Description: If one use e.g. Serbian Latin (Serbia) as default language for documents, and has set . (dot) as decimal key, the expression 15.65+665.55 will return an **Syntax Error**. But if expression is 15,65+665,55 calculation will be done without errors, no matter what it is Languages and Locales/General/Format/Decimal key on the numpad is set to "Same as locale setting (.)" Steps to Reproduce: 1. Change Windows locale to Serbian (Latin), same keyboard 2. change Decimal simbol in Control Panel to use dot instead of comma 3. Set Writer to use decimal key same as local setting 4. Set default language for docs as Serbian Latin (Serbia) Actual Results: 1. 15.15+15.15 , select expression, press CTRL+ and paste result - **Syntax error" Expected Results: 30.30 Reproducible: Always User Profile Reset: Yes Additional Info: 2. write 15,15+15,15 , select expression, press CTRL+ and paste result - 30,30 3. change language to e.g. English (USA) and repeat 1. Result is 30.30
(In reply to Giagor from comment #0) > Description: > If one use e.g. Serbian Latin (Serbia) as default language for documents, That includes, that the decimal separator is a comma. > and has set . (dot) as decimal key, How do you have done that? the expression 15.65+665.55 will return > an **Syntax Error**. > But if expression is 15,65+665,55 calculation will be done without errors, > no matter what it is Languages and Locales/General/Format/Decimal key on the > numpad is set to "Same as locale setting (.)" > The `Decimal key on the numpad` setting does not change what character is used as decimal separator in calculations. It only effects, whether pressing the key inserts the decimal separator of the current locale or inserts the character given by the keyboard layout.
(In reply to Regina Henschel from comment #1) > (In reply to Giagor from comment #0) > > Description: > > If one use e.g. Serbian Latin (Serbia) as default language for documents, > > That includes, that the decimal separator is a comma. It can be comma, but in Windows Settings/Time and languages/Languages and Region is set dot as decimal symbol. Other Windows software follow that, but Writer and Calc totally avoid it. > > > and has set . (dot) as decimal key, > > How do you have done that? What did you mean "that"? > > the expression 15.65+665.55 will return > > an **Syntax Error**. > > But if expression is 15,65+665,55 calculation will be done without errors, > > no matter what it is Languages and Locales/General/Format/Decimal key on the > > numpad is set to "Same as locale setting (.)" > > > > The `Decimal key on the numpad` setting does not change what character is > used as decimal separator in calculations. It only effects, whether pressing > the key inserts the decimal separator of the current locale or inserts the > character given by the keyboard layout. That is not logical. In every math calculation one uses numerical pad and if one set dot as `Decimal key on the numpad` it is expected to use it as symbol not just "character". To repeat - other software follow what is set in Windows settings as decimal symbol, but not LibreOffice. Right now we have nonsense - we must set Locale settings in Libre to English to use dot as decimal symbol, but Western default language to Serbian, due the spellcheck.
*** This bug has been marked as a duplicate of bug 46448 ***