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:
© 2014 Microsoft