org.zkoss.poi.hssf.usermodel

Class HSSFComment

java.lang.Object

org.zkoss.poi.hssf.usermodel.HSSFShape

org.zkoss.poi.hssf.usermodel.HSSFSimpleShape

org.zkoss.poi.hssf.usermodel.HSSFTextbox

org.zkoss.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.

Author:

Yegor Kozlov

Field Summary

Fields inherited from class org.zkoss.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.zkoss.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.zkoss.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

Modifier	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.
protected	HSSFComment(NoteRecord note, TextObjectRecord txo)

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
protected HSSFShape	cloneShape()
protected ObjRecord	createObjRecord()
protected EscherContainerRecord	createSpContainer()
java.lang.String	getAuthor() Name of the original comment author
int	getBackgroundImageId()
int	getColumn() Return the column of the cell that contains the comment
protected NoteRecord	getNoteRecord() Returns the underlying Note record
int	getRow() Return the row of the cell that contains the comment
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.zkoss.poi.hssf.usermodel.HSSFTextbox

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

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

createTextObjRecord, getShapeType, getString, getTextObjectRecord, getWrapText, setString, setWrapText

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

countOfAllChildren, getAnchor, getEscherContainer, getFillColor, getLineStyle, getLineStyleColor, getLineWidth, getObjRecord, getOptRecord, getParent, getPatriarch, getRotationDegree, isFlipHorizontal, isFlipVertical, isNoFill, setAnchor, setFillColor, setFillColor, setFlipHorizontal, setFlipVertical, setLineStyle, setLineStyleColor, setLineStyleColor, setLineWidth, setNoFill, setParent, setPatriarch, setPropertyValue, setRotationDegree

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.zkoss.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

HSSFComment

protected HSSFComment(NoteRecord note,
                      TextObjectRecord txo)

Method Detail

createSpContainer

protected EscherContainerRecord createSpContainer()

Overrides:

createSpContainer in class HSSFTextbox

createObjRecord

protected ObjRecord createObjRecord()

Overrides:

createObjRecord in class HSSFTextbox

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

getNoteRecord

protected NoteRecord getNoteRecord()

Returns the underlying Note record

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

Overrides:

afterRemove in class HSSFTextbox

cloneShape

protected HSSFShape cloneShape()

Overrides:

cloneShape in class HSSFTextbox

setBackgroundImage

public void setBackgroundImage(int pictureIndex)

resetBackgroundImage

public void resetBackgroundImage()

getBackgroundImageId

public int getBackgroundImageId()