Free Support Forum - aspose.com

Suming Named Range in XMLSpeadsheet not working

Hi,



When I have an XML spreadsheet with a named range on one sheet, and try to sum this on another sheet, I get the error:



Invalid formula:“SUM(SumThisRange)”.



When trying to open the spreadsheet:



template.Excel.Open(@“C:\aspose\SumNamedRange.xml”, FileFormatType.SpreadsheetML);



The SUM works fine when opened in excel.

I have attached an example spreadsheet to this message.



Thank you



Verge