Spreadsheet Editor

OfficeSuite supports all of the major Excel spreadsheet types including .XLS, .XLSX, .XLSM, .ODS, and .CSV. To access the Spreadsheet Editor, either open or create a new spreadsheet. There are also Spreadsheets keyboard shortcuts for attached physical keyboards.

The Sheets Editor is easily identified by its characteristic green-colored menu bar.

Viewer mode

Existing Spreadsheet documents are automatically opened in Viewer mode. This mode lets you view spreadsheets with minimal interference from the interface. To enable editing, tap on the Editor icon to enter Editor mode.

When in Viewer mode, to toggle the menu bar, tap anywhere in the document. You can browse by swiping in a given direction, and zoom in and out of the interface with a pinch gesture.

At the upper right corner of the screen you'll find options to share the document, these are detailed in our separate Sharing Options topic. The third icon on the top right will open the Contextual menu providing a wide range of options for viewing documents:

	Save any changes made to the document in its current format.
	Save as another file type for maximum compatibility.
	Print the document using a networked printer.
	Find instances of entered text. You can browse between results using the left and right arrows.
	Export to PDF to quickly create a PDF file from your spreadsheet.
	Protect the document using a custom password. Note that user-generated passwords are NOT recoverable if forgotten!
	Gridlines toggles the display of cell gridlines in the document.
	Freeze/Unfreeze toggles locking the upper leftmost row and/or column so that it is always displayed regardless of which part of the spreadsheet you are viewing.
	Go to cell... takes you to a specific cell by entering in its coordinates (in the format ColumnLetter:RowNumber).
	Zoom the view to different levels for easier viewing.
	Charts displays any contained charts in full screen mode.
	Manage versions allows you to view and work with previous versions of a specific file. This option is visible only on files that have been uploaded to your MobiSystems Drive account.
	Properties shows you detailed information about the specific file such as location, type, size, who has access and more.
	Help opens this help documentation.

Along the bottom of the Spreadsheet editor you'll find the Summary bar, which allows you to switch between the sheets that are currently present in your document.

If you select more than one cell that contains a number, you will automatically see the Sum of the selected cells on the right of the Summary bar. Tapping here will also let you see the Average, Count, Max, and Min of the selected cell range. If no numbered cell range is selected, you will see the Expand/Collapse button, which toggles full screen viewing (in Viewer mode only).

In Editor mode (shown below), you can rearrange sheets by dragging them, and add new sheets using the Add button. Tapping on an existing sheet lets you Delete, Rename, and Hide/Unhide them. Finally, the Quick keyboard lets you instantly add numbers and symbols to a selected cell.

To enable editing, tap on the Editor icon to enter Editor mode.

Editor mode

New Spreadsheets are automatically created in Editor mode. This mode lets you immediately start creating and formatting your spreadsheets using the full range of OfficeSuite's editing features. To switch to Viewer mode, tap on the Viewer icon in the upper right.

There are several options in the upper right which are visible across all tabs:

	Save any changes made to the document.
	Undo the most recent change made.
	Redo the most recent undone change.
	Up/Down arrow toggles visibility of the interface.

OfficeSuite's Spreadsheet Editor provides a tabbed interface with options similar to those found on desktop PC's. The tabs in the Spreadsheet Editor are File, Home, Insert, Format, Formulas, View and Review. An additional Chart tab will appear whenever you select a chart.

The Formula bar is always displayed under the function tabs, and allows you to add entries and formulas easily. More information on how formulas work can be found in the Formulas tab.

File

The File tab houses all of the file management capabilities of the Spreadsheet Editor. From here you can create, open, and save Excel documents, as well as setup page layouts, print, and more.

	New – Creates a new blank spreadsheet.
	Templates – Allows you to create a new file using one of OfficeSuite's provided templates.
	Open – Exits the current module, allowing you to open a new file.
	Open Recent – Displays a list of recently-opened files for quick access.
	Save – Saves any changes you have made to the spreadsheet.
	Save As – Allows you to save the spreadsheet with a new name and/or file type.
	Export to PDF – Quickly converts your spreadsheet to a PDF file.
	Print – Opens the Print dialog, which displays a thumbnail view of pages for printing. You can select a connected printer by tapping on its name in the upper left. To print, tap on the Printer icon in the upper right.
	Pages can be toggled with the Checkbox on the bottom right, while advanced print options are displayed by tapping on the bar across the top. From here, you can specify the number of copies to print, paper size, and orientation, among others.
	Share – Allows you to share the document with others.
	Protect – Allows you to restrict access to the spreadsheet with a custom password. Please note that user passwords are not recoverable in OfficeSuite.
	Manage versions – Allows you to view and work with previous versions of a specific file. This option is visible only on files that have been uploaded to your MobiSystems Drive account.
	Help – Displays the Spreadsheet Editor help within this help documentation.

Home

The Home tab is where you'll find the standard range of tools for adjusting font sizes, colors, and styles; formatting options for individual cells and cell ranges; as well as sum, filter, and sort settings.

Paste – Place cut or copied elements in your document. For further choice on what to paste and what not to you have the following options:

	Keep Formatting – Keep any formatting present on the copied or cut content.
	Text Only – Pastes only text with no formatting.

	Cut – Cut elements from one location, and move them to another via paste.
	Copy – Copy elements from one location to another via paste.
	Format Painter – Copies the formatting and style of the selected text.
Arial	Font Families – Opens the font menu, which lists your available OfficeSuite fonts in their relevant style.
11 pt	Font Size – Adjusts font size from a predefined value.
	Font Color – Specify the text color.
	Bold – Embolden text.
	Italics – Italicize text.
	Underline – Underline text.
	Strikethrough – Add a strikethrough effect to text.
	Cell Border – Provides options for specifying cell borders on cells or cell ranges.
	Highlight Color – Specify the highlight color.
	Align Top – Aligns cell text against the top border.
	Align Middle – Aligns cell text between the top and bottom borders.
	Align Bottom – Aligns cell text against the bottom border.
	Align Left – Aligns text against the left border.
	Align Center – Centers text between both borders.
	Align Right – Aligns text against the right border.
	Wrap Text – Allows text to be wrapped within a cell so that it does not get obscured by the cell boundaries.
	Merge Cells – Groups the contents of multiple cells together, creating a single cell in their place. Note that only the upper-leftmost cell data will be retained.
	Currency – Marks the entered numerical value as currency, in dollars.
	Percentage – Marks the entered numerical value as a percentage.
	Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result. Using this with only one cell selected will allow you to enter cell ranges manually.
	Insert – Used to insert either Rows above the currently selected range or a Column left of it.
	Delete – Deletes the selected rows or columns of the spreadsheet, or the currently active sheet.
	Cells – Provides options to place additional cells. Two options are available, Insert empty cells and shift right and Insert empty cells and shift down.
	Find & Replace – Searches for instances of text entered in the Search field, and will replace them with text entered in the Replace field:
	Case sensitive – Will search for exact cases such as capitalized or all lowercase letters. Match entire cell – Will filter out results that have the searched text as a part of a larger cell entry. Search in results of formulas – Will search either through cell values or cell formulas.

Insert

The Insert tab is used for placing a wide range of visual additions to your spreadsheets, such as graphics and charts.

	Table – Inserts a table into the selected cell or cell range. You can specify the number of rows and columns by dragging across the creation grid. Once a table is inserted, you can modify it under Table tab by tapping on it.
	Picture – Inserts an image into your spreadsheet from your Android file system. Placed images can be modified using the resize and scale anchors.
	Web Picture – Perform an online image search and instantly insert a picture into your spreadsheet (requires an Internet connection).
	Camera – Allows you to insert an image using your devices' camera.
	Chart – Opens the chart insertion dialog, which allows you to insert a chart with a range of chart options. The Type tab lists charts and chart subtypes, along with a 3D effect toggle. The Data tab allows you to add and name series and ranges, while the Style tab provides options to change chart colors. Selected charts can be modified using the Charts tab.
	Chart in New Sheet – Provides identical options to the chart tab, except the chart will be inserted into a separate sheet in the spreadsheet.
	Hyperlink – Marks the contained cell elements as a hyperlink to a web address or email.
	Comment – Adds a comment to a cell or cell range. Commented cells are marked by a small indicator in the upper right, and will briefly appear when the cell or cell range is selected.
	Text Box – Adds a floating text box that can be overlaid anywhere over your spreadsheet. You can adjust the size of the text box using the resize anchors, and contents and style by tapping on the Edit button.

Format

The Format tab is a quick way adjust the formatting of the various elements of your spreadsheet. This includes common formatting options from other tabs, as well as options to adjust units of measurement and cell alignment.

	Number Formatting – Allows you to mark numbers in cell ranges, and choose from a wide range of unit measurements and formatting. Each category provides additional customization options, while the Custom category allows you to specify your own number format.
	Alignment in Cell – Changes the formatting of cells and cell ranges. Besides horizontal and vertical alignment, you can adjust indentation and more.
	Cell Font – Changes the formatting of cells and cell ranges. You can adjust font size, style, color, and specify text effects.
	Borders – Opens the cell border dialog, which provides options for specifying cell border colors and line styles.
	Hide Rows – Hides (but does not delete) cell rows from view. Hidden rows can be shown using Unhide Rows.
	Unhide Rows – Reveals hidden rows. Can only be accessed from selected neighboring unhidden rows.
	Hide Columns – Hides (but does not delete) cell columns from view. Hidden columns can be shown using Unhide Columns.
	Unhide Columns – Reveals hidden columns. Can only be accessed from selected neighboring unhidden columns.
	Auto-Fit Columns – Resizes columns to fit the character width of their data.
	Rename Sheet – Renames the individual sheets of your spreadsheet.
	Conditional Formatting – Opens the conditional formatting dialog, which provides options to highlight cells and cell ranges based on certain criteria.
	Edit Hyperlink – can be used to add or edit a hyperlink in the selected cell or cell range.
	Clear – Clears the contents and formatting of a cell or cell range.

Formulas

Formulas are part of the core functionality of spreadsheets, and the Formulas tab includes all of the controls needed to effectively manage your formulas.

	Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result. Using this with only one cell selected will allow you to enter cell ranges manually.
	Financial – Finance formulas include calculating interest payments and depreciation.
	Logical – Logical arguments are those that can manipulate values like true/false.
	Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more.
	Date & Time – Lets you write formulas that operate based on date and time parameters.
	Reference – Allows you to lookup references and values of a cell range.
	Math – Contains mathematical formulas including trigonometric functions and logarithms.
	Define Name – Lets you name a particular cell or cell range, its range, and which sheets make up its scope.
	Name Manager – Displays all of the named cells and cell ranges in the spreadsheet.
	Recalculate – Forces the selected formula to be recalculated. Useful for applying changes made to updated formulas and cells.
	Insert Function – Contains a list of all the formulas available in OfficeSuite alongside detailed descriptions of their functionality:
	Common – Contains more commonly used formulas, like AVERAGE and SUM. All – Displays the full list of formulas currently available in OfficeSuite. Math & Trig – Contains mathematical formulas including trigonometric functions and logarithms. Logical – Logical arguments are those that can manipulate values like true/false. Statistical – Provides formulas found in statistics like standard deviation and frequency. Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more. Reference – Allows you to lookup references and values of a cell range. Date & Time – Lets you write formulas that operate based on date and time parameters. Finance – Finance formulas include calculating interest payments and depreciation. Information – Informational formulas allow you to make adjustments based on cell conditions, such as whether cells contain even numbers, return errors, and others. Database – Contains database-related formulas such as maximum and minimum database values or extracting records from a database.

Data

The Data tab houses options like Sort, Filter and others, especially useful when working with large quantities of data.

	Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order.
	Filter – A great way for managing large amounts of data, Filter manipulates entire cell ranges to display specific entries. Once you apply a filter to a cell range, press the Down arrow that appears in the cell range to display the Filter dialog:
	Clear Filter – Removes any active filter. Smallest to Largest – Lists values in ascending order. Largest to Smallest – Lists values in descending order. Custom Filter – Provides a wide range of comparison filters that display values that meet particular criteria, such as greater than or equal to. Multiple Choice – Lets you toggle the display of individual cell values. All blanks – Displays all cells with no data. All non-blanks – Displays all cells which contain data.
	Data Validation – Limit the data that can be entered into a cell using custom values.
	Circle Invalid Cells – Circles any invalid data within the sheet for better visibility.

View

The View tab houses spreadsheet navigation controls alongside find and selection options.

	Go to Cell – Useful for large spreadsheets, this field allows you to go directly to a specific cell by entering in its coordinates (ColumnLetter:RowNumber).
	Zoom – Lets you change your view to a predefined zoom level.
	Zoom to Normal – Returns the zoom level to default.
	Freeze – Allows you to lock the display of cells and columns so that they will always display on-screen. The lock area starts at the row-column intersection of the currently selected cell.
	Cell Content – Displays a popup of the current cell contents, including values and formulas. For cell ranges, only the upper leftmost cell content will be displayed.
	Hide Gridlines – Toggles the display of gridlines (or cell borders) for individual sheets..
	Sheets – Displays a popup of all the sheets in the spreadsheet, and allows you to navigate between them.
	Charts – Displays all of the charts in the document, and can open them individually in full screen mode for easier viewing.
	Start/Stop Selection – Toggles selection mode that allows you to select multiple cells, starting with the currently selected one.
	Select All – Selects all of the cells in the spreadsheet that contain data.

Review

The Review tab houses protection and security options, as well as comment management.

	Check Spelling – Checks if there are spelling mistakes in any words that have been inserted.
	Set language – Sets the default language for spell checking.
	Comment – SAdds a comment to a cell or cell range. Commented cells are marked by a small indicator in the upper right, and will briefly appear when the cell or cell range is selected.
	Edit Comment – Adds and edits a comment to the selected cell or cell range.
	Delete Comment – Removes a comment from the selected cell or cell range.
	Protect Workbook – Used to add a password to the spreadsheet.
	Protect Sheet – Used to restrict access to specific elements in the current sheet.
	Protect Range – Used to protect the currently selected cell range.
	Protected Range Manager – Displays a list of the protected cell ranges in the spreadsheet.

Chart

The Chart tab will appear once you have selected a chart, or created one from the Insert tab.

	Done – Closes the Chart tab and applies any changes made.
	Open – Displays the chart in full screen view mode.
	Edit chart – Opens the chart insertion dialog, which allows you to edit a chart with a range of chart options. The Type tab lists charts and chart subtypes, along with a 3D effect toggle. The Data tab allows you to add and name series and ranges, while the Style tab provides options to change chart colors. You can get a visualization of your chart before committing any changes using the Preview tab.

Shape

The Shape tab appears when an image or shape has been placed in the spreadsheet using the Insert menu.

	Done – Closes the Shape tab and applies any changes made.
	Copy – Copies the graphic, a copy of which can then be pasted from the Home tab.
	View – Opens the image or shape in any of the device's image apps for better visibility.
	Edit – Allows the image to be edited using a separate image editing program.
	Restore original size – Brings the image or shape back to its original size.
	Save – Saves any changes made to the graphic in OfficeSuite as a separate image file.

Text Box

The Text Box tab appears when a text box has been placed in the spreadsheet via the Insert menu.

	Done – Closes the Text box tab and applies any changes made.
	Edit – Tapping this provides all respectable options from the File, Home and Data menus, allowing users to edit the text inside the box.

You can also tap on an already selected cell or cell range to display the cell popup menu, which provides additional options for manipulating cell data:

	Cut the selected cell data.
	Copy the selected cell data.
	Paste the selected cell data.
	Look up the selected text in an installed dictionary.
	Search the selected text online.
	Autofill the selected cell range.