|Category: Quality Assurance|
This command checks whether all text in the worksheet or selection is fully translated from source language to target language, and changes the background color of cells containing "overlooked" text.
Sample - Results of 'Check Translation' command
|The example above was translated from Russian to English and then checked using 'Check Translation' command (settings: Entire worksheet, Yellow highlight colour). The command found one cell (no wrapping) whose text extends all the way from left to right - the "untranslated" text is enclosed in a red circle.
This command works only if the spreadsheet was translated between languages with two entirely different alphabets (e.g. English and Greek, German and Russian, etc.). To see the list of requirements, click here.
Why to use:
- Due to cell formatting, text may be hidden below another cell or completely hidden from view (e.g. when the cell's Wrap Text setting is off).
- Due to Excel's limited text editing capabilities, it is possible to skip text during translation.
: Select the direction in which the spreadsheet was translated (Source Language -> Target Language format). For example, if the text was translated from Russian to English, select Russian -> English
. For help on configuring available language pairs, please refer to TransTools configuration section
- select this if you want to check the entire active worksheet.
- select this if you want to check the selected range
only. The selection may be a selected range, a textbox or a group of shapes
- choose a pre-defined colour to be used for highlighting cells. Note: Make sure that the color you selected is not already used in the worksheet as a cell background color, otherwise you will not be able to restore the original background after proofreading
(see Remove Highlight
- this option allows you to check text of cells containing formulas. Spreadsheets often contain calculated cells whose contents rely on the contents of other cells. If this option is used, TransTools will highlight cells with 'untranslated' text. Unless this option is on, TransTools ignores calculated cells.
- Because Excel has no equivalent to Word's highlight colour, the command changes the cells' background colour instead. You will have to find the 'untranslated' text yourself.
- Use 'Remove Highlight' command to reset the chosen background colour to 'No colour'.