Free Support Forum -

Suming Named Range in XMLSpeadsheet not working


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