https://bugs.documentfoundation.org/show_bug.cgi?id=138652
[email protected] changed:
What |Removed |Added
----------------------------------------------------------------------------
Ever confirmed|0 |1
Status|UNCONFIRMED |NEEDINFO
--- Comment #8 from [email protected] ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
