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,
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.
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.
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.
Vera, thank you. Your sample code worked for our issue.
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.
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.
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.
Flexmonster update is planned for this sprint, within two weeks we will take this task in development and inform you about the results.
Thank you for the heads-up – let us know if you have any questions in the meantime, we will be happy to assist you!