[Libreoffice-bugs] [Bug 88769] Improper SORTING on the date field for certain date formats

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=88769

--- Comment #6 from Bruno <b.inhelder at bluewin.ch> ---
(In reply to krafczyk.matthew from comment #4)
> This bug is still present on branch 5.4.0.0.alpha0+ on linux.
> 
> To reproduce, open a new Libreoffice Calc doc and enter the following table:
> 
>      A        |       B
> ------------------------------
> 2017 31 Jan   |       A
> 2017 10 Feb   |       B
> 2017 20 Mar   |       C
> 2017 01 Apr   |       D
> 
> Select the 4 cells of column A, and navigate to the 'Format' menu and select
> 'Cells...'.
> 
> Then set the format to Date and enter the format 'YYYY D MMM' pressing the
> check mark to add the format and set the format of those cells.
> 
> Now select all the 8 cells between column A and B and select 'Data' and then
> 'Sort...'. Then set 'Sort Key 1' to 'Column A' and select either Ascending
> or Descending.
> 
> You will find that the cells are sorted as if they were strings rather than
> dates.

Same on V5.4 Win with Date format dd.mm.yyyy. Doesn't sort like a date but just
alphabetically.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170808/633f7d62/attachment.html>