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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
