Page 1 of 1

Editable cells with background color still printing white?

Posted: Thu Sep 13, 2018 6:25 pm
by kwutzke
Hello all.

Is it possible in OO Calc to set (editable) cells' background colors to gray, but when printing the background will be white/transparent? (all sheets are protected and have editable and non-editable cells.... many editable ones...)

The point is that I only want to give the user (a true beginner) some hint as to where she can edit cells (rather like a comment) and when she is finished the print output is plain white/transparent.

Is it possible?? If so, how?

Karsten

Re: Editable cells with background color still printing whit

Posted: Thu Sep 13, 2018 7:36 pm
by Zizi64
Is it possible in OO Calc to set (editable) cells' background colors to gray, but when printing the background will be white/transparent?
- Try Tools - Options - OpenOffice - Appearance - General - Document background (select a color). It will be appeared on the srceen only.

- Or adjust the Default Cell Style temporarly: Set the background color of the cells to the desired color, and then reset, when you want to print the document.

Re: Editable cells with background color still printing whit

Posted: Sat Dec 08, 2018 1:27 pm
by kwutzke
Hello,

I don't want to set the background color for ALL cells, but only for some.

I want to highlight the editable cells for a novice user, so they can see which cells she can edit. This is for an invoice sheet, so when finally printing it, the cell colors SHALL NOT BE PRINTED, of course.

Is this possible??

Karsten

Re: Editable cells with background color still printing whit

Posted: Sat Dec 08, 2018 1:45 pm
by Zizi64
I don't want to set the background color for ALL cells, but only for some.

I want to highlight the editable cells for novice users, so they can see which cells she can edit. This is for an invoice sheet, so when finally printing it, the cell colors SHALL NOT BE PRINTED, of course.

Is this possible??
- You can use a light shade of a light color (very-light-yellow) for the cells to edit (that will give a little difference to the white on a B&W printer,
- Or you can use the Conditional formatting feature with a control cell as switch (between two user defined cell styles "ForEditing", "ForPrinting") adjust the two styles as you want, and switch between the formatting states by a "data validity" featured control cell.)