How can I exclude certain colored texts from my Excel translation?
When working with Microsoft Excel files, it is common to require that certain colored text such as red text or other items are not extracted for translation to the target file. Wordbee Translator provides you with the ability to specify certain text colors within a Microsoft Excel file to be excluded from the translation.
The Default Configuration for Microsoft Excel files does not do this automatically. The best way to handle this requirement is to Create a Custom Format Configuration with this option as part of that configuration.
To do this, you will need to go to Settings > Translation Settings > Document Formats, choose the Excel format type, and then either modify an existing one or create a new one for these scenarios.
Step 1: You will need to click on Edit to begin making changes to the chosen Microsoft Excel configuration. If only the Default configuration is present for Excel files, simply edit it and then Save as New when finished.
Unless you have already configured a custom configuration for Microsoft Excel files, the best approach is to access these settings in Wordbee Translator and create a new custom configuration from the provided Default Configuration. To do so, please refer to the Create file format configurations page.
Step 2: Next, select the Do not translate Tab to view the configuration options for what should not be translated in a Microsoft Excel source file.
Step 3: In the Colors section you will see several colors listed with their own individual checkbox. If you want to omit a specific color of text from the translation, simply check the checkbox next to each text color that should be excluded from the translation.
Be certain to use the default colors for text in Excel and to select the same within the file format configuration. If another shade other than the default is used within the source file, the text will still be extracted as it will not match the configuration selection.
When the required text color options have been enabled (checked), this configuration section will appear as shown below:
Step 4: When finished, you have two options for saving the change. If you are making the change for an existing configuration (other than the Default), simply click on Save. However, if you are using an existing to create a new file format configuration, you will need to enter a Name, enter a Description (Optional), and then click on Save as new at the top right of the screen.
Step 5: To view the list of Excel configurations, click on Back to list in the top right of the screen.
New configurations will appear in the list for Microsoft Excel file format configurations. In the example below, a new configuration was created from the Default Configuration to omit blue, green, and red text from the translation.