Hello,
You can try using the last row of the Spread as ColumnFooter using FrozenTrailingRowCount property and use the SubTotal formula in that row. Code for the same is given below:
fpSpread1.ActiveSheet.FrozenTrailingRowCount = 1;
int num = fpSpread1.Sheets[0].RowCount - 1;
fpSpread1.Sheets[0].Cells[fpSpread1.ActiveSheet.Rows.Count-1,1].Formula = "SUBTOTAL(1,B1:B" + num + ")";
Hoe this will help you. Thanks
--------------------------------------------------------------------------------
Reeva Dhingra
GrapeCity FarPoint |
陕公网安备：61019002000258 |
隐私政策 |
网站地图