Editing comments

Viewing and editing the properties

Select a comment with the mouse to view and edit its properties in the Property-Editor. Since a comment is not visible (only its text) you must click onto the free space under the separator line of the comment.

After you successfully selected the comment, a blue border will be drawn around it and its properties will be displayed in the Property-Editor.

Creating comments

The only way to create a new comment is to use the toolbar of the Query-Editor.

Use the button "Add comment" from the toolbar in order to append a new comment to your query. The new comment will be appended at the end of the worksheet and can be moved to the desired position afterwards.

Moving and copying comments

Comments can be moved inside a query with drag&drop. First select the comment (by clicking on the free space under its separator line) and move it with the mouse. A blue line indicate valid target positions for the comment.

Copying comments with drag&drop works exactly the same, but you must press the "CTRL" key while moving the comment. The mouse pointer will show a little plus symbol then. When dropping the comment at the target position, a copy of it will be created and the comment does not disappear from its original position.

Deleting comments

There are two different ways to delete a comment, using the keyboard or using the context menu of a comment:

Deleting comments using the the keyboard

In order to delete a comment you can use the "Delete" key. First you must select the comment with the mouse. Then press the "Delete" key to delete the comment.

The system will delete the comment without asking before. If you falsely deleted a comment you can use the "Undo" button from the toolbar to undo the deletion.

Deleting comments using their context menu

Alternatively you can use the context menu of a comment to delete it. Select the comment first and open its context menu with the right mouse button. Then use the menu item "Delete comment" to delete the comment.

Changing the comment-text

Change the text in the worksheet

The text of a comment can be changed directly on the worksheet. Click onto the text and edit it afterwards. When you stop editing (e.g. by selecting another element of the worksheet) the changes will be stored in the comment.

Changing the text property

Alternatively you can change the comment text by editing the property "Text". Since this property always contains a constant string, no formula is accepted for this property.

Computing the comment text

Instead of displaying a constant text you can use also use a formula for the computation of comment text. This formula must be stored in the property "Formula" of the comment.

The computed text of a comment (defined with the property Formula) is used instead of the constant text defined with the property "Text".

Deactivating the export of comments

The properties Copy To Result and Export determine whether a comment will be transferred into a Snapshot (Copy To Result) or PDF or Excel output (Export). Set the appropriate property to "false" to prevent a comment from being transferred.

The context menu for comments

Comments offer, as mentioned above, a context menu. This menu only allows to delete an existing comment.

instantOLAP

Online documentation, Version 2.2.7, 16.01.2007