Using FILTER function inside CellFormula via openXML shows only one result and need refresh
Hi, here is the code I used to create a formula with openXML that starts with FILTER (see code below) -> When it opens up inside excel I got the formula wrapped with curly brackets and shows only one value: {=FILTER(BallStats[Ball];BallStats[count]<DrawStatistics!J3)} I need to go on the cell and hot enter to refresh the cell, then it shows the correct result. Also set the FullCalculationOnLoad = True on the document CalculationProperties. Thanks. Code: Dim CellFormula As CellFormula = New CellFormula() With {.FormulaType = CellFormulaValues.Array, .Reference = c.CellReference} CellFormula.CalculateCell = True CellFormula.AlwaysCalculateArray = True CellFormula.Text = v c.Append(CellFormula)