Class Spreadsheet

Public Methods

Spreadsheet()

bool readSpreadsheet(filename)

bool setPointer(range)

inline string getPointer() const

bool cellPointerIsCell() const

bool cellPointerIsRange() const

void pointerHome()

void pointerUp(amount, lineno, filename)

void pointerDown(amount, lineno, filename)

void pointerLeft(amount, lineno, filename)

void pointerRight(amount, lineno, filename)

string pointerSlideDown(here) const

string pointerSlideLeft(here) const

string pointerSlideRight(here) const

string pointerSlideUp(here) const

void pointerExpandDown(amount)

void pointerExpandDownAuto()

void pointerExpandRight(amount)

void pointerExpandRightAuto()

void pointerExpandTableAuto()

void pointerRangeCompress()

string pointerLowerLeft() const

string pointerLowerRight() const

string pointerUpperLeft() const

string pointerUpperRight() const

int fillCells(fillrange, value)

bool findCell(value, exactMatch)

string getNamedRange(name) const

void setNamedRange(name, range)

void setNamedRangesByTitles()

inline int getNamedRangeCount() const

inline string getNamedRangeName(i) const

inline string getNamedRangeValue(i) const

bool findInRange(value, exactMatch)

bool findTable(tableNo)

void crop()

bool setOutputType(type)

void pointerPrint(outputFormat, labels)

static void functionAvg(value, data)

static void functionCount(value, data)

static void functionMax(value, data)

static void functionMin(value, data)

static void functionSum(value, data)

int functionCells(fnrange, fn, data)

inline float fnAvg(data)

inline float fnCount(data)

inline float fnMax(data)

inline float fnMin(data)

inline float fnSum(data)

Private Properties

Private Methods

string replace(text, find, replacement)

void unxmlize(value)

string xmlize(value)

string quotize(value)

#include <Spreadsheet.h >

Super class: CsvSpreadsheet

Public Methods

Spreadsheet()

bool readSpreadsheet(filename)

string filename

bool setPointer(range)

string range

Pointer & pointer manipulation

inline string getPointer() const

bool cellPointerIsCell() const

bool cellPointerIsRange() const

void pointerHome()

void pointerUp(amount, lineno, filename)

int amount
int lineno
string filename

void pointerDown(amount, lineno, filename)

int amount
int lineno
string filename

void pointerLeft(amount, lineno, filename)

int amount
int lineno
string filename

void pointerRight(amount, lineno, filename)

int amount
int lineno
string filename

string pointerSlideDown(here) const

string here

string pointerSlideLeft(here) const

string here

string pointerSlideRight(here) const

string here

string pointerSlideUp(here) const

string here

void pointerExpandDown(amount)

int amount

void pointerExpandDownAuto()

void pointerExpandRight(amount)

int amount

void pointerExpandRightAuto()

void pointerExpandTableAuto()

void pointerRangeCompress()

string pointerLowerLeft() const

string pointerLowerRight() const

string pointerUpperLeft() const

string pointerUpperRight() const

int fillCells(fillrange, value)

string fillrange
string value

Set cell contents in range

bool findCell(value, exactMatch)

string value
bool exactMatch

string getNamedRange(name) const

string name

Named ranges

void setNamedRange(name, range)

string name
string range

void setNamedRangesByTitles()

inline int getNamedRangeCount() const

inline string getNamedRangeName(i) const

int i

inline string getNamedRangeValue(i) const

int i

bool findInRange(value, exactMatch)

string value
bool exactMatch

Search

bool findTable(tableNo)

int tableNo

void crop()

Reduce the spreadsheet down to just the current range

bool setOutputType(type)

string type

Default value: "text"

generate output

void pointerPrint(outputFormat, labels)

string outputFormat
bool labels	Default value: true

static void functionAvg(value, data)

string value
void* data

Perform a function across the current pointer range

static void functionCount(value, data)

string value
void* data

static void functionMax(value, data)

string value
void* data

static void functionMin(value, data)

string value
void* data

static void functionSum(value, data)

string value
void* data

int functionCells(fnrange, fn, data)

string fnrange
SSCellFunction fn
void* data

inline float fnAvg(data)

SSFunctionData* data

Default value: NULL

inline float fnCount(data)

SSFunctionData* data

Default value: NULL

inline float fnMax(data)

SSFunctionData* data

Default value: NULL

inline float fnMin(data)

SSFunctionData* data

Default value: NULL

inline float fnSum(data)

SSFunctionData* data

Default value: NULL

Private Properties

string pointer	home is A1
string outputFormat	default is text
map <string,string > string
map <string,string > string > namedRange

Private Methods

string replace(text, find, replacement)

string text
string find
string replacement

void unxmlize(value)

string value

string xmlize(value)

string value

string quotize(value)

string value