PHPOffice / PhpSpreadsheet

    /**

     * Write SCENPROTECT

     */

    private function writeScenProtect()

    {

        // Exit if sheet protection is not active

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

            return;

        }

        // Exit if scenarios are not protected

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

            return;

        }

        $record = 0x00DD; // Record identifier

        $length = 0x0002; // Bytes to follow

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

        $data = pack('v', 1);

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

    }

    /**

     * Write OBJECTPROTECT

    /**

     * Write OBJECTPROTECT

     */

    private function writeObjectProtect()

    {

        // Exit if sheet protection is not active

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

            return;

        }

        // Exit if objects are not protected

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

            return;

        }

        $record = 0x0063; // Record identifier

        $length = 0x0002; // Bytes to follow

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

        $data = pack('v', 1);

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

    }

    /**

     * Write the worksheet PASSWORD record.

     * Store the window zoom factor. This should be a reduced fraction but for

     * simplicity we will store all fractions with a numerator of 100.

     */

    private function writeZoom()

    {

        // If scale is 100 we don't need to write a record

        if ($this->phpSheet->getSheetView()->getZoomScale() == 100) {

            return;

        }

        $record = 0x00A0; // Record identifier

        $length = 0x0004; // Bytes to follow

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

        $data = pack('vv', $this->phpSheet->getSheetView()->getZoomScale(), 100);

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

    }

    /**

     * Get Escher object