Range.Subtotal different than menu function

[CJJ]

When I interactively use the Data->Subtotals function, it creates the
subtotal lines and grand total line at the bottom, correctly per my
grouping column and subtotal columns. It also puts in "range bars" on
the left hand side that allows easy navigation, collapsing, expansion
of the subtotal groups.

When I do the same thing from c# code using the Range.Subtotal
function, using the same parameter values, I get only the subtotal
values and not the "range bars". Is that correct behavior? How do I
create those range bars from my code?

Thanks in advance,

CJJ

 

[CJJ]

When I interactively use the Data->Subtotals function, it creates the
subtotal lines and grand total line at the bottom, correctly per my
grouping column and subtotal columns. It also puts in "range bars" on
the left hand side that allows easy navigation, collapsing, expansion
of the subtotal groups.

When I do the same thing from c# code using the Range.Subtotal
function, using the same parameter values, I get only the subtotal
values and not the "range bars". Is that correct behavior? How do I
create those range bars from my code?

Thanks in advance,

CJJ

after further research, the "range bars" I allude to are actually
"Outlines". And the solution may lie in performing an "automatic
outline" operation on the range that includes the subtotal lines

 

[Doug Glancy]

CJJ,

Try doing it interactively with the Macro Recorder turned on. That could
show you your missing settings.

hth,

Doug