Re: [libreoffice-users] Re: Paste of Dates Incorrect in Calc

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: 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

Eugenie (Oogie) McGuire 
Desert Weyr http://www.desertweyr.com/  
Paonia, CO USA


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