I tried using Spire.Xls, to generate .xlsx from .xltx.
However, copying sheet containing a named cell seems to cause issue.
Found a issue in the following scenario.
used 'Spire.XLS Pack (Hotfix) Version: 9.6.7'.
Named 'value' cell are defined in the 'data' sheet and have global scope.
the 'ng' sheet in defined a named 'group' with multiple cells and has a scope for the sheet.
reference a named 'value' cell, from in range of named 'group'.
Copy the 'ng' sheet, using Spire.Xls.
- Code: Select all
using (var workbook = new Workbook())
{
workbook.LoadTemplateFromFile("./origin.xltx");
workbook.Worksheets.AddCopy(workbook.Worksheets["ng"]);
workbook.CalculateAllValue();
workbook.SaveToFile("./issue.xlsx");
}
in the copied sheet('ng_1'), the formula referring to 'value' is incorrect.
named 'value' cell scoped to the copied sheet is added, and referenced.
Is there a way to work around this problem?
Sorry for ugly English.
Thanks.