Truncated value while fetching the numeric data from cell

Aspose.Cells Product Family
1

Hi,

I am trying to fetch the value from a cell which is Numeric. In Power query mode the actual value for C5 cell is 957667663909.88611. However when I try to fetch it using cell.getStringValueWithoutFormat(), I get the value as 957667663909.8861. The fifth digit is truncated. Can you help in understanding why is the value truncated. Also is there any other function that I can use. I have already used getDoubleValue() too. Let me know how can i share the sample java code and excel file?

2

@shahsidd1
Please compress the Excel template file and Java test code into zip format and upload them here. We will check them soon.