OpenOffice.org Macros Explained
The Calc dispatch commands are specific to Calc documents. Most of the commands are obviously specific to a Calc document-for example, Calculate. Other commands, however, leave me asking why they aren't global-for example, AcceptChanges. Table 3 lists the dispatch commands that are specific to Calc documents.
| Calc-Specific Dispatch Commands | |||
|---|---|---|---|
| AcceptChanges | Add | AddPrintArea | AdjustPrintZoom |
| AlignBlock | AlignBottom | AlignHorizontalCenter | AlignLeft |
| AlignRight | AlignTop | AlignVCenter | ApplyNames |
| AuditingFillMode | AutoComplete | AutoFill | AutomaticCalculation |
| AutoOutline | AutoRefreshArrows | Calculate | CalculateHard |
| Cancel | ChooseDesign | ClearArrowDependents | ClearArrowPrecedents |
| ClearArrows | ClearContents | ClosePreview | ColumnWidth |
| CommentChange | ConditionalFormatDialog | CreateNames | DataAreaRefresh |
| DataConsolidate | DataDataPilotRun | DataFilterAutoFilter | DataFilterHideAutoFilter |
| DataFilterRemoveFilter | DataFilterSpecialFilter | DataFilterStandardFilter | DataImport |
| DataPilotFilter | DataReImport | DataSelect | DataSort |
| DataSubTotals | DefineDBName | DefineLabelRange | DefineName |
| DefinePrintArea | DeleteAllBreaks | DeleteCell | DeleteColumnbreak |
| DeleteColumns | DeletePivotTable | DeletePrintArea | DeleteRowbreak |
| DeleteRows | Deselect | DrawChart | EditHeaderAndFooter |
| EditLinks | EditPrintArea | EuroConverter | FillDown |
| FillLeft | FillRight | FillSeries | FillTable |
| FillUp | FirstPage | FocusCellAddress | FocusInputLine |
| FormatCellDialog | FreezePanes | FunctionBox | FunctionDialog |
| GoalSeekDialog | GoDownToEndOfData | GoDownToEndOfDataSel | GoLeftBlock |
| GoLeftToStartOfData | GoLeftToStartOfDataSel | GoRightBlock | GoRightBlockSel |
| GoRightToEndOfData | GoRightToEndOfDataSel | GoToCurrentCell | GoUpToStartOfData |
| GoUpToStartOfDataSel | Hide | HideColumn | HideRow |
| Hyphenate | InputLineVisible | InsCellsCtrl | Insert |
| InsertCell | InsertCellsDown | InsertCellsRight | InsertColumnBreak |
| InsertColumns | InsertContents | InsertCtrl | InsertExternalDataSource |
| InsertName | InsertObjectStarlmage | InsertObjectStarMath | InsertRowBreak |
| InsertRows | InsObjCtrl | JumpToNextTable | JumpToNextUnprotected |
| JumpToPreviousUnprotected | JumpToPrevTable | LastPage | MergeCells |
| Move | Name | NextPage | NoteVisible |
| NumberFormatCurrency | NumberFormatDate | NumberFormatDecDecimals | NumberFormatDecimal |
| NumberFormatIncDecimals | NumberFormatPercent | NumberFormatScientific | NumberFormatStandard |
| NumberFormatTime | ObjectMirrorHorizontal | ObjectMirrorVertical | PagebreakMode |
| PageFormatDialog | PasteSpecial | PreviousPage | Protect |
| ProtectTraceChangeMode | RecalcPivotTable | RefreshArrows | Remove |
| RenameObject | RenameTable | RepeatSearch | ResetAttributes |
| ResetPrintZoom | RowHeight | Scale | ScenarioManager |
| SelectArrayFormula | SelectColumn | SelectData | SelectDB |
| SelectRow | SelectScenario | SelectTables | SetInputMode |
| SetOptimalColumnWidth | SetOptimalColumnWidthDirect | SetOptimalRowHeight | Show |
| ShowChanges | ShowColumn | ShowDependents | ShowErrors |
| ShowInvalid | ShowPrecedents | ShowRow | SimpleReferenz |
| SortAscending | SortDescending | SplitCell | SplitWindow |
| StandardTextAttributes | StarChartDataDialog | StarChartDialog | StatusDocPos |
| StatusPageStyle | StatusSelectionMode | StatusSelectionModeExp | StatusSelectionModeExt |
| TableOperationDialog | TableSelectAll | TextAttributes | ToggleAnchorType |
| ToggleRelative | ToolProtectionDocument | ToolsOptions | TraceChangeMode |
| UnderlineDotted | UnderlineDouble | UnderlineNone | UnderlineSingle |
| UpdateChart | Validation | ViewRowColumnHeaders | ViewValueHighlighting |
| WrapText | ZoomIn | ZoomOut | |