Issue 107184

Summary: Cellrange.Filter incorrect for values 66 and 67
Product: Calc Reporter: fjcc <aftcampos>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOO310m19   
Target Milestone: ---   
Hardware: Other   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description fjcc 2009-11-24 19:14:06 UTC
The issue is described in the Spanish forum
http://user.services.openoffice.org/es/forum/viewtopic.php?f=21&t=2195 and
confirmed in the English forum
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=24992. 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