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

Hi,



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);



Thanks,

-Steve

Hi,

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

Fix is great, thanks!