/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ #ifndef __com_sun_star_table_XCell_idl__ #define __com_sun_star_table_XCell_idl__ #ifndef __com_sun_star_uno_XInterface_idl__ #include #endif #ifndef __com_sun_star_table_CellContentType_idl__ #include #endif //============================================================================= module com { module sun { module star { module table { //============================================================================= /** provides methods to access the contents of a cell in a table. @see com::sun::star::table::Cell */ published interface XCell: com::sun::star::uno::XInterface { //------------------------------------------------------------------------- /** returns the formula string of a cell.

Even if the cell does not contain a formula, an assignment of this attribute's value to another cell's formula attribute would create the same cell content. This is because this attribute contains the original text value of a string cell. The value of a value cell will be formatted using the number format's default format or the formula string, including "=", of a formula cell.

*/ string getFormula(); //------------------------------------------------------------------------- /** sets a formula into the cell.

When assigned, the string will be interpreted and a value, text or formula cell is created, depending on the text and the number format.

*/ void setFormula( [in] string aFormula ); //------------------------------------------------------------------------- /** returns the floating point value of the cell.

For a value cell the value is returned, for a string cell zero is returned and for a formula cell the result value of a formula is returned.

*/ double getValue(); //------------------------------------------------------------------------- /** sets a floating point value into the cell.

After a call to this method the type of the cell is CellContentType::VALUE.

*/ void setValue( [in] double nValue ); //------------------------------------------------------------------------- /** returns the type of the cell. */ com::sun::star::table::CellContentType getType(); //------------------------------------------------------------------------- /** returns the error value of the cell.

If the cell does not contain a formula, the error is always zero.

*/ long getError(); }; //============================================================================= }; }; }; }; #endif