Forum Discussion

PapaGamer74's avatar
PapaGamer74
Copper Contributor
May 08, 2023

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)

No RepliesBe the first to reply

Resources