How to remove groups

Posted by: 2006-03-03-121549-300 on 15 September 2017, 1:36 am EST

  • Posted 15 September 2017, 1:36 am EST

    I’am using Outlook-style grouping of rows.  How to remove groups on Client-side. 

  • Posted 15 September 2017, 1:36 am EST


    You can use the CallBack method of Spread with the Command set to Ungroup, n, m (where n is the column to ungroup and m is the column you want to place this grouped column). Or, if you need to do a full postback of the page, you can do the same command using the __doPostBack function.

       FpSpread1.CallBack("Ungroup, 2, 2");


       __doPostBack("FpSpread1", "Ungroup,2,2");

  • Posted 15 September 2017, 1:36 am EST

    Thanks, but ...

    1. To begin a new group  I double-click a column header, how to remove group from groupimg bar?
    2. In a groupimg bar I see the column name but I need to see the column header label. 


  • Posted 15 September 2017, 1:36 am EST


    1) There is not a way client side to know what column(s) have been grouped. You can use the Grouped event to get the column(s) being grouped and store off the column number in a hidden field or attribute that you can query client side. Then, you can use code like I gave you in the last post to ungroup that column.

    2) If the Spread control is bound, then the name of the bound DataColumn will display in the GroupBar. If you are not bound, we do not have a way to get at the data for the header in the GroupDataModel (model used for displaying the grouped data) so you will just get the default labels for the SheetView.

  • Posted 15 September 2017, 1:36 am EST


    How to add new group on Server-side to restore a last state of page ?


  • Posted 15 September 2017, 1:36 am EST


    If you want to implement grouping of the Spread server side, you would need to get the DataModel from the Spread as a GroupDataModel object and then call the Group method with the columns you want grouped and what sort state you want them in.

        Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.Sheets(0).DataModel)
        Dim si() As FarPoint.Web.Spread.SortInfo = New FarPoint.Web.Spread.SortInfo() {New FarPoint.Web.Spread.SortInfo(3, True)}
        FpSpread1.Sheets(0).DataModel = gm
  • Posted 28 July 2022, 5:13 pm EST

    Delete a group in Outlook

    Open Outlook for Windows.

    Under Groups on the left nav bar, select your group.

    Select Edit Group on the ribbon.

    Click the Delete Group button in the lower-left corner of the window.

    Select I understand that all group content will be deleted > Delete.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels