Saving XLSX unhides every row

[wyattGTL]

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);

header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment;filename=$fileName");
header("Cache-Control: max-age=0");
$writer->save('php://output');

All of the rows get un-hidden when exporting like that. I've verified that the rows are in fact hidden in the original file.
How can I fix this?

[wyattGTL]

I am using version 1.14

[wyattGTL]

Just realized it only happens with some files. Here is a file that is happens with.
libre.xlsx

[wyattGTL]

Rows 2 and 5 will not be hidden after exporting the file with the above code.

[wyattGTL]

Before saving the file, I get the row dimensions and verify that the rows are in fact hidden. Something is going wrong in the saving with this specific file. I would appreciate any help, I'm in a bit of a time crunch unfortunately.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[oleibman]

The worksheet includes autofilters, and Excel autofilters will find and display previously hidden rows if they satisfy the filter. PhpSpreadsheet evaluates autofilters when writing, which is leading to your problem. I'm not sure that it's practical to change this behavior - it would represent a breaking change for many programs which currently execute as expected.