Formula issue in Aspose Cells 8.6.2 Java

Aspose.Cells Product Family
1
HI,

We are facing a formula issue in Java Aspose Cells 8.6.2. Result produced by the Excel sheet and Aspose is different.

Actual Result produced by Excel sheet for Cell BV93 is 1.486, but the Aspose produces the error DIV/0 which is causing issue in our application.

Please find the attached sample excel sheet.

Sheet Name = Class Data
Cell Name = BV93

Please do the needful.

import com.aspose.cells.Workbook;

public class CellCheck {
public static void main(String[] args) throws Exception {
Workbook inputWorkbook = new Workbook("sample-aspose1.xlsx");
System.out.println(inputWorkbook.getWorksheets().get("Class Data").getCells().get("BV93").getValue());
}
}
2

Hi Vinodkar,


Thank you for contacting Aspose support.

Please call Workbook.calculateFormula method before retrieving the formula based values then the cell will contain the correct value.

Java

Workbook inputWorkbook = new Workbook(“C:/temp/sample-aspose2.xlsx”);
inputWorkbook.calculateFormula();
System.out.println(inputWorkbook.getWorksheets().get(“Class Data”).getCells().get(“BV93”).getValue());

1.4865560282610344
3

Can you please validate the Aspose again, we have been using the calcualte formula but still the issue seems to occur.

4

Hi Sundarraj,


I have reevaluated the scenario against the latest version of Aspose.Cells for Java 8.6.2 with code provided in my previous response. I am getting the correct result, that is; 1.4865560282610344. You need to confirm the following two points on your side.

  • In the code snippet provided in first post, the file name is sample-aspose1.xlsx whereas the shared sample file name is sample-aspose2.xlsx. It is possible that you may have uploaded a wrong sample so please try the case by downloading the sample from this thread.
  • Make sure you are using the latest version of the API, that is; 8.6.2 at the moment. You may print the API version on the console using the CellsHelper.getVersion method.

In case you are still not able to figure it out, please provide us the following information.

  • Operating system version & architecture
  • JDK vendor and version
  • Locale of your machine
  • JVM arguments set for the process/program, if any
5

Hi Raza,


Please use the lastest attached Spreadsheet for verifying.

Cell : BV93

Thanks,
Vinod
6

Hi Vinod,


Thank you for sharing a new sample.

Please note, we are able to replicate the said issue on our side while using the latest version of Aspose.Cells for Java 8.6.2.1 and newly shared sample. We have logged this incident in our bug tracking system as CELLSJAVA-41605 for further investigation & correction purposes. Our product team will further look into the details of this problem and we will keep you updated on the status of correction. We apologize for your inconvenience.
7

Hi,

Thanks for using Aspose.Cells.

This is to inform you that we have fixed your issue CELLSJAVA-41605 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

8

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for Java v8.6.2.4 and let us know your feedback.

9

The issues you have found earlier (filed as CELLSJAVA-41605) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.