https://bugs.documentfoundation.org/show_bug.cgi?id=163055
--- Comment #13 from Paolo <[email protected]> --- It worked on every version of LO released in the past 5 years, including 24.2.6.2 (the previous installed by libreoffice ppa, at least on my Ubuntu linux). Have you noticed that, using the "MettiFiltroDati" macro, the blank rows after row 5848 "disappears"? It seems that it's trying to filter empty cells (or those with value = 0) I tested the macro on a Windows system running LO 7.0 and it does not work there (same result as yours). In this page "https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1sheet_1_1FilterFieldValue.html"; it says that the FilterFieldValue Struct has been released with LO 7.2, that's why on 7.0 macro fails. I will try 2 things: 1. run the macro on a "Try Ubuntu" from Ubuntu 24.04 iso image. 2. write a similar macro in a simpler file (two columns, one with text, one with numbers from 1 to 10, autofilter on) using "filter" over the sheet object on column with numbers filtering for values >= 5 [similar to the one in "Andrew D. Pitonyak 2012 file OOME macro explained 3rd edition"]. I'm searching in "https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sheet.html"; and its links to find a description of the "filter" method but, at the moment, I haven't found it. I believe the problem is somewhere there. Thank you -- You are receiving this mail because: You are the assignee for the bug.
