Versions

Initial release	Oct 5, 2009
Current version (5.0.1)	Jan 25, 2012

Average rating for the current version

United States    Display more Countries

Average rating for all versions

United States    Display more Countries

Screenshots

Sheet² is a spreadsheet app, which lets you create and edit XLS format spreadsheets on your iPhone or iPod Touch. It is compatible with Excel, Numbers and any other XLS-based Spreadsheet program.

GOOGLE AND MOBILEME INTEGRATION

Sheet² works seamlessly with Google Docs, allowing you to directly view and edit the spreadsheets that you store in your Google Docs account.
Not only is this a great way of transferring spreadsheets to and from Sheet², it also means that you can manipulate the same spreadsheets both
on the iPhone and from within your web browser.

If you are a MobileMe user, you can use Sheet² to access spreadsheets stored on your iDisk, either by opening them and editing them directly on your
iDisk or copying them from your iDisk and editing them locally.

Sheet² may also be mounted as a drive from Finder (on a MAC) or Windows Explorer, or from a web browser on any platform.

GENERAL FEATURES

● View, create, edit and save spreadsheets in .XLS format.
● Compatible with Excel, Numbers, NeoOffice.
● Portrait and landscape views.
● Handles multiple worksheets.
● Handles unlimited rows and columns.
● Searching and sorting of cells.
● Cell formatting, including bold, italic, borders, text and cell color, alignment, text wrapping.
● Cell types, including General, Number, Currency, Percentage, Date, Time, Date/Time and Text.
● Merge cells feature.
● Pane freezing.
● Copy and paste within and between worksheets.
● Tap and drag to change row heights and column widths.
● Intelligent auto range selection for range based functions.
● Tap cells to compose formula.
● Insert, copy, paste or cut cell ranges, rows or columns.
● Date formats, date separators and numeric separators are all handled correctly according to the current locale, with manual override. Out of all the iPhone spreadsheets, only Sheet² does this correctly!

ORGANISING SPREADSHEETS

● Access spreadsheets stored in Google Docs, iDisk and any WebDAV server, including open, edit, save, delete and rename.
● Create or delete folders.
● Move or copy spreadsheets between folderslocally
● Move or copy spreadsheets between Google Docs or iDisk accounts and the local folders.
● Move or copy spreadsheets within folders in Google Docs or iDisk accounts.
● Email spreadsheets as attachments.
● Print spreadsheets wirelessly (iOS4.2 and later).

FUNCTIONS

● Financial Functions - FV, NPER, PMT, PV, RATE

● Mathematical Functions - 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

● String Functions - CHAR, CLEAN, CODE, CONCATENATE, DOLLAR, EXACT, FIND, LEFT, LEN, LOWER, MID, PROPER, REPLACE, REPT, RIGHT, SEARCH, SUBSTITUTE, TRIM, UPPER

● Statistical Functions - AVEDEV, AVERAGE, AVERAGEA, LARGE, MEDIAN, MODE, NORMDIST, SMALL, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP, VARPA

● Trigonometric Functions - ACOS, ACOSH, ASIN, ASINH, ATAN, ATAN2, ATANH, COMBIN, COS, COSH, DEGREES, PERMUT, RADIANS, SIN, SINH, TAN, TANH

● Date/Time Functions - DATE, DATEVALUE, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TIMEVALUE, TODAY, WEEKDAY, WEEKNUM, YEAR

● Logical Functions - AND, FALSE, IF, IFERROR, NOT, OR, TRUE

● General Functions - 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

● Base Conversion Functions - BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX