前の関連記事:Calc(12)CalcドキュメントとWriterドキュメントとのサービスとインターフェイスの比較
セルをセル範囲と比較したサービスとインターフェイス一覧
def macro(): ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。 smgr = ctx.getServiceManager() # サービスマネージャーの取得。 tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。 doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。 sheets = doc.getSheets() # シートコレクション。 sheet = sheets[0] # 最初のシート。 cell = sheet[0, 0] # 行インデックス0、列インデックス0、のセル(つまりA1セル)。 cells = sheet[2:5, 3:6] # 行インデックス2以上5未満、列インデックス3以上6未満(つまりD3:F5と同じ)のセル範囲。 tcu.wcompare(cell, cells)object1はセル、object2はセル範囲を指します。
object1とobject2に共通するサービスとインターフェイス一覧
├─.sheet.SheetCellRange
│ │ string AbsoluteName
│ │ .sheet.XSheetConditionalEntries ConditionalFormat
│ │ .sheet.XSheetConditionalEntries ConditionalFormatLocal
│ │ .awt.Point Position
│ │ .awt.Size Size
│ │ .beans.XPropertySet Validation
│ │ .beans.XPropertySet ValidationLocal
│ ├─.beans.XTolerantMultiPropertySet
│ │ [.beans.GetDirectPropertyTolerantResult] getDirectPropertyValuesTolerant( [in] [string] aPropertyNames)
│ │ [.beans.GetPropertyTolerantResult] getPropertyValuesTolerant( [in] [string] aPropertyNames)
│ │ [.beans.SetPropertyTolerantFailed] setPropertyValuesTolerant( [in] [string] aPropertyNames,
│ │ [in] [any] aValues
│ │ ) raises ( .lang.IllegalArgumentException)
│ ├─.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.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.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.XMultipleOperation
│ │ void setTableOperation( [in] .table.CellRangeAddress aFormulaRange,
│ │ [in] .sheet.TableOperationMode nMode,
│ │ [in] .table.CellAddress aColumnCell,
│ │ [in] .table.CellAddress aRowCell)
│ ├─.sheet.XSheetCellRange
│ │ │ .sheet.XSpreadsheet getSpreadsheet()
│ │ └─.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)
│ ├─.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)
│ ├─.sheet.SheetRangesQuery
│ │ ├─.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.XFormulaQuery
│ │ .sheet.XSheetCellRanges queryDependents( [in] boolean bRecursive)
│ │ .sheet.XSheetCellRanges queryPrecedents( [in] boolean bRecursive)
│ ├─.style.CharacterProperties
│ │ boolean CharAutoKerning
│ │ .util.Color CharBackColor
│ │ boolean CharBackTransparent
│ │ long CharBorderDistance
│ │ .table.BorderLine2 CharBottomBorder
│ │ long CharBottomBorderDistance
│ │ short CharCaseMap
│ │ .util.Color CharColor
│ │ boolean CharCombineIsOn
│ │ string CharCombinePrefix
│ │ string CharCombineSuffix
│ │ boolean CharContoured
│ │ boolean CharCrossedOut
│ │ short CharEmphasis
│ │ short CharEscapement
│ │ byte CharEscapementHeight
│ │ boolean CharFlash
│ │ short CharFontCharSet
│ │ short CharFontFamily
│ │ string CharFontName
│ │ short CharFontPitch
│ │ string CharFontStyleName
│ │ short CharFontType
│ │ float CharHeight
│ │ boolean CharHidden
│ │ .util.Color CharHighlight
│ │ [.beans.PropertyValue] CharInteropGrabBag
│ │ boolean CharKeepTogether
│ │ short CharKerning
│ │ .table.BorderLine2 CharLeftBorder
│ │ long CharLeftBorderDistance
│ │ .lang.Locale CharLocale
│ │ boolean CharNoHyphenation
│ │ boolean CharNoLineBreak
│ │ .awt.FontSlant CharPosture
│ │ short CharRelief
│ │ .table.BorderLine2 CharRightBorder
│ │ long CharRightBorderDistance
│ │ short CharRotation
│ │ boolean CharRotationIsFitToLine
│ │ short CharScaleWidth
│ │ long CharShadingValue
│ │ .table.ShadowFormat CharShadowFormat
│ │ boolean CharShadowed
│ │ short CharStrikeout
│ │ string CharStyleName
│ │ [string] CharStyleNames
│ │ .table.BorderLine2 CharTopBorder
│ │ long CharTopBorderDistance
│ │ short CharUnderline
│ │ .util.Color CharUnderlineColor
│ │ boolean CharUnderlineHasColor
│ │ float CharWeight
│ │ boolean CharWordMode
│ │ string HyperLinkName
│ │ string HyperLinkTarget
│ │ string HyperLinkURL
│ │ short RubyAdjust
│ │ string RubyCharStyleName
│ │ boolean RubyIsAbove
│ │ string RubyText
│ │ .container.XNameContainer TextUserDefinedAttributes
│ │ string UnvisitedCharStyleName
│ │ string VisitedCharStyleName
│ ├─.style.CharacterPropertiesAsian
│ │ short CharFontCharSetAsian
│ │ short CharFontFamilyAsian
│ │ string CharFontNameAsian
│ │ short CharFontPitchAsian
│ │ string CharFontStyleNameAsian
│ │ float CharHeightAsian
│ │ .lang.Locale CharLocaleAsian
│ │ .awt.FontSlant CharPostureAsian
│ │ float CharWeightAsian
│ ├─.style.CharacterPropertiesComplex
│ │ short CharFontCharSetComplex
│ │ short CharFontFamilyComplex
│ │ string CharFontNameComplex
│ │ short CharFontPitchComplex
│ │ string CharFontStyleNameComplex
│ │ float CharHeightComplex
│ │ .lang.Locale CharLocaleComplex
│ │ .awt.FontSlant CharPostureComplex
│ │ float CharWeightComplex
│ ├─.style.ParagraphProperties
│ │ long BorderDistance
│ │ .table.BorderLine BottomBorder
│ │ long BottomBorderDistance
│ │ .style.BreakType BreakType
│ │ string DropCapCharStyleName
│ │ .style.DropCapFormat DropCapFormat
│ │ boolean DropCapWholeWord
│ │ .table.BorderLine LeftBorder
│ │ long LeftBorderDistance
│ │ string ListId
│ │ boolean NumberingIsNumber
│ │ short NumberingLevel
│ │ .container.XIndexReplace NumberingRules
│ │ short NumberingStartValue
│ │ string NumberingStyleName
│ │ short OutlineLevel
│ │ string PageDescName
│ │ short PageNumberOffset
│ │ string PageStyleName
│ │ .style.ParagraphAdjust ParaAdjust
│ │ .util.Color ParaBackColor
│ │ string ParaBackGraphicFilter
│ │ .style.GraphicLocation ParaBackGraphicLocation
│ │ string ParaBackGraphicURL
│ │ boolean ParaBackTransparent
│ │ long ParaBottomMargin
│ │ boolean ParaContextMargin
│ │ boolean ParaExpandSingleWord
│ │ long ParaFirstLineIndent
│ │ short ParaHyphenationMaxHyphens
│ │ short ParaHyphenationMaxLeadingChars
│ │ short ParaHyphenationMaxTrailingChars
│ │ [.beans.PropertyValue] ParaInteropGrabBag
│ │ boolean ParaIsAutoFirstLineIndent
│ │ boolean ParaIsConnectBorder
│ │ boolean ParaIsHyphenation
│ │ boolean ParaIsNumberingRestart
│ │ boolean ParaKeepTogether
│ │ short ParaLastLineAdjust
│ │ long ParaLeftMargin
│ │ boolean ParaLineNumberCount
│ │ long ParaLineNumberStartValue
│ │ .style.LineSpacing ParaLineSpacing
│ │ byte ParaOrphans
│ │ boolean ParaRegisterModeActive
│ │ long ParaRightMargin
│ │ .table.ShadowFormat ParaShadowFormat
│ │ boolean ParaSplit
│ │ string ParaStyleName
│ │ [.style.TabStop] ParaTabStops
│ │ long ParaTopMargin
│ │ .container.XNameContainer ParaUserDefinedAttributes
│ │ short ParaVertAlignment
│ │ byte ParaWidows
│ │ .table.BorderLine RightBorder
│ │ long RightBorderDistance
│ │ .table.BorderLine TopBorder
│ │ long TopBorderDistance
│ └─.table.CellRange
│ └─.table.CellProperties
│ │ boolean AsianVerticalMode
│ │ .table.BorderLine BottomBorder
│ │ .table.BorderLine2 BottomBorder2
│ │ .util.Color CellBackColor
│ │ [.beans.PropertyValue] CellInteropGrabBag
│ │ .util.CellProtection CellProtection
│ │ string CellStyle
│ │ &nbsnbsp; .table.BorderLine DiagonalBLTR
│ │ .table.BorderLine2 DiagonalBLTR2
│ │ .table.BorderLine DiagonalTLBR
│ │ .table.BorderLine2 DiagonalTLBR2
│ │ .table.CellHoriJustify HoriJustify
│ │ boolean IsCellBackgroundTransparent
│ │ boolean IsTextWrapped
│ │ .table.BorderLine LeftBorder
│ │ .table.BorderLine2 LeftBorder2
│ │ long NumberFormat
│ │ .table.CellOrientation Orientation
│ │ short ParaIndent
│ │ .table.BorderLine RightBorder
│ │ .table.BorderLine2 RightBorder2
│ │ long RotateAngle
│ │ long RotateReference
│ │ .table.ShadowFormat ShadowFormat
│ │ boolean ShrinkToFit
│ │ .table.TableBorder TableBorder
│ │ .table.TableBorder2 TableBorder2
│ │ .table.BorderLine TopBorder
│ │ .table.BorderLine2 TopBorder2
│ │ .container.XNameContainer UserDefinedAttributes
│ │ long VertJustify
│ └─.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)
├─.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)
├─.sheet.XArrayFormulaTokens
│ [.sheet.FormulaToken] getArrayTokens()
│ void setArrayTokens( [in] [.sheet.FormulaToken] aTokens)
└──(サービスやインターフェイスに属しないプロパティ)
short CharFont
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
boolean ChartColumnAsLabel
boolean ChartRowAsLabel
.sheet.XSheetConditionalEntries ConditionalFormatXML
unsigned hyper FormatID
long HoriJustifyMethod
.beans.XPropertySet ValidationXML
long VertJustifyMethod
object1だけがもつサービスとインターフェイス一覧
├─.sheet.SheetCell
│ │ string AbsoluteName
│ │ .sheet.XSheetConditionalEntries ConditionalFormat
│ │ .sheet.XSheetConditionalEntries ConditionalFormatLocal
│ │ string FormulaLocal
│ │ long FormulaResultType
│ │ .awt.Point Position
│ │ .awt.Size Size
│ │ .beans.XPropertySet Validation
│ │ .beans.XPropertySet ValidationLocal
│ ├─.document.XActionLockable
│ │ void addActionLock()
│ │ boolean isActionLocked()
│ │ void removeActionLock()
│ │ short resetActionLocks()
│ │ void setActionLocks( [in] short nLock)
│ ├─.sheet.XCellAddressable
│ │ .table.CellAddress getCellAddress()
│ ├─.sheet.XSheetAnnotationAnchor
│ │ .sheet.XSheetAnnotation getAnnotation()
│ ├─.text.XTextFieldsSupplier
│ │ .container.XNameAccess getTextFieldMasters()
│ │ .container.XEnumerationAccess getTextFields()
│ ├─.style.ParagraphPropertiesAsian
│ │ boolean ParaIsCharacterDistance
│ │ boolean ParaIsForbiddenRules
│ │ boolean ParaIsHangingPunctuation
│ ├─.style.ParagraphPropertiesComplex
│ │ short WritingMode
│ ├─.table.Cell
│ │ ├─.table.XCell
│ │ │ long getError()
│ │ │ string getFormula()
│ │ │ .table.CellContentType getType()
│ │ │ double getValue()
│ │ │ void setFormula( [in] string aFormula)
│ │ │ void setValue( [in] double nValue)
│ │ └─.text.XText
│ │ │ void insertTextContent( [in] .text.XTextRange xRange,
│ │ │ [in] .text.XTextContent xContent,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void removeTextContent( [in] .text.XTextContent xContent
│ │ │ ) raises ( .container.NoSuchElementException)
│ │ └─.text.XSimpleText
│ │ │ .text.XTextCursor createTextCursor()
│ │ │ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ │ │ void insertControlCharacter( [in] .text.XTextRange xRange,
│ │ │ [in] short nControlCharacter,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void insertString( [in] .text.XTextRange xRange,
│ │ │ [in] string aString,
│ │ │ [in] boolean bAbsorb)
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ └─.text.Text
│ │ .beans.PropertyValues EndRedline
│ │ .beans.PropertyValues StartRedline
│ ├─.container.XEnumerationAccess
│ │ │ .container.XEnumeration createEnumeration()
│ │ └─.container.XElementAccess
│ │ type getElementType()
│ │ boolean hasElements()
│ ├─.text.XRelativeTextContentInsert
│ │ void insertTextContentAfter( [in] .text.XTextContent xNewContent,
│ │ [in] .text.XTextContent xPredecessor
│ │ ) raises ( .lang.IllegalArgumentException)
│ │ void insertTextContentBefore( [in] .text.XTextContent xNewContent,
│ │ [in] .text.XTextContent xSuccessor
│ │ ) raises ( .lang.IllegalArgumentException)
│ ├─.text.XTextRangeCompare
│ │ short compareRegionEnds( [in] .text.XTextRange xR1,
│ │ [in] .text.XTextRange xR2
│ │ ) raises ( .lang.IllegalArgumentException)
│ │ short compareRegionStarts( [in] .text.XTextRange xR1,
│ │ [in] .text.XTextRange xR2
│ │ ) raises ( .lang.IllegalArgumentException)
│ └─.text.XTextRangeMover
│ void moveTextRange( [in] .text.XTextRange xRange,
│ [in] short nParagraphs)
├─.sheet.XFormulaTokens
│ [.sheet.FormulaToken] getTokens()
│ void setTokens( [in] [.sheet.FormulaToken] aTokens)
├─.table.XCell2
│ void setFormulaResult( [in] double nValue)
│ void setFormulaString( [in] string aFormula)
└──(サービスやインターフェイスに属しないプロパティ)
string Hyperlink
object2だけがもつサービスとインターフェイス一覧
└──(相手のサービスやインターフェイスに属しているプロパティにあるもの)
boolean ParaIsCharacterDistance
boolean ParaIsForbiddenRules
boolean ParaIsHangingPunctuation
short WritingMode
├─.sheet.SheetCellRange
│ │ string AbsoluteName
│ │ .sheet.XSheetConditionalEntries ConditionalFormat
│ │ .sheet.XSheetConditionalEntries ConditionalFormatLocal
│ │ .awt.Point Position
│ │ .awt.Size Size
│ │ .beans.XPropertySet Validation
│ │ .beans.XPropertySet ValidationLocal
│ ├─.beans.XTolerantMultiPropertySet
│ │ [.beans.GetDirectPropertyTolerantResult] getDirectPropertyValuesTolerant( [in] [string] aPropertyNames)
│ │ [.beans.GetPropertyTolerantResult] getPropertyValuesTolerant( [in] [string] aPropertyNames)
│ │ [.beans.SetPropertyTolerantFailed] setPropertyValuesTolerant( [in] [string] aPropertyNames,
│ │ [in] [any] aValues
│ │ ) raises ( .lang.IllegalArgumentException)
│ ├─.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.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.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.XMultipleOperation
│ │ void setTableOperation( [in] .table.CellRangeAddress aFormulaRange,
│ │ [in] .sheet.TableOperationMode nMode,
│ │ [in] .table.CellAddress aColumnCell,
│ │ [in] .table.CellAddress aRowCell)
│ ├─.sheet.XSheetCellRange
│ │ │ .sheet.XSpreadsheet getSpreadsheet()
│ │ └─.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)
│ ├─.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)
│ ├─.sheet.SheetRangesQuery
│ │ ├─.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.XFormulaQuery
│ │ .sheet.XSheetCellRanges queryDependents( [in] boolean bRecursive)
│ │ .sheet.XSheetCellRanges queryPrecedents( [in] boolean bRecursive)
│ ├─.style.CharacterProperties
│ │ boolean CharAutoKerning
│ │ .util.Color CharBackColor
│ │ boolean CharBackTransparent
│ │ long CharBorderDistance
│ │ .table.BorderLine2 CharBottomBorder
│ │ long CharBottomBorderDistance
│ │ short CharCaseMap
│ │ .util.Color CharColor
│ │ boolean CharCombineIsOn
│ │ string CharCombinePrefix
│ │ string CharCombineSuffix
│ │ boolean CharContoured
│ │ boolean CharCrossedOut
│ │ short CharEmphasis
│ │ short CharEscapement
│ │ byte CharEscapementHeight
│ │ boolean CharFlash
│ │ short CharFontCharSet
│ │ short CharFontFamily
│ │ string CharFontName
│ │ short CharFontPitch
│ │ string CharFontStyleName
│ │ short CharFontType
│ │ float CharHeight
│ │ boolean CharHidden
│ │ .util.Color CharHighlight
│ │ [.beans.PropertyValue] CharInteropGrabBag
│ │ boolean CharKeepTogether
│ │ short CharKerning
│ │ .table.BorderLine2 CharLeftBorder
│ │ long CharLeftBorderDistance
│ │ .lang.Locale CharLocale
│ │ boolean CharNoHyphenation
│ │ boolean CharNoLineBreak
│ │ .awt.FontSlant CharPosture
│ │ short CharRelief
│ │ .table.BorderLine2 CharRightBorder
│ │ long CharRightBorderDistance
│ │ short CharRotation
│ │ boolean CharRotationIsFitToLine
│ │ short CharScaleWidth
│ │ long CharShadingValue
│ │ .table.ShadowFormat CharShadowFormat
│ │ boolean CharShadowed
│ │ short CharStrikeout
│ │ string CharStyleName
│ │ [string] CharStyleNames
│ │ .table.BorderLine2 CharTopBorder
│ │ long CharTopBorderDistance
│ │ short CharUnderline
│ │ .util.Color CharUnderlineColor
│ │ boolean CharUnderlineHasColor
│ │ float CharWeight
│ │ boolean CharWordMode
│ │ string HyperLinkName
│ │ string HyperLinkTarget
│ │ string HyperLinkURL
│ │ short RubyAdjust
│ │ string RubyCharStyleName
│ │ boolean RubyIsAbove
│ │ string RubyText
│ │ .container.XNameContainer TextUserDefinedAttributes
│ │ string UnvisitedCharStyleName
│ │ string VisitedCharStyleName
│ ├─.style.CharacterPropertiesAsian
│ │ short CharFontCharSetAsian
│ │ short CharFontFamilyAsian
│ │ string CharFontNameAsian
│ │ short CharFontPitchAsian
│ │ string CharFontStyleNameAsian
│ │ float CharHeightAsian
│ │ .lang.Locale CharLocaleAsian
│ │ .awt.FontSlant CharPostureAsian
│ │ float CharWeightAsian
│ ├─.style.CharacterPropertiesComplex
│ │ short CharFontCharSetComplex
│ │ short CharFontFamilyComplex
│ │ string CharFontNameComplex
│ │ short CharFontPitchComplex
│ │ string CharFontStyleNameComplex
│ │ float CharHeightComplex
│ │ .lang.Locale CharLocaleComplex
│ │ .awt.FontSlant CharPostureComplex
│ │ float CharWeightComplex
│ ├─.style.ParagraphProperties
│ │ long BorderDistance
│ │ .table.BorderLine BottomBorder
│ │ long BottomBorderDistance
│ │ .style.BreakType BreakType
│ │ string DropCapCharStyleName
│ │ .style.DropCapFormat DropCapFormat
│ │ boolean DropCapWholeWord
│ │ .table.BorderLine LeftBorder
│ │ long LeftBorderDistance
│ │ string ListId
│ │ boolean NumberingIsNumber
│ │ short NumberingLevel
│ │ .container.XIndexReplace NumberingRules
│ │ short NumberingStartValue
│ │ string NumberingStyleName
│ │ short OutlineLevel
│ │ string PageDescName
│ │ short PageNumberOffset
│ │ string PageStyleName
│ │ .style.ParagraphAdjust ParaAdjust
│ │ .util.Color ParaBackColor
│ │ string ParaBackGraphicFilter
│ │ .style.GraphicLocation ParaBackGraphicLocation
│ │ string ParaBackGraphicURL
│ │ boolean ParaBackTransparent
│ │ long ParaBottomMargin
│ │ boolean ParaContextMargin
│ │ boolean ParaExpandSingleWord
│ │ long ParaFirstLineIndent
│ │ short ParaHyphenationMaxHyphens
│ │ short ParaHyphenationMaxLeadingChars
│ │ short ParaHyphenationMaxTrailingChars
│ │ [.beans.PropertyValue] ParaInteropGrabBag
│ │ boolean ParaIsAutoFirstLineIndent
│ │ boolean ParaIsConnectBorder
│ │ boolean ParaIsHyphenation
│ │ boolean ParaIsNumberingRestart
│ │ boolean ParaKeepTogether
│ │ short ParaLastLineAdjust
│ │ long ParaLeftMargin
│ │ boolean ParaLineNumberCount
│ │ long ParaLineNumberStartValue
│ │ .style.LineSpacing ParaLineSpacing
│ │ byte ParaOrphans
│ │ boolean ParaRegisterModeActive
│ │ long ParaRightMargin
│ │ .table.ShadowFormat ParaShadowFormat
│ │ boolean ParaSplit
│ │ string ParaStyleName
│ │ [.style.TabStop] ParaTabStops
│ │ long ParaTopMargin
│ │ .container.XNameContainer ParaUserDefinedAttributes
│ │ short ParaVertAlignment
│ │ byte ParaWidows
│ │ .table.BorderLine RightBorder
│ │ long RightBorderDistance
│ │ .table.BorderLine TopBorder
│ │ long TopBorderDistance
│ └─.table.CellRange
│ └─.table.CellProperties
│ │ boolean AsianVerticalMode
│ │ .table.BorderLine BottomBorder
│ │ .table.BorderLine2 BottomBorder2
│ │ .util.Color CellBackColor
│ │ [.beans.PropertyValue] CellInteropGrabBag
│ │ .util.CellProtection CellProtection
│ │ string CellStyle
│ │ &nbsnbsp; .table.BorderLine DiagonalBLTR
│ │ .table.BorderLine2 DiagonalBLTR2
│ │ .table.BorderLine DiagonalTLBR
│ │ .table.BorderLine2 DiagonalTLBR2
│ │ .table.CellHoriJustify HoriJustify
│ │ boolean IsCellBackgroundTransparent
│ │ boolean IsTextWrapped
│ │ .table.BorderLine LeftBorder
│ │ .table.BorderLine2 LeftBorder2
│ │ long NumberFormat
│ │ .table.CellOrientation Orientation
│ │ short ParaIndent
│ │ .table.BorderLine RightBorder
│ │ .table.BorderLine2 RightBorder2
│ │ long RotateAngle
│ │ long RotateReference
│ │ .table.ShadowFormat ShadowFormat
│ │ boolean ShrinkToFit
│ │ .table.TableBorder TableBorder
│ │ .table.TableBorder2 TableBorder2
│ │ .table.BorderLine TopBorder
│ │ .table.BorderLine2 TopBorder2
│ │ .container.XNameContainer UserDefinedAttributes
│ │ long VertJustify
│ └─.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)
├─.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)
├─.sheet.XArrayFormulaTokens
│ [.sheet.FormulaToken] getArrayTokens()
│ void setArrayTokens( [in] [.sheet.FormulaToken] aTokens)
└──(サービスやインターフェイスに属しないプロパティ)
short CharFont
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
boolean ChartColumnAsLabel
boolean ChartRowAsLabel
.sheet.XSheetConditionalEntries ConditionalFormatXML
unsigned hyper FormatID
long HoriJustifyMethod
.beans.XPropertySet ValidationXML
long VertJustifyMethod
object1だけがもつサービスとインターフェイス一覧
├─.sheet.SheetCell
│ │ string AbsoluteName
│ │ .sheet.XSheetConditionalEntries ConditionalFormat
│ │ .sheet.XSheetConditionalEntries ConditionalFormatLocal
│ │ string FormulaLocal
│ │ long FormulaResultType
│ │ .awt.Point Position
│ │ .awt.Size Size
│ │ .beans.XPropertySet Validation
│ │ .beans.XPropertySet ValidationLocal
│ ├─.document.XActionLockable
│ │ void addActionLock()
│ │ boolean isActionLocked()
│ │ void removeActionLock()
│ │ short resetActionLocks()
│ │ void setActionLocks( [in] short nLock)
│ ├─.sheet.XCellAddressable
│ │ .table.CellAddress getCellAddress()
│ ├─.sheet.XSheetAnnotationAnchor
│ │ .sheet.XSheetAnnotation getAnnotation()
│ ├─.text.XTextFieldsSupplier
│ │ .container.XNameAccess getTextFieldMasters()
│ │ .container.XEnumerationAccess getTextFields()
│ ├─.style.ParagraphPropertiesAsian
│ │ boolean ParaIsCharacterDistance
│ │ boolean ParaIsForbiddenRules
│ │ boolean ParaIsHangingPunctuation
│ ├─.style.ParagraphPropertiesComplex
│ │ short WritingMode
│ ├─.table.Cell
│ │ ├─.table.XCell
│ │ │ long getError()
│ │ │ string getFormula()
│ │ │ .table.CellContentType getType()
│ │ │ double getValue()
│ │ │ void setFormula( [in] string aFormula)
│ │ │ void setValue( [in] double nValue)
│ │ └─.text.XText
│ │ │ void insertTextContent( [in] .text.XTextRange xRange,
│ │ │ [in] .text.XTextContent xContent,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void removeTextContent( [in] .text.XTextContent xContent
│ │ │ ) raises ( .container.NoSuchElementException)
│ │ └─.text.XSimpleText
│ │ │ .text.XTextCursor createTextCursor()
│ │ │ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ │ │ void insertControlCharacter( [in] .text.XTextRange xRange,
│ │ │ [in] short nControlCharacter,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void insertString( [in] .text.XTextRange xRange,
│ │ │ [in] string aString,
│ │ │ [in] boolean bAbsorb)
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ └─.text.Text
│ │ .beans.PropertyValues EndRedline
│ │ .beans.PropertyValues StartRedline
│ ├─.container.XEnumerationAccess
│ │ │ .container.XEnumeration createEnumeration()
│ │ └─.container.XElementAccess
│ │ type getElementType()
│ │ boolean hasElements()
│ ├─.text.XRelativeTextContentInsert
│ │ void insertTextContentAfter( [in] .text.XTextContent xNewContent,
│ │ [in] .text.XTextContent xPredecessor
│ │ ) raises ( .lang.IllegalArgumentException)
│ │ void insertTextContentBefore( [in] .text.XTextContent xNewContent,
│ │ [in] .text.XTextContent xSuccessor
│ │ ) raises ( .lang.IllegalArgumentException)
│ ├─.text.XTextRangeCompare
│ │ short compareRegionEnds( [in] .text.XTextRange xR1,
│ │ [in] .text.XTextRange xR2
│ │ ) raises ( .lang.IllegalArgumentException)
│ │ short compareRegionStarts( [in] .text.XTextRange xR1,
│ │ [in] .text.XTextRange xR2
│ │ ) raises ( .lang.IllegalArgumentException)
│ └─.text.XTextRangeMover
│ void moveTextRange( [in] .text.XTextRange xRange,
│ [in] short nParagraphs)
├─.sheet.XFormulaTokens
│ [.sheet.FormulaToken] getTokens()
│ void setTokens( [in] [.sheet.FormulaToken] aTokens)
├─.table.XCell2
│ void setFormulaResult( [in] double nValue)
│ void setFormulaString( [in] string aFormula)
└──(サービスやインターフェイスに属しないプロパティ)
string Hyperlink
object2だけがもつサービスとインターフェイス一覧
└──(相手のサービスやインターフェイスに属しているプロパティにあるもの)
boolean ParaIsCharacterDistance
boolean ParaIsForbiddenRules
boolean ParaIsHangingPunctuation
short WritingMode
0 件のコメント:
コメントを投稿