Option |  |
Class | |
Parameters | |
xlObjects | |
RangeType |
Sum
Avg or Average
Count
CountNums
Min
Max
Product
StDev
StDevP
Var
VarP |
TopSumEx
TopAverageEx, TopAvearge2Ex
TopCountEx
TopCountNumsEx
TopMinEx
TopMaxEx
TopProductEx
TopStDevEx
TopStDevPEx
TopVarEx
TopVarPEx |
TotalOfRow=row |
[xoColumn] |
[rtRange, rtRangeRoot, rtRangeMaster, rtRangeDetail] |
|
Extended summary options.
Extends standard option functionality allowing totaling in arbitrary ranges. This feature is accessed through the use of the TotalOfRow parameter that accepts the row for which you want to get a summary.
|
|
Chart |
TopChart |
Name=n |
[xoRange] |
[rtRange] |
|
Obligatory. Refreshes the chart specified in n with data from the range. N must contain the full name of a chart, including the sheet name.
|
|
DeleteColumn |
TopDeleteColumn |
|
[xoColumn] |
[rtRange, rtRangeRoot] |
|
Deletes the column where the option is used.
|
|
Group |
TopGroupEx |
Collapse
Desc
Asc
MergeLabels
MergeLabels2
PlaceToColumn=n
WithHeader
Disablesubtotals
DisableOutline
PageBreaks |
[xoColumn] |
[rtRange, rtRangeDetail] |
|
Extends the functionality of the standard Group option. The range where the option is used must be a list (see Appendix A).
Allows creating subtotals in the ranges of the lowest level of nesting in master-detail reports. Can be used in absence of the summary options. In such a case, data are grouped without subtotals. The option row formatting is used for formatting subtotals and group headers.
In the presence of the SummaryAbove option (see below), subtotals are placed above grouped values.
The Collapse, Asc, and Desc parameters are the same as in the standard option pack.
MergeLabels and MergeLabels2 cause merging of cells in the grouped column.
PlaceToColumn allows placing the group header to a specified column.
DisableSubtotals turns off subtotals for the grouped column. Useful in report debugging. Sorts data within the group.
DisableOutline turns off an outline for the grouped column.
PageBreaks inserts page breaks between groups.
WithHeader creates a header in case of subtotals.
|
|
GroupNoSort |
TopGroupNoSort |
|
[xoRange] |
[rtRange, rtRangeDetail] |
|
The same as the standard option but can be used with extended Group option. The range where the option is used must be a list (see Appendix A).
|
|
DisableGrandTotals |
TopDisableGrandTotals |
|
[xoRange] |
[rtRange] |
|
Suppresses grand totals in the case of grouping with subtotals.
|
|
SummaryAbove
SummaryBelow |
TopSummaryAbove
TopSummaryBelow |
|
[xoRange] |
[rtRange, rtRangeDetail] |
|
Additional options to be used together with the Group option. SummaryAbove allows placing summary above grouped values. SummaryBelow (default) places summary below data.
The range where the option is used must be a list (see Appendix A).
|
|
GroupWithHeader |
TopGroupWithHeader |
|
[xoRange] |
[rtRange] |
|
Creates a group header for a subtotaled range. Works with range of a special format only.
|
|
Outline |
TopOutline |
CollapseLevel=level |
[xoRange] |
[rtRangeRoot] |
|
Allows creating the Outline view corresponding to the structure of nested ranges. Is used at the topmost level of nesting. Can be used together with the SummaryAbove and SummaryBelow options. Outline doesn't cover subtotals. Clears the outline created by the Group option.
Use the CollapseLevel parameter in order to show only a specific level in an outline.
|
|
