dimanche 20 septembre 2020

libreoffice calc bug or missconfiguration prevents IF statment to work on the version 6.4.5.2

I cant make the if statement work on 'LibreOffice 6.4.5.2 40(Build:2)', lubuntu 20.04. But it works on 'LibreOffice 6.4.2.2 40(Build:2)', lubuntu 20.04, of other cpu.

Cell A1 : 1

Cell A2 formula : =if(a1=1;2;3)

Cell A2 should returns : 2

But returns : #NAME?

This same formula works on the other cpu. So its either a problem with the configuration or a bug of the version 6.4.5.2 , right ? I did reinstalled the libreoffice calc using the terminal, but this error persists.

Aucun commentaire:

Enregistrer un commentaire