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.

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. ❤️

Forum Discussion

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

Resources