Page 1 of 1
Ranorex is stripping off $ and add trailing 0s upon import
Posted: Tue Oct 23, 2018 5:43 pm
by centeneUser2.0
Hi, I'm new to Ranorex. I'm trying to do a simple validation against a datasource where $5,900 and $0.00 appear on the UI; however, upon loading it into Ranorex, the Ranorex datasource is now displaying 5,900 and 0.0000 respectively.
Re: Ranorex is stripping off $ and add trailing 0s upon import
Posted: Tue Oct 23, 2018 9:48 pm
by Support Team
Hi CenteneUser2.0,
Based on the described issue, I suspect you are using Excel as your data source. Excel often automatically formats your data so it is easier to read, however, the actual value is different. In Excel,
set the cell's format to "Text" or "General" to see the actual value.
I hope this helps!
Cheers,
Ned
Re: Ranorex is stripping off $ and add trailing 0s upon import
Posted: Wed Oct 24, 2018 3:24 pm
by krstcs
I would highly recommend that you stop using Excel. Use CSV text files instead. They do not have this issue, and as long as you enclose the string in quotes like ("$45,000") (otherwise the comma would be a problem) you will be fine.