Created attachment 42818 [details] Spreadsheet with date values changing between sessions When I create a spreadsheet containign cells formatted as a date with the full month name and a four-digit year (MMMM JJJJ in my locale; it would be MMMM YYYY in english locales), the date changes between sessions. This spreadsheet file contains 12 sheets, one for each month of the year. I started filling them with January to December 2011, upon opening the file, the dates had changed to December 2006-November 2007. I would expect the date values to stay the values I entered. This is reproducible on my system, spreadsheet file attached. What surprises me: The dates went down 4 years and 1 month (49 months) in each sheet, resulting in a basically correct order of dates - just having the wrong values...
Created attachment 42819 [details] Date values not changing between sessions There is a workaround to this issue, though: Prepending the date values with a single quote (maybe double quote works as well?) keeps the date values from being changed between sessions. Still, I would not expect this behavior.
Hi Niklas, I cannot reproduce this. I download your date_changes.ods, change locale of the style default to German Select D2 on Januar, choose default formatting Choose formatting, set to date / MMMM YYYY Now shows Januar 2011 again, but right aligned Close and open spreadsheet > date still OK So ??? Cor
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian