FM / topics

/home/techb158/ileadtechnology.com/SSM/vendor/phpoffice/phpspreadsheet/docs/topics/

/home/techb158/ileadtechnology.com/SSM/vendor/phpoffice/phpspreadsheet/docs/topics

Name	Size	Mode	Actions
images/	-	0755	rm
accessing-cells.md	20662	0644	edit dl rm
architecture.md	3151	0644	edit dl rm
autofilters.md	18744	0644	edit dl rm
calculation-engine.md	62275	0644	edit dl rm
creating-spreadsheet.md	2067	0644	edit dl rm
file-formats.md	6023	0644	edit dl rm
memory_saving.md	3505	0644	edit dl rm
migration-from-PHPExcel.md	11686	0644	edit dl rm
reading-and-writing-to-file.md	27737	0644	edit dl rm
reading-files.md	27159	0644	edit dl rm
recipes.md	53864	0644	edit dl rm
settings.md	1597	0644	edit dl rm
worksheets.md	4711	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/SSM/vendor/phpoffice/phpspreadsheet/docs/topics/settings.md (1597B)

# Configuration Settings

Once you have included the PhpSpreadsheet files in your script, but
before instantiating a `Spreadsheet` object or loading a workbook file,
there are a number of configuration options that can be set which will
affect the subsequent behaviour of the script.

## Cell collection caching

By default, PhpSpreadsheet holds all cell objects in memory, but
you can specify alternatives to reduce memory consumption at the cost of speed.
Read more about [memory saving](./memory_saving.md).

To enable cell caching, you must provide your own implementation of cache like so:

``` php
$cache = new MyCustomPsr16Implementation();

\PhpOffice\PhpSpreadsheet\Settings::setCache($cache);
```

## Language/Locale

Some localisation elements have been included in PhpSpreadsheet. You can
set a locale by changing the settings. To set the locale to Brazilian
Portuguese you would use:

``` php
$locale = 'pt_br';
$validLocale = \PhpOffice\PhpSpreadsheet\Settings::setLocale($locale);
if (!$validLocale) {
    echo 'Unable to set locale to ' . $locale . " - reverting to en_us" . PHP_EOL;
}
```

- If Brazilian Portuguese language files aren't available, then Portuguese
will be enabled instead
- If Portuguese language files aren't available,
then the `setLocale()` method will return an error, and American English
(en\_us) settings will be used throughout.

More details of the features available once a locale has been set,
including a list of the languages and locales currently supported, can
be found in [Locale Settings for
Formulae](./recipes.md#locale-settings-for-formulae).

# Configuration Settings Once you have included the PhpSpreadsheet files in your script, but before instantiating a `Spreadsheet` object or loading a workbook file, there are a number of configuration options that can be set which will affect the subsequent behaviour of the script. ## Cell collection caching By default, PhpSpreadsheet holds all cell objects in memory, but you can specify alternatives to reduce memory consumption at the cost of speed. Read more about [memory saving](./memory_saving.md). To enable cell caching, you must provide your own implementation of cache like so: ``` php $cache = new MyCustomPsr16Implementation(); \PhpOffice\PhpSpreadsheet\Settings::setCache($cache); ``` ## Language/Locale Some localisation elements have been included in PhpSpreadsheet. You can set a locale by changing the settings. To set the locale to Brazilian Portuguese you would use: ``` php $locale = 'pt_br'; $validLocale = \PhpOffice\PhpSpreadsheet\Settings::setLocale($locale); if (!$validLocale) { echo 'Unable to set locale to ' . $locale . " - reverting to en_us" . PHP_EOL; } ``` - If Brazilian Portuguese language files aren't available, then Portuguese will be enabled instead - If Portuguese language files aren't available, then the `setLocale()` method will return an error, and American English (en\_us) settings will be used throughout. More details of the features available once a locale has been set, including a list of the languages and locales currently supported, can be found in [Locale Settings for Formulae](./recipes.md#locale-settings-for-formulae).