Dokumentacija HotXLS

SummaryColumn svojstvo

Vraća or sets the location of the summary columns in the outline. Read/write XlSummaryColumn

Sintaksa

property SummaryColumn: XlSummaryColumn;

Opis

SummaryColumn can be one of these XlSummaryColumn constants
xlLeft The summary column will be positioned to the left of the detail columns in the outline
xlRight The summary column will be positioned to the right of the detail columns in the outline

Primjer

This example sets SummaryColumn property on sheet one to xlSummaryOnLeft

book.Worksheets[1].Outline.SummaryColumn := xlLeft;