Introduction

Sheet² is a Microsoft Excel compatible spreadsheet for the iPhone or iPod Touch. It combines ease of use with many of the standard features you would expect in a desktop spreadsheet, including: cell formatting, searching, multiple worksheets, merged cells, freeze panes, over 140 spreadsheet functions and a lot more. It also provides integration with Google Docs and MobileMe iDisk accounts and many other cloud based services. Sheet² supports the Excel 97-2003 (*.xls) format.

Additionally, Sheet² lets you use your iPhone or iPod Touch for storing and viewing files or for transferring files between two computers. It is capable of viewing files of many different types in addition to documents and spreadsheets. This includes PDF files, presentation files (PPT), image files (BMP, GIF, JPG etc), movie files (.MP4) and many other different formats.

Using Sheet², you can access your iPhone or iPod Touch just like you would a network drive from either Windows Vista, Windows XP or a Mac. You can copy files to and from the device simply by dragging and dropping files from within Windows Explorer or Mac Finder. Your iPhone or iPod Touch simply needs to be available on the network via its wi-fi capability.

Furthermore, Sheet² will let you access files stored in cloud based servers, such as MobileMe iDisk and Box.net and will let you access documents and spreadsheets stored in a Google Docs account. In both cases, you may transfer files to and from the device from the cloud-based store. You may also create folders and organize your files within the cloud-based store.

You can also copy files to and from the iPhone or iPod Touch from a desktop computer, by connecting the device to a computer running iTunes via a USB cable. See Transferring files using iTunes for more information on this.
Getting started
To start editing your first spreadsheet, first create a new spreadsheet by tapping the (+) button at the top right of the screen. You will then be asked to enter a name for the new spreadsheet.


You don't need to add a file extension. Sheet² will do this for you automatically. Press OK to create the new spreadsheet and start editing.

The user guide is a useful source of information and describes in some detail the full functionality of Sheet². You can access the user guide by pressing the help button in the toolbar. Alternatively, click here to see a list of topics covered.


When you are finished browsing this page and you wish to go back to Sheet², press the Done button in the top right corner of this window.

Creating a new workbook
To create a new workbook, tap the (+) button at the top right of the file list.

You will then be prompted to enter a name for the new workbook.


You don't need to add a file extension. Sheet² will do this for you automatically. Just enter a name. You can choose to show or hide file extensions from within the settings. A blank workbook will open. To start editing the spreadsheet, select the cell you wish to change and press the keyboard button at the top right of the screen.

When you have finished making changes, either close Sheet² and your changes will be saved automatically, or press the Close button at the top left of the window. Sheet² will prompt you to save or discard your current chanages. Press the Save button to save your changes.

Opening an existing workbook
To open an existing workbook for editing, tap on the relevant workbook name in the list of workbooks.


The workbook will then be loaded ready for you to start editing. Sheet² can open workbooks with a .xls extension, a .xml extension or a .csv extension. If you try to open a file with a .xlsx extension, it will be opened for viewing only.

Opening a workbook email attachment
If you have received an email containing a .xls file, you may open the .doc file in Sheet² in the following way:

Once the workbook is open in Sheet², you may begin editing it. You will not however be able to save the workbook to its current location. This is because the workbook will have been copied to an Inbox folder (which is created if it doesn't already exist) and this folder is read only. Instead, you must save the workbook to another filename.

Saving a workbook
Once you have finished editing the spreadsheet, press the Close button at the top left of the screen.


If you have made changes to the spreadsheet, you will be prompted to save the changes.


Press the Save button to save the changes. The new spreadsheet file will be shown in the files list.

Compatibility with other programs
Sheet² supports importing XLS (BIFF5 through BIFF8), XML Spreadsheet format and CSV format. When saving a file, the file format will be maintained. For example, if you import and open a .xls file, when you save it, it will remain a .xls file. If you import and open a .xml file, when you save it, it will remain a .xml file.

As a result, Sheet² is compatible with the following programs:

  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

Panning & zooming
You can pan (or scroll) around the worksheet by holding down a finger and dragging the screen, in just the same way that you scroll through your email, except the panning works in two directions. To zoom in to an area, pinch together your thumb and forefinger on the area of the screen that you wish to zoom into and then expand your pinch to change the zoom level. Do exactly the reverse to zoom out. This is exactly the same process that you use for zooming in and out using Safari on the iPhone.

Using an external keyboard
●Note: This only applies to devices running OS4.0 or later.

If you connect an external keyboard to your iPhone or iPod Touch (using either the dedicated iPad keyboard or a bluetooth keyboard), Sheet² will allow you to navigate around the spreadsheet using the cursor keys on the keyboard.

In addition, holding down the Fn key while pressing the cursor up or down keys will page the sheet upwards or downwards, respectively. pressing the Enter key will submit the contents of the formula window into the selected cell and will select the cell below the currently selected cell. Pressing the Tab key will submit the contents of the formula window into the selected cell and will select the cell to the right of the currently selected cell.

Whenever you attach an external keyboard the on-screen keyboard will not be shown, giving you more room on the screen to edit the spreadsheet.

Entering a value into a cell
To enter a value into a cell, select the cell by tapping on it. Then click in the formula bar located at the top of the screen. The keyboard will appear, allowing you to enter the value that you wish to attribute to the cell. Once you have entered the value into the formula bar, press the Done key on the keyboard in order to transfer the value to the cell.

Alternatively, once you have entered a value into the formula bar, you can simply select another cell and the previously selected cell will be updated with the contents of the formula bar.

If the formula you wish to enter is long, it may be easier to enter the formula into a larger field. You can do this by double clicking on the cell, whose formula you wish to enter. Doing this will display an Edit Formula window, allowing you to see the entire formula as you type it.

Selecting a range
You can select a single cell by tapping on the cell. Similarly, you can select an entire row or column by tapping on the relevant row or column header, but to select a range of cells you must first select a cell to define one corner of the rectangular range of cells that you wish to select, by tapping on the appropriate cell. Then press and hold down on the cell that will define the opposite corner of the range. After one second the range will be selected, allowing you to perform any functions that involve a range of cells.

Another way to select a range is by double tapping and on the second tap, hold down and drag to define the range. Either method works well, but the first method is more convenient if you have a large range to select.

If you wish to select several rows or columns, select the first row or column (as appropriate) and then press and hold on the last row or column (as appropriate). After one second the range selection will be made.

Quick formatting
It is possible to quickly set the font of a cell, row, column or range of cells, to be bold or italic. To do this, select the range of cells whose format you wish to change and press either the bold button or the italic button, located in the toolbar at the bottom of the screen. The format of the cells will change accordingly.


You can quickly add borders to a cell, row, column or range of cells. To do this, select the range of cells whose border format you wish to change and press one of the border format buttons.

●Scroll the toolbar by two pages (using a swipe gesture) to access this feature

You may choose between no border, top, left, bottom or right borders, an outline border or a full inner and outer borders.


Changing the cell style
Sheet² lets you change the bold or italic format of a cell and also the text color and background color of a cell, or range of cells. To do this, select the appropriate cell or range of cells and show the Cell Styles page by pressing the format button located in the toolbar.


To change the bold or italic formatting of the selected range of cells, press the relevant button in the Bold or Italic row.


To change the text color or the background color of the selected range of cells, press on the Background color or Text color row. Doing this will show the Choose Color page.


Select an appropriate color by sliding the hue slider and then choosing one of the shades by clicking on the appropriate cell.

You can choose black or white from the top row.

If you want to choose "transparent" as your color, for example, if you want to remove all background color from a range of cells, then click on the None cell in the top row.

Once you have selected the appropriate color, pressing the Cell Style button at the top left of the screen will return you back to the Cell Style page, with the selected color showing in the corresponding row.

Pressing Save in the Cell Style page will save the formatting changes and will return you to the worksheet view.

Changing the cell type
Sheet² lets you define cells as a specific type. You can select from the following types: By default, all cells are General type. This means that spreadsheet will interpret how to display the contents of the cell according to the data stored within the cell.

It is possible to enforce a specific display format by changing the cell type. For example, you may wish to display all numbers within a range of cells as dollar values with two decimal places. To do this select the appropriate cell or range of cells and show the Cell Types page by pressing the format button located in the toolbar and selecting the Type button in the tab bar at the bottom of the screen.


Now press down in the Type row. You will be presented with a list of cell types to choose from. Press on Currency. The view will return to the Cell Type page. Further options will appear allowing you to select the number of decimal places that you wish to show and the currency symbol that you wish to show. You can choose from either the dollar, euro, sterling or yen currency symbols.

You may also choose whether the currency symbol preceeds the number or whether it follows the number. Finally, you may choose how to display negative numbers. You have the option of displaying negative numbers with a negative symbol preceeding the number, or instead by showing the number in brackets.


The decimal places and negative numbers options are available if you choose the Number type, however in addition, you may choose whether or not to show large numbers separated by a thousand separator, e.g. 1000,000 instead of 1000000. Pressing Save in the Cell Type page will save the changes and will return you to the worksheet view.

Changing the cell width and height
You may change the size of a cell or a range of cells by selecting the appropriate cell or range of cells and pressing the format button located in the toolbar and selecting the Size button in the tab bar at the bottom of the screen.


You will see two slider controls. The top slider controls the width of the selected cells. Drag the slider to the left to decrease the width and to the right to increase the width.


The bottom slider controls the height of the selected cells. Drag the slider to the left to decrease the height and to the right to increase the height. The preview image below will change to show the new size of each cell in the selected range. Press the Save button to save your changes. If you only want to change the width or height of a single column or row, you may find it easier to do this directly within the worksheet view. For more information, see Changing the width and height of rows and columns.

Changing the cell text alignment
You may change the vertical and horizontal alignment of a cell or a range of cells by selecting the appropriate cell or range of cells and pressing the Settings button located in the toolbar and selecting the Align button in the tab bar at the bottom of the screen.


You will see two alignment controls. The top control lets you choose the horizontal text alignment. You can choose between left, center and right alignment.


The bottom control lets you choose the vertical text alignment. You can choose between top, middle and bottom alignment. Press the Save button to save your changes.

Creating merged cells
Sheet² lets you select a range of cells and merge them into a single cell. When you do this, the contents of all but the top left cell will be cleared. The value of the top left cell will be used as the merged cell's value.


To merge a range of cells, select the appropriate range and press the Settings button located in the toolbar and select the Align button in the tab bar at the bottom of the screen.


Turn on the Merge cells switch and press the Save button. To unmerge a merged cell, select it and open the Align settings and turn off the Merge cells switch and press the Save button.

Wrapping text within cells
Sheet² lets you choose whether or not text is wrapped within a cell or a merged cell.


To wrap text, select the appropriate cell or merged cell and press the Settings button located in the toolbar and select the Align button in the tab bar at the bottom of the screen.


Turn on the Wrap Text switch and press the Save button. You can adjust the alignment of the wrapped text by choosing the appropriate horizontal and vertical alignments from the controls above. To turn off wrapping of text in a cell, select it and open the Align settings and turn off the Wrap Text switch and press the Save button.

Inserting rows and columns
●Scroll the toolbar by one page (using a swipe gesture) to access this feature

To insert a row, select the row above which you want to insert the new row and press the Insert Cells button in the toolbar.


You will be asked to confirm whether you wish to insert a new row. Press the Insert Row button to confirm the action.

You use a similar process for inserting a column, except this time you select the column before which you want to insert the new column. When you press the Insert Cells toolbar button, this time you will be asked whether you wish to insert a new column. Press the Insert Column button to confirm the action.

If you want to insert multiple rows or columns, you must select the appropriate number of rows or columns prior to pressing the Insert Cells toolbar button.

Deleting rows and columns
To delete a row, select the row that you wish to delete and press the Cut Cells button in the toolbar.


This will highlight the row you have chosen to delete with a dotted line. Press the Cut Cells button again. You will be asked to confirm whether you wish to delete the row. Press the Delete Row button to confirm the action.

You use a similar process for deleting a column, except this time you select the column that you wish to delete. When you press the Cut Cells toolbar button, this time you will be asked whether you wish to delete the column. Press the Delete Column button to confirm the action.

If you only want to clear the cells in the selected row or column, press the Clear Cells(s) button.

Emptying a range of cells
To empty a range of cells, select the range that you wish to empty and press the Clear Cells button in the toolbar.


You will be asked to confirm whether you wish to empty the cells. Press the Clear Cells button to confirm the action. Only the contents of the cells will be cleared. The cell formatting will remain.

Copying a range of cells
To copy a range of cells, select the range that you wish to copy and press the Copy Cells toolbar button in the toolbar.


This will highlight the range you have chosen to copy with a dotted line. Now select the cell which defines the top left cell of the destination range (this can be in another worksheet within the same workbook). Then press the Paste Cells toolbar button.



The range of values will be copied to the new destination. Any cells containing formulas will have their formulas updated to reflect the new destination.

Moving a range of cells
To move a range of cells, select the range that you wish to move and press the Cut Cells toolbar button in the toolbar.


This will highlight the range you have chosen to move with a dotted line. Now select the cell which defines the top left cell of the destination range. Then press the Paste Cells toolbar button.



The range of values will be moved to the new destination. Any cells containing formulas will have their formulas updated to reflect the new destination.

Jumping to a cell
To goto a specific cell, tap the cell reference area.


A dialog box will appear, letting you type in the exact cell reference that you wish to go to, for example, A500, or BD201.


Press OK to jump to the entered cell.

Sorting a range of cells
●Scroll the toolbar by one page (using a swipe gesture) to access this feature

To sort a range of cells, select the range that you wish to sort and press the Sort button in the toolbar.


This will show a screen allowing you to choose the direction of the sort, i.e. left to right or top to bottom, the column or row by which to sort and whether the sort is ascending or descending.



Once you have chosen the relevant options, press the Sort button at the top right of the screen.

Searching cells
●Scroll the toolbar by one page (using a swipe gesture) to access this feature

Sheet² lets you search cell values and formulas for instances of specific text characters. To search cell values or formulas for occurrences of text, press the Search button in the toolbar.


The Search dialog box will appear. You can enter the search text into the top field. You can choose whether to search for cells containing, beginning with or ending with your search text. You can choose whether to search the cell value AND formula, or the value only or the formula only. You can also choose whether or not the search should consider the case sensitivity of the search text.


When you have chosen the relevant options, press the Search button. Sheet² will scroll to the first cell matching your search criteria. The toolbar will change to show a Next button and a Cancel button. Pressing the Next button will scroll to the next matching cell. When you are finished, press the Cancel button.

Changing the width and height of rows and columns
Sheet² lets you change the width of a column or the height of a row from directly within the worksheet view. To change the width of a column, tap and hold on the relevant separator line in the column header. Two arrows will then appear. As soon as they do, with your finger still held down, drag your finger left or right to change the width of the column accordingly.


The same process may be used to change the height of a row. Tap and hold on the relevant separator line in the row header and drag to change the height.

Using the Sum button
You can sum a series of cells very quickly by using the sum button, which is located in the toolbar.


To sum a range of cells, select the cell where you wish the result to be shown. Then press the Sum button in the toolbar. Sheet² will try to intelligently select the range of cells that it thinks you wish to sum. If this selection is correct, press the Done button on the keyboard. If it is not correct, tap on the formula bar and manually change the cell range that you wish to sum and press the Done key.


Using the Function button
You can enter any of the standard functions directly into the formula bar using the keyboard, however you can select a function for applying to a cell, or a series of cells, very quickly by using the Function button, which is located in the toolbar.


To specify a function, select the cell where you wish the result to be shown. Then press the Function button in the toolbar.

For certain functions that apply to ranges of cells, Sheet² will try to intelligently select the range of cells that it thinks you wish to apply the function to. If this selection is correct, press the Done button on the keyboard. If it is not correct, tap on the formula bar and manually change the cell range that you wish to associate with the function and press the Done key.

Some other functions require you to enter parameters. If you use the Function button to enter these functions, Sheet² will enter placeholders for the parameters, which you can then replace with actual parameter values.

For a list of available functions, click here.

Using the Freeze Panes feature
●Scroll the toolbar by one page (using a swipe gesture) to access this feature

You can freeze a row, column or area of the worksheet so that it remains fixed, when the worksheet is scrolled. For example, you would freeze panes to keep row and column labels visible as you scroll.




To unfreeze a row, column or area, click the cell A1 and press the Freeze Panes button.

When you press the Freeze Panes button, Sheet² will also lock the initial scroll position. For example, if the worksheet is scrolled such that column D is the leftmost column showing in the view, applying the Freeze Panes function will lock the initial scroll offset at column D, meaning that you will not be able to scroll to cells before column D without unfreezing the panes first.

Full screen view
●Scroll the toolbar by one page (using a swipe gesture) to access this feature

If you want to maximize the amount of screen space for showing a spreadsheet, you can hide the row and column headers and the navigation bar. To do this, press the Full Screen button in the toolbar.


To re-show the row and column headers and the navigation bar, press the Full Screen button again.

Multiple Worksheets
Sheet² allows you to view and manage multiple multiple worksheets within a particular workbook. To view or manage worksheets, press the worksheet button in the toolbar.


The worksheets will appear in a horizontally scrollable view, allowing you to flick between each worksheet.


You can select to view a worksheet, by scrolling to it and then tapping on the middle of the screen, or pressing the Done button. If you wish to create a new worksheet, press the Edit button and then press the New Sheet button, which will appear in the toolbar. You will be prompted for the name of the new sheet. Press OK once you have entered the name. The new worksheet will be created and Sheet² will view it, ready for you to start editing.

You can rename a worksheet by pressing the Edit button and then pressing the Rename Sheet button, which will appear in the toolbar. You will be prompted for the name of the new name. Press OK once you have entered the name. The sheet will now be renamed.

You can delete a worksheet by pressing the Edit button and then pressing the red button to the top left of the worksheet. You will be prompted to confirm the deletion. Press OK to permanently delete the worksheet. Note, you will not be able to delete the worksheet if it is the last worksheet in the workbook.

Organizing spreadsheet in folders
Sheet² lets you organize your spreadsheets into folders. You can create a new folder by pressing the New Folder button in the toolbar at the bottom of the screen.


After pressing the button you will be asked to enter a name for the new folder.


Choose a suitable name and press OK. Once the folder has been created, you can move or copy spreadsheets to and from folders. See Copying a spreadsheet or Moving a spreadsheet for more information.

To open the folder you have just created, you simply tap it. The folder will open, showing any spreadsheets or sub folders that it contains. In the case of a new folder, it will contain nothing initially. You may transfer spreadsheets into the folder.


Copying a spreadsheet
Sheet² lets you copy spreadsheets from one folder to another or to another name within the same folder. To copy a spreadsheet, start by tapping on the Organize button in the toolbar at the bottom of the screen.



The toolbar will change to show a Move button, a Copy button and a Cancel button. Select the spreadsheet (or spreadsheets) that you wish to copy, by tapping on each spreadsheet in turn.



A tick will be shown against each selected spreadsheet. Then press the Copy button. You will be asked to choose a destination folder.



The top-most level folder is shown initially, giving you the opportunity to choose either a local folder, or a remote folder, such as a folder located in Google Docs or on your MobileMe iDisk. To copy the spreadsheet locally, tap on Local Files and tap on the relevant sub folders until you have located the desired destination folder.



To copy the spreadsheet to the chosen folder, press the Choose "folder" button in the toolbar. To cancel the operation at any time, press the Cancel button in the top right of the screen. If you selected a destination folder, which is the same as the source folder, the spreadsheet name will be changed to original spreadsheet name_Copy.
Moving a spreadsheet
Sheet² lets you move spreadsheets from one folder to another, regardless of whether the folder is a local or remote folder, such as a folder located in Google Docs or on your MobileMe iDisk. The process is exactly the same as if you were copying a spreadsheet, except you press the Move button rather than the Copy button.



The only difference between moving a spreadsheet and copying a spreadsheet is that when moving a spreadsheet, the spreadsheet is deleted from the source folder, after it has been copied to the destination folder.
Deleting a spreadsheet
To delete an existing spreadsheet (or spreadsheets), start by pressing the Delete button in the toolbar.



Then select one or more spreadsheets from the current folder. Select the spreadsheet that you wish to delete, by tapping on each spreadsheet. Finally, press the red Delete button in the toolbar.

Emailing a spreadsheet
Sometimes, you may want to email someone a spreadsheet that you have stored on the iPhone. To email a spreadsheet, tap on the disclosure button to the right of the relevant spreadsheet name.


A new window is shown containing an Email File button. Press the Email File button. The familiar email compose screen will appear.


Enter an email address for the recipient, or press the plus button (in the To: field) to select a recipient from the address book. If you want to type in multiple recipients, press return after you have entered each email address. Enter a subject and optional body. Then press the Send button.
Renaming a spreadsheet
If you want to change the name of a spreadsheet, first tap on the disclosure button to the right of the relevant spreadsheet name in the list of spreadsheets.


Then tap the name of the spreadsheet as shown in the image below:


The keyboard will then appear, allowing you to change the name of the spreadsheet. You do not need to add .doc to the end of the spreadsheet name. Its original file extension is automatically appended. When you have changed the spreadsheet name, press the Done button at the top right corner of the screen in order to rename the spreadsheet.
Setting a passcode
If you want to prevent other people from viewing the files in Sheet², you can set a four digit passcode that must be entered everytime the app is opened or switched to. To passcode the app, open the Settings page and turn on the Passcode lock switch. You will be asked to enter a four digit number and then to confirm the number, by entering the same number again. Once you have done this, the next time you open Sheet², you will be prompted to enter the four-digit number.


If someone has attempted to open Sheet² and entered an incorrect number, you will be shown the number of failed attempts in this screen since the last successful passcode entry.

Transferring files using iTunes
When you connect the iPhone or iPod Touch via the USB cable to your desktop computer (running iTunes), you will have the ability to copy files to and from the Sheet² app. Once the device is connected, select the device from the left-hand window in iTunes. In the right-hand window, choose the Apps tab and scroll to the bottom of the Apps window. At the bottom of the page you will see a section entitled "File Sharing". In the left part of the window, you will see one or more apps that are capable of synchronizing files with iTunes. Sheet² should be listed. Select Sheet² and you will see a list of the top level files and folders that exist in Sheet². You can copy files from Sheet² by selecting the relevant file or folder from the list and pressing the Save To... button. You can then choose a destination folder on your desktop computer. Press OK to start copying files from the device to your desktop computer. You can also copy files from the desktop computer to the device. To do this, press the Add... button under the list of files and then choose one or more files from your desktop computer and press OK. As soon as you press OK, the device will show that it is synchronizing and when it is finished, the files that you added will appear in the Local Files folder at the top level.

Transferring files over wi-fi
Using Sheet², you can access your iPhone or iPod Touch just like you would a network drive from either Windows Vista, Windows XP or a Mac. You can copy files to and from the device simply by dragging and dropping files from within Windows Explorer or Mac Finder. Your iPhone or iPod Touch simply needs to be available on the network via its wi-fi capability.

To copy files to and from the iPhone from a desktop computer, you will need to know the connection address (or IP address) of the phone. This will vary, depending upon which network you are connected to. Provided you are successfully connected to a network, then you can find out the connection address by starting the application, pressing the Settings button (the leftmost button in the toolbar), turning on File Sharing and making a note of the address shown just under the File Sharing switch.


Once the Sheet² application is started, you may connect to the phone either from a web browser, or by accessing the phone as a drive from within Windows Explorer or the Finder application (or indeed any WebDAV client).

Using Windows Explorer in Vista
  1. Find out the iPhone's IP Address as described in the Transferring files over wi-fi
  2. Press the Start button and select Computer
  3. Press the Map network drive button in the toolbar.
  4. Enter the IP address, for example, http://{ip address}:8080 into the field and press OK.
A new window will appear showing the list of files that are stored on the iPhone.

Once you can see the files in a new window, you can copy and paste files to and from the iPhone and the desktop computer. Ensure that the iPhone does not turn itself off while you are trying to access its files.

Using Windows Explorer in XP
  1. Find out the iPhone's IP Address as described in the Transferring files over wi-fi
  2. Press the Start button and select My Network Places
  3. In the left hand margin, press Add a network place.
  4. In the wizard that appears, press Next. In the following page, select Choose another network location and press Next.
  5. Enter the IP address, for example, http://{ip address}:8080 into the field and press Next. Then in the final page, press Finish.
A new window will appear showing the list of files that are stored on the phone.

Once you can see the files in a new window, you can copy and paste files to and from the iPhone and the desktop computer. Ensure that the iPhone does not turn itself off while you are trying to access its files.

Using Finder on a MAC
  1. Find out the iPhone's IP Address as described in the Transferring files over wi-fi
  2. Open the Finder application
  3. Select Connect to server.. from the Go menu, or press Command-K
  4. Enter the IP address, for example, http://{ip address}:8080 into the field and press Connect.
A new Finder window will appear showing the list of files that are stored on the iPhone.

Once you can see the files in a new window, you can copy and paste files to and from the iPhone and the desktop computer. Ensure that the iPhone does not turn itself off while you are trying to access its files.

Using a Web Browser
  1. Find out the iPhone's IP Address as described in the Transferring files over wi-fi
  2. Enter the published address, for example, http://{ip address}:8080 into the browser and press Enter. A web page will appear showing the list of worksheets residing on the phone.
  3. Either click on the relevant file link to open the file in the appropriate application or, alternatively, right click (shift click on MAC) and select Save Target As and save the file to the local disk on your desktop computer.


To upload a file to the phone, press the Browse button, select the appropriate file and press the Submit button.
Troubleshooting the Connection

The pre-requisite to connecting to the iPhone in order to copy files to and from the phone is that you are able to "see" the iPhone on the network. First, open the Sheet² app, press the settings button (the cog button at the far left of the toolbar) and make a note of the connection address which will appear under the File Sharing switch when you turn on file sharing. The connection address takes the following form:
http://{ipaddress}:8080
Once you have the connection address then make a note of the ipaddress portion of the connection address. Then open a command window (cmd.exe on a PC or the Terminal app on a MAC) and type the following:
ping {ipaddress} [followed by Enter]

where {ipaddress} should be replaced with the actual IP address that you noted. Do you get successful responses? If not then your dekstop PC will be unable to connect to the device in order to transfer files over the local network. You can either try to resolve the problem, possibly by rebooting your router, or you may prefer to setup a Google Apps account or a MobileMe iDisk account and transfer files over the 3G network, rather than over the wifi network.

Integrating with cloud storage services
Sheet² can integrate with a number of cloud storage services. This means that you can connect to your favourite online file store and edit and manipulate your spreadsheets and documents right from within Sheet². Additionally you can view many other different types of files that you store in these online file stores. Sheet² can connect to the following cloud services:
  • Google Docs
  • Dropbox
  • MobileMe iDisk
  • Box.net
  • MyDisk.se
  • iCloud
  • any generic WebDAV server
To configure access to a particular cloud storage provider from within Sheet², press the Back button in the toolbar at the top of the file list. (The file list pane is shown when Sheet² is landscape orientated).

Press the Edit button, which then appears at the top of the file list. You can then select Add Service from within the file list. This will enable you to choose from all the available cloud services.


Choose the service that you wish to configure. You will then be given the opportunity to enter the credentials for the service that you have chosen. Once you have entered your credentials (login name and password), press Save. Then press Done at the top of the File list. A new top level folder will appear representing that file store. Tapping on this folder will show the top level files in your chosen file store.


Once you have connected to the remote file store, you may transfer files to and from the remote file store and the local files folder by copying or moving the files in the normal way.

If you wish to connect to a remote file store that is not listed in the above list of file stores, then provided the remote file store supports the WebDAV protocol, you may specify "Other WebDAV" when choosing the type of service and you can enter the specific server address and port number for the service. Ask your service provider for the details that you need to enter.

For instance, you could create an "Other WebDAV" service to connect to another iPad, iPhone or iPod Touch running Sheet² (with file sharing turned on). This would allow you to access the files on the other device from your own device.


Settings

Various settings let you control how Sheet² behaves. You may access the settings by pressing the Settings button from the main screen.


The settings that may be changed are as follows:

Enable File Sharing
You may control whether or not Sheet² allows any form of wifi access to its files by enabling or disabling the File Sharing option. By default, this option will be on, which will mean whenever you start Sheet² , it will begin listening for incoming connections from Windows Explorer, Mac Finder, a web browser or any WebDAV enabled client. Sheet² will remember the selection between sessions.

Sharing Security
If you wish to secure Sheet² so that anyone connecting must specify a username and password, set the Require Password switch to ON and enter a suitable username and password. Windows Explorer, MAC Finder and web browsers will subsequently require a user to enter this username and password before allowing connection to Sheet².

Enable Sleep
Normally, if you don't interact with your iPhone or iPod Touch, it will auto-turn off after a couple of minutes. This is useful for saving battery power, but not so good if you are transferring a large file to or from Sheet² . For this reason, Sheet² prevents the device from auto-sleeping by default. You can change this, such that the device will sleep after the usual period of no interaction by setting Allow Sleep to ON. If you do so, you should understand that any file transfers you make when the device auto sleeps may be lost or corrupt.

Viewing Options
- Show File Extensions: Turn this on if you wish to show file extensions for each file shown in Sheet².

- Show Invisible Files: If you want to show files that are normally hidden on the desktop, set this setting to ON.

- Show Folders First: If you want to sort the file list so that folders are always shown before files, set this setting to ON.

- Show File Sizes: If you want to show the size of each file, set this setting to ON.