Calc(11)列のサービスとインターフェイス一覧

2017-10-11

旧ブログ

t f B! P L

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


列アクセスオブジェクトのサービスとインターフェイス一覧

def macro():
 ctx = XSCRIPTCONTEXT.getComponentContext()  # コンポーネントコンテクストの取得。
 smgr = ctx.getServiceManager()  # サービスマネージャーの取得。 
 tcu = smgr.createInstanceWithContext("pq.Tcu", ctx)  # サービス名か実装名でインスタンス化。
 doc = XSCRIPTCONTEXT.getDocument()  # Calcドキュメント。
 sheets = doc.getSheets()  # シートコレクション。
 sheet = sheets[0]  # 最初のシート。
 columns = sheet.getColumns()  # 列アクセスオブジェクト。
 tcu.wtree(columns)
プロパティのあるサービスがないのに、XPropertySetインターフェイスがありますが、そのメソッドで一括して列のプロパティが設定できるようになっていました。

├─.table.TableColumns
│   ├─.container.XEnumerationAccess
│   │   │   .container.XEnumeration  createEnumeration()
│   │   └─.container.XElementAccess
│   │           type  getElementType()
│   │        boolean  hasElements()
│   ├─.container.XNameAccess
│   │          any  getByName( [in] string aName
│   │               ) raises ( .lang.WrappedTargetException,
│   │                          .container.NoSuchElementException)
│   │     [string]  getElementNames()
│   │      boolean  hasByName( [in] string aName)
│   └─.table.XTableColumns
│     │   void  insertByIndex( [in] long nIndex,
│     │                        [in] long nCount)
│     │   void  removeByIndex( [in] long nIndex,
│     │                        [in] long nCount)
│     └─.container.XIndexAccess
│            any  getByIndex( [in] long Index
│                  ) raises ( .lang.WrappedTargetException,
│                             .lang.IndexOutOfBoundsException)
│           long  getCount()
├─.beans.XPropertySet
│                        void  addPropertyChangeListener( [in]                         string aPropertyName,
│                                                         [in] .beans.XPropertyChangeListener xListener
│                                              ) raises ( .lang.WrappedTargetException,
│                                                         .beans.UnknownPropertyException)
│                        void  addVetoableChangeListener( [in]                         string PropertyName,
│                                                         [in] .beans.XVetoableChangeListener aListener
│                                              ) raises ( .lang.WrappedTargetException,
│                                                         .beans.UnknownPropertyException)
│     .beans.XPropertySetInfo  getPropertySetInfo()
│                         any  getPropertyValue( [in] string PropertyName
│                                     ) raises ( .lang.WrappedTargetException,
│                                                .beans.UnknownPropertyException)
│                        void  removePropertyChangeListener( [in]                         string aPropertyName,
│                                                            [in] .beans.XPropertyChangeListener aListener
│                                                 ) raises ( .lang.WrappedTargetException,
│                                                            .beans.UnknownPropertyException)
│                        void  removeVetoableChangeListener( [in]                         string PropertyName,
│                                                            [in] .beans.XVetoableChangeListener aListener
│                                                 ) raises ( .lang.WrappedTargetException,
│                                                            .beans.UnknownPropertyException)
│                        void  setPropertyValue( [in] string aPropertyName,
│                                                [in]    any aValue
│                                     ) raises ( .lang.WrappedTargetException,
│                                                .lang.IllegalArgumentException,
│                                                .beans.PropertyVetoException,
│                                                .beans.UnknownPropertyException)
└──(サービスやインターフェイスに属しないプロパティ)
           boolean  IsManualPageBreak
           boolean  IsStartOfNewPage
           boolean  IsVisible
           boolean  OptimalWidth
              long  Width

列のサービスとインターフェイス一覧

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

次の関連記事:Calc(12)CalcドキュメントとWriterドキュメントとのサービスとインターフェイスの比較

ブログ検索 by Blogger

Translate

最近のコメント

Created by Calendar Gadget

QooQ