Documentation Center

Configuring the Microsoft Excel 97-2003 file type

You can configure Microsoft Excel 97-2003 settings, so that you customize the way this file type is processed during translation or review.

Procedure

  1. Decide for which projects you want to configure file type settings:
    • For the active project, go to the Projects view, and on the Home tab, select Project Settings.
    • For all future projects, go to File > Options.
  2. Expand the File Types list, and select the Microsoft Excel 97-2003.
  3. Select the Exclusions page, and then:
    1. Select the Skip cells formatted with the selected color checkbox and select a color, to ignore the Excel cells marked with a specific color from translation.
    2. Select the Skip selected columns checkbox, to ignore specific Excel columns from translation. Select Add Column and fill in the Excel column name.
  4. Select the Common page and then specify which content becomes translatable:
    • Under Select the optional content to include for translation:, specify which content becomes translatable. Select:
      • Comments to make comments translatable.
      • Headers and footers to extract headers and footers for translation.
      • Hidden content (columns, rows, sheets) to extract hidden content for translation.
      • Sheet names to make sheet names translatable.
      • Alternative text to extract the text corresponding to the ALT HTML attribute for translation.
      • Document properties to extract details such as the file author or the file creation date for translation.
      • Cells with numeric content to extract numeric content and its formatting for translation. Note that formatting is allowed only for cell-level formatting, not inline formatting.
    • In the Document properties area, select one of the available options from the list:
      • Do not extract - This setting does not extract any file properties for translation.
      • All document properties - This setting extracts all the file properties from the Summary and Custom tabs, and makes them available for translation.
      • Summary - This setting extracts the file properties only from the Summary tab (title, subject, author etc.) and makes them available for translation.
      • Custom - This extracts the file properties only from the Custom tab and makes them available for translation.
    • Under Other settings:, select:
      • Treat special characters as inline placeholder tags to treat non-breaking space, tabs and hyphens as tags. If you enable this option, special characters are enclosed in inline tags. Note that the em dash and en dash characters are always treated as text.
      • Skip character spacing and kerning to ignore spacing, kerning and placeholders such as <cf nfa="True">.
      • Extract optional hyphens to extract hyphens. SDL recommends that you leave this option disabled, because the placement of discretionary hyphens depends on the structure and pronunciation of words in the source language.
      • Retain Studio target comments in target file to make comments available for consultation in the target file.
  5. Select the QuickInsert page.
  6. Specify QuickInsert settings to insert tags and formatting, or to insert text and special characters.
  7. Select Font mapping.
  8. Specify the font mapping settings for your source and target languages.
  9. Select OK.