User Tools

Site Tools


en:infra-convert:faq

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 ​templatescustomize ​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>
en/infra-convert/faq.1690617737.txt.gz · Last modified: 2023/07/29 10:02 by me