The synopses worksheet and hits: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(6 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 2: Zeile 2:




[[Datei:EN-Excel Übersetzung Synopse-&-Fundstelle.jpg.jpg|center|1000px]]
[[Datei:EN_Menüband_Excel_Übersetzung_Fundstellen_Synopsen-Blatt.jpg|1200px|center]]




== [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] The synopses worksheet ==
 
 
== The synopses worksheet ==


The synopses worksheet is automatically created by firesys when you add translations to your Excel document. The synopses worksheet is therefore inserted in the document in first place in the tab. When working with firesys, you can also use the turquoise arrow called “Switch to dictionary” in the “firesys” group to open the synopses worksheet.  
The synopses worksheet is automatically created by firesys when you add translations to your Excel document. The synopses worksheet is therefore inserted in the document in first place in the tab. When working with firesys, you can also use the turquoise arrow called “Switch to dictionary” in the “firesys” group to open the synopses worksheet.  
Zeile 13: Zeile 15:




=== [[Datei:rxdmnuSynopsisManageSort_16.png|link=|16px]] Sort ===
=== [[Datei:RxmnuCellAccountValuesSheetSorting_16.png|link=|16px]] Sort ===


You can sort existing entries in the dictionary/translation manager in alphabetic order in the language you selected.  
You can sort existing entries in the dictionary/translation manager in alphabetic order in the language you selected.  
Zeile 27: Zeile 29:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = Before using the “Delete terms” function, you should first use the “Update hits” function to see the current status of your translation elements.
|Gutzuwissen = Before using the “Delete terms” function, you should first use the “Update hits” function to see the current status of your translation elements.
Zeile 34: Zeile 36:




== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Hits ==
== Hits ==


=== [[Datei:rxbtnSynopsisUpdateHyperlinks_16.png|link=|16px]] Update ===
=== [[Datei:rxbtnSynopsisUpdateHyperlinks_16.png|link=|16px]] Update ===
Zeile 41: Zeile 43:


In firesys, terms in newly added worksheets are accepted into the dictionary or linked with already existing terms provided they occur within the print area. If a worksheet is deleted, the hits for the terms used there are removed and, if the term is no longer used in the entire workbook, it is displayed as crossed out.  
In firesys, terms in newly added worksheets are accepted into the dictionary or linked with already existing terms provided they occur within the print area. If a worksheet is deleted, the hits for the terms used there are removed and, if the term is no longer used in the entire workbook, it is displayed as crossed out.  
If the name of a worksheet is changed, the references in the dictionary to the hits must be adjusted. This is done automatically if the “Check and update hits” option is selected (additional information is available in Settings in the “dictionary” in Excel). If the “Review and update hits” option is deactivated, you can update the hits manually. To do this, click on the “Update” button.  
If the name of a worksheet is changed, the references in the dictionary to the hits must be adjusted. This is done automatically if the “Check and update hits” option is selected (additional information is available in [[Settings_in_Excel_–_dictionary|Settings in the “dictionary”]] in Excel). If the “Review and update hits” option is deactivated, you can update the hits manually. To do this, click on the “Update” button.  


=== [[Datei:rxbtnSynopsisPrevious_16.png|link=|16px]] / [[Datei:rxbtnSynopsisNext_16.png|link=|16px]] Previous hit/next hit ===
=== [[Datei:rxbtnSynopsisPrevious_16.png|link=|16px]] / [[Datei:rxbtnSynopsisNext_16.png|link=|16px]] Previous hit/next hit ===
Zeile 49: Zeile 51:
== See also ==
== See also ==


[[Datei:Navigation_hoch.svg|link=]]  [[Translations_in_Excel|The translation basic functions in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Translations_in_Excel|Translations in Excel | The translation basic functions]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_translation_manager|An overview of the translation manager functions]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_translation_manager|The translation manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_dictionaries_in_firesys|An overview of the firesys dictionaries]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_dictionaries_in_firesys|The dictionaries in firesys]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_translation_basic_functions|The translation basic functions]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_translation_basic_functions|The translation basic functions]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Import_and_export_translations|Import and export translations]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Import_and_export_translations|Import and export translations]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Additional_export_functions|The translation export functions in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Additional_export_functions|Additional export functions]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Übersetzungen-Content]]
[[Kategorie:English-Excel Dokument-Übersetzungen-Content]]

Aktuelle Version vom 19. November 2021, 12:34 Uhr

When you work with firesys in Excel, the translation function is one of the central components. firesys has therefore created a dictionary with approximately 50,000 translations containing terms from the world of finance. If you are using the translation manager in firesys, you can check whether any missing translations for your terms exist in the firesys dictionary. These are then automatically added to your terms from the firesys dictionary. To make working with translations in your document easier, the synopses worksheet was created which displays all available translation elements in your document on a worksheet. Furthermore, it displays the cell in your document in which the translation element is used, called hits.


EN Menüband Excel Übersetzung Fundstellen Synopsen-Blatt.jpg



The synopses worksheet

The synopses worksheet is automatically created by firesys when you add translations to your Excel document. The synopses worksheet is therefore inserted in the document in first place in the tab. When working with firesys, you can also use the turquoise arrow called “Switch to dictionary” in the “firesys” group to open the synopses worksheet.


Excel Übersetzungen Synopsenblatt.jpg


RxmnuCellAccountValuesSheetSorting 16.png Sort

You can sort existing entries in the dictionary/translation manager in alphabetic order in the language you selected.

RxtglbtnSynopsisManageAutoFilter 16.png Activate filter

Activates the Excel function “Filter” for filtering by specific terms on the synopses worksheet. You can this change how the dictionary contents are displayed according to your requirements.

RxbtnSynopsisManageDeleteObsolete 16.png Delete terms

Deletes unused (crossed out) terms from the dictionary. A query dialog appears beforehand, stating the number of terms to be deleted.


Glühbirne neu.png
Good to know

Before using the “Delete terms” function, you should first use the “Update hits” function to see the current status of your translation elements.


Hits

RxbtnSynopsisUpdateHyperlinks 16.png Update

You need this function when you delete or rename worksheets, or if you have removed translation elements from your document and you want to have a current view of the translation elements on the synopses worksheet.

In firesys, terms in newly added worksheets are accepted into the dictionary or linked with already existing terms provided they occur within the print area. If a worksheet is deleted, the hits for the terms used there are removed and, if the term is no longer used in the entire workbook, it is displayed as crossed out. If the name of a worksheet is changed, the references in the dictionary to the hits must be adjusted. This is done automatically if the “Check and update hits” option is selected (additional information is available in Settings in the “dictionary” in Excel). If the “Review and update hits” option is deactivated, you can update the hits manually. To do this, click on the “Update” button.

RxbtnSynopsisPrevious 16.png / RxbtnSynopsisNext 16.png Previous hit/next hit

Navigate from hit to hit from the currently selected translations in your document without having to switch to the dictionary and search for the individual hits yourself.

See also

Navigation hoch.svg Translations in Excel | The translation basic functions
Navigation rechts.svg The translation manager
Navigation rechts.svg The dictionaries in firesys
Navigation rechts.svg The translation basic functions
Navigation rechts.svg Import and export translations
Navigation rechts.svg Additional export functions

Further contents

firesys website
Customer area
YouTube