ScTableSheetObjは、OpenOffice.org Calcテーブルシートを表すオブジェクトである。
ScTableSheetObj のプロパティ一覧を次に示す。
| プロパティ | 概要 | |
|---|---|---|
| SbxSTRING | AbsoluteName | |
| SbxBOOL | AsianVerticalMode | |
| SbxBOOL | AutomaticPrintArea | |
| SbxLONG | BorderColor | |
| SbxOBJECT | BottomBorder | |
| SbxLONG | CellBackColor | |
| SbxOBJECT | CellProtection | |
| SbxSTRING | CellStyle | |
| SbxLONG | CharColor | |
| SbxBOOL | CharContoured | |
| SbxBOOL | CharCrossedOut | |
| SbxINTEGER | CharEmphasis | |
| SbxINTEGER | CharFont | |
| SbxINTEGER | CharFontCharSet | |
| SbxINTEGER | CharFontCharSetAsian | |
| SbxINTEGER | CharFontCharSetComplex | |
| SbxINTEGER | CharFontFamily | |
| SbxINTEGER | CharFontFamilyAsian | |
| SbxINTEGER | CharFontFamilyComplex | |
| SbxSTRING | CharFontName | |
| SbxSTRING | CharFontNameAsian | |
| SbxSTRING | CharFontNameComplex | |
| SbxINTEGER | CharFontPitch | |
| SbxINTEGER | CharFontPitchAsian | |
| SbxINTEGER | CharFontPitchComplex | |
| SbxSTRING | CharFontStyleName | |
| SbxSTRING | CharFontStyleNameAsian | |
| SbxSTRING | CharFontStyleNameComplex | |
| SbxSINGLE | CharHeight | |
| SbxSINGLE | CharHeightAsian | |
| SbxSINGLE | CharHeightComplex | |
| SbxOBJECT | CharLocale | |
| SbxOBJECT | CharLocaleAsian | |
| SbxOBJECT | CharLocaleComplex | |
| SbxLONG | CharPosture | |
| SbxLONG | CharPostureAsian | |
| SbxLONG | CharPostureComplex | |
| SbxINTEGER | CharRelief | |
| SbxBOOL | CharShadowed | |
| SbxINTEGER | CharStrikeout | |
| SbxINTEGER | CharUnderline | |
| SbxLONG | CharUnderlineColor | |
| SbxBOOL | CharUnderlineHasColor | |
| SbxSINGLE | CharWeight | |
| SbxSINGLE | CharWeightAsian | |
| SbxSINGLE | CharWeightComplex | |
| SbxBOOL | CharWordMode | |
| SbxBOOL | ChartColumnAsLabel | |
| SbxBOOL | ChartRowAsLabel | |
| SbxOBJECT | ConditionalFormat | |
| SbxOBJECT | ConditionalFormatLocal | |
| SbxOBJECT | ConditionalFormatXML | |
| SbxBOOL | CopyBack | |
| SbxBOOL | CopyFormulas | |
| SbxBOOL | CopyStyles | |
| SbxOBJECT | DiagonalBLTR | |
| SbxOBJECT | DiagonalTLBR | |
| SbxLONG | HoriJustify | |
| SbxBOOL | IsActive | |
| SbxBOOL | IsCellBackgroundTransparent | |
| SbxBOOL | IsTextWrapped | |
| SbxBOOL | IsVisible | |
| SbxOBJECT | LeftBorder | |
| SbxOBJECT | LinkDisplayBitmap | |
| SbxSTRING | LinkDisplayName | |
| SbxLONG | NumberFormat | |
| SbxOBJECT | NumberingRules | |
| SbxLONG | Orientation | |
| SbxSTRING | PageStyle | |
| SbxINTEGER | ParaAdjust | |
| SbxLONG | ParaBottomMargin | |
| SbxINTEGER | ParaIndent | |
| SbxBOOL | ParaIsCharacterDistance | |
| SbxBOOL | ParaIsForbiddenRules | |
| SbxBOOL | ParaIsHangingPunctuation | |
| SbxBOOL | ParaIsHyphenation | |
| SbxINTEGER | ParaLastLineAdjust | |
| SbxLONG | ParaLeftMargin | |
| SbxLONG | ParaRightMargin | |
| SbxLONG | ParaTopMargin | |
| SbxOBJECT | Position | |
| SbxBOOL | PrintBorder | |
| SbxBOOL | Protected | |
| SbxOBJECT | RightBorder | |
| SbxLONG | RotateAngle | |
| SbxLONG | RotateReference | |
| SbxOBJECT | ShadowFormat | |
| SbxBOOL | ShowBorder | |
| SbxBOOL | ShrinkToFit | |
| SbxOBJECT | Size | |
| SbxOBJECT | TableBorder | |
| SbxINTEGER | TableLayout | |
| SbxOBJECT | TopBorder | |
| SbxOBJECT | UserDefinedAttributes | |
| SbxOBJECT | Validation | |
| SbxOBJECT | ValidationLocal | |
| SbxOBJECT | ValidationXML | |
| SbxLONG | VertJustify | |
| SbxINTEGER | WritingMode | |
| SbxOBJECT | PropertySetInfo | |
| SbxSTRING | PropertyToDefault | |
| SbxDOUBLE | NotANumber | |
| SbxARRAY | Data | |
| SbxARRAY | RowDescriptions | |
| SbxARRAY | ColumnDescriptions | |
| SbxSTRING | ImplementationName | |
| SbxARRAY | SupportedServiceNames | |
| SbxARRAY | Types | |
| SbxARRAY | ImplementationId | |
| SbxOBJECT | RangeAddress | |
| SbxOBJECT | Spreadsheet | |
| SbxSTRING | ArrayFormula | |
| SbxARRAY | DataArray | |
| SbxARRAY | FormulaArray | |
| SbxBOOL | IsMerged | |
| SbxOBJECT | Columns | |
| SbxOBJECT | Rows | |
| SbxOBJECT | CellFormatRanges | |
| SbxOBJECT | UniqueCellFormatRanges | |
| SbxSTRING | Name | |
| SbxARRAY | ColumnPageBreaks | |
| SbxARRAY | RowPageBreaks | |
| SbxOBJECT | Charts | |
| SbxOBJECT | DataPilotTables | |
| SbxOBJECT | Scenarios | |
| SbxOBJECT | Annotations | |
| SbxOBJECT | DrawPage | |
| SbxARRAY | PrintAreas | |
| SbxBOOL | PrintTitleColumns | |
| SbxOBJECT | TitleColumns | |
| SbxBOOL | PrintTitleRows | |
| SbxOBJECT | TitleRows | |
| SbxBOOL | IsScenario | |
| SbxSTRING | ScenarioComment | |
| SbxARRAY | Ranges | |
| SbxLONG | LinkMode | |
| SbxSTRING | LinkUrl | |
| SbxSTRING | LinkSheetName | |
| SbxSTRING | Dbg_SupportedInterfaces | サポートしているインタフェースの一覧 |
| SbxSTRING | Dbg_Properties | 属性の一覧 |
| SbxSTRING | Dbg_Methods | メソッドの一覧 |
ScTableSheetObj のメソッド一覧を次に示す。
| メソッド | 概要 | |
|---|---|---|
| SbxEMPTY | queryInterface ( SbxOBJECT ) | インタフェースの問い合わせ |
| SbxOBJECT | getPropertySetInfo ( void ) | |
| SbxVOID | setPropertyValue ( SbxSTRING, SbxVARIANT ) | |
| SbxEMPTY | getPropertyValue ( SbxSTRING ) | |
| SbxVOID | addPropertyChangeListener ( SbxSTRING, SbxOBJECT ) | |
| SbxVOID | removePropertyChangeListener ( SbxSTRING, SbxOBJECT ) | |
| SbxVOID | addVetoableChangeListener ( SbxSTRING, SbxOBJECT ) | |
| SbxVOID | removeVetoableChangeListener ( SbxSTRING, SbxOBJECT ) | |
| SbxOBJECT | getPropertySetInfo ( void ) | |
| SbxVOID | setPropertyValues ( SbxARRAY, SbxARRAY ) | |
| SbxARRAY | getPropertyValues ( SbxARRAY ) | |
| SbxVOID | addPropertiesChangeListener ( SbxARRAY, SbxOBJECT ) | |
| SbxVOID | removePropertiesChangeListener ( SbxOBJECT ) | |
| SbxVOID | firePropertiesChangeEvent ( SbxARRAY, SbxOBJECT ) | |
| SbxLONG | getPropertyState ( SbxSTRING ) | |
| SbxARRAY | getPropertyStates ( SbxARRAY ) | |
| SbxVOID | setPropertyToDefault ( SbxSTRING ) | |
| SbxEMPTY | getPropertyDefault ( SbxSTRING ) | |
| SbxDOUBLE | computeFunction ( SbxLONG ) | |
| SbxVOID | clearContents ( SbxLONG ) | セルの内容のクリア |
| SbxVOID | addChartDataChangeEventListener ( SbxOBJECT ) | |
| SbxVOID | removeChartDataChangeEventListener ( SbxOBJECT ) | |
| SbxDOUBLE | getNotANumber ( void ) | |
| SbxBOOL | isNotANumber ( SbxDOUBLE ) | |
| SbxARRAY | getData ( void ) | |
| SbxVOID | setData ( SbxARRAY ) | |
| SbxARRAY | getRowDescriptions ( void ) | |
| SbxVOID | setRowDescriptions ( SbxARRAY ) | |
| SbxARRAY | getColumnDescriptions ( void ) | |
| SbxVOID | setColumnDescriptions ( SbxARRAY ) | |
| SbxVOID | decrementIndent ( void ) | |
| SbxVOID | incrementIndent ( void ) | |
| SbxOBJECT | queryVisibleCells ( void ) | |
| SbxOBJECT | queryEmptyCells ( void ) | |
| SbxOBJECT | queryContentCells ( SbxINTEGER ) | |
| SbxOBJECT | queryFormulaCells ( SbxLONG ) | |
| SbxOBJECT | queryColumnDifferences ( SbxOBJECT ) | |
| SbxOBJECT | queryRowDifferences ( SbxOBJECT ) | |
| SbxOBJECT | queryIntersection ( SbxOBJECT ) | |
| SbxOBJECT | queryDependents ( SbxBOOL ) | |
| SbxOBJECT | queryPrecedents ( SbxBOOL ) | |
| SbxOBJECT | createSearchDescriptor ( void ) | |
| SbxOBJECT | findAll ( SbxOBJECT ) | |
| SbxOBJECT | findFirst ( SbxOBJECT ) | |
| SbxOBJECT | findNext ( SbxOBJECT, SbxOBJECT ) | |
| SbxOBJECT | createReplaceDescriptor ( void ) | |
| SbxLONG | replaceAll ( SbxOBJECT ) | |
| SbxVOID | addModifyListener ( SbxOBJECT ) | |
| SbxVOID | removeModifyListener ( SbxOBJECT ) | |
| SbxSTRING | getImplementationName ( void ) | |
| SbxBOOL | supportsService ( SbxSTRING ) | |
| SbxARRAY | getSupportedServiceNames ( void ) | |
| SbxINT64 | getSomething ( SbxARRAY ) | |
| SbxARRAY | getTypes ( void ) | |
| SbxARRAY | getImplementationId ( void ) | |
| SbxOBJECT | getRangeAddress ( void ) | |
| SbxOBJECT | getCellByPosition ( SbxLONG, SbxLONG ) | |
| SbxOBJECT | getCellRangeByPosition ( SbxLONG, SbxLONG, SbxLONG, SbxLONG ) | |
| SbxOBJECT | getCellRangeByName ( SbxSTRING ) | |
| SbxOBJECT | getSpreadsheet ( void ) | |
| SbxSTRING | getArrayFormula ( void ) | |
| SbxVOID | setArrayFormula ( SbxSTRING ) | |
| SbxARRAY | getDataArray ( void ) | |
| SbxVOID | setDataArray ( SbxARRAY ) | |
| SbxARRAY | getFormulaArray ( void ) | |
| SbxVOID | setFormulaArray ( SbxARRAY ) | |
| SbxVOID | setTableOperation ( SbxOBJECT, SbxLONG, SbxOBJECT, SbxOBJECT ) | |
| SbxVOID | merge ( SbxBOOL ) | |
| SbxBOOL | getIsMerged ( void ) | |
| SbxVOID | fillSeries ( SbxLONG, SbxLONG, SbxLONG, SbxDOUBLE, SbxDOUBLE ) | |
| SbxVOID | fillAuto ( SbxLONG, SbxLONG ) | |
| SbxVOID | autoFormat ( SbxSTRING ) | |
| SbxARRAY | createSortDescriptor ( void ) | |
| SbxVOID | sort ( SbxARRAY ) | |
| SbxOBJECT | createFilterDescriptor ( SbxBOOL ) | |
| SbxVOID | filter ( SbxOBJECT ) | |
| SbxOBJECT | createFilterDescriptorByObject ( SbxOBJECT ) | |
| SbxOBJECT | createSubTotalDescriptor ( SbxBOOL ) | |
| SbxVOID | applySubTotals ( SbxOBJECT, SbxBOOL ) | |
| SbxVOID | removeSubTotals ( void ) | |
| SbxOBJECT | getColumns ( void ) | |
| SbxOBJECT | getRows ( void ) | |
| SbxARRAY | createImportDescriptor ( SbxBOOL ) | |
| SbxVOID | doImport ( SbxARRAY ) | |
| SbxOBJECT | getCellFormatRanges ( void ) | |
| SbxOBJECT | getUniqueCellFormatRanges ( void ) | |
| SbxOBJECT | createCursor ( void ) | |
| SbxOBJECT | createCursorByRange ( SbxOBJECT ) | |
| SbxSTRING | getName ( void ) | |
| SbxVOID | setName ( SbxSTRING ) | |
| SbxARRAY | getColumnPageBreaks ( void ) | |
| SbxARRAY | getRowPageBreaks ( void ) | |
| SbxVOID | removeAllManualPageBreaks ( void ) | |
| SbxVOID | insertCells ( SbxOBJECT, SbxLONG ) | |
| SbxVOID | removeRange ( SbxOBJECT, SbxLONG ) | |
| SbxVOID | moveRange ( SbxOBJECT, SbxOBJECT ) | |
| SbxVOID | copyRange ( SbxOBJECT, SbxOBJECT ) | |
| SbxOBJECT | getCharts ( void ) | |
| SbxOBJECT | getDataPilotTables ( void ) | |
| SbxOBJECT | getScenarios ( void ) | |
| SbxOBJECT | getAnnotations ( void ) | |
| SbxOBJECT | getDrawPage ( void ) | |
| SbxARRAY | getPrintAreas ( void ) | |
| SbxVOID | setPrintAreas ( SbxARRAY ) | |
| SbxBOOL | getPrintTitleColumns ( void ) | |
| SbxVOID | setPrintTitleColumns ( SbxBOOL ) | |
| SbxOBJECT | getTitleColumns ( void ) | |
| SbxVOID | setTitleColumns ( SbxOBJECT ) | |
| SbxBOOL | getPrintTitleRows ( void ) | |
| SbxVOID | setPrintTitleRows ( SbxBOOL ) | |
| SbxOBJECT | getTitleRows ( void ) | |
| SbxVOID | setTitleRows ( SbxOBJECT ) | |
| SbxBOOL | hideDependents ( SbxOBJECT ) | |
| SbxBOOL | hidePrecedents ( SbxOBJECT ) | |
| SbxBOOL | showDependents ( SbxOBJECT ) | |
| SbxBOOL | showPrecedents ( SbxOBJECT ) | |
| SbxBOOL | showErrors ( SbxOBJECT ) | |
| SbxBOOL | showInvalid ( void ) | |
| SbxVOID | clearArrows ( void ) | |
| SbxVOID | group ( SbxOBJECT, SbxLONG ) | |
| SbxVOID | ungroup ( SbxOBJECT, SbxLONG ) | |
| SbxVOID | autoOutline ( SbxOBJECT ) | |
| SbxVOID | clearOutline ( void ) | |
| SbxVOID | hideDetail ( SbxOBJECT ) | |
| SbxVOID | showDetail ( SbxOBJECT ) | |
| SbxVOID | showLevel ( SbxINTEGER, SbxLONG ) | |
| SbxVOID | protect ( SbxSTRING ) | |
| SbxVOID | unprotect ( SbxSTRING ) | |
| SbxBOOL | isProtected ( void ) | |
| SbxBOOL | getIsScenario ( void ) | |
| SbxSTRING | getScenarioComment ( void ) | |
| SbxVOID | setScenarioComment ( SbxSTRING ) | |
| SbxVOID | addRanges ( SbxARRAY ) | |
| SbxVOID | apply ( void ) | |
| SbxARRAY | getRanges ( void ) | |
| SbxLONG | getLinkMode ( void ) | |
| SbxVOID | setLinkMode ( SbxLONG ) | |
| SbxSTRING | getLinkUrl ( void ) | |
| SbxVOID | setLinkUrl ( SbxSTRING ) | |
| SbxSTRING | getLinkSheetName ( void ) | |
| SbxVOID | setLinkSheetName ( SbxSTRING ) | |
| SbxVOID | link ( SbxSTRING, SbxSTRING, SbxSTRING, SbxSTRING, SbxLONG ) | |
com.sun.star.table.CellRangeAddress参照
表（テーブルシート）のすべてのセルの内容をクリアする。
OpenOffice.org Basicの呼び出し形式:
無し
| 値 | フラグ | 説明 |
|---|---|---|
| 1 | VALUE | 日付や時刻として書式設定されていない数値 |
| 2 | DATETIME | 日付や時刻として書式設定されている数値 |
| 4 | STRING | 文字列 |
| 8 | ANNOTATION | セルに付けられたコメント |
| 16 | FORMULA | 計算式 |
| 32 | HARDATTR | セルに直接指定された書式 |
| 64 | STYLES | 間接的に指定された書式 |
| 128 | OBJECT | セルに配置された描画オブジェクト |
| 256 | EDITATTR | セル内の一部のテキストに対してのみ指定された書式 |
一度に複数のフラグを指定することもできます。たとえば、セルの文字列とセルに直接指定された書式をクリアするには、4 + 32 で 36 を引数に指定します。
セルのすべての内容をクリアするには、1 + 2 + 4 + 8 + 16 + 32 + 64 + 128 + 256 で 511 を引数に指定します。
シートのすべてのセルの内容をクリアするOpenOffice.org Basicマクロの例を次に示します。
Dim oSheet As Object
oSheet = ThisComponent.Sheets.getByName("表1")
oSheet.clearContents(36)列番号と行番号で指定したセルのオブジェクトへの参照を返す。
セルを表すオブジェクト（ScCellObj）への参照
セル範囲を表すオブジェクト（ScCellRangeObj）への参照