We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Invalid Formula Error when opening spreadsheet

After downloading the 1.8.8.1 how fix, I started getting an Invalid Formula error in a spreadsheet that has been working. I looked at every formula on the page and didn’t see any that were invalid. Any ideas?

I sent you a sample of the spreadsheet that is not working last week. Thanks.

Russ

Hi Russell,

It’s fixed and the new hotfix will be released tomorrow.

@RussellA,
Aspose.Excel is discontinued and is replaced by an advance version Aspose.Cells. This new product contains vast range of latest features supported by different versions of MS Excel. You can work with formulas using this new product as demonstrated in the following sample code:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Excel object
int sheetIndex = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Adding a value to "A1" cell
worksheet.Cells["A1"].PutValue(1);

// Adding a value to "A2" cell
worksheet.Cells["A2"].PutValue(2);

// Adding a value to "A3" cell
worksheet.Cells["A3"].PutValue(3);

// Adding a SUM formula to "A4" cell
worksheet.Cells["A4"].Formula = "=SUM(A1:A3)";

// Calculating the results of formulas
workbook.CalculateFormula();

// Get the calculated value of the cell
string value = worksheet.Cells["A4"].Value.ToString();

// Saving the Excel file
workbook.Save(dataDir + "output.xls"); 

Here is the link to detailed description of this feature:
Using formulas or functions to process data

The latest version of this product is available here for testing without any cost:
Aspose.Cells for .NET (Latest Version)

For your ease a rich solution is available here for testing variety of features without writing any code.