Calc(14)セルとシートとのサービスとインターフェイスの比較

2017-10-13

旧ブログ

t f B! P L

前の関連記事:Calc(13)セルとセル範囲とのサービスとインターフェイスの比較


セルをシートと比較したサービスとインターフェイス一覧

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セル)。
 tcu.wcompare(cell, sheet)
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
                                      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
│   │  &nbsnbsp;                      .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)
└──(サービスやインターフェイスに属しないプロパティ)
           unsigned hyper  FormatID
                   string  Hyperlink

object2だけがもつサービスとインターフェイス一覧
├─.document.LinkTarget
│   │   string  LinkDisplayName
│   └─.document.XLinkTargetSupplier
│        .container.XNameAccess  getLinks()
├─.sheet.Spreadsheet
│   │                      boolean  AutomaticPrintArea
│   │   .sheet.XConditionalFormats  ConditionalFormats
│   │                      boolean  IsVisible
│   │                       string  PageStyle
│   │                  .util.Color  TabColor
│   │                        short  TableLayout
│   ├─.container.XNamed
│   │     string  getName()
│   │       void  setName( [in] string aName)
│   ├─.drawing.XDrawPageSupplier
│   │     .drawing.XDrawPage  getDrawPage()
│   ├─.sheet.XCellRangeMovement
│   │     void  copyRange( [in]      .table.CellAddress aDestination,
│   │                      [in] .table.CellRangeAddress aSource)
│   │     void  insertCells( [in] .table.CellRangeAddress aRange,
│   │                        [in]   .sheet.CellInsertMode nMode)
│   │     void  moveRange( [in]      .table.CellAddress aDestination,
│   │                      [in] .table.CellRangeAddress aSource)
│   │     void  removeRange( [in] .table.CellRangeAddress aRange,
│   │                        [in]   .sheet.CellDeleteMode nMode)
│   ├─.sheet.XDataPilotTablesSupplier
│   │     .sheet.XDataPilotTables  getDataPilotTables()
│   ├─.sheet.XExternalSheetName
│   │     void  setExternalName( [in] string aUrl,
│   │                            [in] string aSheetName
│   │                 ) raises ( .container.ElementExistException)
│   ├─.sheet.XPrintAreas
│   │     [.table.CellRangeAddress]  getPrintAreas()
│   │                       boolean  getPrintTitleColumns()
│   │                       boolean  getPrintTitleRows()
│   │       .table.CellRangeAddress  getTitleColumns()
│   │       .table.CellRangeAddress  getTitleRows()
│   │                          void  setPrintAreas( [in] [.table.CellRangeAddress] aPrintAreas)
│   │                          void  setPrintTitleColumns( [in] boolean bPrintTitleColumns)
│   │                          void  setPrintTitleRows( [in] boolean bPrintTitleRows)
│   │                          void  setTitleColumns( [in] .table.CellRangeAddress aTitleColumns)
│   │                          void  setTitleRows( [in] .table.CellRangeAddress aTitleRows)
│   ├─.sheet.XScenariosSupplier
│   │     .sheet.XScenarios  getScenarios()
│   ├─.sheet.XSheetAnnotationsSupplier
│   │     .sheet.XSheetAnnotations  getAnnotations()
│   ├─.sheet.XSheetAuditing
│   │        void  clearArrows()
│   │     boolean  hideDependents( [in] .table.CellAddress aPosition)
│   │     boolean  hidePrecedents( [in] .table.CellAddress aPosition)
│   │     boolean  showDependents( [in] .table.CellAddress aPosition)
│   │     boolean  showErrors( [in] .table.CellAddress aPosition)
│   │     boolean  showInvalid()
│   │     boolean  showPrecedents( [in] .table.CellAddress aPosition)
│   ├─.sheet.XSheetLinkable
│   │     .sheet.SheetLinkMode  getLinkMode()
│   │                   string  getLinkSheetName()
│   │                   string  getLinkUrl()
│   │                     void  link( [in]               string aUrl,
│   │                                 [in]               string aSheetName,
│   │                                 [in]               string aFilterName,
│   │                                 [in]               string aFilterOptions,
│   │                                 [in] .sheet.SheetLinkMode nMode)
│   │                     void  setLinkMode( [in] .sheet.SheetLinkMode nLinkMode)
│   │                     void  setLinkSheetName( [in] string aLinkSheetName)
│   │                     void  setLinkUrl( [in] string aLinkUrl)
│   ├─.sheet.XSheetOutline
│   │     void  autoOutline( [in] .table.CellRangeAddress aRange)
│   │     void  clearOutline()
│   │     void  group( [in] .table.CellRangeAddress aRange,
│   │                  [in] .table.TableOrientation nOrientation)
│   │     void  hideDetail( [in] .table.CellRangeAddress aRange)
│   │     void  showDetail( [in] .table.CellRangeAddress aRange)
│   │     void  showLevel( [in]                   short nLevel,
│   │                      [in] .table.TableOrientation nOrientation)
│   │     void  ungroup( [in] .table.CellRangeAddress aRange,
│   │                    [in] .table.TableOrientation nOrientation)
│   ├─.sheet.XSheetPageBreak
│   │     [.sheet.TablePageBreakData]  getColumnPageBreaks()
│   │     [.sheet.TablePageBreakData]  getRowPageBreaks()
│   │                            void  removeAllManualPageBreaks()
│   ├─.sheet.XSpreadsheet
│   │     .sheet.XSheetCellCursor  createCursor()
│   │     .sheet.XSheetCellCursor  createCursorByRange( [in] .sheet.XSheetCellRange aRange)
│   ├─.table.XTableChartsSupplier
│   │     .table.XTableCharts  getCharts()
│   ├─.util.XProtectable
│   │     boolean  isProtected()
│   │        void  protect( [in] string aPassword)
│   │        void  unprotect( [in] string aPassword
│   │              ) raises ( .lang.IllegalArgumentException)
│   └─.sheet.Scenario
│     │      long  BorderColor
│     │   boolean  CopyBack
│     │   boolean  CopyFormulas
│     │   boolean  CopyStyles
│     │   boolean  IsActive
│     │   boolean  PrintBorder
│     │   boolean  Protected
│     │   boolean  ShowBorder
│     ├─.sheet.XScenario
│     │        void  addRanges( [in] [.table.CellRangeAddress] aRanges)
│     │        void  apply()
│     │     boolean  getIsScenario()
│     │      string  getScenarioComment()
│     │        void  setScenarioComment( [in] string aScenarioComment)
│     └─.sheet.XScenarioEnhanced
│           [.table.CellRangeAddress]  getRanges()
├─.document.XEventsSupplier
│     .container.XNameReplace  getEvents()
├─.table.XTablePivotChartsSupplier
│     .table.XTablePivotCharts  getPivotCharts()
└──(サービスやインターフェイスに属しないプロパティ)
                        string  CodeName
                  .awt.XBitmap  LinkDisplayBitmap
           .sheet.XNamedRanges  NamedRanges
     (相手のサービスやインターフェイスに属しているプロパティにあるもの)
           boolean  ParaIsCharacterDistance
           boolean  ParaIsForbiddenRules
           boolean  ParaIsHangingPunctuation
             short  WritingMode

次の関連記事:Calc(15)セル範囲とセルカーサーとのサービスとインターフェイスの比較

ブログ検索 by Blogger

Translate

最近のコメント

Created by Calendar Gadget

QooQ