We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Saving to SpreadsheetML from worksheet that has a named range consisting of an entire column


The worksheet that I’m trying to save to has a named range that consists of an entire column A:A. When this is saved to SpreadsheetML, and the opening it with Excel, an error occurs. A closer look at the SpreadsheetML shows that the syntax of the named range address (ss:RefersTo) is invalid:

<ss:NamedRange ss:Name=“NamedRange” ss:RefersTo="=Sheet1!=Sheet1!C1:C1" />

Here’s the code that I used to produce this result:

var workbook = new Workbook();

var worksheet = workbook.Worksheets[0];

var range = worksheet.Cells.CreateRange(0, 1, true);

range.Name = “NamedRange”;

workbook.Save(string.Format("{0}SaveSpreadsheetMLColumnNamedRanges.result.xml", TestHelper.TemplateDirectory), FileFormatType.SpreadsheetML);




Please try the fix in <A href="</A></P>

Fix is great, thanks!