https://bugs.documentfoundation.org/show_bug.cgi?id=161767
--- Comment #7 from Regina Henschel <[email protected]> --- Created attachment 208919 --> https://bugs.documentfoundation.org/attachment.cgi?id=208919&action=edit Example with FILTER on database range Example to show the interoperability problems: Open the attached file and export it to xlsx-format. Open the exported file in Excel. Problem: Excel treats "myData" without header and thus the FILTER functions does not work because the criteria range has a different count of rows. Opening the exported file in LibreOffice works. In case the decision is to keep the behavior of LibreOffice to include the header, then the export needs to generate [#all]. However, I would prefer to exclude the header in SORT and FILTER function in LibreOffice. BTW, the footer needs to be treated as well. -- You are receiving this mail because: You are the assignee for the bug.
