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