Bug 108006

Summary:	Change of date
Product:	LibreOffice	Reporter:	Guenter Wey <guewey>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	lo_bugs, miguelangelrv, xiscofauli
Priority:	medium
Version:	5.2.6.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	2 spreadsheets

Description Guenter Wey 2017-05-22 17:55:52 UTC

Description:
LibreOffice, now two days ahead of time
---------------------------------------

Attached are two LibreOffice spreadsheets named "Fido call history 2017.ods" and "Temporary copy.ods", from now on referred to as "file F" anf "file T". They deal with my habit of keeping track of my cellphone calls with Fido, my cellphone service provider. Creation of file F was started on 04 March 2017 and updated on 21 May 2017. File T was "created" on 21 May 2017 by just copying the latest call data (not yet listed in file F) from my Fido account website. After doing this, I copied the contents of file T to file F. Please, open both files and take a close look at the date - i.e. the left-most - column: Do you notice that for each call, the date in file F is two days ahead from the equivalent date in file T?

I have the strong suspicion that there is a problem with your latest spreadsheet update. I am not sure if the following observation is of any help in solving the problem: When I right-click any of the dates in either of the two files, then select "Format/Cells.../Numbers", "Date" is shown as "Category" and "Default - English (USA)" as "Language". However, in file T, "01/02/00 01:37PM" is shown as "Format" while in file F, "12/31/99 01:37PM" is the "Format".

I would greatly appreciate an explanation, and even more, a solution to the above-described problem,

Guenter Wey, a user of LibreOffice since the days of Staroffice

Steps to Reproduce:
1. See 2 attachments
2.
3.

Actual Results:
Dates are changed by 2 days.

Expected Results:
That dates are not changed.

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0

Comment 1 Guenter Wey 2017-05-22 17:59:34 UTC

Created attachment 133457 [details]
2 spreadsheets

Comment 2 Guenter Wey 2017-05-22 21:37:18 UTC

Comment on attachment 133457 [details]
2 spreadsheets

Temporary copy:
---------------
05/18/17 12:38 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
05/18/17 11:10 AM	$0.40	416 783-4433 	Outgoing call 	        Local call 
05/16/17 04:55 PM	$0.00	416 820-2246 	Incoming SMS 	        -- 
05/13/17 12:25 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
04/30/17 03:55 PM	$1.20	416 820-2246 	Incoming call 	        Local call 
04/30/17 03:45 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/28/17 06:39 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/26/17 02:51 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/26/17 02:51 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/25/17 03:29 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/24/17 12:03 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/18/17 01:18 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
04/13/17 07:23 PM	$0.00	416 820-2246 	Voicemail received 	Local call 

Fido call history 2017:
-----------------------
05/16/17 12:38 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
05/16/17 11:10 AM	$0.40	416 783-4433 	Outgoing call 	        Local call 
05/14/17 04:55 PM	$0.00	416 820-2246 	Incoming SMS 	        -- 
05/11/17 12:25 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
04/28/17 03:55 PM	$1.20	416 820-2246 	Incoming call 	        Local call 
04/28/17 03:45 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/26/17 06:39 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/24/17 02:51 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/24/17 02:51 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/23/17 03:29 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/22/17 12:03 PM	$0.00	416 820-2246 	Voicemail received 	Local call 
04/16/17 01:18 PM	$0.40	416 431-6396 	Outgoing call 	        Local call 
04/11/17 07:23 PM	$0.00	416 820-2246 	Voicemail received 	Local call

Comment 3 m_a_riosv 2017-05-22 23:32:26 UTC

There is only one spreadsheet attached, please add the second one.

Comment 4 Guenter Wey 2017-05-25 00:09:45 UTC

 To Comment # 3 on bug 108006 from m.a.riosv:

There is only one spreadsheet attached, please add the second one.



My response, which I tried before to send to you, but apparently in vain:
The "only one spreadsheet" you are referring to is actually a copy of both spreadsheets, with their titles on top of each. I was prevented from attaching the actual spreadsheets because Firefox allegedly was not capable of doing this.

Comment 5 m_a_riosv 2017-05-25 01:22:20 UTC

I don't know what you have tried before, but send private emails should be used only to send some private data/file for test purpose or something similar. BTW remember that we are volunteers.

I think you are talking about two files with different behavior, or a file with two sheets. I don't know, but there is only one spreadsheet with one sheet.

In any case the issue with your file seems that in some way the option Menu/Tools/Options/LibreOffice Calc/Calculate/Date, has been changed to 12/30/1899 from 01/01/1900, selecting the second one shows correct values, right?