search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
152 stars 21 forks source link

Libre Calc: using , (comma) vs ; (semicolon) to separate arguments in formula #12

Closed cmallwitz closed 3 years ago

cmallwitz commented 3 years ago

Windows 7. LibreOffice 7.0.4.2 is autocorrecting any digit with the comma in the beginning ex. ",21" to "0,21" and then fx shows error:501. The symbol ";" works fine. Its better to correct the readme manual and write ";" instead ",".

Originally posted by @ikyquocked in https://github.com/cmallwitz/Financials-Extension/issues/10#issuecomment-770021789

cmallwitz commented 3 years ago

There is a setting in "Tools" - "Options…" - "LibreOffice Calc" - "Formula": Under "Functions" on can specify the character used to separate arguments in formula.

Mine is set to , (comma) - when I enter ; (semicolon) in a formula (Ubuntu / UK English), no error is reported but the semicolon is converted to , (comma)

Depending on your system's language and default LibreOffice settings, you maybe better off using ;