Worksheet.Cells.GroupRows question

Aspose.Cells Product Family
1

In excel, when you create a group of rows, it defaults to having the summary inforamtion at the bottom of the group. Your method WorkSheet.Cells.GroupRows performs in this same manner.

However, in excel, you can change the settings for that group to say that the summary information is at the top of that group. Excel menu path is: Data/Group and Outline/Settings....

I have not found how to duplicate this using Aspose. Can you tell me how to accomplish this. If it does not exist, can you add this feature?

Thank you, James

2

Hi James,

Thanks for considering Aspose.

Well The feature is not supported yet. Cells.GroupRows() always refers summay rows to below of the detail and Cells.GroupColumns() always refers summay cols to right of the detail. We will consider this feature in future releases.

Regards

Amjad Sahi

Aspose Nanjing Team

3

Actually we have already implemented this feature. Please check Grouping rows and columns.

Could it serve your need, James?

4

Yes!

Thank you, Thank you, Thank you

James