com.aspose.cells
Class Comment

java.lang.Object
    com.aspose.cells.Comment

public class Comment 
extends java.lang.Object

Workbook workbook = new Workbook();
CommentCollection comments = workbook.getWorksheets().get(0).getComments();

//Add comment to cell A1
int commentIndex = comments.add(0, 0);
Comment comment = comments.get(commentIndex);
comment.setNote("First note.");
comment.getFont().setName("Times New Roman");

//Add comment to cell B2
comments.add("B2");
comment = comments.get("B2");
comment.setNote("Second note.");

public java.lang.String getAuthor() / public void setAuthor(java.lang.String value)

Gets and sets Name of the original comment author

public CommentShape getCommentShape()

Get a Shape object that represents the shape attached to the specified comment.

public int getRow()

Gets the row index of the comment.

public int getColumn()

Gets the column index of the comment.

public java.lang.String getNote() / public void setNote(java.lang.String value)

Represents the content of comment.

public java.lang.String getHtmlNote() / public void setHtmlNote(java.lang.String value)

Gets and sets the html string which contains data and some formattings in this comment.

public Font getFont()

Gets the font of comment.

public boolean isVisible() / public void setVisible(boolean value)

Represents if the comment is visible or not.

public int getTextOrientationType() / public void setTextOrientationType(int value)

Gets and sets the text orientation type of the comment. The value of the property is TextOrientationType integer constant.

public int getTextHorizontalAlignment() / public void setTextHorizontalAlignment(int value)

Gets and sets the text horizontal alignment type of the comment. The value of the property is TextAlignmentType integer constant.

public int getTextVerticalAlignment() / public void setTextVerticalAlignment(int value)

Gets and sets the text vertical alignment type of the comment. The value of the property is TextAlignmentType integer constant.

public boolean getAutoSize() / public void setAutoSize(boolean value)

Indicates if size of comment is adjusted automatically according to its content.

public double getHeightCM() / public void setHeightCM(double value)

Represents the height of the comment, in unit of centimeters.

public double getWidthCM() / public void setWidthCM(double value)

Represents the width of the comment, in unit of centimeters.

public double getWidthInch() / public void setWidthInch(double value)

Represents the width of the comment, in unit of inches.

public double getHeightInch() / public void setHeightInch(double value)

Represents the height of the comment, in unit of inches.

public FontSetting characters(int startIndex, int length)

Returns a Characters object that represents a range of characters within the comment text.

Parameters:

startIndex - The index of the start of the character.

length - The number of characters.

Returns:

Characters object.

public java.util.ArrayList getCharacters()

Returns all Characters objects that represents a range of characters within the comment text.

Returns:

All Characters objects