https://bugs.freedesktop.org/show_bug.cgi?id=81560
Priority: medium
Bug ID: 81560
Assignee: [email protected]
Summary: DATALOSS: date in calc cells change randomly
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
Steps to reproduce:
0. This is on Ubuntu x86_64 in german local, I did not test others.
1. Set Settings -> Libreoffice Calc -> "Berechnen" (Calculation?) -> Date =
1.1.1904
2. Create new spreadsheet
3. Enter 2.6.2014 in the cell (here: german date format, maybe 2014-06-02 in
English)
4. Save file
5. Close file
6. Reopen file
7. Display file
8. save the file
Current behavior:
After step 4, 2014-06-02 is saved in content.xml in the ods file:
<table:table-cell office:value-type="date" office:date-value="2014-06-02"
calcext:value-type="date">
<text:p>02.06.14</text:p>
</table:table-cell>
But it step 7, it is display as 1.6.2010 (that is 2010-06-01) .
After saving in step 8, content.xml contains:
<table:table-cell office:value-type="date" office:date-value="2010-06-01"
calcext:value-type="date">
<text:p>01.06.10</text:p>
</table:table-cell>
The current mode of operation breaks file display and corrupts the original
file!
Expected behavior:
The date should not change, neither while displaying or when saving the file.
--
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