subtotal

[ict@sogedin.it]

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 ??

[Simon.yang]

Hello,

Thanks for your post. I found that there was a writing error in your code which should be ',' instead of ';'.
Please change

Code: Select all

string formula = "SUBTOTAL(9;PIPPO!F6:" + "F" + (sheet.LastRow -2) + ")";

into

Code: Select all

string formula = "SUBTOTAL(9,PIPPO!F6:" + "F" + (sheet.LastRow -2) + ")";

If you still encounter issue, please write back to us and share the detail of your issue.

Best regards,
Simon
E-iceblue support team

[Simon.yang]

Hello,

Greeting from E-iceblue.
How is the issue going?
We will appreciate it if you could give us some feedback.

Best regards,
Simon
E-iceblue support team