LibreOffice
LibreOffice 24.2 SDK API Reference
|
These constants select different types for grouping members of a DataPilot field by date or time. More...
Variables | |
const long | SECONDS = 1 |
Groups all members of a DataPilot field containing a date/time value by their current value for seconds. More... | |
const long | MINUTES = 2 |
Groups all members of a DataPilot field containing a date/time value by their current value for minutes. More... | |
const long | HOURS = 4 |
Groups all members of a DataPilot field containing a date/time value by their current value for hours. More... | |
const long | DAYS = 8 |
Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days. More... | |
const long | MONTHS = 16 |
Groups all members of a DataPilot field containing a date/time value by their month. More... | |
const long | QUARTERS = 32 |
Groups all members of a DataPilot field containing a date/time value by their quarter. More... | |
const long | YEARS = 64 |
Groups all members of a DataPilot field containing a date/time value by their year. More... | |
These constants select different types for grouping members of a DataPilot field by date or time.
const long DAYS = 8 |
Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days.
Examples:
Calendar day grouping: The group Jan 03 will contain all members that contain the January 3rd, regardless of the year or time of the member, e.g. 2002-Jan-03 00:00:00 or 1999-Jan-03 02:12:45.
See descriptions for XDataPilotFieldGrouping::createDateGroup() for more details about day grouping.
const long HOURS = 4 |
Groups all members of a DataPilot field containing a date/time value by their current value for hours.
Example: The group 02 will contain all members that contain a time with a hour value of 2, regardless of the date, minutes and seconds of the member, e.g. 2002-Jan-03 02:00:00 or 1999-May-02 02:12:45.
const long MINUTES = 2 |
Groups all members of a DataPilot field containing a date/time value by their current value for minutes.
Example: The group :02 will contain all members that contain a time with a minutes value of 2, regardless of the date, hours and seconds of the member, e.g. 2002-Jan-03 00:02:00 or 1999-May-02 12:02:45.
const long MONTHS = 16 |
Groups all members of a DataPilot field containing a date/time value by their month.
Example: The group Jan will contain all members with a date in the month January, regardless of the year, day, or time of the member, e.g. 2002-Jan-03 00:00:00 or 1999-Jan-02 02:12:45.
const long QUARTERS = 32 |
Groups all members of a DataPilot field containing a date/time value by their quarter.
Example: The group Q1 will contain all members with a date in the first quarter of a year (i.e. the months January, February, and march), regardless of the year, day, or time of the member, e.g. 2002-Jan-03 00:00:00 or 1999-Mar-02 02:12:45.
const long SECONDS = 1 |
Groups all members of a DataPilot field containing a date/time value by their current value for seconds.
Example: The group :02 will contain all members that contain a time with a seconds value of 2, regardless of the date, hours and minutes of the member, e.g. 2002-Jan-03 00:00:02 or 1999-May-02 12:45:02.
const long YEARS = 64 |
Groups all members of a DataPilot field containing a date/time value by their year.
Example: The group 1999 will contain all members with a date in the year 1999, regardless of the month, day, or time of the member, e.g. 1999-Jan-03 00:00:00 or 1999-May-02 02:12:45.