[Libreoffice-bugs] [Bug 138652] Sorting in Calc by Date

[bugzilla-daemon at bugs.documentfoundation.org]

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

srdosm at email.cz changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEEDINFO

--- Comment #8 from srdosm at email.cz ---
(In reply to saltyla1 from comment #7)
> I have found that in the Format Cells dialog window,
> Numbers tab, Category "date" > Format , the first 12/31/99 , which
> has a format code of M/D/YY is not a match for 12/31/99. It should be
> single digit/single digit/double digit , as M/D/YY suggests(I.E. 9/2/99)
> 
> I have changed all of the input dates to match MM/DD/YY and it works
> for both selections of 12/31/99 .
> 
> The second instance of 12/31/99 with format code MM/DD/YY is correct.


Hello Saltyla,

you have not the cells in date format. That why the sorting is so. Look to TOOL
- OPTIONS - LANGUAGE SETTINGS - LANGUAGE And there is "Date accaptance
patterns".  It is format, how you can insert dates. Also select a cell with a
date in your document and press F2. There is sign << ' >> in front of the date.
It tells to libreoffice "dont format this".

Please check it and tell us, if it works ok.

-- 
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/20201207/441cb751/attachment.htm>