Ask Your Question

How to print shaded rows on LibreOffice Calc 3.6 on Windows 8 [closed]

asked 2014-02-24 18:36:39 +0100

LeonardW67 gravatar image

updated 2020-08-20 14:43:50 +0100

Alex Kemp gravatar image

LibreOffice Calc 3.6 running Windows 8

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-19 16:55:56.930014


Please, what do you mean with shaded rows?

m.a.riosv gravatar imagem.a.riosv ( 2014-02-24 23:11:55 +0100 )edit

I alternated rows with fill in shading 10% gray. I looked for print settings and cannot get the file to print the shaded rows. I just prints without the shading. I did set to print cell borders and that worked fine. But no printing shading!

LeonardW67 gravatar imageLeonardW67 ( 2014-02-28 20:28:58 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-02-28 22:43:44 +0100

m.a.riosv gravatar image

There some options about print in Menu/Tools/LibreOffice/Print, or maybe you have selecting to print in Black&White in the printer driver. If being only 10% it is not printer, you can try with a shadow at least 60% and see if it is printed, if yes, perhaps not a B&W issue.

image description

edit flag offensive delete link more


It is possible that 10% gray is barely (or not at all) perceptible as different than white when printed. Have you tried applying the "Yellow" Format/Autoformat to the range you're trying to print (it has alternating rows). If that prints, you can create a custom autoformat by setting up a small section (at least 4rows by 4 columns) the way you'd like, select/block the section, go to Format/Autoformat and select Add.. The custom autoformat will be available for any table you wish to apply it to.

Edward gravatar imageEdward ( 2014-02-28 23:45:03 +0100 )edit

answered 2014-02-24 23:19:14 +0100

Alexander Wilms gravatar image

updated 2014-02-24 23:21:44 +0100

I assume you mean alternating row colors?

  1. Create two cell styles
  2. Select area that should be formatted
  3. Format > Conditional formatting > Condition
  4. Select "Formula is" and type =MOD(ROW();2)
  5. Select the cell style
  6. If you want a second color, add another condition
  7. Select "Formula is" and type =NOT(MOD(ROW();2))
  8. Select the cell style
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-02-24 18:36:39 +0100

Seen: 478 times

Last updated: Feb 28 '14