Formula Errors converting from SpreadsheetML


#1

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.


#2

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.


#3

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






#4

Please try this fix.


#5

That works a treat.

Thank you very much.