Screen elements

The Control bar is located above the Command menu.

The Control bar includes the following elements:

• button: Allows to go to other applications and to the main navigation page.

•File name and extension, which is a full name of the file you are working on.

• Mark as important or  Unmark button: Allows to add or delete the opened file to/from the favorites. The file marked as favorite is duplicated in the Flagged folder in MyOffice Files.

•Share button: Allows to open the form where users can provide shared access.

• Help: Allows to open help materials, the release notes with the description of the recent updates of the application and a window with information on the version of the application. Send  feedback hyperlink (displayed if a mail client is connected and a support service mail address was specified by the system administrator in the MyOffice Documents Online settings). The button may contain the  indicator informing that there are updates to the application. The indication will be displayed for 14 calendar days from the date of system update until the user checks the information about the changes.

•User profile picture with user initials or photo. Clicking this button will display the user profile.

Send feedback hyperlink

If a mail client is connected and the system administrator has specified the mailing address of the support service in the MyOffice Documents Online settings, when clicking on Send feedback will open a new tab in the browser containing the feedback form. Fill in the Topic field and describe your issue in the Message field. Click Submit to send your feedback.

The Command menu of MyOffice Spreadsheet contains the menus reflecting the core features of the application.

In the document editing mode, the Command menu contains the following menus:

•File

•Edit

•Insert

•Format

•Table

•Data

•Tools

•View

•Help

In the document view mode, the Command menu contains the following menus:

•File

•View

•Help

The Toolbar contains formatting tools for working with cells, rows and columns, text, charts, and shapes. The tools are displayed depending on the selected document content.

The size of the Toolbar varies depending on the size of the web browser window. If the window size does not allow displaying the entire Toolbar, some of the tools will be hidden. Hidden tools are displayed by clicking  More on the Toolbar.

In documents available to the user for viewing only, the Toolbar is not displayed.

The formula bar is the line which you can edit to enter, modify, and view data and formulas. The formula bar displays the real contents of the selected cell. The formula bar always displays the text in black, regardless of the color that the user selects for the text in the cell.

The formula bar can be stretched, expanded/collapsed, or configured to auto-adjust the line to the data of the selected cell.

Stretch the formula bar

To enlarge or reduce the formula bar by the value of your choice, do the following:

1.Hold the cursor over the bottom border of the formula bar until it looks like a double-sided arrow.

2.Press the left mouse button to move the border of the formula bar to the desired mark.

3.Release the left mouse button to set the selected value.

The maximum height to which the formula bar can be enlarged as a result of stretching is no more than half the current size of the table's workspace.

Once the formula bar is stretched:

•The  Expand formula bar button on the right part of the formula bar will change to  Collapse formula bar.

•The height of the formula bar set by the user for a cell becomes the default value for that cell.

Expand/collapse the formula bar

To increase or decrease the size formula bar by the selected value, click  Expand formula bar/ Collapse formula bar on the right side of the formula bar. Or use the Command menu and select View > Formula bar > Expand formula bar or Collapse formula bar. If the user has previously stretched the formula bar, clicking Expand formula bar will expand the formula bar to the value set by the user.

Automatically adjust the formula bar

To automatically adjust the formula bar to the size of the data in a cell, click  Fit to data on the right side of the formula bar. Or check View > Formula bar > Fit formula bar to data.

Repeat the operation to disable automatic adjustment.

The maximum height to which the formula bar can be increased when automatic data fitting is turned on is 10% of the workspace size at most.

The workspace displays the contents of the sheet selected by the user. The workspace is colored in white.This area falls within the page boundary when printed. For more details, see Printing area

You can expand the workspace by adding rows and columns. For more details, see Add rows and columns

If you want to open a password-protected file, you will be warned to delete the password and upload the document again.

The Sidebar is an interactive element of MyOffice Spreadsheet interface which allows for accessing to the additional features of the spreadsheet editor.

The Sidebar includes the following buttons:

• File info: Opens the tab with information about the document you are working on.

• Find and replace: Opens the dialog box that allows to search for a specific text throughout the document and replace words with words of your choice.

• Insert function: Opens the insert function pane.

•All validations: Opens the All validations tab.

• Name manager: Opens the Name manager tab.

The Sidebar may contain avatars of co-authors (users working simultaneously with the active document), if the spreadsheet document is open with users who have been granted shared access.

File info tab

To see the information about the file, click  File info on the Sidebar. Or go to the Command menu and select File > Info.

This tab displays short information about the file you are working on:

•Path. Click the folder name to go to the folder where the file is located.

•File size

•The date of creation and the name of the author of the file/folder. When you hold the cursor over the username, a pop-up window will appear with additional information about the user and the Details button to view detailed information about this user in the MyOffice Contacts application (when integrated with MyOffice Mail).

•The date of the last modification of the file/folder and the name of the user who made the edits last. When you hold the cursor over the username, a pop-up window will appear with additional information about the user and the Details button to view detailed information about this user in the MyOffice Contacts application (when integrated with MyOffice Mail).

•Access permission type (only for files that had been shared with the user by other users)

•A list of users and groups that have been provided with access (with their access rights), as well as the Share (for the document owner) / Decline access (for users who have been granted access rights) hyperlink.

•A list of users and groups that with access permissions and information about the access permission type. If the user is a member of an access group, a tooltip is displayed next to the group name. Hold over the user's avatar or username to view more information about the user. If necessary, click Details in the pop-up window to view the contact information in MyOffice Contacts in a new tab of the web browser (when integrated with MyOffice Mail).

Find and replace

To open the search pane, click  Find and replace in the Sidebar (for more information, see Find and replace).

Insert function pane

To open the Insert function pane, click  Insert function on the Sidebar (for more information, click Enter functions).

The sheet tabs allow for quick navigation between sheets. Right-click the sheet name to display the actions that you can perform.

The Status bar displays notifications on the actions performed in the application, the status of changes made, the values of the most frequently used functions, as well as the scale management tools.

The application notifications include:

•All changes saved

•Saving

•Inserting image

•Preparing for print

•Preparing File (when downloading a file)

•Offline