/** * @param Range $range * * @return string */ public function getData(Range $range) { $data = pack("V", $this->getOptions()); $data .= pack("vC", strlen($this->titlePrompt), 0x0) . $this->titlePrompt; $data .= pack("vC", strlen($this->titleError), 0x0) . $this->titleError; $data .= pack("vC", strlen($this->descrPrompt), 0x0) . $this->descrPrompt; $data .= pack("vC", strlen($this->descrError), 0x0) . $this->descrError; $data .= $this->packFormula($this->formula1); $data .= $this->packFormula($this->formula2); $data .= \Xls\Subrecord\Range::getData(array($range)); return $data; }
/** * Create the print area NAME records */ protected function storePrintAreaNames() { foreach ($this->worksheets as $sheet) { $printSetup = $sheet->getPrintSetup(); if ($printSetup->isPrintAreaSet()) { $area = $printSetup->getPrintArea(); $data = $this->getRangeCommonHeader($sheet); $data .= \Xls\Subrecord\Range::getData(array($area), false); $this->appendRecord('DefinedName', array(Record\DefinedName::BUILTIN_PRINT_AREA, $sheet->getIndex() + 1, $data)); } } }