/** * Generate the WSBOOL biff record * @param Worksheet $sheet * * @return string */ public function getData(Worksheet $sheet) { $grbit = 0x0; // Set the option flags $grbit |= 0x1; // Auto page breaks visible if ($sheet->getOutlineStyle()) { $grbit |= 0x20; // Auto outline styles } if ($sheet->getOutlineBelow()) { $grbit |= 0x40; // Outline summary below } if ($sheet->getOutlineRight()) { $grbit |= 0x80; // Outline summary right } if ($sheet->getPrintSetup()->isFitPage()) { $grbit |= 0x100; // Page setup fit to page } if ($sheet->isOutlineOn()) { $grbit |= 0x400; // Outline symbols displayed } $data = pack("v", $grbit); return $this->getFullRecord($data); }
/** * @param Worksheet $worksheet * * @return int */ protected function calcGrbit(Worksheet $worksheet) { $fDspFmla = 0; // 0 - bit $fDspGrid = intval($worksheet->areGridLinesVisible()); // 1 $fDspRwCol = 1; // 2 $fFrozen = intval($worksheet->isFrozen()); // 3 $fDspZeros = 1; // 4 $fDefaultHdr = 1; // 5 $fArabic = intval($worksheet->isRtl()); // 6 $fDspGuts = intval($worksheet->isOutlineOn()); // 7 $fFrozenNoSplit = 0; // 0 - bit $fSelected = intval($worksheet->isSelected()); // 1 $fPaged = 1; // 2 $grbit = $fDspFmla; $grbit |= $fDspGrid << 1; $grbit |= $fDspRwCol << 2; $grbit |= $fFrozen << 3; $grbit |= $fDspZeros << 4; $grbit |= $fDefaultHdr << 5; $grbit |= $fArabic << 6; $grbit |= $fDspGuts << 7; $grbit |= $fFrozenNoSplit << 8; $grbit |= $fSelected << 9; $grbit |= $fPaged << 10; return $grbit; }