Configure row types: Unterschied zwischen den Versionen

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




<imagemap>Datei:EN Excel Gestaltung Zeilentypen konfigurieren.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Gestaltung_Formatisierung_StyleGuide.jpg|center|1200px]]
rect 0 70 69 162 [[Overview_of_the_dashboard]]
 
rect 71 69 175 162 [[The_basic_functions_of_firesys]]
rect 180 69 247 162 [[The_StyleGuide_in_Excel]]
rect 251 70 406 163 [[Design_texts_in_Excel]]
rect 400 70 468 162 [[Design_texts_in_Excel#Highlighting]]
rect 471 68 562 161 [[Design_texts_in_Excel#Conditional_formatting]]
rect 566 69 645 162 [[Excel-areas#Print_area]]
rect 648 70 795 89 [[Excel-areas#Name_manager]]
rect 647 93 796 113 [[Excel-areas#X.2FY_ranges]]
rect 647 115 796 136 [[Excel-areas#Empty_areas|]]
rect 802 70 964 159 [[Formulas]]
rect 969 71 1093 162 [[Views_and_comments_in_Excel#View]]
rect 1105 72 1363 161 [[Views_and_comments_in_Excel#Comments_in_Excel]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
</imagemap>




== The function ==
== The function ==
[[Datei:EN Excel Gestaltung Zeilentypen-konfigurieren.jpg|mini|upright=1.3|The view of the Remove Styles dialog]]
[[Datei:EN Excel Gestaltung Zeilentypen-konfigurieren.jpg|mini|upright=1.5|The view of the Remove Styles dialog]]


=== [[Datei:Image.Tab.RowType.Edit.32.png|link=|16px]] Edit formats ===
=== [[Datei:Image.Tab.RowType.Edit.32.png|link=|16px]] Edit formats ===
Zeile 32: Zeile 17:




{{
Vorlage:GoodtoKnowSmall


|Gutzuwissen = As of firesys 2018, erroneous row formats are highlighted line-by-line in Word. This makes it much easier to identify formatting errors.


}}
 
   
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
===Video: Configure row types ===
 
 
{{Vorlage:Video-Excel-Gestaltung-Formatierung-Styleguide-Zeilentypen konfigurieren-English}}   


== See also ==
== See also ==

Aktuelle Version vom 19. Januar 2024, 12:37 Uhr

firesys uses its own styles for implementing the tables in Excel. If these formats are not applied to tables, an error message will appear when updating. In the “Configure line types” dialogue, you can assign additional Excel styles to the firesys line types.


EN Menüband Excel Gestaltung Formatisierung StyleGuide.jpg


The function

The view of the Remove Styles dialog

Image.Tab.RowType.Edit.32.png Edit formats

Assign any Excel styles to a table format. Example: The format “Sum, Sum_2, Sum, ...” in Excel becomes the formatting “Table body total” in Word.

Image.Tab.RowType.Reset.32.png Reset

Resets the selected line types to the delivery status.

Image.Tab.RowType.Activate.32.png Activate

Reactivates line types and the assigned Excel styles that were not required due to a redesign in a previous version.













Video: Configure row types


The explanation of the individual steps in detail

How to configure row types for your Excel tables:

  1. In the “*Style” tab in the “Formatting” group, click on the “StyleGuide” split button.

  2. In the drop-down menu that opens, select the item “Configure row types”.
    →The dialogue “Configure row types” opens. Here you have the option to choose from different templates.

  3. Click on the desired element.
    Note: The “Edit” and “Reset” buttons are activated when you click on the element.

  4. Click on “Edit”.
    → The dialogue “Assign styles” opens. Here you can search for all existing Excel format templates.

  5. Select the ones you want to assign to their selection and then press “OK”.
    → The dialogue closes. You will see your selection in the edited template in the "Configure row types" dialogue.

  6. To undo your adjustments, select the template you want to change.

  7. Click on the “Reset” button to delete the format assignment.
    → The adjustments will be reversed

See also

Navigation hoch.svg The StyleGuide in Excel
Navigation rechts.svg The StyleGuide
Navigation rechts.svg Remove styles

Further contents

firesys website
Customer area
YouTube