PHPOffice / PhpSpreadsheet

    /**

     * Read HORIZONTALPAGEBREAKS record

     */

    private function readHorizontalPageBreaks()

    {

        $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->version == self::XLS_BIFF8 && !$this->readDataOnly) {

            // offset: 0; size: 2; number of the following row index structures

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

            // offset: 2; size: 6 * $nm; list of $nm row index structures

            for ($i = 0; $i < $nm; ++$i) {

                $r = self::getInt2d($recordData, 2 + 6 * $i);

                $cf = self::getInt2d($recordData, 2 + 6 * $i + 2);

                $cl = self::getInt2d($recordData, 2 + 6 * $i + 4);

                // not sure why two column indexes are necessary?

                $this->phpSheet->setBreakByColumnAndRow($cf, $r, \PhpOffice\PhpSpreadsheet\Worksheet::BREAK_ROW);

            }

        }

    }

    /**

     * Read VERTICALPAGEBREAKS record

    /**

     * Read VERTICALPAGEBREAKS record

     */

    private function readVerticalPageBreaks()

    {

        $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->version == self::XLS_BIFF8 && !$this->readDataOnly) {

            // offset: 0; size: 2; number of the following column index structures

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

            // offset: 2; size: 6 * $nm; list of $nm row index structures

            for ($i = 0; $i < $nm; ++$i) {

                $c = self::getInt2d($recordData, 2 + 6 * $i);

                $rf = self::getInt2d($recordData, 2 + 6 * $i + 2);

                $rl = self::getInt2d($recordData, 2 + 6 * $i + 4);

                // not sure why two row indexes are necessary?

                $this->phpSheet->setBreakByColumnAndRow($c, $rf, \PhpOffice\PhpSpreadsheet\Worksheet::BREAK_COLUMN);

            }

        }

    }

    /**

     * Read HEADER record