# Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3?

LibreOffice 4.2.8.2 Build ID: 420m0(Build:2)

Example, in D2, E2, F2:

12,8 | DEBIT | VRAI [=SI(EXACT(E2;"DEBIT");D2;"")]

Interestingly, the result specified in the function wizard is correct...

Cheers, JPP

edit retag close merge delete

Sort by » oldest newest most voted

Hi

I do not reproduce this malfunction (locale and UI in French). Is it the same in a new spreadsheet?

The cell where the function was probably pre-formatted Boolean value. Have you tried Right click "Clear Direct Formatting"?

Regards

more

How on earth do we (pre or post) format a cell to a Boolean value?

( 2015-07-26 16:03:35 +0200 )edit

Just type TRUE (FALSE) in a cell... or right clickFormat CellsNumbers tab, Category: Boolean value

( 2015-07-26 16:09:56 +0200 )edit

"Category: Boolean value" AARGH! Looking & not seeing. Thanks, Pierre.

( 2015-07-26 16:37:10 +0200 )edit

For me it returns "#NAME?", since it does not know what the function 'si()' is supposed to be. Neither does the Help, nor the function wizard, and neither do I.

Updated later:
GOOD GRIEF!!! There are an entire set of French translations of the command language, so the 'SI()' function is the French equivalent of the 'IF()' function (thanks Iolax).

Changing F2 to =IF(EXACT(E2,"DEBIT"),D2,"") it gives the result "12.8" (D2 as "12.8" numeric, EN locale) or "12,8" (D2 as '12,8' text'). Note that Calc changed the semi-colons (;) to commas (,) twice (once when first pasting the function in, and second after editing each comma back to a semi-colon). I do not know whether the semi-colon change would make any difference to the OP FR result.

I assume that this is a bug in the FR coding. I cannot assist further, as I'm not prepared to change my locale (I would likely need to reinstall with a new locale to experiment further).

more

Hi Alex, I checked the website https://help.libreoffice.org/Calc/Log... and found SI function is the IF function in English.

( 2015-07-26 02:35:18 +0200 )edit

Hi,

@pierre-yves samyn: yesss! Clearing direct formatting does work. Thank you. I thought of a formatting issue, but I had only tried to explicitly format the cell as a Number, which apparently is not enough.

@Alex Kemp: I should have mentioned the different set of functions for French, sorry. It actually drives me nuts quite often! Sharing files across different language settings, for instance, may be a pain in the neck (your comment wrt to the semicolon vs. coma issue is typical, since the coma is used as a decimal separator in French...). Thanks for your time anyway.

Cheers, JPP

more

In French you find "boolean value" as "Valeur logique" in the column "Catégories" of the tab "Nombres"

more