When changing the number separator in one of the below mentioned dialogs manually, then the separator will only be applied as thousands separator (as the name already indicates). Higher numbers (million and more) e.g. 1 000 000 will be displayed as 1000 000. When changing back to the default separator of the selected language then the separators will be correctly added to numbers from a million and above (German: 1.000.000). Dialogs with separator: - Writer: Table > Number Format - Calc: Format > Cells > Numbers - Calc: in every cell style dialog > Numbers Actual behavior: Changing thousands separator for 1.000.000 (German) from a point to a thin space will result in 1000 000. Expected behavior: The million with manually added thin space as separator should be displayed as 1 000 000. PS: Should the name be 'digit group separator' instead of 'thousands separator'? (https://en.wikipedia.org/wiki/Decimal_separator#Digit_grouping) Version: 6.2.0.0.alpha0+ (x64) Build ID: 414ef6cb187dd3bbcc917dbedf3c0c1cc8668f60 CPU threads: 8; OS: Windows 10.0; UI render: GL; TinderBox: Win-x86_64@42, Branch:master, Time: 2018-08-21_00:13:04
Thousand separator (like decimal separator or grouping rule) cannot be manually modified. It is automatically defined for each language. When you add an undefined character, like thin space in German, it is treated as a text character and added between 3rd and 4th digits. When you enter a number less than 1000, your pseudo thousand separator character will be also inserted. You may notice it if you use a character different from space. It correctly works like that from the beginning, so it is not a bug for me.