Cannot calculate SUM formula

Aspose.Cells Product Family
1

Hello!


There is an exception Aspose.Cells.CellsException: Error in Cell: B25-Invalid
formula:“SUM(PY1:‘PY11’!B25)”, where PY11 is a different sheet.

P.S.
Change the formula to =SUM(PY1!B25,‘PY11’!B25) solves the problem.

Thanks,
Leo

2

Hi Leo,

Thanks for your posting and using Aspose.Cells.

Please provide an Excel file containing your formula which is working fine there but throwing exception in Aspose.Cells.

We will look into your issue and help you asap.

3

Please find attached.


Thanks,
Leo
4

Hi,


Thanks for the template file.

After an initial test, I observed an issue in the output Excel file and PDF file format regarding calculating formulas while using the template file provided by the you with v8.2.0.2. I do not get any exception from Aspose.Cells while running the code segment but I got issues prompted by MS Excel in the output Excel file (when opening the file into it) and also in the PDF file (which has “#Recursive Reference” error for the calculated value of the cell).
e.g
Sample code:

var book = new Workbook(@“E:\test2\21773.xlsx”);
book.CalculateFormula();
book.Save(@“E:\test2\out217731.xlsx”);

book.Save(@“E:\test2\out217731.pdf”, SaveFormat.Pdf);

I have logged a ticket with an id “CELLSNET-42961” for your issue. We will look into it soon.

Once we have any update on it, we will let you know here.

Thank you.

5

Hi,

Thanks for your using Aspose.Cells.

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