Free Support Forum - aspose.com

#ref in formula fields

Hi,
I loaded a spreadsheet and see #ref in cells that have formulas.
Why is this?
Thanks,
Leo

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

Here is the spreadsheet.

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?

Laurence,

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

Thanks,
Leo

Hi Leo,

We will check it ASAP.

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 refernece.

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.