Export only one sheet of a Numbers spread sheet
MacBook Pro 15.4, iMac 20, iPhone 3G, iPhone 4, iPad, Apple TV, Mac OS X (10.6.6)
MacBook Pro 15.4, iMac 20, iPhone 3G, iPhone 4, iPad, Apple TV, Mac OS X (10.6.6)
Cycles4Fun wrote:
Ivan,
I see no reason to be rude. I asked precise question.
"Is there a way to export just a single sheet of a Numbers spreadsheet?"
Hi I Wish to ask in the same line
which is - I have a excel document which i have imported in my iPAD 2 via numbers app.
this excel document has 10 sheets each labled from 1 to 10 differently.
Now i want to email only sheet number 2 which has only one A4 size information on it.
in this case who do i do the pdf exporting of only the sheet number 2 from my entire excel document.
numbers exports the entire excel file to pdf and attachs the same in my mail app. but i only want the sheet number 2 from my entire set of sheets from my excel document
pls help
Regards
"Hi I Wish to ask in the same line"
Well, the answer, for any document in any application that can access the print dialogue on the Mac, is pretty much the same.
Press command-P to open the Print dialogue, set the page range you want to 'print', click the PDF button and choose one of the options.
You'll get a PDF version of the page(s) you chose to 'print.'
If you're asking about doing this from your iPad, that's a whole 'nuther question and a whole 'nuther community.
You'll find the expert answers for that question here: Using iPad or here: iWork For iOS.
Regards,
Barry
Sorry Barry
U thought this section would answer my question
I shall post again in the using iPad section
For mac I knew but u think the feature is not there for iPad 2 running numbers
It's such a big drawback of numbers as a whole software
"...but u think the feature is not there for iPad 2 running numbers"
Not what I said at all.
This is the Numbers community. Poorly named, as it really handles only the Mac version of Numbers. You can find a few Numbers for Mac experts here, but not many of the people here use an iPad. We don't "think the feature is not there for iPad," we simply don't know whether it is or not. That's why we refer Numbers for iOS questions to the (also poorly named) iWork for iOS community, where there's a better chance of finding someone who does know.
Regards,
Barry
Going through the print dialog is really a workaround. Apple (if you are listening) should really allow for a choice of sheets when exporting from numbers, especially since they have not provided a Print Area option. It is just too easy to erroneously include unintended background calculations.
The export option has the advantage over "printing" to pdf that you do not need to fiddle with your page setup to avoid that your sheet gets chopped up leaving orphan lines or columns on additional pages.
Soren,
So you wish to Save a file in Sheet View to PDF, saving only 1 Sheet...
o Click on the Sheet name in the Sheets Pane and Command-C
o Switch to Preview.app
o Command-N
o Command-S
Jerry
Hi Soren,
Your wrote (numbers added):
"1.Going through the print dialog is really a workaround.
2, Apple (a) (if you are listening) should really (b) allow for a choice of sheets when exporting from numbers, especially since (c) they have not provided a Print Area option.
3, It is just too easy to erroneously include unintended background calculations."
1. I beg to differ. A PDF file is the electronic version of a printed document. When you print, you create a static document on paper. When you 'print' to PDF, you create a static document as a file. The ability to 'print to PDF' is universal—it's available to every application that runs on the Mac and has access to the Print dialogue.
2a. Apple does not actively monitor these user-to-user forums. If you want to suggest this 'feature enhancement,' your best route is through the Feedback channel. Go to the Numbers menu in Numbers '09 and choose Provide Numbers Feedback. Feedback goes directly to Apple.
2b. When you Save a document, you save the entire document. When you Export a document, you export the entire document. The reult is a live' document, not the static one you get by printing or creating a PDF.
2c. Print Area is necessary in an application like Excel, which produces a huge, monolithic table populated by islands of data. The Numbers model differs, allowing for creation of several small, single purpose tables on one or more sheets within a single document. Once that concept is grasped and put to use, there's little if any need for Print Area.
3. True, if you use Numbers as if it were Excel. Much less true as you gain the knowledge of the differences and start using Numbers as its designers intended.
Regards,
Barry
Hey Jerry - I used to use this hack / workaround religiously and appreciate you posting it for others to find. I'm curious if you have tried it on OS X 10.9 and Pages / iWork '13, if not, I would like to prompt you to do so as a couple things have changed:
1) Alpha is not on immediately, this can be turned off when saving
2) Bigger problem is the quality in which Preview.app is presenting the copied content, if you have a large doucment you are "exporting" via this method, it gets pretty gnarly.
Best wishes,
Jordan
Edit: Numbers*, not Pages (sorry)
Export only one sheet of a Numbers spread sheet