1d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5d1766043SAndrew Rist * distributed with this work for additional information 6d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14d1766043SAndrew Rist * software distributed under the License is distributed on an 15d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17d1766043SAndrew Rist * specific language governing permissions and limitations 18d1766043SAndrew Rist * under the License. 19cdf0e10cSrcweir * 20d1766043SAndrew Rist *************************************************************/ 21d1766043SAndrew Rist 22d1766043SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellRangeFormula_idl__ 25cdf0e10cSrcweir#define __com_sun_star_sheet_XCellRangeFormula_idl__ 26cdf0e10cSrcweir 27cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 28cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 29cdf0e10cSrcweir#endif 30cdf0e10cSrcweir 31cdf0e10cSrcweir//============================================================================= 32cdf0e10cSrcweir 33cdf0e10cSrcweirmodule com { module sun { module star { module sheet { 34cdf0e10cSrcweir 35cdf0e10cSrcweir//============================================================================= 36cdf0e10cSrcweir 37cdf0e10cSrcweir/** allows to get and set cell contents (values, text or formulas) 38cdf0e10cSrcweir for a cell range. 39cdf0e10cSrcweir 40cdf0e10cSrcweir <p>The outer sequence represents the rows and the inner sequence 41cdf0e10cSrcweir the columns of the array.</p> 42cdf0e10cSrcweir 43*fbef625eSJürgen Schmidt @since OpenOffice 1.1.2 44cdf0e10cSrcweir */ 45cdf0e10cSrcweir 46cdf0e10cSrcweirpublished interface XCellRangeFormula: com::sun::star::uno::XInterface 47cdf0e10cSrcweir{ 48cdf0e10cSrcweir /** gets an array from the contents of the cell range. 49cdf0e10cSrcweir 50cdf0e10cSrcweir <p>Each element of the result contains the same string that 51cdf0e10cSrcweir would be returned by 52cdf0e10cSrcweir <member scope="com::sun::star::table">XCell::getFormula()</member> 53cdf0e10cSrcweir for the corresponding cell.</p> 54cdf0e10cSrcweir */ 55cdf0e10cSrcweir sequence< sequence< string > > getFormulaArray(); 56cdf0e10cSrcweir 57cdf0e10cSrcweir /** fills the cell range with values from an array. 58cdf0e10cSrcweir 59cdf0e10cSrcweir <p>The size of the array must be the same as the size of the cell 60cdf0e10cSrcweir range. Each element of the array is interpreted the same way as 61cdf0e10cSrcweir the argument to a 62cdf0e10cSrcweir <member scope="com::sun::star::table">XCell::setFormula()</member> 63cdf0e10cSrcweir call for the corresponding cell.</p> 64cdf0e10cSrcweir 65cdf0e10cSrcweir @throws <type scope="com::sun::star::uno">RuntimeException</type> 66cdf0e10cSrcweir If the size of the array is different from the current size. 67cdf0e10cSrcweir */ 68cdf0e10cSrcweir void setFormulaArray( [in] sequence< sequence< string > > aArray ); 69cdf0e10cSrcweir}; 70cdf0e10cSrcweir 71cdf0e10cSrcweir//============================================================================= 72cdf0e10cSrcweir}; }; }; }; 73cdf0e10cSrcweir 74cdf0e10cSrcweir#endif 75cdf0e10cSrcweir 76