https://bugs.documentfoundation.org/show_bug.cgi?id=154155
--- Comment #2 from Eike Rathke <[email protected]> --- I don't see that Excel would support some [$-bcp47] modifier. So if at all then another modifier should be used that could be omitted from the format code, like [bcp47:...] or [lt:...] Anyhow, the correct way to have "[NatNum12]0" for Marathi is to select Marathi from the language list and enter "[NatNum12]0" as format code. Doing so the user doesn't have to know neither LCID nor the language tag. (and an input of "[NatNum12][$-44e]0" is converted to anyway). For the TEXT() function, the literal format code from an interoperability and i18n pov is a complete horror already anyway, this would add just more mess. Furthermore, users might come up with syntactically valid language tags but for which no locale support exists. These could only be rejected. If a valid and supported [lt:...] was given, that would have to be converted to the matching [$-...] LCID anyway to make things work. So, I'm not very convinced.. -- You are receiving this mail because: You are the assignee for the bug.
