Bug 90669

Summary: Feature Request:Monochrome printing from Calc
Product: LibreOffice Reporter: HD <kg_ooohelp>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: marina.latini, mgb1508, miguelangelrv, raal, Widzowcz
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
Whiteboard: VOTE
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103309    
Attachments: Attached sample pic
Draw feature

Description HD 2015-04-17 06:27:21 UTC
Created attachment 114849 [details]
Attached sample pic

Feature Request:
I request the additional of the same features as the "black-and-white print" of Excel.
For example,if you set the "black and white" from the print properties, the background color will be printed in gray.
I want to print with no background color.

Best regards.
Comment 1 raal 2015-04-17 16:08:57 UTC
Created attachment 114865 [details]
Draw feature

Valid enhancement, provide feature as in Draw
Comment 2 Marina Latini (SUSE) 2015-10-01 16:21:24 UTC
Added a vote here: https://wiki.documentfoundation.org/Vote_for_Enhancement#Votes_-_Calc
Comment 3 Gabriele Ponzo 2015-10-01 22:43:55 UTC
+1 for me, also here:
https://wiki.documentfoundation.org/Vote_for_Enhancement#Votes_-_Calc
Comment 4 Marina Latini (SUSE) 2015-10-05 08:00:35 UTC
Set:
* version to "inherited from OOo"
* hardware "All" "All"

Whiteboard: "VOTE"
Comment 5 Zibowsky 2024-03-19 13:21:09 UTC
If it would be possible to revive this request, this would be a very useful feature for Libreoffice Calc .

I migrated from MS and this is an essential function in a spreadsheet program for me to allow for visual formatting that does not print when the document is printed. Under page setup in the document, there is a checkbox for printing the document in black & white that allows only simple black text and border to print for a clean document.

The current method of doing this is either manually configuring a printer system wide to print in monochrome, but this still prints grey backgrounds and other formats. Currently I am just saving the document as a copy and manually changing all formatting to black text, white background, and removing conditional formats. This works but it is cumbersome.

If anyone would be willing to work on this it would be greatly appreciated!

Thanks!