Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Andrew
530
It is possible to control the expanded / collapsed setting of the outlines in Excel via Infragistics.Excel library?
posted

Using the Infragistics.Excel library, I see that it is possible to create hierarchies in workbooks via setting the outline level. Is it possible to set whether or not each outline level is expanded or collapsed when the user opens the spreadsheet via code?

  • 44743
    posted

    If you set Hidden all rows/column in the group to True, that will collapse the group. If you set it to False on all rows/columns, it will expand the group.