FBSpread Class Reference

Base spreadsheet class. More...

Inheritance diagram for FBSpread:

Public Member Functions
object	GetCellValue (int pRow, int pColumn)
	Get a cell's value. More...
void	SetCellValue (int pRow, int pColumn, object pValue)
	Set a cell's value. More...
FBSpreadCell	GetSpreadCell (kReference pRef, int pColumn)
	Get a cell from row and column numbers. More...
	FBSpread ()
	Constructor. More...
	Clear ()
	Clear spreadsheet This function will empty spreadsheet of all its rows, columns and cells. More...
	ColumnAdd (str pString, kReference pRef=0)
	Add a column. More...
	GetCellView (kReference pRef, int pColumn, HIKtView pView)
	Get a cell's internal toolkit view. More...
FBSpreadColumn	GetColumn (int pColumn)
	Get a column from a column number. More...
FBSpreadCell	GetCurrentCell ()
	Get the current cell. More...
FBSpreadRow	GetRow (kReference pRef)
	Get a row from a row reference. More...
	RowAdd (str pString, kReference pRef=0)
	Add a row. More...
	RowSort (bool pAscending=True)
	Sort rows. More...
	SetCellView (kReference pRef, int pColumn, HIKtView pView)
	Set a cell's internal toolkit view. More...
Public Member Functions inherited from FBVisualComponent
	FBVisualComponent ()
	Constructor. More...
bool	AddChild (FBVisualComponent pChild, int pId=0)
	Add a child component. More...
FBVisualComponent	GetChild (int pId=0)
	Get a child component. More...
QWidget	GetQWidgetAddress ()
	Get internal QWidget. More...
bool	IsView ()
	Is component a view? More...
	Refresh (bool pNow=False)
	Refresh component. More...
	ViewExpose ()
	Exposed view callback function. More...
	ViewInput (int pMouseX, int pMouseY, FBInputType pAction, int pButtonKey, int pModifier)
	Input callback function. More...

Public Attributes
str	Caption
	Read Write Property: Caption to display for spreadsheet. More...
int	Column
	Read Write Property: Current column. More...
bool	MultiSelect
	Read Write Property: Can there be multiple selections? More...
FBEvent	OnCellChange
	Event: Cell value changed. More...
FBEvent	OnColumnClick
	Event: Column clicked. More...
FBEvent	OnDragAndDrop
	Event: Drag and drop event. More...
FBEvent	OnRowClick
	Event: Row clicked. More...
FBkReference	Row
	Read Write Property: Current row. More...
Public Attributes inherited from FBVisualComponent
str	RegionName
	Read Write Property: Region name. More...
int	RegionOffsetX
	Read Write Property: Region X offset. More...
int	RegionOffsetY
	Read Write Property: Region Y offset. More...
int	RegionOffsetWidth
	Read Write Property: Region width offset. More...
int	RegionOffsetHeight
	Read Write Property: Region height offset. More...
float	RegionRatioX
	Read Write Property: Ratio for X attachment. More...
float	RegionRatioY
	Read Write Property: Ratio for Y attachment. More...
float	RegionRatioWidth
	Read Write Property: Ratio for Width attachment. More...
float	RegionRatioHeight
	Read Write Property: Ratio for Height attachment. More...
FBAttachType	RegionAttachTypeX
	Read Write Property: X Attachment type. More...
FBAttachType	RegionAttachTypeY
	Read Write Property: Y Attachment type. More...
FBAttachType	RegionAttachTypeWidth
	Read Write Property: Width Attachment type. More...
FBAttachType	RegionAttachTypeHeight
	Read Write Property: Height Attachment type. More...
FBVisualComponent	RegionAttachToX
	Read Write Property X Attachment source. More...
FBVisualComponent	RegionAttachToY
	Read Write Property: Y Attachment source. More...
FBVisualComponent	RegionAttachToWidth
	Read Write Property: Width Attachment source. More...
FBVisualComponent	RegionAttachToHeight
	Read Write Property: Height Attachment source. More...
int	RegionPosMaxX
	Read Write Property: Region X position Max More...
int	RegionPosMinX
	Read Write Property: Region X position Min More...
int	RegionPosMaxY
	Read Write Property: Region Y position Max More...
int	RegionPosMinY
	Read Write Property: Region Y position Min More...
str	BorderCaption
	Read Write Property: Caption to display in border. More...
bool	BorderShowCaption
	Read Write Property: Show caption? More...
FBBorderStyle	BorderStyle
	Read Write Property: Style of border. More...
bool	BorderInSet
	Read Write Property: Is border inset? More...
int	BorderWidth
	Read Write Property: Width of border. More...
int	BorderSpacing
	Read Write Property: Spacing of border. More...
float	BorderMaxAngle
	Read Write Property: Max angle for rounding. More...
int	BorderCornerRadius
	Read Write Property: Corner radius (rounded). More...
str	Caption
	Property: Widget caption. More...
bool	Enabled
	Read Write Property: Is visual enabled? More...
int	Height
	Read Write Property: Height. More...
str	Hint
	Read Write Property: Hint to show. More...
int	Left
	Read Write Property: Left coordinate. More...
bool	ReadOnly
	Read Write Property: Is visual component read only? More...
int	Top
	Read Write Property: Top coordinate. More...
bool	Visible
	Read Write Property: Is visual component visible? More...
int	Width
	Read Write Property: Width. More...

Detailed Description

Base spreadsheet class.

See samples: ActionScriptMgr.py, KeyboardMapper.py, Spread.py.

Constructor & Destructor Documentation

FBSpread()

FBSpread

(

)

Constructor.

Member Function Documentation

Clear()

Clear

(

)

Clear spreadsheet This function will empty spreadsheet of all its rows, columns and cells.

ColumnAdd()

ColumnAdd	(	str	pString,
		kReference	pRef = 0
	)

Add a column.

Parameters

pString	Text to display with column.
pRef	User-define column reference number(default=0).

GetCellValue()

object GetCellValue	(	int	pRow,
		int	pColumn
	)

Get a cell's value.

Parameters

pRow	Row of cell.
pColumn	Column of cell.

Return values

object

Value of the cell (can be str, int or float)

GetCellView()

GetCellView	(	kReference	pRef,
		int	pColumn,
		HIKtView	pView
	)

Get a cell's internal toolkit view.

Parameters

pRef	Row of cell.
pColumn	Column of cell.
pView	Handle of view.

GetColumn()

FBSpreadColumn GetColumn

(

int

pColumn

)

Get a column from a column number.

Parameters

pColumn

Column number.

Returns

A copy of column.

GetCurrentCell()

FBSpreadCell GetCurrentCell

(

)

Get the current cell.

Returns

A copy of the the current cell.

GetRow()

FBSpreadRow GetRow

(

kReference

pRef

)

Get a row from a row reference.

Parameters

pRef	Reference to a row.

Returns

A copy of the row.

GetSpreadCell()

FBSpreadCell GetSpreadCell	(	kReference	pRef,
		int	pColumn
	)

Get a cell from row and column numbers.

Parameters

pRef	Row reference.
pColumn	Column number.

Returns

A copy of the cell.

RowAdd()

RowAdd	(	str	pString,
		kReference	pRef = 0
	)

Add a row.

Parameters

pString	Text to display with row.
pRef	User-defined reference for row(default=0).

RowSort()

RowSort

(

bool

pAscending = True

)

Sort rows.

Parameters

pAscending

If true, sort ascending.

SetCellValue()

void SetCellValue	(	int	pRow,
		int	pColumn,
		object	pValue
	)

Set a cell's value.

This will also set the FBSpreadCell.Style to the type of pValue (kFBCellStyleInteger if pValue is an int, kFBCellStyleDouble if pValue is a float, kFBCellStyleString if pValue is a str).

Parameters

pRow	Row of cell.
pColumn	Column of cell.
pValue	Value of the cell (can be str, int or float)

SetCellView()

SetCellView	(	kReference	pRef,
		int	pColumn,
		HIKtView	pView
	)

Set a cell's internal toolkit view.

Parameters

pRef	Row of cell.
pColumn	Column of cell.
pView	View to use to set cell's view.

Member Data Documentation

Caption

str Caption

Read Write Property: Caption to display for spreadsheet.

Column

int Column

Read Write Property: Current column.

MultiSelect

bool MultiSelect

Read Write Property: Can there be multiple selections?

OnCellChange

FBEvent OnCellChange

Event: Cell value changed.

OnColumnClick

FBEvent OnColumnClick

Event: Column clicked.

OnDragAndDrop

FBEvent OnDragAndDrop

Event: Drag and drop event.

OnRowClick

FBEvent OnRowClick

Event: Row clicked.

Row

FBkReference Row

Read Write Property: Current row.