Settings in Excel – read version: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „Here you determine the properties of the read version (see Create read version). The following settings are available: TBD == Read version settings == Date…“) |
Keine Bearbeitungszusammenfassung |
||
| (5 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
Here you determine the properties of the read version (see Create read version). The following settings are available: | Here you determine the properties of the read version (see [[Additional_export_functions#Create_a_read_version|Create read version]]). The following settings are available: | ||
== Read version settings == | == Read version settings == | ||
[[Datei: | [[Datei:EN Excel firesys Einstellungen Leseversion.jpg|mini|upright=2.0|The view of the read settings in Excel]] | ||
=== Remove all comments === | === Remove all comments === | ||
| Zeile 29: | Zeile 29: | ||
== See also == | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[The_settings_in_firesys|The setting menus in firesys]] <br> | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[Settings_in_Excel|The firesys settings in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Settings_in_Excel_–_dictionary|The dictionary settings in firesys]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Settings_in_Excel_–_versioning_the_workbook|The versioning settings in Excel]] <br> | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie: | [[Kategorie:The firesys basic functions-Einstellungen in Excel]] | ||
Aktuelle Version vom 21. Februar 2020, 14:50 Uhr
Here you determine the properties of the read version (see Create read version). The following settings are available:
Read version settings
Remove all comments
Removes comments that were entered via Excel’s editing/commenting function.
Remove all formulas
Activate this function if you want to remove the calculations, rounding and links in the tables and only want the numbers in the tables. The formulas for the dictionary are always removed when creating a read version.
Hidden rows and columns within the print area are not imported but deleted when uploading Excel tables to Word.
Remove worksheets without print area
Removes worksheets without a print area. Since print areas are required for the dictionary, such sheets usually do not contain any tables that are appropriate for display.
Sheets with print area only keep print area
Removes all cells of a sheet except the print area.
Only keep dictionary in print area
Removes all numbers and replaces them with Xs in the print area of a sheet.
See also
The setting menus in firesys
The firesys settings in Excel
The dictionary settings in firesys
The versioning settings in Excel