Difference between revisions of "Calc/Drafts/Data Filter"
From Apache OpenOffice Wiki
(→Related issues: added i77677 which overlaps with this enhancement.) |
(→Related issues: corrected c&p issue URL) |
||
| Line 8: | Line 8: | ||
* [http://qa.openoffice.org/issues/show_bug.cgi?id=35578 issue 35578] for Empty and Non-Empty conditions in AutoFilter. | * [http://qa.openoffice.org/issues/show_bug.cgi?id=35578 issue 35578] for Empty and Non-Empty conditions in AutoFilter. | ||
* [http://qa.openoffice.org/issues/show_bug.cgi?id=35579 issue 35579] for Contains, Does-Not-Contain, Starts-With and Ends-With filter conditions. | * [http://qa.openoffice.org/issues/show_bug.cgi?id=35579 issue 35579] for Contains, Does-Not-Contain, Starts-With and Ends-With filter conditions. | ||
| − | * [http://qa.openoffice.org/issues/show_bug.cgi?id= | + | * [http://qa.openoffice.org/issues/show_bug.cgi?id=77677 issue 77677] for multi-selection filter extension ([[Calc/Features/multi-selection_filter_extension|spec]]) which also extends ODF's <table:filter-condition> element (already approved for ODF 1.2). |
== File Format == | == File Format == | ||
Revision as of 09:30, 6 December 2007
About a new feature that adds some filter-conditions and a Top10 Filter dialog in data filter.
Abstract
There are three purposes of this feature. The first is to add some filter conditions to standard filter dialog, they are “Include”, “NoInclude”, “Start”, “NoStart”, “End”, “NoEnd”. The second is to add a Top10 dialog. The last is to add “empty” and “notempty” to AutoFilter popup list.
the Specification of this feature
Related issues
- issue 35578 for Empty and Non-Empty conditions in AutoFilter.
- issue 35579 for Contains, Does-Not-Contain, Starts-With and Ends-With filter conditions.
- issue 77677 for multi-selection filter extension (spec) which also extends ODF's <table:filter-condition> element (already approved for ODF 1.2).
File Format
The filter conditions need to be stored in ODF. The accepted proposal for ODF 1.2 adds the values
- begins (begins with)
- ends (ends with)
- contains (contains)
- !contains (does not contain)
to the <table:filter-condition> element's table:operator attribute. Does-not-start-with or does-not-end-with are not handled.
