Open edhans opened 1 week ago
Hi Ed Thanks for reporting this, we are looking into it
Hi @edhans We have identified the bug and will get it fixed in a future update.
The alphabetical sort happens regardless of the Format of your dates—it is the ascending/descending sort order that triggers it. The issue also exists on integers which are also sorted "Alphabetically".
Here are few pictures confirming the issue:
The short date format is sorted alphabetically:
Long date without explicit sort looks correct:
Explicit sort on long date:
Integers also sort alphabetically.
Description
We have our Date formatted as Long Date in the date table. The Pivot Grid is sorting it alphabetically.![image](https://github.com/TabularEditor/TabularEditor3/assets/45298358/705b2c51-c23d-4306-af6e-b72be1d47e4a)
You can see that May is coming after July here.
Once we change it back to a normal date format without words in it, like dd/mm/yyyy, it sorts properly.
This might be related to some degree to #1318 in the sorting code.
Tabular Editor 3 Version
3.16.2
Screenshots
No response
Steps to Reproduce
No response
Expected behavior
I would expect it to sort in the underlying date order regardless of the date format, even if it is a date format with words in the display.
Crash Report
No response
Windows Version
11