We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to expand or collapse the group programmatically in SfSpreadsheet?

Platform: WinRT |
Control: SfSpreadsheet |
Published Date: February 10, 2016 |
Last Revised Date: April 25, 2016
Tags: outline

SfSpreadsheet allows you to expand or collapse the groups in a worksheet.

 

Collapse group:

Groups can be collapsed by using CollapseGroup method of IRange and then hide the columns of SpreadsheetGrid like below.

 

C#

 

Expand group:

Groups can be expand by ExpandGroup method of IRange and then unhide the columns of SpreadsheetGrid like below. And also invalidate cells to refresh the view.

 

C#

 

Sample links:

 

WPF

 

WinRT

WinForms

 

UWP

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon