To access the Spreadsheet Editor advanced settings,
- tap the
Tools icon in the right corner of the top toolbar,
- tap the arrow next to the
Application Settings menu item.
Currently, the following advanced settings are available:
- Unit of Measurement - this option allows to specify what units are used for measuring elements parameters such as width, height, spacing, margins etc. You can select the Centimeter, Point, or Inch option.
- Formula Language - this option allows to select the language for displaying and entering formula names. Currently, the following formula languages are available: Azeri - Latin, Bulgarian, Chinese - Simplified, Chinese – Traditional, Czech, Dutch, Danish, English, Finnish, French, German, Greek, Italian, Japanese, Korean, Laotian, Latvian, Polish, Portuguese, Portuguese - Brazilian, Romanian, Russian, Slovak, Slovenian, Spanish, Swedish, Turkish, Ukrainian, Vietnamese.
- Regional Settings - this option allows to select the default display format for currency and date and time.
- Commenting Display - this option allows to set, if you want to display Comments and/or Resolved Comments on the worksheet. If you enable these options, the commented cells will be marked on the sheet.
- R1C1 Reference Style - this option allows to enable the R1C1 reference style instead of the A1 reference style used by default.
- Dark theme - this option allows to switch to dark interface mode. The dark theme colors vary from black to light-gray providing a comfortable interface for working at low-light conditions.
- Macros Settings allows to choose if you want to enable all macros with or without a notification or disable all macros.