Calc(8)セル範囲のサービスとインターフェイス一覧

2017-10-10

旧ブログ

t f B! P L

前の関連記事:Calc(7)セルのサービスとインターフェイス一覧


セル範囲のサービスとインターフェイス一覧

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と同じ)のセル範囲。 
 tcu.wtree(cells)  # D3:F5のセル範囲。

├─.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
│        │           .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
                             boolean  ParaIsCharacterDistance
                             boolean  ParaIsForbiddenRules
                             boolean  ParaIsHangingPunctuation
                 .beans.XPropertySet  ValidationXML
                                long  VertJustifyMethod
                               short  WritingMode

XCellRangesQueryインターフェイスのメソッドは値の入っている最後の行をみつけるときなどに便利です(Calc(24)セルカーサーでセル範囲を変更する)。

結合したセルはgetIsMerged()で結合セルかどうか判断できます。

それに対して結合されたセルの場合は、セルに内容が入っていても表示されていないのですが、queryVisibleCells()メソッドでは表示されているセルとして取得できました。

セルが結合されているかどうかマクロから判断する方法はわかりませんでした。

次の関連記事:Calc(9)テキストカーサーとセルカーサーのサービスとインターフェイス一覧

ブログ検索 by Blogger

Translate

最近のコメント

Created by Calendar Gadget

QooQ