desktop-packages team mailing list archive

[AZ <1345546@xxxxxxxxxxxxxxxxxx>]

1/ How do you change date setting if the file is closed ?

I created (opened) a new file (not saved) and changed it then. The
change shows up in user/registrymodifications.xcu .

2/ where is random ? All changes are made by you, Calc does only what
you asked him to do.

I originally did what I wrote in steps to reproduce. Originally, I first
had a document created on another computer that showed up with wrong
dates. Then I found that even documents created locally showed wrong
dates. After changing the setting mentioned back to defaults, the issue
was gone. But it could be reproduced by the steps mentioned in "steps to
reproduce". So I thought this was an unacceptable issue with
libreoffice.

I'm now facing difficulties to reproduce this even on the machine that
originally exhibited this behaviour (which does not always even have
internet access). So I don't know how to debug this further.

Regardless of the original issue, I find it very strange as a user that
changing that very setting changes the static! document content. I think
this is not easy to see as a user (when going through menu) and does not
only affect calculations as one could expect from menu structure.

3/ the origin date is saved in the content.xml if it is not the standard
origin date (1899.12.30). Open such a content.xml and search for "null-
date".

thanks for pointing that out.

4/ when reading a file Calc converts dates to numbers (decimal) of days
from the null-date. It converts back to dates when formatting and
saving.

I think it would improve user experience when changing that setting
would not alter static (non-calculated) content.

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have
provided requested informations. Thank you for your understanding.

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