Cell Class Reference

Inherits Class.

List of all members.

---

Detailed Description

For every cell in the spread sheet there is a Cell object.

Cell contains format information and algorithm and it contains the calculation algorithm.

Example (in Ruby) :

 doc = krosskspreadcore::get("KSpreadDocument")
 sheet = doc.currentSheet()
 cellA1 = sheet.cell(0, 0)
 cellA2 = sheet.cell(0, 1)
 cellA2.setValue( cellA1.value() )
 cellA2.setTextColor( "#ff0000" )

Private Member Functions
QVariant	value () const
bool	setValue (const QVariant &value)
int	column () const
int	row () const
Cell *	previousCell () const
Cell *	nextCell () const
void	setPreviousCell (Cell *c)
void	setNextCell (Cell *c)
const QString	name () const
const QString	fullName () const
const QString	comment () const
void	setComment (const QString &c)
const QString	getFormatString () const
void	setFormatString (const QString &format)
const QString	text () const
bool	setText (const QString &text, bool asString=false)
const QString	textColor ()
void	setTextColor (const QString &textcolor)
const QString	backgroundColor ()
void	setBackgroundColor (const QString &backgroundcolor)

---

Member Function Documentation

const QString backgroundColor

(

)

[private]

Return the backgroundcolor as RGB-value in the format "#RRGGBB".

int column

(

)

const [private]

Return the column number.

const QString comment

(

)

const [private]

Returns the comment for the cell.

const QString fullName

(

)

const [private]

Returns the full name of the cell, i.e. including the worksheet name. Example: "Sheet1!A1"

const QString getFormatString

(

)

const [private]

Returns the format of the cell, e.g. #.##0.00, dd/mmm/yyyy,...

const QString name

(

)

const [private]

Returns the name of the cell. For example, the cell in first column and first row is "A1".

Cell * nextCell

(

)

const [private]

Return the next cell if there is any.

Cell * previousCell

(

)

const [private]

Return the previous cell if there is any.

int row

(

)

const [private]

Return the row number.

void setBackgroundColor

(

const QString &

backgroundcolor

)

[private]

Set the backgroundcolor to the RGB-value in the format "#RRGGBB" where each of R, G, and B is a single hex digit.

void setComment

(

const QString &

c

)

[private]

Set the comment for the cell.

void setFormatString

(

const QString &

format

)

[private]

Sets the format of the cell, e.g. #.##0.00, dd/mmm/yyyy,...

void setNextCell

(

Cell *

c

)

[private]

Set the next cell.

void setPreviousCell

(

Cell *

c

)

[private]

Set the previous cell.

bool setText	(	const QString &	text,
		bool	asString = false
	)			[private]

Set the text of the cell. If asString is true, the text will be handled as string else we try to parse the string to the expected value.

void setTextColor

(

const QString &

textcolor

)

[private]

Set the textcolor to the RGB-value in the format "#RRGGBB" where each of R, G, and B is a single hex digit.

bool setValue

(

const QVariant &

value

)

[private]

Set the value the cell has.

const QString text

(

)

const [private]

Return the text of the cell (the formula if there is one, the value otherwise). This could be a value (e.g. "14.03") or a formula (e.g. "=SUM(A1:A10)")

const QString textColor

(

)

[private]

Return the textcolor as RGB-value in the format "#RRGGBB".

QVariant value

(

)

const [private]

Return the value of the cell.

---