Array formulas
Calc
supports array formulas (formulas entered using Control+Shift+Enter),
but Calc can not have array constants in a formula. The work-around
is to have the constant values in cells on a sheet and refer to them.
Some
Excel array formulas seem to rely on the way that Excel is
calculating a result in a non-documented way–such a practice is not
a good idea even within Excel only, and certainly not a good idea
when importing a file containing such a formula into Calc.
Note
|
OpenOffice.org
help refers to array functions as matrix functions.
|