## OfficeSuite Professional Help

### Table of Contents

Basics

Components
Supported formats
Opening documents

File browser

Managing Files and Folders
Creating Documents
Sorting Files
Sharing Documents
Using Dictionaries

Document Editor

Viewing Documents
Working with Texts
Editing Features
Context Menus & Keyboard Shortcuts
Using Dictionaries

Spreadsheet Editor

Viewing and Navigation
Editing Spreadsheets

Presentation Editor

Viewing and Navigation
Editing Slides

PDF Viewer

Viewing
Navigation

## Basics

Welcome to MobiSystems® OfficeSuite Professional!

OfficeSuite Professional is a complete mobile office solution, allowing you to create, view and edit Microsoft® Word and Excel files away from your office. With the advanced editing features you can modify documents on-the-go and save them in their original format - DOC, DOCX, TXT, XLS, XLSX, CSV, PPT, PPTX, PPS and PPSX - just ready to be used back on your desktop computer. You can also open Adobe PDF and ZIP files and attachments.

### Components of OfficeSuite Pro

OfficeSuite is a group of applications sharing the same user interface, look and feel, and a common File browser. Each separate module in OfficeSuite supports different Microsoft Office file formats: Document Editor for Microsoft Word, Spreadsheet Editor for Microsoft Excel and Presentation Editor for Microsoft PowerPoint. PDF Viewer module is also included to allow users to open the commonly used PDF files and attachments.

###### Table of Contents

### Supported Formats

The file formats supported by theOfficeSuite Document Editor are:

- DOC - Microsoft® Word 97-2003 text documents.
- DOCX - Microsoft® Word 2007 text documents.
- DOCX - Microsoft® Word 2010 text documents.
- TXT - the commonly used TXT format for compatibility of OfficeSuite with third-party desktop programs.

OfficeSuite Spreadsheet Editor:

- XLS - Microsoft® Excel 97-2003 documents.
- XLSX - Microsoft® Excel 2007 documents.
- XLSX - Microsoft® Excel 2010 documents.
- CSV - CSV (comma separated) format ensures the compatibility of OfficeSuite with third-party desktop programs.

The file PowerPoint formats that the OfficeSuite opens and allows to be edited are:

- PPT and PPS - Microsoft® PowerPoint® 97-2003 documents.
- PPTX and PPSX - Microsoft® PowerPoint® 2007 documents.
- PPTX and PPSX - Microsoft® PowerPoint® 2010 documents.

OfficeSuite includes the OfficeSuite PDF Viewer which allows you to open Adobe® PDF files.

###### Table of Contents

### Opening Documents

OfficeSuite Pro allows you to open local or remote files, attachments that you received in your email client or files downloaded from a web browser:

- Email attachments

  Open your email client and locate the email message with attachment that you would like to open. Open the menu and select Attachments; Download the attachement and open it in OfficeSuite.

- Through OfficeSuite File Browser

  Open OfficeSuite and use the built-in File Browser to locate the desired document. Different supported file formats are listed with different icons.

- Through web browser

  While browsing the web you might come across document files. Dowload the file and select OfficeSuite to open it when prompted.

- Google Drive

  OfficeSuite Pro allows you to access your Google Drive account and files. To do so, use Add remote account in application File Browser. You should have an existing Google Drive account to use this feature.

###### Table of Contents

## The File Browser in OfficeSuite

When you start the program, the OfficeSuite File Browser will open.

### Managing Files and Folders

The File Browser provides basic operations to help you manage your files and folders. A long tap on a file from the file list will pop up the File Options menu.

- To rename a file, choose Rename and enter the new name in the text box that appears.
- To delete a file, choose Delete.
- To view file properties, choose Properties as Name, Type, File Size, Path to the file and Date modified.

The same options apply for folders. Note that only empty folders can be deleted.

###### Table of Contents

### Creating Documents

OfficeSuite Professional allows you to create new office documents. To do so, select Menu > New. You will be prompted to select the type of document to be created - Word document, Excel workbook or PowerPoint presentation. If you choose to add a presenation, you also have the option to use one of the 10 templates offered by OfficeSuite.

###### Table of Contents

### Sorting Files

To sort files, select Menu > Sort. Choose the criteria by which you want to sort the files:

- Name
- Type
- Size
- Date modified

###### Table of Contents

### Sharing Documents

OfficeSuite allows you to share your documents directly from the file browser by sending them to email recepient, to another device via Bluetooth or to upload them to an existing Google Drive account.

- To send a file via email or Bluetooth, tap and hold on the file until the File options menu appears and choose Send file. You will be offered the option to select email client to be used or Bluetooth. The file will be sent as an attachment to a new email in the program that you have selected to use.
- You can archive a file before sending it so you reduce its size. To do so, select Zip & Send file in the File options menu that appears when you tap and hold on a file.
- If you have an existing Google Drive account that has been added to OfficeSuite, you will also be able to Upload files to Google Drive, using the File options context menu.

###### Table of Contents

### Using Dictionaries

OfficeSuite Pro allows you to look up the meanings of selected words in text documents in a dictionary or reference book. More than one dictionary can be installed. To download dictionaries to use with OfficeSuite, select Download dictionaries in the main screen of the file browser. You will be redirected to the MobiSystems mobile site from where you can directly download, install and buy dictionaries of your choice.

###### Table of Contents

## The Document Editor in OfficeSuite

OfficeSuite supports viewing and editing of Microsoft Word DOC and DOCX files, as well as TXT files.

### Viewing documents

#### View Mode

OfficeSuite Pro works in two different modes - View mode and Edit mode. Use the View mode to open and read documents.To switch between the two modes press the menu button and then press View mode or Edit mode respectively.

#### Reading and Navigation

When a document is opened, the file's contents will be loaded sequentially. You can easily scroll within the document in order to read it. OfficeSuite also provides several options for easy navigation in the documet. Through the View menu you are able to:

- Go to top - return in the beginning of a document
- Go to bottom - move to the end of the current document
- Go to bookmark - navigate to a previously bookmarked location in the document
- Zoom - select the most convenient for you zoom value for reading
- Full screen - use the whole screen area to view a document

###### Table of Contents

### Working with Text

#### Text selection

While you are in Edit mode you can easily select text to format or perform different operations on. To do so, tap where you want to start the selection and drag to the position where you want to end the selection. The marked text will be highlighted. Finger-sized fine selectors will appear that will allow you to refine your choice. Tap and drag either of the selectors until you highlight the exact text that you need.

#### Cut, Copy, Paste

OfficeSuite Pro allows you to cut, copy and paste text selection to other places in the current document, other documents or external applications on your device. To to so:

1. Select the text as already described.
2. Select Edit from the menu and then Copy or Cut.
3. Go to the place where you want to paste the text and choose Edit > Paste

#### Undo / Redo

In OfficeSuite you are able to undo and redo the last operations that you have performed. To do so, use the Edit > Undo or Edit > Redo menu.

#### Find Text

OfficeSuite allows you to seach words and phrases within the currently opened document. To start the search, choose Find and enter the word/phrase that you want to search for in the pop-up dialog. You can use the or buttons to locate the previous or next match. To stop the search, choose .

###### Table of Contents

### Editing Features

OfficeSuite allows you to perform advanced text formatting of text and lists, as well as to create and modify different embedded objects as tables, lists, hyperlinks, images and other.

#### Edit Mode

The editing features are accessible only if you work in Edit mode. To switch between View mode and Edit mode press the menu button and then press respectively - Edit mode or View mode. Depending on the application mode the main and context menu will change offering different options to work with text documents.

#### Format

In order to format selected text or lists you can use the More > Format menu. You are able to format:

- Fonts - font types, sizes and styles, colors and effects
- Paragraphs - alignment, indents, spacing and line spacing
- Formatting symbols - this menu option will allow you to view the formatting symbols
- Bullets and numbering - you can select between single and multilevel lists, and between different styles of ordered and unordered lists
- Increase / Decrease indent

#### Insert

You are able to insert new objects in OfficeSuite Pro. To do so:

1. Place the cursor where you want to insert the object.
2. Select More > Insert from the main menu.
3. Select the type of object you would like to add:

- Image
- Table
- Hyperlink
- Bookmark
- Break
- Comment
- Footnote
- Endnote

###### Table of Contents

### Context Menus & Keyboard Shortcuts

OfficeSuite provides quick access to some commonly used operations through contex menus. Press and hold for a while on the desired place in order to open the context menu.

For devices with keyboards OfficeSuite supports the following shortcuts:

- Menu + x - Cut
- Menu + c - Copy
- Menu + v - Paste
- Menu + z - Undo
- Menu + y - Redo
- Menu + a - Select all
- Menu + s - Save

###### Table of Contents

### Using Dictionaries to Look up Words

OfficeSuite Pro allows you to look up the meanings of selected words in a dictionary or reference book. This feature is only available in text documents. The dictionaries have to be installed on your device beforehand. To download and install dictionaries, go to the File Browser and select Download dictionaries.

To check a word meaning, select the word and hold on it until the context menu apears. Select Look up in dictionary from the context menu and then dictionary to be used from a list of installed dictionaries.

###### Table of Contents

## The Spreadsheet Editor in OfficeSuite

OfficeSuite Pro opens and edits Microsoft® Office XLS and XLSX files, as well as CSV files.

### Viewing and Navigation

For easy browsing and navigation OfficeSuite offers some on-screen controls. To access them, tap on the screen and hold until a pop-up menu appears.

- Change spreadsheet - to change the current spreadsheet, just tap on this icon. The Select sheet dialog will open with the list of available sheets. Tap on the one that you want to open.
- Charts - this button allows you to open embedded charts in the current spreadsheet. The Select charts dialog will open with the list of available charts.
- or Zoom - to zoom in and out, use the zoom buttons available after tapping on the screen.
- Changing row height and/or column width - You can change the row height or column width by tapping and holding on the row/column boundary. Slide the boundary left/right or up/down. A thin black line will indicate the new boundary position.

For easier spreadsheet viewing you can use some additional features available in the View menu:

- Full screen - allows you to use the whole screen area by removing the status bar.
- Go to - gives you the ability to move directly to a cell with given coordinates.
- Freeze - allows you to freeze rows and /or columns to make them visisible all the time while you scroll in a sheet.

###### Table of Contents

### Editing Spreadsheets

OfficeSuite Pro allows you to modify cells, columns and rows formatting and contents, as well as to insert objects in spreadsheets and workbooks.

To select multiple cells which you want to handle, select Edit > Start selectction. After that tap on the cells you want to include in the selection. When finished tap Edit > Stop selectction

OfficeSuite Pro allows you to cut, copy and paste cells or selections to other places in the current document, other documents or external applications on your device. To to so:

1. Select the cell(s) as already described.
2. Select Edit from the menu and then Copy or Cut.
3. Go to the place where you want to paste the cell(s) and choose Edit > Paste

#### Undo / Redo

In OfficeSuite you are able to undo and redo the last operations that you have performed. To do so, use the Edit > Undo or Edit > Redo menu.

#### Inserting Objects

- To insert a function - Go to the cell where you want to embed the function and select Insert > Function from the menu. Select function category and the function itself.
- To insert a row - Highlight the row before which you want to add the new row. Select Insert > Row above from the menu.
- To insert a column - Highlight the column right to the position where you want to add a new one. Select Insert > Column left from the menu.
- To insert a worksheet - select Insert > Worksheet from the main manu and specify worksheet name when prompted.
- To insert a chart - go to the sheet where you want to place the chart and tap Menu> Insert > Chart. Select chart type, range and properties.
- To insert a comment - select the cell to which the comment is related and then choose Insert > Comment from the menu.

#### Format

The Format menu allows you to modify cell types and formatting, to hide rows and columns, and to rename sheets.

- Cells - through the Format > Cells menu you can modify the type of the cell, as well as to set up cell font, border and alignment.
- Rows - use the Format > Rows menu in order to hide and unhide rows.
- Columns - use the Format > Columns menu in order to hide and unhide columns or to auto fit columns.
- Rename sheet - allows you to modify a sheet's name

###### Table of Contents

## The Presentation Editor in OfficeSuite

### Viewing and Navigation

- Changing slides - To switch between the different slides in a presentation, you can use the pop-up toolbar which appears when you tap on the screen. Use the and arrows to move through the slides.
- Fit to screen - You can use the Zoom > Fit and Zoom > Fit width buttons to autofit a slide or expand it to the device screen.
- Go to slide - Choose Menu>Go to slide to go to a selected slide.
- Zoom - Choose Menu>Zoom and the Select zoom dialog will open from which you can select the desired zoom value. The supported zoom values are 25%, 50%, 75% and 100%.
- Full Screen - allows you to use the whole screen of your phone as a work area. To switch to Full Screen, choose Menu>Full screen. To exit Full Screen, choose Menu>Normal screen.
- Slideshow- To start a slideshow, choose Menu>Slide show. To stop the slideshow, choose Menu>Stop slide show.

###### Table of Contents

### Editing Slides

#### Slides Management

Through the Edit menu you can handle the slides in the current presentation. You are able to:

- Reorder slides - Select the corresponding menu item and reorganize the slides by draging and droping them to the new desired positions.
- Insert slide - A new slide is inserted before the currect one.
- Duplicate slide - Duplicates the current slide.
- Delete slide - The currently active slide is deleted.

#### Modifying Slides

- Outline view - The Outline view shows your slide text in outline form. Use this menu item in case you want to review or edit the slide text. To access the Outline view, simply select the corresponding menu item. Here you can add and format the text of your slide and edit the existing text. To return back to normal view when finished with the editing, select Menu>Slide view
- Slide notes - OfficeSuite Pro allows you also to add or modify notes to each slide. To do so, navigate to the desired slide while you are in Slide view. The footer part of the screen is dedicated to slide notes. Tap in this area to start editing your notes.

###### Table of Contents

## PDF Viewer

### Viewing PDF files

The Zoom menu - allows you to zoom in and out of a PDF file. In the Select zoom dialog you can select the desired zoom value 25%, 50%, 75% and 100% or Fit width or Fit (for auto fit).

You can also use the the pop-up toolbar that appears on the screen when you tap, in order to zoom in and out the current document.

Full screen menu allows you to use the whole screen of your phone as a work area. To switch to Full Screen, choose Menu>Full screen. To exit Full Screen, choose Menu>Normal screen.

###### Table of Contents

### Navigation in PDF Documents

To switch between the different pages in the PDF, you can use the pop-up toolbar which appears when you tap on the screen. Use the and arrows to move through the different pages.

The Go to page menu allows you to go to a particular page in the PDF document. Use the and buttons to choose a page number or enter it from the keyboard.

###### Table of Contents