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: [email protected]
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
