How To...

Filter panel – Text filters

When you click on “Filter” icon on Filter panel’s toolbar or click “View” menu -> “Filter” sheet ->” Edit” menu item, Sisulizer opens Filter dialog. This dialog contains settings available also via Filter panel (“Row statuses”, “Translation statuses”, “Data Types” tabs), but you can find here some additional items, that is, “Text” and “Other” tab. These tabs contain powerful and advanced filtering options. I describe in this article filtering settings available in “Text” tab. Below is example screenshot from “Text” tab of Filter dialog.

Text tab

Text fields

In the upper part of this dialog are the following text fields visible where you can type filtered text:

  • Context
  • Original
  • Translation

These fields allow you to filter Translation sheet contents by typed text. For example, when you type some text e.g. “add” to “Original” field, Sisulizer displays in sheet only items with this string in the original language column (additional, typed text is highlighted in all displayed rows).

Filtered originals

These filtering options can be used for verification of translations (“Translation” field), excluding from localization some original strings, excluding context items with specified text, etc.. It is perfect to check consistently use of your terminology. For example, if you would like to keep some own names for your tools also in translations, you can type name of your internal tool to “Original” field. It displays in sheet only strings with this name. Next, you can quickly exclude, mark, lock all filtered rows or add comments to these rows. When you check “Excluded” checkbox, filter works in opposite way and matching rows aren’t shown. For example, if you typed “add” string to “Original” field, Sisulizer displays only rows without “add” string.
You can use quick filtering (translation and original columns) directly via Translation sheet. Simply, right click on desired word in cell and select “Filter all items having …”. Below is example for our example word, that is, “add”.


Below above described text fields is the “Options” section. This section specifies options how above strings are compared to the project strings. Below is a list available options.

  • Case sensitive – includes only those rows where the text exactly matches the case of the text you have entered above
  • Ignore hotkey characters – if checked ignore hotkey character mark (e.g. & or _) when comparing strings
  • Whole strings only – if checked limits the search to text that matches complete strings
  • Whole words only – if checked limits the search to text that matches one or more complete words
  • Long threshold – if given shows only those rows whose translations are the given value longer than the original value. This filter setting was described in other article on our blog.

Translated strings compared to originals

This filter allows you to display rows with translation values identical with original values, and it can be useful for verification of translation job. For example, this filter allows you to quickly search original values accidentally copied to translation columns. Possible options:

  • No Filter
  • Identical
  • Different

By default all translation items identical with originals are displayed in grayed color in sheet (look on below screenshot), but you can change it in Sheet properties.

Identical items

Empty Originals and Empty Translations

These settings filter originals and translations with empty values or values only with spaces. Empty items can be the reason for many troubles in localized application, and this solution allows you to avoid these issues with your application. You can also use validation tests (Validation menu) for searching empty items. Don’t worry if your translation cell in sheet is empty (first row from below screenshot), because in this case Sisulizer uses original string. However, for second row from below screenshot with “(empty)” item, Sisulizer uses in output file empty translations, and described here filter finds similar items.

Empty item

Spelling errors

These filters allows you display in sheet only strings with potential spelling mistakes. Of course, you can set up this filter separately (or together) for original and translation column.


Leave a Reply