next up previous contents
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
borders
Perl
Python
Tcl
C language operators
calculations
calculations
constraint expressions
explicit dependency
formula syntax
formulas
operators
precision
precision of
Worksheet::needsRecalc()
Worksheet::recalc()
cell borders
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
operators
range
period
present value
price
range operator
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
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()
Worksheet::needsRecalc()
Perl
Python
Tcl
Worksheet::performGoalSeek()
Perl
Python
Tcl
Worksheet::recalc()
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 up previous contents
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