OpenOffice.org Macros Explained

C

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

calendar systems, 107

CanSetPaperFormat property, 257

CanSetPaperOrientation property, 257

CanSetPaperSize property, 257

Case expressions, 58-59

case sensitivity

constant names , 205

filter names, 216

OpenOffice.org Basic, 20

Case statements, 59-62

CBool(), 159

CByte(), 22, 73, 80, 81

CCur(), 167

CCur routine, 166

CDate(), 29, 101, 102

CDateFromlso(), 29, 101, 102

CDateToIso(), 29, 101, 102, 105

CDbl(), 73, 80

CellAddressConversion service, 328

CellBackColor property, 330

CellInsertMode enumeration, 358

CellProtection property, 331

CellRange service, 337

cells , in text tables, 309-310

CellStyle property, 330

Change property, 403

Chapter field, 312

character styles, 178

CharacterCompressionType property, 263

CharacterCount field, 312

CharacterCount property, 316-317

characters

properties, 276-280

regular expressions, 301-302

CharacterSet property, 242

CharLocale property, 161

Chart commands, UNO dispatcher, 197

ChartColumnAsLabel property, 307

ChartRowAsLabel property, 307

ChDir(), 127, 128

ChDrive() 127, 128

check box control, 400, 425-426

Choose(), 149

Choose statement, 57-58, 149

CHR$(), 28, 116

CHR(), 113, 116

CInt(), 80

CircleKind enumeration, 393

CleanCodeStyles, Writer module, 274-276

clearContents(), 345

ClickAction enumeration, 405

CLng(), 73, 80

CInt(), 73

Close(), 127

Close statement, 136

Closeable property, 421

CMYK (cyan, magenta , yellow, and black), 147

code. See macros

CollatorLocale property, 352

collapseToCurrentArray(), 365

collapseToCurrentRegion(), 365

Collate property, 257

CollatorAlgorithm property, 352

CollectSimpleStatistics, Writer module, 285-286

colon (), as a statement operator, 54

color functions, 147-148

Color property, 330

ColorTableURL property, 263

column properties, 343

Column property, 328

CombinedCharacters field, 312

combineShapes, Graphic module, 379

combo box, 427-428

ComboBox control, 400

CommandButton control, 400

Comment property, 242

comments, adding, 19-20

comparison operators, 53-54, 117-119

Compile icon, IDE, 9

compile-time error, 21, 65

complex queries, 339-341

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

Connection property, 363

ConnectorShape, 396

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

context, default, 173

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

Controls dialog, 415

Controls icon, IDE, 12

Controls toolbar, 414

ConvertFromURL(), 127

ConvertToURL(), 127, 210-211

Coordinates property, 394

copyByName(), 326

CopyCount property, 257

CopyNamedTableToEnd, Writer module, 312

CopyOutputData property, 352, 364

COS(), 73

country codes, 249-255

CreateAGIobalLib, Library module, 410

CreateDataPilotSource, Calc module, 360

CreateDataPilotTable, Calc module, 361

createEnumeration(), 326

createlnstance(), 321

CreateObject(), 30, 159, 160

createPeer(), 419

CreatePropertySet routine, 166, 167

CreateSelectedTextlterator, Writer module, 291-292

createTextCursor(), 266

createTextCursorByRange(), 266

CreateUnoDialog(), 169, 416

CreateUnoListener(), 169

CreateUnoObjects(), 169

CreateUnoService(), 169, 172

CreateUnoStruct(), 169, 170-171

CreationDate property, StarDesktop, 209

CSng(), 80, 84-85

CStr(), 84, 113, 114, 125-126

CSV filter, 217

CurDir(), 127

CurrencySymbol property, 430

currency control, 430-431

currency numbers , 22, 24, 82

currency variable, 26

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

CustomShow property, 401