Description: When using a Locale that does not use the period as the decimal separator, the option exists to check the box for "Decimal Separator key: Same as locale setting (,)". This is a great idea - well done! I'm in en-ZA. However, when entering an IP address, the concept fails. In my case, the decimal separator is a comma, so my IP addresses visually appear as: 8,8,4,4 instead of: 8.8.4.4 Would it be plausible to incorporate recognising that multiple decimal commas are not really commas, but periods? In other words, when I enter on the numerical keypad: When I enter: 3 . 4 display this as 3,4 (as is done now); and then When I enter: 3 . 4 . 5 . 6 display this as 3.4.5.6 interpreting this to be an IP address. Especially in our locale, where the numbers "thousands separator" is a space, we will never have a normal number with multiple commas, since it's only used as the decimal separator. Steps to Reproduce: 1. In Tools/Options/Language Settings/Languages set Locale to English (South Africa) and check the Decimal Separator key - Same as locale setting box. 2. Using the keypad, enter a number with a period. e.g. 3 period 4 would show as 3,4 3. Using the keypad, enter an IP address. It would show as 8,8,4,4 - rather it would be desirable to have it show as 8.8.4.4 Actual Results: IP addresses are separated by commas instead of periods. Expected Results: IP addresses should be separated by periods. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: When sensing more than one comma (i.e. decimal separator) convert the localized option (the comma) to use periods instead. Version: 7.1.5.2 Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: en-ZA (en_US.utf8); UI: en-US Calc: threaded
For me it is not a bug because the dot from the numerical keypad is the decimal separator. Use the dot from the keyboard instead when you want a dot. Closing as NotABug. Please feel free to reopen if you disagree. In that case, please add explanation. Best regards. JBF