• Show convenient version of this site
  • Deutsch
  • English
Contact
Newsletter
  • Products
    • ALS
      • Across Language Server
        • Translation Management
        • Terminology Management
        • Translation Memory
      • Editions
      • Interfaces
    • ATE
      • Across Translator Edition
      • Editions
      • Download
      • Across Account
    • Elanion
      • Overview
      • Login
  • Solutions
    • Customers
      • Enterprises
      • Language Service Providers
      • Translators
    • Industries
      • E-Commerce & Trade
      • Pharmaceuticals & medicine
      • IT & Software
    • Departments
      • Marketing & E-Commerce
      • Technical Documentation
      • Software User Interfaces
  • Services
    • Hosting
    • Training
    • Consulting
  • Partners
    • Language Service Providers
    • Universities
  • Company
    • Across Systems
    • News
    • Events
    • Career
    • Contact
  • Knowledge
    • Blog
    • Video Library
    • Case Studies
    • White Papers
    • Fact Sheets
    • File Formats
    • Expert Features
  • Support
    • Online Help
    • FAQ
    • Support Request
    • Updates
    • New Functions
Schedule Consultation
  • Online-Help
  • ALS
  • System Management
  • System settings
  • Excel 2000-2003
  • Release Notes v7.0
    • Across v7 15980
    • Across v7 15960
    • Across v7 15954
    • Across v7 15934
    • Across v7 15921
    • Across v7 15918
    • Across v7 15911
  • Getting Started
    • Structure and Architecture
      • TMS Functionality
      • Across Support and Across Services
      • Toolbox
      • Modules
        • crossBoard
        • crossDesk
        • crossTerm
        • crossTank
      • Tasks/Roles
      • Using Across
        • Wizards
        • Module Icons
        • Keyboard Shortcuts
        • Context menus
        • Profiling mode
      • Customization
        • Across
        • Toolbars
      • Matches
      • Repetitions
    • Basic Decisions
      • Rich Translation Memory
      • Storing Multiple Translations
      • Permitting Multiple Translations
      • Segmentation
      • Splitting
    • Logging in
      • Online Client
      • Windows Authentication
    • crossBoard
      • Dashboard
        • Adding Dashlets
        • Customizing Dashlets
      • My Tasks
        • Confirming/Rejecting Tasks
        • Customizing the Module
    • Change username/password
    • Confirming and Opening Tasks
    • Internal Communication
      • Message Administration
    • Rights System: Default Settings
      • Projects
      • Documents
      • Target Languages
      • Paragraphs
      • Users
      • Cockpit
      • Groups
      • User Settings Templates
      • Languages
      • Fonts
      • Relations
      • crossTank
      • crossTerm
      • User Settings
      • System Settings
      • Tools
      • Workflows
      • LSCM
      • Windows Resources
  • System Management
    • General Information
    • Users
      • Context Menu
      • Creation with Across Login
      • Creation with Windows Authentication
      • Properties
    • Groups & User Crowds
      • Groups
        • Creation
      • Attribute-Specific Rights
      • User Crowds
        • Creation
    • Softkeys
      • Creation
      • Management
    • Reports for User and Group Information
    • User Settings Templates
      • Creation
    • Workflows
      • Standard
      • User-Defined
      • Assignment or Change
      • Configuration
        • Quality Management (QM v6.3)
    • Relations
      • Creation
    • Languages
      • Sublanguages
      • Right-to-Left Languages (RTL Languages)
    • Fonts
      • Missing Fonts
      • Assignment of Master to Trusted Server
    • User settings
      • The "General" Section
        • Alignment
        • General
        • Notification
        • crossSearch
          • Customization and Extension
        • Dialog Settings
        • E-Mail
        • Progress
        • Review
        • Project Wizard Options
        • Project Filters
        • Spell-Check
          • Adding a Hunspell Dictionary
        • Fonts
        • Languages
        • Preview
      • crossDesk Area
        • Auto-Propagate
        • crossTank
        • crossTerm
        • crossView
        • Contrast Formatting
        • Quality Management
        • Source/Context View
        • Target Editor
      • Customizing Shortcut Keys
    • System settings
      • Editing States
      • User Dictionary
      • crossGrid
        • TS Properties - General
        • TS Properties - Languages
        • TS Properties - Data Usage
        • TS Properties - Rights
          • crossTank
          • crossTerm
        • TS Properties - Contacts
        • MS Properties
      • crossGrid Packaging Templates
        • General
        • crossTank
        • crossTerm
      • crossTank
      • crossWAN Packaging Templates
        • General
        • crossTank
        • crossTerm
      • Subjects
      • Information
      • Machine Translation
        • Configuration
      • Project Settings Templates
        • General
        • crossTank
          • Storing Settings
          • Penalties
          • Pre-Translation
        • crossTerm
      • Quality Management v6.3
        • Configuring the crossTerm Check
        • Managing QM Lists (QM v6.3)
      • Quality Management v7.0
        • QM Check with Regular Expressions
      • Reporting
      • Segmentation
      • Language Settings
        • Date, Time, and Number Formats
          • Adding new format
          • Define Alphanumeric Dates
          • Sentence detection
          • Adding new abbreviations
          • Creating Sentence Rules
          • Editing Sentence Rules
          • Wildcard
      • Structure Attributes
      • System Attributes
        • User-Defined Creation
      • Search Center
      • Concordance Search Results
      • Stopwords
      • Term Extraction
      • Document Settings
      • Document Associations
      • Display Text
      • .NET Resources
      • Excel 2000-2003
      • Excel 2007-2016
      • IDML
      • MIF 7
      • MIF 8-2019
      • PDF
      • PowerPoint 2000-2003
      • PowerPoint 2007-2016
      • QuickSilver
      • Tagged HTML
        • The Element Properties Window (Tagged ML)
        • The Attributes Tab (Tagged ML)
        • The Formatting Tab (Tagged ML)
        • Tagged ML Formats – Configuration
      • Tagged SGML
      • Tagged XML
      • Tagged XML v2
        • Conditionally Mapping an XML Element to a Structure Attribute
        • Display Internal Elements Depending on the Attributes
      • Visual XML
      • Windows Resources
      • Word 2000-2003
        • Show/Hide Style Elements
      • Word 2007-2016
      • XLIFF
      • Regular expressions
        • Application Examples
        • RegEx QM Criteria for Software Localization
    • System attributes
      • crossTank Entries
  • Project Management
    • Projects
      • Project View
      • Project settings
      • Functions of the Module
      • Project Search
        • Search and Replace
      • Project creation
        • Execution
      • Adding attachements
      • Releasing Projects
      • Document and Project Updates
        • Execution
      • Project status
      • Exporting projects
      • Importing projects
      • Activating/Deactivating Projects
      • Duplicating Projects
      • Archiving Projects
      • Change workflow
      • Changing Workflows (Several Documents)
    • Documents
      • Adding a document
      • Adding a target language
      • Aligning Existing Translations
        • Execution
        • Manual corrections
        • Intermediate States
      • Document Formats and Programs
        • Supported Windows Document Formats
        • Supported macOS Document Formats
        • Details of Software Localization
      • Partitioning Documents
      • Locking and Hiding Text
      • Redoing Document Versions
      • Deleting a Document Version
      • Pre-translations
      • Machine Translation
        • Machine Pre-translation
        • Configuration of the Systems
      • Document Settings Templates
        • Creation
          • Configuring a DST for Word
          • Configuring a DST for XML
          • Configuring a DST for Conditional XML
        • DST for Converted Documents
        • Assigning DST
      • Checking out Documents
    • Reports
      • Reports
      • Price Calculation
        • Example 1
        • Example 2
        • Example 3
        • Example 4
      • Word Count in Across
      • Report Types
      • Creation
        • Creating an Edit Distance Report
        • Creating a Comments Overview Report
      • Update Report
      • Customization
    • Tasks
      • Priorities and Due Dates
      • Reports
      • View
      • Assignment
        • Assignment to Crowds
      • Non-Matching Users
      • Unassignment
    • Quality management
      • Quality Management View
      • QM Criteria
        • QM Criteria (QM v7.0)
        • QM Templates (v7.0)
        • General (QM v6.3)
        • SGML, XML, and XLIFF (QM v6.3)
        • Windows Resources (QM v6.3)
        • .NET Resources (QM v6.3)
        • Display Text (QM v6.3)
      • Manage QM Criteria
      • Integrating QM criteria
      • Expanding the QM Check (QM v7.0)
      • Deactivating QM Criteria
      • Connecting External QM Tools
    • Formats
      • View
      • Creating Templates
      • Editing Templates
    • The Project Archive
      • Restoring
    • crossGrid
      • View
      • Reporting
      • Rights Control
      • Transmission History
      • Availability of Entries
      • Package delegation
        • Assembling Data
        • Packaging Templates
          • Provide Entries
        • Creation and Delegation
          • Delegation
        • Retrieval
          • User-Defined Workflows
        • Delivery
        • Importing Data (v6.3)
    • Project Management Cockpit
      • Context Menus
      • Customization
      • Functions
      • Queries
    • The Filter Editor
    • crossAnalytics
    • Linguistic Supply Chain Management (LSCM)
      • Basic Information
      • Opening LSCM
      • User Interface
      • Generating Price Lists
      • Mapping Price Lists
      • Creating a Report
      • Generating Price Comparisons
    • crossWAN Project Management
      • Data Preparation and Export
      • Data Processing
      • Task Export
      • Task Import
      • Importing Data (v6.3)
    • Partitioning
    • Relay Translations
      • Assignment
      • Execution
    • Document preparation
    • Term Extraction and Term Translation
      • Term Extraction
        • Icons and Keyboard Shortcuts
      • Term Translation
        • Icons and Keyboard Shortcuts
    • External Editing of Documents
      • Execution
    • The EN 15038 Standard Workflow
    • The ISO 17100 Standard Workflow
    • crossConnect for External Editing
      • Activation
    • Finishing pre-translated tasks automatically
  • Task Processing
    • Working in crossDesk
      • Using crossWeb
      • Text Display
      • Editable Fields vs. Placeables
      • Using Tags
      • Translating Documents
    • Paragraph States
      • Change
    • Empty Paragraphs
    • Modes
      • Correction Mode
    • Customizing crossDesk
    • Tasks in Across
      • Confirming/Rejecting Tasks
      • Concurrently Opening Multiple Tasks
      • Closing Tasks
      • Finishing Tasks
    • Comments
    • Bookmarks
    • Paragraph Numbering
    • Sorting Paragraphs
    • Context View/Source View
      • Date, Time, and Number Formats
      • Number Control
      • Joining Paragraphs
    • crossTerm Window in crossDesk
    • crossView
      • Modes
      • Change History
        • Restoring Old Paragraph Versions
    • Fuzzy search
    • Concordance search
    • crossSearch
    • Spell-check and User Dictionary
    • Pre-translations
    • Store Translations Wizard
    • The Target Editor
      • Automatically Inserting crossTank Entries
      • Automatically Inserting Repetitions
      • Adding Translations to crossTank
      • Creating a Term During Translation
      • Auto-completion
      • Fields
      • Objects and Images
      • Special Characters and Symbols
      • Sentence Detection and Segments
        • Editing Segments
    • Preview
    • QM Check in crossDesk
      • Usage (QM v7.0)
      • Mandatory Criteria
      • QM Batch Mode
    • Search and Replace
    • Correction
      • Correcting Translations
    • Reviews
    • Redelegation to the Translator
    • Quick Translate
      • Translating with Quick Translate
      • Finishing Quick Translate Tasks
    • Local Data in the Offline Client
  • crossWAN
    • About crossWAN
      • crossWAN Online
      • crossWAN Load
      • crossWAN classic
      • crossWeb for Offline Users
    • Retrieving Tasks
    • Delivering Tasks
  • TM Management
    • The crossTank Manager
      • Rich Translation Memory
        • Exchange Formats
      • Context matches
      • Structure Matches
      • Context-Independent Translations
      • Usage History
      • Auto-Changes and Auto-Adjustments
    • Adding Translations
    • Editing Translations
    • Changing the Status of Translations
    • Merging Translations
    • Deleting Translations
    • Protecting Translations
      • Translation Units
      • Paragraphs in Connection with Pre-Translations
      • Protected Paragraphs in Across Reports
      • Rights Control
    • Searching for Translations
      • Search and Replace
    • Generating a crossTank Summary
    • crossTank Import
      • Mapping Import Data
      • Import Templates
      • Import Statistics
      • TMX Import and Server Context
      • Importing translation memories
        • TM Import Functions
    • crossTank Export
      • Exporting translation memories
    • crossTank Maintenance
      • Changing Attributes
      • Deleting Entries
      • Removing Redundant Translations
      • Changing the Attributes of Multiple Entries
      • Removal of Duplicates
      • Identifying Unused Entries
  • Terminology Management
    • Concept-Oriented Terminology System
    • Definitions
      • What is an entry?
    • The crossTerm Manager
    • crossTerm settings
      • crossTerm Instances
        • Management
      • Entries
        • Indexes
        • Text fields
          • Standard text fields
        • Picklists
          • Standard picklists
        • System attributes
        • Attachments
        • Groups
          • Creation
      • Terms
      • Template Management
        • Entry templates
        • Term templates
      • Tooltip Administration
        • Data Categories
        • crossTerm Instances
        • Administrative Index Information
        • Definitions
    • crossTerm Manager User Interface
      • Modes & Layouts
        • User-Defined Layouts
      • Search Area and Hit List Display
      • Concept-Oriented Information
      • Source-Language Terms
      • Target-Language Terms
      • Additional Information
    • Searching for Entries/Terms
      • Search Types
        • Term search
        • Fuzzy search
        • Entry search
        • Keyword search in definitions
        • Concordance search
        • Index search
      • Display of Search Suggestions
      • Quick Filters
      • Filters and Filter Sets
        • Creating User-Defined Filters
        • Creating Filter Sets
        • Public and Non-Public Filters and Filter Sets
        • Search Criteria
        • Logical Operators and Groupings
      • Stemming
        • Language Administration
    • Entry and term elements
      • Add entry and term
        • Superscript & Subscript
      • Homographs
      • Quick Add Terms
      • Indexes
        • Index usage
        • Standalone Entries
          • Creation
        • Index Duplicates
        • Index set up
        • Creating bibliographic entries
        • Creating cross-references to bibliographic entries
      • Cross-References
        • Index Cross-References
        • Entry IDs
        • Check
      • Hyperlinks
    • Editing Entries/Terms
    • Delete Entries/Term(s)
    • Merging Entries
    • Duplicating Entries
    • Manual correction
    • crossTerm Reports
      • Terminology Reports
      • Entry Reports
      • Summaries
        • Generating Entry Summaries
        • Generating Term Summaries
    • crossTerm Import
      • Mapping
      • GUID mapping
      • Templates
      • Log file
        • Creation
      • Exclusion Files
      • Existing Terminology
      • Importing Terminology
        • The TBX format
          • Import
        • The CSV Format
          • Import
          • Preparations
          • Mapping
        • Star Martif import
        • The MultiTerm format
          • Import
    • crossTerm Export
      • Templates
      • Exporting Terminology
    • crossTerm Data Maintenance
      • Execution
    • crossTerm Web
      • Homographs
      • Sending Comments
      • Logging of Unsuccessful Searches
      • Opening crossTerm Web
        • Anonymous access
        • Login via Windows Authentication
      • Working with crossTerm Web
        • Creating an entry
        • Edit entry
        • Delete entry
        • Search
          • Concordance search
          • Search for entry
          • Search for terms
          • Keyword search in definitions
          • Auto-completion
        • Settings
      • crossTerm Web Rights
        • Editing
        • Interaction of Rights
      • crossTerm Web Suggestion Module
        • Controlling the Access
        • Suggesting terms
        • Further processing of term suggestions
      • crossTerm Web Skins
    • crossMining
    • crossSearch
  • Browser-based Work
    • Working Browser-based with crossWeb
      • Browser Settings
      • Login
      • Customization
      • User Settings
        • General
        • crossDesk Web
      • My Tasks
      • Terminology
      • crossView
    • Project Management
      • Projects
      • Tasks
      • Creating Projects
      • Document Check-out
    • Translation
      • crossDesk Web
        • Customization
      • Finishing Tasks
      • Source Languages as Reference
    • Review
      • Review Mode
      • Standard Mode
      • Reviewing Translations
    • External Document Editing
  • Editing of Special Formats
    • HTML Documents
      • Tagged HTML
    • XML Documents
      • Visual XML vs. Tagged XML
      • Tagged XML v2
      • Consideration of DTDs and XSDs
      • Encoding
      • XHTML Documents
    • SGML Documents
    • FrameMaker Documents
      • MIF Documents
      • Translating MIF Documents
        • MIF Elements
        • Creating Previews
      • Font Mapping
        • Font mapping
    • Word Documents
      • Editable Fields vs. Placeables
      • Linked Objects
      • Bookmarks
      • Change tracking (DOCX)
        • Usage
      • Hidden Text (DOCX)
      • Document Properties (DOCX)
    • TXT Documents
      • Encoding
    • Excel Documents
      • Processing
      • Formulas, Numbers, and Dates
    • PowerPoint documents
    • InDesign and InCopy Documents
      • Conversion
      • Translations of special formats
      • Kerning and Tracking
      • Tagged XML or Visual XML
      • Set Visual XML
      • Previews
    • QuickSilver documents
      • Translation
      • Icons
      • Centrally Defined Components
      • Sanity Check of Prefix Components
    • PO Documents
      • Processing
      • Extraction of Translation Units
    • MC Documents
    • XLIFF Documents
      • Bilingual XLIFF Files
      • Cloneable Elements
      • Paired Elements
      • QM Check (QM v6.3)
    • crossTransform
      • Extension
      • Setup
      • Adding Formats
    • Software Localization
      • Quality Management (QM v6.3)
      • Customizing Shortcut Keys
      • Localizing Dialog Boxes
        • Customizing Dialog Elements and Buttons
      • Localizing Menus
      • Localizing String Tables
        • Displaying String IDs
    • Localization of mobile apps
    • Localizing Display Texts
      • The Across-Specific DTXML Format
      • Localizing Display Texts in crossDesk Web
  • Menus, Icons, and Keyboard Shortcuts
    • Reference: Icons
      • Across Client
      • crossDesk
        • crossView
          • Software Localization
          • MIF Documents
          • QuickSilver Documents
        • Context View/Source View
        • Target Editor
        • Search Center
        • crossTerm
        • Status Bar
      • crossTank Manager
      • crossTerm Manager
      • crossWeb
        • Paragraph States
        • crossView
        • Context View/Source View
        • Target Editor
        • Search Center
        • crossTerm
      • Alignment
      • Term Extraction & Translation
    • Reference: Keyboard Shortcuts
      • General
      • crossDesk
      • crossTank
      • crossTerm
      • crossDesk Web
    • Reference: Menus
      • File
      • View
      • Tools
      • Help
      • crossTank Manager
      • crossTerm Manager
    • Reference: Context Menus
      • Projects and Tasks
      • Users
      • crossDesk
      • crossTerm Manager
      • crossWeb

System Settings: DST > Excel 2000-2003

In the Excel 2000-2003 section, you can manage templates for the processing of XLS files.

Excel documents often contain lots of numbers and relatively little text to translate. To "filter out" the text and make the translator's job easier and more efficient, Excel templates can be created in which rows, columns and ranges can be defined that are either hidden from the translator or visible, but locked. To reduce the load placed on system resources you can also specify that these ranges are not checked in. In this way, the check-in and processing times can be reduced considerably.

Excel documents can also contain columns with various languages, of which only one language is meant to be translated (to prevent crossTank from being filled with incorrect terms). In this case too, the creation of Excel templates can reduce the amount of work and improve quality control at the same time.

General tab

On the General tab you can define how the areas of an Excel document are displayed in crossDesk. This makes it possible, for example, to ignore columns and rows consisting of numbers only that do not require translation. You can also select whether to allow the translator to see these areas or not.

By clicking Add, you can add an area to the currently selected template and select how it should be displayed in Across.

First specify whether the new area should be defined on the basis of rows, columns, context, numbers, objects or worksheets:

Row
If Row is selected, enter a row number (e.g. 1) or a row range (e.g. 1-3) in the input field.
Column
If Column is selected, enter a column in the input field (e.g. A) or a column range (e.g. A-C).
Context
After selecting Context, specify a cell range in the input field. To do this, you can use regular expressions (e.g., ^[0-9]+$ for every cell that only contains one number). You can also select one of the predefined templates for frequently used regular expressions. Then click Insert and adapt the regular expression to your requirements, if necessary.
Image
see the notes below
Object
see the notes below
Worksheet
Under Worksheet, enter the name of the worksheet in the input field (e.g., Table2).

You can then specify whether each area is locked, hidden or ignored. If you select Ignore the corresponding area will not be considered when checking in the document, putting less pressure on system resources and for that reason cannot be viewed by the project manager or be made visible at a later date.

When selecting the Row, Column or Context, you can restrict the new range to individual worksheets by entering the respective name (e.g., Table2). If you do not enter anything in the input field, the setting will apply to all worksheets in the particular Excel file.

Hiding images and objects

You can also define how images and objects contained in an Excel document are displayed by using Excel templates. These can be hidden for the translator:

In order to do this, click Add then go to Filter type and select the option Images or Objects. Then define how the selected elements should be treated. Using the drop-down list, go to Action and select between Lock, Hide or Ignore. If you select Lock, the selected elements are visible for the translator in crossDesk, but cannot be edited. If you select Hide, the elements will not be visible to the translator. If you select Ignore, the images or objects will not be taken into consideration when checking in the document. This relieves the system load, but the ignored items cannot be viewed by the project manager or made visible at a later date.

Danger

Objects are elements that require the use of an external application in order to edit them, e.g. an image editing program. Images are elements that can be edited using Excel.

You can use the following characters to define ranges of rows or columns:

Area
Description
x-y
Section of row/column x up to row/column y
x, y
Row/column x and row/column y
x; y
Row/column x and row/column y

Click Edit to customize existing range and Delete to remove them.

The following icons are used to display the various ranges:

Icon
Description
icn_dst_excel_zeile
Row
icn_dst_excel_spalte
Column
icn_dst_excel_kontext
Context
icn_dst_excel_bilder
Images
icn_dst_excel_objekte
Objects
icn_dst_excel_tabellenblatt
Worksheet

Use the icn_sortierung_runter and icn_sortierung_hoch icons to sort the areas.

Moreover, you can determine whether hidden areas in the Excel document are to be hidden or displayed in Across, too.

Hiding numbers and dates

By default, numbers and dates are displayed in crossDesk. The displayed numbers and dates are locked, as they are usually not translated. By activating the corresponding option, you can determine that numbers and dates contained in Excel files are to be hidden in crossDesk. If the option is activated, numbers and dates will not be displayed in crossDesk. In contrast, if the option is deactivated, numbers and dates will be displayed in crossDesk.

Excel files processing type

In addition, you can define how Excel files are to be processed and displayed in crossDesk. You can determine whether the files are to be processed by columns or by rows. While processing by columns, first column A with row 1 to n is processed, then column B with rows 1 to n and so on. If the text flow follows the rows, the files can also be processes by rows. Accordingly, first row 1 with columns A to n is processed, then row 2 with columns A to n and so on.

The following Excel file is processed differently:

drittprogramm_ms-excel_quelldatei

Depending on the processing method, the file is checked in differently and displayed accordingly in crossDesk:

Processing by columns:
Processing by rows:
drittprogramm_ms-excel_quelldatei_verarbeitung-nach-spalten
drittprogramm_ms-excel_quelldatei_verarbeitung-nach-zeilen
Presentation in crossDesk:
cDesk_source-view_darstellung-excel_verarbeitung-nach-spalten
cDesk_source-view_darstellung-excel_verarbeitung-nach-zeilen

Using the Advanced button, you can determine whether meta information is to be entered in the properties of the current version. Every Excel document can contain meta information such as title and author of the document. In Excel 2003, these are available under File > Properties.

Additionally, you can determine whether hidden worksheets and hidden rows, columns, and cells are to be checked in and translated.

Register for our Newsletter now

Our newsletter provides you with exclusive news about the Across Language Server, often even before the official announcement. The newsletter also provides you with early information on events, webinars, and training sessions.

  • Legal Notice
  • GTC
  • Privacy Statement
  • Cookies
  • info@across.net