Having described the document management features of iSpreadsheet, this section describes how to work with the spreadsheet view.
You can move around your spreadsheet using simple gestures; sliding your finger horizontally across your device’s screen scrolls columns, vertically scrolls rows.
At the top of the spreadsheet is a data entry text field, along with the button that, when tapped, shows the save options described earlier in this document.
At the bottom of the spreadsheet is the tool bar. The icons displayed on the tool bar depend on whether you have selected a cell, row or column.
To enter data in a cell, tap the required cell to highlight it, then tap the text entry field at the top of the screen.
Enter the data using the keyboard that slides up, then either tap the button, or tap another cell.
To delete the contents of a cell, tap the required cell then tap the button in the text entry field.
To apply formatting to a cell, tap the cell to highlight it, then use the icons in the tool bar at the bottom of the spreadsheet:
Tap the bold icon to toggle bold on/off.
Tap the italic icon to toggle italics on/off.
Tap the text color icon, then tap the required color.
Tap the fill icon, then tap the required color.
To copy and paste the contents of one cell to another, first tap a cell to highlight it.
Tap the copy icon in the tool bar.
Tap the cell in which you want to paste the copied data, then tap the paste icon in the tool bar.
To insert a row or column, first highlight either a row or column by tapping the column letter or row number, then tap the insert icon in the tool bar.
To delete a row or column, first highlight either a row or column by tapping the column letter or row number, then tap the delete icon in the tool bar.
Tap a column to highlight, then tap the column width icons in the tool bar to make the selected column wider or narrower.
Formulae can be applied to a by tapping a cell then tapping the formula icon in the tool bar.
The following formulae are available:
COS |
SUM |
TAN |
ASIN |
SQRT |
SINH |
ACOS |
ATAN |
SQR |
LOG |
SIN |
TANH |
EXP |
After taping the formulae icon, a list of the above functions is displayed. Tapping a function name in this list displays a description and usage of the function.
To apply the formula to the selected cell, tap the button.
The function name is populated in the text entry field at the top of the spreadsheet. Complete the formula in accordance with the usage information provided on the previous screen.
Note: If the format of your formula is entered incorrectly, the cell is populated with .
© 2008 Savy Soda Pty Ltd. All rights reserved.
Information in this document is subject to change without notice.
Reproduction in any manner whatsoever without the written permission of Savy Soda Pty Ltd is strictly forbidden.
Savy Soda disclaims any proprietary interest in trademarks and trade names other than its own.