Re: [libreoffice-users] Date problem in LO Calc 4.0.3.3

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 <spencer.graves@prodsyse.com>
> To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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