Search Results for

    Show / Hide Table of Contents

    TExcelFile.SetCommentRow Method

    Overloads

    • TExcelFile.SetCommentRow(Integer, Integer, TRichString, IImageProperties, Boolean)
    • TExcelFile.SetCommentRow(Integer, Integer, string, IImageProperties, Boolean)

    TExcelFile.SetCommentRow(Integer, Integer, TRichString, IImageProperties, Boolean)

    Changes the properties (text and position of the popup) for an existing comment at commentIndex. To delete a comment, set a "new TRichString()" as the "value" param. To add a new comment, use SetComment(Integer, Integer, TRichString).

    Remarks

    This method is used together with CommentCountRow. See the reference on it for an example.

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.SetCommentRow(const row: Integer; const commentIndex: Integer; const value: TRichString; commentProperties: IImageProperties; const removeEmpty: Boolean = True); overload; virtual; abstract;

    Parameters

    <-> Parameter Type Description
    const row Integer Row Index (1 based)
    const commentIndex Integer Comment index (1 based)
    const value TRichString Text of the comment. Set it to "new TRichString()" to remove the comment.
    commentProperties IImageProperties Properties of the popup.
    const removeEmpty Boolean Optional: Default value is True

    If true, comments of length 0 will be removed.

    See also

    • TExcelFile
    • CommentRowCount
    • CommentCountRow
    • GetCommentRow
    • GetCommentRowCol
    • GetComment
    • SetComment(Integer, Integer, TRichString)
    • GetCommentPropertiesRow
    • SetCommentPropertiesRow
    • SetCommentProperties

    TExcelFile.SetCommentRow(Integer, Integer, string, IImageProperties, Boolean)

    Changes the properties (text and position of the popup) for an existing comment at commentIndex. To delete a comment, set a String.Empty as the "value" param. To add a new comment, use SetComment(Integer, Integer, TRichString).

    Remarks

    This method is used together with CommentCountRow. See the reference on it for an example.

    Syntax

    Unit: FlexCel.Core

    procedure TExcelFile.SetCommentRow(const row: Integer; const commentIndex: Integer; const value: string; commentProperties: IImageProperties; const removeEmpty: Boolean = True); overload;

    Parameters

    <-> Parameter Type Description
    const row Integer Row Index (1 based)
    const commentIndex Integer Comment index (1 based)
    const value string Text of the comment. Set it to String.Empty to remove the comment.
    commentProperties IImageProperties Properties of the popup.
    const removeEmpty Boolean Optional: Default value is True

    If true, comments of length 0 will be removed.

    See also

    • TExcelFile
    • CommentRowCount
    • CommentCountRow
    • GetCommentRow
    • GetCommentRowCol
    • GetComment
    • SetComment(Integer, Integer, TRichString)
    • GetCommentPropertiesRow
    • SetCommentPropertiesRow
    • SetCommentProperties
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.24
    © 2002 - 2025 tmssoftware.com