https://bugs.freedesktop.org/show_bug.cgi?id=50866
Bug #: 50866
Summary: Macros: Macro to set filter in Calc does not work with
.NumericValue
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.3 release
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: NEW
Severity: normal
Priority: medium
Component: BASIC
AssignedTo: [email protected]
ReportedBy: [email protected]
The following standard method of filtering a named range in Calc has worked for
years in OO, and still does. In LO, however, the entire range is filtered out,
no matter what numeric value is entered ("38" in example below).
Filtering manually works great.
oDBRange = oDoc.DatabaseRanges.getByName("DB_Range_Name")
oDBRange.UseFilterCriteriaSource = False
oFD = oDBRange.getFilterDescriptor()
oField = createUnoStruct("com.sun.star.sheet.TableFilterField")
With oField
.Field = 0
.Operator = com.sun.star.sheet.FilterOperator.EQUAL
.isNumeric = True
.NumericValue = 38
End With
oFD.setFilterFields(Array(oField))
oDBRange.refresh()
Possibly related to bug 46983.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
