Difference between revisions of "Documentation/DevGuide/Spreadsheets/Hierarchies"
OOoWikiBot (Talk | contribs) m (Robot: Changing Category:Spreadsheet Documents) |
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
|NextPage=Documentation/DevGuide/Spreadsheets/Levels | |NextPage=Documentation/DevGuide/Spreadsheets/Levels | ||
}} | }} | ||
− | {{DISPLAYTITLE:Hierarchies}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Spreadsheets/{{SUBPAGENAME}}}} |
+ | {{DISPLAYTITLE:Hierarchies}} | ||
A single dimension can have several hierarchies, that is, several ways of grouping the elements of the dimension. For example, date values may be grouped: | A single dimension can have several hierarchies, that is, several ways of grouping the elements of the dimension. For example, date values may be grouped: | ||
Line 20: | Line 21: | ||
{{PDL1}} | {{PDL1}} | ||
− | [[Category:Documentation/ | + | [[Category:Documentation/Developer's Guide/Spreadsheet Documents]] |
Latest revision as of 10:31, 14 May 2009
A single dimension can have several hierarchies, that is, several ways of grouping the elements of the dimension. For example, date values may be grouped:
- in a hierarchy with the levels "year", "month" and "day of month".
- in a hierarchy with the levels "year", "week" and "day of week".
The property UsedHierarchy
of the com.sun.star.sheet.DataPilotSourceDimension service selects which hierarchy of a dimension is used. The property contains an index into the sequence of names that is returned by the dimension's getElementNames()
method. OpenOffice.org API Calc currently has no user interface to select a hierarchy, so it uses the hierarchy that the initial value of the UsedHierarchy
property selects.
The com.sun.star.sheet.DataPilotSourceHierarchy service serves as a container to access the levels object.
In the example, each dimension has only one hierarchy, which in turn has one level.
Content on this page is licensed under the Public Documentation License (PDL). |