Insert and manipulating comments in Calc

English
#1

I am gradually moving from Excel 2007 to Libre Calc.

I already have a few problems that need clearing up.

My spreadsheet cells contain inserted Comments. For instance, I will list a month of purchases made with a credit card in order to cross check with statements.

I find that when I view a comment created/inserted in Excel shows the top end in yellow background but the extended lower text in clear and I can see the cells behind.

How do I correct that.

Also, in Excel the Comment box can be expanded length ways and width ways and it can be moved using the mouse.

How do I do that in Libre Calc?

#2

How exactly should it be corrected, or what should the result look like?

Also, in Excel the Comment box can be expanded length ways and width ways and it can be moved using the mouse.

Click on the comment on the page.
It gets 8 small square handles, there you go with the mouse on it and click and drag.

Please let us know your operating system and the LibreOffice version.

#3

I am currently using Windows 10, (with a view to updating to W11).

That’s the main reason for all my changes!

The version of LibreOffice I’ve installed is 25.2.3.2 (X86-64)

#4

I figured it out - more by accident I think!

Tell me, when I move my cursor over a cell, the comment box appears and at the very top it comes up with Unknown Author, Date and Time.

When you Edit or Show the comment, this does not appear.

What is that all about?

#6

You may want to uncheck the box Comment authorship in Tools ⟶ Options ⟶ LibreOffice Calc ⟶ View (cf. Comment authorship in LO Help).

You may find some clue in tdf#156885 (“add toggle to show / hide authorship metadata in popup Calc comments”).

#7

Had a look at this via your link and following the menu path instructions.

I can’t seem to locate the checkbox for Comment authorship.

Tools-Options-LibreOffice-View
Tools-Options-LibreOffice-View841Ă—709 72.1 KB

Although at the top left of that screenshot I’m not getting “LibreOffice Calc”. I’m getting just “LibreOffice”. I don’t know if it’s that that is holding me back.

I’m nowhere near an expert but Ilearn reasonably quickly!

#8

Good for you!

Calc-specific settings in Tools ⟶ Options are available when its window is active.

Open any Calc document or create a new one (via File ⟶ New ⟶ Spreadsheet) and then go to Tools etc.
â €

ComShip
ComShip903Ă—312 35.9 KB

#9

Got to have a look at this morning.

Yup, that works! I’ve learnt a bit more.

Thanks for the help, and so quick!

#10

Got another one. May be a simple answer.

In Excel if I want say for instance insert a row or a column I just go to the Insert option on the top row menu.

If I want to repeat that I can use Ctrl Y.

In Libre Calc that doesn’t seem to work. Is there shortcut?

#11

Repeat

You might also find Shortcut keys useful.

#12

This isn’t a clarification concerning the original question, but a new, rather unrelated question.
… …
Please

  • Follow the concept of “one thread one question”. The usefulness of a site like this one depends on an easy way for other visitors to learn from already given answers using the search tool (icon: magnifying glass).
  • Consider to study the basics using the published guides from documentation.libreoffice.org. You may download a .pdf from there. Don’t shy back for the many pages. The documentations have an index of contents each, and are searchable anyway. Unfortunately I don’t know a special "Guide to Calc for users coming from Excel"
2 Likes
#13

Sorry about that - I’m relatively new.

#14

No matter. I just tried to advise, not to critisise.

#5

Same in Calc, but only offered for comments (annotations) set to Show (permanently).
Comments only showing when Mouse over are not editabel / changeable via the UI.

Transparency and lots of Area properties, including gradients and images, can be set for individual (visible!) annotations via their context menu by hard attributing.
The recommended way would be to edit the Drawing Style Note which is applied to newly created annotation shapes. You may create other styles inheriting from this one as you like, but will need to assign such a style individually to newly creatred “comments”…

2 Likes
#15

In addition to @Lupp :

Comments in Calc

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.