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 Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1345546

Title:
  dates in cell change randomly on load

Status in LibreOffice Productivity Suite:
  Unknown
Status in “libreoffice” package in Ubuntu:
  New

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: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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to     : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp

Reply via email to