SpreadsheetListComment (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Controls, pages and windows / Spreadsheet functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SpreadsheetListComment (Function)

In french: TableurListeCommentaire

Lists all the comments on the current worksheet of a Spreadsheet control.

Example

// Rendre tous les commentaires visibles
FOR EACH Commentaire OF SpreadsheetListComment(TBLR_MonTableur)
	Commentaire..Visible = True
END

// Supprimer tous les commentaires
FOR EACH Commentaire OF SpreadsheetListComment(TBLR_MonTableur)
	Commentaire..Text = ""
END

MonTabCommentaire is array of xlsComment
MonTabCommentaire = SpreadsheetListComment(TBLR_MonTableur)
FOR EACH commentaire OF MonTabCommentaire
	Trace(commentaire..Text)
END

Syntax

<Result> = SpreadsheetListComment(<Spreadsheet control>)

<Result>: Array

Array containing the different comments with their characteristics. This array contains variables of type xlsComment.

<Spreadsheet control>: Control name

Name of the Spreadsheet control to be used.

Remarks

Modifying a comment in the array also modifies it in the Spreadsheet control.
Adding or deleting a comment in the array has no effect on the comments in the Spreadsheet control.
If there is no comment in the worksheet, the array is empty.

Component: wd290obj.dll