At 16:54 18/02/2019 +0000, Alan Pearce wrote:
At 11:36 18/02/2019 -0500, Vince Bonly wrote:
AOO Calc on Windows 10-64bit Home desktop.

I am working in a spreadsheet template, and would like to have all comments displayed on screen. I think there is a method to show all written comments in AOO-Calc sheet. If yes, Is there a way to toggle it off/on?

Right click in cell and providing there is a comment in the cell you will be offered "Show Comments"

No: you are offered "Show Comment" (singular) - not the "Show Comments" (plural) that the questioner is seeking.

There is no way that I can see to toggle on or off the display of comments generally in a sheet or spreadsheet. The option "Tools | Options... | OpenOffice Calc | View | Display | Comment indicator" does this for the small coloured indicator which shows in a cell when a comment is present - and I'm guessing that any such general toggle for the comments themselves would be in the same place if it existed.

A macro which claims to achieve what you require is shown at
https://forum.openoffice.org/en/forum/viewtopic.php?t=35463 .

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to