At 16:41 04/06/2013 -0700, Spencer Graves wrote:
When I copy a date from one LO spreadsheet to another, it changes.
Much as you might be surprised by this, it is, I think, by design.
Specifically, I have *.ods files DateProblem2add.ods and
DateProblemMerge.ods. The first contains only 2013-05-30 in cell
A1. The second contains only 2012-12-9 in cell A1. I copy the
first date into cell A3 of the second file, where it appears
2009-05-29 -- four years and one day before the date I thought I was
copying -- which is what I see in that cell in the attached
DateProblemMerge.ods. This is using LO 22.214.171.124 under Windows 7.
Dates and times in a spreadsheet are stored internally as days and
fractions of a day from a selected origin. Displayed values such as
your "2013-05-30" are merely the result of cell formatting. If you
go to Tools | Options... | LibreOffice Calc | Calculate | Date, you
will see that there are three date origins to choose from. If you
copy dates between spreadsheets, the underlying numbers are
copied. If the date origins are different for your two spreadsheets,
the copied values will be interpreted and displayed as different dates.
You will notice that two of the date origin choices are four years
and two days apart. Er, that's indeed four years and one day if you
allow for Microsoft Excel's false belief that 1900 was a leap year.
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy