Hello,
When I am loading an XML spreadsheet in Aspose.Excel, with the formula:
=COUNTBLANK(R4C4:R10C4)
then saving this in Excel97 format.
The formula placed in the spreadsheet is changed to:
=COUNTBLANK(‘D4:$D$10’())
Which gives an error. The correct format of the formula is:
=COUNTBLANK(D4:$D$10)
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?
Thanks
Verge.
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 3.5.2.0
Thanks
Verge
Please try this fix.
That works a treat.
Thank you very much.