Calc commands, UNO dispatcher, 195-196
Calc documents. See also spreadsheets
accessing sheets, 326-327
cell dependencies, 356-357
CellInsertMode enumeration, 358
controllers, 369-373
converting Excel macros, 373-374
creating functions, 368-369
data pilot tables, 359-364
functions, 327
Goal Seek, 367-368
interfaces, 325
macro recorder, 374
named ranges, 366-367
outlines, 357
printing, 260-261
recalculation, 367
security, 367
services, 175, 230
sheet cursors , 364-366
sheets, 354
CalcIsAnythingSelected, Calc module, 369-370
CanSetPaperFormat property, 257
CanSetPaperOrientation property, 257
CanSetPaperSize property, 257
case sensitivity
constant names , 205
filter names, 216
OpenOffice.org Basic, 20
CDateFromlso(), 29, 101, 102
CDateToIso(), 29, 101, 102, 105
CellAddressConversion service, 328
CellBackColor property, 330
CellInsertMode enumeration, 358
CellProtection property, 331
cells , in text tables, 309-310
CharacterCompressionType property, 263
CharacterCount field, 312
CharacterCount property, 316-317
characters
properties, 276-280
regular expressions, 301-302
CharacterSet property, 242
Chart commands, UNO dispatcher, 197
ChartColumnAsLabel property, 307
ChartRowAsLabel property, 307
check box control, 400, 425-426
Choose statement, 57-58, 149
CircleKind enumeration, 393
CleanCodeStyles, Writer module, 274-276
ClickAction enumeration, 405
CMYK (cyan, magenta , yellow, and black), 147
CollatorLocale property, 352
collapseToCurrentArray(), 365
collapseToCurrentRegion(), 365
CollatorAlgorithm property, 352
CollectSimpleStatistics, Writer module, 285-286
colon (), as a statement operator, 54
ColorTableURL property, 263
CombinedCharacters field, 312
combineShapes, Graphic module, 379
CommandButton control, 400
comparison operators, 53-54, 117-119
compile-time error, 21, 65
components , 178, 190, 207-208
concatenation (& and +), 48-49
conditional branching statements, 54
conditional formatting, 336-337
ConditionalFormat property, 333
ConditionalFormatLocal property, 333
ConditionalText field, 313
ConnectorType enumeration, 396-397
constants
advantages, 32
definition, 32
enumerated, 205
names, 21
number formatter, 435
passed as arguments, 39
supported in OOo 2.0, 28
for text fields, 316-317
ContainsHeader property, 352, 364
continuation character, 19, 20
ControlCharacter property, 281
controls
check box, 425-426
control button, 423-425
group box, 427-429
list box controls, 441-442
radio buttons , 426-427
scroll bar controls, 442-444
text edit controls, 429-440
types of, 422-423
ConvertToURL(), 127, 210-211
Coordinates property, 394
CopyNamedTableToEnd, Writer module, 312
CopyOutputData property, 352, 364
CreateAGIobalLib, Library module, 410
CreateDataPilotSource, Calc module, 360
CreateDataPilotTable, Calc module, 361
CreateObject(), 30, 159, 160
CreatePropertySet routine, 166, 167
CreateSelectedTextlterator, Writer module, 291-292
createTextCursorByRange(), 266
CreateUnoDialog(), 169, 416
CreateUnoService(), 169, 172
CreateUnoStruct(), 169, 170-171
CreationDate property, StarDesktop, 209
CStr(), 84, 113, 114, 125-126
CurrencySymbol property, 430
currency control, 430-431
currency numbers , 22, 24, 82
CurrencyField control, 400
CurrentDatabaseCommand property, 263
CurrentDatabaseCommandType property, 263
CurrentDatabaseDataSource property, 263
cursors
accessing content, 287-289
object methods , 282-283
properties, 287
traversing text, 284-287
viewing, 282-284
CustomPresentation, Graphic module, 402