I’m learning how to use LibreCalc for the first time (coming from Excel), and I’ve been trying to use array functions, however they don’t seem to work as the documentation would suggest.
For example, the documentation states that “if cells A1 and A2 are empty the array formulas {=A1:A2=”"} and {=A1:A2=0} will both return a 1 column 2 row array of cells containing TRUE", however when testing this the above formula returned a single cell containing TRUE.
Similarly, the documentation also stated that for a 3x3 array, you can multiply each element in the array by using a formula such as =10*A1:C3, however when I try this the result is #VALUE!.
There are other issues as well, and it seems to me that LibreCalc doesn’t seem to consider the results of these functions to be arrays. This is particularly strange, since some array functions such as MUNIT(dimension) seem to work.
I’m at a loss and I don’t have enough experience with LibreCalc to know if this is a bug, or if I am misunderstanding something. Any advice would be much appreciated.
I am using:
Windows 10 64-bit
LibreOffice 24.8.2
Here is my test file with the above examples:
ArrayExamples.ods (9.8 KB)
Let me know if there’s any other useful information that I can provide.