This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:infra-convert:faq [2023/07/29 10:02] me |
en:infra-convert:faq [2023/12/11 16:40] (current) me |
||
---|---|---|---|
Line 247: | Line 247: | ||
== What should be considered when dealing with Excel test reports? == | == What should be considered when dealing with Excel test reports? == | ||
- | You can create your own Excel test report templates, customize the templates installed with the program, or use them directly.\\ | + | Characteristic and general test plan data can be exported directly to an Excel test report. An Excel template file (*.xltx, *.xltm) is required from #@IC_HTML@# for this. You can use and adapt the installed test report templates or create your own templates. The basics are described on the following linked page. Template-specific descriptions can be found on the **Info** worksheet.\\ |
**See** More > [[en:infra-convert:user:exceltemp|Create and customize Excel templates]] | **See** More > [[en:infra-convert:user:exceltemp|Create and customize Excel templates]] | ||
The **Excel Report Add-In** known from the predecessor software #@IC_OLD_HTML@# is no longer used. The Excel export function is now integrated in #@IC_HTML@#.\\ | The **Excel Report Add-In** known from the predecessor software #@IC_OLD_HTML@# is no longer used. The Excel export function is now integrated in #@IC_HTML@#.\\ | ||
**See** Functions > Export > Export test plan > [[en:infra-convert:user:functions:cplanexport#workflowexport_test_plan_version|Workflow: Export test plan version]] | **See** Functions > Export > Export test plan > [[en:infra-convert:user:functions:cplanexport#workflowexport_test_plan_version|Workflow: Export test plan version]] | ||
- | |||
- | The supplied Excel test report templates provide forms for common approval procedures in German and English. You set the language, release procedure and sample size on the "Input" sheet on the far right. Further usage and customization options can be found in the documentation.\\ | ||
- | **See** More > Create and customize Excel templates > [[en:infra-convert:user:exceltemp#standard_templates|Standard templates]] | ||
**Known problems and possible solutions** | **Known problems and possible solutions** | ||
Line 265: | Line 262: | ||
^ Formulas are not calculated (#NAME?) | If the entry "#NAME?" is displayed in some fields in an exported Excel file, editing of the document may be restricted. Some formulas are not calculated in the "Protected view" mode. To do this, disable the protected view. Trusted sources can be set in the Excel Trust Center. Contact your administrator for this. | | ^ Formulas are not calculated (#NAME?) | If the entry "#NAME?" is displayed in some fields in an exported Excel file, editing of the document may be restricted. Some formulas are not calculated in the "Protected view" mode. To do this, disable the protected view. Trusted sources can be set in the Excel Trust Center. Contact your administrator for this. | | ||
^ The file is write protected | Security settings may prevent access to the template file. Note that the access permissions apply to the user running #@IC_HTML@# at the moment. In this case, contact your administrator.\\ \\ Alternatively, you can try to save the template file with Excel again (**File** > **Save as**) or change the directory for test report templates. The location can be set in the #@IC_HTML@# settings.\\ **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|“Excel test plan” group]] | | ^ The file is write protected | Security settings may prevent access to the template file. Note that the access permissions apply to the user running #@IC_HTML@# at the moment. In this case, contact your administrator.\\ \\ Alternatively, you can try to save the template file with Excel again (**File** > **Save as**) or change the directory for test report templates. The location can be set in the #@IC_HTML@# settings.\\ **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|“Excel test plan” group]] | | ||
- | ^ Error in Microsoft Office interop interface | If the export process is aborted with an error message indicating an error in the "Microsoft.Office.Interop" interface, there may be an error in the Microsoft Excel or Office installation. Perform an Office repair. | | + | ^ Error in Microsoft Office interop interface | If the export process is aborted with an error message indicating an error in the "Microsoft.Office.Interop" interface, there may be an error in the Microsoft Excel or Office installation. Carry out an Office repair, in the first attempt a quick repair, if the error continues to occur, an online repair.\\ **See** Microsoft Support > [[https://support.microsoft.com/en-us/office/reparieren-einer-office-anwendung-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b|Repair an Office application]]\\ \\ **Quick repair** – Press the key combination **Window key** + **R**, enter //control// in the Run console that opens and confirm the entry. Navigate under **Control Panel** > **All Control Panel Items** to **Programs and Features**. Search here for //Microsoft Office// or //Microsoft 365//. Right-click on the entry and click on **Change** in the context menu. In the repair dialog that opens, select **Quick Repair** and then click **Repair** twice.\\ \\ **Online repair** – Open the repair dialog as described above under //Quick repair//. Select **Online repair** here and then click **Repair** twice. | |
<WRAP noprint> | <WRAP noprint> |