[libreoffice-users] Re: Date will not format or sort when imported into calc (ods)

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: 
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4005124.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@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