desktop-packages team mailing list archive

[AZ <1345546@xxxxxxxxxxxxxxxxxx>]

Further, I would expect that change to only affect ambiguous dates (in
file formats that do not use four digit years, for example) - because
what is the point in changing a date based on a program setting? Or
maybe when actually doing some calculation, because this setting is in
the "calculate" section.

Further, one can only change this setting with a calc file open
(otherwise the menu is missing) - so it will always affect a file.

-- 
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:
  [Upstream] Dates in cell change randomly on load

Status in LibreOffice Productivity Suite:
  New
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