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
⋅ 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
⋅ 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
⋅ 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
⋅ May 28, 2020
Vera, thank you. Your sample code worked for our issue.
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
