org.apache.poi.hssf.usermodel

Class HSSFComment

java.lang.Object

org.apache.poi.hssf.usermodel.HSSFShape

org.apache.poi.hssf.usermodel.HSSFSimpleShape

org.apache.poi.hssf.usermodel.HSSFTextbox

org.apache.poi.hssf.usermodel.HSSFComment

All Implemented Interfaces:

Comment

public class HSSFComment
extends HSSFTextbox
implements Comment

Represents a cell comment - a sticky note associated with a cell.

Field Summary

Fields inherited from class org.apache.poi.hssf.usermodel.HSSFTextbox

HORIZONTAL_ALIGNMENT_CENTERED, HORIZONTAL_ALIGNMENT_DISTRIBUTED, HORIZONTAL_ALIGNMENT_JUSTIFIED, HORIZONTAL_ALIGNMENT_LEFT, HORIZONTAL_ALIGNMENT_RIGHT, OBJECT_TYPE_TEXT, VERTICAL_ALIGNMENT_BOTTOM, VERTICAL_ALIGNMENT_CENTER, VERTICAL_ALIGNMENT_DISTRIBUTED, VERTICAL_ALIGNMENT_JUSTIFY, VERTICAL_ALIGNMENT_TOP

Fields inherited from class org.apache.poi.hssf.usermodel.HSSFSimpleShape

OBJECT_TYPE_ARC, OBJECT_TYPE_COMBO_BOX, OBJECT_TYPE_COMMENT, OBJECT_TYPE_LINE, OBJECT_TYPE_MICROSOFT_OFFICE_DRAWING, OBJECT_TYPE_OVAL, OBJECT_TYPE_PICTURE, OBJECT_TYPE_RECTANGLE, WRAP_BY_POINTS, WRAP_NONE, WRAP_SQUARE

Fields inherited from class org.apache.poi.hssf.usermodel.HSSFShape

FILL__FILLCOLOR_DEFAULT, LINESTYLE__COLOR_DEFAULT, LINESTYLE_DASHDOTDOTSYS, LINESTYLE_DASHDOTGEL, LINESTYLE_DASHDOTSYS, LINESTYLE_DASHGEL, LINESTYLE_DASHSYS, LINESTYLE_DEFAULT, LINESTYLE_DOTGEL, LINESTYLE_DOTSYS, LINESTYLE_LONGDASHDOTDOTGEL, LINESTYLE_LONGDASHDOTGEL, LINESTYLE_LONGDASHGEL, LINESTYLE_NONE, LINESTYLE_SOLID, LINEWIDTH_DEFAULT, LINEWIDTH_ONE_PT, NO_FILL_DEFAULT, NO_FILLHITTEST_FALSE, NO_FILLHITTEST_TRUE

Constructor Summary

Constructors

Constructor and Description
HSSFComment(EscherContainerRecord spContainer, ObjRecord objRecord, TextObjectRecord textObjectRecord, NoteRecord _note)
HSSFComment(HSSFShape parent, HSSFAnchor anchor) Construct a new comment with the given parent and anchor.

Method Summary

Modifier and Type	Method and Description
void	afterRemove(HSSFPatriarch patriarch) remove escher container from the patriarch.escherAggregate remove obj, textObj and note records if it's necessary in case of ShapeGroup remove all contained shapes
java.lang.String	getAuthor() Name of the original comment author
int	getBackgroundImageId()
ClientAnchor	getClientAnchor() Return defines position of this anchor in the sheet.
int	getColumn() Return the column of the cell that contains the comment
int	getRow() Return the row of the cell that contains the comment
boolean	hasPosition() Do we know which cell this comment belongs to?
boolean	isVisible() Sets whether this comment is visible.
void	resetBackgroundImage()
void	setAuthor(java.lang.String author) Name of the original comment author
void	setBackgroundImage(int pictureIndex)
void	setColumn(int col) Set the column of the cell that contains the comment
void	setColumn(short col) Deprecated. (Nov 2009) use setColumn(int) }
void	setRow(int row) Set the row of the cell that contains the comment
void	setShapeType(int shapeType)
void	setVisible(boolean visible) Returns whether this comment is visible.

Methods inherited from class org.apache.poi.hssf.usermodel.HSSFTextbox

getHorizontalAlignment, getMarginBottom, getMarginLeft, getMarginRight, getMarginTop, getVerticalAlignment, setHorizontalAlignment, setMarginBottom, setMarginLeft, setMarginRight, setMarginTop, setVerticalAlignment

Methods inherited from class org.apache.poi.hssf.usermodel.HSSFSimpleShape

getShapeType, getString, getWrapText, setString, setWrapText

Methods inherited from class org.apache.poi.hssf.usermodel.HSSFShape

countOfAllChildren, getAnchor, getFillColor, getLineStyle, getLineStyleColor, getLineWidth, getParent, getPatriarch, getRotationDegree, isFlipHorizontal, isFlipVertical, isNoFill, setAnchor, setFillColor, setFillColor, setFlipHorizontal, setFlipVertical, setLineStyle, setLineStyleColor, setLineStyleColor, setLineWidth, setNoFill, setRotationDegree

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.poi.ss.usermodel.Comment

getString, setString

Constructor Detail

HSSFComment

public HSSFComment(EscherContainerRecord spContainer,
                   ObjRecord objRecord,
                   TextObjectRecord textObjectRecord,
                   NoteRecord _note)

HSSFComment

public HSSFComment(HSSFShape parent,
                   HSSFAnchor anchor)

Construct a new comment with the given parent and anchor.

Parameters:

parent -

anchor - defines position of this anchor in the sheet

Method Detail

setVisible

public void setVisible(boolean visible)

Returns whether this comment is visible.

Specified by:

setVisible in interface Comment

Parameters:

visible - true if the comment is visible, false otherwise

isVisible

public boolean isVisible()

Sets whether this comment is visible.

Specified by:

isVisible in interface Comment

Returns:

true if the comment is visible, false otherwise

getRow

public int getRow()

Return the row of the cell that contains the comment

Specified by:

getRow in interface Comment

Returns:

the 0-based row of the cell that contains the comment

setRow

public void setRow(int row)

Set the row of the cell that contains the comment

Specified by:

setRow in interface Comment

Parameters:

row - the 0-based row of the cell that contains the comment

getColumn

public int getColumn()

Return the column of the cell that contains the comment

Specified by:

getColumn in interface Comment

Returns:

the 0-based column of the cell that contains the comment

setColumn

public void setColumn(int col)

Set the column of the cell that contains the comment

Specified by:

setColumn in interface Comment

Parameters:

col - the 0-based column of the cell that contains the comment

setColumn

@Deprecated
public void setColumn(short col)

Deprecated. (Nov 2009) use setColumn(int) }

getAuthor

public java.lang.String getAuthor()

Name of the original comment author

Specified by:

getAuthor in interface Comment

Returns:

the name of the original author of the comment

setAuthor

public void setAuthor(java.lang.String author)

Name of the original comment author

Specified by:

setAuthor in interface Comment

Parameters:

author - the name of the original author of the comment

hasPosition

public boolean hasPosition()

Do we know which cell this comment belongs to?

getClientAnchor

public ClientAnchor getClientAnchor()

Description copied from interface: Comment

Return defines position of this anchor in the sheet.

Specified by:

getClientAnchor in interface Comment

Returns:

defines position of this anchor in the sheet

setShapeType

public void setShapeType(int shapeType)

Overrides:

setShapeType in class HSSFTextbox

Parameters:

shapeType - - shapeType

See Also:

HSSFShapeTypes

afterRemove

public void afterRemove(HSSFPatriarch patriarch)

Description copied from class: HSSFShape

remove escher container from the patriarch.escherAggregate remove obj, textObj and note records if it's necessary in case of ShapeGroup remove all contained shapes

setBackgroundImage

public void setBackgroundImage(int pictureIndex)

resetBackgroundImage

public void resetBackgroundImage()

getBackgroundImageId

public int getBackgroundImageId()