public WorkbookSettings() 
{
    initialFileSize = DEFAULT_INITIAL_FILE_SIZE;
    arrayGrowSize = DEFAULT_ARRAY_GROW_SIZE;
    localeFunctionNames = new HashMap();
    excelDisplayLanguage = CountryCode.USA.getCode();
    excelRegionalSettings = CountryCode.UK.getCode();
    refreshAll = false;
    template = false;
    excel9file = false;
    windowProtected = false;
    hideobj = HIDEOBJ_SHOW_ALL;
    // Initialize other properties from the system properties
    try
    {
      boolean suppressWarnings = Boolean.getBoolean("jxl.nowarnings");
      setSuppressWarnings(suppressWarnings);
      drawingsDisabled        = Boolean.getBoolean("jxl.nodrawings");
      namesDisabled           = Boolean.getBoolean("jxl.nonames");
      gcDisabled              = Boolean.getBoolean("jxl.nogc");
      rationalizationDisabled = Boolean.getBoolean("jxl.norat");
      mergedCellCheckingDisabled =
        Boolean.getBoolean("jxl.nomergedcellchecks");
      formulaReferenceAdjustDisabled =
                                Boolean.getBoolean("jxl.noformulaadjust");
      propertySetsDisabled = Boolean.getBoolean("jxl.nopropertysets");
      ignoreBlankCells = Boolean.getBoolean("jxl.ignoreblanks");
      cellValidationDisabled = Boolean.getBoolean("jxl.nocellvalidation");
      autoFilterDisabled = !Boolean.getBoolean("jxl.autofilter"); 
             // autofilter currently disabled by default
      useTemporaryFileDuringWrite = 
        Boolean.getBoolean("jxl.usetemporaryfileduringwrite");
      String tempdir =
        System.getProperty("jxl.temporaryfileduringwritedirectory");
      if (tempdir != null)
      {
        temporaryFileDuringWriteDirectory = new File(tempdir);
      }
      encoding = System.getProperty("file.encoding");
    }
    catch (SecurityException e)
    {
      logger.warn("Error accessing system properties.", e);
    }
    // Initialize the locale to the system locale
    try
    {
      if (System.getProperty("jxl.lang")    == null ||
          System.getProperty("jxl.country") == null)
      {
        locale = Locale.getDefault();
      }
      else
      {
        locale = new Locale(System.getProperty("jxl.lang"),
                            System.getProperty("jxl.country"));
      }
      if (System.getProperty("jxl.encoding") != null)
      {
        encoding = System.getProperty("jxl.encoding");
      }
    } 
    catch (SecurityException e)
    {
      logger.warn("Error accessing system properties.", e);
      locale = Locale.getDefault();
    }
}

Default constructor

 public int getArrayGrowSize() 
{
    return arrayGrowSize;
}

Accessor for the array grow size property

 public boolean getAutoFilterDisabled() 
{
    return autoFilterDisabled;
}

Accessor for the autofilter disabled feature

 public boolean getCellValidationDisabled() 
{
    return cellValidationDisabled;
}

Accessor for the ignore cell validation

 public int getCharacterSet() 
{
    return characterSet;
}

Accessor for the character set. This value is only used for reading and has no effect when writing out the spreadsheet

 public boolean getDrawingsDisabled() 
{
    return drawingsDisabled;
}

Gets the drawings disabled flag

 public String getEncoding() 
{
    return encoding;
}

Accessor for the character encoding

 public boolean getExcel9File() 
{
    return excel9file;
}

Has this file been written by excel 2000?

 public String getExcelDisplayLanguage() 
{
    return excelDisplayLanguage;
}

Returns the two character ISO 3166 mnemonic used by excel for user language displayto display

 public String getExcelRegionalSettings() 
{
    return excelRegionalSettings;
}

Returns the two character ISO 3166 mnemonic used by excel for its regional settings

 public boolean getFormulaAdjust() 
{
    return !formulaReferenceAdjustDisabled;
}

Accessor for the formula adjust disabled

 public FunctionNames getFunctionNames() 
{
    if (functionNames == null)
    {
      functionNames = (FunctionNames) localeFunctionNames.get(locale);
      // have not previously accessed function names for this locale,
      // so create a brand new one and add it to the list
      if (functionNames == null)
      {
        functionNames = new FunctionNames(locale);
        localeFunctionNames.put(locale, functionNames);
      }
    }
    return functionNames;
}

Gets the function names. This is used by the formula parsing package in order to get the locale specific function names for this particular workbook

 public boolean getGCDisabled() 
{
    return gcDisabled;
}

Accessor for the disabling of garbage collection

 public int getHideobj() 
{
    return hideobj;
}

The HIDEOBJ record stores options selected in the Options dialog,View tab Possible values are: HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS

 public boolean getIgnoreBlanks() 
{
    return ignoreBlankCells;
}

Accessor for the ignore blanks flag

 public int getInitialFileSize() 
{
    return initialFileSize;
}

Accessor for the initial file size property

 public Locale getLocale() 
{
    return locale;
}

Returns the locale used by JExcelAPI to read the spreadsheet

 public boolean getMergedCellCheckingDisabled() 
{
    return mergedCellCheckingDisabled;
}

Accessor to retrieve the merged cell checking flag

 public boolean getNamesDisabled() 
{
    return namesDisabled;
}

Accessor for the disabling of interpretation of named ranges

 public boolean getPropertySetsDisabled() 
{
    return propertySetsDisabled;
}

Accessor to retrieve the property sets disabled flag

 public boolean getRationalizationDisabled() 
{
    return rationalizationDisabled;
}

Accessor to retrieve the rationalization flag

 public boolean getRefreshAll() 
{
    return refreshAll;
}

When true then Refresh All should be done on all external data ranges and PivotTables when loading the workbook (the default is =0)

 public boolean getTemplate() 
{
    return template;
}

Workbook Is a Template

 public File getTemporaryFileDuringWriteDirectory() 
{
    return temporaryFileDuringWriteDirectory;
}

Used in conjunction with the UseTemporaryFileDuringWrite setting to set the target directory for the temporary files. This value can be NULL, in which case the normal system default temporary directory is used instead

 public boolean getUseTemporaryFileDuringWrite() 
{
    return useTemporaryFileDuringWrite;
}

Accessor for the temporary file during write. If this is set, then when the workbook is written a temporary file will be used to store the interim binary data, otherwise it will take place in memory. Setting this flag involves an assessment of the trade-offs between memory usage and performance

 public boolean getWindowProtected() 
{
    return windowProtected;
}

 public String getWriteAccess() 
{
    return writeAccess;
}

 public  void setArrayGrowSize(int sz) 
{
    arrayGrowSize = sz;
}

Sets the amount of memory by which to increase the amount of memory allocated to storing the workbook data. For processeses reading many small workbooks inside a WAS it might be necessary to reduce the default size Default value is 1 megabyte

 public  void setAutoFilterDisabled(boolean disabled) 
{
    autoFilterDisabled = disabled;
}

Sets the autofilter disabled

 public  void setCellValidationDisabled(boolean cv) 
{
    cellValidationDisabled = cv;
}

Sets the ignore cell validation flag

 public  void setCharacterSet(int cs) 
{
    characterSet = cs;
}

Sets the character set. This is only used when the spreadsheet is read, and has no effect when the spreadsheet is written

 public  void setDrawingsDisabled(boolean b) 
{
    drawingsDisabled = b;
}

Disables the handling of drawings

 public  void setEncoding(String enc) 
{
    encoding = enc;
}

Sets the encoding for this workbook

 public  void setExcel9File(boolean excel9file) 
{
    this.excel9file = excel9file;
}

 public  void setExcelDisplayLanguage(String code) 
{
    excelDisplayLanguage = code;
}

Sets the language in which the generated file will display

 public  void setExcelRegionalSettings(String code) 
{
    excelRegionalSettings = code;
}

Sets the regional settings for the generated excel file

 public  void setFormulaAdjust(boolean b) 
{
    formulaReferenceAdjustDisabled = !b;
}

Setter for the formula adjust disabled property

 public  void setGCDisabled(boolean disabled) 
{
    gcDisabled = disabled;
}

Sets the garbage collection disabled

 public  void setHideobj(int hideobj) 
{
    this.hideobj = hideobj;
}

The HIDEOBJ record stores options selected in the Options dialog,View tab Possible values are: HIDEOBJ_HIDE_ALL, HIDEOBJ_SHOW_ALL and HIDEOBJ_SHOW_PLACEHOLDERS

 public  void setIgnoreBlanks(boolean ignoreBlanks) 
{
    ignoreBlankCells = ignoreBlanks;
}

Sets the ignore blanks flag

 public  void setInitialFileSize(int sz) 
{
    initialFileSize = sz;
}

Sets the initial amount of memory allocated to store the workbook data when reading a worksheet. For processeses reading many small workbooks inside a WAS it might be necessary to reduce the default size Default value is 5 megabytes

 public  void setLocale(Locale l) 
{
    locale = l;
}

Sets the locale used by JExcelApi to generate the spreadsheet. Setting this value has no effect on the language or region of the generated excel file

 public  void setMergedCellChecking(boolean b) 
{
    mergedCellCheckingDisabled = !b;
}

Accessor to set the merged cell checking

 public  void setNamesDisabled(boolean b) 
{
    namesDisabled = b;
}

Disables the handling of names

 public  void setPropertySets(boolean r) 
{
    propertySetsDisabled = !r;
}

Sets whether or not to enable any property sets (such as macros) to be copied along with the workbook Leaving this feature enabled will result in the JXL process using more memory

 public  void setRationalization(boolean r) 
{
    rationalizationDisabled = !r;
}

Sets whether or not to rationalize the cell formats before writing out the sheet. The default value is true

 public  void setRefreshAll(boolean refreshAll) 
{
    this.refreshAll = refreshAll;
}

When true then Refresh All should be done on all external data ranges and PivotTables when loading the workbook (the default is =0)

 public  void setSuppressWarnings(boolean w) 
{
    logger.setSuppressWarnings(w);
}

Accessor to set the suppress warnings flag. Due to the change in logging in version 2.4, this will now set the warning behaviour across the JVM (depending on the type of logger used)

 public  void setTemplate(boolean template) 
{
    this.template = template;
}

Workbook Is a Template

 public  void setTemporaryFileDuringWriteDirectory(File dir) 
{
    temporaryFileDuringWriteDirectory = dir;
}

Used in conjunction with the UseTemporaryFileDuringWrite setting to set the target directory for the temporary files. If this is not set, the system default temporary directory is used. This has no effect unless the useTemporaryFileDuringWrite setting is TRUE

 public  void setUseTemporaryFileDuringWrite(boolean temp) 
{
    useTemporaryFileDuringWrite = temp;
}

Sets whether a temporary file is used during the generation of the workbook. If not set, the workbook will take place entirely in memory. Setting this flag involves an assessment of the trade-offs between memory usage and performance

 public  void setWindowProtected(boolean windowprotected) 
{
    this.windowProtected = windowProtected;
}

 public  void setWriteAccess(String writeAccess) 
{
    this.writeAccess = writeAccess;
}