前の関連記事：Calc(10)行のサービスとインターフェイス一覧
列アクセスオブジェクトのサービスとインターフェイス一覧
def macro():
ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。
smgr = ctx.getServiceManager() # サービスマネージャーの取得。
tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。
doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。
sheets = doc.getSheets() # シートコレクション。
sheet = sheets[0] # 最初のシート。
columns = sheet.getColumns() # 列アクセスオブジェクト。
tcu.wtree(columns)
プロパティのあるサービスがないのに、XPropertySetインターフェイスがありますが、そのメソッドで一括して列のプロパティが設定できるようになっていました。├─.table.TableColumns
│ ├─.container.XEnumerationAccess
│ │ │ .container.XEnumeration createEnumeration()
│ │ └─.container.XElementAccess
│ │ type getElementType()
│ │ boolean hasElements()
│ ├─.container.XNameAccess
│ │ any getByName( [in] string aName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .container.NoSuchElementException)
│ │ [string] getElementNames()
│ │ boolean hasByName( [in] string aName)
│ └─.table.XTableColumns
│ │ void insertByIndex( [in] long nIndex,
│ │ [in] long nCount)
│ │ void removeByIndex( [in] long nIndex,
│ │ [in] long nCount)
│ └─.container.XIndexAccess
│ any getByIndex( [in] long Index
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IndexOutOfBoundsException)
│ long getCount()
├─.beans.XPropertySet
│ void addPropertyChangeListener( [in] string aPropertyName,
│ [in] .beans.XPropertyChangeListener xListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void addVetoableChangeListener( [in] string PropertyName,
│ [in] .beans.XVetoableChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ .beans.XPropertySetInfo getPropertySetInfo()
│ any getPropertyValue( [in] string PropertyName
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void removePropertyChangeListener( [in] string aPropertyName,
│ [in] .beans.XPropertyChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void removeVetoableChangeListener( [in] string PropertyName,
│ [in] .beans.XVetoableChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void setPropertyValue( [in] string aPropertyName,
│ [in] any aValue
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IllegalArgumentException,
│ .beans.PropertyVetoException,
│ .beans.UnknownPropertyException)
└──(サービスやインターフェイスに属しないプロパティ)
boolean IsManualPageBreak
boolean IsStartOfNewPage
boolean IsVisible
boolean OptimalWidth
long Width
│ ├─.container.XEnumerationAccess
│ │ │ .container.XEnumeration createEnumeration()
│ │ └─.container.XElementAccess
│ │ type getElementType()
│ │ boolean hasElements()
│ ├─.container.XNameAccess
│ │ any getByName( [in] string aName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .container.NoSuchElementException)
│ │ [string] getElementNames()
│ │ boolean hasByName( [in] string aName)
│ └─.table.XTableColumns
│ │ void insertByIndex( [in] long nIndex,
│ │ [in] long nCount)
│ │ void removeByIndex( [in] long nIndex,
│ │ [in] long nCount)
│ └─.container.XIndexAccess
│ any getByIndex( [in] long Index
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IndexOutOfBoundsException)
│ long getCount()
├─.beans.XPropertySet
│ void addPropertyChangeListener( [in] string aPropertyName,
│ [in] .beans.XPropertyChangeListener xListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void addVetoableChangeListener( [in] string PropertyName,
│ [in] .beans.XVetoableChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ .beans.XPropertySetInfo getPropertySetInfo()
│ any getPropertyValue( [in] string PropertyName
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void removePropertyChangeListener( [in] string aPropertyName,
│ [in] .beans.XPropertyChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void removeVetoableChangeListener( [in] string PropertyName,
│ [in] .beans.XVetoableChangeListener aListener
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ void setPropertyValue( [in] string aPropertyName,
│ [in] any aValue
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IllegalArgumentException,
│ .beans.PropertyVetoException,
│ .beans.UnknownPropertyException)
└──(サービスやインターフェイスに属しないプロパティ)
boolean IsManualPageBreak
boolean IsStartOfNewPage
boolean IsVisible
boolean OptimalWidth
long Width
列のサービスとインターフェイス一覧
def macro():
ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。
smgr = ctx.getServiceManager() # サービスマネージャーの取得。
tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。
doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。
sheets = doc.getSheets() # シートコレクション。
sheet = sheets[0] # 最初のシート。
columns = sheet.getColumns() # 列アクセスオブジェクト。
column = columns[0] # 1列目。
tcu.wtree(column) # 列
├─.table.TableColumn
│ │ boolean IsStartOfNewPage
│ │ boolean IsVisible
│ │ boolean OptimalWidth
│ │ long Width
│ ├─.beans.XPropertySet
│ │ void addPropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener xListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void addVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.XPropertySetInfo getPropertySetInfo()
│ │ any getPropertyValue( [in] string PropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removePropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removeVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void setPropertyValue( [in] string aPropertyName,
│ │ [in] any aValue
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .lang.IllegalArgumentException,
│ │ .beans.PropertyVetoException,
│ │ .beans.UnknownPropertyException)
│ ├─.container.XNamed
│ │ string getName()
│ │ void setName( [in] string aName)
│ └─.table.XCellRange
│ .table.XCell getCellByPosition( [in] long nColumn,
│ [in] long nRow
│ ) raises ( .lang.IndexOutOfBoundsException)
│ .table.XCellRange getCellRangeByName( [in] string aRange)
│ .table.XCellRange getCellRangeByPosition( [in] long nLeft,
│ [in] long nTop,
│ [in] long nRight,
│ [in] long nBottom
│ ) raises ( .lang.IndexOutOfBoundsException)
├─.beans.XMultiPropertySet
│ void addPropertiesChangeListener( [in] [string] aPropertyNames,
│ [in] .beans.XPropertiesChangeListener xListener)
│ void firePropertiesChangeEvent( [in] [string] aPropertyNames,
│ [in] .beans.XPropertiesChangeListener xListener)
│ .beans.XPropertySetInfo getPropertySetInfo()
│ [any] getPropertyValues( [in] [string] aPropertyNames)
│ void removePropertiesChangeListener( [in] .beans.XPropertiesChangeListener xListener)
│ void setPropertyValues( [in] [string] aPropertyNames,
│ [in] [any] aValues
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IllegalArgumentException,
│ .beans.PropertyVetoException)
├─.beans.XPropertyState
│ any getPropertyDefault( [in] string aPropertyName
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ .beans.PropertyState getPropertyState( [in] string PropertyName
│ ) raises ( .beans.UnknownPropertyException)
│ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ ) raises ( .beans.UnknownPropertyException)
│ void setPropertyToDefault( [in] string PropertyName
│ ) raises ( .beans.UnknownPropertyException)
├─.chart.XChartDataArray
│ │ [string] getColumnDescriptions()
│ │ [[double]] getData()
│ │ [string] getRowDescriptions()
│ │ void setColumnDescriptions( [in] [string] aColumnDescriptions)
│ │ void setData( [in] [[double]] aData)
│ │ void setRowDescriptions( [in] [string] aRowDescriptions)
│ └─.chart.XChartData
│ void addChartDataChangeEventListener( [in] .chart.XChartDataChangeEventListener aListener)
│ double getNotANumber()
│ boolean isNotANumber( [in] double nNumber)
│ void removeChartDataChangeEventListener( [in] .chart.XChartDataChangeEventListener aListener)
├─.sheet.XArrayFormulaRange
│ string getArrayFormula()
│ void setArrayFormula( [in] string aFormula)
├─.sheet.XArrayFormulaTokens
│ [.sheet.FormulaToken] getArrayTokens()
│ void setArrayTokens( [in] [.sheet.FormulaToken] aTokens)
├─.sheet.XCellFormatRangesSupplier
│ .container.XIndexAccess getCellFormatRanges()
├─.sheet.XCellRangeAddressable
│ .table.CellRangeAddress getRangeAddress()
├─.sheet.XCellRangeData
│ [[any]] getDataArray()
│ void setDataArray( [in] [[any]] aArray)
├─.sheet.XCellRangeFormula
│ [[string]] getFormulaArray()
│ void setFormulaArray( [in] [[string]] aArray)
├─.sheet.XCellRangesQuery
│ .sheet.XSheetCellRanges queryColumnDifferences( [in] .table.CellAddress aCompare)
│ .sheet.XSheetCellRanges queryContentCells( [in] short nContentFlags)
│ .sheet.XSheetCellRanges queryEmptyCells()
│ .sheet.XSheetCellRanges queryFormulaCells( [in] long nResultFlags)
│ .sheet.XSheetCellRanges queryIntersection( [in] .table.CellRangeAddress aRange)
│ .sheet.XSheetCellRanges queryRowDifferences( [in] .table.CellAddress aCompare)
│ .sheet.XSheetCellRanges queryVisibleCells()
├─.sheet.XCellSeries
│ void fillAuto( [in] .sheet.FillDirection nFillDirection,
│ [in] long nSourceCount)
│ void fillSeries( [in] .sheet.FillDirection nFillDirection,
│ [in] .sheet.FillMode nFillMode,
│ [in] .sheet.FillDateMode nFillDateMode,
│ [in] double fStep,
│ [in] double fEndValue)
├─.sheet.XFormulaQuery
│ .sheet.XSheetCellRanges queryDependents( [in] boolean bRecursive)
│ .sheet.XSheetCellRanges queryPrecedents( [in] boolean bRecursive)
├─.sheet.XMultipleOperation
│ void setTableOperation( [in] .table.CellRangeAddress aFormulaRange,
│ [in] .sheet.TableOperationMode nMode,
│ [in] .table.CellAddress aColumnCell,
│ [in] .table.CellAddress aRowCell)
├─.sheet.XSheetCellRange
│ .sheet.XSpreadsheet getSpreadsheet()
├─.sheet.XSheetFilterableEx
│ │ .sheet.XSheetFilterDescriptor createFilterDescriptorByObject( [in] .sheet.XSheetFilterable xObject)
│ └─.sheet.XSheetFilterable
│ .sheet.XSheetFilterDescriptor createFilterDescriptor( [in] boolean bEmpty)
│ void filter( [in] .sheet.XSheetFilterDescriptor xDescriptor)
├─.sheet.XSheetOperation
│ void clearContents( [in] long nContentFlags)
│ double computeFunction( [in] .sheet.GeneralFunction nFunction
│ ) raises ( .uno.Exception)
├─.sheet.XSubTotalCalculatable
│ void applySubTotals( [in] .sheet.XSubTotalDescriptor xDescriptor,
│ [in] boolean bReplace)
│ .sheet.XSubTotalDescriptor createSubTotalDescriptor( [in] boolean bEmpty)
│ void removeSubTotals()
├─.sheet.XUniqueCellFormatRangesSupplier
│ .container.XIndexAccess getUniqueCellFormatRanges()
├─.table.XAutoFormattable
│ void autoFormat( [in] string aName
│ ) raises ( .lang.IllegalArgumentException)
├─.table.XColumnRowRange
│ .table.XTableColumns getColumns()
│ .table.XTableRows getRows()
├─.util.XImportable
│ [.beans.PropertyValue] createImportDescriptor( [in] boolean bEmpty)
│ void doImport( [in] [.beans.PropertyValue] aDescriptor)
├─.util.XIndent
│ void decrementIndent()
│ void incrementIndent()
├─.util.XMergeable
│ boolean getIsMerged()
│ void merge( [in] boolean bMerge)
├─.util.XModifyBroadcaster
│ void addModifyListener( [in] .util.XModifyListener aListener)
│ void removeModifyListener( [in] .util.XModifyListener aListener)
├─.util.XReplaceable
│ │ .util.XReplaceDescriptor createReplaceDescriptor()
│ │ long replaceAll( [in] .util.XSearchDescriptor xDesc)
│ └─.util.XSearchable
│ .util.XSearchDescriptor createSearchDescriptor()
│ .container.XIndexAccess findAll( [in] .util.XSearchDescriptor xDesc)
│ .uno.XInterface findFirst( [in] .util.XSearchDescriptor xDesc)
│ .uno.XInterface findNext( [in] .uno.XInterface xStartAt,
│ [in] .util.XSearchDescriptor xDesc)
├─.util.XSortable
│ [.beans.PropertyValue] createSortDescriptor()
│ void sort( [in] [.beans.PropertyValue] xDescriptor)
└──(サービスやインターフェイスに属しないプロパティ)
string AbsoluteName
boolean AsianVerticalMode
.table.BorderLine BottomBorder
.table.BorderLine2 BottomBorder2
long CellBackColor
.util.CellProtection CellProtection
string CellStyle
long CharColor
boolean CharContoured
boolean CharCrossedOut
short CharEmphasis
short CharFont
short CharFontCharSet
short CharFontCharSetAsian
short CharFontCharSetComplex
short CharFontFamily
short CharFontFamilyAsian
short CharFontFamilyComplex
string CharFontName
string CharFontNameAsian
string CharFontNameComplex
short CharFontPitch
short CharFontPitchAsian
short CharFontPitchComplex
string CharFontStyleName
string CharFontStyleNameAsian
string CharFontStyleNameComplex
float CharHeight
float CharHeightAsian
float CharHeightComplex
.lang.Locale CharLocale
.lang.Locale CharLocaleAsian
.lang.Locale CharLocaleComplex
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
.awt.FontSlant CharPosture
.awt.FontSlant CharPostureAsian
.awt.FontSlant CharPostureComplex
short CharRelief
boolean CharShadowed
short CharStrikeout
short CharUnderline
long CharUnderlineColor
boolean CharUnderlineHasColor
float CharWeight
float CharWeightAsian
float CharWeightComplex
boolean CharWordMode
boolean ChartColumnAsLabel
boolean ChartRowAsLabel
.sheet.XSheetConditionalEntries ConditionalFormat
.sheet.XSheetConditionalEntries ConditionalFormatLocal
.sheet.XSheetConditionalEntries ConditionalFormatXML
.table.BorderLine DiagonalBLTR
.table.BorderLine2 DiagonalBLTR2
.table.BorderLine DiagonalTLBR
.table.BorderLine2 DiagonalTLBR2
.table.CellHoriJustify HoriJustify
long HoriJustifyMethod
boolean IsCellBackgroundTransparent
boolean IsManualPageBreak
boolean IsTextWrapped
.table.BorderLine LeftBorder
.table.BorderLine2 LeftBorder2
long NumberFormat
.container.XIndexReplace NumberingRules
.table.CellOrientation Orientation
short ParaAdjust
long ParaBottomMargin
short ParaIndent
boolean ParaIsCharacterDistance
boolean ParaIsForbiddenRules
boolean ParaIsHangingPunctuation
boolean ParaIsHyphenation
short ParaLastLineAdjust
long ParaLeftMargin
long ParaRightMargin
long ParaTopMargin
.awt.Point Position
.table.BorderLine RightBorder
.table.BorderLine2 RightBorder2
long RotateAngle
long RotateReference
.table.ShadowFormat ShadowFormat
boolean ShrinkToFit
.awt.Size Size
.table.TableBorder TableBorder
.table.TableBorder2 TableBorder2
.table.BorderLine TopBorder
.table.BorderLine2 TopBorder2
.container.XNameContainer UserDefinedAttributes
.beans.XPropertySet Validation
.beans.XPropertySet ValidationLocal
.beans.XPropertySet ValidationXML
long VertJustify
long VertJustifyMethod
short WritingMode
│ │ boolean IsStartOfNewPage
│ │ boolean IsVisible
│ │ boolean OptimalWidth
│ │ long Width
│ ├─.beans.XPropertySet
│ │ void addPropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener xListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void addVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.XPropertySetInfo getPropertySetInfo()
│ │ any getPropertyValue( [in] string PropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removePropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removeVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void setPropertyValue( [in] string aPropertyName,
│ │ [in] any aValue
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .lang.IllegalArgumentException,
│ │ .beans.PropertyVetoException,
│ │ .beans.UnknownPropertyException)
│ ├─.container.XNamed
│ │ string getName()
│ │ void setName( [in] string aName)
│ └─.table.XCellRange
│ .table.XCell getCellByPosition( [in] long nColumn,
│ [in] long nRow
│ ) raises ( .lang.IndexOutOfBoundsException)
│ .table.XCellRange getCellRangeByName( [in] string aRange)
│ .table.XCellRange getCellRangeByPosition( [in] long nLeft,
│ [in] long nTop,
│ [in] long nRight,
│ [in] long nBottom
│ ) raises ( .lang.IndexOutOfBoundsException)
├─.beans.XMultiPropertySet
│ void addPropertiesChangeListener( [in] [string] aPropertyNames,
│ [in] .beans.XPropertiesChangeListener xListener)
│ void firePropertiesChangeEvent( [in] [string] aPropertyNames,
│ [in] .beans.XPropertiesChangeListener xListener)
│ .beans.XPropertySetInfo getPropertySetInfo()
│ [any] getPropertyValues( [in] [string] aPropertyNames)
│ void removePropertiesChangeListener( [in] .beans.XPropertiesChangeListener xListener)
│ void setPropertyValues( [in] [string] aPropertyNames,
│ [in] [any] aValues
│ ) raises ( .lang.WrappedTargetException,
│ .lang.IllegalArgumentException,
│ .beans.PropertyVetoException)
├─.beans.XPropertyState
│ any getPropertyDefault( [in] string aPropertyName
│ ) raises ( .lang.WrappedTargetException,
│ .beans.UnknownPropertyException)
│ .beans.PropertyState getPropertyState( [in] string PropertyName
│ ) raises ( .beans.UnknownPropertyException)
│ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ ) raises ( .beans.UnknownPropertyException)
│ void setPropertyToDefault( [in] string PropertyName
│ ) raises ( .beans.UnknownPropertyException)
├─.chart.XChartDataArray
│ │ [string] getColumnDescriptions()
│ │ [[double]] getData()
│ │ [string] getRowDescriptions()
│ │ void setColumnDescriptions( [in] [string] aColumnDescriptions)
│ │ void setData( [in] [[double]] aData)
│ │ void setRowDescriptions( [in] [string] aRowDescriptions)
│ └─.chart.XChartData
│ void addChartDataChangeEventListener( [in] .chart.XChartDataChangeEventListener aListener)
│ double getNotANumber()
│ boolean isNotANumber( [in] double nNumber)
│ void removeChartDataChangeEventListener( [in] .chart.XChartDataChangeEventListener aListener)
├─.sheet.XArrayFormulaRange
│ string getArrayFormula()
│ void setArrayFormula( [in] string aFormula)
├─.sheet.XArrayFormulaTokens
│ [.sheet.FormulaToken] getArrayTokens()
│ void setArrayTokens( [in] [.sheet.FormulaToken] aTokens)
├─.sheet.XCellFormatRangesSupplier
│ .container.XIndexAccess getCellFormatRanges()
├─.sheet.XCellRangeAddressable
│ .table.CellRangeAddress getRangeAddress()
├─.sheet.XCellRangeData
│ [[any]] getDataArray()
│ void setDataArray( [in] [[any]] aArray)
├─.sheet.XCellRangeFormula
│ [[string]] getFormulaArray()
│ void setFormulaArray( [in] [[string]] aArray)
├─.sheet.XCellRangesQuery
│ .sheet.XSheetCellRanges queryColumnDifferences( [in] .table.CellAddress aCompare)
│ .sheet.XSheetCellRanges queryContentCells( [in] short nContentFlags)
│ .sheet.XSheetCellRanges queryEmptyCells()
│ .sheet.XSheetCellRanges queryFormulaCells( [in] long nResultFlags)
│ .sheet.XSheetCellRanges queryIntersection( [in] .table.CellRangeAddress aRange)
│ .sheet.XSheetCellRanges queryRowDifferences( [in] .table.CellAddress aCompare)
│ .sheet.XSheetCellRanges queryVisibleCells()
├─.sheet.XCellSeries
│ void fillAuto( [in] .sheet.FillDirection nFillDirection,
│ [in] long nSourceCount)
│ void fillSeries( [in] .sheet.FillDirection nFillDirection,
│ [in] .sheet.FillMode nFillMode,
│ [in] .sheet.FillDateMode nFillDateMode,
│ [in] double fStep,
│ [in] double fEndValue)
├─.sheet.XFormulaQuery
│ .sheet.XSheetCellRanges queryDependents( [in] boolean bRecursive)
│ .sheet.XSheetCellRanges queryPrecedents( [in] boolean bRecursive)
├─.sheet.XMultipleOperation
│ void setTableOperation( [in] .table.CellRangeAddress aFormulaRange,
│ [in] .sheet.TableOperationMode nMode,
│ [in] .table.CellAddress aColumnCell,
│ [in] .table.CellAddress aRowCell)
├─.sheet.XSheetCellRange
│ .sheet.XSpreadsheet getSpreadsheet()
├─.sheet.XSheetFilterableEx
│ │ .sheet.XSheetFilterDescriptor createFilterDescriptorByObject( [in] .sheet.XSheetFilterable xObject)
│ └─.sheet.XSheetFilterable
│ .sheet.XSheetFilterDescriptor createFilterDescriptor( [in] boolean bEmpty)
│ void filter( [in] .sheet.XSheetFilterDescriptor xDescriptor)
├─.sheet.XSheetOperation
│ void clearContents( [in] long nContentFlags)
│ double computeFunction( [in] .sheet.GeneralFunction nFunction
│ ) raises ( .uno.Exception)
├─.sheet.XSubTotalCalculatable
│ void applySubTotals( [in] .sheet.XSubTotalDescriptor xDescriptor,
│ [in] boolean bReplace)
│ .sheet.XSubTotalDescriptor createSubTotalDescriptor( [in] boolean bEmpty)
│ void removeSubTotals()
├─.sheet.XUniqueCellFormatRangesSupplier
│ .container.XIndexAccess getUniqueCellFormatRanges()
├─.table.XAutoFormattable
│ void autoFormat( [in] string aName
│ ) raises ( .lang.IllegalArgumentException)
├─.table.XColumnRowRange
│ .table.XTableColumns getColumns()
│ .table.XTableRows getRows()
├─.util.XImportable
│ [.beans.PropertyValue] createImportDescriptor( [in] boolean bEmpty)
│ void doImport( [in] [.beans.PropertyValue] aDescriptor)
├─.util.XIndent
│ void decrementIndent()
│ void incrementIndent()
├─.util.XMergeable
│ boolean getIsMerged()
│ void merge( [in] boolean bMerge)
├─.util.XModifyBroadcaster
│ void addModifyListener( [in] .util.XModifyListener aListener)
│ void removeModifyListener( [in] .util.XModifyListener aListener)
├─.util.XReplaceable
│ │ .util.XReplaceDescriptor createReplaceDescriptor()
│ │ long replaceAll( [in] .util.XSearchDescriptor xDesc)
│ └─.util.XSearchable
│ .util.XSearchDescriptor createSearchDescriptor()
│ .container.XIndexAccess findAll( [in] .util.XSearchDescriptor xDesc)
│ .uno.XInterface findFirst( [in] .util.XSearchDescriptor xDesc)
│ .uno.XInterface findNext( [in] .uno.XInterface xStartAt,
│ [in] .util.XSearchDescriptor xDesc)
├─.util.XSortable
│ [.beans.PropertyValue] createSortDescriptor()
│ void sort( [in] [.beans.PropertyValue] xDescriptor)
└──(サービスやインターフェイスに属しないプロパティ)
string AbsoluteName
boolean AsianVerticalMode
.table.BorderLine BottomBorder
.table.BorderLine2 BottomBorder2
long CellBackColor
.util.CellProtection CellProtection
string CellStyle
long CharColor
boolean CharContoured
boolean CharCrossedOut
short CharEmphasis
short CharFont
short CharFontCharSet
short CharFontCharSetAsian
short CharFontCharSetComplex
short CharFontFamily
short CharFontFamilyAsian
short CharFontFamilyComplex
string CharFontName
string CharFontNameAsian
string CharFontNameComplex
short CharFontPitch
short CharFontPitchAsian
short CharFontPitchComplex
string CharFontStyleName
string CharFontStyleNameAsian
string CharFontStyleNameComplex
float CharHeight
float CharHeightAsian
float CharHeightComplex
.lang.Locale CharLocale
.lang.Locale CharLocaleAsian
.lang.Locale CharLocaleComplex
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
.awt.FontSlant CharPosture
.awt.FontSlant CharPostureAsian
.awt.FontSlant CharPostureComplex
short CharRelief
boolean CharShadowed
short CharStrikeout
short CharUnderline
long CharUnderlineColor
boolean CharUnderlineHasColor
float CharWeight
float CharWeightAsian
float CharWeightComplex
boolean CharWordMode
boolean ChartColumnAsLabel
boolean ChartRowAsLabel
.sheet.XSheetConditionalEntries ConditionalFormat
.sheet.XSheetConditionalEntries ConditionalFormatLocal
.sheet.XSheetConditionalEntries ConditionalFormatXML
.table.BorderLine DiagonalBLTR
.table.BorderLine2 DiagonalBLTR2
.table.BorderLine DiagonalTLBR
.table.BorderLine2 DiagonalTLBR2
.table.CellHoriJustify HoriJustify
long HoriJustifyMethod
boolean IsCellBackgroundTransparent
boolean IsManualPageBreak
boolean IsTextWrapped
.table.BorderLine LeftBorder
.table.BorderLine2 LeftBorder2
long NumberFormat
.container.XIndexReplace NumberingRules
.table.CellOrientation Orientation
short ParaAdjust
long ParaBottomMargin
short ParaIndent
boolean ParaIsCharacterDistance
boolean ParaIsForbiddenRules
boolean ParaIsHangingPunctuation
boolean ParaIsHyphenation
short ParaLastLineAdjust
long ParaLeftMargin
long ParaRightMargin
long ParaTopMargin
.awt.Point Position
.table.BorderLine RightBorder
.table.BorderLine2 RightBorder2
long RotateAngle
long RotateReference
.table.ShadowFormat ShadowFormat
boolean ShrinkToFit
.awt.Size Size
.table.TableBorder TableBorder
.table.TableBorder2 TableBorder2
.table.BorderLine TopBorder
.table.BorderLine2 TopBorder2
.container.XNameContainer UserDefinedAttributes
.beans.XPropertySet Validation
.beans.XPropertySet ValidationLocal
.beans.XPropertySet ValidationXML
long VertJustify
long VertJustifyMethod
short WritingMode
0 件のコメント:
コメントを投稿