https://bugs.documentfoundation.org/show_bug.cgi?id=96476
Bug ID: 96476
Summary: Copy/paste special changing emptu date fields to date
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121290
--> https://bugs.documentfoundation.org/attachment.cgi?id=121290&action=edit
Test file demonstrating copy /paste special problem
Running LibreOffice 5.0.3.2 on Linux and LibreOffice 5.0.4.1 on 64-bit Windows
7.
When searching with vlookup date, then copying data without formulas to the new
sheet, empty cells gets converted to 30.12.1899. 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.
- 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
--
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
