Properties' Summary |
DataPilotFieldOrientation
Orientation |
specifies the orientation of the field.
|
GeneralFunction
Function |
specifies the function used to calculate results for this field.
|
sequence< GeneralFunction >
Subtotals |
[ OPTIONAL ]
specifies the functions used to calculate subtotals for this field.
|
string
SelectedPage |
[ OPTIONAL ]
specifies the selected page which is used to filter the data pilot.
|
boolean
UseSelectedPage |
[ OPTIONAL ]
specifies whether to use the selected page to filter the data pilot or
show all.
|
string
UsedHierarchy |
[ OPTIONAL ]
specifies which hierarchy of the dimension is used.
|
boolean
HasSortInfo |
[ OPTIONAL ]
specifies whether this field has sorting information.
|
DataPilotFieldSortInfo
SortInfo |
[ OPTIONAL ]
controls how the field's items are sorted.
|
boolean
HasLayoutInfo |
[ OPTIONAL ]
specifies whether this field has layout information.
|
DataPilotFieldLayoutInfo
LayoutInfo |
[ OPTIONAL ]
controls how the field's items are laid out in the result table.
|
boolean
HasAutoShowInfo |
[ OPTIONAL ]
specifies whether this field has auto show information.
|
DataPilotFieldAutoShowInfo
AutoShowInfo |
[ OPTIONAL ]
enables the automatic inclusion of only a number of items with
the highest or lowest result values.
|
boolean
HasReference |
[ OPTIONAL ]
specifies whether this field has a reference.
|
DataPilotFieldReference
Reference |
[ OPTIONAL ]
controls how the results are shown in relation to a selected
reference result.
|
boolean
IsGroupField |
[ OPTIONAL ]
specifies whether this field is a group field.
|
DataPilotFieldGroupInfo
GroupInfo |
[ OPTIONAL ]
contains the grouping information of the DataPilot field.
|
boolean
ShowEmpty |
[ OPTIONAL ]
specifies whether to show this field also if it is empty or not.
|
short
Function2 |
[ OPTIONAL ]
specifies the function used to calculate results for this field.
|
sequence< short >
Subtotals2 |
[ OPTIONAL ]
specifies the functions used to calculate subtotals for this field.
|
Properties' Details |
Orientation
DataPilotFieldOrientation Orientation;
- Description
- specifies the orientation of the field.
If the orientation of a field has been changed using this property,
the field will be moved to the last position in the collection of all
fields with the specified orientation.
|
|
Function
GeneralFunction Function;
- Description
- specifies the function used to calculate results for this field.
For column and row fields, this is the function for subtotals
(GeneralFunction::NONE means no subtotals).
For data fields, this is the function shown in the data pilot
table.
|
|
Subtotals
sequence< GeneralFunction > Subtotals;
- Usage Restrictions
- optional
- Description
- specifies the functions used to calculate subtotals for this field.
This property is supported by column and row fields only.
An empty sequence means no subtotals. The same effect can be
achieved by setting the property #Function to the
value GeneralFunction::NONE. If the length of the
sequence is greater than 1, then the sequence MUST NOT contain one of
the values GeneralFunction::NONE or
GeneralFunction::AUTO.
The order of the functions in this sequence is reflected in the
DataPilot table. Multiple entries of the same function are ignored
when setting the property.
|
|
SelectedPage
string SelectedPage;
- Usage Restrictions
- optional
- Description
- specifies the selected page which is used to filter the data pilot.
|
|
UseSelectedPage
boolean UseSelectedPage;
- Usage Restrictions
- optional
- Description
- specifies whether to use the selected page to filter the data pilot or
show all.
|
|
UsedHierarchy
string UsedHierarchy;
- Usage Restrictions
- optional
- Description
- specifies which hierarchy of the dimension is used.
- See also
- DataPilotSourceHierarchies
|
|
HasSortInfo
boolean HasSortInfo;
- Usage Restrictions
- optional
- Description
- specifies whether this field has sorting information.
|
|
SortInfo
DataPilotFieldSortInfo SortInfo;
- Usage Restrictions
- optional
- Description
- controls how the field's items are sorted.
|
|
HasLayoutInfo
boolean HasLayoutInfo;
- Usage Restrictions
- optional
- Description
- specifies whether this field has layout information.
|
|
LayoutInfo
DataPilotFieldLayoutInfo LayoutInfo;
- Usage Restrictions
- optional
- Description
- controls how the field's items are laid out in the result table.
|
|
HasAutoShowInfo
boolean HasAutoShowInfo;
- Usage Restrictions
- optional
- Description
- specifies whether this field has auto show information.
|
|
AutoShowInfo
DataPilotFieldAutoShowInfo AutoShowInfo;
- Usage Restrictions
- optional
- Description
- enables the automatic inclusion of only a number of items with
the highest or lowest result values.
|
|
HasReference
boolean HasReference;
- Usage Restrictions
- optional
- Description
- specifies whether this field has a reference.
|
|
Reference
DataPilotFieldReference Reference;
- Usage Restrictions
- optional
- Description
- controls how the results are shown in relation to a selected
reference result.
|
|
IsGroupField
boolean IsGroupField;
- Usage Restrictions
- optional
- Description
- specifies whether this field is a group field.
|
|
GroupInfo
DataPilotFieldGroupInfo GroupInfo;
- Usage Restrictions
- optional
- Description
- contains the grouping information of the DataPilot field.
By changing the value of this property it is possible to modify the
grouping settings of this field.
|
|
ShowEmpty
boolean ShowEmpty;
- Usage Restrictions
- optional
- Description
- specifies whether to show this field also if it is empty or not.
|
|
Function2
short Function2;
- Usage Restrictions
- optional
- Description
- specifies the function used to calculate results for this field.
For column and row fields, this is the function for subtotals
(GeneralFunction2::NONE means no subtotals).
For data fields, this is the function shown in the data pilot
table.
Since LibreOffice 5.3
|
|
Subtotals2
sequence< short > Subtotals2;
- Usage Restrictions
- optional
- Description
- specifies the functions used to calculate subtotals for this field.
This property is supported by column and row fields only.
An empty sequence means no subtotals. The same effect can be
achieved by setting the property #Function2 to the
value GeneralFunction::NONE. If the length of the
sequence is greater then 1, then the sequence MUST NOT contain one of
the values GeneralFunction2::NONE or
GeneralFunction2::AUTO.
The order of the functions in this sequence is reflected in the
DataPilot table. Multiple entries of the same function are ignored
when setting the property.
Since LibreOffice 5.3
|
|
Copyright © 2020, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.