Index

Next: About this document ... Up: SpreadScript 1.2 User's Guide Previous: D.4 Classes Contents

Index

active workbook

Perl
Python
Tcl

allowable life

as needed recalculation

basis

Border::constructor

Perl
Python
Tcl

Border::destructor

Perl
Python
Tcl

Border::getBottom()

Perl
Python
Tcl

Border::getLeft()

Perl
Python
Tcl

Border::getRight()

Perl
Python
Tcl

Border::getTop()

Perl
Python
Tcl

Border::setBottom()

Perl
Python
Tcl

Border::setLeft()

Perl
Python
Tcl

Border::setRight()

Perl
Python
Tcl

Border::setTop()

Perl
Python
Tcl

borders

Perl
Python
Tcl

C language operators

calculations

constraint expressions
explicit dependency
formula syntax
formulas
operators
precision
precision of
Worksheet::needsRecalc()
Worksheet::recalc()

cell borders

Perl
Python
Tcl

cell copy

Perl
Python
Tcl

cell format

Perl
Python
Tcl

cell to row-column

Perl
Python
Tcl

cell type

Perl
Python
Tcl

cell types

Perl
Python
Tcl

cells

absolute references
computed references
current cell reference
relative references

comma separated values export

Perl
Python
Tcl

comma separated values import

Perl
Python
Tcl

computed cell references

conditional statistical

conditional statistical functions ,

constraint expressions

copy

Perl
Python
Tcl

cost

coupon rate

CSV export

Perl
Python
Tcl

CSV import

Perl
Python
Tcl

current cell reference

date functions ,

day and month order

Perl
Python
Tcl

digital logic functions ,

embedded tools ,

Excel compatibility mode ,

Excel mode

Perl ,
Python ,
Tcl ,

Excel warning

Perl
Python
Tcl

explicit dependency

export CSV

Perl
Python
Tcl

export HTML

Perl
Python
Tcl

export LaTeX209

Perl
Python
Tcl

export LaTeX2E

Perl
Python
Tcl

export TSV

Perl
Python
Tcl

file types

Perl
Python
Tcl

financial functions ,

font names

Perl
Python
Tcl

font sizes

Perl
Python
Tcl

font styles

Perl
Python
Tcl

font underline

Perl
Python
Tcl

format

Perl
Python
Tcl

formula syntax ,

formulas

frequency

functions

@ ,
ABS ,
ACCRINT ,
ACCRINTM ,
ACOS ,
ACOSH ,
ALARM ,
AND , ,
ANNOTATE ,
arguments to
ASIN ,
ASINH ,
ATAN ,
ATAN2 ,
ATANH ,
AVERAGE ,
AVG ,
categories of
CAVG ,
CCOUNT ,
CEIL ,
CEILING , ,
CELLREF ,
CHAR ,
CHOOSE , ,
CLEAN ,
CMAX ,
CMIN ,
CODE ,
COL ,
COLS ,
COLUMN ,
COLUMNS ,
CONCATENATE ,
conditional statistical ,
CONFIDENCE
CORR ,
CORREL ,
COS ,
COSH ,
COUNT ,
COUPDAYBS ,
COUPDAYS ,
COUPDAYSNC ,
COUPNCD ,
COUPNUM ,
COUPPCD ,
CSTD ,
CSTDS ,
CSUM ,
CTERM ,
CUMIPMT ,
CUMPRINC ,
CVAR ,
CVARS ,
DATE ,
date and time ,
DATEVALUE ,
DAY ,
DAYS360 ,
DB ,
DDB ,
DEGREES ,
DET ,
DFT ,
digital logic ,
DISC ,
DOLLARDE ,
DOLLARFR ,
DOT ,
DURATION ,
EDATE ,
EFFECT ,
EIGEN ,
embedded tools ,
EOMONTH ,
ERF ,
ERFC ,
EXACT ,
Excel compatibility ,
EXP ,
F ,
FACT ,
FALSE
FFT ,
FILEEXISTS ,
financial ,
FIND ,
FLOOR , ,
FORECAST ,
FORMAT ,
FRAC ,
FREQUENCY ,
FTEST ,
FV ,
FVSCHEDULE ,
GAMMA ,
GEOMEAN ,
GMEAN ,
GRAND
HARMEAN ,
HEXTONUM ,
HLOOKUP , ,
HMEAN ,
HOUR ,
IF ,
INIT ,
INT , ,
INTERP2D ,
INTERP3D ,
INTRATE ,
INVDFT ,
INVERT , ,
INVFFT ,
IPMT , ,
IRR ,
ISERR ,
ISERROR ,
ISNUMBER ,
ISSTRING , ,
ISTEXT
LARGE ,
LEFT ,
LEN ,
LENGTH ,
LINCOEF ,
LINFIT ,
LLS ,
LN ,
LNGAMMA ,
LOG ,
LOG10 ,
LOG2 ,
logic
logic functions
LOWER ,
MATCH ,
mathematical ,
MAX ,
MDURATION ,
MEDIAN ,
MESSAGE ,
MID ,
MIN ,
MINUTE ,
MIRR ,
miscellaneous ,
MMUL ,
MOD , ,
MODE ,
MODULUS ,
MONTH ,
MSQ ,
N ,
NA ,
NAND ,
NETWORKDAYS ,
NOMINAL ,
NOR ,
NORMDIST ,
NORMINV ,
NORMSDIST ,
NORMSINV ,
NOT , ,
NOW ,
NPV ,
NUMTOHEX ,
ODDFPRICE ,
ODDFYIELD ,
ODDLPRICE ,
ODDLYIELD ,
OR , ,
PERCENTILE ,
PERCENTRANK ,
PERMUT ,
PI
PLS ,
PMT ,
POLY ,
POLYCOEF ,
POLYFIT , ,
PPMT ,
PRICE ,
PRICEDISC ,
PRICEMAT ,
PRODUCT ,
PROPER ,
PTTEST ,
PV ,
QUARTILE ,
quick reference
RADIANS ,
RAND
RANGEREF ,
RANK ,
RATE ,
RECEIVED ,
REGEX ,
REPEAT ,
REPLACE ,
REPT ,
RIGHT ,
RMS ,
ROUND ,
ROW ,
ROWS ,
S ,
SALARM ,
SECOND ,
SIGMOID ,
SIN ,
SINH ,
SLN ,
SMALL ,
SQRT ,
SSE ,
SSQ ,
STANDARDIZE ,
statistical
statistical functions
STD ,
STDEV ,
STDEVP ,
STDS ,
STRCAT ,
STRING , , ,
STRLEN ,
SUM ,
SUMPRODUCT ,
SYD ,
T ,
TAN ,
TANH ,
TBILLEQ ,
TBILLPRICE ,
TBILLYIELD ,
TERM ,
TIME ,
TIMEVALUE ,
TODAY
TRANSPOSE , ,
TREND ,
TRIM ,
TRUE
TRUNC ,
TTEST ,
TTEST2EV ,
TTEST2UV ,
UPPER ,
VALUE ,
VAR , , ,
VARP ,
VARS ,
VDB ,
VECLEN ,
VLOOKUP , ,
VSUM ,
WEEKDAY ,
WORKDAY ,
XIRR ,
XLAND ,
XLCEILING ,
XLCHOOSE
XLFLOOR
XLHLOOKUP ,
XLINT ,
XLIPMT ,
XLMID ,
XLMOD ,
XLNOT ,
XLOR ,
XLREPLACE ,
XLVAR ,
XLVLOOKUP ,
XNPV ,
XOR ,
XVALUE
YEAR ,
YEARFRAC ,
YIELD ,
YIELDDISC ,
YIELDMAT ,
ZTEST ,

future value

getActiveWorkbook()

Perl
Python
Tcl

getTypeString()

Perl
Python
Tcl

getVersionInfo()

Perl
Python
Tcl

global functions

Perl
Python
Tcl

goal seek status

Perl
Python
Tcl

goal seek

Perl
Python
Tcl

GoalSeekContext::constructor

Perl
Python
Tcl

GoalSeekContext::destructor

Perl
Python
Tcl

horizontal justification

Perl
Python
Tcl

HTML export

Perl
Python
Tcl

import CSV

Perl
Python
Tcl

import TSV

Perl
Python
Tcl

init()

Perl
Python
Tcl

initialize

Perl
Python
Tcl

initializing

installation

interest rate

just-in-time recalculation

LaTeX209 export

Perl
Python
Tcl

LaTeX2E export

Perl
Python
Tcl

library

initializing

logic functions ,

mathematical functions ,

month and day order

Perl
Python
Tcl

natural order recalculation

operators

range

Range::clear()

Perl
Python
Tcl

Range::constructor

Perl
Python
Tcl

Range::copy()

Perl
Python
Tcl

Range::copyValues()

Perl
Python
Tcl

Range::createFromString()

Perl
Python
Tcl

Range::destructor

Perl
Python
Tcl

Range::exportCSV()

Perl
Python
Tcl

Range::exportHTML()

Perl
Python
Tcl

Range::exportLaTeX209()

Perl
Python
Tcl

Range::exportLaTeX2E()

Perl
Python
Tcl

Range::exportTSV()

Perl
Python
Tcl

Range::getBounds()

Perl
Python
Tcl

Range::getMaxColumn()

Perl
Python
Tcl

Range::getMaxRow()

Perl
Python
Tcl

Range::getMinColumn()

Perl
Python
Tcl

Range::getMinRow()

Perl
Python
Tcl

Range::getParent()

Perl
Python
Tcl

Range::importCSV()

Perl
Python
Tcl

Range::importTSV()

Perl
Python
Tcl

Range::move()

Perl
Python
Tcl

Range::scroll()

Perl
Python
Tcl

Range::setBorder()

Perl
Python
Tcl

Range::setBorderEdges()

Perl
Python
Tcl

Range::setFont()

Perl
Python
Tcl

Range::setFontSize()

Perl
Python
Tcl

Range::setFontStyle()

Perl
Python
Tcl

Range::setFormatAndPlaces()

Perl
Python
Tcl

Range::setFormula()

Perl
Python
Tcl

Range::setHorizontalJustification()

Perl
Python
Tcl

Range::setNumber()

Perl
Python
Tcl

Range::setText()

Perl
Python
Tcl

Range::setUnderline()

Perl
Python
Tcl

Range::sortRows()

Perl
Python
Tcl

Range::toString()

Perl
Python
Tcl

ranges

absolute references
computed references
relative references

rcToText()

Perl
Python
Tcl

recalculating

recalculation

as needed
just-in-time
natural order

row sorting

Perl
Python
Tcl

row-column to cell

Perl
Python
Tcl

salvage value

setDefaultExcelMode()

Perl
Python
Tcl

SortContext::append()

Perl
Python
Tcl

SortContext::constructor

Perl
Python
Tcl

SortContext::deleteKey()

Perl
Python
Tcl

SortContext::destructor

Perl
Python
Tcl

SortContext::getKey()

Perl
Python
Tcl

SortContext::getNumKeys()

Perl
Python
Tcl

SortContext::prepend()

Perl
Python
Tcl

sorting direction

Perl
Python
Tcl

sorting

Perl ,
Python ,
Tcl ,

SpreadScript

installing
uninstalling

statistical functions

stopOnExcelWarning()

Perl
Python
Tcl

string functions ,

syntax

formula

tab separated values export

Perl
Python
Tcl

tab separated values import

Perl
Python
Tcl

textToRC()

Perl
Python
Tcl

time functions ,

TSV export

Perl
Python
Tcl

TSV import

Perl
Python
Tcl

underline

Perl
Python
Tcl

uninstall

version

Perl
Python
Tcl

word wrapping

Perl
Python
Tcl

workbook

Perl
Python
Tcl

Workbook::activate()

Perl
Python
Tcl

Workbook::constructor

Perl
Python
Tcl

Workbook::createSheet()

Perl
Python
Tcl

Workbook::deleteSheet()

Perl
Python
Tcl

Workbook::destructor

Perl
Python
Tcl

Workbook::getFileName()

Perl
Python
Tcl

Workbook::getSheet()

Perl
Python
Tcl

Workbook::getSheetByName()

Perl
Python
Tcl

Workbook::getSheetCount()

Perl
Python
Tcl

Workbook::open()

Perl
Python
Tcl

Workbook::save()

Perl
Python
Tcl

Workbook::setExcelMode()

Perl
Python
Tcl

workcreating

creating

worksheet

accessing

Worksheet::deleteColumns()

Perl
Python
Tcl

Worksheet::deleteRows()

Perl
Python
Tcl

Worksheet::destructor

Perl
Python
Tcl

Worksheet::getBorder()

Perl
Python
Tcl

Worksheet::getColumnWidth()

Perl
Python
Tcl

Worksheet::getDefaultColumnWidth()

Perl
Python
Tcl

Worksheet::getDefaultFont()

Perl
Python
Tcl

Worksheet::getDefaultFontSize()

Perl
Python
Tcl

Worksheet::getDefaultFontStyle()

Perl
Python
Tcl

Worksheet::getDefaultFormat()

Perl
Python
Tcl

Worksheet::getDefaultFormatAndPlaces()

Perl
Python
Tcl

Worksheet::getDefaultHorizontalJustification()

Perl
Python
Tcl

Worksheet::getDefaultPlaces()

Perl
Python
Tcl

Worksheet::getDefaultRowHeight()

Perl
Python
Tcl

Worksheet::getDefaultUnderline()

Perl
Python
Tcl

Worksheet::getDefaultWordWrap()

Perl
Python
Tcl

Worksheet::getDimensions()

Perl
Python
Tcl

Worksheet::getFont()

Perl
Python
Tcl

Worksheet::getFontSize()

Perl
Python
Tcl

Worksheet::getFontStyle()

Perl
Python
Tcl

Worksheet::getFormat()

Perl
Python
Tcl

Worksheet::getFormatAndPlaces()

Perl
Python
Tcl

Worksheet::getFormula()

Perl
Python
Tcl

Worksheet::getHorizontalJustification()

Perl
Python
Tcl

Worksheet::getName()

Perl
Python
Tcl

Worksheet::getNumber()

Perl
Python
Tcl

Worksheet::getPlaces()

Perl
Python
Tcl

Worksheet::getRowHeight()

Perl
Python
Tcl

Worksheet::getText()

Perl
Python
Tcl

Worksheet::getType()

Perl
Python
Tcl

Worksheet::getUnderline()

Perl
Python
Tcl

Worksheet::getWordWrap()

Perl
Python
Tcl

Worksheet::goal seek

Perl
Python
Tcl

Worksheet::insertColumns()

Perl
Python
Tcl

Worksheet::insertRows()

Perl
Python
Tcl

Worksheet::needsRecalc()

Perl
Python
Tcl

Worksheet::performGoalSeek()

Perl
Python
Tcl

Worksheet::recalc()

Perl
Python
Tcl

Worksheet::setBorder()

Perl
Python
Tcl

Worksheet::setColumnWidths()

Perl
Python
Tcl

Worksheet::setDefaultColumnWidth()

Perl
Python
Tcl

Worksheet::setDefaultFont()

Perl
Python
Tcl

Worksheet::setDefaultFontSize()

Perl
Python
Tcl

Worksheet::setDefaultFontStyle()

Perl
Python
Tcl

Worksheet::setDefaultFormat()

Perl
Python
Tcl

Worksheet::setDefaultFormatAndPlaces()

Perl
Python
Tcl

Worksheet::setDefaultHorizontalJustification()

Perl
Python
Tcl

Worksheet::setDefaultPlaces()

Perl
Python
Tcl

Worksheet::setDefaultRowHeight()

Perl
Python
Tcl

Worksheet::setDefaultUnderline()

Perl
Python
Tcl

Worksheet::setFont()

Perl
Python
Tcl

Worksheet::setFontSize()

Perl
Python
Tcl

Worksheet::setFontStyle()

Perl
Python
Tcl

Worksheet::setFormat()

Perl
Python
Tcl

Worksheet::setFormatAndPlaces()

Perl
Python
Tcl

Worksheet::setFormula()

Perl
Python
Tcl

Worksheet::setHorizontalJustification()

Perl
Python
Tcl

Worksheet::setName()

Perl
Python
Tcl

Worksheet::setNumber()

Perl
Python
Tcl

Worksheet::setPlaces()

Perl
Python
Tcl

Worksheet::setRowHeights()

Perl
Python
Tcl

Worksheet::setText()

Perl
Python
Tcl

Worksheet::setUnderline()

Perl
Python
Tcl

yield

Next: About this document ... Up: SpreadScript 1.2 User's Guide Previous: D.4 Classes Contents

SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003