We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
We still have some issues with array formulas.
Notably something like:
[TestMethod] public void DynamicArrayFormulaWithTwoCellsInTableGenerateCorruptWorkbook() { using (var package = OpenPackage("DynamicArrayTableNew.xlsx", true)) { var wb = package.Workbook; var sheet = wb.Worksheets.Add("newWorksheet"); var excelTable = sheet.Tables.Add(sheet.Cells["A1:D4"], "TableTest"); sheet.Cells["D2:D3"].CreateArrayFormula("SUM(A2:B2 * 1)", true); SaveAndCleanup(package); } }
Creates a corrupt workbook.
Meanwhile in Excel selecting D2:D3 and applying =SUM(A2:B2 * 1) applies it to a tables whole column:
=SUM(A2:B2 * 1)
Trying to apply it as an array formula (`ctrl+shift) results in an error:
Epplus should also throw an error.
This is also somewhat related to #1314 and #1642
This issue also appears when IsDynamic is set to false.
IsDynamic
The text was updated successfully, but these errors were encountered:
No branches or pull requests
We still have some issues with array formulas.
Notably something like:
Creates a corrupt workbook.
Meanwhile in Excel selecting D2:D3 and applying
![Image](https://private-user-images.githubusercontent.com/122265629/410466945-633f409c-1b50-4877-9ac7-2d1ce23e33e0.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5MTYzNDcsIm5iZiI6MTczODkxNjA0NywicGF0aCI6Ii8xMjIyNjU2MjkvNDEwNDY2OTQ1LTYzM2Y0MDljLTFiNTAtNDg3Ny05YWM3LTJkMWNlMjNlMzNlMC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QwODE0MDdaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05ODgwZWViMmIyNmM5OGI4MzBjZTNkZjc1OTZlZmFjYmVmODk3YmQwODA1NDUyNzc1NzQwNTk1NDEzZGQxZDkwJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.Z9v4mPSP9WoxCx403vOKhJjA4yufm7kamGQI6G0yGQI)
=SUM(A2:B2 * 1)
applies it to a tables whole column:Trying to apply it as an array formula (`ctrl+shift) results in an error:
Epplus should also throw an error.
This is also somewhat related to #1314 and #1642
This issue also appears when
IsDynamic
is set to false.The text was updated successfully, but these errors were encountered: