Hello Support Team,
We are having trouble displaying some small numbers in the pivot table. The only numbers that are not displayed properly are the numbers that begin in the sixth decimal place (Eg: 1.2e-6). Any other number with a bigger or smaller exponent is displaying correctly.
For example:
We checked the database to analyze the conflicting values, and all of them are numbers that start in the sixth decimal place (Eg: 0,0000012). That indicates that the numbers are not the problem.
I don't understand why the numbers with any other exponent are displaying well and the numbers like the above mentioned are displayed like 0.0e+0.
Can you help me to identify what is causing this kind of behavior?
Best regards,
Fernando.
Hello, Fernando,
Thank you for writing to us.
We have managed to reproduce the issue on our end.
Our team will provide the fix in the minor release version with the ETA 21st of October.
Please let us know if you have any questions.
Best Regards,
Vera
Hello Vera,
Thank you for your response. We are glad that you were able to reproduce the issue. However, this is something that is negatively impacting some of our customers, so we would like to know if it would be possible to have a patch or maybe a beta version before the date you indicated. If it's not possible, could you give us some workaround we could use meanwhile?.
We tried formatting the cells as a percent as a workaround, but it didn't work, because some percents also start at the sixth position, and gives us the value 0.0e+0%
Thank you for your support.
Best regards,
Fernando.
Hello Fernando,
Thank you for your feedback.
Currently, the only possible workaround is to fix such cells manually using customizeCell approach: https://www.flexmonster.com/api/customizecell/.
We would try prioritizing your case. The necessary fix will be released in the nearest minor update, ETA Oct 7.
Please let us know if everything works fine for you.
Regards,
Dmytro
Hello Fernando,
We spent some more time investigating your case and found a workaround.
If you use beutifyFloatingPoint
formatting property with the value false
everything should work as expected.
Here is an example: https://jsfiddle.net/flexmonster/71f365my/48/.
Regards,
Dmytro
Hello Dmytro,
Thank you for prioritizing the case. We will wait until the release, but for now, we will try the workaround you indicated. Also, your example was very helpful.
Thank you for your support.
Best regards!
Fernando.
Hello, Fernando,
We are glad to announce that the issue with displaying small numbers was fixed.
This is included in the 2.7.16 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/ .
Please let us know if everything works fine for you.
Best Regards,
Vera
Hello Vera,
Thank you very much for letting us know that the update is out.
We will let you know if everything is working fine for us.
Best regards!
Fernando.