Public bug reported:
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 nor when saving the
file.
ProblemType: Bug
DistroRelease: Ubuntu 14.04
Package: libreoffice-calc 1:4.2.4-0ubuntu2
Uname: Linux 3.15.0-031500rc7-generic x86_64
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)
** Affects: df-libreoffice
Importance: Unknown
Status: Unknown
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug trusty
** Bug watch added: freedesktop.org Bugzilla #81560
https://bugs.freedesktop.org/show_bug.cgi?id=81560
** Also affects: df-libreoffice via
https://bugs.freedesktop.org/show_bug.cgi?id=81560
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1345546
Title:
dates in cell change randomly on load
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
