https://bugs.documentfoundation.org/show_bug.cgi?id=96475
Bug ID: 96475 Summary: Sorting pasted date fields incorrect Product: LibreOffice Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: dsik...@hotmail.com Created attachment 121289 --> https://bugs.documentfoundation.org/attachment.cgi?id=121289&action=edit Test file demonstrating sorting problem When searching with vlookup date, then copying data without formulas to te new sheet, sorting does not work correctly. Check the attached ODT test file with 3 sheets: "List" containing formulas, which are searching data from the "Inventory" sheet and "Summary" sheet is a result of "copy/paste special" of "List" with only Text, Numbers, Date&Time and Formats included. Now sorting "Summary" sheet by "Contact" seems to be incorrect: - Cells with empty value have changed to show 30.12.1899 - non-existing "host" cells showing correctly #N/A - Cells with existing Date value showing correctly When trying to sort now by "Contact", only the cells with existing Date value seems to be sorted correctly. #N/A and originally empty but now with bogus date value filled cells doesn't seem to be sorting at all. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs