Ask Your Question

Date copied to new sheet appears as 2 days earlier [closed]

asked 2013-07-25 06:32:49 +0200

Ricky Wee gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-04 04:31:18.374722


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.

Ljiljan gravatar imageLjiljan ( 2013-07-25 06:55:14 +0200 )edit

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?

Ricky Wee gravatar imageRicky Wee ( 2013-07-25 07:14:38 +0200 )edit

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

Ljiljan gravatar imageLjiljan ( 2013-07-25 08:07:51 +0200 )edit

The file is found here: It's a puzzling problem as it is the first time I've encountered it.

Ricky Wee gravatar imageRicky Wee ( 2013-07-25 08:22:19 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-07-25 09:06:23 +0200

oweng gravatar image

updated 2013-07-25 09:07:38 +0200

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.

edit flag offensive delete link more



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

Ricky Wee gravatar imageRicky Wee ( 2013-07-25 10:53:20 +0200 )edit

Question Tools

1 follower


Asked: 2013-07-25 06:32:49 +0200

Seen: 92 times

Last updated: Jul 25 '13