Formula Errors converting from SpreadsheetML



When I am loading an XML spreadsheet in Aspose.Excel, with the formula:


then saving this in Excel97 format.

The formula placed in the spreadsheet is changed to:


Which gives an error. The correct format of the formula is:


Is this a known issue or is there some other reason for it’s occurance?

Do you have a work around, or a fix I could use?




Hi Verge,

Which version are you using? Could you please post your xml spreadsheet here? I tested this formula but didn't find this problem.


Hi Laurence,

Thanks for getting back so quickly.

Sorry, that problem was my mistake, I was using an old version of the Aspose.Excel.dll.

I am having another problem with summing values on another sheet. The error I am getting is:

Invalid formula:"=SUM(‘015- Fund Portfolio’!$A$1:$E$1)".

When I try and load the attached XML Spreadsheet using the following code:

ExcelDesigner designer = new ExcelDesigner();

MemoryStream myStream = new MemoryStream((new UnicodeEncoding()).GetBytes(excelWorkbook));

designer.Excel.Open(myStream, FileFormatType.SpreadsheetML); // ** The Line Giving Error

It works fine if I remove the SUM formula.

The version I am using is




Please try this fix.


That works a treat.

Thank you very much.