Settings - TestCase from XL

The following settings can be found under Settings->TestCase from XL.

BusinessObjects’ Workbook
Description	List of paths and file names of the worksheets with business objects, separated by semicolons ;
Example

Domains’ Workbook
Description	List of paths and file names of the worksheets with domain definitions, separated by semicolons ;
Example

Use Excel cell content or format
Description	When you create test data from Excel, you can choose which format Tosca uses to create test data from your file. To do so, select one of the following setting values: Cell content: Tosca uses a cell's content as it is to create test data. Cell content in Excel-defined format: Tosca uses a cell's content in the Excel-defined format to create test data. Let's say you have a date format defined in your Excel document: YYYY-MM-DD. You also have a column called Date of Birth, but the dates in this column are in the format DD.MM.YYYY. If you select Cell content, Tosca creates test data from Date of Birth based on what's in the cells: DD.MM.YYYY. If you select Cell content in Excel-defined format, Tosca creates test data from Date of Birth based on the Excel-defined date format: YYYY-MM-DD.
Example	Content

Use Excel cell content or format

Description

When you create test data from Excel, you can choose which format Tosca uses to create test data from your file. To do so, select one of the following setting values:

Cell content: Tosca uses a cell's content as it is to create test data.
Cell content in Excel-defined format: Tosca uses a cell's content in the Excel-defined format to create test data.

Let's say you have a date format defined in your Excel document: YYYY-MM-DD. You also have a column called Date of Birth, but the dates in this column are in the format DD.MM.YYYY.

If you select Cell content, Tosca creates test data from Date of Birth based on what's in the cells: DD.MM.YYYY.
If you select Cell content in Excel-defined format, Tosca creates test data from Date of Birth based on the Excel-defined date format: YYYY-MM-DD.

Example

Content

Keep Actionmode Output
Description	Offers the possibility to automatically reset the intended use to input as soon as results (e.g. premiums) are returned to a template.
Example	Yes

Method of cell-copy
Description	The contents of Excel cells can be copied as values or formulars from Tosca Commander™.
Example	Copy by formulars

Project’s context
Description	Definition of output context for domain translations.
Example	HOST

Trim XL Values
Description	Spaces before and after a value in an Excel cell can be removed by Tosca Commander™ Possible values: Yes: spaces are removed No: spaces are not removed
Example	No

Trim XL Values

Description

Spaces before and after a value in an Excel cell can be removed by Tosca Commander™

Possible values:

Yes: spaces are removed

No: spaces are not removed

Example