JanKallman / EPPlus

Create advanced Excel spreadsheets using .NET
3.76k stars 1.17k forks source link

Array formulas cannot be recognized after parsing #63

Closed roelvandersteen closed 6 years ago

roelvandersteen commented 6 years ago

Reading array formulas is not yet supported (according to the comment in LoadCells(Xmlreader) at line 1358 else if (t == "array")), but there is some basic support.

Unfortunately, however, at this point there is no way to recognize that a formula was originally an array formula. I propose to solve this by setting the CellFlags.ArrayFormula flag for the relevant cell.

PR follows.

JanKallman commented 6 years ago

Fixed in 4.5.1