EPPlus Sum function issue

29 views
Skip to first unread message

Manish Katoch

unread,
Aug 8, 2025, 6:46:21 AMAug 8
to exce...@googlegroups.com, govert.va...@gmail.com
I am using RowFunctions.Sum like this
table.Columns[columnIndex].TotalsRowFunction = RowFunctions.Sum;

But this is showing a formula with #Ref!
e.g. =SUBTOTAL(109,#REF!) but it should be like =SUBTOTAL(109,[Line No.]).
If I add the formula like this
var colName = table.Columns[columnIndex].Name;
table.Columns[columnIndex].TotalsRowFormula = $"SUBTOTAL(109,[{colName}])";
Then it's working fine, but still showing this warning in Excel.
Not sure what is happening, but it was working in 4.x and not working in 7.x version
image.png

Could you help me with this?
Reply all
Reply to author
Forward
0 new messages