Open a file
To open a file, use one of the following methods:
•If MyOffice Spreadsheet is the default application to open files of the appropriate format, double-click the file with the left mouse button. Some Linux operating systems require a single left-click to open a file.
•Right-click the file. When working in Linux, run Open in MyOffice Spreadsheet / Open with MyOffice Spreadsheet command from the context menu. When you work in Windows, run Open with command from the context menu. When working in macOS, run Open with command and select MyOffice Spreadsheet in the displayed list of applications.
•Open MyOffice Spreadsheet. In the File menu, click Open. Or press Ctrl+O or 
Cmd+O. In the File manager window that appears, select the desired file and click Open.
•Open MyOffice Spreadsheet and drag the document or its shortcut from the operating system file manager window to the open application window. You can open up to 32 files at a time by dragging and dropping them into the application window.
The document will open on the sheet on which the last data save before closing was made. If this sheet has been renamed or deleted in another application, the document opens on the first sheet.
File in .xls format
Working with files in .xls format is not supported on macOS.
When you open a file in .xls format, it is automatically converted to .xlsx format. To save a file in .xlsx format, follow the steps described in the Save a file section. |
File in .xlsb format
Working with files in .xlsb format is not supported on macOS.
When you open a file in .xlsb format, a copy of that file in a different format is opened. To save a copy of the file or replace the original .xlsb file with a copy, follow the steps in Save File section. |
File in .xml format
When you open a file in .xml format, a document is created with a table on the first sheet containing data from the file. The table is given a name in the format of Table N, for example, “Table 1” and the default design style is applied. All the features of tables are available for the created spreadsheet. The following restrictions apply to files in .xml format: •Only XML 1.0 files are processed. •The XML file association is not provided. •Schemas referenced by the XML file are not processed. •The maximum number of columns in a file is 16,384. •The maximum number of rows in a file is 1,048,576. |
View-only file
If the Read-only property is set for a file by the OS tools, then: •This file is opened in the View mode. •A notification “The document is view-only” is displayed on the Toolbar. The file is opened in the Edit mode if you work with it using the WebDAV protocol or if it has the *.xlsm, *.xls,*.xlsb extension.
In the View mode, you cannot make changes to the document or change its formatting. If necessary, you can create a copy of this document that can be edited. To do this, click Edit a Copy on the Toolbar. A copy of the document will open in a new application window. To save the file copy, follow the steps described in the Save a file section. |
File is being used by another application
If the file is opened for editing in another application, then: •This file is opened in the View mode. •The Toolbar displays a notification that the document is opened in another application. The file is opened in the Edit mode if it has an *.xlsm, *.xls or *.xlsb extension or is opened in another application, but that application has not created a lock file.
In the View mode, you cannot make changes to the document or change its formatting. To edit a document, do one of the following: •Finish working with the document in another application. Then, in MyOffice Spreadsheet, click Check Availability on the Toolbar. If working with a document in another application is not completed, the pop-up message “Document is still in use” will be displayed. If the work is completed, the document will switch to the Edit mode. •Create an editable copy of the document. To do this, in MyOffice Spreadsheet, on the Toolbar, click Edit a Copy. A copy of the document will open in a new application window. To save the file copy, follow the steps described in the Save a file section. |
File is opened by another user
When you try to open a local document opened by another user on the same computer, a dialog box is displayed that contains: •Information about the user who is currently working with this document. •Open a Copy button to create an editable copy of the document. •Close button to finish working with the document. A file is opened in the Edit mode if it has *.xlsm, *.xls or *.xlsb extension.
|
