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.
To unsubscribe e-mail to: email@example.com
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
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