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.
4. Show function tooltip - enables tips for entering functions.

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 seeing 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.

Appearance

1. 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.
   • The Gray color scheme incorporates lighter gray color and appears as a uniformly light color scheme.
   • The Turn on document dark mode option is used to make the working area darker when the editor is set to Dark or Contrast Dark interface theme. Check the Turn on document dark mode box to enable it.

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

2. Tab style - choose whether you want the currently selected tab to be filled in with a lighter color with the Fill option or to be underlined with the Line option.
3. Use toolbar color as tabs background - the color of the toolbar will be used as tabs background. The toolbar color depends on the currently selected interface theme.

Workspace

1. The Turn on screen reader support option is used to enable support of screen reader software.

2. 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 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.

3. 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.
4. Show the Quick Print button in the editor header is used in the desktop version to enable quick printing via the corresponding button at the top toolbar. The file will be printed on the last selected or default printer.
5. The RTL Interface (Beta) option is used to change the direction in which elements of the interface are displayed.

   This option is available only for interface languages that require RTL.

6. Snapped to the grid while scrolling - enables grid snapping for the scrolling process.
7. The Customize quick access button is used to choose which buttons shall be available in the top toolbar, i.e., Save, Print, Undo, and Redo.
8. 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.
9. 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%. You can also choose the Fit to Page, Fit to Width, or Last Used option.

   The Last used option refers to the last set scaling value during the current session.

10. 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.
11. 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 33 languages:

   Armenian, Belarusian, 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. Available regions: Azerbaijani, Bulgarian, Czech, Danish, German (Austria), German (Germany), German (Switzerland), Greek (Greece), English (Australia), English (Indonesia), English (United Kingdom), English (USA), Spanish (Spain), Spanish (Mexico), Finnish (Finland), French (France), French (Switzerland), Indonesian (Indonesia), Italian (Italy), Italian (Switzerland), Japanese, Korean, Latvian, Hungarian, Dutch (Netherlands), Polish (Poland), Portuguese (Brazil), Portuguese (Portugal), Slovak, Slovenian, Swedish (Finland), Swedish (Sweden), Turkish, Ukrainian, Vietnamese, Chinese, Taiwanese.
4. 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.
2. The Enable iterative calculation option is used to activate iterative calculation.
3. The Maximum iterations option is used to set the number of times formulae with circular reference will perform calculations until the cycle stops.
4. The Maximum change option is used to set the precision of iterative calculations.

The changes are saved as you go.

Return to previous page