https://bugs.documentfoundation.org/show_bug.cgi?id=148847
--- Comment #3 from Mike Kaganski <mikekagan...@hotmail.com> --- Wrt number format codes: you simply cannot create code (in Basic) or formulas (in Calc) that would use format codes, and would work wherever they are opened. The specific codes, separators, everything there is locale-dependent - and thus, a format string created for one locale would create something absolutely wrong in another locale. Have 's = Format(x, "0,000.00")' number format for thousand separators and two decimals after decimal dot, which would work for en-US - and it will fail in locales where comma is decimal separator. Have '=TEXT(A1;"JJJJ-MM-TT")' for German locale to show ISO date format - and it will fail in France (using J for days, not using T) or in USA (not using J or T). The things here are not *words*, they are *codes*. The origin of the code is irrelevant: you do not use "YEAR", you use some character, like "Y". It's bad to have codes "translated", just to create impression of localization here - and make it all unportable, unusable. Anyone using a localization then would be unable to use an acceptance pattern they find anywhere - if it was provided for a different locale. Translation should be done only for words, not for codes. -- You are receiving this mail because: You are the assignee for the bug.
