On Mon, 23 Feb 2009 18:37:41 -0500 "Jeff Luttrell" <[email protected]> wrote:
> I checked this and the 0 value was unchecked, when I checked it to > see what it would do, I could then see the 0's that were going to > print. The problem is that I dont want them there and when I uncheck > it they dont show on the form but they print out on the hard copy. Is > there a way to tell the program to leave the blank lines blank? > > Thanks, Jeff Hello, Jeff Try this: 1. Go to the "Format" menu and select the "Page" menu. 2. Select the "Sheet" tab. 3. In the section of the window that comes up that is labeled "Print", you will see the option "Zero Values" Uncheck that box and click "OK" The reason that I think that this MIGHT fix your problem is that the previous solution that you tried was for what is VIEWED. The fix that I advocate appears to affect what is PRINTED. I hope this helps. Steven P. Ulrick > ----- Original Message ----- > From: "Russell Butler" <[email protected]> > To: <[email protected]> > Sent: Monday, February 23, 2009 4:04 PM > Subject: [users] Re: Removing 0 from lines left blank > > > > Jeff Luttrell wrote: > >> How do I remove the 0 that prints out on forms where the lines are > >> left blank. Please explain it simply. I only use the program to > >> fill out and print forms that are sent to me so I have no > >> knowledge of how to create or edit forms. > >> > >> Thanks, Plumber Jeff > > > > Hi Jeff > > > > If it is a Calc (spreadsheet) form, see the Help under "zero" > > > > Basically, in Tools-Options-OpenOffice.org Calc -View there is a > > checkbox for "Zero." If that is unchecked the 0 value will not > > show. > > > > HTH > > > > Russell -- 19:05:55 up 4:21, 1 user, load average: 0.09, 0.34, 0.36 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
