• 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
  • ATE
  • Editing of Special Formats
  • Excel Documents
  • Formulas, Numbers, and Dates
  • Release Notes v7.0
    • Across v7 15960
    • Across v7 15954
    • Across v7 15934
    • Across v7 15921
    • Across v7 15918
    • Across v7 15911
  • Installation and Administration
    • About Across Translator Edition
    • Installation of the Across Translator Edition
    • Connection to Across Account
    • Activation of the Across Translator Edition
    • Functions of the Across Translator Edition
    • Data Synchronization/Migration of the Across Translator Edition
      • Data Synchronization/Migration of the Translator Edition
      • Data Synchronization with the Offline Client
    • Backing up Data of the Translator Edition
    • Restoring Translator Edition Backups
    • Uninstalling the Across Translator Edition
  • Getting Started
    • Structure and Architecture
      • TMS Functionality
      • Across Support and Across Services
      • Repetitions
    • Basic Decisions
      • Rich Translation Memory
    • Logging in
      • Across Translator Edition
        • Translator Edition Login
        • Logging in to Offline Client
    • crossBoard
      • Dashboard
        • Adding Dashlets
        • Customizing Dashlets
    • Change username/password
    • Confirming and Opening Tasks
    • Internal Communication
      • Message Administration
  • System Management
    • Relations
      • Creation
    • Languages
    • Fonts
    • User settings
      • The "General" Section
        • General
        • crossSearch
          • Customization and Extension
        • Dialog Settings
        • Project Wizard Options
        • Spell-Check
          • Adding a Hunspell Dictionary
        • Fonts
        • Languages
        • Preview
      • crossDesk Area
        • crossTank
        • crossTerm
        • crossView
        • Contrast Formatting
        • Quality Management
        • Source/Context View
        • Target Editor
      • Customizing Shortcut Keys
    • System settings
      • crossTank
      • Quality Management v6.3
        • Configuring the crossTerm Check
      • Quality Management v7.0
        • QM Check with Regular Expressions
      • System Attributes
        • User-Defined Creation
      • Stopwords
      • 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
      • Word 2000-2003
        • Show/Hide Style Elements
      • Word 2007-2016
      • XLIFF
    • System attributes
  • Project Management
    • Projects
      • Project View
      • Project settings
      • Functions of the Module
      • Project Search
        • Search and Replace
      • Project creation
        • Execution
      • Adding attachements
      • Document and Project Updates
        • Execution
      • Project status
      • Exporting projects
      • Importing projects
      • Duplicating 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
      • 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
      • Report Types
    • Quality management
      • QM Criteria
        • QM Criteria (QM v7.0)
        • QM Templates (v7.0)
        • 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
    • The Filter Editor
    • Partitioning
    • Relay Translations
      • Execution
    • Document preparation
    • Term Extraction and Term Translation
      • Term Extraction
    • External Editing of Documents
      • Execution
    • The EN 15038 Standard Workflow
    • The ISO 17100 Standard Workflow
    • Cost Estimates
  • Task Processing
    • Working in crossDesk
      • Using Tags
    • Paragraph States
    • Empty Paragraphs
    • Modes
    • Customizing crossDesk
    • Tasks in Across
      • Concurrently Opening Multiple Tasks
    • Comments
    • Bookmarks
    • Paragraph Numbering
    • Sorting Paragraphs
    • Context View/Source View
    • crossTerm Window in crossDesk
    • crossView
    • Fuzzy search
    • Concordance search
    • crossSearch
    • Spell-check and User Dictionary
    • Pre-translations
    • Store Translations Wizard
    • The Target Editor
      • Adding Translations to crossTank
    • Preview
    • QM Check in crossDesk
    • Search and Replace
    • Correction
      • Correcting Translations
    • Reviews
    • Redelegation to the Translator
    • Quick Translate
      • Translating with Quick Translate
    • Local Data in the Offline Client
  • crossWAN
    • About crossWAN
      • crossWAN Online
      • crossWAN classic
    • Retrieving Tasks
    • Delivering Tasks
  • TM Management
    • The crossTank Manager
    • Adding Translations
    • Editing Translations
    • Changing the Status of Translations
    • Merging Translations
    • Deleting Translations
    • Protecting Translations
    • Searching for Translations
    • Generating a crossTank Summary
    • crossTank Import
    • crossTank Export
      • Exporting translation memories
    • crossTank Maintenance
      • Changing Attributes
  • Terminology Management
    • Concept-Oriented Terminology System
    • Definitions
    • The crossTerm Manager
    • crossTerm settings
    • crossTerm Manager User Interface
    • Searching for Entries/Terms
      • Search Types
        • Term search
        • Fuzzy search
        • Entry search
        • Keyword search in definitions
        • Concordance search
        • Index search
      • Display of Search Suggestions
      • 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
      • 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
    • Editing Entries/Terms
    • Delete Entries/Term(s)
    • Merging Entries
    • Duplicating Entries
    • Manual correction
    • crossTerm Reports
      • Terminology Reports
      • Entry Reports
    • crossTerm Import
    • crossTerm Export
      • Exporting Terminology
    • crossTerm Data Maintenance
      • Execution
    • crossTerm Web
      • crossTerm Web Suggestion Module
        • Controlling the Access
        • Suggesting terms
        • Further processing of term suggestions
    • crossMining
    • crossSearch
  • Browser-based Work
    • Working Browser-based with crossWeb
      • Login
      • User Settings
        • crossDesk Web
      • My Tasks
    • Translation
      • crossDesk Web
        • Customization
    • Review
      • Review Mode
      • Reviewing Translations
    • External Document Editing
  • Editing of Special Formats
    • HTML Documents
      • Tagged HTML
    • XML Documents
    • SGML Documents
    • FrameMaker Documents
    • Word Documents
    • TXT Documents
    • Excel Documents
      • Formulas, Numbers, and Dates
    • PowerPoint documents
    • InDesign and InCopy Documents
      • Translations of special formats
    • QuickSilver documents
    • PO Documents
    • MC Documents
    • XLIFF Documents
      • Bilingual XLIFF Files
    • crossTransform
    • Software Localization
      • Localizing Menus
      • Localizing String Tables
    • Localization of mobile apps
    • Localizing Display Texts
      • Localizing Display Texts in crossDesk Web
  • Menus, Icons, and Keyboard Shortcuts
    • Reference: Icons
      • Across Client
      • Term Extraction & Translation
    • Reference: Keyboard Shortcuts
      • General
      • crossDesk
      • crossTank
      • crossTerm
      • crossDesk Web
    • Reference: Menus
      • File
    • Reference: Context Menus
      • Projects and Tasks

Formulas, Numbers, and Dates

Formulas

Formulas, which always begin with the equals sign (=) in Excel, are usually not translated. Therefore, all formulas are ignored when checking in Excel documents. Accordingly, they are not displayed in crossDesk and do not need to be translated.

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. An option in the section of the project settings templates of Excel can be used to determine whether the numbers and dates contained in Excel files are to be hidden in crossDesk. You can activate the option under Tools > System Settings > Document settings > Excel 2000-2003:

sysset_dst_xls_zahlen-und-datum-verbergen

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 (locked) in crossDesk. This option is available for Excel 2000-2013.

Dates in Excel

In Excel, dates are always displayed according to the locale selected on the particular computer. If, for example, a German locale is selected, a date contained in an Excel document will automatically be displayed in the standard German date format in Excel. If the same Excel file is opened on a computer with an English locale, the date will automatically be displayed in the standard English date format.

Hidden Contents

Excel files may have contents that should not be displayed and that are therefore hidden in the Excel files. This may be the case with individual cells as well as entire rows, columns, or spreadsheets.

The document settings templates of Excel feature options for determining whether hidden contents are to be presented in crossDesk and thus be made available for translation.

Format
Information
Path
Excel 2000-2003 (XLS)
By default, hidden content is displayed in crossDesk.
Tools > System Settings > Document settings > Excel 2000-2003
Excel 2007-2016 (XLSX)
You can determine whether hidden worksheets, hidden rows and columns, and hidden cells are to be checked in, making them available for translation.
Tools > System Settings > Document settings > Excel 2007-2016 > Advanced
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