Mats Alm

Hi, please provide more detailed information on how we can recreate this problem. We need either a failing unit test or a workbook together with code that causes the issue.

@Vasar007 Did you try to log the errors as described in [this section](https://github.com/JanKallman/EPPlus/wiki/Formula-Calculation) of our wiki? Also, the support for array formulas in EPPlus 4 calc engine is not very...

Ok. One known issue is that EPPlus not yet handles array formulas properly. Dont know If that is causing this problem though. Would you mind sharing the code of your...

I think you will get more interesting output If you do this (typing this from my phone, so excuse if the code is not 100%). 1. Wrap the code in...

Hi Andreas, apologies for a very late reply. The formula calc engine in EPPlus 4 does not support the (A1:A2)*(B1:B2) piece. The result of that expression would "spill" over into...

I have not been able to reproduce an error due to a cell value set with a float. It is omitted in the if condition you are refering to, but...

Hi @abrguyt, The formula calc engine in EPPlus does not yet support array formulas. We plan to implement it in EPPlus 5. It is mentioned at the bottom of [this...

Many thanks, just to set the expectations straight - it will not be in the initial EPPlus 5 release, but when we have stabilized the new version array formulas are...

We are providing a more comprehensive explanation on this topic here: [https://www.epplussoftware.com/Home/LgplToPolyform](https://www.epplussoftware.com/Home/LgplToPolyform) EPPlus 5 is now available as a beta on Nuget and we are fully focused on making it...

Hi @PrzemyslawKlys , It can definately be used within a commercial company with the commercial license we are offering on our website https://epplussoftware.com/LicenseOverview I cannot give you detailed legal advice,...