Date copied to new sheet appears as 2 days earlier

[RickyWee]

This problem is unique to a calc spreadsheet from one of our users.

When the date field is copied to another new sheet, the date appears as 2 days earlier!
e.g. 1/1/2013 when copied to a new sheet, appears as 30/12/2012

What I observe is:

• The problem only occurs with this spreadsheet in question.
• The date is correct if it is copied within the same spreadsheet.
• When the spreadsheet is saved in xlsx format, the date appears as 2 days earlier after I reopen it.

What is the cause of this inconsistency?

[Ljiljan]

I tried to reproduce your error, but everything works fine; ie. when date is copied to new sheet it does not appear as 2 days earlier. I saved it in XLSX and still - the date is the same.

[RickyWee]

This problem is unique to the particular spreadsheet. I don’t encounter this problem with other spreadsheets. How do I attach the spreadsheet in this post?

[Ljiljan]

Can you upload it to UbuntuOne or Dropbox, or some other file-sharing sites? What I know - you cannot upload file in the comments of this site… you should try to edit your original message and in toolbar you will find Insert Attachment (this could be disabled because your karma is still at low level).

[RickyWee]

The file is found here: https://dl.dropboxusercontent.com/u/1124967/date%2B2error.ods
It’s a puzzling problem as it is the first time I’ve encountered it.

[oweng]

The year zero date for that file is set to use the StarCalc 1.0 value of 01/01/1900, rather than the LO default value of 12/30/1899. Refer Tools > Options… > LibreOffice Calc > Calculate > Date section. This is where your two days difference comes from. It is a less-common cross-platform issue. Unless there is a specific reason to use the old StarCalc value (and there may be) it is best to use the LO default value.

[RickyWee]

Thanks a bunch. I don’t know how the …Calculate>Date value was changed but It was the exact solution I was looking for