https://bugs.documentfoundation.org/show_bug.cgi?id=152091
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #13 from Eike Rathke <[email protected]> --- The behaviour is expected. If a function or operator expects a single scalar value but the argument is a cell range and the formula expression is not in array mode, an implicit intersection of the formula cell's position and the cell range argument is taken. If such is not possible because the position and the range are not intersect-able or the range is not a column vector or row vector with a single dimension in the intersection direction, an error is returned. For example the reference A1:A2 is intersect-able anywhere on row 1 or row 2, but not on other rows nor anywhere in column A (because then there is no single cell intersection). See also ODFF 6.3.3 Implied Intersection https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017984_715980110 -- You are receiving this mail because: You are the assignee for the bug.
