offapi/com/sun/star/sheet/XCellRangeFormula.idl

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: XCellRangeFormula.idl,v $
  10  * $Revision: 1.8 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  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.
  17  *
  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).
  23  *
  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.
  28  *
  29  ************************************************************************/
  30
  31 #ifndef __com_sun_star_sheet_XCellRangeFormula_idl__
  32 #define __com_sun_star_sheet_XCellRangeFormula_idl__
  33
  34 #ifndef __com_sun_star_uno_XInterface_idl__
  35 #include <com/sun/star/uno/XInterface.idl>
  36 #endif
  37
  38 //=============================================================================
  39
  40 module com {  module sun {  module star {  module sheet {
  41
  42 //=============================================================================
  43
  44 /** allows to get and set cell contents (values, text or formulas)
  45     for a cell range.
  46
  47     <p>The outer sequence represents the rows and the inner sequence
  48     the columns of the array.</p>
  49
  50     @since OOo 1.1.2
  51  */
  52
  53 published interface XCellRangeFormula: com::sun::star::uno::XInterface
  54 {
  55     /** gets an array from the contents of the cell range.
  56
  57         <p>Each element of the result contains the same string that
  58         would be returned by
  59         <member scope="com::sun::star::table">XCell::getFormula()</member>
  60         for the corresponding cell.</p>
  61      */
  62     sequence< sequence< string > > getFormulaArray();
  63
  64     /** fills the cell range with values from an array.
  65
  66         <p>The size of the array must be the same as the size of the cell
  67         range. Each element of the array is interpreted the same way as
  68         the argument to a
  69         <member scope="com::sun::star::table">XCell::setFormula()</member>
  70         call for the corresponding cell.</p>
  71
  72         @throws <type scope="com::sun::star::uno">RuntimeException</type>
  73             If the size of the array is different from the current size.
  74      */
  75     void setFormulaArray( [in] sequence< sequence< string > > aArray );
  76 };
  77
  78 //=============================================================================
  79 }; }; }; };
  80
  81 #endif
  82