3.11.8.1              The Sheet "Content"

Smart Excel Template horizontal content

Sheet "Content" of the standard template "HorizontalTemplate.xlsx"

Smart Excel Template vertical Content

Sheet "Content" of the Standard template "VerticalTemplate.xlsx"

Customer-specific Headers and Footers

Depending on the template type, the headers are highlighted in green or beige, the footers in orange or pink.

The formatting of the cells executed at headers and footers can be adopted during the export:

1.      Insertion of EXCEL functions (e.g. date =TODAY(); Sums =Sum(F2:F24) etc.)

2.      Activation of cell protection

3.      Adaption of the border specifications (line width and pattern)

4.      Connection of cells

5.      Cell colors

6.      Setting filters

7.      Character formats

8.      Changing the column width

Customer-specific data section

The data section is white in the templates (rows 5-7).

The formatting of the cells executed in the data section can be adopted during the export:

1.      Adaption of the border specifications

2.      Cell colors

3.      Character formats

4.      Changing the column width

5.      Line feed formats