Created attachment 958348 [details] Data file before sorting columns. Description of problem: Given a spreadsheet with some columns of numbers, with average of each column calculated below, and a column at left with the average of each row: sorting the columns on their averages yields incorrect result and disconnects column averages from their columns. Version-Release number of selected component (if applicable): libreoffice-calc-4.2.7.2-6.fc20.x86_64 How reproducible: always Steps to Reproduce: 1. Create spreadsheet with a series of columns of numbers. (Attached example uses columns C thru S, rows 4 through 17.) In row below last data row, put formulas calculating averages of the columns. (In example, this is row 19.) 2. Select the columns of data (entire columns) to be sorted. (In example, columns C thru S.) 3. Click Data - Sort... In Options select Direction Left to Right (sort columns). All other options can be unchecked. In Sort Criteria select the row containing the column averages. (In example, row 19.) Ascending or Descending does not matter. Click OK. Actual results: Columns are not sorted in order of average value. Cells containing averages have averages of different columns than the columns they are in. (In the example after sort, for instance, below the data in column G the average is for column M.) Expected results: Columns should be rearranged so that row containing averages has them in sorted order, and each average should be the average of the numbers in the column it is in. Additional info: I haven't tested it on sorting rows to see if the same thing happens. If the row averages are removed
Created attachment 958349 [details] Example data file after sorting
This appears to be one of the cases tracked in https://bugs.freedesktop.org/show_bug.cgi?id=85490 meta bug regarding broken sort behavior.
libreoffice-4.2.7.2-10.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/libreoffice-4.2.7.2-10.fc20
libreoffice-4.2.7.2-11.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/libreoffice-4.2.7.2-11.fc20
libreoffice-4.2.7.2-11.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report.
Thank you, sort is working correctly now. I agree fully with comment 8 at https://bugs.freedesktop.org/show_bug.cgi?id=85490