The worksheet inspector: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(5 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
The worksheet inspector provides quick access to firesys-relevant information relating to your Excel worksheet. It docks itself to your Excel document as a work area. By default, the worksheet inspector opens automatically with your firesys document. You can disable this function in the Settings.  
The worksheet inspector provides quick access to firesys-relevant information relating to your Excel worksheet. It docks itself to your Excel document as a work area. By default, the worksheet inspector opens automatically with your firesys document. You can disable this function in the [[The_worksheet_inspector#Settings|Settings]].
 
 
[[Datei:EN_Menüband_Excel_Status_Information_Blatt-Inspektor.jpg|center|1200px]]




<imagemap>Datei:EN-Excel Status Menüband-Blatt-Inspektor.jpg|1200px|center
rect 3 85 219 203 [[The_basic_functions_of_firesys]]
rect 224 85 511 202 [[The_StatusCockpit]]
rect 515 85 593 201 [[The_worksheet_inspector]]
rect 597 86 721 202 [[Coloured_highlighting_in_Excel]]
rect 725 86 800 200 [[The_worksheet_navigator]]
rect 802 85 885 200 [[The_worksheet_status]]
rect 890 83 1108 201 [[The_rolling_forward_function]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
</imagemap>




Zeile 20: Zeile 12:




[[Datei:EN-Excel Status Blatt-Inspektor.jpg|center|750px]]
[[Datei:EN_Excel Status Blatt-Inspektor.jpg|center|750px]]
 


  Below is a list of all parameters that are checked:  
<p>
  Below is a list of all parameters that are checked: </p>


=== Excel file ===
=== Excel file ===
Zeile 33: Zeile 25:
: ''The date when the currently open Excel file was last saved''
: ''The date when the currently open Excel file was last saved''


[[Datei:Dummysymbol.png|link=|16px]] Calculation options of the workbook   
[[Datei:White Icon.jpg|link=|16px]] Calculation options of the workbook   
: ''Displays the calculation option that is selected in Excel for the current workbook. You can change the setting in the “Calculation” group in the “Formulas” Excel ribbon''
: ''Displays the calculation option that is selected in Excel for the current workbook. You can change the setting in the “Calculation” group in the “Formulas” Excel ribbon''


[[Datei:Dummysymbol.png|link=|16px]] Hidden worksheets in the workbook  
[[Datei:White Icon.jpg|link=|16px]] Hidden worksheets in the workbook  
: ''This icon is displayed if your workbook contains hidden worksheets''
: ''This icon is displayed if your workbook contains hidden worksheets''


Zeile 52: Zeile 44:
: ''The file name of the currently open Excel file''
: ''The file name of the currently open Excel file''


[[Datei:Dummysymbol.png|link=|16px]] Worksheet protection  
[[Datei:White Icon.jpg|link=|16px]] Worksheet protection  


[[Datei:Dummysymbol.png|link=|16px]] Hidden rows  
[[Datei:White Icon.jpg|link=|16px]] Hidden rows  


[[Datei:Dummysymbol.png|link=|16px]] Hidden columns  
[[Datei:White Icon.jpg|link=|16px]] Hidden columns  


[[Datei:Dummysymbol.png|link=|16px]] Excel errors  
[[Datei:White Icon.jpg|link=|16px]] Excel errors  


[[Datei:Dummysymbol.png|link=|16px]] Cells with “####”  
[[Datei:White Icon.jpg|link=|16px]] Cells with “####”  


=== Validation ===
=== Validation ===


[[Datei:Dummysymbol.png|link=|16px]] Number of validations  
[[Datei:White Icon.jpg|link=|16px]] Number of validations  


[[Datei:Dummysymbol.png|link=|16px]] Validations with deviations  
[[Datei:White Icon.jpg|link=|16px]] Validations with deviations  


[[Datei:Dummysymbol.png|link=|16px]] Defective validations  
[[Datei:White Icon.jpg|link=|16px]] Defective validations  


=== Dictionary ===
=== Dictionary ===


[[Datei:Dummysymbol.png|link=|16px]] Cells with translations  
[[Datei:White Icon.jpg|link=|16px]] Cells with translations  


[[Datei:Dummysymbol.png|link=|16px]] Missing translations  
[[Datei:White Icon.jpg|link=|16px]] Missing translations  




Zeile 111: Zeile 103:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = The worksheet inspector display may vary depending on which options you selected.
|Gutzuwissen = The worksheet inspector display may vary depending on which options you selected.
Zeile 122: Zeile 114:
[[Datei:Navigation_rechts.svg|link=]] [[The_StatusCockpit|The StatusCockpit]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_StatusCockpit|The StatusCockpit]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_navigator|The worksheet navigator]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_navigator|The worksheet navigator]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status|The worksheet status in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status|The worksheet status]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_rolling_forward_function|The rolling forward function]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_rolling_forward_function|The rolling forward function]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Coloured_highlighting_in_Excel|Coloured highlighting in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Coloured_highlighting_in_Excel|Coloured highlighting in Excel]]  <br>

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

The worksheet inspector provides quick access to firesys-relevant information relating to your Excel worksheet. It docks itself to your Excel document as a work area. By default, the worksheet inspector opens automatically with your firesys document. You can disable this function in the Settings.


EN Menüband Excel Status Information Blatt-Inspektor.jpg



An overview of the functions of the worksheet inspector

You can use the worksheet inspector to identify errors or inconsistencies in a practical overview by using coloured icons and overview lists showing additional information.


EN Excel Status Blatt-Inspektor.jpg

Below is a list of all parameters that are checked:

Excel file

White Icon.jpg File name

The file name of the Excel file that is currently open

White Icon.jpg Save date

The date when the currently open Excel file was last saved

White Icon.jpg Calculation options of the workbook

Displays the calculation option that is selected in Excel for the current workbook. You can change the setting in the “Calculation” group in the “Formulas” Excel ribbon

White Icon.jpg Hidden worksheets in the workbook

This icon is displayed if your workbook contains hidden worksheets

Worksheet

White Icon.jpg Name

The name of the currently open worksheet

White Icon.jpg Used range

The range of the current workbook in which you have defined ranges is displayed here. If you have defined several ranges, the ranges are summarised.

White Icon.jpg Print area

The range of the current workbook that you have defined as the print area is displayed here.

White Icon.jpg Status

The current status of the worksheet

White Icon.jpg Rolled forward

The file name of the currently open Excel file

White Icon.jpg Worksheet protection

White Icon.jpg Hidden rows

White Icon.jpg Hidden columns

White Icon.jpg Excel errors

White Icon.jpg Cells with “####”

Validation

White Icon.jpg Number of validations

White Icon.jpg Validations with deviations

White Icon.jpg Defective validations

Dictionary

White Icon.jpg Cells with translations

White Icon.jpg Missing translations


Glühbirne neu.png
Good to know

Information that is not relevant remains hidden in the worksheet inspector. If you are not using any validations or translations on the current worksheet, these elements are not visible.


Settings

The view of the settings in the worksheet inspector

You will find the settings for the worksheet inspector in the second tab in the menu ribbon.

General

Start after activating firesys

You can close the worksheet inspector at any time and use this function to configure that the worksheet inspector is no longer started the next time firesys is activated.

Read out information

The worksheet inspector displays the information shown above from various firesys components. This information can also be read out dynamically.

Read out when changing the worksheet

If you select this option, another settings level appears in which you can define which information should be read out dynamically and displayed in the worksheet inspector. The following options are available:

  • Dictionary and validation cells
  • Hidden rows and columns
  • Cells with Excel errors
  • Narrow columns (###)


Glühbirne neu.png
Good to know

The worksheet inspector display may vary depending on which options you selected.

See also

Navigation hoch.svg The worksheet status in Excel
Navigation rechts.svg The StatusCockpit
Navigation rechts.svg The worksheet navigator
Navigation rechts.svg The worksheet status
Navigation rechts.svg The rolling forward function
Navigation rechts.svg Coloured highlighting in Excel

Further contents

firesys website
Customer area
YouTube