|
| |||||||
|
Sheet² 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 WorksheetsSheet² 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 Sheet² 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 Sheet² application. Sheet² 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 
Sheet² 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.
Sheet² 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. Sheet² 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 Sheet² 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 |