Comprehensive Spreadsheet editing
Sheet² HD provides a wealth of features for creating and editing XLS format spreadsheets. It features a two-way scrollable, zoomable grid, which can contain up to 65000 rows of data. Cells can contain text, numeric values, date or time values or formulas. You can choose the specific format for certain cell types, for example the number of decimal places used or the currency symbol display. Sheet² HD provides over 140 Excel compatible functions for use when building your spreadsheets.
The spreadsheet editor supports freeze panes and cell merging too - ideal for managing large worksheets. You can style cells by changing the cell text font and size, the text color, the background color of the cell and you can define the cell border style.
Multiple worksheets
Sheet² HD provides support for multiple sheets within a workbook with tabs appearing at the bottom of the window for each worksheet that exists in the workbook.You can create new worksheets and delete or rename existing worksheets. You can also change the order of worksheets, all by using the worksheet tab bar.
Searching & sorting
Sheet² HD provides the ability to search the worksheet for any phrase, number or other text, letting you easily scroll between search results. Searches may include tests for case sensitivity and whole words. It is also possible to sort a range of cells by any row or column.
Intelligent auto-filling
Sheet² HD also supports auto-filling, which makes it easy to populate cells with data based on the data in the currently selected cells. For example, typing "Jan" into A1 and "Feb" into B1 and then filling allong row 1 will cause the entire row to be intelligently filled with the months of the year.
Functions
Sheet² HD supports over 140 Excel compatible functions. These are listed below:
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 |
|
|
With Sheet² HD, you can view, edit and create Microsoft Excel compatible workbooks without being tied to your computer. Sheet² HD gives you the freedom to forget the desktop or laptop computer and edit spreadsheets using just your iPad.
