Bug 113291 - Calc custom date format sort doesn't work (single quote dates)
Summary: Calc custom date format sort doesn't work (single quote dates)
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-20 13:25 UTC by Yan Pas
Modified: 2017-11-07 15:42 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
example file (11.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-10-20 13:26 UTC, Yan Pas 		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 Yan Pas 2017-10-20 13:25:04 UTC 
Description:
There are documents with the following date format "'DD.MM.YYYY". Libreoffice doesn't display signle quote and it doesn't sort correctly even if I set custom format manually.

Steps to Reproduce:
-

Actual Results:  
https://superuser.com/questions/394092/how-to-remove-a-plain-text-protecting-single-quote-from-all-the-selected-cells-i

Expected Results:
-


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.62 Safari/537.36
Comment 1 Yan Pas 2017-10-20 13:26:47 UTC 
Created attachment 137144 [details]
example file
Comment 2 Eike Rathke 2017-11-07 15:42:27 UTC 
All cells have text content, not numeric date serial content, thus are not dates.
Therefore you can change the (date) number format to anything but it is never reflected in the cell display. Sorting such cell content sorts it alphanumerically instead of date. Not a bug.