Free Support Forum - aspose.com

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

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 ?

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.

Hello,

Any news about this improvement ?

Thanks in advance.

Hi,

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

Thank you,

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

Hi,

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