Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.1.250 Section 8.7.4, Filter Condition

a. This is not supported in core Word 2007.

b. The standard defines the attribute table:case-sensitive, contained within the element <table:filter-condition>

This attribute is not supported in core Excel 2007.

c. The standard defines the attribute table:data-type, contained within the element <table:filter-condition>

This attribute is supported in core Excel 2007.

Color, icon, and some dynamic filters are not saved.

d. The standard defines the attribute table:field-number, contained within the element <table:filter-condition>

This attribute is supported in core Excel 2007.

e. The standard defines the attribute table:operator, contained within the element <table:filter-condition>

This attribute is supported in core Excel 2007.

Some operators are not supported for PivotTable filters (for example, "bottom values" and "top values").

f. The standard defines the attribute table:value, contained within the element <table:filter-condition>

This attribute is supported in core Excel 2007.

Some regular expressions are not supported. Also, some values are not supported for AF, such as filtering with “Date = 36527” instead of “1/2/2000”. The table:value attribute is supported in Calc 3. However, only "." and ".*" are supported for regular expressions. All other expressions are dropped. On save, non-wildcard filters, such as "Contains", are transformed into corresponding regular expressions.

Show:
© 2015 Microsoft