en:infra-convert:faq_neu
Differences
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_neu [2022/08/02 14:12] me removed |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <WRAP group> | ||
| - | <WRAP box round> | ||
| - | <WRAP column 10%> | ||
| - | \\ \\ | ||
| - | {{ :en:infra-convert:user:icon_faq_excel_export.png?nolink&0x60 |}} | ||
| - | </WRAP> | ||
| - | <WRAP column 85%> | ||
| - | **Excel export**\\ | ||
| - | == 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.\\ | ||
| - | **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@#.\\ | ||
| - | **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** | ||
| - | |||
| - | |< 100% 33% 66% >| | ||
| - | ^ Problem ^ Explanation/Solution ^ | ||
| - | ^ No data is entered in the Excel file | If the Excel file is created but not filled with values, this can have the following reasons:\\ \\ **No data in the test plan** – The test plan version to be exported does not contain any characteristics (or test plan attributes) or all characteristics have been filtered out for export. Check the contents of the test plan version in the project that you want to export. Check whether you have activated filters for the export.\\ **See** Functions > Export > Export test plan > [[en:infra-convert:user:functions:cplanexport#workflowexport_test_plan_version|Workflow: Export test plan version]]\\ \\ **Missing cell names** – There are no cells named with valid export variables on the sheet. Either these were not defined or the sheet was not active or not in the foreground when the Excel template was saved.\\ **See** More > Create and customize Excel templates > [[en:infra-convert:user:exceltemp#structure|Structure]] | | ||
| - | ^ The sheet is write-protected | If the export process is interrupted with the message that cells are located on a read-only sheet, check whether write protection is not activated for the sheet to be filled. Open the template file in Excel. You can view the protection status under **File** > **Information** > **Protect workbook**. | | ||
| - | ^ The file is used by another process | You may be trying to overwrite a file that is open in another application. Check if this is the case or save the file under a different name or in a different directory. | | ||
| - | ^ 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]] | | ||
| - | ^ 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. | | ||
| - | |||
| - | </WRAP> | ||
| - | </WRAP> | ||
| - | </WRAP> | ||
en/infra-convert/faq_neu.1659442376.txt.gz · Last modified: 2022/08/02 14:12 by me
Page Tools
