1) Freeze panes
2) Sort on any/all columns
3) Create a new Excel file (it'll save as an .xls file)
I've got my app hooked up to my Dropbox account (and to my desktop). Using both ways, I was easily able to access my file. If you don't want to use Dropbox, or sync it to your desktop, there's always e-mail...
Docs2go WILL let you work on Excel files and import/export files to/from your iPad.
Thanks for the info Marilyn. The latest embarrasing news from here is that the spreadsheet in Office2 does allow you to freeze panes. I figured it out last night.
Does the spreadsheet in Documents To Go allow you to perform fills, ie, drag right or down to fill a row or column with sequential data? That's a useful function that I'm finding myself missing in Office2 at the moment.
As far as I can tell, no, D2G doesn't have the drag-to-fill function. It can copy quite well, but not that. Bummer - 'cause I like it too.
However, as far as I've been able to research, QuickOffice doesn't have this function either. Guess maybe it's a bit too complex for these mini/quasi Microsoft apps? Maybe one day, one will ...
Yeah, I'm willing to bet that Numbers can't do it either.
If you choose a text field it just duplicates the entry.
That's interesting twerppoet.
1) Can you fill with a number without automatically incrementing?
2) Can you fill with numbers that increment by multiples other than 1, eg, 3, 6, 9 etc?
3) Can you fill with incrementing dates?
Yes to all three, though it took me a while to figure out and a slight interface quirk almost made me give up before I figured it out.
It will increment dates just fine.
To change the increment, enter the first two numbers of the desired increment in adjacent fields. Then with both fields selected do a fill.
To get the pop-up menu that lets you fill, you first select the field or fields you want. Then you tap and hold until the menu shows up. The quirk, if you don't hold for at least a second after the menu shows it goes to entry mode. Or sliding your finger off the field before releasing seems to work too.
Also, when you select a date field and accidentally go into entry mode, it resets the field to blank and you have to reinter the date. Very annoying, until you learn to just hold the tap a little longer.
A little more playing around in Numbers shows that it can freeze both row and column headers. While not as versatile as freezing entire panes, it should be very useful.
Just select the header row or column you want by tapping opposite of it on the gray bar. Tap on the info icon, circle with an i in it, and choose the Headers tab. Here you can set the number of header rows and/or columns as well as freeze them. I'm not sure if selecting the header first is necessary, but because you can have multiple spread sheets on the same Number's page you need to at least make sure the sheet you want is selected.
And you can set a Footer Row here as well, though I'm not exactly sure what that will do. Haven't experimented with it yet.
Edit: Removed link to iWorks tutorials. They were for the full OS X versions. I'll look to see if I can find the iPad equivalent.
Last edited by twerppoet; 01-13-2011 at 03:51 PM.
Noticed there is actually an attendance templet in iPad Numbers. It brings up another advantage. While freezing headers is nice, wouldn't be even nicer to be able to just go do a quick form, add the date, and then scroll though a check list?
Yep, you can do this. Numbers is the only spreadsheet I know on the iPad that gives you a form entry option.
Unfortunately the export to excel format converts the checkboxes to True False or at least that's what I see when I re-import it to Numbers on the iMac. I don't have Excel to play with. I'm downloading OpenOffice as I type this, to check how it works there.
Ok, I've put some pictures and the exported spreadsheet on iDisk. Here is the public link.
BTW, the export looks terrible in OpenOffice.