Show All Comments

["WA.TWORSX via AOL" <wa...@verizon.net>]

Hi Group:

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?

VinceB.



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Show All Comments

[Brian Barker <b....@btinternet.com.INVALID>]

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: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org