Libre Office Calc changes the date, seems to take it forward about four years. This has started suddenly in long established and often used spreadsheets. Initially I thought I had a faulty spreadsheet, but now it is happening in more than one. Seems to have started with the latest upgrade, but of that I'm not absolutely sure. Running on a 64 bit Windows 8 machine with 16gb RAM, and ample disc space. I have the date configuration set as either DD MMM YY, or DD MMM YYYY, have done with no problems for years. Once I have opened the file, and found the date changed, the date stays changed. Any ideas what is happening?
Hi Maurie, maybe was changed the option in: Menu/Tools/Options/LibreOffice calc/Calculate - Date
Hi Mario, I had a look at what you proposed, but after the "Menu/Tools/Options/LibreOffice", I run into a wall, as I can't see any option for the last few steps, "calc/Calculate - Date".
Created attachment 92786 [details] Screenshot with the option. Hi Maurie, I forgot answer. Please take a look to the attached screenshot.
Hi Mario, I think you've nailed it. I had a look as you suggested, and it was set to the bottom date of the list. Don't know how that happened, but that doesn't really matter. The important thing is that since I set it back to the top option, all my dates in Calc are behaving themselves. I've been watching it for a few days now, in a couple of different spreadsheets, and all seems to be going well. Thanks very much for your help. I guess that I now need to mark this item as solved. Any idea how I do this? (This is my first venture into Bugzilla, or anything like it for that matter) Cheers Maurie
Thanks for inform Maurie, Don't worry, changed to RESOLVED NOTABUG.