You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Edward Fields <ed...@efields.com> on 2012/11/28 19:24:41 UTC
how to scale a worksheet to fill the printed page
OpenOffice 3.1 on Windows Vista
Fit object to paper format check box missing
I'm trying to scale the spreadsheet to fill the printed page, the closest
thing I find in help is
---------
Printing a Slide to Fit a Paper Size
You can reduce the size of a slide when you print, so that the slide can
fit on a printed page.
1. Open the document that you want to print.
2. In Normal View, choose Format - Page, and then click the Page tab.
3. In Layout settings area, select the Fit object to paper format check box.
4. In the Paper format area, select a Format.
5. Click OK. The slide is resized to fit the printed page, while
maintaining the relative positions of the objects on the slide.
------------
however, when print previewing a worksheet, there is no such check box.
How then can one fill a print page with a scaled up worksheet?
sincerely
macduff40
Re: how to scale a worksheet to fill the printed page
Posted by tj <tj...@apache.org>.
On 11/28/2012 20:47, Edward Fields wrote:
> Hi TJ
>
> thanks for responding.
>
> the print function as described does not match my configuration, probably
> because I mistakenly said I was using ver. 3.1,
> I am in fact using 3.4.1, Rev .1372282 according to the About
> OpenOffice.org dialog box
> this is the dialog I get when I select File --> Print
>
> it is this page that I wish to print expanded to maximize print size
> (currently on 1/2 the landscape page, left side is painted)
> [image: Inline image 1]
>
> On Wed, Nov 28, 2012 at 5:36 PM, tj <tj...@apache.org> wrote:
>
>> On 11/28/2012 13:24, Edward Fields wrote:
>>
>>> OpenOffice 3.1 on Windows Vista
>>>
>>> Fit object to paper format check box missing
>>>
>>> I'm trying to scale the spreadsheet to fill the printed page, the closest
>>> thing I find in help is
>>>
>>> ---------
>>> Printing a Slide to Fit a Paper Size
>>>
>>> You can reduce the size of a slide when you print, so that the slide can
>>> fit on a printed page.
>>> 1. Open the document that you want to print.
>>> 2. In Normal View, choose Format - Page, and then click the Page tab.
>>> 3. In Layout settings area, select the Fit object to paper format check
>>> box.
>>> 4. In the Paper format area, select a Format.
>>> 5. Click OK. The slide is resized to fit the printed page, while
>>> maintaining the relative positions of the objects on the slide.
>>> ------------
>>> however, when print previewing a worksheet, there is no such check box.
>>>
>>> How then can one fill a print page with a scaled up worksheet?
>>> sincerely
>>> macduff40
>>>
>>> The Calc User Guide for 3.2 is available on the wiki. You can check the
>> screen shots; if they look the same as what you see, the directions should
>> work, too.
>>
>> <http://wiki.openoffice.org/**wiki/Documentation/OOo3_User_**
>> Guides/Calc_Guide/Printing_**exporting_emailing<http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Printing_exporting_emailing>
>>>
>>
>> Please let us know if this works for you.
>>
>> /tj/
>>
According to the Guide, the interesting list box is not on the print
dialog at all, but rather on the Page style dialog. You might give that
a try. If that's changed, I'm out of answers.
We like to keep stuff like this on the list, so please reply there.
/tj/
Re: how to scale a worksheet to fill the printed page
Posted by tj <tj...@apache.org>.
On 11/28/2012 13:24, Edward Fields wrote:
> OpenOffice 3.1 on Windows Vista
>
> Fit object to paper format check box missing
>
> I'm trying to scale the spreadsheet to fill the printed page, the closest
> thing I find in help is
>
> ---------
> Printing a Slide to Fit a Paper Size
>
> You can reduce the size of a slide when you print, so that the slide can
> fit on a printed page.
> 1. Open the document that you want to print.
> 2. In Normal View, choose Format - Page, and then click the Page tab.
> 3. In Layout settings area, select the Fit object to paper format check box.
> 4. In the Paper format area, select a Format.
> 5. Click OK. The slide is resized to fit the printed page, while
> maintaining the relative positions of the objects on the slide.
> ------------
> however, when print previewing a worksheet, there is no such check box.
>
> How then can one fill a print page with a scaled up worksheet?
> sincerely
> macduff40
>
The Calc User Guide for 3.2 is available on the wiki. You can check the
screen shots; if they look the same as what you see, the directions
should work, too.
<http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Printing_exporting_emailing>
Please let us know if this works for you.
/tj/