Turn around GroupColumns


#1

Hello,

for example it like to group the columns 5-15.

With excel.Worksheets[0].Cells.GroupColumns(5, 15); everything works for me.

But the Groupingsymbol ("+") at the top of the page is above the column 15.

I've got a customner who like to have the symbol above column 5.

It tried to turn around the parameters (excel.Worksheets[0].Cells.GroupColumns(15, 5);) but it won't work for me!

Is it it possible to change the direction of grouping? In Excel I could group the cells this way!

Best Regards

Sören


#2

Please try:

excel.Worksheets[0].Cells.GroupColumns(5, 15);

excel.Worksheets[0].SummaryColumnRight = false;


#3

Thanks!

the following works for me: excel.Worksheets[0].Outline.SummaryColumnRight = false;