Hi Can someone please explain to me what the "ForceArray" attribute is supposed to do? To quote from https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017986_715980110
---snip--- 6.3.4 Force to array context (ForceArray) A ForceArray attribute forces calculation of the argument's expression into non-scalar array mode. This means that no implied intersection is performed, instead where a reference to a single cell is expected and multiple cells are provided, iteration over the multiple cells is performed and results are stored in an array that is passed on. ---snip--- In ODF 1.3, the HLOOKUP, LOGEST, LINEST, MATCH, and VLOOKUP functions are adding ForceArray to some of their parameters. For example VLOOKUP, is supposed to change from ODF 1.2's: VLOOKUP( Any Lookup ; Reference|Array DataSource ; Integer Column [ ; Logical RangeLookup = TRUE() ] ) to ODF 1.3's: VLOOKUP( Any Lookup ; *ForceArray* Reference|Array DataSource ; Integer Column [ ; Logical RangeLookup = TRUE() ] ) Now yes, already the "Lookup" parameter can be an array, or a range of cells, and if you enter it as an array formula, it will correctly populate each cell with a VLOOKUP of each element. And if you try to enter a column label as the "Lookup", VLOOKUP will fail because it doesn't do "implied intersection". So why is the ForceArray attribute on the "DataSource" parameter instead of the "Lookup" parameter? Or is ForceArray supposed to do something else? Thank you Damjan
