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: English, Deutsch, Spanish, French, Italian, Russian, Polish.
- 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.
- Theme allows to change the color scheme of the editor’s interface. The available options are: Dark that incorporates black, dark gray, and light gray colors suitable for working during nighttime; Light incorporates standard blue, white, and light gray colors with less contrast in UI elements suitable for working during daytime; and Same as system makes the editor follow the interface theme of your system.
- Macros Settings allows to choose if you want to enable all macros with or without a notification or disable all macros.