Precision issues with Aspose.Cells for Java V1.9.4 Hot Fix

Aspose.Cells Product Family
1

I am doing the following :

  1. Open Microsoft Excel and create a new workbook
  2. A1: 3.72574790014717000
  3. B1: 0.02276050441415250
  4. C1: =A1*B1
  5. Result: 0.08479990152731910
Then I run the following Java code



Workbook wb = new Workbook();

wb.open(new FileInputStream(srcFile));

wb.calculateFormula();

wb.save(new FileOutputStream(dstFile));



When I reopen the workbook in Excel, the calculated value differs.
Result: 0.08479990157726320

I am using Aspose.Cells for Java V1.9.4 Hot Fix for JRE 1.5, with the Sun JRE 1.5.0_07.

Can you help me ?
2

Hi,

Thank you for your sample case, we will release a new version to fix this issue in this week, thank you for being patient.

3

Hello,

Any news about this improvement ?

Thanks in advance.

4

Hi,

Thank you for being patient, there still some feature need to support in our new version, so please try this fix.

5

Thank you,

It looks like it is OK in this version.
When do you think the “official” new version will be issued ?

6

Hi,

We will try to release it in this week, thank you.