[Upstream] Dates in cell change randomly on load
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Invalid
|
Medium
|
|||
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned |
Bug Description
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:
<text:
</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:
<text:
</table:
The current mode of operation breaks file display and corrupts the original file!
Expected behavior:
The date should not change, neither while displaying nor when saving the file.
ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: libreoffice-calc 1:4.2.4-0ubuntu2
Uname: Linux 3.15.0-
ApportVersion: 2.14.1-0ubuntu3.2
Architecture: amd64
CurrentDesktop: KDE
Date: Sun Jul 20 12:58:26 2014
SourcePackage: libreoffice
UpgradeStatus: Upgraded to trusty on 2014-06-18 (31 days ago)
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → New |
Changed in df-libreoffice: | |
status: | New → Incomplete |
summary: |
- dates in cell change randomly on load + [Upstream] Dates in cell change randomly on load |
Changed in df-libreoffice: | |
status: | Incomplete → New |
Changed in df-libreoffice: | |
status: | New → Invalid |
Changed in libreoffice (Ubuntu): | |
status: | New → Invalid |
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: value-type= "date" office: date-value= "2014-06- 02" calcext: value-type= "date"> p>02.06. 14</text: p>
<table:table-cell office:
<text:
</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: value-type= "date" office: date-value= "2010-06- 01" calcext: value-type= "date"> p>01.06. 10</text: p> table-cell>
<table:table-cell office:
<text:
</table:
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.