CosminSocaciu
asked on
C1 FlexGridClassic Merge Headers
I've used a Flex grdi from C1 to display some info.
How can I merge the header from the Grid ? I have two fixed rows and I've set the merge style to FixedOnly. I've merged cells from different rows but I can't merge cell from same row.
I also can't acces Row collection to set AllowMerging to true.It says it is a read-only collection.
Thanks !!!
How can I merge the header from the Grid ? I have two fixed rows and I've set the merge style to FixedOnly. I've merged cells from different rows but I can't merge cell from same row.
I also can't acces Row collection to set AllowMerging to true.It says it is a read-only collection.
Thanks !!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
.AllowMerging = AllowMergingEnum.FixedOnly
' create row headers
.Rows(0).AllowMerging = True
'---------- Create group header (merge some cells) ------------------
' Group 1 merge
Dim rng As CellRange '= .GetCellRange(0, 0, 0, 1)
'rng.Data = "Heading"
rng = .GetCellRange(0, 3, 0, 7)
rng.Data = "Transactions"
' Group 3 merge
rng = .GetCellRange(0, 8, 0, 12)
rng.Data = "Cumulative"
' Group 4 merge
rng = .GetCellRange(0, 13, 0, 17)
rng.Data = "Other Info"