Issue 107184 - Cellrange.Filter incorrect for values 66 and 67
Summary: Cellrange.Filter incorrect for values 66 and 67
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO310m19
Hardware: Other Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-11-24 19:14 UTC by fjcc
Modified: 2013-08-30 08:27 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description fjcc 2009-11-24 19:14:06 UTC
The issue is described in the Spanish forum and
confirmed in the English forum Code
and example files are available there. A macro defines a cell range in column A.
A FilterDescriptor is then created and set for isNumeric = True, FilterOperator
= c.s.s.FilterOperator.EQUAL. Calling CellRange.Filter(FDescriptor) works for
NumericValues except 66 and 67. Setting NumericValue to 66 results in the filter
showing all of the empty cells in the range.  Setting NumericValue to 67 filters
for all non-empty cells. B. Marcelly confirmed the behavior also in version 1.1.5
Comment 1 Edwin Sharp 2013-08-30 08:27:44 UTC
As give in description.

Rev. 1518439 Win 7