1/ How do you change date setting if the file is closed ? 2/ where is random ? All changes are made by you, Calc does only what you asked him to do.
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". 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. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. 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 -- 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
