Soluling home   Document home

Grid Filter - Text

Use this sheet to specify a filter based on the context value, original string, or translated value.

Mode

The following modes are used:

Value Description
Plain text Plain text is used in the filter text
Plain text with wildcard characters
As above but * and ? characters are interpreted as wild characters.
Regular expression Filter text is a regular expression.

Context

Text is used to find matches in the context values.

Check Excluded to include those rows that do not match the above text.

Original

Text is used to find matches in the original values.

Check Excluded to include those rows that do not match the above text.

Translation

Text is used to find matches in the translation values.

Check Excluded to include those rows that do not match the above text.

Options

Specifies options for the text filtering. Possible options are:

Value Description
Match entire cell contents If checked, the filter value must match the whole-cell value.
Match case
If checked, the case in the filter value must match the case of the cell value.
Ignore hotkey characters If checked, hotkey characters (e.g., & or _) are ignored.
Match whole words If checked, the filter value is considered a word, and there must be a match for the whole word.

Translated strings compared to originals

Specifies if original strings and translations are compared and filtered based on the comparison. Possible values are:

Value Description
No filter If checked, the filter ignores original and translation comparison.
Identical
If checked, the filter shows only those rows where original and translated values are the same.
Different If checked, the filter shows only those rows where original and translated values are different.