1 /*************************************************************************
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 * Copyright 2008 by Sun Microsystems, Inc.
7 * OpenOffice.org - a multi-platform office productivity suite
9 * $RCSfile: XMultipleOperation.idl,v $
12 * This file is part of OpenOffice.org.
14 * OpenOffice.org is free software: you can redistribute it and/or modify
15 * it under the terms of the GNU Lesser General Public License version 3
16 * only, as published by the Free Software Foundation.
18 * OpenOffice.org is distributed in the hope that it will be useful,
19 * but WITHOUT ANY WARRANTY; without even the implied warranty of
20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 * GNU Lesser General Public License version 3 for more details
22 * (a copy is included in the LICENSE file that accompanied this code).
24 * You should have received a copy of the GNU Lesser General Public License
25 * version 3 along with OpenOffice.org. If not, see
26 * <http://www.openoffice.org/license.html>
27 * for a copy of the LGPLv3 License.
29 ************************************************************************/
31 #ifndef __com_sun_star_sheet_XMultipleOperation_idl__
32 #define __com_sun_star_sheet_XMultipleOperation_idl__
34 #ifndef __com_sun_star_uno_XInterface_idl__
35 #include
<com
/sun
/star
/uno
/XInterface.idl
>
38 #ifndef __com_sun_star_table_CellRangeAddress_idl__
39 #include
<com
/sun
/star
/table
/CellRangeAddress.idl
>
42 #ifndef __com_sun_star_sheet_TableOperationMode_idl__
43 #include
<com
/sun
/star
/sheet
/TableOperationMode.idl
>
46 #ifndef __com_sun_star_table_CellAddress_idl__
47 #include
<com
/sun
/star
/table
/CellAddress.idl
>
50 //=============================================================================
52 module com
{ module sun
{ module star
{ module sheet
{
54 //=============================================================================
56 /** provides a method to apply a Multiple Operations Table to the
59 published
interface XMultipleOperation
: com
::sun
::star
::uno
::XInterface
61 //-------------------------------------------------------------------------
63 /** creates a table of formulas (a "Multiple Operations Table").
65 <p>The specified formulas are repeated, with references to the
66 specified cells replaced by references to values in the first
67 column and/or row of the range.</p>
70 the range that contains formula cells (modes
71 <const>TableOperationMode::ROW</const> or
72 <const>TableOperationMode::COLUMN</const>) or a single formula
73 cell (mode <const>TableOperationMode::BOTH</const>).
76 specifies the calculation mode to fill the cells.
79 contains the address of the cell that is referenced by
80 formulas in a row (mode <const>TableOperationMode::ROW</const>)
81 or by the formula cell used for two value series (mode
82 <const>TableOperationMode::BOTH</const>). This parameter is not
83 used if mode is <const>TableOperationMode::COLUMN</const>.
86 contains the address of the cell that is referenced by
87 formulas in a column (mode <const>TableOperationMode::COLUMN</const>)
88 or by the formula cell used for two value series (mode
89 <const>TableOperationMode::BOTH</const>). This parameter is not
90 used if mode is <const>TableOperationMode::ROW</const>.
92 void setTableOperation
(
93 [in] com
::sun
::star
::table
::CellRangeAddress aFormulaRange
,
94 [in] com
::sun
::star
::sheet
::TableOperationMode nMode
,
95 [in] com
::sun
::star
::table
::CellAddress aColumnCell
,
96 [in] com
::sun
::star
::table
::CellAddress aRowCell
);
100 //=============================================================================