Filter and spill

GemBox.Spreadsheet
1

When I add formula
=FILTER(A2:C9, B2:B9=F1)

to a cell the formula been
=@FILTER(A2:C9, B2:B9=F1)

Are filter not supported or what to do?

2

Hi Johan,

Try using this:

ExcelCell cell = ...
cell.SetDynamicArrayFormula("=FILTER(A2:C9, B2:B9=F1)");

Does this solve your issue?

Regards,
Mario