Aug 31, 2011 at 10:42 PM
Edited Sep 1, 2011 at 12:23 AM
First of all I'd like to thank you for your amazing job. Epplus is a really usefull tool.
I'm opening this discussion to focus on array formulas; not creating them using eeplus but having a template that have them processed by eeplus.
The steps to reproduce the error is:
1 - Create a .xlsx file with an arbitrary number of sheets;
2 - Put an array formula in one cell of one sheet
3 - Process the file using it as a template (new ExcelPackage(new FileInfo(path), new FileInfo(templatePath))) and insert an abitrary number of rows on any sheet (not necessarily the sheet containing the array formula)
4 - The resulting file got its array formulas transformed into regular formulas (which, obviously, don't work anymore)
The expected result was to have the formulas intact, since no change was made to the whole sheet (let alone the particular cell containing the array formula)
Moreover, and I don't know if its supposed to, I checkout the trunk and I got a lot of XML errors while saving the package. I know that the trunk isn't supposed to work all the time but I'm giving the heads up anyway. BTW, I checked it out to see if this
whole array formulas being transformed in regular formulas problem was already solved.
Did anyone run into this problem as well? Is there a solution/workaround?
I'm using epplus 18.104.22.168 (from here: http://epplus.codeplex.com/releases/view/67324#DownloadId=245824)