I added a formula to a cell using EPPLus C# as below.
mySheet.Cells[rowNumber, columnNumber].CreateArrayFormula”UNIQUE(FILTER({sheetName}!C:C,{sheetName}!B:B = A{rowNumber}))”));

When I open the generated xlms it shows additional curly braces around the function like below

and data is not populated from the formula.
But when I click on the formula-bar these curly braces disappear and values are populated.

​I added a formula to a cell using EPPLus C# as below.mySheet.Cells[rowNumber, columnNumber].CreateArrayFormula”UNIQUE(FILTER({sheetName}!C:C,{sheetName}!B:B = A{rowNumber}))”));When I open the generated xlms it shows additional curly braces around the function like below and data is not populated from the formula.But when I click on the formula-bar these curly braces disappear and values are populated.  Read More

​