https://bugs.freedesktop.org/show_bug.cgi?id=67822
--- Comment #13 from Mike Kaganski <[email protected]> --- This has direct relation to regional settings. The original format string ("#,##0.00;[RED]-#,##0.00") should be read like this: "Show at least one decimal digit before decimal separator, and at least two after; show thousand separators; for negatives, show the sign and mark the number red". Here, the comma (",") stands for thousand separator, the dot (".") for decimal separator. But in the format string, these symbols are locale-dependent. This format string is only valid for locales where the comma is used for thousands, and the dot is decimal separator. In other locales, the corresponding characters from the locale must be used instead. For example, here in Russia, we use comma (",") as decimal separator, and space (" ") as thousands separator. In this case, the correct format string looks like this: "# ##0,00;[RED]-# ##0,00". And it works. (See more details here: https://help.libreoffice.org/Common/Number_Format_Codes) If I manually set another locale for a cell (say, English (US)), I can use that locale codes. But if I use wrong codes (like when I use original reporter's code for Russian locale cell), the bug appears. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
