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!