Frequently Asked Questions

About Quicksheet

Quicksheet allows you to take your files with you & access the iDisk® folder in your MobileMe® account directly from your iPhone® or iPod Touch®. In addition, Quicksheet comes with the FIRST and ONLY true spreadsheet (Microsoft Excel® .xls) editor for the iPhone® and iPod Touch®.

With Quicksheet you can:
• Access your files stored in your iDisk folder
• Download and view files on your iPhone
• Download and save files on your iPhone for faster/offline access
• Upload files from your iPhone to your iDisk folder
• Transfer files from your Desktop to your iPhone
• Edit your files with a true Microsoft Excel (.XLS) compatible spreadsheet editor
• Email files directly from your iPhone

About MobileMe

MobileMe is a service provided by Apple that allows you to keep your email, calendar and contacts in sync. You can access and manage your email, contacts, calendar, photos, and files at me.com. Additionally, MobileMe features iDisk that allows you to store, access and share files online.

For more info, visit:
www.apple.com/mobileme

About iDisk

iDisk, a MobileMe feature, is an online storage repository accessible via a web browser at me.com, Finder on Mac OS X, or as a remote disk in Microsoft Windows.

With MobileMe iDisk, it's easy to store, access, and share files online. You have plenty of storage space - even large files are no problem. Just add the files you need to your iDisk, and whatever you upload will be there for you to download using a web browser on any computer.

For more info, visit:
www.apple.com/mobileme/features/idisk.html

Quickoffice Products Availability

Quickoffice is available as a paid application in the App Store. Click Here to purchase Quickoffice.

Quickoffice Files is available as a paid application in the App Store. Click here to purchase Quickoffice Files.

Quicksheet is available as a paid application in the App Store. Click here to purchase Quicksheet.

Quickword is available as a paid application in the App Store. Click here to purchase Quickword.

Requires iPhone OS 3.0

Quickoffice is available for iPhone and iPod Touch, running iPhone OS 3.0.

You can upgrade your iPhone or iPod Touch to iPhone OS 3.0 using iTunes.

For more information on how to upgrade your iPhone, visit: www.apple.com/iphone/softwareupdate

For more information on how to upgrade your iPod Touch, visit: www.apple.com/ipodtouch/softwareupdate.html

Overview

Quicksheet includes an .XLS & .XLSX compatible spreadsheet processor. You can easily create new spreadsheets & edit spreadsheets created on your PC/Macintosh. No more converting .XLS or .XLSX to .XML or vice versa.

How does it work: Quickoffice (the developer of Quicksheet) has been developing Office applications for the smartphones for the past 12 years. Quickoffice is the leading mobile office application and is shipped on more that 100 million smartphones. Quickoffice has brought its award winning spreadsheet application now to the iPhone.

Supported File Format: At this time, only XLS & XLSX files can be edited using Quicksheet.

Creating Spreadsheets

To create a new spreadsheet, launch Quicksheet and select "On My iPhone". Then press the "New Spreadsheet" icon on the toolbar to launch the spreadsheet processor. The default file format is .XLS, but it can be changed to .XLSX from the settings menu.

Enter data into the cells as you would on your PC/Mac. Once done, press the Back button on the navigation bar. You will be presented with options to save the newly created spreadsheet.

Manage Worksheets

A spreadsheet can contain several worksheets. Now you can add, remove, rename and reorder worksheets easily. Simply press the Worksheets toolbar (insert graphic) and press the Edit button.

• To Add a new worksheet, press:

• To Remove a spreadsheet, press the icon next to the worksheet and press the Delete button.

• To Rename a spreadsheet, tap on the sheet name that you wish to change. This brings the keyboard for you to edit the name.

• To Rearrange spreadsheets, tap and hold the insert graphic icon to make the entry movable. Now drag the entry and place it in the desired location.

Find Text

The find feature allows you to quickly search for every occurrence of a specific word or phrase in the current worksheet.

To use this feature, select Find from the toolbar.

Enter the text or phrase you want to find in the Find bar.

Use the Previous and Next icons on the find bar to navigate through each occurrence of the found text or phrase in the document.

Multiple Options to Modify Cells

Landscape Editing Edit cells in landscape orientation easily.

Simply rotate your iPhone to view the spreadsheet in landscape mode and tap on the cell you want to edit. When you are finished making changes, press the Done button to accept the changes.

Double tap a cell in Portrait mode to make changes to the cell directly in the grid ("Inline Editing").

In Landscape mode, simply tap on a cell to start editing the contents of the cell.

Multi-line Cells - To enter multiple lines in a cell, simply press the return key on the keyboard.

Remember to tap and hold to scroll vertically in the formula bar to view multiple lines.

OS 3.0 Native Cut/Copy/Paste

Quicksheet allows you to use the OS 3.0 Cut/Copy/Paste feature to cut, copy and paste from Quicksheet to another application and vise versa.

Tap and hold a single cell to open the Cut/Copy/Paste dialog and select Copy or Cut.

Navigate to a cell where you want the contents pasted. Tap and hold the cell and select Paste.

Cutting and copying a range of cells is now easier. Simply double-tap and drag to select a range of cells to open the Cut/Copy/Paste dialog, and select Copy or Cut to add the selected range to the clipboard. Tapping on column or row headers will select an entire column or row and the Cut/Copy/Paste dialog will appear.

Now you can cut, copy or paste within a cell. Double tap a cell to select the contents of the cell, and hold to get the Cut/Copy/Paste bubble dialog.

Double tap to select a word. Triple tap to select a paragraph.

Note: Quicksheet retains all formatting when you cut/copy and paste across worksheets or workbooks. Copying text from one application to another will not retain formatting.

Formula Builder

Formula builder allows you to create formulas easily and provides help and UI to minimize errors.

• View function signature as a popup when building the formula.

• Specify arguments by simply tapping the cell. You can even choose cell ranges as arguments. To choose a cell range, double tap and drag. Place a comma as an argument separator.

• Note: You can choose function arguments only when creating new formulas.

Built-in Functions

Quicksheet supports more than 125 built-in functions. To enter a function, press the fx button to launch the function selection screen.

You can browse the list of supported functions sorted by category. When you select the function you want to use, it will be inserted into the spreadsheet.

Formatting Cells

Quickoffice provides extensive capabilities to format cells. Select the format icon and then select Bold, Italic, Text format, Text color, Background color, or Cell borders to change the appearance of the selected cells. Select the number format icon to change how the values are displayed. Pressing > next to the number format will give you additional options.

Advanced Formatting

Quicksheet now provides advanced formatting options.

Font Type and Size

Set font type and size for cell contents. Specified choices will be applied to current cell or all cells in the selected range.

Cell Borders

Apply or remove cell borders.

Note: You cannot specify border color or style.

Align Text

Quicksheet provides you an easy way to change horizontal and vertical alignment for a cell or a range of cells. Simply press the Alignment button in the toolbar and drag the sample text to change horizontal and vertical alignment. The changes will be applied on the fly.

You can also set text wrapping for a cell or a range of cells in the alignment dialog

The Default button restores the default horizontal alignment of a cell based on its Number Format (i.e. right alignment for numbers and left alignment for text). back to top

Clear Cell Contents and Formatting Easily

Tap on the formula bar to clear the cell contents.

• If you have made any changes to the cell, the first tap clears the edits and the second tap clears the cell contents.

• When you have selected multiple cells including entire rows and columns, pressing X clears the cell contents of all selected cells.

Tap on the toolbar to clear both cell contents and formatting.

• If you have selected multiple cells, this operation would clear the contents and formatting of all selected cells.

Resizing Rows or Columns

To resize a column, press and hold the dividing area between the column headers to switch to resizing mode. Then, slide your finger to increase or decrease the column width. Once you have reached the desired column width, lift your finger.

To resize a row, press and hold the dividing area between the row headers to switch to resizing mode. Then, slide your finger to increase or decrease the row height. Once you have reached the desired row height, lift your finger.

Selecting Rows or Columns

To select a column or a row, simply tap the column or row header.

Selecting a Range of Cells

To select a range of cells, simply double tap on a cell and drag your finger diagonally to select a range

Undo and Redo

Quicksheet makes it easy to undo/redo your edits. Simply shake the device to access the Undo/Redo dialog. Up to 10 changes can be undone or redone at a time.

Improved Readability

Now you can easily read large amounts of text. As long as adjacent cells are empty, a cell's contents will overflow into them.

Saving a Spreadsheet

Quicksheet automatically saves your changes to a temporary file as you make edits. To save the changes, press Back and you will be presented with options to save or discard the changes. Press Save to save the changes to the file, Save As to save the changes to a new file, or Don't Save to discard all changes made to the file.

Supported File Types

Quickoffice will list any files without any restriction. However, only the following file types can be viewed or played on the device.

Images: .jpg, .jpeg, .png, .tif, .tiff, .gif and .svg
Microsoft Word: .doc and .docx
Microsoft Excel: .xls and .xlsx
Microsoft PowerPoint: .ppt and .pptx
iWork: Pages, Numbers and Keynote (iWork '09 is not supported
Adobe Acrobat: .pdf
Web Pages: .htm and .html
Web Archive: .mht
Text: .txt
Audio: .mp3

Changing default file format

Quickoffice provides the ability for users to create files in native Office 2003 or 2007 formats. By default, all files are created in Office 2003 format. You can change this by tapping the settings gear and then tapping the MS Office 2007 option.

Viewing Large or Complex Documents

Quickoffice utilizes viewers present on your iPhone to view documents. This document viewer is used by many applications on your iPhone incuding the Mail application for viewing e-mail attachments. At times, this viewer can crash or not respond when viewing large or complex documents.

Zooming and scrolling

Zooming:
When viewing documents, you can zoom in and out. Double-tap when viewing a file to zoom in. Double-tap again to zoom out. Quickoffice supports the familiar 2-finger pinch gesture to zoom in or out.

Scrolling:
To scroll around the file, simply tap and drag up, down, or sideways.Dragging your finger to scroll won't choose or activate anything on the screen.

Viewing files in Landscape orientation

Quickoffice will change the orientation of the document you are viewing based on the accelerometer sensor.

Caching files for faster view

Quickoffice uses a cache to store recently downloaded & viewed files. You can adjust the size of the cache by pressing the Tools icon from the Main screen and selecting Cache Size. To clear the cache, from the main screen, press the Tools icon and select Clear Cache.

Viewing Password Protected PDF's

At this time, Quickoffice does not support viewing of password protected PDF's.

Viewing images

Quickoffice supports viewing of popular image formats such as JPG, TIFF, GIF, SVG and PNG

Quickoffice includes a built in image viewer optimized for viewing images on your iPhone or iPod Touch.

Playing Audio and Video files

Quickoffice supports playing of popular media formats such as MP3, MOV and QT.

Overview

Quickoffice allows you to use a WiFi network to transfer documents between your iPhone or iPod Touch, and a desktop computer running Mac OS X, Microsoft Windows XP, or Microsoft Windows Vista. Files are transferred in one of two ways, either by mounting your mobile device as a drive on your computer or by using the web browser on your computer to communicate with your device.

When your mobile device is mounted as a drive, you move and copy files to and from the device using the Finder on Mac OS X, or the File Explorer on Microsoft Windows platforms. When using a web browser, Quickoffice presents a friendly web interface which allows you to browse the contents of your device, and exchange files with the computer.

Note: iWork files cannot be transferred using the web browser interface. Please mount your iPhone as a drive to transfer iWork files.

Requirements

File Transfers makes use of the WiFi networking capabilities of the iPhone and iPod Touch to exchange files with a desktop computer. Quickoffice supports Macintosh computers running Mac OS X 10.5 Leopard, Microsoft Windows XP SP2 and Microsoft Windows Vista SP1.

Before you can use File Transfers, you will have to connect both your mobile device, and the computer, to the same WiFi network. The current WiFi network settings for the iPhone and iPod touch may be found in the Settings application. For instructions and troubleshooting tips, please refer to the documentation that came with your mobile device. Similarly, please refer to the documentation provided with your operating system for help in connecting your computer to a WiFi network.

File Transfer Settings

You can access the File Transfer settings from two locations within Quickoffice. The first location is the application settings panel, accessible from the main screen. The second location is from any directory listing screen, available using the button on the right side of the navigation bar at the top of the screen.

The File Transfers Master Switch

The File Transfers master switch allows you to enable and disable the File Transfers functionality altogether.

Beneath the master switch, Quickoffice offers status information about the file transfer connection. When enabled, this status information presents the internet address that you can use to connect to your mobile device on its local network.

File Transfer Authentication Settings

When File Transfers are enabled, Quickoffice also offers authentication settings. Authentication can be enabled or disabled. When disabled, any computer that attempts to make a connection to your device may do so without requiring the user of that computer to enter a username and password.

Note: If you disable authentication then computers on the local network will be able to connect to your mobile device and access the files it contains without any security measures in place.

When authentication is enabled, Quickoffice will also offer controls for setting a username and password. Once these are set, any computer that tries to connect to Quickoffice will ask the user to provide that same username and password before allowing that computer access to the files on your device.

Note: File Transfers authentication settings are only used to validate whether or not a computer can connect to your iPhone or iPod Touch, but File Transfers does not use a secure connection to transfer the content of files. Using File Transfers on a public WiFi network, even with authentication enabled, can put the security of those files at risk.

Mounting your iPhone as a drive - Using Mac OS X

1. Make sure you have turned on Wi-Fi on your iPhone and your iPhone and Macintosh are on the same WiFi network.
2. To connect to your mobile device from Mac OS X, simply bring up the "Connect To Server…" dialog from the Go menu in the Finder (cmd-K).
3. Enter the address of your device (as shown in the File Transfers settings dialog, or the File Transfer status bar in the Home screen) in the Server Address field of the Connect to Server dialog and press the Connect button.
4. If you have enabled authentication in the file transfer settings, the Finder will present you with an authentication dialog asking for a username and password. If authentication is enabled on Quickoffice, enter the same username and password you have set up in the File Transfer settings on your mobile device.
5. Mac OS X should mount your device as a drive. The name of the mounted drive will match the internet address you used when establishing the connection.

When you are finished working with Quickoffice, you should eject the drive that represents Quickoffice. This is typically done by dragging the drive icon to the trash, or by selecting the drive and choosing the Eject menu item under the file menu (cmd-E).

Mounting your iPhone as a drive - Using Microsoft Windows XP

To connect to your mobile device from Windows XP, you will need to map the device as a network place.

1. Open My Network Places either by selecting it on your desktop, or by clicking the Start button and selecting it from the menu.
2. From the Network Tasks panel, select Add a network place. The Add Network Place Wizard will appear to guide you through the process.
3. The first pane of the wizard offers informative text about what the wizard can do. After reading it, click the Next » button.
4. When asked "Where do you want to create this network place?", choose the second option: Choose another network location and click the Next » button.
5. Enter the internet address of your mobile device into the Internet or network address field. Click the Next » button.
6. If you have enabled authentication for File Transfers, the computer will prompt you for a username and password. Enter the same username and password you have set up in the File Transfer settings on your mobile device.
7. The wizard will ask you for a shortcut name that will help you quickly identify the mounted iPhone or iPod Touch. Enter an appropriate name and click the Next » button.
8. The last panel of the wizard will confirm that you have created the network place successfully. Simply click Finish to dismiss the wizard.

Mounting your iPhone as a drive - Using Microsoft Windows Vista

To connect to your mobile device from Windows Vista, you will need to map the device as a network place.

1. Select the Computer shortcut from your desktop, or by clicking the Start button selecting it from the menu.
2. From the Tools menu, select the "Map Network Drive" item. This will open the "Map Network Drive" window.
3. You will need to assign a drive letter to represent your mobile device. Choose any of the available drive letters from the Drive menu.
4. Enter the internet address of your mobile device into the Folder field. Click the Finish button to dismiss the window.
5. If you have enabled authentication for File Transfers, the computer will prompt you for a username and password. Enter the same username and password you have set up in the File Transfer settings on your mobile device.

Transferring files between your PC/Macintosh and your iPhone

To upload files to your iPhone, first connect your PC/Mac to your iPhone as described in "Mounting your iPhone as a drive." Once your iPhone is mounted as a drive on your computer, you can drag-and-drop files and folders between your desktop and your iPhone.

Disable Sleep Mode

The Disable Sleep mode prevents the device from going to sleep while transferring files or viewing long documents. You can access the Disable Sleep setting from the application settings panel, accessible from the main screen.

Note: Leaving Disable Sleep turned on for long periods of time will reduce the battery life of the device.

Not a MobileMe subscriber?

For more information on MobileMe, visit: www.apple.com/mobileme/

Connecting to your iDisk storage

From the Home screen of Quickoffice, press the Edit button. Select Add Account and enter your MobileMe member name and password in the account details screen and press Save. Now you can access files on your iDisk storage from Quickoffice.

Connecting to your friend's public folders

You can only access your friend's public folders on their iDisk storage. To access your friend's password protected public folders, you will need your friend's member name and password.

From the Home screen of Quickoffice, press the Edit button. Select Add Public Folder and enter your friend's MobileMe member name and press Save. If your friend's public folder is password protected you will be prompted for that password. Please enter the password and press Save. Now you can access your friend's public iDisk folder.

Connecting to multiple iDisk accounts

Quickoffice allows you to connect to several MobileMe iDisk accounts. From the Home screen of Quickoffice, press Edit. Select Add Account and enter the MobileMe member name and password in the account details screen and press Save. You can repeat this any number of times.

You can also connect to several public folders with the Add Public Folder item on the Home screen.

Changing your password

If the password for your MobileMe account has changed, you need to enter your new password. From the Home screen of Quickoffice, press the Edit button. Select the iDisk account and in the account details screen, enter the new password and press Back.

Downloading files for offline access

You can download one or more files and save them locally to your iPhone or iPod touch simply by pressing the Organize button in the toolbar when you are in the file list view.

Specifying a folder to save downloaded files

When downloading files, you can choose a folder on your iPhone where the downloaded files will be saved. To create a new folder, press the New Folder button and enter the folder name.

Downloading a folder - Not possible

It is not possible to download a folder. However, you can select mulitple files to download at once by pressing the Organize button in the toolbar, selecting the files to download, and pressing Download.

Viewing a locally saved file

To view a locally saved file, simply select "On iPhone" from the Home screen and navigate to the desired file.

Creating new folder

You can create folders on your iPhone or iPod Touch to organize downloaded files. To create a new folder, simply navigate to the local storage (On iPhone), press the New Folder button in the toolbar and enter the name of the new folder.

With Quickoffice, you can create new folders on your iDisk storage. To create a new folder on your iDisk, access your iDisk account from the main Quickoffice Files screen, andpress the New Folder button in the toolbar and enter the name of the new folder.

Moving files between folders

From the file list view in a local folder, press the Organize button in the toolbar, select the files to be moved, and press Move. From the list of local folders, select the destination folder. The selected files will be moved to the chosen destination folder.

Note: You can only move files on your iPhone. You cannot move files in your iDisk storage.

Renaming a file

From the file list view in a local or remote folder, press the details icon (») to display the file details and press the Rename button to enter a new name.

Deleting files and folders

From the file list view in a local folder, press the Trash button in the toolbar and select the files or folders to be deleted and press Delete.

With Quickoffice, you can delete files and folders in your iDisk storage. To delete files and folders in your iDisk storage, press the Trash button in the toolbar and select the files or folders to be deleted and press Delete.

Uploading a file to iDisk storage

You can upload files from your iPhone or iPod Touch to your iDisk storage.

To upload files to your iDisk, navigate to the desired folder in On iPhone. Press the Organize button in the toolbar, select the file to upload and press Move. Select a destination folder on your iDisk and press Choose "(folder name)".

Note: Only files within Quickoffice and on your iPhone can be uploaded to your iDisk storage. You cannot upload iWork files to your iDisk.

Uploading multiple files

You can upload multiple files at once to your iDisk storage. To do this, press the Organize button in the toolbar from the file list view, select the files you want to upload and press Move. Then navigate to your iDisk and the folder where you want to upload the files and select Choose "(folder name)".

Specifying a destination folder

When uploading files to your iDisk storage, you can specify a destination folder. Choose the destination folder by navigating through your iDisk folders, and select the desired folder by pressing Choose "(folder name)".

Uploading a folder - Not Possible

It is not possible to upload an entire folder, however, you can select multiple files to upload at once.

Uploading files on 3G or on EDGE

Uploading files on 3G or on EDGE can be very slow. Typically, upload speeds are only a fraction of the download speeds. Use WiFi to upload your files quickly.

Supported File Types

Quickoffice allows you to e-mail files on remote iDisk storage without having to download them.

Multiple local or remote files can be attached to a single e-mail.

E-mail files regardless of file type.

How to E-mail a File

Press the E-mail button in the toolbar, select the files to e-mail, and press Send. This launches the Compose New Message screen. Note that the files you selected are automatically attached to the message. Specify To, CC, BCC, Subject, and Body (as you would in the Mail application) and press Send to securely send the e-mail.

Specifying From Address

The first time you e-mail a file, you have to fill in the From: field with your e-mail address. You will only need to do this the first time you send an e-mail.

Access Your E-mail Attachments

With the latest version of Quickoffice you do not need MS Exchange to access e-mail attachments. Simply add your e-mail addresses into Quickoffice and you can receive attachments directly in the application.

To add your e-mail addresses, press the button from the Home screen and select Add Attachments.

Enter your e-mail address and press Save.

Note: To add several e-mail addresses press the Return button after each e-mail address.

To complete registration, check each e-mail account for the e-mail addresses you've added to Quickoffice and validate your account(s) by clicking on the validation link in the validation e-mail you received.

To access your attachments in Quickoffice simply forward them to files@quickofficeconnect.com from one of your validated accounts.

Note: If you add a contact on your device linked to files@quickofficeconnect.com, then you will not have to manually type it each time. We suggest giving this contact a name such as "Quickoffice Attachments".

Now you can access your attachments: select the Attachments item on the Home screen of Quickoffice.

You can add or remove e-mail addresses whenever you want. To edit the list of e-mail addresses, press the button from the Home screen and select Attachments. Add or remove e-mail addresses and press Save.

Note: You need to validate each e-mail address added.

Note: Deleting an e-mail address does not delete previously received attachments.

Downloading E-mail Attachments

To work with attachments, you need to download them.

Simply tap on an attachment to download it, and it will automatically open as soon as it has downloaded.

To download several attachments at a time, press the Download button , check as many attachments as you want, and press the Download button.