The synopses worksheet and hits

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen

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