Known Issues - Data tables

Relevant for: GUI tests and GUI scripted components

This section describes limitations for working with data tables.

In this topic:

Data and GUI tests and components

If you parameterize a value that is defined as a variant value, then when retrieving the value from the Data pane, UFT One retrieves it as a string. This occurs even if you enter a numeric value in the Data pane.

Back to top

Data sheet names shortened automatically

Excel sheet naming conventions prohibit the use of sheet names that exceed 31 characters or contain [ ] characters.

Therefore, when opening data tables created in a version earlier than 15.0, sheet names are modified if they do not match these conventions.

Most sheet references automatically refer to the new names. However, you may need to re-record or manually update sheet names in steps that explicitly refer to the old names, such as: DataTable.Value, DataTable.GetSheet, and SAPGUITable.Input.

Back to top

Selecting data table content

• You can select multiple cells in the data sheet. However, you cannot select the parameter name in the first row and additional table cells at the same time.

• Selecting multiple sheets in the data table using CTRL is no longer supported.

Back to top

Entering data from an autofill list

Entering autofill values by pressing ENTER or TAB after typing the first value in a cell is no longer supported.

See To populate your data table with values from an autofill list.

Back to top

Importing data sheets in languages other than English

When you import an Excel data sheet in languages other than English from a database by specifying the SQL statement manually, double byte characters appear garbled in the imported sheet in UFT One.

Workaround: Import the data sheet by right-clicking in the Data pane and select one of the following:

• File > Import from File to import the data sheet.

• Sheet > Import > From File to import the data sheet.

Back to top

See also:

• Define and manage data tables