Bug 47050 - Calc: Shown comments should not print and export if print/export comments unchecked
Summary: Calc: Shown comments should not print and export if print/export comments unc...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
Reported: 2012-03-07 05:46 UTC by Nicolas Mailhot
Modified: 2023-10-31 06:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Mailhot 2012-03-07 05:46:48 UTC
Comments are here to help people fill spreadsheets and usually should not be printed

1. The user should not have to hide comments manually before printing
2. They should not print by default 
3. Comment artifacts (arrow parts) should not bleed in printed cells when the comment itself is situated outside the print zone
4. it should be easy to toggle the print status of comments for a whole document

Excel 2007 does it right : calc forms are printed without arrow bits
Comment 1 sasha.libreoffice 2012-05-30 07:14:22 UTC
Thanks for new idea
in 3.5.3 disabling of printing comments not implemented yet

Workaround: File->Export as PDF, remove option "Export Comments", then print resulting pdf file
Comment 2 bfoman (inactive) 2012-08-08 12:01:23 UTC
Confirmed with:
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Edited summary according to http://wiki.documentfoundation.org/BugReport
Comment 3 Timur 2018-06-07 15:50:39 UTC
Bug rule is: one issue per report. 

1. and 2. are probably the same. 
Print-Comments is off by default but it doesn't behave well. 
We have both Format-Page-Print-comments and Export as PDF - Export comments and we have comments shown/hidden possibilities. 
When comments are hidden in Calc, comments options in both print/export seem to work fine. Comments are not seen and they are added as PDF comments in export. 
But when comments are shown in Calc, unchecking comments options still prints shown comments. That seems wrong. If we have many comments and some are shown and some are hidden, we need that "don't print" comment option means no comments are printed, regardless if they are shown. 
Yes from LO 5.4 we have "show/hide all comments toggle button" but that's something else. 

As for 3. I'm not sure what it means, but it should be reported as a new bug. 
As for 4. that was solved in LO 5.4 with Bug 84837 and Bug 107258.
Comment 4 QA Administrators 2019-06-08 02:53:18 UTC Comment hidden (obsolete)
Comment 5 Timur 2019-11-14 18:02:55 UTC
Same in Lo 6.5+.
We lack comments option in new print dialog from LO 5.3, same as in the old.
Comment 6 Meagan Hane 2019-11-23 11:05:34 UTC Comment hidden (spam)
Comment 7 Kaitlyn 2020-02-18 09:25:13 UTC Comment hidden (spam)
Comment 8 Diane Kiton 2020-11-18 16:01:06 UTC Comment hidden (spam)
Comment 9 dossierstate 2023-10-31 06:52:06 UTC Comment hidden (spam)