Jump to content

Comments in Calc

From The Document Foundation Wiki

Foreword

The video "Insert comments in Calc - LibreOffice" shows how comments are inserted and edited in Calc.

It links to this page here, which contains further information and details.

Link to the Video

Link to the Video (in German [DE]):

"Kommentare einfügen in Calc - LibreOffice

Insert comments

To work with the comment functions, open Calc and here in the example the working file "Comments_in_Calc.ods".

Note:
A blue arrow leads from a visible comment field to the cell, in which the comment was created.

In this way, the relationship between cell and comment is always visible.

Insert a comment in a cell

Now add a comment to a cell.

Right-click on the cell that you want to add a comment to.

In the menu that appears select Insert Comment.

A yellow field appears, this is the comment field.

The cursor flashes in the comment field.

You can now directly write the desired comment.

E.g. write: "I am currently writing my comment".

Show existing comments

The cells with a small red square in the top right (Example: ) already have a comment.

If you move the mouse pointer to such a cell, the comment of the cell is displayed.

Display comment permanently

Comments can also be displayed permanently.

This is done by right-clicking on such a cell and a context menu opens.

There you can select Show Comment.

Then the comment is now displayed permanently.

Edit comments

You can now edit the comment field and the comment.

Formatting comments directly

Direct formatting is carried out using the “Formatting” toolbar, for example.

This type of formatting is not recommended.

Click with the right mouse button in the cell and select Show Comment.

Then you click with the right mouse button in the cell and select Edit Comment.

The cursor now blinks in the comment field.

You can carry out your desired formatting.

Mark the text and choose the font, e.g. Noto Sans, and font size 16.

Exit the comment by clicking on an empty cell or with the Esc key.

Formatting comments with styles

The styles are located in the sidebar (F11).

Styles always contain so-called packages of properties (font, font color, background, transparency, etc.), which you can change according to your wishes and then assign to comment fields, for example.

To format comment fields, you need the drawing styles in the sidebar.

Newly inserted comments are always assigned the “Note” drawing style.

In the document KommentareInCalc.ods you will find examples with some drawing styles.

Example Comments in Calc
Example Comments in Calc

You can also create your own drawing styles.

You can find out how to create drawing styles in the Calc manual - Chapter 05 - Format styles and document templates.

To assign drawing styles to the comment fields:

Click on the edge of a comment to select it.

Now double-click on the desired drawing style in the sidebar.

The comment field will adopt the properties.

If you are working with styles, the objects (in this case the comment fields) must not be directly formatted in any way.

To delete the direct formatting of a comment field, select the comment field and choose Format > Delete direct formatting from the menu,
(Ctrl + M).

Drag comments larger or smaller

Click on the edge of a comment to highlight it.

The comment field now has 8 handles on the outer edge.

Click-hold-drag one of these handles to make the comment field larger or smaller.

When the comment field is the desired size, release the mouse button.

Move comment field

To be able to move a comment field, it must be displayed permanently.

You click in the comment field so that it is marked.

The cursor now has the shape of a four-way arrow (here in yellow).

The comment field can be moved with click-hold-drag.

Hide comment

If the comment is not to be displayed permanently, you can right-click in the cell and select Hide comment.

Delete Comment

Click with the right mouse button in the cell and select Delete Comment.

Further information

Work files

Start file:

"Comments_in_Calc.ods"

File with additionally inserted comment:

"Edited_comments_in_Calc.ods"

Documentation / Manuals

Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?

For questions on this topic go to:

Ask.LibreOffice

Get Involved

Join us today and help us to make it even better!

Get Involved

LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.