* Logo
* Translator Tools
*
* Motto
* *
TransTools suite Knowledge base Feedback Back to Index | Site map
*
*
*
*
**
**
**
**
**
*
*
*
*
*
*
Also on:

TransTools on Twitter TransTools on Google Plus TransTools on LinkedIn TransTools on Scoop.It!
*

Language Check

Excel
Category: Quality Assurance

Undo Undo support - YES. See general Excel undo notes.

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
Screenshot: 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.

Requirements:

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.

Options:

Screenshot: Check Translation dialogue

  1. Direction : 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.
  2. Entire worksheet - select this if you want to check the entire active worksheet.
  3. Selection - 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 containing textboxes.
  4. Highlight color - 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 command).
  5. Evaluate formulas - 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.

When the appropriate options have been selected, click Continue. To exit, click Cancel.

Notes:

  • 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'.

 

Developed by Stanislav Okhvat, 2007–2016

Microsoft Word®, Excel®, PowerPoint® and Visio® are registered trademarks of Microsoft Corporation.
Autocad© is copyright of Autodesk, Inc.
SDL Trados® (including SDL Trados Studio, Trados Workbench, TagEditor and Microsoft Word Addin) is a registered trademark of SDL plc.
memoQ is copyright of Kilgray Translation Technologies.
Wordfast© is copyright of Yves Champollion.

Software disclaimer