Excel 2000-2003 Settings

Exclusions page

You can choose not to extract the content of cells formatted with a certain color by selecting the Skip cells formatted with selected color check box, and then selecting the color.

You can also choose not to extract the content of certain columns by selecting the Skip selected columns check box. Then, click Add Column, type the name of the column that you want to exclude from translation and click OK.

Common page

Comments: Include comments for translation or skip them.
Headers and footers: Include headers and footers for translation or skip them.
Hidden content (columns, rows, columns, sheets): You can extract these for translation or skip them.
Sheet names: Include sheet names for translation or skip them.
Alternative text: Alternative text corresponds to the Alt HTML attribute. You can include alternative text for translation or skip it.
Hyperlinks: Select this check box to make all parts of the hyperlink element available to the translator, including the hyperlink itself.
Cells with numeric content: Include cells with numbers or skip them.
Treat special characters as inline placeholder tags: Examples of special characters are non-breaking space, tab, and discretionary hyphen. You can treat these characters as text or as tags. If you select this check box, they are put into inline tags. Em dashes and en dashes are always treated as text.
Skip character spacing and kerning: Include advanced font formatting such as character spacing and kerning or skip it.
Tip: Advanced formatting is usually removed because you probably will need to reapply advanced formatting after translation, so including such formatting merely increases the number of tags displayed during translation.
Extract optional hyphens: The placement of discretionary hyphens depends on the structure and pronunciation of the words in the source language, so you should usually choose to remove rather than extract them.

QuickInsert Settings page

QuickInsert: Use the QuickInsert panel to add or edit QuickInsert items for this file type. QuickInsert items give the translator a way to insert content from the editor's QuickInsert toolbar.
The list of QuickInsert items does not include the standard (default) QuickInsert items, so initially it is an empty list.
Name: The name of the QuickInsert button.
Description: A tooltip for the QuickInsert button.
Standalone text: For example, to use QuickInsert to insert a character.
Text pair: For example, to use QuickInsert to insert a pair of characters (such as French quotation marks).

Font mapping page

Font mapping

Use the Font mapping settings to specify the fonts that WorldServer uses in the target document to replace the fonts used in the source document.

For example, if the target language is Chinese (Taiwan), you might want to specify that the PMingLiu font is used for all text in the target document, regardless of the fonts used in the source document. If so, map all source language fonts to PMingLiu for Chinese (Taiwan).

By default, most target languages in this dialog box have only one font and for each language all source fonts are mapped to one font.

Note: The mapping is done when the target document is created (when the document is saved as target), so you may not see the mapping in the editor.

Embedded Content page

Select the Enable embedded content processing check box if you want to enable embedded content processing. Use document structure information to identify embedded content and tag definition rules to specify how to treat it.

Document structure information

Embedded content processing for Excel file types only works when you select Cell as the document structure information. This is selected by default, so you do not need to add any other type of structure information.

Tag definitions rules

Add tag definition rules to specify how to treat the embedded content defined under Document structure information. Click Add, and then, in the Add/Edit Embedded Content Rule dialog box, specify the following:

Field	Description
Tag Type	Placeholder – converts embedded content into standalone (placeholder) tags. Tag Pair – identifies tag pairs (a start tag and an end tag) in the embedded content.
Start Tag	A regular expression that identifies embedded content and converts each occurrence of such content into a placeholder tag. For example, to convert all HTML `<br>` (line break) tags into placeholder tags, type `<br.*?>`
Ignore case	Select this check box if you do not want the letter case of your defined tags to be taken into consideration when the embedded content is identified.
Translate	Not translatable means that the content between the tag pairs is displayed to the translator as locked content. Text within tag pairs can be translatable or non translatable. Placeholder tags are not translatable.
Formatting	If available, click Edit to modify the way in which the embedded content is displayed.

If you click Advanced, you can specify how tags are displayed in the Advanced Settings dialog box:

Field	Description
Inside text the tag acts as a word end	Use this option to change the behavior of cursor placement. When you select it, the editor treats the tag as a word for the purposes of navigation. For example, in the editor, pressing Ctrl+Left Arrow moves the cursor to the beginning of the tag and Ctrl+Right Arrow moves the cursor to the end of the tag.
Text lines can be wrapped after the tag	Selecting this check box indicates that a line break after this tag does not indicate the end of a segment. For example: Gather ye rosebuds while ye may, `<br>` Old Time is still a-flying: `<br>`
Tags represent formatting only and can be hidden in the editor	When you select this check box, text is formatted correctly and the standard formatting tags (for example, bold, italic, and font type) are not displayed. Selecting this option does not mean that the tag is always hidden; the user can change the editor settings to make the tag to be displayed.
Tags represent the text	Placeholder (standalone) tags only. A tag can have a text equivalent. For example, the entity tag `"` has the text equivalent `"`.
Segmentation hint	A segmentation hint is a property of a tag that helps the program to segment the asset better when converting the asset to a translatable format: whether to position the tag within a segment or outside of the segment or to force a segmentation break. Select one of the following options: Include – if selected, the tag is displayed in the editor, even if it has no associated text. You would rarely select this option. Include With Text – if selected, the tag is displayed in the editor when the tag has associated text. For example, the tag specifies a footnote marker. Where this is the case, the translator needs the ability to move the marker to another word in the same sentence, so the tag should be included with the text. Exclude – if selected, the program will use the tag or tag pair to segment the text wherever possible. For example, if `<p>...</p>` or `<br>` tags are marked as Exclude and an XML document includes embedded HTML code, the software will use the `<p>...</p>` and `<br>` tags to segment the document. This segmentation is in addition to the segmentation already applied to the embedding XML code. May Exclude – The editor determines whether the tag is part of the text.