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

Reply via email to