https://bugs.documentfoundation.org/show_bug.cgi?id=172481
Bug ID: 172481
Summary: LibreCalc - Error in date sort with format dd-mm-yyyy
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
There is a problem with sorting data with date format dd-mm-yyyy (LibreCalc)
whereby 01-01-2024, 01-01-2026, 02-02-2025, if sorted follows the dd first and
does not prioritize year. A manual workaround is to reverse the format to
yyyy-mm-dd, but this becomes problematic because there is no automatic
conversion of the format from dd-mm-yyyy to yyyy-mm-dd.
Note, date sorting works fine on yyyy-mm-dd (Japan/China standard) format, but
does not work on dd-mm-yyyy (UK standard) or mm-dd-yyyy (US Standard)
Suggested solution is to convert to an epoch timestamp then sort the data then
revert back to the original date format whatever format it may be.
below is the LibreCalc version that I am using:
Version: 26.2.1.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: CL threaded
Steps to Reproduce:
1.enter the following dates for sorting 01-01-2024, 01-01-2026, 02-02-2025
2.sort either Ascending or Descending
3.Check outcome
Actual Results:
The data (dd-mm-yyyy) sorts by dd then mm then yyyy which is wrong and not
compatible with proper data sorting
Expected Results:
already explained above.
Reproducible: Always
User Profile Reset: No
Additional Info:
no other information
--
You are receiving this mail because:
You are the assignee for the bug.
