OfficeSuite for iOS supports all of the major Excel spreadsheet types including .XLS, .XLSX, .CSV, and .ODS (available in OfficeSuite Pro/Premium only). To access the Spreadsheet Editor, either open or create a new spreadsheet from the OfficeSuite Homescreen.
The Contextual menu provides additional options for the Spreadsheet Editor:
|Save – Saves any changes you have made to the document.|
|Save As – Saves any changes you have made to the document, but gives you the option to change the file type or name of the file.|
|Export to PDF – Export the file to PDF.|
|Print – Print the document, options include:|
|Share – Allows you to share the document. The options include to Email it, Zip & Email it, as well as to Open it in Another App.|
|Protect – Set a user-generated password. Please note that document passwords are not recoverable. To remove a document password, simply select the Protect option again.|
|Help – Opens this help documentation.|
|About – Displays the app version number, useful links, and the third party libraries used in OfficeSuite. From here you can also apply to become an OfficeSuite Beta tester.|
While editing, you can tap on the Undo/Redo icon to retract the latest change you have made. Holding down on this icon will reveal the Redo option, where you can reapply changes.
There is also a Fullscreen icon, which will hide the Spreadsheet Editor toolbars for easier viewing. To exit fullscreen mode, press the Minimize icon.
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.
You can drag and drop cells and cell ranges by briefly holding down on the selection, and moving them to a new location in the spreadsheet. OfficeSuite will automatically update any associated formulas and references to match your changes.
OfficeSuite's Popup menu appears upon selecting more than one cell in a spreadsheet. It provides a range of quick access shortcuts:
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.
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.
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.
|Arial||Font Families – Opens the font menu, which lists your available OfficeSuite fonts in their relevant style.|
|12||Font Size – Adjusts font size, in pixels. Can be incremented by using the - and + buttons, or to a predefined value by tapping on the number.|
|Bold – Embolden text.|
|Italics – Italicize text.|
|Underline – Underline text.|
|Double Underline – Underlines text with two lines.|
|Strikethrough – Add a strikethrough effect to text.|
|Align Left – Aligns text against the left margin.|
|Align Center – Centers text between both margins.|
|Align Right – Aligns text against the right margin.|
|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.|
|Font Color – Specify the text color.|
|Highlight Color – Specify the highlight color.|
|Paste – Place cut or copied elements in your document.|
|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 – Copy the formatting from one text selection to another.|
|Wrap Text – Allows text to be wrapped within a cell, so that it does not get obscured by the cell boundaries.|
|Merge and Center – 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:|
|Insert – Gives you the option to insert cells, rows, columns and worksheets.|
|Delete – Deletes the selected rows or columns of the spreadsheet, or the currently active sheet.|
|Go to – Useful for large spreadsheets, this field allows you to go directly to a specific cell by entering in its coordinates (RowNumber:ColumnLetter).|
The Insert tab is used for placing a wide range of visual additions to your spreadsheets, such as graphics and charts.
|Table – Include a table in the spreadsheet, a new Table tab will appear, the options of which include:|
|Picture – Inserts an image into your spreadsheet from your iOS Photos app. You may be prompted to grant OfficeSuite access to your Photos in order for this feature to work. Placed images can be modified using the resize and scale anchors, and rotated using the protruding rotate anchor.|
|Camera Picture – Allows you to insert an image using your iPhone or iPad camera.|
|Row Above – Inserts a blank row above the currently selected cell.|
|Column Left – Inserts a blank column to the left of the currently selected cell.|
|Chart – Inserts a custom chart with a data range you specify. Selected charts can be modified using the Chart tab.|
|Chart in a New Sheet – Provides identical options to the chart item, except the chart will be inserted into a separate sheet in the spreadsheet. Selected charts can be modified using the Chart tab.|
|Comment – Adds a comment to a cell. Commented cells are marked by a small red indicator in the upper right.|
|Hyperlink – Marks the contained cell elements as a hyperlink to a website, email address, or a reference in the current spreadsheet.|
The Format tab is a quick way adjust the formatting of the various elements of your spreadsheet. This also includes 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.|
|Cell Font – Changes the formatting of cells and cell ranges. Besides horizontal and vertical alignment, you can adjust font size, style, color, indentation, and more.|
|Cell Border – Provides options for specifying cell borders on cells or cell ranges.|
|Cell Style – Allows you to customize your cells from a selection of available built-in themes.|
|Cell Protection – Allows you to lock cells or hide formulas in them. Note that these setting take effect only in protected sheets (you can make a sheet protected from the Review tab).|
|Hide Rows – Hides (but does not delete) cell rows from view. Hidden rows are marked by a Red arrow along the row number column, and can be shown using Unhide Rows.|
|Unhide Rows – Reveals hidden rows. Can only be accessed from selected neighboring unhidden rows.|
|Auto-Fit Rows – Rezises rows to fit the character width of their data.|
|Hide Columns – Hides (but does not delete) cell columns from view. Hidden columns are marked by a Red arrow along the column letter row, and can be shown using Unhide Columns.|
|Unhide Columns – Reveals hidden columns. Can only be accessed from selected neighboring unhidden columns.|
|Auto-Fit Columns – Rezises columns to fit the character width of their data.|
|Rename Sheet – Renames the individual sheets of your spreadsheet.|
|Tab Colour – Distinguish your tabs from one another by inserting different colours to them.|
|Conditional Formatting – Opens the conditional formatting dialog, which provides options to highlight cells and cell ranges based on certain criteria.|
|Edit Hyperlink – Used to add or edit a hyperlink in the selected cell or cell range.|
|Clear – Clears the contents of a cell or cell range. Also allows you to selectively clear just formatting, contents, comments, or hyperlinks.|
Formulas are part of the core functionality of spreadsheets, and the Formulas tab includes all of the controls needed to effectively manage your formulas.
|Insert Function – Contains a list of all the formulas offered by OfficeSuite for iOS alongside detailed descriptions of their functionality:|
|Define Name – Lets you name a particular cell or cell 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.|
|Auto Sum – Performs quick calculations of the numbers in a selected cell range and displays the result:|
|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.|
The Data tab allows you to organize and validate the data in your spreadsheet, as well as to manage the cases of invalid data. Options include:
|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:|
|Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order:|
|Data Validation – A very practical way of managing what type of data can be inserted in specific places in your spreadsheet, based on pre-defined criteria such as data type, length and more. Any data not matching the criteria will return an error message. Options for Data Validation include:|
|Circle Invalid Data – Allows you to quickly see the cases in which data inserted into the sheet does not match the criteria of Data Validation.|
|Group – Group a range of rows or columns.|
|Ungroup – Ungroup a range of rows or columns.|
|Show Detail – Expand a group of previously hidden cells.|
|Hide Detail – Collapse a group of cells.|
The View tab houses spreadsheet navigation controls alongside find and selection options.
|Zoom – Lets you change your view to a predefined zoom level.|
|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).|
|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.|
|Show Gridlines – Toggles the display of gridlines (or cell borders).|
|Show Headings – Toggles the display of headings (the vertical bar displaying the row number and the horizontal one displaying the column letter).|
|Right-to-Left Sheet – Create a Right-to-Left sheet. Very helpful when inserting data in RTL languages such as Hebrew, Arabic or Farsi.|
|Start Selection – Toggles selection mode that allows you to select multiple cells, starting with the first one.|
|Select All – Selects all of the cells in the spreadsheet that contain data.|
|Find & Replace – Searches for instances of text entered in the Search field, and will replace them with text entered in the Replace field. Browsing between search results is done with the Back and Forth arrows. The Gear icon provides options to:|
The Review tab houses options for comment management.
|Add/Edit Comment – Adds or edits a comment in the selected cell.|
|Delete Comment – Removes a comment from the selected cell.|
|Protect Sheet – Allows you to limit the access of users to the sheet by setting a password on it. Please note that passwords are not recoverable if forgotten. Another options in Protect Sheets is to define what kind of operations users will be allowed to do on it (such as formatting cells/columns, insert hyperlinks, delete rows/columns and many more.)|
The Chart tab will appear once you have created and selected a chart (from the Insert tab).
|Type – Changes the chart type from a list of predefined formats. Can be modified after the chart is initially created.|
|Format – Provides options for the customization of all chart elements:|
|Elements – Provides additional customization in the form of data kabels, gridlines and more.|
|Chart Layouts – Select a different layout for your chart.|
|Colors – Select the colour palette used in the chart.|
|Chart Styles – Presents several preset styles to change how the chart looks.|
|Switch Rows/Columns – Rotate data from columns to rows and vice versa.|
|Delete – Removes the chart from your spreadsheet.|
The Table tab will appear once you have created and selected a table (from the Insert tab).
|Table name – Select the name of the table.|
|Table Range – Set the dimensions of the page. By tapping this icon arrows will appear on the edges of the table, use them to set the desired size of the table.|
|Styles – Adjusts the table color scheme from a list of predefined styles.|
|Convert to Range – Tapping this icon will remove the table and all entries and names in it will become a part of the spreadsheet.|