This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal

UseCellTextAsValue Setting - Fetching data from excel template as it appears in the cell

Fetching the data from an excel file (XL references) as it appears in the cell by using the setting UseCellTextAsValue in the ToscaCommander.exe.config.


Situation

The user has designed the test case instances in an external excel file.It is then treated as a data source for the test case template in Test Case section.Some values for the attributes in the excel have zero's in the decimal places.For example: 150.00 or 20000.00

On instantiation of the Test Case template, the values in the test steps appear as 150 and 20000.But it is the business need, to get the value as text/displayed in the excel cell.

Solution

1. Navigate to the directory: %TRICENTIS_HOME% and open TOSCACommander.exe.config.

Please Note: Before making changes in the TOSCACommander.exe.config file, please create a backup of the same.

2. In the <configSections>, under the <sectionGroup name="applicationSettings" ..>, copy and paste a previously existing <section ...*/>.

3. Replace the name="..." with: "Tricentis.TCCore.XLConnector.Properties.Settings"

4. Under <applicationSettings> copy and paste the following:

<Tricentis.TCCore.XLConnector.Properties.Settings>
	<setting name="UseCellTextAsValue" serializeAs="String">
		<value>True</value>
	</setting>
</Tricentis.TCCore.XLConnector.Properties.Settings>

5. Restart Tosca Commander to bring the changes to effect.

This setting allows to specify how values are copied from Excel cells. If this setting is True, the value is read as text (i.e. how it is displayed). If this setting is False, the value is read as Value (i.e. how it has been entered earlier).

 

[opt.] Reference

https://support.tricentis.com/community/manuals_detail.do?lang=en&version=11.1.0&url=tosca_commander/commander_config.htm

IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial