The previous suggestions should work for input from a file into a new
spreadsheet, but if you have an existing spreadsheet, you may have date and
time in either date and time or text format. Anyone working with date and
time, date, time, or number formats may have this problem.
It will not matter if your date and time entries are static, but sorting the
entries by date is usually why a spreadsheet is used. I suggest using the
ISO8601 format [Fri 1999-12-31 23:59:59 (NN YYYY-MM-DD HH:MM:SS)] as that
will sort properly as text if the entries are all from the same time zone.
My problem was because I tried to solve the problem within the spreadsheet
and there is no known way to do that. My solution is to take the entire
column of data out of the spreadsheet, enter it into a simple word processor
(gedit for example) to remove all formatting and copy it back into the
spreadsheet. I make sure the column is correctly formatted before pasting
the data. Unfortunately, a direct copy and paste special does not work as
there is no unformatted option, just check boxes to include or exclude data
formats. Copy a text encoded date and paste special will paste the data only
if text is checked.
I hope my description of what works for me is clear enough for you to use
the same (or similar) procedure.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
For unsubscribe instructions 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