Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: table ::
interface XCell
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XCell
Description provides methods to access the contents of a cell in a table. See also Cell

Methods' Summary
getFormula | returns the formula string of a cell.
setFormula | sets a formula into the cell.
getValue | returns the floating point value of the cell.
setValue | sets a floating point value into the cell.
getType | returns the type of the cell.
getError | returns the error value of the cell.

Methods' Details
getFormula
string getFormula(); |  |
Description 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.
setFormula
void setFormula( | [in] string | aFormula );
Description 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.
getValue
double getValue(); |  |
Description returns the floating point value of the cell. For a value cell the value is returnd, for a string cell zero is returned and for a formula cell the result value of a formula is returned.
setValue
void setValue( | [in] double | nValue );
Description sets a floating point value into the cell. After a call to this method the type of the cell is CellContentType::VALUE .
getType
CellContentType getType(); |  |
Description returns the type of the cell.
getError
long getError(); |  |
Description returns the error value of the cell. If the cell does not contain a formula, the error is always zero.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.