How to use Auto Outline

Hi, in excel, you can click Data, Group & Outline, Auto Outline to get all the rows automatically grouped. How can I do this with Aspose?

Thanks!

Hi,

Thanks for considering Aspose.

Please check the following doc for grouping rows / columns in a worksheet:

Grouping and ungrouping rows and columns

Thank you.

Those instructions show how to do the grouping when you know your starting and ending rows, but I want to use the Auto Outline feature in Excel so it will automatically group when I don't know what the starting & ending rows are. Can you tell me how to use Auto Outline? Thanks!

Hi,

Well, you can do it with ease, kindly use Cells.MinRow and Cells.MinColumn to extract the starting row and starting column indexes. Similarly use Cells.MaxDataRow, Cells.MaxDataColumn to get the farthest row and column indexes for specifying your source range of data.

And we will look into this feature and implement it soon.

Thank you.

Hi
Has the ‘Auto Outline’ feature been implemented?

@aferriere2,

I am afraid, this is not available yet. You have to implement it manually using grouping rows and cols feature provided by Aspose.Cells.