Hi,
at the minute we are evaluating Aspose.Excel to wrap-up the existing functionality in a set of spreadsheets developed by our business users. I’ve checked the spreadsheet so that only the supported formula are contained within but I’m still getting a runtime exception when I try to execute the CalculateFormula() method:
at Aspose.Excel.?.?(Cell ?, Byte[] ?)
at Aspose.Excel.?.?(Cell ?)
at Aspose.Excel.Excel.CalculateFormula()
at ConsoleAsposeTest.TestExcel.Main(String[] args) in c:\projects\work\b2b\ex
celtest\consoleasposetest\exceltest.cs:line 24
I have attached the spreadsheet. and here is the simple code I’m using to open it :
Excel excel = new Excel();
//Open a spreadsheet
excel.Open(“Rating - NOTRUNC.xls”);
try
{
excel.CalculateFormula();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
many thanks for your time,Dave.