In Excel functions like SUM and AVERAGE ignore logical values in Calc they are numbers and are therefore included.Take care therefore, if you need compatibility: Another example: NOT(57) returns FALSE because 57 evaluates as TRUE.Įxcel in contrast has a separate type for logical values - they are not numbers, but are sometimes converted to numbers. For example where A1 contains apple, NOT(A1) returns TRUE because 'apple' evaluates as 0 = FALSE. 0 is taken as FALSE and anything else is taken as TRUE. For example =TRUE() returns the value 1, which is displayed as TRUE if you then change the format to a numerical format, it displays 1.Īny Calc function that tests for a logical result, actually tests if the value evaluates as the number 0. Any Calc cell formula that returns a logical result, tells the cell to display FALSE or TRUE - if the cell has the default (General) format. We may enter 1 in a cell, and then (selecting Format - Cells.) choose the 'Boolean Value' format to display the number as TRUE.Īny Calc function that returns a logical result, actually returns the number 0 or 1. In Calc, logical values are represented by numbers: 0 is FALSE and 1 is TRUE. Returns TRUE if any of the arguments are TRUE. Returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE. Returns one of two values, depending on a test condition.

Returns TRUE if all the arguments are TRUE. But this is too complex for an ordinary user.The logical functions operate on logical ('boolean') values, that is, TRUE or FALSE.

It will be integrated as a new Calc function. This is not a simple script but a complete Uno component, to be installed in with an extension. A work-around is to store the script function in My Macros, and load the document only when is already loaded. The Basic wrapper function must call the script using the Scripting Framework, which is not really simple (you can find examples in the forums).īut there is another problem : if you put the script function and wrapper function in a Calc document, the formula will throw an error at loading of the document, because at this time the script is not yet loaded. Your Calc formula will call the wrapper function, which in turn will call the script function, get its result and return it as a result. If you want it to use a function created in a script language (JavaScript, BeanShell, Python) you need to create a wrapper function in Basic. Calc is only designed to use functions created in OOoBasic.

Openoffice calc function