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

Formatting is the correct word as I wish to be able to format the date and
time, date, time, number, and currency into the required format.

Your assertion that the correct number must be correctly entered into each
cell is absolutely correct. My problem was that the number was not being
entered correctly because of the format in which the number was being
presented to the spreadsheet. There is a wide variety of formats. For
example, a specified date.

In my personal experience, '10.11.2012' has been demonstrated to be two
different dates (Fri 2012-10-11 OR Mon 2012-11-10). Everyone is accustomed
to using their own format and, in some cases, their own calendar:
{12 Bak'tun 19 K'atun 19 Tun 15 Winal 17 K'in 13 Kaban 0 Keh G2} is Sat
2012-11-10.
09,27,4710 is Sat 2012-11-10.
25 Che 5773 is Fri 2012-11-09 from local sunset to midnight and Sat
2012-11-10 from midnight to local sunset. Longitude is required to resolve
local sunset.
2012-315 is 2012-11-10.
2012-45 includes 2012-11-10.

This is why I prefer using ISO8601 as the International Standards
Organization's format is least likely to be misinterpreted. For other
formats, I prefer to use the name of the month abbreviated to three
characters, especially if there is any chance of the month being confused
with the day (day <13).

Unless punch cards are still being used, there is no excuse for a two digit
year.

Meine Übersetzungen sind nicht sehr gut, so dass ich selten nutzen Deutsch.
Zu zahlreichen Anlässen habe ich gebeten worden zu benutzen nur Englisch.



--
View this message in context: 
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006266.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