Hi again
When looking closer at the date- and time-formats for sv_SE I find a lot
of duplicates of YYYY-MM-DD
and YY-MM-DD. There are a few lets say questionable formats there as
well. When it comes to time-
formats. I really hope we at least can have HH.MM and MM.SS
Is it possible not to turn inputs on format MM.DD into dates in Calc. It
is much more likely that it is
supposed to be a time value HH.MM? MM-DD is good to have accepted
though. Not really sure
if it's possible.
I will have a closer look at the current formats and discuss them
locally. But that might take some
time so. I appended a few formats to the sv_SE.xml do you want a patch,
or how should i proceed?
Thanks,
Niklas Johansson
Niklas Johansson skrev 2012-01-18 18:08:
Hi Eike
[... time separator ...]
Is it possible to accept both . and : as separators?
No, only one is possible.
OK, good to know.
EU-standard (not seen that often but since were in the EU and all EU
documents ,
use this format it would be a good thing to support):
D.M
D.M.YYYY
Which standard would that be? I only know of EN 28601 that followed
ISO 8601.
Sorry, bad choice of words. The source of information that I used are
the recommendations
that Språkrådet (the Swedish language council) gives. In their book
"Svenska skrivregler"
they state that the format D.M.YYYY is used in all EU-documents
regardless of language.
After some searching on the net I found publications I found this link:
http://publications.europa.eu/code/en/en-4100500en.htm
And a few more (Swedish and English) that said something similar to
"Dates in the text should always be given in their full form (6 June
1992), whereas in footnotes they should always be abbreviated, i.e.
6.6.1992, not 6.6.92"
You can define as many date formats (to display dates) you want by just
adding them to the locale data file starting with formatindex="50", too
many formats in the dialog may just confuse users though..
Thank you, I'll have a closer look. Did a quick test build and was
able to add D/M YYYY.
I'll discuss things further on the Swedish list and get back to you as
soon as possible.
For date acceptance patterns, as long as the DMY order stays the same
within one locale also multiple separators can be used, ISO 8601 and its
YMD order is always supported internally, no need to define anything for
that.
OK, in other words D/M might be a problem for us since the most common
format is YYYY-MM-DD.
I don't think it really matters that much, the most important
(commonly used) formats
are already supported.
--
Thanks,
/Niklas
--
Unsubscribe instructions: E-mail to [email protected]
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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted