• Optimized and designed for BlackBerry smartphones.
• Supports 65,536 rows and 256 columns.
• Multiple sheets per workbook.
• Cell and text formatting.
• Alignment, borders and background colors.
• Easy cell editing with real-time preview.
• Preview for formatting.
• Cut, copy and paste cell data.
• Insert and delete cells, rows and columns.
• Zoom in or out. *
• Freeze panes. *
• Supports password protected workbooks. **
• Row and column resizing.
• Find, go to, and End mode.
• Full screen view. **
• Auto switch to numeric or text input mode based on cell format.
• Managing workbooks with categories.
• Features the most frequently used Microsoft Excel functions.
• Compatible with Microsoft Excel.
• Edit and send email attachments.

You can install GridMagic in one of the following ways:

OTA Installation

1. Use your smartphone's internet browser to access http://www.simprit.com/wap.wml
2. Click "GridMagic (RIM BlackBerry)" to download the application.

Installation with BlackBerry Desktop Manager

1. Download gridmagic_setup.exe from http://www.simprit.com/download.html
2. Double-click gridmagic_setup.exe and follow the on-screen instructions to install GridMagic and its components on your hard drive:
   
   
   
   
3. Connect your BlackBerry smartphone to your desktop computer.
4. Start the BlackBerry Desktop Manager and launch the Application Loader.
5. Proceed to the Device Application Selection (or Handheld Application Selection) screen.
6. Press Add button to add sxo_calc.alx (this file is located at C:\Program Files\Simprit\GridMagic by default) to the Application Loader:
   
   
   
   
7. Follow the instructions of the Application Loader Wizard to load GridMagic to your smartphone.
8. Reset your smartphone after installation.

GridMagic is launched in a fully functional trial mode when you first install it. You can use GridMagic in trial mode for 15 days.

Once the trial is expired, the software will turn into the Community Edition with basic features. You are free to use GridMagic Community Edition for non-commercial personal or educational purposes.

You can also convert the software to the Community Edition during the trial period:

1. Launch GridMagic on your smartphone.
2. In the workbook list, click About on the menu.
3. Click the Convert to Community Edition button.
4. Click Yes.

To use GridMagic for commercial purposes, you can choose to purchase GridMagic Standard or GridMagic Professional.

You can compare the features available in different GridMagic editions at http://www.simprit.com/gridmagic/product_comparison.html

If you have previously installed GridMagic (trial or Community Edition) on your smartphone, you are not required to re-install the software when you decide to purchase GridMagic. You just need to follow the following instructions to register the software:

1. Locate your device ID. Launch GridMagic on your smartphone, click About on the menu. Note down your device ID shown in the About screen.
2. Make payment. Visit the product page at http://www.simprit.com/gridmagic/ and look at the purchase information section to understand how to purchase the product and make your payment online.
3. Obtain the registration key. Your registration key to unlock the software will be generated to you immediately after your payment is made and cleared.
4. Register the GridMagic software with the steps listed in the following section.

Registering the GridMagic software

1. Launch GridMagic.
2. Click About on the menu.
3. Click the Register button, or click Register on the menu.
4. In the Registration Key dialog box, enter your registration key EXACTLY as it appears on your registration acknowledgement email and press Enter.
   
   
   
   

You will have a registered version of GridMagic once you have successfully registered the software with a valid registration key.

Working with Files

Create a new workbook

1. In the workbook list, click New on the menu.

Open a workbook

1. In the workbook list, navigate to the workbook you want to open.
2. Open the workbook in one of the following ways:
   • Press Enter.
   • Click Open on the menu.
   • Click the trackball.

Delete a workbook

1. In the workbook list, navigate to the workbook you want to delete.
2. Press Backspace, or alternatively, Click Delete on the menu.
3. Click the Delete button.

Rename a workbook

1. In the workbook list, navigate to the workbook you want to rename.
2. Click Rename on the menu.
3. Type a new name over the current name.
4. Press Enter.

Duplicate a workbook

1. In the workbook list, navigate to the workbook you want to duplicate.
2. Click Duplicate on the menu.

Filter workbook list by a category

1. In the workbook list, click Filter on the menu.
2. Check the category you want to filter (by pressing Space).

Remove filter

1. In the workbook list, click Filter on the menu.
2. Click Clear Selection on the menu.

Find a workbook

1. In the workbook list, click Find on the menu.
2. Type the workbook name you are searching for.
3. Press Enter.
4. Workbooks that match the name will be displayed.

To clear the find result, click Reset Find on the menu.

Moving Around in a Workbook or Worksheet

Move between cells

In the current workbook, roll the trackwheel or trackball to move between cells on a worksheet. For smartphones that have a trackwheel, you can also hold the Alt key and roll the trackwheel to move in a different direction. The moving direction can be customized in Options.

Page scrolling

In the current workbook, enable Page scrolling in one of the following ways:

• Press Space then press P.
• Click Enable Page Scrolling on the menu.
• Hold Alt key and press Enter. ***

You can then roll the trackwheel or trackball, to move between pages. For smartphones that have a trackwheel, you can also hold the Alt key and roll the trackwheel to move in a different direction.

To stop page scrolling, use one of the following ways:

• Press Space then press P.
• Click Disable Page Scrolling on the menu.
• Hold Alt key and press Enter. ***

Find data

1. Click Find on the menu, or alternatively, press Space then press F.
2. Enter the data you want to search for and specify your search options.
3. Press Enter.

If the data is found, Find Next will appear in the menu. You can use Find Next to continue searching for the same data in the worksheet.

Go to a specific cell

1. In the current workbook, click Go To on the menu, or alternatively, press Space then press G.
2. Type the cell, row or column you want to go to.
3. Press Enter.

Move by one block of data within a row or column

1. In the current workbook, click Go To on the menu, or alternatively, press Space then press G.
2. Select Turn End mode on then press Enter.
3. Scroll to move by one block of data.

Go to a recently visited cell

1. In the current workbook, click Go To on the menu, or alternatively, press Space then press G.
2. Scroll to one of the recently visited cells in the list that you want to go to.
3. Press Enter.

Zoom on a worksheet

This feature is supported in GridMagic Standard and GridMagic Professional.

In the current workbook, hold Shift key and roll the trackwheel or trackball to zoom in or out on the worksheet.

Or alternatively,

1. Switch to Zoom mode in one of the following ways:
   • Press Space then press Z.
   • Click Zoom In/Out on the menu.
2. Roll the trackwheel/trackball, or alternatively, click Zoom In or Zoom Out on the menu.

To stop zooming in Zoom mode, press Escape, or alternatively, click Stop Zooming on the menu.

Full screen view

This feature is only supported in GridMagic Professional.

In the current workbook, click Full Screen on the menu.

Or alternatively, press Space then press W.

To switch to normal view, click Normal View on the menu.

Or alternatively, press Space then press W.

You can change the screen view behavior in Options:

1. Close the current workbook and go back to the workbook list screen.
2. Click Options on the menu.
3. Click General Options.
4. Choose the Startup screen view you want.

Switch to another worksheet in a workbook

1. In the current workbook, click Sheets on the menu, or alternatively, click the trackball and click Sheets on the menu.
2. In the worksheet list, navigate to the worksheet you want to switch to.
3. Open the workbook in one of the following ways:
   • Press Enter.
   • Click Open on the menu.
   • Click the trackball.

Alternatively, press Space then press the worksheet number (e.g. 3) you want to open.

Close a workbook

1. In the current workbook, press Escape, or alternatively, click Close on the menu.

Manipulating Workbooks and Worksheets

Save a workbook

1. In the current workbook, click Save on the menu, or alternatively, click the trackball and click Save on the menu.

Save a backup copy of a workbook

1. In the current workbook, click Save As on the menu.
2. Type a name for the workbook.
3. Press Enter.

Insert a new worksheet

1. In the current workbook, click Sheets on the menu, or alternatively, click the trackball and click Sheets on the menu.
2. Click Insert on the menu.
3. Type the new worksheet name.
4. Press Enter.

Delete a worksheet from a workbook

1. In the current workbook, click Sheets on the menu, or alternatively, click the trackball and click Sheets on the menu.
2. Navigate to the worksheet you want to delete.
3. Press Backspace, or alternatively, click Delete on the menu.
4. Click the Delete button.

Rename a worksheet

1. In the current workbook, click Sheets on the menu, or alternatively, click the trackball and click Sheets on the menu.
2. Navigate to the worksheet you want to rename.
3. Click Rename on the menu.
4. Type a new name over the current name.
5. Press Enter.

Move a worksheet

1. In the current workbook, click Sheets on the menu, or alternatively, click the trackball and click Sheets on the menu.
2. Navigate to the worksheet you want to move.
3. Click Move on the menu.
4. In the Before sheet drop-down list, select the worksheet before which you want to insert the moved worksheet.
5. Click the OK button.

Freeze worksheet panes

This feature is supported in GridMagic Standard and GridMagic Professional.

1. In the current workbook, move to the cell where you want the split to appear.
2. Click Freeze Panes on the menu.

To unfreeze panes, click Freeze Panes on the menu.

Assign categories to a workbook

1. In the current workbook, click Categories on the menu.
2. Check the categories you want to assign to the current workbook (by pressing Space).
3. Click Apply on the menu.

Remove categories from a workbook

1. In the current workbook, click Categories on the menu.
2. Uncheck the categories you want to remove from the current workbook (by pressing Space).
3. Click Apply on the menu.

Protect workbook with a password

This feature is supported in GridMagic Professional only.

1. In the current workbook, click Workbook Options on the menu.
2. Navigate to the Password field.
3. Type a password.
4. Click Save on the menu.
5. Type the password again.
6. Press Enter.

Change workbook settings

1. In the current workbook, click Workbook Options on the menu.
2. Make any changes you want.
3. Click Save on the menu.

Note that when Zoom Factor is Global, it refers to the Zoom Factor set in the General Options.

Manipulating Rows, Columns, and Cells

Select a range of cells

1. Move to the first cell of the range.
2. Hold Alt key and click the trackwheel/trackball, or click Select on the menu.
3. Move to the last cell of the range.

Select rows

1. Move to the row you want to select.
2. Hold Alt key and click the trackwheel/trackball, or click Select on the menu.
3. Click Select Rows on the menu.
4. Roll the trackwheel/trackball if you want to select more rows.

Select columns

1. Move to the column you want to select.
2. Hold Alt key and click the trackwheel/trackball, or click Select on the menu.
3. Click Select Columns on the menu.
4. Roll the trackwheel/trackball if you want to select more columns.

Cancel a selection of cells

To cancel a selection of cells, press Escape; or alternatively, click Cancel Selection on the menu.

Insert cells

1. Select a range of existing cells where you want to insert the new cells. (Refer to Select a range of cells.)
2. Click Insert Cells on the menu.
3. Select Shift cells down, Shift cells right, Entire row or Entire column.
4. Click the OK button.

Insert rows

1. Select rows immediately below where you want the new rows. (Refer to Select rows.)
2. Click Insert Rows on the menu.

Insert columns

1. Select columns immediately below where you want the new columns. (Refer to Select columns.)
2. Click Insert Columns on the menu.

Delete cells

1. Select the cells you want to delete. (Refer to Select a range of cells.)
2. Click Delete Cells on the menu.
3. Select Shift cells up, Shift cells left, Entire row or Entire column.
4. Click the OK button.

Delete rows

1. Select the rows you want to delete. (Refer to Select rows.)
2. Click Delete Rows on the menu.

Delete columns

1. Select the columns you want to delete. (Refer to Select columns.)
2. Click Delete Columns on the menu.

Resize cells, rows, or columns

1. Select the cells, rows or columns you want to change their heights or widths. (Refer to Select a range of cells, Select rows, and Select columns, respectively.)
2. Switch to Resize mode in one of the following ways:
   1. Press Space then press R.
   2. Click Resize on the menu.
3. Roll the trackwheel/trackball, or hold Alt key and roll the trackwheel to change heights or widths.

In Resize mode, you can also specify the row height or column width you want by:

1. Click Resize on the menu.
2. Enter the row height or column width you want.
3. Click Apply on the menu.

To stop resizing in Resize mode, press Escape, or alternatively, click Stop Resizing on the menu.

Entering and Editing Data

Enter data in a cell

1. Move to the cell where you want to enter data.
2. Type the data and press Enter.

Edit cell contents

1. Move to the cell that contains the data you want to edit.
2. Press Enter.
3. Make any changes to the cell contents.
4. To enter your changes, press Enter. To cancel your changes, press Escape.

Or alternatively,

1. Move to the cell that contains the data you want to edit.
2. Click Input on the menu.
3. Make any changes to the cell contents.
4. Click Apply on the menu to enter your changes, or click Cancel on the menu to cancel your changes.

Switch to numeric input mode

Numeric input mode allows you to enter numbers conveniently. To switch to numeric input mode:

1. Move to the cell where you want to edit.
2. Press Enter.
3. Click Numeric Input on the menu.

To exit numeric input mode, click Exit Numeric Input on the menu.

If a cell is formatted as one of the numeric categories (e.g. Number, Currency, Date, Time, etc), GridMagic will automatically switch to numeric input mode when entering data in the cell; otherwise, GridMagic will use the current input mode on the smartphone.

If you want to change this behavior for unformatted cells, you can turn on Auto numeric input based on previous rows. If the Auto numeric input based on previous rows option is turned on, when entering data in a cell, GridMagic will detect data format of the previous rows. If the previous rows are detected as of the numeric categories, it will switch to numeric input mode.

To change the Auto numeric input based on previous rows option:

1. In the workbook list screen, click Options on the menu.
2. Click General Options.
3. Change the Auto numeric input based on previous rows option.

For BlackBerry smartphones with SureType keypad, when you switch to numeric input mode, you can press ! to enter date-related symbols (e.g. /, :, SPACE); or press ? to enter number-related symbols (e.g. -, $, +, %).

Insert a function

1. Move to the cell that you want to insert function.
2. Press Enter.
3. Hold Alt key and roll the trackwheel, or roll the trackball to move to the position you want the function to be inserted.
4. Click Insert Function on the menu.
5. Click the function you want to insert.
6. Complete the function by entering its arguments and press Enter.

Clear contents from cells

1. Select the cells, rows, or columns you want to clear. (Refer to Select a range of cells, Select rows, and Select columns, respectively.)
2. Press Backspace.

Cut Cell Data

1. Move to the cell that you want to cut its data, or select a cut area. (Refer to Select a range of cells.)
2. Hold the Shift key and press Backspace, or alternatively, click Cut on the menu.

Copy Cell Data

1. Move to the cell that you want to copy its data, or select a copy area. (Refer to Select a range of cells.)
2. Hold the Alt key and click the trackwheel/trackball, or alternatively, click Copy on the menu.

Paste Cell Data

1. Move to the cell where you want the data to be pasted.
2. Hold the Shift key and click the trackwheel/trackball, or alternatively, click Paste on the menu.

Formatting Text and Cells

Format a single cell

1. Move to the cell you want to format.
2. Click Format Cells on the menu.
3. Make changes to the format you want.
4. Click Apply on the menu.

Format a range of cells

1. Select cells that you want to format. (Refer to Select a range of cells.)
2. Click Format Cells on the menu.
3. Make changes to the format you want.
4. Click Apply on the menu.

Apply format to a range of cells

1. Select cells that you want to format. (Refer to Select a range of cells.)
2. Click Apply Format on the menu.
3. Click the format you want to apply.

Change the text format of the specific text in a cell

1. Move to the cell that you want to change its text format.
2. Press Enter.
3. Hold Alt key and roll the trackwheel, or roll the trackball to move to the character you want to start making selection.
4. Hold Alt key and click the trackwheel/trackball to turn on the text selection mode.
5. Hold Alt key and roll the trackwheel, or roll the trackball to make selection.
6. Click Format Text on the menu.
7. Make changes to the format you want.
8. Click Apply on the menu.

Managing Categories

Create a new category

1. In the workbook list, click Filter on the menu; or alternatively, in the current workbook, click Categories on the menu.
2. Click New on the menu.
3. Type the new category name.
4. Press Enter.

Delete a category

1. In the workbook list, click Filter on the menu; or alternatively, in the current workbook, click Categories on the menu.
2. Navigate to the category you want to delete.
3. Press Backspace.
4. Click the Delete button.

Or alternatively,

1. In the workbook list, click Filter on the menu; or alternatively, in the current workbook, click Categories on the menu.
2. Navigate to the category you want to delete.
3. Click Delete on the menu.
4. Click the Delete button.

Launching BlackBerry Applications

This feature is supported in GridMagic Standard and GridMagic Professional.

Launch a browser

If a cell contains a web site URL, you can launch the BlackBerry browser and go to the web site in one of the following ways:

• Press Space then press L.
• Click Get Link on the menu.

Make a phone call

If a cell contains a telephone number, you can make a phone call with the number in one of the following ways:

• Press Space then press L.
• Click Call <PHONE NUMBER> on the menu.

Compose an email

If a cell contains an email address, you can compose an email sending to the email address in one of the following ways:

• Press Space then press L.
• Click Compose Email on the menu.

Changing Default Settings

1. In the workbook list, click Options on the menu.
2. Click General Options.
3. Make any changes you want.
4. Click Save on the menu.

GridMagic works together with the GridMagic Server to provide the ability to open, edit and send spreadsheets as email attachments on your BlackBerry smartphone anywhere, anytime.

Opening and Editing Email Attachments

1. Open a message that attached with Excel workbooks.
2. Click Open with GridMagic on the menu.
   
   
   
   
3. Click the attachment you want to edit and then click Open on the menu.
   
   
   
   (You can also save the attachment directly to GridMagic by clicking Save on the menu.)
   
   
4. Make any changes you want.
5. Click Save on the menu.
6. Type a workbook name and press Enter

To go back to the attachment list, click Close on the menu.

Sending Workbooks as Email Attachments

1. In the email message you are composing, click Send via GridMagic on the menu.
   
   
   
   
2. Check the workbooks you want to send as attachment (by pressing Space).
3. Click Send on the menu.
   
   
   
   

Changing Attachment Service Settings

1. Launch GridMagic.
2. In the workbook list, click Options on the menu.
3. Click Attachment Service.
4. Make any changes you want.
5. Click Save on the menu.

The available options are listed below:

Option	Description
Integrate with email messages	Specifies whether to add GridMagic menu items to email messages.
Bcc me sent messages	Specifies whether to send a copy of message to the sender whenever an attachment is sent via the Send via GridMagic menu item.
Add signature to outgoing messages	Specifies whether to add your signature to outgoing messages.
Email signature	Your signature to add to outgoing messages.

Changing Connection Settings

1. Launch GridMagic.
2. In the workbook list, click Options on the menu.
3. Click Connection Settings.
4. Make any changes you want.
5. Click Save on the menu.

Option	Description
Connection mode	If this is set to Auto, GridMagic will automatically detect the connection type for you. Otherwise, if Manual is selected, you need to specify the connection type you prefer.
Connection type	This can be either BES (BlackBerry Enterprise Server), BIS (BlackBerry Internet Service) or Direct TCP. You only need to specify your connection type if the connection mode is set to Manual.

To test your BIS connection, you can click the Test BIS Connection on the menu.

Setting Up SyncManager

SyncManager allows you to synchronize data between your BlackBerry smartphones and your desktop. It is included in the gridmagic_setup.exe installer. You may refer to the Installation with BlackBerry Desktop Manager section on how to obtain and run the installer. Make sure you have run the installer before proceeding with the following steps.

1. Launch BlackBerry Desktop Manager and double click the Synchronize (or Intellisync) icon.
2. Check the Execute Add-in actions checkbox.
3. Click Configure Add-ins button. (For BlackBerry Desktop Manager 4.2, you need to click the Configuration tab first.)
4. Check the SyncManager add-in module.
   
   
   
   
5. Click the OK button.

Using SyncManager

1. Connect your smartphone to your desktop. Make sure GridMagic is not running.
2. Launch BlackBerry Desktop Manager and double click the Synchronize (or Intellisync) icon.
3. Click the Synchronize now button.
   
   
   
   
4. Specify your Workbook path.
5. Choose the actions you want to perform for each workbook.
6. Click the Synchronize button.

Backup GridMagic data

1. Connect your smartphone to your computer.
2. Open the BlackBerry Desktop Manager.
3. Double-click the Backup and Restore icon.
4. Click Advanced.
5. If your smartphone is locked, type your password. Click OK.
6. In the Device Databases (or Handheld Databases) section, select the SyncManager Database to back up.
7. Click the Left-Arrow button.
8. On the File menu, click Save As.
9. Type a name and select a location for your backup file.
10. Click Save.

Restore GridMagic data

1. Connect your smartphone to your computer.
2. Open the BlackBerry Desktop Manager.
3. Double-click the Backup and Restore icon.
4. Click Advanced.
5. If your smartphone is locked, type your password. Click OK.
6. On the File menu, click Open.
7. Select a backup file (an .ipd file).
8. Click Open.
9. In the Desktop File Databases section, select the SyncManager Database to restore.
10. Click the Right-Arrow button.
11. Click OK.

While working with worksheets, you can perform the following actions with shortcut keys:

Action	Shortcut Keys
Display Shortcut Keys dialog	Press Space then click the trackwheel/trackball
Zoom in *	Hold Shift key + roll the trackwheel/trackball up, or hold Alt key + roll trackball up
Zoom out *	Hold Shift key + roll the trackwheel/trackball down, or hold Alt key + roll trackball down
Full screen view **	Press Space then click W
Complete a cell entry and move down in the selection	Enter
Start a cell entry	Press a letter, or press Enter
Enable or disable Page scrolling	Press Space then press P, or hold Alt key + Enter ***
Switch to another worksheet in a workbook	Press Space then press the worksheet number (e.g. 3) you want to open
Find data in a worksheet	Press Space then press F
Go to a specific cell	Press Space then press G
Start selecting cells	Hold Alt key + click the trackwheel/trackball
Cut cell data	Hold Shift key + Backspace
Copy cell data	Hold Shift key + Enter
Paste cell data	Hold Shift key + click the trackwheel/trackball
Copy cell data when selecting cells	Hold Shift key + Enter, or Hold Alt key + click the trackwheel/trackball
Resize column width or row height	Press Space then press R to switch to Resize mode, then roll the trackwheel/trackball, or hold Alt key + roll the trackwheel
Zoom in or out *	Press Space then press Z to switch to Zoom mode, then roll the trackwheel/trackball
Launch BlackBerry application (depends on cell content) *	Press Space then press L