Calc(17)セル範囲と行とのサービスとインターフェイスの比較

def macro():
 ctx = XSCRIPTCONTEXT.getComponentContext()  # コンポーネントコンテクストの取得。
 smgr = ctx.getServiceManager()  # サービスマネージャーの取得。 
 tcu = smgr.createInstanceWithContext("pq.Tcu", ctx)  # サービス名か実装名でインスタンス化。
 doc = XSCRIPTCONTEXT.getDocument()  # Calcドキュメント。
 sheets = doc.getSheets()  # シートコレクション。
 sheet = sheets[0]  # 最初のシート。
 cells = sheet[2:5, 3:6]  # 行インデックス2以上5未満、列インデックス3以上6未満(つまりD3:F5と同じ)のセル範囲。 
 rows = sheet.getRows()  # 行アクセスオブジェクト。
 row = rows[0]  # 1行目。
 tcu.wcompare(cells, row)

object1とobject2に共通するサービスとインターフェイス一覧
├─.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.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.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()
│   └─.table.XCellRange
│             .table.XCell  getCellByPosition( [in] long nColumn,
│                   nbsp;                           [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)
└──(サービスやインターフェイスに属しないプロパティ)
                                     short  CharFont
                                     short  CharOverline
                                      long  CharOverlineColor
                                   boolean  CharOverlineHasColor
                                   boolean  ChartColumnAsLabel
                                   boolean  ChartRowAsLabel
           .sheet.XSheetConditionalEntries  ConditionalFormatXML
                                      long  HoriJustifyMethod
                                   boolean  ParaIsCharacterDistance
                                   boolean  ParaIsForbiddenRules
                                   boolean  ParaIsHangingPunctuation
                       .beans.XPropertySet  ValidationXML
                                      long  VertJustifyMethod
                                     short  WritingMode

object1だけがもつサービスとインターフェイス一覧
├─.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)
│   ├─.sheet.SheetRangesQuery
│   ├─.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  nbsp;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
│                   .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
└──(サービスやインターフェイスに属しないプロパティ)
           unsigned hyper  FormatID

object2だけがもつサービスとインターフェイス一覧
├─.table.TableRow
│        long  Height
│     boolean  IsStartOfNewPage
│     boolean  IsVisible
│     boolean  OptimalHeight
└──(サービスやインターフェイスに属しないプロパティ)
           boolean  IsFiltered
           boolean  IsManualPageBreak
     (相手のサービスやインターフェイスに属しているプロパティにあるもの)
                                    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  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
                            .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
           .sheet.XSheetConditionalEntries  ConditionalFormat
           .sheet.XSheetConditionalEntries  ConditionalFormatLocal
                         .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
                  .container.XIndexReplace  NumberingRules
                    .table.CellOrientation  Orientation
                                     short  ParaAdjust
                                      long  ParaBottomMargin
                                     short  ParaIndent
                                   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
                                      long  VertJustify