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
Editable cells with background color still printing white?
Editable cells with background color still printing white?
OpenOffice 4.1.5 on Windows 10
Re: Editable cells with background color still printing whit
- Try Tools - Options - OpenOffice - Appearance - General - Document background (select a color). It will be appeared on the srceen only.Is it possible in OO Calc to set (editable) cells' background colors to gray, but when printing the background will be white/transparent?
- 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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Editable cells with background color still printing whit
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
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
OpenOffice 4.1.5 on Windows 10
Re: Editable cells with background color still printing whit
- 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,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??
- 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.)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.