Bug 73861

Summary:	Calc changes the date, take it forward about four years
Product:	LibreOffice	Reporter:	Maurie May <MaurieMay>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG	QA Contact:
Severity:	major
Priority:	medium	CC:	mariosv
Version:	4.0.6.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:
i915 platform:		i915 features:
Attachments:	Screenshot with the option.

Description Maurie May 2014-01-21 05:14:38 UTC

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?

Comment 1 m.a.riosv 2014-01-21 09:25:06 UTC

Hi Maurie, 
maybe was changed the option in:
Menu/Tools/Options/LibreOffice calc/Calculate - Date

Comment 2 Maurie May 2014-01-23 07:46:12 UTC

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

Comment 3 m.a.riosv 2014-01-25 21:45:50 UTC

Created attachment 92786 [details]
Screenshot with the option.

Hi Maurie, I forgot answer.
Please take a look to the attached screenshot.

Comment 4 Maurie May 2014-01-29 00:04:34 UTC

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

Comment 5 m.a.riosv 2014-01-29 00:32:26 UTC

Thanks for inform Maurie,

Don't worry, changed to RESOLVED NOTABUG.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.