Thank you very much
Jeff
----- Original Message -----
From: "Steven P. Ulrick" <[email protected]>
To: <[email protected]>
Sent: Tuesday, February 24, 2009 5:46 PM
Subject: Re: [users] Re: Removing 0 from lines left blank
Hello Jeff
I think this should work:
1. Select the following menus: "Format | Styles and Formatting"
2. The window that comes up should have two little icons near the top,
on the left hand side. As you hover over them with your mouse pointer,
you will see that one is named "Cell Styles" and that the other is
named "Page Styles" Click the one named "Page Styles"
3. You will see two choices, "Default" and "Report" Right click on
"Default"
4. You will then be given the choices "New" and "Modify" Choose
"Modify"
5. On the window that opens up, click the tab named "Sheet"
6. Uncheck the "Zero values" box that is located in the "Print" section.
7. Click "OK"
8. Select the following menus: "File | Templates | Save"
9. Make sure that the choice that is selected in the "Categories"
column is "My Templates"
10. In the box underneath the words "New template" type something like
"default-userdefined" and then click "OK"
11. Then follow the following menus "File | Templates | Organize"
12. Double Click on "My Templates"
13. Right click on the template that is named whatever you happened to
name it in step 10.
14. On the menu that comes up, choose "Set as default template" and
then click "Close"
15. Close OpenOffice.org.
16. Open up a blank OpenOffice.org spreadsheet. If you go to "Format |
Page | Sheet", "Zero values" should still be unchecked.
This will work fine IF you were creating new spreadsheets.
Unfortunately, I JUST tried the following experiment and it failed:
1. Set the default template for spreadsheets to have the "Zero value"
box unchecked.
2. Checked to see that that worked as expected. It did. So far so
good...
3. Opened up a spreadsheet of my own creation that I had just checked
before this experiment, and it had the "Zero value" box checked.
"Unfortunately", when I opened up my old spreadsheet, OpenOffice
respected the settings that I was using way back when I created the
spreadsheet.
The above steps WOULD work for you if you could possibly get the
person/people that send you spreadsheets made in OpenOffice.org to make
the changes that I described in this message. If fact, if they are
willing, and they can't make my instructions work for them, let me know
and I can try to work with them off list
Thank You,
Steven P. Ulrick
On Tue, 24 Feb 2009 13:59:48 -0500
"Jeff Luttrell" <[email protected]> wrote:
Thank You so much that worked, do you know if there is a way to make
the software keep that change for all documents?
Thanks again, Jeff
----- Original Message -----
From: "Steven P. Ulrick" <[email protected]>
To: <[email protected]>
Sent: Monday, February 23, 2009 8:06 PM
Subject: Re: [users] Re: Removing 0 from lines left blank
> 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]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
16:46:00 up 1 day, 2:01, 1 user, load average: 0.40, 0.32, 0.36
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
