Forum Discussion
SmartBear_Suppo
10 years agoSmartBear Alumni (Retired)
Hello,
The excel jar files were upgraded in 5.1.1 and 5.1 to configure xlsx files,
The custom values are not read correctly from the excel sheet, they are read off as decimal So the workaround for the issue is, Copy all the cells from Excel to Notepad Delete all the cells from excel Select all the cells > Right click > Format cells > Select text Copy all the values from Notepad Right click on excel sheet > Pasts as Text
And then try the file in DataSource, this should work.
The defect tracking number for this issue is SOAP-2777. You can follow up on this bug with this.
Regards,
Temil
The excel jar files were upgraded in 5.1.1 and 5.1 to configure xlsx files,
The custom values are not read correctly from the excel sheet, they are read off as decimal So the workaround for the issue is, Copy all the cells from Excel to Notepad Delete all the cells from excel Select all the cells > Right click > Format cells > Select text Copy all the values from Notepad Right click on excel sheet > Pasts as Text
And then try the file in DataSource, this should work.
The defect tracking number for this issue is SOAP-2777. You can follow up on this bug with this.
Regards,
Temil