https://bugs.documentfoundation.org/show_bug.cgi?id=163055
Bug ID: 163055
Summary: Basic macro with filtering instructions stopped
working
Product: LibreOffice
Version: 24.8.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
My Ubuntu Linux has just updated LibreOffice to 28.8.1.2 and now a couple of
basic macros I use every day has stopped working in the part that sets a filter
and in the part that cleans the 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)
Steps to Reproduce:
1.Run the filter code on a file with date values
2.Run the clean filter code on a file with filtered columns
Actual Results:
Data are not filtered or filter is not cleaned
Expected Results:
Data filtered over the cell value read by macro or filter is cleaned
Reproducible: Always
User Profile Reset: No
Additional Info:
Macros was written 5 years ago and has ever worked on every previous
LibreOffice version
--
You are receiving this mail because:
You are the assignee for the bug.
