English:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.3 released

Developer's Guide

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 Feather

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

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