In "Language Settings" option dialog, "Languages" panel, when unchecking the "Decimal separator key: same as locale setting", the LibreOffice calc behaviour is not changed. When the locale defines the comma "," as decimal separator, it would be convenient to have Calc accepts numbers formatted as "12.42" as valid numbers instead of interpreting them as text. I seem to remember that in older versions of Calc, the above setting could be unchecked to use the dot everywhere as decimal separator. Now, even when unchecked, Calc only understands the comma as separator. The problem happens in bare cell content, in formulas, in CSV import and likely in other places where a number is interpreted. -- Version: 7.0.3.1 Build ID: d7547858d014d4cf69878db179d326fc3483e082 CPU threads: 4; OS: Linux 5.9; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Flatpak Calc: threaded
You are confusing things. That is not what that option is supposed to do. What the option is meant for is to let the decimal separator *key* on a *numeric keyboard* produce the character that is used as decimal separator in the current locale, even if it is labelled differently. It never made accept input a different character as the defined decimal separator.