gcSpreadGrid1.SetClip(0, 0, 1, 10, "Japan\tJapan\tJapan\tJapan\tJapan\tChina\tChina\tChina\tChina\tChina");
gcSpreadGrid1.SetClip(1, 0, 1, 10, "Tokyo\tTokyo\tTokyo\tSendai\tSendai\tSendai\tSendai\tBeijing\tBeijing\tBejing");
gcSpreadGrid1.Rows[0].MergePolicy = GrapeCity.Windows.SpreadGrid.MergePolicy.Restricted;
gcSpreadGrid1.Rows[1].MergePolicy = GrapeCity.Windows.SpreadGrid.MergePolicy.Always;
gcSpreadGrid1.SetClip(0, 0, 1, 10, "Japan" & vbTab & "Japan" & vbTab & "Japan" & vbTab & "Japan" & vbTab & "Japan" & vbTab & "China" & vbTab & "China" & vbTab & "China" & vbTab & "China" & vbTab & "China")
gcSpreadGrid1.SetClip(1, 0, 1, 10, "Tokyo" & vbTab & "Tokyo" & vbTab & "Tokyo" & vbTab & "Sendai" & vbTab & "Sendai" & vbTab & "Sendai" & vbTab & "Sendai" & vbTab & "Beijing" & vbTab & "Beijing" & vbTab & "Bejing")
gcSpreadGrid1.Rows(0).MergePolicy = GrapeCity.Windows.SpreadGrid.MergePolicy.Restricted
gcSpreadGrid1.Rows(1).MergePolicy = GrapeCity.Windows.SpreadGrid.MergePolicy.Always