Troubleshooting
Problem
A user generated data with 16-digit numbers in a Microsoft® Excel spreadsheet and then saved the data to a CSV file. The user then imported the CSV file into a datapool. The datapool displays the numbers using exponential notation, for example, 1.23457E+15.
Resolving The Problem
The default cell format in Microsoft Excel displays a 16-digit number in exponential notation. Therefore, the number 1234567890123450 is displayed as 1.23457E+15; this is the value written to the .csv file when a Save As is performed. IBM® Rational® TestManager imports the data exactly as it is written, that is, as 1.23457E+15.
To get the actual numeric value in the datapool instead of the exponential notation, the data must be displayed differently in the spreadsheet. To do this, enter the data in the spreadsheet as a string literal by entering the data with a single apostrophe (') before the number. Entering '123456789012345' keeps the data in the desired format. When the data is saved as a CSV file and then imported into a datapool, TestManager displays '123456789012345.
Historical Number
139371417
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21135569