setCellComment

Sets the comment properties of a cell.

setCellComment( workbook, comment, row, column )

Required arguments

• workbook spreadsheet object
• comment struct
• row numeric
• column numeric

The comment struct may contain the following keys:

• anchor
• author
• bold
• color
• comment
• fillcolor
• font
• horizontalalignment
• italic
• linestyle
• linestylecolor
• size
• strikeout
• underline
• verticalalignment
• visible

Refer to the ColdFusion SpreadsheetSetCellComment docs for details

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.addColumn( workbook, "a" );
theComment = {
 author="cfsimplicity"
 ,comment="This is the comment in row 1 column 1"
 ,linestyle="dashsys"
 ,color="blue"
};
spreadsheet.setCellComment( workbook, theComment, 1, 1 );