Hi :) Is this something to do with the difference between how Excel calculates dates and how Calc does it? There is something weird about the way Excel does it. The question is should we do it the wrong way in order to be compatible with Excel or the right way in order to make sense to the rest of the world. Regards from Tom :)
>________________________________ > From: Spencer Graves <[email protected]> >To: "[email protected]" <[email protected]> >Sent: Wednesday, 5 June 2013, 0:41 >Subject: [libreoffice-users] Date problem in LO Calc 4.0.3.3 > > >Hello, All: > > > When I copy a date from one LO spreadsheet to another, it changes. > > > 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 4.0.3.3 under Windows 7. > > > I have a work around for my particular application. However, >since I haven't filed bug reports on LO before, I thought it best to >report this anomaly to this email list and trust that someone else might >be better positioned to see that this gets properly reported. > > > Thanks, > Spencer > > >-- >To unsubscribe e-mail to: [email protected] >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >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 > > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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
