#ref in formula fields

rapiddata · March 19, 2005, 6:39am

Hi,

I loaded a spreadsheet and see #ref in cells that have formulas.

Why is this?

Thanks,

Leo

Laurence · March 19, 2005, 4:52pm

Could you please post your spreadsheet here? We will check it ASAP.

rapiddata · March 21, 2005, 5:13am

Here is the spreadsheet.

Laurence · March 21, 2005, 4:48pm

Hi Leo,

Could you please tell me which cell doesn’t show correctly on the web page? I don’t find it. The attached file is my screenshot after loading your file.

And are you using Aspose.Excel.Viewer or Aspose.Excel.Web?

rapiddata · March 22, 2005, 10:39am

Laurence,

Attached is the .aspx page and excel file with the problem.

Thanks,
Leo

Laurence · March 22, 2005, 6:18pm

Hi Leo,

We will check it ASAP.

Laurence · March 23, 2005, 10:03pm

Currently Aspose.Excel.Web borrows the formula calculation engine from Aspose.Excel.

In Aspose.Excel, only part of Excel functions are supported. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Excel.CalculateFormula.html
for reference.

MS Excel can automatically re-calculate the formula when loading the file so in most case there aren’t problems when loading an Excel file in MS Excel.

We are working to enhance the formula calculation engine to solve this problem.