https://bugs.freedesktop.org/show_bug.cgi?id=50866

Beluga <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO
                 CC|                            |[email protected]

--- Comment #1 from Beluga <[email protected]> ---
Can you give me more detailed steps to reproduce (if this is still a problem)?
I did Insert - Define - Name for row selection with numbers, including 38. I
named it range.

Then I had to modify the macro like this:

Sub Rangetest
oNamedRanges = ThisComponent.NamedRanges
oNamedRange = oNamedRanges.getByName("range")
oNamedRange.UseFilterCriteriaSource = False
oFD = oNamedRange.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))
oNamedRange.refresh()
End Sub

It refuses to run. It doesn't seem to be finding the range by name,
highlighting the getByName line while giving the error:
Type: com.sun.star.container.NoSuchElementException

Tested on Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 8b21b5cbe78945b27525b4ce78ae3d981f90590f
TinderBox: Win-x86@39, Branch:master, Time: 2014-11-06_03:55:51

-- 
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

Reply via email to