I'm trying to create a spreadsheet and after I populate it with the data I want to use the subtotal on a range. This is easy to do through the interop (range.Subtotal(...)), but I haven't figured out how to do it through the Excel Engine (if I can at all).
Is it possible? If so, how?
Thanks
Jason
There is no equivalent of the Subtotal method in the Excel object model. You can apply a formula to a cell which uses the SUBTOTAL or SUM functions to create a subtotal manually. You can also submit a feature request for a method to accomplish this automatically: http://devcenter.infragistics.com/Protected/RequestFeature.aspx.
Mike Dour"]You can apply a formula to a cell which uses the SUBTOTAL or SUM functions to create a subtotal manually.
This is exactly the problem. We cannot use SUBTOTAL in a formula. It seems that we cannot use any function that requires two or more arguments.
What code are you using to apply the formula? This could be a bug. You can also submit this to the support group: http://es.infragistics.com/gethelp.
Mike Dour"]What code are you using to apply the formula?
I tried
Formula::Parse("=SUBTOTAL(3,RC1:R4C1)", CellReferenceMode::R1C1)->ApplyTo(objCell);
and
objCell->ApplyFormula("=SUBTOTAL(3,B1:B5)");
Regards,
Mark Junker
I was able to use these formulas in cells, save out the workbook, and verify that the formulas evaluated correctly. Are you getting an exception when you apply the formula or is it solving incorrectly in Excel? Also, what version of the Excel assembly are you using? Its possible this was a bug with an older version and it has since been fixed.
Ok, there seems to be a bug in 8.2.20082.1000 which seems to be fixed in 8.3.20083.1009.