AutoFilter
<autoFilter ref="D5:H11"> <filterColumn colId="0"> <filters> <filter val="A"/> </filters> </filterColumn> <filterColumn colId="1"> <customFilters and="1"> <customFilter operator="greaterThan" val="0"/> <customFilter operator="lessThan" val="0.7"/> </customFilters> </filterColumn> </autoFilter>
AutoFilters specify criteria for which cells in a table should be displayed. In this example, the first column (zero-based index @colId
) in the table (cells D5:D11), has a criteria specifying that only rows in the table whose value in column D are equal to A
will be shown. The rest of the rows are hidden.
A second criterion is specified as well, on the 2nd column, E: only rows whose values in column E are greater than 0 and less than 0.7.
The resulting grid could be rendered like this: