Calc(18)ドキュメントとシートとのサービスとインターフェイスの比較

2017-10-13

旧ブログ

t f B! P L

前の関連記事: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]  # 最初のシート。
 tcu.wcompare(doc, sheet)
object1はドキュメント、object2はシートを指します。

object1とobject2に共通するサービスとインターフェイス一覧
├─.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)
├─.document.XEventsSupplier
│     .container.XNameReplace  getEvents()
├─.document.XLinkTargetSupplier
│     .container.XNameAccess  getLinks()
├─.util.XModifyBroadcaster
│     void  addModifyListener( [in] .util.XModifyListener aListener)
│     void  removeModifyListener( [in] .util.XModifyListener aListener)
├─.util.XProtectable
│     boolean  isProtected()
│        void  protect( [in] string aPassword)
│        void  unprotect( [in] string aPassword
│              ) raises ( .lang.IllegalArgumentException)
└──(サービスやインターフェイスに属しないプロパティ)
           string  CodeName

object1だけがもつサービスとインターフェイス一覧
├─.sheet.SpreadsheetDocument
│   │        .sheet.XAreaLinks  AreaLinks
│   │      .sheet.XLabelRanges  ColumnLabelRanges
│   │   .container.XNameAccess  DDELinks
│   │   .sheet.XDatabaseRanges  DatabaseRanges
│   │      .sheet.XNamedRanges  NamedRanges
│   │      .sheet.XLabelRanges  RowLabelRanges
│   │   .container.XNameAccess  SheetLinks
│   ├─.document.XActionLockable
│   │        void  addActionLock()
│   │     boolean  isActionLocked()
│   │        void  removeActionLock()
│   │       short  resetActionLocks()
│   │        void  setActionLocks( [in] short nLock)
│   ├─.drawing.XDrawPagesSupplier
│   │     .drawing.XDrawPages  getDrawPages()
│   ├─.frame.XModel
│   │   │                  boolean  attachResource( [in]                 string URL,
│   │   │                                           [in] [.beans.PropertyValue] Arguments)
│   │   │                     void  connectController( [in] .frame.XController Controller)
│   │   │                     void  disconnectController( [in] .frame.XController Controller)
│   │   │   [.beans.PropertyValue]  getArgs()
│   │   │       .frame.XController  getCurrentController()
│   │   │          .uno.XInterface  getCurrentSelection()
│   │   │                   string  getURL()
│   │   │                  boolean  hasControllersLocked()
│   │   │                     void  lockControllers()
│   │   │                     void  setCurrentController( [in] .frame.XController Controller
│   │   │                                      ) raises ( .container.NoSuchElementException)
│   │   │                     void  unlockControllers()
│   │   └─.lang.XComponent
│   │        void  addEventListener( [in] .lang.XEventListener xListener)
│   │        void  dispose()
│   │        void  removeEventListener( [in] .lang.XEventListener aListener)
│   ├─.lang.XMultiServiceFactory
│   │     .uno.XInterface  createInstance( [in] string aServiceSpecifier
│   │                           ) raises ( .uno.Exception)
│   │     .uno.XInterface  createInstanceWithArguments( [in] string ServiceSpecifier,
│   │                                                   [in]  [any] Arguments
│   │                                        ) raises ( .uno.Exception)
│   │            [string]  getAvailableServiceNames()
│   ├─.sheet.XCalculatable
│   │        void  calculate()
│   │        void  calculateAll()
│   │        void  enableAutomaticCalculation( [in] boolean bEnabled)
│   │     boolean  isAutomaticCalculationEnabled()
│   ├─.sheet.XConsolidatable
│   │                                void  consolidate( [in] .sheet.XConsolidationDescriptor xDescriptor)
│   │     .sheet.XConsolidationDescriptor  createConsolidationDescriptor( [in] boolean bEmpty)
│   ├─.sheet.XDocumentAuditing
│   │     void  refreshArrows()
│   ├─.sheet.XGoalSeek
│   │     .sheet.GoalResult  seekGoal( [in] .table.CellAddress aFormulaPosition,
│   │                                  [in] .table.CellAddress aVariablePosition,
│   │                                  [in]             string aGoalValue)
│   ├─.sheet.XSpreadsheetDocument
│   │     .sheet.XSpreadsheets  getSheets()
│   ├─.style.XStyleFamiliesSupplier
│   │     .container.XNameAccess  getStyleFamilies()
│   ├─.util.XNumberFormatsSupplier
│   │      .beans.XPropertySet  getNumberFormatSettings()
│   │     .util.XNumberFormats  getNumberFormats()
│   ├─.document.OfficeDocument
│   │   │                  boolean  ApplyFormDesignMode
│   │   │                  boolean  AutomaticControlFocus
│   │   │   [.beans.PropertyValue]  InteropGrabBag
│   │   │                   string  RuntimeUID
│   │   ├─.document.XDocumentEventBroadcaster
│   │   │     void  addDocumentEventListener( [in] .document.XDocumentEventListener Listener)
│   │   │     void  notifyDocumentEvent( [in]              string EventName,
│   │   │                                [in] .frame.XController2 ViewController,
│   │   │                                [in]                 any Supplement
│   │   │                     ) raises ( .lang.NoSupportException,
│   │   │                                .lang.IllegalArgumentException)
│   │   │     void  removeDocumentEventListener( [in] .document.XDocumentEventListener Listener)
│   │   ├─.document.XDocumentPropertiesSupplier
│   │   │     .document.XDocumentProperties  getDocumentProperties()
│   │   ├─.document.XEmbeddedScripts
│   │   │                                   boolean  AllowMacroExecution
│   │   │     .script.XStorageBasedLibraryContainer  BasicLibraries
│   │   │     .script.XStorageBasedLibraryContainer  DialogLibraries
│   │   ├─.document.XEventBroadcaster
│   │   │     void  addEventListener( [in] .document.XEventListener Listener)
│   │   │     void  removeEventListener( [in] .document.XEventListener Listener)
│   │   ├─.document.XUndoManagerSupplier
│   │   │     .document.XUndoManager  getUndoManager()
│   │   ├─.document.XViewDataSupplier
│   │   │     .container.XIndexAccess  getViewData()
│   │   │                        void  setViewData( [in] .container.XIndexAccess Data)
│   │   ├─.frame.XStorable
│   │   │      string  getLocation()
│   │   │     boolean  hasLocation()
│   │   │     boolean  isReadonly()
│   │   │        void  store()
│   │   │        void  storeAsURL( [in]                 string sURL,
│   │   │                          [in] [.beans.PropertyValue] lArguments
│   │   │               ) raises ( .io.IOException)
│   │   │        void  storeToURL( [in]                 string sURL,
│   │   │                          [in] [.beans.PropertyValue] lArguments
│   │   │               ) raises ( .io.IOException)
│   │   ├─.util.XModifiable
│   │   │     boolean  isModified()
│   │   │        void  setModified( [in] boolean bModified
│   │   │                ) raises ( .beans.PropertyVetoException)
│   │   ├─.view.XPrintJobBroadcaster
│   │   │     void  addPrintJobListener( [in] .view.XPrintJobListener xListener)
│   │   │     void  removePrintJobListener( [in] .view.XPrintJobListener xListener)
│   │   └─.view.XPrintable
│   │        [.beans.PropertyValue]  getPrinter()
│   │                          void  print( [in] [.beans.PropertyValue] xOptions
│   │                            ) raises ( .lang.IllegalArgumentException)
│   │                          void  setPrinter( [in] [.beans.PropertyValue] aPrinter
│   │                                 ) raises ( .lang.IllegalArgumentException)
│   └─.sheet.SpreadsheetDocumentSettings
│                           boolean  CalcAsShown
│                      .lang.Locale  CharLocale
│                      .lang.Locale  CharLocaleAsian
│                      .lang.Locale  CharLocaleComplex
│                             short  DefaultTabStop
│        .i18n.XForbiddenCharacters  ForbiddenCharacters
│                           boolean  HasDrawPages
│                           boolean  IgnoreCase
│                           boolean  IsAdjustHeightEnabled
│                           boolean  IsExecuteLinkEnabled
│                           boolean  IsIterationEnabled
│                           boolean  IsLoaded
│                           boolean  IsRecordChangesProtected
│                           boolean  IsUndoEnabled
│                              long  IterationCount
│                            double  IterationEpsilon
│                           boolean  LookUpLabels
│                           boolean  MatchWholeCell
│                        .util.Date  NullDate
│                           boolean  RecordChanges
│                      .awt.XDevice  ReferenceDevice
│                           boolean  RegularExpressions
│                           boolean  SpellOnline
│                             short  StandardDecimals
│                           boolean  Wildcards
├─.container.XChild
│     .uno.XInterface  getParent()
│                void  setParent( [in] .uno.XInterface Parent
│                      ) raises ( .lang.NoSupportException)
├─.datatransfer.XTransferable
│                            any  getTransferData( [in] .datatransfer.DataFlavor aFlavor
│                                       ) raises ( .io.IOException,
│                                                  .datatransfer.UnsupportedFlavorException)
│     [.datatransfer.DataFlavor]  getTransferDataFlavors()
│                        boolean  isDataFlavorSupported( [in] .datatransfer.DataFlavor aFlavor)
├─.document.XCmisDocument
│     [.document.CmisProperty]  CmisProperties
│                      boolean  canCancelCheckOut()
│                      boolean  canCheckIn()
│                      boolean  canCheckOut()
│                         void  cancelCheckOut()
│                         void  checkIn( [in] boolean isMajor,
│                                        [in]  string comment)
│                         void  checkOut()
│      [.document.CmisVersion]  getAllVersions()
│                      boolean  isVersionable()
│                         void  updateCmisProperties( [in] [.document.CmisProperty] cmisProperties)
├─.document.XDocumentRecovery
│        void  recoverFromFile( [in]                 string SourceLocation,
│                               [in]                 string SalvagedFile,
│                               [in] [.beans.PropertyValue] MediaDescriptor
│                    ) raises ( .lang.WrappedTargetException,
│                               .io.IOException)
│        void  storeToRecoveryFile( [in]                 string TargetLocation,
│                                   [in] [.beans.PropertyValue] MediaDescriptor
│                        ) raises ( .lang.WrappedTargetException,
│                                   .io.IOException)
│     boolean  wasModifiedSinceLastSave()
├─.document.XDocumentSubStorageSupplier
│     .embed.XStorage  getDocumentSubStorage( [in] string StorageName,
│                                             [in]   long nMode)
│            [string]  getDocumentSubStoragesNames()
├─.document.XScriptInvocationContext
│     .document.XEmbeddedScripts  ScriptContainer
├─.document.XStorageBasedDocument
│                void  addStorageChangeListener( [in] .document.XStorageChangeListener xListener)
│     .embed.XStorage  getDocumentStorage()
│                void  loadFromStorage( [in]        .embed.XStorage xStorage,
│                                       [in] [.beans.PropertyValue] aMediaDescriptor
│                            ) raises ( .uno.Exception,
│                                       .io.IOException,
│                                       .frame.DoubleInitializationException,
│                                       .lang.IllegalArgumentException)
│                void  removeStorageChangeListener( [in] .document.XStorageChangeListener xListener)
│                void  storeToStorage( [in]        .embed.XStorage xStorage,
│                                      [in] [.beans.PropertyValue] aMediaDescriptor
│                           ) raises ( .uno.Exception,
│                                      .io.IOException,
│                                      .lang.IllegalArgumentException)
│                void  switchToStorage( [in] .embed.XStorage xStorage
│                            ) raises ( .uno.Exception,
│                                       .io.IOException,
│                                       .lang.IllegalArgumentException)
├─.embed.XVisualObject
│                            long  getMapUnit( [in] hyper nAspect
│                                   ) raises ( .uno.Exception)
│     .embed.VisualRepresentation  getPreferredVisualRepresentation( [in] hyper nAspect
│                                                         ) raises ( .uno.Exception,
│                                                                    .embed.WrongStateException,
│                                                                    .lang.IllegalArgumentException)
│                       .awt.Size  getVisualAreaSize( [in] hyper nAspect
│                                          ) raises ( .uno.Exception,
│                                                     .embed.WrongStateException,
│                                                     .lang.IllegalArgumentException)
│                            void  setVisualAreaSize( [in]     hyper nAspect,
│                                                     [in] .awt.Size aSize
│                                          ) raises ( .uno.Exception,
│                                                     .embed.WrongStateException,
│                                                     .lang.IllegalArgumentException)
├─.frame.XLoadable
│     void  initNew()
│     void  load( [in] [.beans.PropertyValue] lArguments
│      ) raises ( .uno.Exception,
│                 .io.IOException,
│                 .frame.DoubleInitializationException)
├─.frame.XModel2
│         .frame.XController2  createDefaultViewController( [in] .frame.XFrame Frame
│                                                ) raises ( .uno.Exception,
│                                                           .lang.IllegalArgumentException)
│         .frame.XController2  createViewController( [in]                 string ViewName,
│                                                    [in] [.beans.PropertyValue] Arguments,
│                                                    [in]          .frame.XFrame Frame
│                                         ) raises ( .uno.Exception,
│                                                    .lang.IllegalArgumentException)
│                    [string]  getAvailableViewControllerNames()
│     .container.XEnumeration  getControllers()
├─.frame.XModule
│     string  getIdentifier()
│       void  setIdentifier( [in] string Identifier)
├─.frame.XStorable2
│     void  storeSelf( [in] [.beans.PropertyValue] lArguments
│           ) raises ( .io.IOException,
│                      .lang.IllegalArgumentException)
├─.frame.XTitle
│     string  getTitle()
│       void  setTitle( [in] string sTitle)
├─.frame.XTitleChangeBroadcaster
│     void  addTitleChangeListener( [in] .frame.XTitleChangeListener xListener)
│     void  removeTitleChangeListener( [in] .frame.XTitleChangeListener xListener)
├─.frame.XUntitledNumbers
│     string  getUntitledPrefix()
│       long  leaseNumber( [in] .uno.XInterface xComponent
│               ) raises ( .lang.IllegalArgumentException)
│       void  releaseNumber( [in] long nNumber
│                 ) raises ( .lang.IllegalArgumentException)
│       void  releaseNumberForComponent( [in] .uno.XInterface xComponent
│                             ) raises ( .lang.IllegalArgumentException)
├─.rdf.XDocumentMetadataAccess
│   │                void  addContentOrStylesFile( [in] string FileName
│   │                                   ) raises ( .container.ElementExistException,
│   │                                              .lang.IllegalArgumentException)
│   │           .rdf.XURI  addMetadataFile( [in]      string FileName,
│   │                                       [in] [.rdf.XURI] Types
│   │                            ) raises ( .container.ElementExistException,
│   │                                       .lang.IllegalArgumentException)
│   │   .rdf.XMetadatable  getElementByMetadataReference( [in] .beans.StringPair MetadataReference)
│   │   .rdf.XMetadatable  getElementByURI( [in] .rdf.XURI URI
│   │                            ) raises ( .lang.IllegalArgumentException)
│   │         [.rdf.XURI]  getMetadataGraphsWithType( [in] .rdf.XURI Type
│   │                                      ) raises ( .lang.IllegalArgumentException)
│   │           .rdf.XURI  importMetadataFile( [in]            short Format,
│   │                                          [in] .io.XInputStream InStream,
│   │                                          [in]           string FileName,
│   │                                          [in]        .rdf.XURI BaseURI,
│   │                                          [in]      [.rdf.XURI] Types
│   │                               ) raises ( .io.IOException,
│   │                                          .rdf.ParseException,
│   │                                          .container.ElementExistException,
│   │                                          .datatransfer.UnsupportedFlavorException,
│   │                                          .lang.IllegalArgumentException)
│   │                void  loadMetadataFromMedium( [in] [.beans.PropertyValue] Medium
│   │                                   ) raises ( .lang.WrappedTargetException,
│   │                                              .lang.IllegalArgumentException)
│   │                void  loadMetadataFromStorage( [in]           .embed.XStorage Storage,
│   │                                               [in]                 .rdf.XURI BaseURI,
│   │                                               [in] .task.XInteractionHandler InteractionHandler
│   │                                    ) raises ( .lang.WrappedTargetException,
│   │                                               .lang.IllegalArgumentException)
│   │                void  removeContentOrStylesFile( [in] string FileName
│   │                                      ) raises ( .container.NoSuchElementException,
│   │                                                 .lang.IllegalArgumentException)
│   │                void  removeMetadataFile( [in] .rdf.XURI GraphName
│   │                               ) raises ( .container.NoSuchElementException,
│   │                                          .lang.IllegalArgumentException)
│   │                void  storeMetadataToMedium( [in] [.beans.PropertyValue] Medium
│   │                                  ) raises ( .lang.WrappedTargetException,
│   │                                             .lang.IllegalArgumentException)
│   │                void  storeMetadataToStorage( [in] .embed.XStorage Storage
│   │                                   ) raises ( .lang.WrappedTargetException,
│   │                                              .lang.IllegalArgumentException)
│   ├─.rdf.XRepositorySupplier
│   │     .rdf.XRepository  getRDFRepository()
│   └─.rdf.XURI
│     │   string  LocalName
│     │   string  Namespace
│     └─.rdf.XResource
│        └─.rdf.XNode
│              string  StringValue
├─.script.XStarBasicAccess
│                          void  addDialog( [in] string LibraryName,
│                                           [in] string DialogName,
│                                           [in] [byte] Data
│                                ) raises ( .container.NoSuchElementException)
│                          void  addModule( [in] string LibraryName,
│                                           [in] string ModuleName,
│                                           [in] string Language,
│                                           [in] string Source
│                                ) raises ( .container.NoSuchElementException)
│                          void  createLibrary( [in] string LibName,
│                                               [in] string Password,
│                                               [in] string ExternalSourceURL,
│                                               [in] string LinkTargetURL
│                                    ) raises ( .container.ElementExistException)
│     .container.XNameContainer  getLibraryContainer()
├─.script.provider.XScriptProviderSupplier
│     .script.provider.XScriptProvider  getScriptProvider()
├─.sheet.opencl.XOpenCLSelection
│                               void  disableAutomaticDeviceSelection()
│                               void  disableOpcodeSubsetTest()
│                               void  enableAutomaticDeviceSelection( [in] boolean force)
│                               void  enableOpcodeSubsetTest()
│                               void  enableOpenCL( [in] boolean enable)
│                               long  getDeviceID()
│                               long  getFormulaCellNumberLimit()
│     [.sheet.opencl.OpenCLPlatform]  getOpenCLPlatforms()
│                               long  getPlatformID()
│                            boolean  isOpcodeSubsetTested()
│                            boolean  isOpenCLEnabled()
│                               void  selectOpenCLDevice( [in] long platform,
│                                                         [in] long device)
│                               void  setFormulaCellNumberLimit( [in] long number)
├─.ui.XUIConfigurationManagerSupplier
│     .ui.XUIConfigurationManager  getUIConfigurationManager()
├─.util.XChangesNotifier
│     void  addChangesListener( [in] .util.XChangesListener aListener)
│     void  removeChangesListener( [in] .util.XChangesListener aListener)
├─.util.XCloseable
│   │   void  close( [in] boolean DeliverOwnership
│   │     ) raises ( .util.CloseVetoException)
│   └─.util.XCloseBroadcaster
│        void  addCloseListener( [in] .util.XCloseListener Listener)
│        void  removeCloseListener( [in] .util.XCloseListener Listener)
├─.util.XModifiable2
│     boolean  disableSetModified()
│     boolean  enableSetModified()
│     boolean  isSetModifiedEnabled()
├─.view.XRenderable
│     [.beans.PropertyValue]  getRenderer( [in]                   long nRenderer,
│                                          [in]                    any aSelection,
│                                          [in] [.beans.PropertyValue] xOptions
│                               ) raises ( .lang.IllegalArgumentException)
│                       long  getRendererCount( [in]                    any aSelection,
│                                               [in] [.beans.PropertyValue] xOptions
│                                    ) raises ( .lang.IllegalArgumentException)
│                       void  render( [in]                   long nRenderer,
│                                     [in]                    any aSelection,
│                                     [in] [.beans.PropertyValue] xOptions
│                          ) raises ( .lang.IllegalArgumentException)
└──(サービスやインターフェイスに属しないプロパティ)
                             string  BuildId
           .sheet.XExternalDocLinks  ExternalDocLinks
                            boolean  HasValidSignatures
                            boolean  IsChangeReadOnlyEnabled
                             string  VBAGlobalConstantName

object2だけがもつサービスとインターフェイス一覧
├─.document.LinkTarget
│     string  LinkDisplayName
├─.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)
│   │   └─.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)
│   ├─.table.XTableChartsSupplier
│   │     .table.XTableCharts  getCharts()
│   ├─.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()
│   └─.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.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.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.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)
├─.table.XTablePivotChartsSupplier
│     .table.XTablePivotCharts  getPivotCharts()
└──(サービスやインターフェイスに属しないプロパティ)
                                     short  CharFont
                                     short  CharOverline
                                      long  CharOverlineColor
                                   boolean  CharOverlineHasColor
                                   boolean  ChartColumnAsLabel
                                   boolean  ChartRowAsLabel
           .sheet.XSheetConditionalEntries  ConditionalFormatXML
                                      long  HoriJustifyMethod
                              .awt.XBitmap  LinkDisplayBitmap
                                   boolean  ParaIsCharacterDistance
                                   boolean  ParaIsForbiddenRules
                                   boolean  ParaIsHangingPunctuation
                       .beans.XPropertySet  ValidationXML
                                      long  VertJustifyMethod
                                     short  WritingMode
     (相手のサービスやインターフェイスに属しているプロパティにあるもの)
           .sheet.XNamedRanges  NamedRanges

次の関連記事:Calc(19)Calcコントローラーのサービスとインターフェイス一覧

ブログ検索 by Blogger

Translate

最近のコメント

Created by Calendar Gadget

QooQ