desktop-packages team mailing list archive

[JBF <jbfaure@xxxxxxxxxxxxxxx>]

(In reply to comment #6)
> Created attachment 106048 [details]
> screencast showing the change of the date when changing the setting
> 
> This is on yet another machine, running ubuntu mint 16 with a fresh profile.
> It shows that the displayed date changes too when changing the setting. it
> is libreoffice 4.1

Yes, where is the problem ? the origin date is saved in the file, if you change it, the dates change accordingly because each date is an amount of days from the origin date.
Why do you want to change the origin date for an existing file ?

Closing as NotABug. Please feel free to reopen if you have an argument
against this explanation.

Best regards. JBF

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