OpenOffice.org Macros Explained
S
SafeUBound(), 97
Save Source As icon, IDE, 12
SaveOutputPosition property, 364
SavePicture routine, 166
SaveVersionOnClose property, 263
Scalelmage property, 440
screen flicker, 305
Script field, 315
scroll bar controls, 442-444
ScrollDownOneScreen, Writer module, 283
ScrollValue property, 443
ScrollValueMax property, 443
search-and-replace functionality, 296-302
SearchDescriptor service, 296
SearchSheet, Calc module, 342
SearchStyles attribute, 300
SearchWords flag, 342
Second(), 29, 101, 106, 107
security dialog, 215
Seek(), 128, 138
seekGoal(), 368
Select Case statement, 58-59
selected text, 289-292, 295-296
SelectedIterns property, 441
SendKeys routine, 166
services, UNO, 172-173
SetAttr(), 128
SetConditionalStyle, Calc module, 337
setContext(), 419
setData(), 308
setDate(), 433
setDesignMode(), 419
setEditable(), 430
setEmpty(), 433
setEnable(), 419
SetExpression field, 315, 319
setFirst(), 433
setFocus(), 419
setGraphics(), 420
setLast(), 433
setLongFormat(), 433
setMax(), 433
setMaxTextLen(), 430
setMenuBar(), 420
setMin(), 433
setPagePrintSettings(), 258
setParentStyle(), 246
setPosSize(), 419
setPrintAreas(), 261
setPrinter(), 255
setPrintTitleColumns(), 261
setPrintTitleRows(), 261
setPropertyValue(), 231
SetRangeText, Calc module, 370
setReplaceAttributes(), 300
setSearchAttributes(), 300
SetSelectedCells, Calc module, 370-371
setSelection(), 430
setStatus(), 421
setStrictFormat(), 433
setString(), 267
setTableOperation(), 348-349
setText(), 430
setTitle(), 420
setTitleColumns(), 261
setTitleRows(), 261
SetTransitionEffects, Graphic module, 403
setUserFieldName(), 233
setUserFieldValue(), 233
SetValidationRange, Calc module, 336
setVisible(), 419
setZoom(), 420
Sgn(), 73, 78, 79
ShadowFormat property, 307, 331
shadows, properties, 386-387
shearing , 387-388
sheet cells . See spreadsheets
Sheet property, 328, 334
SheetCellCursor service, 364-365
Shell(), 148-150
Shell command arguments, 152
Shell statement, 151
ShowAnchor property, 373
ShowCharts property, 373
ShowDrawing property, 373
ShowErrorMessage property, 335
ShowFieldMasters, Writer module, 319-320
ShowFormulas property, 373
ShowGrid property, 373
ShowHelpLines property, 373
ShowInputMessage property, 335
ShowNotes property, 373
ShowObjects property, 373
ShowPageBreaks property, 373
showPrecedents(), 356
ShowThousandsSeparator property, 430
ShowZeroValues property, 373
simple variables , 22
SimpleCellInfo, Calc module, 329
SimpleEllipseShapes, Graphic module, 392
SimpleLine, Graphic module, 389
SimplePolyLineShape, Graphic module, 390
SimplePolyPolygonShape, Graphic module, 391
SimplePresentation, Graphic module, 402
SimpleTableManipulations, Writer module, 309
SIN(), 73
single quotation character, 20, 217
Single Step icon, IDE, 10
single variables, 22, 26-27
Size property, 332
Sizeable property, 421
SizeProtect property, 381
SkipDuplicates property, 363
slash mark (/), separating multiple values, 217
slot, for UNO dispatch commands, 191
SolidHandles property, 373
SortAscending property, 352
SortColOne, Calc module, 353
SortColumns property, 352
SortColZero, Calc module, 352-353
SortFields property, 352
Sound property, 404, 405
SoundOn property, 404
Space(), 113
Spc(), 154
special characters
defining constant strings, 28
in URL notation, 128
Speed property, 403, 404
Spin property, 430, 432, 434, 435
Split(), 91, 96, 113, 114, 125
Split property, 307
spreadsheets. See also Calc documents
creating functions, 368-369
interfaces, 326
linking to, 355-356
printing, 260-261
sheet cells
array formulas, 347-348
automatic data fill, 345-347
clearing, 345
data, 327-333
dimensions, 344
formatting, 350-351
functions, 345, 348-350
managing, 343-345
merging cells, 342-343
properties, 334-337
range services, 337-341
ranges, 333-334
searching and replacing, 341-342
sorting, 351-354
Sqr(), 73, 78, 79
stack data structure, 42
Standard library, 9, 16
Star Basic. See OpenOffice.org Basic
StarDesktop. See also filter names
features, 203
filter names
Calc import and export, 222-223
Chart import and export, 225
Draw import and export, 223-224
Graphics import and export, 226-227
Impress import and export, 224-225
Math import and export, 225
Writer Global import and export, 222
Writer import and export, 218-221
Writer Web import and export, 221
Frame service, 203-206
getComponents(), 208-209
XCloseable interface, 206-207
XComponentLoader interface
loading components , 210-213
named parameters, 213-214
XDesktop interface, 206-210
XEnumerationAccess, 207-208
XEventBroadcaster interface, 206
StarPresentation property, 242
StartColumn property, 334
StartGluePointlndex property, 396
StartPosition property, 396
StartRow property, 334
StartShape property, 396
StartWithNavigator property, 401
State property, 424, 425, 426
statements, 54. See also flow control
StatusIndicator property, 242
Step Back icon, IDE, 10
Step property, 421, 444
Stop(), 148-150
Stop command, 149-150
Stop icon, IDE, 10
STOPPRESENTATION property, 405
store(), 243
storeAsURL(), 243
storeToURL, 243
storing macros
in application libraries, 8-9
in document libraries, 1-8
Str(), 84, 84-85, 113, 114
StrComp(), 114, 119
StrConv(), 167
StrConv routine, 166, 167
StrictFormat property, 430, 432, 434, 435, 437, 438
String(), 114, 119
string concatenation (& and +), 48-49
string conversion functions, 84, 102-103
string operators, 46
string routines
aligning strings, 121-122
ASCII and Unicode values, 114-117
converting data to strings, 125-126
fancy formatting, 122-125
functions, 113-119
substrings, 119-121
string variables, 22, 27-28
StringltemList property, 428, 441
StringValue property, 363
struct, 189. See also UNO
Style property, 381
subroutines. See also arguments; functions; numerical routines
built-in global UNO variables, 177-180
creating, 8
definition, 19
elapsed time, 108-109
example, 38-39
in Generic module, 232-236, 238-241, 245-248, 253-256, 259-262
names, 21
pixel size, 146
related to arrays, 35, 91-92
related to dates and times, 29
scope, 42-45
utility methods , 444-447
substrings, 119-121
subtraction (-), 48-49
supportsService(), 174, 325
syntax check, 9
syntax errors, 7
system-dependent beep, 159