To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107184 Issue #|107184 Summary|Cellrange.Filter incorrect for values 66 and 67 Component|Spreadsheet Version|OOO310m19 Platform|Other URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|fjcc
------- Additional comments from [email protected] Tue Nov 24 19:14:06 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
