scale to fit in PRINT DIALOG

Is there a way to scale to fit in the print dialog? Does anyone know where this is and how to save these? The settings seem to be splayed across Numbers, Layout and Paper Handling Tabs and I really wish they had put this together in a more straightforward way.


This dialog drives me nuts when I have two printers and a jillion pieces of software that I am printing out of.


Is there a way to scale a numbers spreadsheet to FIT onto 8 x 11 or 8 x 14 or 11 x 17 inch paper? I often need to print the SAME DOCUMENT out on different paper sizes and I can't seem to find a scale to fit in the print dialog that works.


I am using an HP 8500 and a HP 1700.


Thanks.

Posted on Oct 3, 2011 12:54 PM

Reply
18 replies

Oct 3, 2011 1:14 PM in response to Wayne Contello

Thank you Wayne.


I am coming from PC and have been struggling with this since I bought my mac a year and a half ago. Somehow between numbers being very different from Excel and the printer drivers (??) being produced by mac instead of hp means I am doing a lot of wrestling.


For instance the buttons on my HP 8500 don't work and HP says I need to talk to mac which seems very silly.


Anyway, I am trying to hook up my large format HP1700 printer which can do up to 12 x 18 paper and this seems to still be an issue.


Do you know why I have to click "Scale to fit paper size" BEFORE this dialog gives me an option to pick a paper size other than 8 x11? I /have/ to click in here /before/ I can choose 11 x 17 or 12 x 18 or whatever.


Also, do you know what "Scale down only" is for or what it does?


Lastly, is "Legal" 8 1/2 x 14 and is Tabloid 11 x 17 and if so do you know how I set a custom size such as 12 x 18 or even something else...?


Thank you.

Oct 3, 2011 1:27 PM in response to hotwheels22

I think you are thinking of things different than the Numbers devlopers.


You should enable Page view using the menu item or the key combination <CMD>+<OPT>+p and scale the content in document:

User uploaded file

User uploaded file


Change the paper size in the document inspector.


Some of the printer settings are specific to YOUR printers and they may, or many not, be available in mine. The only scale down check box generally indicates you do not want the drive to make the content larger to fit the page but you do want it to shrink the content if it is too big to fit

Oct 3, 2011 1:34 PM in response to Wayne Contello

HI Wayne.


Many thanks. This is really time for me to solve. It is like poking a stick at a cat at this point.


Yeah. So this is so stupid. They want me to manually scale my document by sliding this slider to and fro so that it is too small and then - oh - too big and then - oh - too small and then - er OK, we'll call that just right.


And then what?


Now I print.


Now I don't want to have to do this all over again and simply want to print this document at the exact same size or - say - I have a similar document or even a similar TAB in this document that I want to print so the text is the same size.


I mean this slider business is completely independent from and Page Setting in the Print dialog that I would have saved isn't it?


Thanks!

Oct 3, 2011 1:54 PM in response to Wayne Contello

Thanks Wayne.

But - it sticks like this so when I go back to print on the SAME PAPER SIZE it is still scaled to fit by using the slider? I mean can I save this settings somewhere?


Also, how do I change paper size?


Do I go out into the print dialog, change the paper size to a new paper size and then go back in and scale it with the slider again?


Can you just walk me through how that works? I have not gotten it yet at all...

Oct 4, 2011 8:24 AM in response to Wayne Contello

Hi Wayne,


Thanks for your help with these issues. I have been meaning to tackle them for a long time and it is a little bit like shaving in the car while driving 60 MPH down I35 through downtown sometimes.


A. Can I just please ask you what step 2 means? What does setting the size in Numbers mean exactly? I have gotten to the point where I understand how to create a new tab (which seems like it allows me to print this info on another page). Is there more to it than this?


B. I guess there is also some Preview Option in numbers that lets me see where the page breaks are going to be and where I can insert additional paragraph returns if I want something to print on another page within the same tab?


C. Can you please just quickly break down for me how I go about /changing/ the print size of a document? I don't get this at all but I do oftentimes want to print the same document on 8 x 11 or 11 x 17 or 12 x 18 both in terms of how it will look and in terms of what stage in the process I am at (i.e. quick black and white to 8 x 11 to edit and proof and then 11 x 17 to send to someone to review and then 12 x 18 in color for me to have as a final presentation or a final proof...).


THANK YOU. THANK YOU. THANK YOU.

Oct 4, 2011 8:41 AM in response to hotwheels22

A) Means settle on the FINAL paper size early. If the final output is an 8x12, select Tabloid extra. Fundamentally I doubt the real size changes once you get into a doc.


B) Show Print view will show you haw Numbers is going to break your document into individual sheets of paper.

to enable this select the menu item "View > Show Print View"

User uploaded file



C) I can explain in general terms because I do not have the same printer(s) as you.

Once you set the actual print size (as descussed in A) you can print the document by using the menu item "File > Print..."


In the print dialog there is a menu which contains specific items regarding this print event (not others just this one). Select the item "Paper Handling"


User uploaded file

Here you can select tthe destination paper size once you check the box "Scale to fit paper size".

Oct 19, 2011 10:35 AM in response to Wayne Contello

Hi Wayne.

Thanks.


I think what I am missing at this point is how I go ahead and /change/ the print size from - say - 8 x 11 to paper that is - say - 11 x 17. I have a document now that has ten Sheets (i.e. tabs) and I want to print each of these Sheets (with from 1 - 50 pages on each) onto 11 x 17 paper INSTEAD of the 8 x 11 paper that I printed them out on to review it all.


I will print these on the HP 1700 which holds this size paper (whereas the HP 8500 does 8 x 11 only).


Is there a way to do this?


Can I do it by setting a pulldown?


I mean, I don't want to have to get into /each/ sheet in this document /every/ time I need to print to another paper size and /manually/ scale the slider to 34 or 35 or 36 or 37 percent. Also, it is a little annoying to have to run this little slider manually partly because it involves a lot of labor but also because it is very hard to get it set to the same size that you set it for in the Sheet before (which is formatted the same) but also because I'd really just like my documents to print the same size each time and not be controlled by some manual slider.


Am I missing something? Can I set the SHEET PRINT STYLE as some kind of Printer Default by SAVING IT and then pulling down to this next time I print? Do you follow?


THANKS!


Jon

Oct 20, 2011 3:44 AM in response to hotwheels22

Hello

If you don't want to apply the trials scheme every time, you may use these scripts.


The first one allows you to grab the exact scale value which you defined one by the trials scheme.


--{code}

--[SCRIPT get_Scale_value]

(*

Here the code is in it's extended shape to show the way I got the infos allowing me to build it


Yvan KOENIG (VALLAURIS, France)

2011/10/20

*)

property workInProgress : false

(*

true = activate the instructions grabbing informative infos

false = drop the instructions grabbing informative infos

*)

on run

local the_window, previewIsActive, currentValue

tell application "Numbers" to activate

tell application "System Events" to tell application process "Numbers"

set the_window to name of first window whose subrole is "AXStandardWindow"

tell windowthe_window

if workInProgress then class of every UI element

(*

{button, button, button, splitter group, pop up button, pop up button, static text, color well, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, checkbox, menu button, button, button, menu button, pop up button, image, static text, tool bar, button, image, static text, grow area}

*)

tell first splitter group

if workInProgress then class of every UI element


--> {splitter group, splitter, splitter group}

if workInProgress then class of every UI element of first splitter group


--> {scroll area, splitter, scroll area, scroll area} not for us !

if workInProgress then class of every UI element of last splitter group


--> {splitter group, splitter, scroll area} It's ours !

tell last splitter group

if workInProgress then class of every UI element


--> {splitter group, splitter, scroll area}

tell first splitter group

if workInProgress then class of every UI element


--> {scroll area, scroll area}

if workInProgress then class of every UI element of first scroll area


--> {text area, scroll bar}


class of every UI element of last scroll area

(*

--> {UI element, scroll bar, scroll bar, UI element, UI element, pop up button, button} it's ours but don't show Preview

or

--> {UI element, scroll bar, scroll bar, UI element, UI element, pop up button, button, slider, group} it's ours showing Preview

*)

set previewIsActive to result contains slider

end tell -- first splitter group

end tell -- last splitter group

end tell -- first splitter group

end tell -- Window


(*

If needed, trigger "Show Preview before Print" *)

if not previewIsActive then

tell menu bar 1 to tell menu bar item 9 to tell menu 1 to click menu item 1

end if

tell window the_window to tell first splitter group to tell last splitter group to tell first splitter group to tell last scroll area

repeat

if (get class of every UI element) contains slider then exit repeat

end repeat

set currentValue to get value of first slider


--> 0.456789

end tell

end tell -- System Events


set the clipboard tocurrentValue as text


activate

if my parleAnglais() then

display dialog "The scale value : " & currentValue & " is in the clipboard."

else

display dialog "L’échelle : " & currentValue & " est dans le presse-papiers."

end if

end run


--=====


on parleAnglais()

local z

try

tell application "Numbers" to set z to localized string "Cancel"

on error

set z to "Cancel"

end try

return (z is not "Annuler")

end parleAnglais


--=====

--[/SCRIPT]

--{code}


Store this scale value in a safe area to be able to reuse it.

The next time you will want to reuse the same setting, run the second script and type the scale value.

The script will apply this exact value to the document.


--{code}

--[SCRIPT set_Scale_value]

(*

Yvan KOENIG (VALLAURIS, France)

2011/10/20

*)

if my parleAnglais() then

set maybe to display dialog "Type the scale to apply" default answer (0.456789 as text)

else

set maybe to display dialog "Saisir l’échelle à appliquer" default answer (0.456789 as text)

end if

set the_scale to (text returned of maybe) as number


tell application "Numbers" to activate

tell application "System Events" to tell application process "Numbers"

set the_window to name of first window whose subrole is "AXStandardWindow"

tell window the_window to tell first splitter group to tell last splitter group to tell first splitter group

set previewActive to class of every UI element of last scroll area contains slider

end tell -- Window

if not previewActive then

tell menu bar 1 to tell menu bar item 9 to tell menu 1 to click menu item 1 --Show Preview before Print

end if

tell window the_window to tell first splitter group to tell last splitter group to tell first splitter group to tell last scroll area

set value of first slider to the_scale

end tell

end tell -- System Events


--=====


on parleAnglais()

local z

try

tell application "Numbers" to set z to localized string "Cancel"

on error

set z to "Cancel"

end try

return (z is not "Annuler")

end parleAnglais


--=====

--[/SCRIPT]


Yvan KOENIG (VALLAURIS, France) jeudi 20 octobre 2011 12:44:27

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community



Oct 21, 2011 3:58 PM in response to KOENIG Yvan

Hi Yvan,


Thank you very much.


I am just about getting everything else taken care of so that I can take a look at scripts. Before recently this would be too difficult.


Can I please ask you if there is a good place to read up on these?


Are there different types of scripts in Mac?


I have heard of Automator and I have used a download that simply asked me to drop some files in - I think it was a Print or Pages or something - folder. Dragging and dropping into a folder was quite easy obviously.


Is this a script that I copy and paste into a text editor such as TextWrangler and then save as a txt file or is there some other way to try these?


Thank you.

Oct 22, 2011 3:37 AM in response to hotwheels22

(1) Applications > Utilities > AppleScript Editor.app

Double click the app.

You will get :

User uploaded file

(2) from my message, copy the first script : start from the 1st --{code} to the 2nd one

and paste in the AppleScrtpt Editor window.

You will get :

User uploaded file

(3) Click the Compile button (the one whose icon is a hammer)

You will get :

User uploaded file

(4) Save it as get_Scale_value.scpt

User uploaded file

(5) same process with the 2nd script :

User uploaded file

I will post an other message explaining how you may activate the Scripts menu.


Yvan KOENIG (VALLAURIS, France) samedi 22 octobre 2011 12:37:39

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community



Oct 22, 2011 5:01 AM in response to KOENIG Yvan

(1) When the Script editor is running,

trigger the menu AppleScript > Preferences > General

Set the different items like that :

User uploaded file


(2) From the Finder, enter the User Library folder ( option key pressed + Go To to reach this hidden folder)

then create the subfolders Applications and Numbers which you may see below :

User uploaded file


It's in this subfolder that you will store the two scripts.

When Numbers is active, triggering the Scripts menu will give :

User uploaded file

The scripts stored in the Numbers subfolder will appear as new Numbers features.

Here I selected set_Scale_value but some rows above is get_Scale_value.


Yvan KOENIG (VALLAURIS, France) samedi 22 octobre 2011 14:00:50


iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.0

My iDisk is : <http://public.me.com/koenigyvan>

Please : Search for questions similar to your own before submitting them to the community

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

scale to fit in PRINT DIALOG

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.