TExcelFile.SetComment Method
Overloads
- TExcelFile.SetComment(Integer, Integer, string)
- TExcelFile.SetComment(Integer, Integer, TRichString)
- TExcelFile.SetComment(Integer, Integer, string, string, IImageProperties)
- TExcelFile.SetComment(Integer, Integer, TRichString, string, IImageProperties, Boolean)
TExcelFile.SetComment(Integer, Integer, string)
Sets or deletes a comment at the specified cell.
Remarks
To delete a comment, set its value to String.Empty.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.SetComment(const row: Integer; const col: Integer; const value: string); overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row index (1 based) |
const | col | Integer | Column index (1 based) |
const | value | string | Text of the comment. Set it to String.Empty to delete the comment. |
See also
- TExcelFile
- CommentRowCount
- CommentCountRow
- GetCommentRow
- GetCommentRowCol
- GetComment
- SetCommentRow(Integer, Integer, string, IImageProperties, Boolean)
- GetCommentPropertiesRow
- SetCommentPropertiesRow
- SetCommentProperties
TExcelFile.SetComment(Integer, Integer, TRichString)
Sets or deletes a comment at the specified cell.
Remarks
To delete a comment, set its value to String.Empty.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.SetComment(const row: Integer; const col: Integer; const value: TRichString); overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row index (1 based) |
const | col | Integer | Column index (1 based) |
const | value | TRichString | Text of the comment. Set it to String.Empty to delete the comment. |
See also
- TExcelFile
- CommentRowCount
- CommentCountRow
- GetCommentRow
- GetCommentRowCol
- GetComment
- SetCommentRow(Integer, Integer, string, IImageProperties, Boolean)
- GetCommentPropertiesRow
- SetCommentPropertiesRow
- SetCommentProperties
TExcelFile.SetComment(Integer, Integer, string, string, IImageProperties)
Sets or deletes a comment at the specified cell.
Remarks
To delete a comment, set its value to String.Empty.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.SetComment(const row: Integer; const col: Integer; const value: string; const author: string; commentProperties: IImageProperties); overload;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row index (1 based) |
const | col | Integer | Column index (1 based) |
const | value | string | Text of the comment. Set it to String.Empty to delete the comment. |
const | author | string | Author of the comment. |
commentProperties | IImageProperties | Properties of the popup. |
See also
- TExcelFile
- CommentRowCount
- CommentCountRow
- GetCommentRow
- GetCommentRowCol
- GetComment
- SetCommentRow(Integer, Integer, string, IImageProperties, Boolean)
- GetCommentPropertiesRow
- SetCommentPropertiesRow
- SetCommentProperties
TExcelFile.SetComment(Integer, Integer, TRichString, string, IImageProperties, Boolean)
Sets or deletes a comment at the specified cell.
Remarks
To delete a comment, set its value to String.Empty.
Syntax
Unit: FlexCel.Core
procedure TExcelFile.SetComment(const row: Integer; const col: Integer; const value: TRichString; const author: string; commentProperties: IImageProperties; const removeEmpty: Boolean = True); overload; virtual; abstract;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | row | Integer | Row index (1 based) |
const | col | Integer | Column index (1 based) |
const | value | TRichString | Text of the comment. Set it to String.Empty to delete the comment. |
const | author | string | Author of the comment. |
commentProperties | IImageProperties | Properties of the popup. | |
const | removeEmpty | Boolean | Optional: Default value is True |