Free Support Forum -

Cells.GroupColumns - Feature Request

I have recently upgraded to your most recent version of Aspose.Excel (including latest hotfix) and the new Cells.GroupColumns feature is working as expected. I was wondering if there is a way to specify whether the grouped columns are hidden or shown when the spreadsheet is first loaded.

It would seem that the Cells.GroupColumns function could have another argument show/hide Cells.GroupColumns(firstIndex, lastIndex, boolShowYN) or that the worksheet could have a global function like ws.ShowDetail = True or False.

In Excel, you’d highlight the entire spreadsheet and select Data -> Group and Outline -> Hide Detail to accomplish the task I’m trying to figure out.

Thank you for the great software!

Thanks for your suggestion.

I will add this function to meet your need. It will be availabe before the middle of March. Will that meet your need?

Thank you for the prompt response! I can wait for this feature as it’s not a bug fix but rather a convenience for my website user community. Overall, I am very impressed with Aspose.Excel!! Thanks again.