This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
en:infra-convert:user:exceltemp [2019/05/24 14:49] me |
en:infra-convert:user:exceltemp [2019/06/14 16:07] me |
||
---|---|---|---|
Line 33: | Line 33: | ||
Excel templates can be set up and formatted according to your wishes. You can customize the templates provided or create new templates. Place the templates in the folder named //ExcelReports// above. When exporting test plans, these templates are available, see Functions > Export > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | Excel templates can be set up and formatted according to your wishes. You can customize the templates provided or create new templates. Place the templates in the folder named //ExcelReports// above. When exporting test plans, these templates are available, see Functions > Export > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d. | ||
+ | |||
+ | > **Important** Only one worksheet of #@IC_HTML@# can be filled. The position of the sheet in the workbook is irrelevant, but it must be active respectively visible when the template file is saved. | ||
#@IC_HTML@# writes the inspection characteristics line by line, this means among themselves. Name the first cell in the column to be filled with a value with one of the variables from the table below. How to define names in Excel is described in Microsoft Office Help here: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | #@IC_HTML@# writes the inspection characteristics line by line, this means among themselves. Name the first cell in the column to be filled with a value with one of the variables from the table below. How to define names in Excel is described in Microsoft Office Help here: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]]. | ||
+ | |||
+ | > **Important** Each name can only be assigned once. | ||
{{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} | {{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}} |