Hi :) That looks like the winner to me. Ignore my post Regards from Tom :)
>________________________________ > From: Steve Edmonds <[email protected]> >To: Oogie McGuire <[email protected]> >Cc: [email protected] >Sent: Sunday, 12 May 2013, 22:09 >Subject: Re: [libreoffice-users] Re: Paste of Dates Incorrect in Calc > > >Hi. Take a look at >https://help.libreoffice.org/3.6/Calc/Date_and_Time_Functions >To me the difference you are getting looks close to the difference >between the date bases for day zero. >Steve > >On 2013-05-13 08:45, Oogie McGuire wrote: >> OK following up on the suggestions. >> >> First the user profile page linked to doesn't exist so I can't try that. >> >> I upgraded my system to the latest LibreOffice in case that was a problem am >> running 3.6.6.2 (Build ID: f969faf) >> >> All data was originally created on the same machine in the US locale not >> changed. >> >> I have tried all subsets of paste special I can think of. >> >> I tried setting the format of the cells to number general. Copied those, >> pasted into a new spreadsheet, The numbers did not change at all. But when I >> then set the format to date the dates are not the same and are incorrect. >> >> Tried the copy within the sheet where the dates are correct and it works >> properly >> >> Tried a select of the dates where they are correct. get a brand new blank >> spreadsheet, paste the dates. They are incorrect >> >> Tried copy of the dates after they have been changed to format as numbers >> create a brand new spreadsheet paste verify the numbers are the same change >> the format to date and then the dates are incorrect. >> >> I'd be glad to send the info to anyone else to se if they can figure it out. >> Not sure how or where to upload a file though >> On May 12, 2013, at 2:13 PM, Nino Novak wrote: >> >>> Am 12.05.2013 21:00, schrieb Oogie McGuire: >>> >>>> In the first spreadsheet I select the cells containing the dates I >>>> want. copy (command c) move to the spreadsheet where I want to paste >>>> them select the cells where they are to be pasted paste (command v) >>>> and the data is entered as a date but they have all changed what was >>>> 05/08/2005 in one sheep has become 05/09/2001 in the second sheet! >>> >>> without knowing the reasons of your problem, and in addition what Brian >>> wrote, you could try the following: >>> >>> As dates are represented internally by (integer) numbers, please select >>> the cells containing the dates before you copy them, and set the cell >>> format to "standard". Then all dates should turn into numbers. >>> >>> What happens if you copy&paste those numbers to your new spreadsheet? >>> >>> Do the numbers change? >>> >>> If not, you can then select the target cells and format them as date - >>> and see if they are correct now. >>> >>> Nino >>> >>> -- >>> 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 >>> >>> >> Eugenie (Oogie) McGuire >> Desert Weyr http://www.desertweyr.com/ >> Paonia, CO USA >> >> > > >-- >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
