Description: Calc/Excel Sort Incompatibility I have spreadsheet I use in my spreadsheet class that demonstrates the sort functions of Excel and Calc. To save the original content before the sort, I copy rows 2 through 6, cells A & B to D2. I then select cells D2 through D6 and click on the Sort AZ icon. I get the warning about adjacent information like Excel and hit enter. The problem is Calc includes Row 1 cells D1 & E1 in the sort that causes the Title to be included in the sort. Excel does not do that. It seems the different formatting between Rows 1 & 2 does not matter The real problem is that this failure is inconsistent. Some list work and some fail. Lists starting in D2 and E10 fail but A2, G2, J2 H10, A17 and D17 function correctly. Mind blowing! Problem is reproduceable. Steps to Reproduce: 1.Create list with Titles in Row 1 Cells A & B & D 2.Create list in Rows 2-6 Cols A & B 3.Copy R2-6 A & B to D2 4.Sort D2-D6 5.Yes to Expand sort 6.Problem = Title in D1 included in sort even though not selected. 7.Copies at other locations may or not fail. Have sample to share Actual Results: 6. Problem = Title in D1 included in sort even though not selected. Expected Results: Excel does not include title. Only sorts selected cells. Some locations in CALC work correctly. Have CALC file to share via email. Reproducible: Sometimes User Profile Reset: No Additional Info: Should not included Title cells. Fails on my other computers.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 170340 [details] CALC sample of failure Actual spreadsheet that fails
Actual failing sample supplied
Created attachment 170341 [details] Replace original file with this actual failing file with CALC sort bug Sent wrong file first. It is my teaching sample.
Hello Ron, I can confirm this bug is present in my version, I would like to add, however, your issue could be solved by selecting what needs to be sorted and sort it with 'current selection' instead of 'extend selection' As far as I can tell this seems to be an issue with how the titles are assigned to columns. Present in Version: 7.2.2.2 / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 12; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Calc: threaded