Editable cells with background color still printing white?

Discuss the spreadsheet application

Editable cells with background color still printing white?

Postby kwutzke » Thu Sep 13, 2018 6:25 pm

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
OpenOffice 4.1.5 on Windows 10
kwutzke
 
Posts: 8
Joined: Wed Nov 11, 2009 5:29 pm

Re: Editable cells with background color still printing whit

Postby Zizi64 » Thu Sep 13, 2018 7:36 pm

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8546
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Editable cells with background color still printing whit

Postby kwutzke » Sat Dec 08, 2018 1:27 pm

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
OpenOffice 4.1.5 on Windows 10
kwutzke
 
Posts: 8
Joined: Wed Nov 11, 2009 5:29 pm

Re: Editable cells with background color still printing whit

Postby Zizi64 » Sat Dec 08, 2018 1:45 pm

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.)
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.3.3; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8546
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: No registered users and 49 guests