[Solved] Where is my filter?

[Mr.Dandy]

I don't understand where is located the filter.
In the attached document, I was apply a filter but unable to find it in ThisComponent tree.
The DatabaseRanges.Count property returns 0

Thanks

[Mr.Dandy]

I must have misspoken.
I'm not trying to un/filter through the UI, but to retrieve the filter description I defined via the API.

[FJCC]

If I do the following steps in MRI

Code: Select all

  oDatabaseRanges = ThisComponent.DatabaseRanges
  oObj1 = oDatabaseRanges.getByName("__Anonymous_Sheet_DB__0")
  oFilterDescriptor = oObj1.getFilterDescriptor()
  
  oFilterFields = oFilterDescriptor.getFilterFields()

I see the the following properties in the FilterFields

Code: Select all

(Name)        (Value Type)             (Value)  (AccessMode)
(0)
Connection    .sheet.FilterConnection  OR     
Field         long                     0      
Operator      .sheet.FilterOperator    EQUAL  
IsNumeric     boolean                  False  
NumericValue  double                   0.0    
StringValue   string                   A      
(1)
Connection    .sheet.FilterConnection  AND    
Field         long                     1      
Operator      .sheet.FilterOperator    EQUAL  
IsNumeric     boolean                  True   
NumericValue  double                   12.0   
StringValue   string                   12     

Is that what you are looking for?

[Mr.Dandy]

Thanks FJCC for the hint

But that's work only with OpenOffice.
LibreOffice returns an empty DatabaseRanges object.
I found an issue report with 147257
I must use :

Code: Select all

oUDR=ThisComponent.getPropertyValue("UnnamedDatabaseRanges")