Softalk Home
Messaging
MESSAGING SOLUTIONS
Outlook
OUTLOOK COLLABORATION
Productivity
PRODUCTIVITY SOLUTIONS
     HomeProductsDownloadsPurchaseSupportMediaBlogCompanyContact
 OverviewMore InfoFeaturesSupport  
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, 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:
  1. General
  2. Number
  3. Currency
  4. Percentage
  5. Date
  6. Time
  7. Text


Multiple Worksheets
Spreadsheet 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
Spreadsheets may be transferred onto and off the phone 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 Spreadsheet application. Spreadsheet 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:

  1. Excel 97 for Windows
  2. Excel 2000 for Windows
  3. Excel 2002 for Windows
  4. Excel 2003 for Windows
  5. Excel 2007 for Windows
  6. Excel X for MAC
  7. Excel 11.0 for MAC
  8. Excel 12.0 for MAC
  9. NeoOffice v2
  10. NeoOffice v3
  11. Numbers 1.0
  12. Numbers 2.0
  13. OpenOffice Calc 1.0
  14. OpenOffice Calc 2.0

Functions
Spreadsheet supports the most popular functions used in other desktop spreadsheet applications. These include:

Date/Time functions

DATE, DATEADD, DATEDIFF, DAY, DAYABBREV, DAYNAME, HOUR, LASTDAY, MINUTE, MONTH, MONTHABBREV, MONTHNAME, NOW, SECOND, TIME, TODAY, WEEKDAY, WEEKNUM, YEAR

Financial functions

FV, NPER, PMT, PV, RATE

General functions
COLUMN, COUNT, HLOOKUP, ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, ISTEXT, ROW, VLOOKUP

Logical functions
AND, FALSE, IF, IFERROR, NOT, OR, TRUE

Math functions
ABS, CEILING, EVEN, EXP, FACTORIAL, FLOOR, INT, LN, LOG, LOG10, MAX, MIN, ODD, POWER, PRODUCT, ROUND, ROUNDDOWN, ROUNDUP, SQRT, SQRTPI, SUM, SUMPRODUCT, TRUNC

Statistical functions
AVERAGE, MEDIAN, MODE, NORMDIST, STDEV, STDEVA, STDEVP, STDEVPA

String functions
CLEAN, CONCATENATE, FIND, LEFT, LOWER, MID, RIGHT, SEARCH, TRIM, UPPER

Trignometry functions
ACOS, ASIN, ATAN, COS, COSH, DEGREES, PI, RADIANS, SIN, SINH, TAN, TANH




     PrivacyTerms of useEnglishDeutschEspañolFrançaisItaliano