|
| |||||||
|
|
Office² turns the iPhone or iPod Touch into a professional word processor and spreadsheet editor, allowing you to easily view, create and edit Microsoft Word (.doc) files and Microsoft Excel (.xls) workbooks. WORD PROCESSOR FEATURES
Office² supports the use of tables, making it possible to edit existing tables and create new ones. It integrates with Sheet², allowing you to select a range of cells in a spreadsheet stored in Sheet² and then paste them into Office² as a table. Inline pictures Office² lets you insert pictures into your document. You can either copy a picture from a web page using Safari and paste it into your document, or you can insert a picture from the Photo app. Copying and pasting Office² uses the standard iPhone copy and paste architecture. Text may be copied from one part of the document and pasted to another. Alternatively, text may be copied from another application, which supports copying and pasting, and then pasted into Office². 
Accessing documents in the cloud Office² lets you transfer documents to and from your MobileMe iDisk, and will let you open and view documents stored on the iDisk. You can also create folders and organize your files by moving or copying them between the folder structure of your iDisk.  Additionally Office² will let you open and view the documents stored in your Google Docs account. You can create folders directly within your Google Docs space and you can transfer documents to and from the Google Docs account. |
|||
|
SPREADSHEET FEATURES Office² provides all the features you need to create a professional looking spreadsheet. It features a standard grid, which may be scrolled and zoomed. Text, numeric or date values or formulas may be entered into the selected cell through the formula bar at the top of the screen.  Cell Formatting Cells may be formatted using the format pages, which let you specify the font style, borders, text and background colors, the size of cells and text alignment within the cells.    Cells may be set to a specific type, so that they may be displayed appropriately. By default, each cell is of type General. This means that the way the cell is displayed is automatically determined. If you wish to change the way certain cells are displayed you can do so using the Cell Type page. 
When a type is selected, the user is presented with additional options for formatting the selected cells.
For example, if the Number type is selected, the user may also choose the number of decimal places to show, how to display negative numbers and whether or not to use the 1000 separator, when displaying larger numbers. The following cell types are supported:
Multiple WorksheetsOffice² provides support for multiple sheets within a workbook. When you press the worksheet button, worksheets are presented in a horizontally scrollable page, allowing you to quickly flick between all the worksheets in the workbook. A worksheet may be selected simply by tapping on it. You can create new worksheets and delete or rename existing worksheets. You can also create cross-sheet formulas and copy and paste between sheets. Searching and Sorting Office² provides the ability to search the worksheet for any phrase, number or other text, letting you easily scroll between search results. It is also possible to sort a range of cells by any row or column. Import/Export Spreadsheets may be transferred onto and off the phone, over a wi-fi network, using Windows Explorer (on a PC) or Finder (on a MAC) or any web browser. Spreadsheets may also be emailed, as attachments, from within the Office² application. Office² exports all workbooks in XLS format. It can import workbooks in either XLS format, XML Spreadsheet format or CSV format. It is compatible with the following desktop spreadsheet applications:
Integration with Google Docs and iDisk 
Office² can access spreadsheet files stored in Google Docs, MobileMe iDisk and other WebDAV-based servers. By simply
entering the user credentials for the relevant service, you can turn on the ability to access files in these remote folders.
Office² will let you copy or move spreadsheet files to and from Google Docs and iDisk folders and the iPhone local storage. Alternatively, you can directly open and edit spreadsheet files in these remote folders. Changes that you make may then be saved directly back to the remote spreadsheet file. Office² also enables you to create folders in either Google Docs or iDisk and move files between these folders. Unlike the wi-fi import/export function, a wi-fi connection is not necessary. You can access spreadsheets in Google Docs and iDisk straight over the 3G cellular network. iPod Touch devices, however, will need a wi-fi connection, giving them access to the Internet. Functions Office² supports the most popular functions used in other desktop spreadsheet applications. These include: Date/time DATE, DATEVALUE, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, YEAR Financial FV, NPER, PMT, PV, RATE General COLUMN, COLUMNS, COUNT, COUNTA, COUNTBLANK, COUNTIF, ERROR.TYPE, HLOOKUP, INDEX, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISREF, ISTEXT, MATCH, N, NA, ROW, ROWS, T, TYPE, VLOOKUP Logical AND, FALSE, IF, IFERROR, NOT, OR, TRUE Math ABS, CEILING, EVEN, EXP, FACT, FLOOR, INT, LN, LOG, LOG10, MAX, MIN, MOD, ODD, PI, POWER, PRODUCT, RAND, ROUND, ROUNDDOWN, ROUNDUP, SIGN, SQRT, SQRTPI, SUM, SUMIF, SUMPRODUCT, TRUNC Statistical AVEDEV, AVERAGE, AVERAGEA, LARGE, MEDIAN, MODE, NORMDIST, SMALL, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA String CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, TRIM, UPPER Trignometry ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, COMBIN, COS, COSH, DEGREES, PERMUT, RADIANS, SIN, SINH, TAN, TANH |
