前の関連記事:Calc(8)セル範囲のサービスとインターフェイス一覧
テキストカーサーのサービスとインターフェイス一覧
テキストカーサーはセルのcreateTextCursor()メソッドで取得して、セルの中の文字列を操作します。
セルの中の文字列の一部に書式設定をするときに使えそうです。
def macro(): ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。 smgr = ctx.getServiceManager() # サービスマネージャーの取得。 tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。 doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。 sheets = doc.getSheets() # シートの採集。 sheet = sheets[0] # 最初のシート。 cell = sheet[0, 0] # 行インデックス0、列インデックス0、のセル(つまりA1セル)。 textcursor = cell.createTextCursor() # A1セル内のテキストカーサー。 tcu.wtree(textcursor) # A1セル内のテキストカーサー。
├─.text.TextCursor
│ ├─.beans.XMultiPropertyStates
│ │ [any] getPropertyDefaults( [in] [string] aPropertyNames
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ void setAllPropertiesToDefault()
│ │ void setPropertiesToDefault( [in] [string] aPropertyNames
│ │ ) raises ( .beans.UnknownPropertyException)
│ ├─.beans.XPropertySet
│ │ void addPropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener xListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void addVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.XPropertySetInfo getPropertySetInfo()
│ │ any getPropertyValue( [in] string PropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removePropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removeVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void setPropertyValue( [in] string aPropertyName,
│ │ [in] any aValue
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .lang.IllegalArgumentException,
│ │ .beans.PropertyVetoException,
│ │ .beans.UnknownPropertyException)
│ ├─.beans.XPropertyState
│ │ any getPropertyDefault( [in] string aPropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.PropertyState getPropertyState( [in] string PropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ void setPropertyToDefault( [in] string PropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ ├─.document.XDocumentInsertable
│ │ void insertDocumentFromURL( [in] string aURL,
│ │ [in] [.beans.PropertyValue] aOptions
│ │ ) raises ( .io.IOException,
│ │ .lang.IllegalArgumentException)
│ ├─.text.XParagraphCursor
│ │ boolean gotoEndOfParagraph( [in] boolean bExpand)
│ │ boolean gotoNextParagraph( [in] boolean bExpand)
│ │ boolean gotoPreviousParagraph( [in] boolean bExpand)
│ │ boolean gotoStartOfParagraph( [in] boolean bExpand)
│ │ boolean isEndOfParagraph()
│ │ boolean isStartOfParagraph()
│ ├─.text.XSentenceCursor
│ │ boolean gotoEndOfSentence( [in] boolean Expand)
│ │ boolean gotoNextSentence( [in] boolean Expand)
│ │ boolean gotoPreviousSentence( [in] boolean Expand)
│ │ boolean gotoStartOfSentence( [in] boolean Expand)
│ │ boolean isEndOfSentence()
│ │ boolean isStartOfSentence()
│ ├─.text.XTextCursor
│ │ │ void collapseToEnd()
│ │ │ void collapseToStart()
│ │ │ boolean goLeft( [in] short nCount,
│ │ │ [in] boolean bExpand)
│ │ │ boolean goRight( [in] short nCount,
│ │ │ [in] boolean bExpand)
│ │ │ void gotoEnd( [in] boolean bExpand)
│ │ │ void gotoRange( [in] .text.XTextRange xRange,
│ │ │ [in] boolean bExpand)
│ │ │ void gotoStart( [in] boolean bExpand)
│ │ │ boolean isCollapsed()
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ ├─.text.XWordCursor
│ │ boolean gotoEndOfWord( [in] boolean bExpand)
│ │ boolean gotoNextWord( [in] boolean bExpand)
│ │ boolean gotoPreviousWord( [in] boolean bExpand)
│ │ boolean gotoStartOfWord( [in] boolean bExpand)
│ │ boolean isEndOfWord()
│ │ boolean isStartOfWord()
│ ├─.util.XSortable
│ │ [.beans.PropertyValue] createSortDescriptor()
│ │ void sort( [in] [.beans.PropertyValue] xDescriptor)
│ └─.text.TextRange
│ ├─.container.XContentEnumerationAccess
│ │ .container.XEnumeration createContentEnumeration( [in] string aServiceName)
│ │ [string] getAvailableServiceNames()
│ ├─.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
│ ├─.style.ParagraphPropertiesAsian
│ │ boolean ParaIsCharacterDistance
│ │ boolean ParaIsForbiddenRules
│ │ boolean ParaIsHangingPunctuation
│ └─.style.ParagraphPropertiesComplex
│ short WritingMode
├─.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)
├─.text.XTextRangeCompare
│ short compareRegionEnds( [in] .text.XTextRange xR1,
│ [in] .text.XTextRange xR2
│ ) raises ( .lang.IllegalArgumentException)
│ short compareRegionStarts( [in] .text.XTextRange xR1,
│ [in] .text.XTextRange xR2
│ ) raises ( .lang.IllegalArgumentException)
└──(サービスやインターフェイスに属しないプロパティ)
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
.awt.FontDescriptor FontDescriptor
.container.XNameContainer UserDefinedAttributes
│ ├─.beans.XMultiPropertyStates
│ │ [any] getPropertyDefaults( [in] [string] aPropertyNames
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ void setAllPropertiesToDefault()
│ │ void setPropertiesToDefault( [in] [string] aPropertyNames
│ │ ) raises ( .beans.UnknownPropertyException)
│ ├─.beans.XPropertySet
│ │ void addPropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener xListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void addVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.XPropertySetInfo getPropertySetInfo()
│ │ any getPropertyValue( [in] string PropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removePropertyChangeListener( [in] string aPropertyName,
│ │ [in] .beans.XPropertyChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void removeVetoableChangeListener( [in] string PropertyName,
│ │ [in] .beans.XVetoableChangeListener aListener
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ void setPropertyValue( [in] string aPropertyName,
│ │ [in] any aValue
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .lang.IllegalArgumentException,
│ │ .beans.PropertyVetoException,
│ │ .beans.UnknownPropertyException)
│ ├─.beans.XPropertyState
│ │ any getPropertyDefault( [in] string aPropertyName
│ │ ) raises ( .lang.WrappedTargetException,
│ │ .beans.UnknownPropertyException)
│ │ .beans.PropertyState getPropertyState( [in] string PropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ [.beans.PropertyState] getPropertyStates( [in] [string] aPropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ │ void setPropertyToDefault( [in] string PropertyName
│ │ ) raises ( .beans.UnknownPropertyException)
│ ├─.document.XDocumentInsertable
│ │ void insertDocumentFromURL( [in] string aURL,
│ │ [in] [.beans.PropertyValue] aOptions
│ │ ) raises ( .io.IOException,
│ │ .lang.IllegalArgumentException)
│ ├─.text.XParagraphCursor
│ │ boolean gotoEndOfParagraph( [in] boolean bExpand)
│ │ boolean gotoNextParagraph( [in] boolean bExpand)
│ │ boolean gotoPreviousParagraph( [in] boolean bExpand)
│ │ boolean gotoStartOfParagraph( [in] boolean bExpand)
│ │ boolean isEndOfParagraph()
│ │ boolean isStartOfParagraph()
│ ├─.text.XSentenceCursor
│ │ boolean gotoEndOfSentence( [in] boolean Expand)
│ │ boolean gotoNextSentence( [in] boolean Expand)
│ │ boolean gotoPreviousSentence( [in] boolean Expand)
│ │ boolean gotoStartOfSentence( [in] boolean Expand)
│ │ boolean isEndOfSentence()
│ │ boolean isStartOfSentence()
│ ├─.text.XTextCursor
│ │ │ void collapseToEnd()
│ │ │ void collapseToStart()
│ │ │ boolean goLeft( [in] short nCount,
│ │ │ [in] boolean bExpand)
│ │ │ boolean goRight( [in] short nCount,
│ │ │ [in] boolean bExpand)
│ │ │ void gotoEnd( [in] boolean bExpand)
│ │ │ void gotoRange( [in] .text.XTextRange xRange,
│ │ │ [in] boolean bExpand)
│ │ │ void gotoStart( [in] boolean bExpand)
│ │ │ boolean isCollapsed()
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ ├─.text.XWordCursor
│ │ boolean gotoEndOfWord( [in] boolean bExpand)
│ │ boolean gotoNextWord( [in] boolean bExpand)
│ │ boolean gotoPreviousWord( [in] boolean bExpand)
│ │ boolean gotoStartOfWord( [in] boolean bExpand)
│ │ boolean isEndOfWord()
│ │ boolean isStartOfWord()
│ ├─.util.XSortable
│ │ [.beans.PropertyValue] createSortDescriptor()
│ │ void sort( [in] [.beans.PropertyValue] xDescriptor)
│ └─.text.TextRange
│ ├─.container.XContentEnumerationAccess
│ │ .container.XEnumeration createContentEnumeration( [in] string aServiceName)
│ │ [string] getAvailableServiceNames()
│ ├─.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
│ ├─.style.ParagraphPropertiesAsian
│ │ boolean ParaIsCharacterDistance
│ │ boolean ParaIsForbiddenRules
│ │ boolean ParaIsHangingPunctuation
│ └─.style.ParagraphPropertiesComplex
│ short WritingMode
├─.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)
├─.text.XTextRangeCompare
│ short compareRegionEnds( [in] .text.XTextRange xR1,
│ [in] .text.XTextRange xR2
│ ) raises ( .lang.IllegalArgumentException)
│ short compareRegionStarts( [in] .text.XTextRange xR1,
│ [in] .text.XTextRange xR2
│ ) raises ( .lang.IllegalArgumentException)
└──(サービスやインターフェイスに属しないプロパティ)
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
.awt.FontDescriptor FontDescriptor
.container.XNameContainer UserDefinedAttributes
セルカーサーのサービスとインターフェイス一覧
セルカーサーはシートのcreateCursor()メソッドかcreateCursorByRange()メソッドで取得します。
def macro(): ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。 smgr = ctx.getServiceManager() # サービスマネージャーの取得。 tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。 doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。 sheets = doc.getSheets() # シートの採集。 sheet = sheets[0] # 最初のシート。 cellcursor = sheet.createCursor() # 最初のシートすべてのセルカーサー。 tcu.wtree(cellcursor) # 最初のシートすべてのセルカーサー。
├─.sheet.SheetCellCursor
│ ├─.sheet.XSheetCellCursor
│ │ │ void collapseToCurrentArray()
│ │ │ void collapseToCurrentRegion()
│ │ │ void collapseToMergedArea()
│ │ │ void collapseToSize( [in] long nColumns,
│ │ │ [in] long nRows)
│ │ │ void expandToEntireColumns()
│ │ │ void expandToEntireRows()
│ │ └─.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.XUsedAreaCursor
│ │ void gotoEndOfUsedArea( [in] boolean bExpand)
│ │ void gotoStartOfUsedArea( [in] boolean bExpand)
│ ├─.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.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)
│ └─.table.CellCursor
│ └─.table.XCellCursor
│ void gotoEnd()
│ void gotoNext()
│ void gotoOffset( [in] long nColumnOffset,
│ [in] long nRowOffset)
│ void gotoPrevious()
│ void gotoStart()
├─.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
│ ├─.sheet.XSheetCellCursor
│ │ │ void collapseToCurrentArray()
│ │ │ void collapseToCurrentRegion()
│ │ │ void collapseToMergedArea()
│ │ │ void collapseToSize( [in] long nColumns,
│ │ │ [in] long nRows)
│ │ │ void expandToEntireColumns()
│ │ │ void expandToEntireRows()
│ │ └─.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.XUsedAreaCursor
│ │ void gotoEndOfUsedArea( [in] boolean bExpand)
│ │ void gotoStartOfUsedArea( [in] boolean bExpand)
│ ├─.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.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)
│ └─.table.CellCursor
│ └─.table.XCellCursor
│ void gotoEnd()
│ void gotoNext()
│ void gotoOffset( [in] long nColumnOffset,
│ [in] long nRowOffset)
│ void gotoPrevious()
│ void gotoStart()
├─.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
0 件のコメント:
コメントを投稿