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.