ScCellRangeObjのプロパティ一覧を次に示す。
プロパティ | 概要 | |
---|---|---|
SbxSTRING | AbsoluteName | |
SbxBOOL | AsianVerticalMode | |
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 | |
SbxOBJECT | DiagonalBLTR | |
SbxOBJECT | DiagonalTLBR | |
SbxLONG | HoriJustify | |
SbxBOOL | IsCellBackgroundTransparent | |
SbxBOOL | IsTextWrapped | |
SbxOBJECT | LeftBorder | |
SbxLONG | NumberFormat | |
SbxOBJECT | NumberingRules | |
SbxLONG | Orientation | |
SbxINTEGER | ParaAdjust | |
SbxLONG | ParaBottomMargin | |
SbxINTEGER | ParaIndent | |
SbxBOOL | ParaIsCharacterDistance | |
SbxBOOL | ParaIsForbiddenRules | |
SbxBOOL | ParaIsHangingPunctuation | |
SbxBOOL | ParaIsHyphenation | |
SbxINTEGER | ParaLastLineAdjust | |
SbxLONG | ParaLeftMargin | |
SbxLONG | ParaRightMargin | |
SbxLONG | ParaTopMargin | |
SbxOBJECT | Position | |
SbxOBJECT | RightBorder | |
SbxLONG | RotateAngle | |
SbxLONG | RotateReference | |
SbxOBJECT | ShadowFormat | |
SbxBOOL | ShrinkToFit | |
SbxOBJECT | Size | |
SbxOBJECT | TableBorder | |
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 | ArrayTokens | |
SbxARRAY | DataArray | |
SbxARRAY | FormulaArray | |
SbxBOOL | IsMerged | |
SbxOBJECT | Columns | |
SbxOBJECT | Rows | |
SbxOBJECT | CellFormatRanges | |
SbxOBJECT | UniqueCellFormatRanges | |
SbxSTRING | Dbg_SupportedInterfaces | サポートしているインタフェースの一覧 |
SbxSTRING | Dbg_Properties | 属性の一覧 |
SbxSTRING | Dbg_Methods | メソッドの一覧 |
ScCellRangeObjのメソッド一覧を次に示す。
メソッド | 概要 | |
---|---|---|
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 | getArrayTokens ( void ) | |
SbxVOID | setArrayTokens ( SbxARRAY ) | |
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 ) |
文字の色
文字の色を表す数値はRGB関数で求めることができる。
赤、緑、青の要素をそれぞれ0から255の値で指定する。
oRange.CharColor = RGB(127, 0, 255)
セル範囲(対象となる複数のセル)の内容をクリアする。
OpenOffice.org Basic での呼び出し形式:
無し
値 | フラグ | 説明 |
---|---|---|
1 | VALUE | 日付や時刻として書式設定されていない数値 |
2 | DATETIME | 日付や時刻として書式設定されている数値 |
4 | STRING | 文字列 |
8 | ANNOTATION | セルに付けられたコメント |
16 | FORMULA | 計算式 |
32 | HARDATTR | セルに直接指定された書式 |
64 | STYLES | 間接的に指定された書式 |
128 | OBJECT | セルに配置された描画オブジェクト |
256 | EDITATTR | セル内の一部のテキストに対してのみ指定された書式 |
一度に複数のフラグを指定することもできます。たとえば、セルの文字列とセルに直接指定された書式をクリアするには、4 + 32 で 36 を引数に指定します。
oRange.clearContents(36)
セルのすべての内容をクリアするには、1 + 2 + 4 + 8 + 16 + 32 + 64 + 128 + 256 で 511 を引数に指定します。
oRange.clearContents(511)
複数セルの内容をクリアするOpenOffice.org Basicマクロの例を次に示します。
Dim oSheet As Object
Dim oRange As Object
oSheet = ThisComponent.Sheets.getByName("表1")
oRange = oSheet.getCellRangePosition(0, 0, 10, 5)
oRange.clearContents(36)
getDataArrayメソッドは、セル範囲内の値を配列に読み込む。
OpenOffice.org Basic での呼び出し形式:
指定されたセル範囲内の値が格納された配列
無し
Dim Sheet As Object
Dim DataArray()
Dim RowDataArray()
Sheet = ThisComponent.Sheets(0)
DataArray() = Sheet.getCellRangeByPosition(0, 0, 1, 1).getDataArray()
RowDataArray() = DataArray(0)
' RowDataArray(0) = Sheet.getCellByPosition(0, 0).Value(1行1列目)
' RowDataArray(1) = Sheet.getCellByPosition(1, 0).Value(1行2列目)
RowDataArray() = DataArray(1)
' RowDataArray(0) = Sheet.getCellByPosition(0, 1).Value(2行1列目)
' RowDataArray(1) = Sheet.getCellByPosition(1, 1).Value(2行2列目)
setDataArrayメソッドは、配列に格納されたデータをセル範囲内に書き込む。
OpenOffice.org Basic での呼び出し形式:
無し
Dim Sheet As Object
Dim DataArray(1)
DataArray(0) = Array(1, 2)
DataArray(1) = Array(3, 4)
Sheet = ThisComponent.Sheets(0)
Sheet.getCellRangeByPosition(0, 0, 1, 1).setDataArray(DataArray)
getFormulaArrayメソッドは、セル範囲内の数式を配列に読み込む。
OpenOffice.org Basic での呼び出し形式:
指定されたセル範囲内の数式が格納された配列
無し
Dim Sheet As Object
Dim DataArray()
Dim RowDataArray()
Sheet = ThisComponent.Sheets(0)
DataArray() = Sheet.getCellRangeByPosition(0, 0, 1, 1,).getFormulaArray()
RowDataArray() = DataArray(0)
' RowDataArray(0) = Sheet.getCellByPosition(0, 0).Formula(1行1列目)
' RowDataArray(1) = Sheet.getCellByPosition(1, 0).Formula(1行2列目)
RowDataArray() = DataArray(1)
' RowDataArray(0) = Sheet.getCellByPosition(0, 1).Formula(2行1列目)
' RowDataArray(1) = Sheet.getCellByPosition(1, 1).Formula(2行2列目)
setFormulaArrayメソッドは、配列に格納された数式をセル範囲内に書き込む。
OpenOffice.org Basic での呼び出し形式:
無し
Dim Sheet As Object
Dim DataArray(1)
DataArray(0) = Array("=Max(X1:X9)", "=Min(X1:X9)")
DataArray(1) = Array<("=Max(Y1:Y9)", "=Min(Y1:Y9)")
Sheet = ThisComponent.Sheets(0)
Sheet.getCellRangeByPosition(0, 0, 1, 1,).setDataArray(DataArray)