insertNewRowBefore increases file size

[kik-krsk]

This is:

- [x] a bug report
- [ ] a feature request
- [ x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

After using insertNewRowBefore, the number of rows becomes $sheet->getHighestRow() + $numberOfRow
After saving the file becomes ~350Kbytes. Template source file 15Kbytes

What is the current behavior?

i think the rows should be $sheet->getHighestDataRow() + $numberOfRow

What are the steps to reproduce?

<?php

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object
$spreadsheet = IOFactory::load(__DIR__ . '/template.xlsx');
$sheet = $spreadsheet->getSheet(0);
$currentRow = 24;
$before = $sheet->getHighestDataRow(); \\36
$sheet->insertNewRowBefore($currentRow, 10);
$after = $sheet->getHighestDataRow(); \\65542

What features do you think are causing the issue

• [ x] Reader
• Writer
• Styles
• Data Validations
• Formula Calculations
• Charts
• AutoFilter
• Form Elements

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

xlsx

Which versions of PhpSpreadsheet and PHP are affected?

1.29.0