Missing range calculation

[ihorbach]

trafficstars

there are two possibilities in excel to sum up two colums row by row:

1. write formula =B1+C1 in the cell D1 and copy it down the column

2. create named range range_1 for the column B and range_2 for the column C write formula =range_1+range_2 , select the whole colum D an copy-paste it there

The second way is much more elegant and flexible, when working with very big excel ranges, which length constantly changes. EPPlus seems not to know this expression

[JanKallman]

Dynamic array formulas is currently not supported by EPPlus. We will add this in a coming version.

[ihorbach]

Hello Jan, can you look at my pull request to this issue? https://github.com/EPPlusSoftware/EPPlus/pull/769 I don't know, if you already began to work on this feature. Otherwise it might be helpful.

[JanKallman]

Yes, we are working on a major redesign of the dependency chain and expression handling where we will implement dynamic array formulas... https://github.com/EPPlusSoftware/EPPlus/tree/feature/formula_parser_rpn

[ashahabov]

This article mentions that EPPlus 7 Preview now supports "Dynamic array formulas". Does this mean that the issue has been resolved in the develop branch?

I'm asking because the test from #769 PR is still failing.

[swmal]

@ashahabov - sorry for the late response to this issue. Dynamic arrayformulas is supported in EPPlus 7, see this wiki page