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

Hi :)  
I don't know if it will help but when weird things happen it sometimes help to try renaming your 
User Profile
https://wiki.documentfoundation.org/Documentation/UserProfile
to "get back to factory defaults".  If some Extension or strange combination of settings is doing 
something strange then that fixes it.  

By renaming it you do keep all your old settings and can put them back afterwards or use them to 
trouble-shoot so you can pin down the problem.  

Btw when you paste into the newer 'worksheep' that should paste in your formatting too so you 
shouldn't need to format prior to pasting.  If you wanted to paste without formatting use 
Shift v
and choose unformatted text

I have no idea why things have gone so strangely tho! Hopefully someone else might
Good luck and regards from 
Tom :)  






> ________________________________
> From: Oogie McGuire <oogiem@desertweyr.com>
> To: users@global.libreoffice.org 
> Sent: Sunday, 12 May 2013, 20:00
> Subject: [libreoffice-users] Paste of Dates Incorrect in Calc
>
>
> I'm having a baffling problem. I have several different spreadsheets set up in LibreOffice under 
> Mac OS X 10.6.8
>
> On one of them one of the columns is set to be a date in format MM/DD/YYYY
>
> I want to copy the data from that column into another column in another spreadsheet document. 
> I have selected that column and set the format of the cells to be the same date format MM/DD/YYYY
>
> 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!
>
> This happens no matter what combinations of pasting a single cell or group of cells or any paste 
> special options I have tried.
> I have verified that in the paste I am not doing any operations on the data.
>
> If I select a single cell in the first spreadsheet. highlight the actual text entry in the upper 
> toolbar, copy that text, then paste that it works as expected and the date is correct. I cannot go 
> in and by hand copy each individual cell that way because there are hundreds of these to do.
>
> Why is the paste changing my data and how do I fix it?
>
> 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
-- 
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