includeCharts; } /** * Set write charts in workbook * Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object. * Set to false (the default) to ignore charts. * * @param bool $pValue * * @return IWriter */ public function setIncludeCharts($pValue = false) { $this->includeCharts = (bool) $pValue; return $this; } /** * Get Pre-Calculate Formulas flag * If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, * so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet * viewer when opening the file * If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower * when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself. * * @return bool */ public function getPreCalculateFormulas() { return $this->preCalculateFormulas; } /** * Set Pre-Calculate Formulas * Set to true (the default) to advise the Writer to calculate all formulae on save * Set to false to prevent precalculation of formulae on save. * * @param bool $pValue Pre-Calculate Formulas? * * @return IWriter */ public function setPreCalculateFormulas($pValue = true) { $this->preCalculateFormulas = (bool) $pValue; return $this; } /** * Get use disk caching where possible? * * @return bool */ public function getUseDiskCaching() { return $this->_useDiskCaching; } /** * Set use disk caching where possible? * * @param bool $pValue * @param string $pDirectory Disk caching directory * * @throws Exception when directory does not exist * * @return IWriter */ public function setUseDiskCaching($pValue = false, $pDirectory = null) { $this->_useDiskCaching = $pValue; if ($pDirectory !== null) { if (is_dir($pDirectory)) { $this->_diskCachingDirectory = $pDirectory; } else { throw new Exception("Directory does not exist: $pDirectory"); } } return $this; } /** * Get disk caching directory. * * @return string */ public function getDiskCachingDirectory() { return $this->_diskCachingDirectory; } }