PapaGamer74
May 08, 2023Copper Contributor
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)