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?
Which version are you using? Could you please post your xml spreadsheet here? I tested this formula but didn't find this problem.
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 188.8.131.52
Please try this fix.
That works a treat.
Thank you very much.