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.
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 in version 2023 and later.
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.
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.
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.
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.
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.