search

dharple / organizer

A web application for keeping track of storage boxes
BSD 2-Clause "Simplified" License
0 stars 1 forks source link

CSV export issues after PhpSpreadsheet v2 upgrade #40

Open dharple opened 2 weeks ago

dharple commented 2 weeks ago

While testing the PhpSpreadsheet v2 upgrade, I noticed that the CSV export will now blank out the contents of a column if there are 3 consecutive spaces (0x20).

dharple commented 2 weeks ago

Actually, that's not accurate. There were 2 rows with 3 consecutive spaces in the description. One row exported correctly before and after the upgrade. One row did not. Removing one space from the 3 consecutive spaces fixed the description that did not export.

dharple commented 2 weeks ago

I can't reproduce this issue. I wrote a script to reproduce the data that went in to PhpSpreadsheet (CSVs are almost PHP arrays...). I am able to reproduce the spreadsheet exactly as it was before the cell was unexpectedly blanked out, but not the state it was after it was blanked out.

Closing.

dharple commented 2 weeks ago

This happened again, today.

I confirmed that the data didn't change in the database, and when I ran the export again, the data was present...