前の関連記事：Calc(41)UIComponentのサービスとインターフェイス一覧
コメントコレクションのサービスとインターフェイスの一覧
シートからそのシートにあるすべてのコメントが取得できます。
コメントの新規挿入はコメントコレクションの insertNew()メソッドで行わないといけません。
コメントの新規挿入はコメントコレクションの insertNew()メソッドで行わないといけません。
def macro():
ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。
smgr = ctx.getServiceManager() # サービスマネージャーの取得。
tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。
doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。
controller = doc.getCurrentController() # コントローラの取得。
sheet = controller.getActiveSheet() # アクティブなシートを取得。
annotations = sheet.getAnnotations()
tcu.wtree(annotations)
└─.sheet.CellAnnotations
├─.container.XEnumerationAccess
│ │ .container.XEnumeration createEnumeration()
│ └─.container.XElementAccess
│ type getElementType()
│ boolean hasElements()
└─.sheet.XSheetAnnotations
│ void insertNew( [in] .table.CellAddress aPosition,
│ [in] string aText)
│ void removeByIndex( [in] long nIndex)
└─.container.XIndexAccess
any getByIndex( [in] long Index
) raises ( .lang.WrappedTargetException,
.lang.IndexOutOfBoundsException)
long getCount()
├─.container.XEnumerationAccess
│ │ .container.XEnumeration createEnumeration()
│ └─.container.XElementAccess
│ type getElementType()
│ boolean hasElements()
└─.sheet.XSheetAnnotations
│ void insertNew( [in] .table.CellAddress aPosition,
│ [in] string aText)
│ void removeByIndex( [in] long nIndex)
└─.container.XIndexAccess
any getByIndex( [in] long Index
) raises ( .lang.WrappedTargetException,
.lang.IndexOutOfBoundsException)
long getCount()
コメントのサービスとインターフェイスの一覧
コメントはセルからも取得できます。
しかし、新規挿入はシートや行や列と同様にコレクションのinsertNew()メソッドで行わないといけないので、セルからコメントを取得するのは既にあるコメントの編集目的になります。
def macro():
ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。
smgr = ctx.getServiceManager() # サービスマネージャーの取得。
tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。
doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。
controller = doc.getCurrentController() # コントローラの取得。
sheet = controller.getActiveSheet() # アクティブなシートを取得。
cell = sheet["A1"]
annotation = cell.getAnnotation()
tcu.wtree(annotation)
└─.sheet.CellAnnotation
├─.container.XChild
│ .uno.XInterface getParent()
│ void setParent( [in] .uno.XInterface Parent
│ ) raises ( .lang.NoSupportException)
├─.sheet.XSheetAnnotation
│ string getAuthor()
│ string getDate()
│ boolean getIsVisible()
│ .table.CellAddress getPosition()
│ void setIsVisible( [in] boolean bIsVisible)
├─.sheet.XSheetAnnotationShapeSupplier
│ .drawing.XShape getAnnotationShape()
└─.text.XSimpleText
│ .text.XTextCursor createTextCursor()
│ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ void insertControlCharacter( [in] .text.XTextRange xRange,
│ [in] short nControlCharacter,
│ [in] boolean bAbsorb
│ ) raises ( .lang.IllegalArgumentException)
│ void insertString( [in] .text.XTextRange xRange,
│ [in] string aString,
│ [in] boolean bAbsorb)
└─.text.XTextRange
.text.XTextRange getEnd()
.text.XTextRange getStart()
string getString()
.text.XText getText()
void setString( [in] string aString)
├─.container.XChild
│ .uno.XInterface getParent()
│ void setParent( [in] .uno.XInterface Parent
│ ) raises ( .lang.NoSupportException)
├─.sheet.XSheetAnnotation
│ string getAuthor()
│ string getDate()
│ boolean getIsVisible()
│ .table.CellAddress getPosition()
│ void setIsVisible( [in] boolean bIsVisible)
├─.sheet.XSheetAnnotationShapeSupplier
│ .drawing.XShape getAnnotationShape()
└─.text.XSimpleText
│ .text.XTextCursor createTextCursor()
│ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ void insertControlCharacter( [in] .text.XTextRange xRange,
│ [in] short nControlCharacter,
│ [in] boolean bAbsorb
│ ) raises ( .lang.IllegalArgumentException)
│ void insertString( [in] .text.XTextRange xRange,
│ [in] string aString,
│ [in] boolean bAbsorb)
└─.text.XTextRange
.text.XTextRange getEnd()
.text.XTextRange getStart()
string getString()
.text.XText getText()
void setString( [in] string aString)
getPosition()でコメントが入っているセルのアドレスが取得できます。
getParent()でセルが取得できます。
CellAnnotationShapeのサービスとインターフェイスの一覧
CellAnnotationShapeはコメントを挿入してからでしか取得できませんでした。
def macro():
ctx = XSCRIPTCONTEXT.getComponentContext() # コンポーネントコンテクストの取得。
smgr = ctx.getServiceManager() # サービスマネージャーの取得。
tcu = smgr.createInstanceWithContext("pq.Tcu", ctx) # サービス名か実装名でインスタンス化。
doc = XSCRIPTCONTEXT.getDocument() # Calcドキュメント。
controller = doc.getCurrentController() # コントローラの取得。
sheet = controller.getActiveSheet() # アクティブなシートを取得。
cell = sheet["C1"]
address = cell.getCellAddress() # セルアドレスを取得。
annotations = sheet.getAnnotations() # シートのセル注釈コレクションを取得。
annotations.insertNew(address, "This is an annotation") # セル注釈を挿入。
annotation = cell.getAnnotation() # セル注釈を取得。
shape = annotation.getAnnotationShape() # CellAnnotationShapeを取得。
tcu.wtree(shape)
├─.sheet.CellAnnotationShape
│ └─.drawing.CaptionShape
│ │ long CaptionAngle
│ │ long CaptionEscapeAbsolute
│ │ long CaptionEscapeDirection
│ │ long CaptionEscapeRelative
│ │ long CaptionGap
│ │ boolean CaptionIsEscapeRelative
│ │ boolean CaptionIsFitLineLength
│ │ boolean CaptionIsFixedAngle
│ │ long CaptionLineLength
│ │ .awt.Point CaptionPoint
│ │ short CaptionType
│ │ long CornerRadius
│ ├─.drawing.FillProperties
│ │ boolean FillBackground
│ │ .awt.XBitmap FillBitmap
│ │ boolean FillBitmapLogicalSize
│ │ .drawing.BitmapMode FillBitmapMode
│ │ string FillBitmapName
│ │ short FillBitmapOffsetX
│ │ short FillBitmapOffsetY
│ │ short FillBitmapPositionOffsetX
│ │ short FillBitmapPositionOffsetY
│ │ .drawing.RectanglePoint FillBitmapRectanglePoint
│ │ long FillBitmapSizeX
│ │ long FillBitmapSizeY
│ │ boolean FillBitmapStretch
│ │ boolean FillBitmapTile
│ │ string FillBitmapURL
│ │ .util.Color FillColor
│ │ .awt.Gradient FillGradient
│ │ string FillGradientName
│ │ .drawing.Hatch FillHatch
│ │ string FillHatchName
│ │ .drawing.FillStyle FillStyle
│ │ short FillTransparence
│ │ .awt.Gradient FillTransparenceGradient
│ │ string FillTransparenceGradientName
│ │ .text.GraphicCrop GraphicCrop
│ ├─.drawing.LineProperties
│ │ .drawing.LineCap LineCap
│ │ .util.Color LineColor
│ │ .drawing.LineDash LineDash
│ │ string LineDashName
│ │ .drawing.PolyPolygonBezierCoords LineEnd
│ │ boolean LineEndCenter
│ │ string LineEndName
│ │ long LineEndWidth
│ │ .drawing.LineJoint LineJoint
│ │ .drawing.PolyPolygonBezierCoords LineStart
│ │ boolean LineStartCenter
│ │ string LineStartName
│ │ long LineStartWidth
│ │ .drawing.LineStyle LineStyle
│ │ short LineTransparence
│ │ long LineWidth
│ ├─.drawing.RotationDescriptor
│ │ long RotateAngle
│ │ long ShearAngle
│ ├─.drawing.ShadowProperties
│ │ boolean Shadow
│ │ .util.Color ShadowColor
│ │ short ShadowTransparence
│ │ long ShadowXDistance
│ │ long ShadowYDistance
│ ├─.drawing.Shape
│ │ │ string Hyperlink
│ │ │ [.beans.PropertyValue] InteropGrabBag
│ │ │ short LayerID
│ │ │ string LayerName
│ │ │ boolean MoveProtect
│ │ │ string Name
│ │ │ long NavigationOrder
│ │ │ boolean Printable
│ │ │ short RelativeHeight
│ │ │ short RelativeHeightRelation
│ │ │ short RelativeWidth
│ │ │ short RelativeWidthRelation
│ │ │ .container.XNameContainer ShapeUserDefinedAttributes
│ │ │ boolean SizeProtect
│ │ │ .style.XStyle Style
│ │ │ .drawing.HomogenMatrix3 Transformation
│ │ │ boolean Visible
│ │ │ long ZOrder
│ │ ├─.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.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)
│ │ ├─.drawing.XGluePointsSupplier
│ │ │ .container.XIndexContainer getGluePoints()
│ │ ├─.drawing.XShape
│ │ │ .awt.Point getPosition()
│ │ │ .awt.Size getSize()
│ │ │ void setPosition( [in] .awt.Point aPosition)
│ │ │ void setSize( [in] .awt.Size aSize
│ │ │ ) raises ( .beans.PropertyVetoException)
│ │ ├─.drawing.XShapeDescriptor
│ │ │ string getShapeType()
│ │ └─.lang.XComponent
│ │ void addEventListener( [in] .lang.XEventListener xListener)
│ │ void dispose()
│ │ void removeEventListener( [in] .lang.XEventListener aListener)
│ └─.drawing.Text
│ ├─.text.XText
│ │ │ void insertTextContent( [in] .text.XTextRange xRange,
│ │ │ [in] .text.XTextContent xContent,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void removeTextContent( [in] .text.XTextContent xContent
│ │ │ ) raises ( .container.NoSuchElementException)
│ │ └─.text.XSimpleText
│ │ │ .text.XTextCursor createTextCursor()
│ │ │ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ │ │ void insertControlCharacter( [in] .text.XTextRange xRange,
│ │ │ [in] short nControlCharacter,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void insertString( [in] .text.XTextRange xRange,
│ │ │ [in] string aString,
│ │ │ [in] boolean bAbsorb)
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ └─.drawing.TextProperties
│ │ boolean IsNumbering
│ │ .container.XIndexReplace NumberingRules
│ │ short TextAnimationAmount
│ │ short TextAnimationCount
│ │ short TextAnimationDelay
│ │ .drawing.TextAnimationDirection TextAnimationDirection
│ │ .drawing.TextAnimationKind TextAnimationKind
│ │ boolean TextAnimationStartInside
│ │ boolean TextAnimationStopInside
│ │ boolean TextAutoGrowHeight
│ │ boolean TextAutoGrowWidth
│ │ boolean TextContourFrame
│ │ .drawing.TextFitToSizeType TextFitToSize
│ │ .drawing.TextHorizontalAdjust TextHorizontalAdjust
│ │ long TextLeftDistance
│ │ long TextLowerDistance
│ │ long TextMaximumFrameHeight
│ │ long TextMaximumFrameWidth
│ │ long TextMinimumFrameHeight
│ │ long TextMinimumFrameWidth
│ │ long TextRightDistance
│ │ long TextUpperDistance
│ │ .drawing.TextVerticalAdjust TextVerticalAdjust
│ │ .text.WritingMode TextWritingMode
│ ├─.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
├─.sheet.Shape
│ .uno.XInterface Anchor
│ long HoriOrientPosition
│ long VertOrientPosition
├─.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.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.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)
├─.container.XChild
│ .uno.XInterface getParent()
│ void setParent( [in] .uno.XInterface Parent
│ ) raises ( .lang.NoSupportException)
├─.container.XEnumerationAccess
│ │ .container.XEnumeration createEnumeration()
│ └─.container.XElementAccess
│ type getElementType()
│ boolean hasElements()
├─.container.XNamed
│ string getName()
│ void setName( [in] string aName)
├─.document.XEventsSupplier
│ .container.XNameReplace getEvents()
├─.text.XTextAppend
│ ├─.text.XParagraphAppend
│ │ .text.XTextRange finishParagraph( [in] .beans.PropertyValues CharacterAndParagraphProperties
│ │ ) raises ( .beans.UnknownPropertyException,
│ │ .lang.IllegalArgumentException)
│ │ .text.XTextRange finishParagraphInsert( [in] .beans.PropertyValues CharacterAndParagraphProperties,
│ │ [in] .text.XTextRange TextRange
│ │ ) raises ( .beans.UnknownPropertyException,
│ │ .lang.IllegalArgumentException)
│ └─.text.XTextPortionAppend
│ .text.XTextRange appendTextPortion( [in] string Text,
│ [in] .beans.PropertyValues CharacterAndParagraphProperties
│ ) raises ( .beans.PropertyVetoException,
│ .beans.UnknownPropertyException,
│ .lang.IllegalArgumentException)
│ .text.XTextRange insertTextPortion( [in] string Text,
│ [in] .beans.PropertyValues CharacterAndParagraphProperties,
│ [in] .text.XTextRange TextRange
│ ) raises ( .beans.PropertyVetoException,
│ .beans.UnknownPropertyException,
│ .lang.IllegalArgumentException)
├─.text.XTextContent
│ void attach( [in] .text.XTextRange xTextRange
│ ) raises ( .lang.IllegalArgumentException)
│ .text.XTextRange getAnchor()
├─.text.XTextCopy
│ void copyText( [in] .text.XTextCopy xSource)
├─.text.XTextRangeMover
│ void moveTextRange( [in] .text.XTextRange xRange,
│ [in] short nParagraphs)
└──(サービスやインターフェイスに属しないプロパティ)
.awt.XBitmap Bitmap
.awt.Rectangle BoundRect
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
string Description
long FillColor2
short FillGradientStepCount
boolean FontIndependentLineSpacing
long FontWorkAdjust
long FontWorkDistance
boolean FontWorkHideForm
boolean FontWorkMirror
boolean FontWorkOutline
long FontWorkShadow
long FontWorkShadowColor
long FontWorkShadowOffsetX
long FontWorkShadowOffsetY
short FontWorkShadowTransparence
long FontWorkStart
long FontWorkStyle
.awt.Rectangle FrameRect
.container.XIndexContainer ImageMap
boolean IsFontwork
.awt.XBitmap LinkDisplayBitmap
string LinkDisplayName
[byte] MetaFile
string TextChainNextName
boolean TextWordWrap
string Title
string UINamePlural
string UINameSingular
string URL
.container.XNameContainer UserDefinedAttributes
│ └─.drawing.CaptionShape
│ │ long CaptionAngle
│ │ long CaptionEscapeAbsolute
│ │ long CaptionEscapeDirection
│ │ long CaptionEscapeRelative
│ │ long CaptionGap
│ │ boolean CaptionIsEscapeRelative
│ │ boolean CaptionIsFitLineLength
│ │ boolean CaptionIsFixedAngle
│ │ long CaptionLineLength
│ │ .awt.Point CaptionPoint
│ │ short CaptionType
│ │ long CornerRadius
│ ├─.drawing.FillProperties
│ │ boolean FillBackground
│ │ .awt.XBitmap FillBitmap
│ │ boolean FillBitmapLogicalSize
│ │ .drawing.BitmapMode FillBitmapMode
│ │ string FillBitmapName
│ │ short FillBitmapOffsetX
│ │ short FillBitmapOffsetY
│ │ short FillBitmapPositionOffsetX
│ │ short FillBitmapPositionOffsetY
│ │ .drawing.RectanglePoint FillBitmapRectanglePoint
│ │ long FillBitmapSizeX
│ │ long FillBitmapSizeY
│ │ boolean FillBitmapStretch
│ │ boolean FillBitmapTile
│ │ string FillBitmapURL
│ │ .util.Color FillColor
│ │ .awt.Gradient FillGradient
│ │ string FillGradientName
│ │ .drawing.Hatch FillHatch
│ │ string FillHatchName
│ │ .drawing.FillStyle FillStyle
│ │ short FillTransparence
│ │ .awt.Gradient FillTransparenceGradient
│ │ string FillTransparenceGradientName
│ │ .text.GraphicCrop GraphicCrop
│ ├─.drawing.LineProperties
│ │ .drawing.LineCap LineCap
│ │ .util.Color LineColor
│ │ .drawing.LineDash LineDash
│ │ string LineDashName
│ │ .drawing.PolyPolygonBezierCoords LineEnd
│ │ boolean LineEndCenter
│ │ string LineEndName
│ │ long LineEndWidth
│ │ .drawing.LineJoint LineJoint
│ │ .drawing.PolyPolygonBezierCoords LineStart
│ │ boolean LineStartCenter
│ │ string LineStartName
│ │ long LineStartWidth
│ │ .drawing.LineStyle LineStyle
│ │ short LineTransparence
│ │ long LineWidth
│ ├─.drawing.RotationDescriptor
│ │ long RotateAngle
│ │ long ShearAngle
│ ├─.drawing.ShadowProperties
│ │ boolean Shadow
│ │ .util.Color ShadowColor
│ │ short ShadowTransparence
│ │ long ShadowXDistance
│ │ long ShadowYDistance
│ ├─.drawing.Shape
│ │ │ string Hyperlink
│ │ │ [.beans.PropertyValue] InteropGrabBag
│ │ │ short LayerID
│ │ │ string LayerName
│ │ │ boolean MoveProtect
│ │ │ string Name
│ │ │ long NavigationOrder
│ │ │ boolean Printable
│ │ │ short RelativeHeight
│ │ │ short RelativeHeightRelation
│ │ │ short RelativeWidth
│ │ │ short RelativeWidthRelation
│ │ │ .container.XNameContainer ShapeUserDefinedAttributes
│ │ │ boolean SizeProtect
│ │ │ .style.XStyle Style
│ │ │ .drawing.HomogenMatrix3 Transformation
│ │ │ boolean Visible
│ │ │ long ZOrder
│ │ ├─.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.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)
│ │ ├─.drawing.XGluePointsSupplier
│ │ │ .container.XIndexContainer getGluePoints()
│ │ ├─.drawing.XShape
│ │ │ .awt.Point getPosition()
│ │ │ .awt.Size getSize()
│ │ │ void setPosition( [in] .awt.Point aPosition)
│ │ │ void setSize( [in] .awt.Size aSize
│ │ │ ) raises ( .beans.PropertyVetoException)
│ │ ├─.drawing.XShapeDescriptor
│ │ │ string getShapeType()
│ │ └─.lang.XComponent
│ │ void addEventListener( [in] .lang.XEventListener xListener)
│ │ void dispose()
│ │ void removeEventListener( [in] .lang.XEventListener aListener)
│ └─.drawing.Text
│ ├─.text.XText
│ │ │ void insertTextContent( [in] .text.XTextRange xRange,
│ │ │ [in] .text.XTextContent xContent,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void removeTextContent( [in] .text.XTextContent xContent
│ │ │ ) raises ( .container.NoSuchElementException)
│ │ └─.text.XSimpleText
│ │ │ .text.XTextCursor createTextCursor()
│ │ │ .text.XTextCursor createTextCursorByRange( [in] .text.XTextRange aTextPosition)
│ │ │ void insertControlCharacter( [in] .text.XTextRange xRange,
│ │ │ [in] short nControlCharacter,
│ │ │ [in] boolean bAbsorb
│ │ │ ) raises ( .lang.IllegalArgumentException)
│ │ │ void insertString( [in] .text.XTextRange xRange,
│ │ │ [in] string aString,
│ │ │ [in] boolean bAbsorb)
│ │ └─.text.XTextRange
│ │ .text.XTextRange getEnd()
│ │ .text.XTextRange getStart()
│ │ string getString()
│ │ .text.XText getText()
│ │ void setString( [in] string aString)
│ └─.drawing.TextProperties
│ │ boolean IsNumbering
│ │ .container.XIndexReplace NumberingRules
│ │ short TextAnimationAmount
│ │ short TextAnimationCount
│ │ short TextAnimationDelay
│ │ .drawing.TextAnimationDirection TextAnimationDirection
│ │ .drawing.TextAnimationKind TextAnimationKind
│ │ boolean TextAnimationStartInside
│ │ boolean TextAnimationStopInside
│ │ boolean TextAutoGrowHeight
│ │ boolean TextAutoGrowWidth
│ │ boolean TextContourFrame
│ │ .drawing.TextFitToSizeType TextFitToSize
│ │ .drawing.TextHorizontalAdjust TextHorizontalAdjust
│ │ long TextLeftDistance
│ │ long TextLowerDistance
│ │ long TextMaximumFrameHeight
│ │ long TextMaximumFrameWidth
│ │ long TextMinimumFrameHeight
│ │ long TextMinimumFrameWidth
│ │ long TextRightDistance
│ │ long TextUpperDistance
│ │ .drawing.TextVerticalAdjust TextVerticalAdjust
│ │ .text.WritingMode TextWritingMode
│ ├─.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
├─.sheet.Shape
│ .uno.XInterface Anchor
│ long HoriOrientPosition
│ long VertOrientPosition
├─.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.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.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)
├─.container.XChild
│ .uno.XInterface getParent()
│ void setParent( [in] .uno.XInterface Parent
│ ) raises ( .lang.NoSupportException)
├─.container.XEnumerationAccess
│ │ .container.XEnumeration createEnumeration()
│ └─.container.XElementAccess
│ type getElementType()
│ boolean hasElements()
├─.container.XNamed
│ string getName()
│ void setName( [in] string aName)
├─.document.XEventsSupplier
│ .container.XNameReplace getEvents()
├─.text.XTextAppend
│ ├─.text.XParagraphAppend
│ │ .text.XTextRange finishParagraph( [in] .beans.PropertyValues CharacterAndParagraphProperties
│ │ ) raises ( .beans.UnknownPropertyException,
│ │ .lang.IllegalArgumentException)
│ │ .text.XTextRange finishParagraphInsert( [in] .beans.PropertyValues CharacterAndParagraphProperties,
│ │ [in] .text.XTextRange TextRange
│ │ ) raises ( .beans.UnknownPropertyException,
│ │ .lang.IllegalArgumentException)
│ └─.text.XTextPortionAppend
│ .text.XTextRange appendTextPortion( [in] string Text,
│ [in] .beans.PropertyValues CharacterAndParagraphProperties
│ ) raises ( .beans.PropertyVetoException,
│ .beans.UnknownPropertyException,
│ .lang.IllegalArgumentException)
│ .text.XTextRange insertTextPortion( [in] string Text,
│ [in] .beans.PropertyValues CharacterAndParagraphProperties,
│ [in] .text.XTextRange TextRange
│ ) raises ( .beans.PropertyVetoException,
│ .beans.UnknownPropertyException,
│ .lang.IllegalArgumentException)
├─.text.XTextContent
│ void attach( [in] .text.XTextRange xTextRange
│ ) raises ( .lang.IllegalArgumentException)
│ .text.XTextRange getAnchor()
├─.text.XTextCopy
│ void copyText( [in] .text.XTextCopy xSource)
├─.text.XTextRangeMover
│ void moveTextRange( [in] .text.XTextRange xRange,
│ [in] short nParagraphs)
└──(サービスやインターフェイスに属しないプロパティ)
.awt.XBitmap Bitmap
.awt.Rectangle BoundRect
short CharOverline
long CharOverlineColor
boolean CharOverlineHasColor
string Description
long FillColor2
short FillGradientStepCount
boolean FontIndependentLineSpacing
long FontWorkAdjust
long FontWorkDistance
boolean FontWorkHideForm
boolean FontWorkMirror
boolean FontWorkOutline
long FontWorkShadow
long FontWorkShadowColor
long FontWorkShadowOffsetX
long FontWorkShadowOffsetY
short FontWorkShadowTransparence
long FontWorkStart
long FontWorkStyle
.awt.Rectangle FrameRect
.container.XIndexContainer ImageMap
boolean IsFontwork
.awt.XBitmap LinkDisplayBitmap
string LinkDisplayName
[byte] MetaFile
string TextChainNextName
boolean TextWordWrap
string Title
string UINamePlural
string UINameSingular
string URL
.container.XNameContainer UserDefinedAttributes
こんなにプロパティがあればいろいろ設定できそうですね。
しかしコメントを挿入してからしか設定できないものでしょうか。
セルの右隅に表示される赤い四角をカスタマイズしたいのですが、これに該当するプロパティはいまのところわかりません。
コメントを非表示にしているとき、コメントのあるセルにマウスが入るとコメントがポップアップします。
Windows10でもlinuxBean14.04でも同じようにポップアップしました。
しかしVirtualBox5.1.22のゲストのlinuxBean14.04ではポップアップがでませんでした。
0 件のコメント:
コメントを投稿