Excel file corrupted after just opening and saving it

[B4rb4ross4]

I tried to open the following file and just save it without changes:
RE_Asset_Spreadsheet.xlsx

After tat the file is corrupted and cannot be opened with excel anymore. From what I can see, in theory I have seen no special stuff that i haven't used before when creating new files. Is there a way to find out what went wrong and how to fix it?

$reader = new XlsxReader();

$spreadsheet = $reader->load(__DIR__."/RE_Asset_Spreadsheet.xlsx");

$writer = new Xlsx($spreadsheet);
$writer->save(__DIR__."/RE_Asset_Spreadsheet_copy.xlsx");

[oleibman]

Thank you for supplying your file. It is very large, so the copy takes a while, but I have no problem with the output file. It opens okay, and appears to match the input file almost exactly. So, what release of PhpSpreadsheet and Php are you using? What operating system? Any other relevant details that you can think of?

I also used MS's "Spreadsheet Compare" tool to search for differences between the files. Aside from a human-imperceptible difference in the background color of some cells, the only difference seems to be in 6 defined names - Google_Sheet_Link_* which seem associated with Data Validation Lists (e.g. cells E8-E1007 on sheet "Asset Characteristics" seem to have a Data Validation List whose values are found in Lists!$A$3:$A$51). PhpSpreadsheet cannot resolve these correctly (external data is not well supported), although Excel apparently can. Presumably the data for these comes from a worksheet on Google Sheets (there is no sheet Lists in this workbook, but presumably there is such a sheet in Google Sheets). PhpSpreadsheet's inability to resolve these means that Data Validation is not used for the cells in question on the copy, but it does not result in corruption.

[B4rb4ross4]

There is a hidden Sheet called Lists in the file.

[oleibman]

Thank you for the explanation. I must be up too late investigating :-) Now that I look at the output spreadsheet again, the Data Validations are there after all (more sleepiness?). So the only differences between input and output are the imperceptible background color change, and the apparently unneeded Google_Sheet_Links. So, back to my questions - what is causing your output file to be corrupt when mine seems fine? PhpSpreadsheet version, Php version, operating system? For the record, I'm on PhpSpreadsheet master (4.2.0 plus recently merged changes), Php8.3, Win11, Excel 365.

[B4rb4ross4]

Ohh, I think I know the reason. I first had $reader->setReadDataOnly(true); set and removed that when creating the ticket while I was still testing it. Was a little fast there .... Was late for me aswell :)

[B4rb4ross4]

So we can close this if it is ok, that it crashes with the readonly flag activated.

[oleibman]

Please leave it open. I would like to investigate why it becomes corrupt with readonly.

[oleibman]

PhpSpreadsheet Reader is loading a printer settings file, which it should not do for dataOnly. Figuring this out was difficult; the solution is very easy. Expect to see it soon. I will be using your file in my unit test, but only one Worksheet (Disclaimer). This demonstrates the problem, and I think it does not reveal any confidential information. Let me know if you feel otherwise.

[B4rb4ross4]

Hey, sorry for the delay. The file is publically downloadable from the GRESB site so it should be fine to use it. I had to ask in my company beforehand if its ok to include the file here.