Summary: | Provide a locale setting with decimal point and ISO date format | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Robert Pollak <robert.pollak> |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | CLOSED DUPLICATE | ||
Severity: | normal | CC: | erack, himajin100000 |
Priority: | medium | ||
Version: | 6.0.7.3 release | ||
Hardware: | All | ||
OS: | Linux (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=131297 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
Robert Pollak
2019-09-16 09:16:29 UTC
Could you give a try to a recent LO version? (see https://launchpad.net/~libreoffice/+archive/ubuntu/ppa) I have now used this PPA to update to LO 6.3.1.2. I still see the problem there: I get wrongly formatted dates (MM/dd/yy), so LANG=en_DK.utf8 is ignored. I have tried three ways of launching Calc: via application menu, via double-clicking a spreadsheet file, and via terminal window. What locale do you use in LO? There's perhaps no en_DK but there's a Danish locale. About Calc and Danish, there's da_DK.xml: https://opengrok.libreoffice.org/xref/core/i18npool/source/localedata/data/da_DK.xml?r=5932aa91 "Locale setting" said "Default - {en}". I have now installed the Danish language package libreoffice-l10n-da, then I switched the LO locale setting to "Danish". This showed me that the Danish locale in in both ways not suitable: * It uses a comma as decimal separator. * Its default date format is dd-MM-yy. For the moment, I will stick with my workaround, using {en} and manually redefining the date format to yyyy-MM-dd. Unfortunately, many of the files I am processing are read-only or csv files, so I have to introduce reformatted copies. Is this da_DK.xml a file I could edit to my wishes (e.g. creating my own en_DK.xml), then use in LO? (In reply to Robert Pollak from comment #5) > Is this da_DK.xml a file I could edit to my wishes (e.g. creating my own > en_DK.xml), then use in LO? I don't think so but am not an expert. However, you've got some parameters which may perhaps help in Tools/Options/Language settings/Languages: - Key decimal separator - pattern dates Those are both useless, because they do not define the default format for existing floating point and time data: - The "Decimal separator key" only configures which symbol is generated when you press the decimal separator key on your number pad. - The "Date acceptance patterns" only define how dates can be keyed in. (This is all described in the Help.) Thank you for your feedback. I must recognize I'm stuck, I won't be able to help here, so uncc myself. (In reply to Robert Pollak from comment #5) > Is this da_DK.xml a file I could edit to my wishes (e.g. creating my own > en_DK.xml), then use in LO? You can propose it if there is no any. cc Eike Rathke as he has helped me in https://bugs.documentfoundation.org/show_bug.cgi?id=131297 Effectively this is a duplicate, free-form default formats. *** This bug has been marked as a duplicate of bug 46448 *** Fwiw, there's an en_DK locale for 7.2, see https://wiki.documentfoundation.org/ReleaseNotes/7.2#New_languages.2Flocales_with_locale_data However, it uses the ',' comma decimal separator because that is how the locale is defined; see https://lh.2xlibre.net/locale/en_DK/ and command line LC_ALL=en_DK.UTF-8 locale -ck LC_NUMERIC |