After upgrading to version 7.4 comma is no longer accepted as decimal point when typing a formula.
It works fine when typing values into a cell. So you can type 7,5 into cell A1, type 2,2 into cell B1 and create a formula =A1*B1 in cell C1. But you cannot create a formula =7,5*2,2 in cell D1. Result will be #NAME? I need to use . as decimal point in formulas. That is rather annoying.
This has never been a problem before. What has gone wrong?
Language settings in Libre Office: User interface = Default - English (USA), Locale setting = Danish, Decimal seperator key = Same as locale setting (,).
Computer locale = Danish
tdf#151886
2 Likes
Thank you Mike, that explains why.
Hope the developers agree on a solution that can handle all considerations.