Group metodo
Demotes the Range (increases its
outline level)
Sintassi
procedura Group(Rows: boolean = true);
| Rows |
Boolean (facoltativo). True per raggruppare le righe; False per raggruppare le colonne. Il valore predefinito è True |
Esempio
This example groups three first rows on sheet one
Workbook.Sheets[1].Range['A1', 'A3'].Group;
This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].Group(True);
This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].Rows.Group;
This example is the same to previous
Workbook.Sheets[1].Range['A1', 'A3'].Rows.Group(True);
This example groups three first columns on sheet one
Workbook.Sheets[1].Range['A1', 'C1'].Group(False);
This example is the same to previous
Workbook.Sheets[1].Range['A1', 'C1'].Columns.Group;
This example is the same to previous
Workbook.Sheets[1].Range['A1', 'C1'].Columns.Group(False);
This example groups rows row1 through row2
Workbook.Sheets[1].RCRange[row1, 1, row2, 1].Group;
This example groups columns col1 through col2
Workbook.Sheets[1].RCRange[1, col1, 1, col2].Columns.Group;
Vedere also