Currently Being ModeratedJan 25, 2013 1:44 PM (in response to BigTarantula99)
Hi, thanks for this.
However the original excel spreadsheet needs to be sent to ipad (in any format, I'm not too bothered) but I need to then have the ability to fill in the certificate on ipad and then save to a PDF, ready for emailing to client. Please let me know if you have any suggestions.
Currently Being ModeratedJan 25, 2013 1:53 PM (in response to Bdjohnson23)
Unless you can recreate it into Numbers for iPad, you will probably have to export as PDF right from Excel. Why does it "need to be sent to iPad"? Was there a problem with Excel or something? Just clarifying...
Currently Being ModeratedJan 25, 2013 1:58 PM (in response to BigTarantula99)
No just for the fact that it enables me to complete certificates on the job rather than having to type them up on Pc when I get home.
Hopefully someone will have a solution, it will be a huge help.
Currently Being ModeratedJan 25, 2013 2:09 PM (in response to Bdjohnson23)
I assume you're using the Email function right from Numbers to email as a PDF. Try this, though I'm not sure if it will help any:
Go to the App Store and download "Adobe Reader". This is an app that gives you full control over PDF files.
When fully installed, go back to Numbers and use the "Open in Another App..." functionality to export the spreadsheet as a PDF and enter it into Adobe Reader. If everything looks fine now, email it right from Adobe Reader. Hope this helps!
Currently Being ModeratedJan 25, 2013 2:25 PM (in response to Bdjohnson23)
I have the same issue. I believe it is the max page size allowed by iOS Numbers being probably smaller than what Mac Numbers allows:
I developed a Logging spreadsheet in Mac Numbers which I want to use to email reports from the road from my iPhone. It looks fine in Mac Numbers as a one-page document; all the Tables are on one Sheet, is 1-page in Print View, etc. If I Export as PDF to my Mac and then open it, it is fine, one page. If I open it in iOS Numbers it looks fine as well. When I export it from iOS Numbers, however, it comes as 4 pages, with overflow parts of Tables on the pages 2-4. What is the maximum "printable" area for a PDF export from iOS Numbers?
I will try reducing my form so it has more margin space to test this, but wonder if anyone has an idea of the max parameters.
Currently Being ModeratedJan 25, 2013 3:02 PM (in response to Bdjohnson23)
Non-sequitur. 1) We want Forms to look right and be layed-out nicely on the page for the client, not all bunched up in the upper-left corner; 2) Apple should have provided the size dimensions for the area you can place stuff on iOS Numbers for PDF 8.5x11, if it differs from Mac Numbers. Someone might know and post this info here.
Currently Being ModeratedJan 25, 2013 8:50 PM (in response to Bdjohnson23)
I might be missing something, but if everyhing shows up on the first page when you export as PDF, but then you have three blank pages, it sounds like the Table has too many rows and/or columns in Numbers. This frequently happens when you import a file from Excel to iPad Pages. Across the top and left side of the table, there will be white bars. If you follow those bars to the end (top bar to the far right/ Left side bar to the bottom), you will see what looks like a button. Click and hold on the button and drag it (up or Left) until it removes the rows/columns that you don't use.
At this point, your table should not have any empty rows of cells. Now try exporting as PDF & see if it looks like you wanted it to.
Currently Being ModeratedJan 26, 2013 1:42 AM (in response to mkral)
I have followed above and changed my excel sheet to 8.5x11 and still finds some empty cells when saving to PDF.
Have also tried to move slide bars as mentioned in last post, there are no empty cells on the sheet but they still appear in the PDF.
Currently Being ModeratedJan 26, 2013 6:22 AM (in response to Bdjohnson23)
BD, you mentioned that you have a copy you could send. If you don't mind, send me a copy at email@example.com, then post a reply on here to let me know. (That's an account I use when I put an addy on the net, but I don't check unless I'm expecting something, to cut down on junk mail). I'd be happy to take a look & see if I can figure anything out. Aside from that, it's hard to think what lse could be causing this.
Currently Being ModeratedJan 26, 2013 8:16 PM (in response to Bdjohnson23)
There were three blank sheet coming across in the PDF. It was a combination of two things.
1. The sheet is a little too wide for 1 page across. This was causing one of the blank pages. You can either shrink it a bit, or else use the option in Excel or Pages to auto-fit it to 1 page by 1 page. In Pages, you find this on the print preview screen, at the bottom right, just make sure Auto-Fit is on, that will shrink the document to fit on a page. In Excel, you can also choose "fit to x pages by x pages. On the Mac version, that option is on the ribbon, on the Layout tab. I'm not at work, so I can't verify where it's at on the Windows version of excel, but it's there as well. Once I clicked that on excel, it saved the doc to 94% size & it got rid of the one extra blank page.
2. The other two pages are showing up because you have the sheet you are using, but also Sheets 2 & 3 in that document. Pages has an option "Page Numbers" that is set to on. Not sure if that is by default or is just set that way for your document. Either way, it is causing Sheet 2 & 3 to print out blank, but with a page # in the footer. If you aren't using Sheets 2 & 3, just delete them, that will be the easiest solution. If you do plan to use them, then you need to go into Print preview on iPad Pages, then click the little gear & turn 'Page Numbers' Off. once I did that, it printed to PDF as 1 page, with no blank stuff at the end.
Hope this fixes it for you. Let me know if you stil have problems with it.