NEW4.00.02 · Released 27 June 2023

NEWfinPOWER Connect

Released in

4.00.02

27 June 2023

1. Opened10 May
2. Closed10 May
3. Released27 Jun

Article 20258 Job J031044

ISExcel; GetString returns unexpected exponential value

The ISExcel.GetString() function may return unexpected values where the cell is a number and the format is "General".

This occurs if the number has many digits and formatting of the number returns an "exponential" value. For example, "400555000000000" was returning "4.00555E+15".