Get Free Trial
Get Free Trial

Problem displaying small numbers that begin in the sixth decimal place

Answered
Fernando Sepúlveda asked on September 23, 2019

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:

  1. I have the value 1.2e-6 but instead of displaying the correct number we get 0.0e+0.
  2. On the other hand, I have the value 1.2e-7, and the pivot table displays that number correctly.

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.

Attachments:
flexmonster_exp06.png

7 answers

Public
Vera Didenko Flexmonster September 24, 2019

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

Public
Fernando Sepúlveda September 24, 2019

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.

Attachments:
Q7NdlL8W5Q.png

Public
Dmytro Zvazhii Flexmonster September 24, 2019

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

Public
Dmytro Zvazhii Flexmonster September 25, 2019

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

Public
Fernando Sepúlveda September 25, 2019

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.

Public
Vera Didenko Flexmonster October 8, 2019

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

Public
Fernando Sepúlveda October 9, 2019

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.

Please login or Register to Submit Answer