Hello Aspose support team,
I have an issue with using Aspose Cells for Java, version 25.8
We did not observe that issue in 25.7
You can find 2 files in the attachment,
producedByExcel.xlsx: Excel version. Formulas are evaluated correctly.
producedByAspose.xlsx: Aspose version. Rows 18 to 1002 in column F contain incorrectly evaluated formula results, displaying the error “#VALUE!”
Could you please check this issue.
excelFiles.zip (46.3 KB)
It appears you are encountering issues with formula evaluation in Aspose Cells for Java version 25.8, where the results are displaying “#VALUE!” in the specified range. Since this issue did not occur in version 25.7, it may indicate a regression or bug introduced in the newer version.
To address this issue, I recommend the following steps:
Check for Updates: Verify that you are using the latest version of Aspose Cells, as the issue may have been resolved in a subsequent release.
Re-evaluate Formulas: You can attempt to re-evaluate the formulas programmatically after loading the workbook. Here’s a sample code snippet:
Workbook workbook = new Workbook("producedByAspose.xlsx");
workbook.calculateFormula();
workbook.save("output.xlsx");
Contact Support: If the problem persists, consider reaching out to Aspose support with the specific files you are working with. They may provide a more tailored solution or confirm if it’s a known issue.
Downgrade: As a temporary workaround, you may want to revert to version 25.7 if the issue is critical and you require immediate functionality.
If you need further assistance, please provide additional details about the specific formulas that are failing, and I can help you troubleshoot further.
Thank you for providing the template Excel files.
I reviewed your scenario using the provided files. It appears that the cells starting from the 18th row (e.g., F18 and onward) are outside the Table/ListObject range. As a result, the formulas are not calculating correctly and are displaying “#VALUE!” errors. Could you clarify how the spreadsheet/file “producedByAspose.xlsx” was created by Aspose.Cells? Please share sample runnable code to generate the file and we could better understand and evaluate the issue on our end. It seems the table may not have been resized sufficiently to accommodate all the cells up to 1002 rows.