Bug 158819 - Sorting by 2 columns doesn't sort properly
Summary: Sorting by 2 columns doesn't sort properly
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-22 04:02 UTC by Daniel DeLorme
Modified: 2023-12-22 04:12 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
ods spreadsheet with sorting bug (38.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-12-22 04:02 UTC, Daniel DeLorme 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Daniel DeLorme 2023-12-22 04:02:11 UTC 
Created attachment 191556 [details]
ods spreadsheet with sorting bug

See attached spreadsheet.

Steps to reproduce:
1. Select the data (A2:P33)
2. Data > Sort...
3. sort key 1: column A
4. sort key 2: column B
5. click "ok"

Result:
The data is not sorted in the expected order.
Every time I repeat the steps above, I get a different (apparently random) order in column B.
Comment 1 Daniel DeLorme 2023-12-22 04:12:57 UTC 
Please ignore, I finally noticed that each line of column N had a reference to one line below (N5 has ref to H6), rendering the sort unstable. orz