-
Notifications
You must be signed in to change notification settings - Fork 267
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Editing a table using structured references in formulas result in a broken Excel sheet. #1314
Comments
I can not reproduce this. I tried with this test with a workbook containing this formula : "Table1[[#This Row],[a]]=Table1[[#This Row],[b]]" Test Code... using (var p = OpenTemplatePackage("i1314.xlsx"))
{
var ws = p.Workbook.Worksheets[0];
var tbl = ws.Tables[0];
tbl.InsertRow(1,1);
tbl.AddRow(1);
SaveAndCleanup(p);
} Are you using EPPlus 7.0.9? |
Epplus6bug..zip |
Yes, it this seems to happen when you have an array table formula that reference the entire column. If you want to compare the cells per row, use this format instead:
|
That is |
From EPPlus 7 adding rows to a table from a template using structured references in a table formula (for instance =@[ColumnName1]=@[ColumnName2]) results in a corrupted Excel file. On opening Excel needs to repair the sheet but then the table is broken. If I change the formulatype to explicit (=C1=D1) the table is no longer corrupted, Excel does show warnings in the cells about the cell formula not being equal to the table column formula.
The text was updated successfully, but these errors were encountered: