org.apache.poi.hssf.usermodel
Class HSSFComment

java.lang.Object
  extended by org.apache.poi.hssf.usermodel.HSSFShape
      extended by org.apache.poi.hssf.usermodel.HSSFSimpleShape
          extended by org.apache.poi.hssf.usermodel.HSSFTextbox
              extended by org.apache.poi.hssf.usermodel.HSSFComment
All Implemented Interfaces:
Comment, Shape, SimpleShape

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
  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
 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()
           
 boolean equals(java.lang.Object obj)
           
 CellAddress getAddress()
          Get the address of the cell that this comment is attached to
 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
protected  NoteRecord getNoteRecord()
          Returns the underlying Note record
 int getRow()
          Return the row of the cell that contains the comment
 int hashCode()
           
 boolean hasPosition()
          Do we know which cell this comment belongs to?
 boolean isVisible()
          Returns whether this comment is visible.
 void resetBackgroundImage()
           
 void setAddress(CellAddress address)
          Set the address of the cell that this comment is attached to
 void setAddress(int row, int col)
          Set the address of the cell that this comment is attached to
 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 setRow(int row)
          Set the row of the cell that contains the comment
 void setShapeType(int shapeType)
           
 void setVisible(boolean visible)
          Sets 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
createTextObjRecord, getShapeId, getShapeType, getString, getTextObjectRecord, getWrapText, setString, setWrapText
 
Methods inherited from class org.apache.poi.hssf.usermodel.HSSFShape
countOfAllChildren, getAnchor, getEscherContainer, getFillColor, getLineStyle, getLineStyleColor, getLineWidth, getObjRecord, getOptRecord, getParent, getPatriarch, getRotationDegree, getShapeName, 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, finalize, getClass, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface org.apache.poi.ss.usermodel.Comment
getString, setString
 
Methods inherited from interface org.apache.poi.ss.usermodel.Shape
getAnchor, getParent, getShapeName, isNoFill, setFillColor, setLineStyleColor, setNoFill
 

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)
Sets 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()
Returns whether this comment is visible.

Specified by:
isVisible in interface Comment
Returns:
true if the comment is visible, false otherwise

getAddress

public CellAddress getAddress()
Description copied from interface: Comment
Get the address of the cell that this comment is attached to

Specified by:
getAddress in interface Comment
Returns:
comment cell address

setAddress

public void setAddress(CellAddress address)
Description copied from interface: Comment
Set the address of the cell that this comment is attached to

Specified by:
setAddress in interface Comment

setAddress

public void setAddress(int row,
                       int col)
Description copied from interface: Comment
Set the address of the cell that this comment is attached to

Specified by:
setAddress in interface Comment

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

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


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. The anchor is the yellow box/balloon that is rendered on top of the sheets when the comment is visible. To associate a comment with a different cell, use Comment.setAddress(org.apache.poi.ss.util.CellAddress).

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

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()

equals

public boolean equals(java.lang.Object obj)
Overrides:
equals in class java.lang.Object

hashCode

public int hashCode()
Overrides:
hashCode in class java.lang.Object