Advanced Settings of the Spreadsheet Editor

The Spreadsheet Editor allows you to change its general advanced settings. To access them, open the File tab on the top toolbar and select the Advanced Settings option.

The advanced settings are grouped as follows:

Editing and saving

1. Autosave is used in the online version to turn on/off automatic saving of changes made during the editing process.
2. Autorecover is used in the desktop version to turn on/off the option that allows you to automatically recover spreadsheets if the program closes unexpectedly.
3. Show the Paste Options button when the content is pasted. The corresponding icon will appear when you paste content in the spreadsheet.

Collaboration

1. The Co-editing mode subsection allows you to set the preferable mode for seeing changes made to the spreadsheet when working in collaboration.
   • Fast (by default). The users who take part in the spreadsheet co-editing will see the changes in real time once they are made by other users.
   • Strict. All the changes made by co-editors will be shown only after you click the Save
     icon that will notify you about new changes.
2. Show changes from other users. This feature allows to see changes made by other users in the spreadsheet opened for viewing only in the Live Viewer mode.
3. Show comments in text. If you disable this feature, the commented passages will be highlighted only if you click the Comments
   icon on the left sidebar.
4. Show resolved comments. This feature is disabled by default so that the resolved comments are hidden in the spreadsheet. You can view such comments only if you click the Comments
   icon on the left sidebar. Enable this option if you want to display resolved comments in the spreadsheet.

Workspace

1. The R1C1 reference style option is disabled by default and the A1 reference style is used.

   When the A1 reference style is used, columns are designated by letters, and rows are designated by numbers. If you select the cell located in row 3 and column 2, its address displayed in the box to the left of the the formula bar looks like this: B3. If the R1C1 reference style is enabled, both rows and columns are designated by numbers. If you select the cell at the intersection of row 3 and column 2, its address will look like this: R3C2. Letter R indicates the row number and letter C indicates the column number.

   

   In case you refer to other cells using the R1C1 reference style, the reference to a target cell is formed based on the distance from an active cell. For example, when you select the cell in row 5 and column 1 and refer to the cell in row 3 and column 2, the reference is R[-2]C[1]. The numbers in square brackets designate the position of the cell relative to the current cell position, i.e. the target cell is 2 rows up and 1 column to the right of the active cell. If you select the cell in row 1 and column 2 and refer to the same cell in row 3 and column 2, the reference is R[2]C, i.e. the target cell is 2 rows down from the active cell and in the same column.

2. The Use Alt key to navigate the user interface using the keyboard option is used to enable using the Alt / Option key in keyboard shortcuts.
3. The Interface theme option is used to change the color scheme of the editor’s interface.
   • The Same as system option makes the editor follow the interface theme of your system.
   • The Light color scheme incorporates standard blue, white, and light gray colors with less contrast in UI elements suitable for working during daytime.
   • The Classic Light color scheme incorporates standard blue, white, and light gray colors.
   • The Dark color scheme incorporates black, dark gray, and light gray colors suitable for working during nighttime.
   • The Contrast Dark color scheme incorporates black, dark gray, and white colors with more contrast in UI elements highlighting the working area of the file.

     Note: Apart from the available Light, Classic Light, Dark, and Contrast Dark interface themes, ONLYOFFICE editors can now be customized with your own color theme. Please follow these instructions to learn how you can do that.

4. The Unit of Measurement option is used to specify what units are used on the rulers and in properties of objects when setting such parameters as width, height, spacing, margins etc. The available units are Centimeter, Point, and Inch.
5. The Default Zoom Value option is used to set the default zoom value, selecting it in the list of available options from 50% to 500%.
6. The Font Hinting option is used to select how fonts are displayed in the Spreadsheet Editor.
   • Choose As Windows if you like the way fonts are usually displayed on Windows, i.e. using Windows font hinting.
   • Choose As OS X if you like the way fonts are usually displayed on a Mac, i.e. without any font hinting at all.
   • Choose Native to display the text with hinting embedded into the font files.
   • Default cache mode - used to select the cache mode for the font characters. It’s not recommended to switch it without any reason. It can be helpful in some cases only, for example, when an issue with the enabled hardware acceleration in the Google Chrome browser occurs.

     The Spreadsheet Editor has two cache modes:

     1. In the first cache mode, each letter is cached as a separate picture.
     2. In the second cache mode, a picture of a certain size is selected where letters are placed dynamically and a mechanism of allocating/removing memory in this picture is also implemented. If there is not enough memory, a second picture is created, etc.

     The Default cache mode setting applies two above mentioned cache modes separately for different browsers:

     • When the Default cache mode setting is enabled, Internet Explorer (v. 9, 10, 11) uses the second cache mode, other browsers use the first cache mode.
     • When the Default cache mode setting is disabled, Internet Explorer (v. 9, 10, 11) uses the first cache mode, other browsers use the second cache mode.
7. The Macros Settings option is used to set macros display with a notification.
   • Choose Disable All to disable all macros within the spreadsheet.
   • Choose Show Notification to receive notifications about macros within the spreadsheet.
   • Choose Enable All to automatically run all macros within the spreadsheet.

Regional Settings

1. The Formula Language option is used to select the language for displaying and entering formula names, argument names, and descriptions.

   Formula language is supported for 32 languages:

   Belarussian, Bulgarian, Catalan, Chinese, Czech, Danish, Dutch, English, Finnish, French, German, Greek, Hungarian, Indonesian, Italian, Japanese, Korean, Lao, Latvian, Norwegian, Polish, Portuguese (Brazil), Portuguese (Portugal), Romanian, Russian, Slovak, Slovenian, Spanish, Swedish, Turkish, Ukrainian, Vietnamese.

2. The Region option is used to set the display mode for currency, date, and time.
3. The Use separators based on regional settings option is enabled by default, the separators will correspond to the set region. To set custom separators, uncheck this option and enter the required separators in Decimal separator and Thousands separator fields.

Proofing

1. The Dictionary language option is used to set the preferred dictionary for the spell checking.
2. Ignore words in UPPERCASE. Words typed in capital letters are ignored during the spell checking.
3. Ignore words with numbers. Words with numbers in them are ignored during the spell checking.
4. The AutoCorrect options menu allows you to access the autocorrect settings such as replacing text as you type, recognizing functions, automatic formatting etc.

Calculating

1. The Use 1904 date system option is used to calculate dates by using January 1, 1904, as a starting point. It can be useful when working with spreadsheets created in MS Excel 2008 for Mac and earlier MS Excel for Mac versions.

To save the changes you made, click the Apply button.

Return to previous page