Settings in Word – data from Excel

Data from Excel (general)

The view of general settings

Update

Upon further occurrence, check updated data

If you update a table and a figure changes in the process, the document is checked for other occurrences of this figure.

Update data even if the Excel source has not been saved

If you make a lot of format and structural changes in Excel and it takes a long time to save the Excel file due to the network and/or file size, you can enable this option to manually save the file once you have made all the changes. We recommend that you minimise your use of this option to ensure that only saved data is entered in the report.

Automatically execute typography functions

After updating Excel objects

Automatically starts all typography functions once the Excel objects have been updated.

Versioning

Version before updating Excel objects.

A version is created before all Excel objects are updated.

Highlighting

Set highlighting

Highlights changed values in colour when updating from Excel.

Retain highlighting

Highlights changed values in colour when updating from Excel.

Transfer highlighting from Excel

Transfers yellow highlighting from Excel to Word.

Transfer Excel comments as Word comments

Comments that are saved in Excel cells are transferred to Word. (This function is only available in a story.)

Hide numbers

Replace hidden numbers with the following number of Xs

Define how many Xs should replace the hidden numbers.

Hide all numbers

Uses the set number of Xs to hide the contents of all cells on import, which were imported from Excel and only contain numbers.

Hide Excel cells with a red background during import

Replaces red Excel cells with the set number of Xs.

Data from Excel (table format and structure)

The view of the table format and structure settings in Word

Table format and structure

Apply formatting information from Excel

Applies formatting information on update for row types which were previously defined in Excel and adjusts the number of rows in the Word table to the Excel source.

Transfer highlighting from Excel

Automatically transfers the highlighting defined for tables in Word (the highlighting of individual columns or lines) from Excel when the relevant formatting has been done there.

Transfer highlighting from Excel (individual cells)

Automatically transfers the highlighting defined for tables in Word (the highlighting of individual cells) from Excel when the relevant formatting has been done there.

Apply strikethrough from Excel

Cells have two diagonal lines through them. These have to be defined beforehand in Excel.

Transfer conditional formatting from Excel

Transfers conditions formatting from Excel to Word when tables are imported

Backgrounds

Transfers the colour scale of the conditional formatting from Excel to Word as a template.

Font colour

Applies the font colour in the Excel cells to Word.

Symbols

Transfers the symbols of the conditional formatting from Excel to Word. Here, the symbols are interpreted and presented in Word as formatted characters. You can also decide if the value to the right next to the symbol should be displayed or not.

Transfer direct formatting from Excel

Transfers direct formatting for cells or characters directly from Excel:

Bold

Italics

Apply indentations

Horizontal alignment

Vertical alignment

Ignore rows and columns with the following marks when updating tables

When importing and updating from Excel, rows and columns with an “X” or “Y” in front or above them are ignored.

X

When importing and updating from Excel, columns and rows with an X before or above them are ignored.

Hide temporarily

In addition to the variant described above, the columns or rows in question are actually hidden in Excel before the update process, and then displayed again later on.

	Good to know
	The “Hide temporarily” function can be combined with the aggregate function in Excel. In this way, you ensure that rows that are hidden by X or Y are taken into account by the formula.

Y

During importing and updating from Excel, columns and rows with a Y before or above them are ignored.

Hide temporarily

In addition to the variant described above, the columns or rows in question are actually hidden in Excel before the update process, and then displayed again later on.

== Number format and translation

The view of number format and translation settings in Word

General

During importing and updating from Excel, apply number format and import absolute value. Here you can determine the initial characters and thousand separator for your tables for up to five languages.

Data in text

Number format differs from tables

Here you can set the initial characters and thousands separator differently for the data in your text, if they differ from the format in the tables.

Translation

Save data in the text and make it compatible with Trados

To avoid data getting lost in the English version of the text, the data in the text is specially handled during saving. This can take some time during opening and saving as well as when updating and writing back stories, depending on the amount of data in the text. This option is document-specific and should be used consistently with linkdocumentsfor the master and all stories.

Import translation from dictionary

Uses the dictionary (synopsis worksheet) from languagewords to automatically translate text in tables and data in text during updating, without needing to change the language in Excel.

Language

Here you will see the defined languages from your document.

Dictionary columns

Here you can select which dictionary column should be assigned to which language.

See also

The setting menus in firesys
The firesys settings in Word
The align with baseline grid settings in Word
The graphic settings in Word

Further contents

→ firesys website
→ Customer area
→ YouTube