HotXLS-documentatie

Startpagina Inhoud Overzicht

UnGroup methode

Promotes a range in an outline (that is, decreases its outline level)

Syntaxis

procedure UnGroup(Rows: boolean = true);

Rows	Boolean (optioneel). True om rijen te ontgroeperen; False om kolommen te ontgroeperen. Default value is True

Voorbeeld

This example ungroups three first rows on sheet one

Workbook.Sheets[1].Range['A1', 'A3'].UnGroup;

This example is the same to previous

Workbook.Sheets[1].Range['A1', 'A3'].UnGroup(True);

This example is the same to previous

Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup;

This example is the same to previous

Workbook.Sheets[1].Range['A1', 'A3'].Rows.UnGroup(True);

This example ungroups three first columns on sheet one

Workbook.Sheets[1].Range['A1', 'C1'].UnGroup(False);

This example is the same to previous

Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup;

This example is the same to previous

Workbook.Sheets[1].Range['A1', 'C1'].Columns.UnGroup(False);

This example ungroups rows row1 through row2

Workbook.Sheets[1].RCRange[row1, 1, row2, 1].UnGroup;

This example ungroups columns col1 through col2

Workbook.Sheets[1].RCRange[1, col1, 1, col2].Columns.UnGroup;

Zie ook

Group method
ClearOutline method
OutlineLevel eigenschap