1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#ifndef __com_sun_star_sheet_XDataPilotFieldGrouping_idl__
#define __com_sun_star_sheet_XDataPilotFieldGrouping_idl__
#include <com/sun/star/uno/XInterface.idl>
#include <com/sun/star/sheet/DataPilotFieldGroupInfo.idl>
#include <com/sun/star/lang/IllegalArgumentException.idl>
module com { module sun { module star { module sheet {
/** Provides methods to create new DataPilot fields where some or all items of
this DataPilot field are grouped in some way.
@see DataPilotField
*/
published interface XDataPilotFieldGrouping: com::sun::star::uno::XInterface
{
/** Creates a new DataPilot field which contains a group containing the
given DataPilot field items (members).
<p>It is possible to create multiple groups by calling this method
several times at the same DataPilot field. On subsequent calls, the
DataPilot field created at the first call is used to insert the new
groups.</p>
<p>The collection of groups can be accessed via the
DataPilotField::GroupInfo property. The returned
struct contains the sequence of groups in its member
DataPilotFieldGroupInfo::Groups.</p>
@param aItems
a sequence containing the names of the items (members) which will
be part of the new group. Must be names of items contained in the
current field.
@returns
the new created field if there is one created on the first call of
this method. <NULL/> is returned on subsequent calls.
@see DataPilotField
@see DataPilotFieldGroupInfo
*/
XDataPilotField createNameGroup([in] sequence< string > aItems)
raises( com::sun::star::lang::IllegalArgumentException );
/** Groups the members of this field by dates, according to the passed
settings.
<p>If this field is already grouped by dates, a new DataPilot field
will be created and returned. If this field is not grouped at all, the
date grouping is performed inside of this field (no new field will be
created). There must not be any other grouping (by member names or by
numeric ranges), otherwise an exception is thrown.</p>
@param aInfo
contains the information how to group the items of the field. The
members of this struct have to fulfill the following requirements:
<ul>
<li>If the member <member>DataPilotFieldGroupInfo::HasAutoStart
</member> is set to <FALSE/>, then the value of <member>
DataPilotFieldGroupInfo::Start</member> must be a floating-point
value representing a valid date/time value (if <member>
DataPilotFieldGroupInfo::HasAutoStart</member> is set to <TRUE/>,
the value of DataPilotFieldGroupInfo::Start will
be ignored).</li>
<li>If the member <member>DataPilotFieldGroupInfo::HasAutoEnd
</member> is set to <FALSE/>, then the value of <member>
DataPilotFieldGroupInfo::End</member> must be a floating-point
value representing a valid date/time value( if <member>
DataPilotFieldGroupInfo::HasAutoEnd</member> is set to <TRUE/>,
the value of DataPilotFieldGroupInfo::End will be
ignored).</li>
<li>If the members <member>DataPilotFieldGroupInfo::HasAutoStart
</member> and DataPilotFieldGroupInfo::HasAutoEnd
are set to <FALSE/> both, then the value of <member>
DataPilotFieldGroupInfo::Start</member> must be less than or equal
to the value of DataPilotFieldGroupInfo::End.</li>
<li>The member DataPilotFieldGroupInfo::HasDateValues
must be set to <TRUE/>.</li>
<li>The member DataPilotFieldGroupInfo::Step must
be zero, unless ranges of days have to be grouped (see the
description of the member GroupBy below), in that case the value
must be greater than or equal to 1 and less than or equal to 32767.
The fractional part of the value will be ignored.</li>
<li>The member DataPilotFieldGroupInfo::GroupBy
must contain exactly one of the flags from DataPilotFieldGroupBy.
A combination of several flags will not be accepted. If
<const>DataPilotFieldGroupBy::DAYS</const> is specified, the
value of the member DataPilotFieldGroupInfo::Step
will specify the type of day grouping (see above). If that value
is zero, grouping is performed on all days of the year (e.g. the
members containing the 1st of January of any year are grouped
together). If that value is greater than zero, grouping is done on
ranges of days, and the value specifies the number of days grouped
into one range (e.g. a value of 7 groups the members of a week
into a range).</li>
<li>The contents of the member <member>
DataPilotFieldGroupInfo::SourceField</member> will be ignored.</li>
<li>The contents of the member <member>
DataPilotFieldGroupInfo::Groups</member> will be ignored.</li>
</ul>
@returns
the new created field if there is one created. <NULL/> is returned,
if date grouping is performed inside this field (i.e. this field
was not grouped by dates before).
@throws com::sun::star::lang::IllegalArgumentException
if the passed struct does not contain valid settings as described,
or if this field is already grouped by member names or numeric
ranges.
@see DataPilotField
*/
XDataPilotField createDateGroup([in] DataPilotFieldGroupInfo aInfo)
raises( com::sun::star::lang::IllegalArgumentException );
};
}; }; }; };
#endif
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|