test.ods (9.3 KB)
I recently updated to 7.4.5.1 and I’m getting the strange issue showcased in the attached file:
in cell A1 I wrote (as I have done for several years)
=0,2+0,3
although now it gives me a #NAME? error. in B1 I wrote
=0.2+0.3
and, although my language setting is Italian (and thus the correct separator should be comma), it provides the correct answer.
What I can’t wrap my head around (and made me unable to find a solution if one was already posted) is that if I write the numbers with the correct comma separator in cells A2 and A3 and then write:
=A2+A3
I get the solution.
I have not made any changes to the local/keyboard settings (or Libreoffice’s) recently.
Obviously my intended outcome is to have the formula in A1 to work. Thanks for any support.
