The bottom line is that you should only really expect to get. You can switch to another tab or a whole other document in Excel and paste it without a problem. Pasting into Drafts and a note in OmniFocus pasted the data in tab-separated text, which is good. However, most apps accept the data as an image. Pasting into Apple Notes and other note-taking apps gives you an image of a spreadsheet. On a better note, Excel works pretty well with the Files app for iOS.
If you have a file saved to iCloud or Dropbox, you can open it in Excel on the iPad, do whatever you want with it, and then save the changes directly to where the file came from. Excel for the iPad supports collaboration both in the form of comments and real time collaborative editing. Any document that is saved to OneDrive can be shared with someone or many people else so they can view the file.
Comments show up in the document like all other versions of Excel, and the app will send you a push notification when comments come in. These comments of course sync across all devices accessing your spreadsheet. However, it may not keep all the formatting information from an Excel spreadsheet. An alternative solution is to go for a different app, of which there are many, although several dominate the field.
Numbers comes with the Apple ecosystem and is free for every Apple device manufactured from onward. Numbers specializes in spreadsheets and comes with many different templates for spreadsheets as well as the ability to save spreadsheet documents and export them in the Microsoft Excel format.
It also allows you to sync your data across all your Apple devices using iCloud. That way your spreadsheet is always up-to-date no matter what device you open it on. While spreadsheets are handled with the specific Google Sheets app, the application comes as part of the Google Drive suite, which includes Google Docs. The Google Drive app allows you to view online spreadsheets as well as edit them, including those you have shared with others.
With Documents to Go you get plenty of functionality, including the ability to view, edit and store spreadsheets and many other types of documents as well. The Google Docs copy of an Excel spreadsheet will open on the iPad ready for editing. Note that if you haven't converted a Word or Excel file to the Google Docs format beforehand, you can make a Google Docs version by opening the file in Google Docs' read-only mode on the iPad, select and copy the file's entire contents, create a new document or spreadsheet in Google Docs, and paste the content into the blank file.
The results are inelegant to say the least: most of the file's formatting is lost, but at least you can add, delete, and make other changes to its content. While the results are much better when you work on the Google Docs versions on the iPad, your editing options are still limited, as you might expect. For example, you can't change or reformat fonts. You can copy and paste text and cell content, but unfortunately, the pasted material adopts the formatting of whichever cell you're pasting into rather than retaining the formatting of the source.
You can try opening the file in the desktop version of Google Docs rather than the mobile version, but the results are mixed at best. That caveat aside, here are my top picks for editing spreadsheets on an iPad.
In Numbers for the iPad, you can use a full-size numeric keypad plus other handy keys for entering data quickly. This could be a crucial capability for those working with spreadsheets on multiple platforms, especially if they were created by other people. Still, both apps are solid, competent spreadsheet editors. Quickoffice Connect Mobile Suite is an especially touch-friendly spreadsheet editor.
0コメント