Using FILTER function inside CellFormula via openXML shows only one result and need refresh

Copper Contributor

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:



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.






Dim CellFormula As CellFormula = New CellFormula() With {.FormulaType = CellFormulaValues.Array, .Reference = c.CellReference}
CellFormula.CalculateCell = True
CellFormula.AlwaysCalculateArray = True
CellFormula.Text = v

0 Replies