Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
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
 

9 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 June 2, 2020

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

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 16, 2020

Hi Denis,
 
We are glad to announce that the issue with decimalPlaces not being applied to large numbers in exponential notation was fixed as well.
 
This is available in the 2.8.9 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
Please let us know if everything works fine for you.
 
Regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 23, 2020

Hi Denis,
 
Hope you’re doing well.
 
We were wondering if you’ve had a chance to check out the latest v2.8.9 release. Was the previously mentioned issue solved, or do you still have any questions you would like to discuss?
 
We would be happy to hear your feedback.
 
Kind regards,
Mykhailo

Public
Denis June 23, 2020

Hi Mykhailo,
Flexmonster update is planned for this sprint, within two weeks we will take this task in development and inform you about the results.
 
Regards,
Denis

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster June 24, 2020

Hi Denis,
 
Thank you for the heads-up – let us know if you have any questions in the meantime, we will be happy to assist you!
 
Kind regards,
Mykhailo

Please login or Register to Submit Answer