How to remove groups

How to remove groups

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

• 

  2006-03-03-121549-300

  • Post Options:
  • Link
    Copy

  Posted 15 September 2017, 1:36 am EST

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

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 15 September 2017, 1:36 am EST

  Hello,

  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");
  
  or
  
     __doPostBack("FpSpread1", "Ungroup,2,2");

• 

  2006-03-03-121549-300

  • Post Options:
  • Link
    Copy

  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. 

  
  
   

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 15 September 2017, 1:36 am EST

  Hello,

  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.

• 

  2006-03-03-121549-300

  • Post Options:
  • Link
    Copy

  Posted 15 September 2017, 1:36 am EST

  Hi:

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

   

• 

  scotts-fp

  • Post Options:
  • Link
    Copy

  Posted 15 September 2017, 1:36 am EST

  Hello,

  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)}
      gm.Group(si)
      FpSpread1.Sheets(0).DataModel = gm
  

   
• 

  petergroft

  • Post Options:
  • Link
    Copy

  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.

  Greetings,
  
  Peter