Known Issues - Data tables

Relevant for: GUI tests and GUI scripted components

This topic describes limitations for working with data tables.

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.

Example: If you parameterize the argument of a step such as: WpfWindow("MyWindow").WpfComboBox("cb").Select 1 and you enter the value 1 in the Data pane, then when the step runs, it retrieves the value as a string: "1", and the step fails.

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 automatically modified if they do not match these conventions. This also happens when you create or rename an action to a name longer than 31 characters.

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

Saving data table content

To successfully save data table changes, you must click any place in the clickable area of the data pane and press Ctrl+S. Make sure that you save data table content before you run a test.

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

Data sheets containing merged cells

We recommend using data sheets that do not contain any merged cells.

If your data sheets contain merged cells, the data in those cells may not be usable and some DataTable object methods may behave unexpectedly.

UFT One 23.4 and earlier: Importing data sheets containing merged cells using the DataTable.Import method caused UFT One to behave unexpectedly. You can import such data sheets using File > Settings > Resources > Data Table.

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: