Settings in Word – data from Excel: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 3: | Zeile 3: | ||
=== Update=== | === Update=== | ||
<b> Upon further occurrence, check updated data </b> | |||
If you update a table and a figure changes in the process, the document is checked for other occurrences of this figure. | If you update a table and a figure changes in the process, the document is checked for other occurrences of this figure. | ||
<b> Update data even if the Excel source has not been saved </b> | |||
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. | 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. | ||
Zeile 13: | Zeile 13: | ||
=== Automatically execute typography functions === | === Automatically execute typography functions === | ||
<b> After updating Excel objects </b> | |||
Automatically starts all typography functions once the Excel objects have been updated. | Automatically starts all typography functions once the Excel objects have been updated. | ||
Zeile 19: | Zeile 19: | ||
=== Versioning === | === Versioning === | ||
<b> Version before updating Excel objects. </b> | |||
A version is created before all Excel objects are updated. | A version is created before all Excel objects are updated. | ||
Zeile 25: | Zeile 25: | ||
=== Highlighting === | === Highlighting === | ||
<b> Set highlighting </b> | |||
Highlights changed values in colour when updating from Excel. | Highlights changed values in colour when updating from Excel. | ||
<b> Retain highlighting </b> | |||
When this function is enabled, the document retains already inserted colored highlights when updating data from Excel. | When this function is enabled, the document retains already inserted colored highlights when updating data from Excel. | ||
<b> Transfer highlighting from Excel </b> | |||
Transfers yellow highlighting from Excel to Word. | Transfers yellow highlighting from Excel to Word. | ||
<b> Transfer Excel comments as Word comments </b> | |||
Comments that are saved in Excel cells are transferred to Word. (This function is only available in a story.) | Comments that are saved in Excel cells are transferred to Word. (This function is only available in a story.) | ||
Zeile 43: | Zeile 43: | ||
=== Hide numbers === | === Hide numbers === | ||
<b> Replace hidden numbers with the following number of Xs </b> | |||
Define how many Xs should replace the hidden numbers. | Define how many Xs should replace the hidden numbers. | ||
Zeile 51: | Zeile 51: | ||
Uses the set number of Xs to hide the contents of all cells on import, which were imported from Excel and only contain 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. | ||
<b> Hide Excel cells with a red background during import </b> | |||
Replaces red Excel cells with the set number of Xs. | Replaces red Excel cells with the set number of Xs. | ||
Zeile 60: | Zeile 60: | ||
=== Table format and structure === | === Table format and structure === | ||
<b> Apply formatting information from Excel </b> | |||
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. | 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. | ||
<b> Transfer highlighting from Excel </b> | |||
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. | 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. | ||
<b> Transfer highlighting from Excel (individual cells) </b> | |||
Automatically transfers the highlighting defined for tables in Word (the highlighting of individual cells) from Excel when the relevant formatting has been done there. | Automatically transfers the highlighting defined for tables in Word (the highlighting of individual cells) from Excel when the relevant formatting has been done there. | ||
<b> Apply strikethrough from Excel </b> | |||
Cells have two diagonal lines through them. These have to be defined beforehand in Excel. | Cells have two diagonal lines through them. These have to be defined beforehand in Excel. | ||
<b> Transfer conditional formatting from Excel </b> | |||
Transfers conditions formatting from Excel to Word when tables are imported | Transfers conditions formatting from Excel to Word when tables are imported | ||
<b> Backgrounds </b> | |||
Transfers the colour scale of the conditional formatting from Excel to Word as a template. | Transfers the colour scale of the conditional formatting from Excel to Word as a template. | ||
<b> Font colour </b> | |||
Applies the font colour in the Excel cells to Word. | Applies the font colour in the Excel cells to Word. | ||
Zeile 97: | Zeile 97: | ||
<b> Symbols </b> | |||
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. | 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. | ||
<b> Transfer direct formatting from Excel </b> | |||
Transfers direct formatting for cells or characters directly from Excel: | Transfers direct formatting for cells or characters directly from Excel: | ||
Zeile 111: | Zeile 111: | ||
: Vertical alignment | : Vertical alignment | ||
<b> Ignore rows and columns with the following marks when updating tables </b> | |||
When importing and updating from Excel, rows and columns with an “X” or “Y” in front or above them are ignored. | When importing and updating from Excel, rows and columns with an “X” or “Y” in front or above them are ignored. | ||
<b> X </b> | |||
When importing and updating from Excel, columns and rows with an X before or above them are ignored. | When importing and updating from Excel, columns and rows with an X before or above them are ignored. | ||
<b> Hide temporarily </b> | |||
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. | 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. | ||
Zeile 132: | Zeile 132: | ||
}} | }} | ||
<b> Y </b> | |||
During importing and updating from Excel, columns and rows with a Y before or above them are ignored. | During importing and updating from Excel, columns and rows with a Y before or above them are ignored. | ||
<b> Hide temporarily </b> | |||
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. | 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. | ||
Zeile 150: | Zeile 150: | ||
=== Data in text === | === Data in text === | ||
<b> Number format differs from tables </b> | |||
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. | 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. | ||
Zeile 156: | Zeile 156: | ||
=== Translation === | === Translation === | ||
<b> Save data in the text and make it compatible with Trados </b> | |||
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. | 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 [https://www.firesys.de/fileadmin/user_upload/Download-Dateien/Moduluebersicht/Moduluebersicht_-_Einzelseiten_EN/firesys_linkdocuments_EN.pdf linkdocuments] for the master and all stories. | This option is document-specific and should be used consistently with [https://www.firesys.de/fileadmin/user_upload/Download-Dateien/Moduluebersicht/Moduluebersicht_-_Einzelseiten_EN/firesys_linkdocuments_EN.pdf linkdocuments] for the master and all stories. | ||
<b> Import translation from dictionary </b> | |||
Uses the dictionary (synopsis worksheet) from [https://www.firesys.de/fileadmin/user_upload/Download-Dateien/Moduluebersicht/Moduluebersicht_-_Einzelseiten_EN/firesys_languagewords_EN.pdf languagewords] to automatically translate text in tables and data in text during updating, without needing to change the language in Excel. | Uses the dictionary (synopsis worksheet) from [https://www.firesys.de/fileadmin/user_upload/Download-Dateien/Moduluebersicht/Moduluebersicht_-_Einzelseiten_EN/firesys_languagewords_EN.pdf languagewords] to automatically translate text in tables and data in text during updating, without needing to change the language in Excel. | ||
<b> Language </b> | |||
Here you will see the defined languages from your document. | Here you will see the defined languages from your document. | ||
<b> Dictionary columns </b> | |||
Here you can select which dictionary column should be assigned to which language. | Here you can select which dictionary column should be assigned to which language. |
Version vom 14. Mai 2021, 09:52 Uhr
Data from Excel (general)
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
When this function is enabled, the document retains already inserted colored highlights when updating data 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)
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.
![]() |
Good to know
|
---|---|
This function is only available in the context of conditional formatting. |
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
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 linkdocuments for 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