We are trying Spire.Xls 9.7 for use in our products.
And I found the issue.
Execute the following code for 'template.xltx'.
- Code: Select all
using (var workbook = new Workbook())
{
workbook.LoadTemplateFromFile("./template.xltx");
var sheet1 = workbook.Worksheets["Sheet1"];
workbook.Worksheets.AddCopy(sheet1);
sheet1.DeleteRow(1);
workbook.SaveToFile("./issue.xlsx");
}
The generated "issue.xlsx" be opened in Excel, and dialog will appear asking if want to recover the file.
When the file is recovered, formula at the bottom line of copied 'Sheet1_1' is '#N/A', which is incorrect.
This problem does not occur if do not copy sheets or delete rows.
Thanks in advance.