/**
* 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;
}
