hi, i this situation
sheet.InsertDataTable(tbUltima, true, _riga + 1, 1);
sheet.Range[_riga, 5].NumberFormat = "#,##0";
sheet.ListObjects.Create("Table" + i.ToString(), sheet.Range[_riga + 1, 1, sheet.LastRow, sheet.LastColumn]);
sheet.ListObjects[0].BuiltInTableStyle = TableBuiltInStyles.TableStyleLight9;
Now I want insert to subtotal column name "PIPPO"
i try
string formula = "SUBTOTAL(9;PIPPO!F6:" + "F" + (sheet.LastRow -2) + ")";
_row = sheet.LastRow + 1;
sheet.Range[_row , 5].Formula = formlula;
but nod bad
Can You help me ??