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: firstname.lastname@example.org
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
- [libreoffice-users] Paste of Dates Incorrect in Calc · Oogie McGuire
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy