PHPOffice / PhpSpreadsheet

     *

     * @access private

     */

    private function writeHcenter()

    {

        $record   = 0x0083;              // Record identifier

        $length   = 0x0002;              // Bytes to follow

        $fHCenter = $this->phpSheet->getPageSetup()->getHorizontalCentered() ? 1 : 0;     // Horizontal centering

        $header    = pack("vv", $record, $length);

        $data      = pack("v", $fHCenter);

        $this->append($header.$data);

    }

    /**

     * Store the vertical centering VCENTER BIFF record.

    /**

     * Store the vertical centering VCENTER BIFF record.

     */

    private function writeVcenter()

    {

        $record   = 0x0084;              // Record identifier

        $length   = 0x0002;              // Bytes to follow

        $fVCenter = $this->phpSheet->getPageSetup()->getVerticalCentered() ? 1 : 0;     // Horizontal centering

        $header    = pack("vv", $record, $length);

        $data      = pack("v", $fVCenter);

        $this->append($header . $data);

    }

    /**

     * Store the LEFTMARGIN BIFF record.

     * Write the PRINTGRIDLINES BIFF record. Must be used in conjunction with the

     * GRIDSET record.

     */

    private function writePrintGridlines()

    {

        $record      = 0x002b;                    // Record identifier

        $length      = 0x0002;                    // Bytes to follow

        $fPrintGrid  = $this->phpSheet->getPrintGridlines() ? 1 : 0;    // Boolean flag

        $header      = pack("vv", $record, $length);

        $data      = pack("v", $fPrintGrid);

        $this->append($header . $data);

    }

    /**

     * Write the GRIDSET BIFF record. Must be used in conjunction with the

    /**

     * Set the Biff PROTECT record to indicate that the worksheet is protected.

     */

    private function writeProtect()

    {

        // Exit unless sheet protection has been specified

        if (!$this->phpSheet->getProtection()->getSheet()) {

            return;

        }

        $record      = 0x0012;             // Record identifier

        $length      = 0x0002;             // Bytes to follow

        $fLock      = 1;    // Worksheet is protected

        $header      = pack("vv", $record, $length);

        $data      = pack("v", $fLock);

        $this->append($header.$data);

    }

    /**

     * Write SCENPROTECT