https://bugs.documentfoundation.org/show_bug.cgi?id=162581
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|UNCONFIRMED |RESOLVED CC| |[email protected] --- Comment #1 from Regina Henschel <[email protected]> --- The feature "dynamic array" does not exist in LibreOffice. The feature request for it is in bug 127808. The fact that a one-row result is copied to subsequent rows of an existing larger output area is conform to ODF. That is item 2.1.3 in section 3.3 Non-Scalar Evaluation in https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading__1017866_715980110 This copying is only for a 1-row input into an output area with more than one rows. For a 2-row input into a e.g. 5-row output area, you would get #N/A error messages. I don't know why this rule was introduced in ODF. I personally want to replace the rule with another one, that allows applications to adapt the output area to the actual input instead. Discussion about that has just started in the ODF TC. And a possible solution depends how "dynamic array" will be implemented in LibreOffice and will be standardized in ODF. A quick solution is not to be expected. In the meantime you could workaround the problem. You can use the functions ROWS and COLUMNS to determine the actual size of the output of the FILTER function and with this information adapt the output area manually. Or you use the Advanced Filter of a Database Range. That adapts its output size to the actual size of the filter result. In case you need help on that, please use our ASK site. *** This bug has been marked as a duplicate of bug 127808 *** -- You are receiving this mail because: You are the assignee for the bug.
