Table of Contents

TExcelFile.SetComment Method

Overloads

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

See also