Spreadsheet Editor

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:
	Printer – Select which printer to use. Copies – How many copies to make. Range – Select which parts of the document to print.
	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:

• Cut the selected data to the clipboard.
• Copy the selected data to the clipboard.
• Paste data from the clipboard into the selected cell or cell range.
• Insert a new row or column.
• Delete a row or column.
• Fill reveals the autofill anchors, which can be used to autofill a dataset based on the data within the selected cells. For example, selecting two cells with 1 and 2 as their dataset will autofill ...3, 4, 5, 6... in the direction in which you drag the autofill anchors.
• Clear removes a information from a selected cell range. This can be either formatting, contents, comments, hyperlinks, or all of the above.
• Freeze locks the position above and to the left of the selected cells so that they are always visible when scrolling.
• Turn Filters ON/OFF toggles filters for the selected cell range. For more on filters, see the Filter entry in the Home tab below.

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:
	Sum – Adds up the numbers in the cell range. Average – Displays the average value of the numbers in the cell range. Count – Counts the number of cells in the range that contain numbers. Max – Displays the largest value of the numbers in the cell range. Min – Displays the smallest value of the numbers in the cell range. Median – Displays the middle number of the numbers in the cell range.
	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:
	Common – Contains more commonly used formulas, like AVERAGE and SUM. All – Displays the full list of formulas currently available in OfficeSuite. Database – Contains database-related formulas such as maximum and minimum database values or extracting records from a database. Information – Informational formulas allow you to make adjustments based on cell conditions, such as whether cells contain even numbers, return errors, and others. Logical – Logical arguments are those that can manipulate values like true/false. Math – Contains mathematical formulas including trigonometric functions and logarithms. Date & Time – Lets you write formulas that operate based on date and time parameters. Statistical – Provides formulas found in statistics like standard deviation and frequency. Financial – Finance formulas include calculating interest payments and depreciation. Lookup – Allows you to lookup references and values of a cell range. Text – Text formulas offer options for capitalizing text entries, replacing characters, searching for entries, and more. Compatibility – Contains advanced mathematical conversions including binomial distribution and standard deviation.
	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:
	Sum – Adds up the numbers in the cell range. Average – Displays the average value of the numbers in the cell range. Count – Counts the number of cells in the range that contain numbers. Max – Displays the largest value of the numbers in the cell range. Min – Displays the smallest value of the numbers in the cell range. Median – Displays the middle number of the numbers in the cell range.
	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:
	Clear Filter – Removes any active filter. Reapply Filter – Reapplies the most recent active filter. Comparison Filter – Will filter out results that are less than, greater than, equal, or not equal to a specific value. The And/Or boxes can be used for applying additional comparisons. Multiple Selection – Lets you toggle the display of individual cells. (Show all) can be used to select/deselect all the cells. Above Average – Displays only the cells which are above the average value of the cell range. Below Average – Displays only the cells which are below the average value of the cell range. Top N – Can show the top/bottom N percent/number of items, where N is a specified number that you can adjust using the - and + arrows next to Count.
	Sort – Provides options to sort data by multiple criteria simultaneously. You can sort by both rows and columns, in ascending or descending order:
	My Data Has Headers – Specifies whether you have included headers or title cells as part of your selected cell range. Case Sensitive – Specifies whether your sort options should take into account capitalization.
	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:
	Criteria – Defines the criteria by which data inserted into the selected file will be validated. Options include Any value, Whole number, Decimal, List, Date, Time and Text Length. Error Alert – Allows you to set what kind of alert message will appear if data inserted into a cell does not meet the aforementioned Criteria. You can choose whether or not to receive an error alert at all using the Show error alert toggle, choose what style the alert will be (Error/Warning/Information), the Title of the alert and lastly, allows you to type in a Message that will display upon triggering the error alert. Input Message – You can set up messages giving further information and instructions on filling out spreadsheets heavily reliant on Data Validation. Options include to set whether a message will be shown at all using the Show input message toggle, give the message a Title and lastly, type out the Message itself.
	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:
	Match Case – 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. Look in – Will search either through cell values or cell formulas.

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:
	Chart Title – Toggles the display of a chart title. Enabling this will reveal a Title entry. Horizontal Labels – Allows you to enter labels for each data set, separated by commas. These labels can automatically be populated from the cell range that contains the data, if applicable. Data Range – Displays the cell ranges that contain the chart data, and whether it is in rows or columns. Legend Entries – Lets you modify the values which compose the chart data, separated by commas. These values can automatically be populated from the cell range that you select to create the chart.
	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.