Enhancement request : supporty for new Excel 2019 functions

[franklentz]

trafficstars

Dear EPPlus Devs,

New Excel 2019 functions are so usefull that they are going to quickly spread: Implementation would be a great improvment !

CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN XLOOKUP XMATCH Thank you so much !

[swmal]

Hi,

Thanks for this feature request!

the following of these functions are already implemented in EPPlus 5:

CONCAT IFS SWITCH

We will look at implementing the rest of the functions you have suggested asap.

For the next version (5.2) we have focused on Finance and Engineering functions and have added more than 50 of these that were missing in previous versions.

[tghamm]

Another that would be helpful: FILTER

[swmal]

Just a note that FILTER and XLOOKUP requires support for array formulas in the calculation engine. We have this on our midterm roadmap and will implement these functions as soon as possible.

[andreasbergqvist]

Any updates on implementing XLOOKUP ?

[JanKallman]

All these functions has been implemented in EPPlus 7.