Posted 8 September 2017, 3:26 pm ESTI'd like to automatically group the rows in a spread grid automatically without dragging the column to the top. I'd like to group by a column called name, and group all subsequent rows with the same name. I currently can do this by dragging the name column to the top, using the standard grouping procedure, but is there a way to group by the first column by default, without needing to drag the column to the top?
Right now I have this, but would like to replace with code that automatically groups by column 0, without having the user drag the column to the top.
fpSpread1.AllowColumnMove = true;
fpSpread1.Sheets.GroupBarInfo.Visible = true;
fpSpread1.Sheets.AllowGroup = true;
fpSpread1.Sheets.GroupingPolicy = FarPoint.Win.Spread.Model.GroupingPolicy.CollapseAll;
I'm currently using Spread for Win Forms v. 6.0, .NET 4.0 and Visual Studio 2012