Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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 l10n+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/l10n/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.