|
| |||||||
|
Spreadsheet 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, 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, you are presented with additional options for formatting the selected cells.
For example, if the Number type is selected, you 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 WorksheetsSpreadsheet 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 Spreadsheet 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 XLS spreadsheet files may be transferred onto and off the phone via a USB cable using Windows Explorer or MAC Finder. Spreadsheets may also be emailed, as attachments, from within the Spreadsheet application. Spreadsheet imports and exports all workbooks in XLS format. It is compatible with the following desktop spreadsheet applications:
Functions Spreadsheet 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 |