Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

How to formatting numbers in exponential notation on grid

Answered
Denis asked on May 5, 2020

Hello,
We are integrating Flexmonster with Highcharts and ran into a problem with formatting numbers in exponential notation on grid.

The fact is that large numbers in the grid are represented in the exponential notation, for example, 7.19654654654e+82. And the problem is that such numbers being decimal just ignore formatting from format cells dialog (decimal places and decimal separator) at the grid.
We also support formatting on highcharts, and there is no such problem.

Please, see attachments for details.

So, why formatting isn’t applied for such values and how we can apply it at the grid?
 
Thanks in advance,
Denis
 

5 answers

Public
Vera Didenko Flexmonster May 6, 2020

Hello, Denis,
 
Thank you for writing to us. 
 
We have managed to reproduce the described behavior: https://jsfiddle.net/flexmonster/9ovwebta/
Our team will add an update so that the number formatting regarding decimal separator targets large numbers in exponential notation as well.
This will be available in the minor release version with the ETA 1st of June.
 
Please let us know if this would work for you.
 
Kind regards, 
Vera

Public
Patrick Vandersluis May 18, 2020

We have an issue that seems like a related problem. Text fields, e.g. ‘3E69’ (happens to be a room number) mysteriously appear as ‘3.00e+69’ but ‘3E33’ displays fine.
Regards,
 
Patrick
 
 

Attachments:
FMimage2.JPG

Public
Vera Didenko Flexmonster May 18, 2020

Hello, Patrick,
 
Thank you for writing to us.
 
For such cases, we kindly suggest specifying the data types for the fields. 
This can be done via the mapping property of the dataSource object
Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/cnv7q1xr/.
 
Please let us know if this works fine for you.
Looking forward to your response.
 
Kind regards,
Vera

Public
Patrick Vandersluis May 28, 2020

Vera, thank you. Your sample code worked for our issue.

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 2 days ago

Hi Denis,
 
We are happy to let you know that the issue with formatting (for decimalSeparator) not being applied to large numbers in exponential notation was fixed.
 
This is available in the 2.8.8 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component. Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Speaking of the same functionality for decimalPlaces, we will need a little bit more time time to implement this, so we will return to you with an update ETA Jun 15th.
 
Feel free to write to us in case of questions.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer