Spreadsheet locale and calculation settings | Zoho Sheet help guide

Locale and calculation settings in your spreadsheet

To customize the gridline color and font of your spreadsheet:
  1. Go to File > Spreadsheet Settings.
  2. In the Spreadsheet Settings tab under General, select the preferred Font Name, Font Size, Text Color, and Gridline Color.
  3. Click OK.


To customize the locale settings of your workbook:
  1. Go to File > Spreadsheet Settings.
  2. In the Spreadsheet Settings tab under Locale, select the Language, Display Direction, Date Format, Time Zone, Currency Symbol, Decimal Separator, Digit Grouping, and Grouping Separator using the respective drop-downs.
  3. Click OK.
Changing a spreadsheet's locale will also change the spreadsheet's date, number format, and default currency. Any changes to the locale settings the author makes, gets reflected to the entire spreadsheet. Collaborators associated with the spreadsheet will also see the changes made by the author.



To change the calculation settings:
  1. Go to Calculation > Iterative Preferences, then either choose to turn on or off the iterative calculation.
  2. If you choose to turn on the iterative calculation, then under Maximum Iterations, specify the number of times the calculation needs to be iterated. 
  3. To set a threshold for the iterations, under Threshold, specify the threshold number.
Iterative Calculation: Repetitive calculations until a certain condition is met. Can be used to apply circular references in formulas. If iterative calculation is turned off, using circular references in formulas will return error.
Maximum Iterations: The number of times the calculation needs to be repeated.
Threshold: Threshold refers to a minimum value; when the difference between the successive iterations is less than the given threshold value, the calculation stops.

      4. Under Calculation > Lookup preference, select either Regular Expressions or Wildcards based on how you prefer to search for the
          characters in your spreadsheet.                             
Regular expressions - An advanced search pattern that helps you find any text/value using single or multiple characters.
Wildcards - Wildcards use a special set of characters that can act as a substitute for the character in the word you're looking to find out.

      5. Once you're done, click OK.