https://bugs.documentfoundation.org/show_bug.cgi?id=163055
--- Comment #9 from Paolo <[email protected]> --- Created attachment 196601 --> https://bugs.documentfoundation.org/attachment.cgi?id=196601&action=edit New ods file with macro inside Sorry to cause you so many problems. In the new ods file you find the macro and the functions they use correctly working. The two macros with problems are, again, MettiFiltroDati and RimuoviFiltroDati. As I stated in the bug opening description, the problem seems to be the Range object method "filter" > These are the parts no more working: > FILETER > oRange = oSheet.getCellRangeByName("AB5:AC" & Row+1) > oFilterDesc = oRange.createFilterDescriptor(True) > With oFields(0) > .Field = 0 > .IsNumeric = True > .NumericValue = oSheet.getCellRangeByName("AI1").value > .Operator = com.sun.star.sheet.FilterOperator.GREATER_EQUAL > End With > oFilterDesc.setFilterFields(oFields()) > oFilterDesc.ContainsHeader = True > oRange.filter(oFilterDesc) > CLEAN FILTER > oRange = oSheet.getCellRangeByName("AB5:AC" & Row+1) > oFilterDesc = oRange.createFilterDescriptor(True) > oRange.filter(oFilterDesc) As I stated before, this instruction has worked properly 'till the system had updated LibreOffice to its last version. The two macros in "RangeObjectMethod_filter_debug.ods" with any previous LO version will do their job -- You are receiving this mail because: You are the assignee for the bug.
