PHPOffice / PhpSpreadsheet

    /**

     * Read DEFAULTROWHEIGHT record

     */

    private function readDefaultRowHeight()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        // offset: 0; size: 2; option flags

        // offset: 2; size: 2; default height for unused rows, (twips 1/20 point)

        $height = self::getInt2d($recordData, 2);

        $this->phpSheet->getDefaultRowDimension()->setRowHeight($height / 20);

    }

    /**

     * Read SHEETPR record

    /**

     * Read HCENTER record

     */

    private function readHcenter()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        if (!$this->readDataOnly) {

            // offset: 0; size: 2; 0 = print sheet left aligned, 1 = print sheet centered horizontally

            $isHorizontalCentered = (bool) self::getInt2d($recordData, 0);

            $this->phpSheet->getPageSetup()->setHorizontalCentered($isHorizontalCentered);

        }

    }

    /**

     * Read VCENTER record

    /**

     * Read VCENTER record

     */

    private function readVcenter()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        if (!$this->readDataOnly) {

            // offset: 0; size: 2; 0 = print sheet aligned at top page border, 1 = print sheet vertically centered

            $isVerticalCentered = (bool) self::getInt2d($recordData, 0);

            $this->phpSheet->getPageSetup()->setVerticalCentered($isVerticalCentered);

        }

    }

    /**

     * Read LEFTMARGIN record

     * PROTECT - Sheet protection (BIFF2 through BIFF8)

     *   if this record is omitted, then it also means no sheet protection

     */

    private function readProtect()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        if ($this->readDataOnly) {

            return;

        }

        // offset: 0; size: 2;

        // bit 0, mask 0x01; 1 = sheet is protected

        $bool = (0x01 & self::getInt2d($recordData, 0)) >> 0;

        $this->phpSheet->getProtection()->setSheet((bool) $bool);

    }

    /**

     * SCENPROTECT

    /**

     * SCENPROTECT

     */

    private function readScenProtect()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        if ($this->readDataOnly) {

            return;

        }

        // offset: 0; size: 2;

        // bit: 0, mask 0x01; 1 = scenarios are protected

        $bool = (0x01 & self::getInt2d($recordData, 0)) >> 0;

        $this->phpSheet->getProtection()->setScenarios((bool) $bool);

    }

    /**

     * OBJECTPROTECT

    /**

     * OBJECTPROTECT

     */

    private function readObjectProtect()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        if ($this->readDataOnly) {

            return;

        }

        // offset: 0; size: 2;

        // bit: 0, mask 0x01; 1 = objects are protected

        $bool = (0x01 & self::getInt2d($recordData, 0)) >> 0;

        $this->phpSheet->getProtection()->setObjects((bool) $bool);

    }

    /**

     * PASSWORD - Sheet protection (hashed) password (BIFF2 through BIFF8)

    /**

     * Read DEFCOLWIDTH record

     */

    private function readDefColWidth()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        // offset: 0; size: 2; default column width

        $width = self::getInt2d($recordData, 0);

        if ($width != 8) {

            $this->phpSheet->getDefaultColumnDimension()->setWidth($width);

        }

    }

    /**

     * Read COLINFO record

     * --    "OpenOffice.org's Documentation of the Microsoft

     *         Excel File Format"

     */

    private function readCodepage()

    {

        $length = self::getInt2d($this->data, $this->pos + 2);

        $recordData = $this->readRecordData($this->data, $this->pos + 4, $length);

        // move stream pointer to next record

        $this->pos += 4 + $length;

        // offset: 0; size: 2; code page identifier

        $codepage = self::getInt2d($recordData, 0);

        $this->codepage = \PhpOffice\PhpSpreadsheet\Shared\CodePage::numberToName($codepage);

    }

    /**

     * DATEMODE