Ask Your Question

Printing and print preview in black & white only [closed]

asked 2014-03-09 17:14:47 +0200

Pete of Ebor gravatar image

Over the last few years I have created several spreadsheets using MS office 97, and I have used quite a bit of colour-coding and background colouring to make them easier on the eye when in use. One useful feature of Office was that I could specify that print previews and printouts would be in black & white to save colour ink. Is there any way Libreoffice can do this ? I've looked but can't seem to find a way.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 06:37:36.547106

1 Answer

Sort by » oldest newest most voted

answered 2014-03-10 00:54:56 +0200

ROSt52 gravatar image

I would do:
File > Printer set-up > select your printer > Properties > the printer menu opens up; select black&white Doing so the setting sticks with file.

In case I want to print out most of my files monochrome/black&white I would make my printer's default setting to black&white.

The Help function of LibO provides more information:
Help > LibreOffice Help or F1 > Find > Search term "black" > Enter > select Printing in Blac & White"

edit flag offensive delete link more


There is also Tools > Options > LibreOffice > Print > Convert colors to grayscale. This, however, does not affect the Page Preview. Notice the term "Page Preview" instead of "Print Preview" (in some versions of MS Office). It would be a decent feature request to ask for the preview to more closely resemble the actual printout, like in the little preview in the print dialog. Disclaimer: I haven't tested the colour converting feature with an actual printer.

kumiponi gravatar imagekumiponi ( 2014-03-11 21:23:18 +0200 )edit

Alex you've marked this as being the correct solution, but it doesn't apply to LibreOffice CALC! The menu options don't even exist in the latest version of Calc! If LO doesn't support this option, at least tell people so that they can either work around the lack of functionality, or use a product that does.

Canoe gravatar imageCanoe ( 2017-08-16 07:48:18 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-09 17:14:47 +0200

Seen: 4,753 times

Last updated: Mar 10 '14