Bug 141169 - Calc ordering is incorrect on a specific public XLS file
Summary: Calc ordering is incorrect on a specific public XLS file
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-03-22 10:44 UTC by Satoshi Nakamoto
Modified: 2021-03-22 14:58 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
sample file (47.50 KB, application/vnd.ms-excel)
2021-03-22 14:51 UTC, Xisco Faulí 		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 Satoshi Nakamoto 2021-03-22 10:44:02 UTC 
Description:
If

Steps to Reproduce:
1. Download xls file from URL: https://nav.gov.hu/nav/adatbazisok/adoslista/hiany_hatralek_1201188187115/jelentos_adohianyosok.html
2. Open file with Calc and Order by Column D.
3. Row number 2 and 3 is an against the ordering invariant.

Actual Results:
Row number 2 and 3 is an against the ordering invariant.

Expected Results:
Row number 2 and 3 should be in accordance of the ordering invariant.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
GNU/sort
Comment 1 Xisco Faulí 2021-03-22 14:51:20 UTC 
Created attachment 170631 [details]
sample file
Comment 2 Xisco Faulí 2021-03-22 14:58:36 UTC 
That is the expected behaviour because they contain a space at the beginning of the string. Same behaviour in Microsoft Excel 2010. Remove the empty space and sort again.
Closing as RESOLVED NOTABUG