Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: table ::

interface 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.