Forum Discussion

Copper Contributor

Oct 26, 2023

Solved

Implicit intersection operator: @, breaking the excel generated from C# code

I am trying to generate a excel document, with a SUM total cell having a formula: =SUM(ROUNDUP(A1:A3,2)) But when I write a formula in C# code as shown below: workSheet.Cells[1, column.Val...

excel

Formulas and Functions

rachel
Oct 28, 2023
Yes, writing it as an array formula works for me:

worksheet.Range("A4:A4").FormulaArrayA1 = "=SUM(ROUNDUP(A1:A3,2))";

I use "using ClosedXML.Excel;" in csharp.

JKPieterse

Silver Contributor

Oct 26, 2023

Your screenshot formula doesn't match the one in your text. That being said, the range object has a (set of) new Formula2 property/properties you should be using when placing Dynamic array-capable formulas into cells.

rachel

Iron Contributor

Oct 28, 2023

Yes, writing it as an array formula works for me:

worksheet.Range("A4:A4").FormulaArrayA1 = "=SUM(ROUNDUP(A1:A3,2))";

I use "using ClosedXML.Excel;" in csharp.

girishjedar
Copper Contributor
Oct 30, 2023
You are the best!!!! Thank you so much Rachel. ❤️