 
Full list of XL Report ProOptionPack™ options
What follow below is a full list of ProOptionPack™ options and their parameters:
CHART |
|
Refreshes a given chart with list range data.
|
SUM, AVG, AVERAGE, COUNT, COUNTNUMS, MAX, MIN, PRODUCT, STDEV, STDEVP, VAR, VARP |
Now you can get totals in arbitrary ranges through the use of the \TOTALOFROW parameter.
|
GROUP (with subtotals) |
Available parameters: ASC, DESC, COLLAPSE, MERGELABELS, MERGELABELS2, PLACETOCOLUMN, DISABLEOUTLINE.
|
GROUP (without subtotals) |
Available parameters: ASC, DESC, COLLAPSE, MERGELABELS, MERGELABELS2, PLACETOCOLUMN, WITHHEADER, DISABLEOUTLINE, DISABLESUBTOTALS, PAGEBREAKS.
|
SUMMARYABOVE, SUMMARYBELOW |
Range options. Allow placing the summary row below or above the group header (if any).
|
GROUPWITHHEADER |
Allows using all features available for usual cells straight in the group header.
|
GROUPWITHHEADER |
Allows using all features available for usual cells straight in the group header.
|
DELETECOLUMN |
Deletes a column of a range.
|
OUTLINE |
Allows creating the Outline view for nested ranges.
|
How to get more details
|
TxlProPackage
