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

XL-Connector: Warning in case of too many characters

This article describes an error that occurs when an XL-Cell contains more than 1024 characters.


Situation

 

An XL-Cell contains more than 1024 characters.
If a template connects to an XL-Cell, that contains more than 1024 characters, the following behaviour occurs when (re)instantiating the template:

Excel Format .xls:

Legacy Connector  ->  Warning and instantiation of the value up to the limit of characters
Native XL-Connector -> No warning and instantiation of the value up to the limit of characters 

Excel Format .xlsx od. .xlsm

Legacy Connector  ->  Warning but full instantiation of the value
Native XL-Connector -> No warning and full instantiation of the value
 
 
Solution


This has been/will be fixed in TOSCA Version 7.5.1:

(Application)Setting UseCellTextAsValue = True
- xls: Whilst (re)instantiating the according warning appears (see below). Instantiation of the value up to the limit of characters.
- xlsx: Whilst (re)instantiating the according warning appears (see below). Instantiation of the value up to the limit of characters.

(Application)Setting UseCellTextAsValue = False
- xls: Whilst (re)instantiating no warning appears. Full instantiation of the value.
- xlsx: Whilst (re)instantiating no warning appears. Full instantiation of the value.

Warnings:
(de)
1 Excel-Zell-Wert(e) sind/ist beim Auslesen aus Excel aufgrund der Einschränkung maximaler Zelleninhalte abgeschnitten worden.
Soll eine Liste der Objekte angezeigt werden, deren Werte abgeschnitten wurden?

(en)
1 Excel-Cell value(s) have been truncated on extraction to due Excel restrictions.
Would you like to see a list of objects with the affected values?

If you click "Yes", the according elements are shown in a search window.
IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial