Date copied to new sheet appears as 2 days earlier [closed]
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?
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.
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?
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).
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.