CSV files with line breaks in the header - behaviour inconsistent with other CSV readers about gdal HOT 3 CLOSED

For me a multiline header line feels very odd. Excel really seems to rely on making difference between LF and CRLF.

I would accept that GDAL does not parse such header lines.

I tried to read a test CSV back to Excel with poor success. I trust you that it is possible somehow but I did not manage to guess how. I could not read it with QGIS either. Maybe it is because of my locale (Finnish).
This is how Excel wants to open the CSV file that it created by itself:

from gdal.

Excel really seems to rely on making difference between LF and CRLF.

But see my note:

(Note, when you use Excel to create a file with line breaks in cells, those line breaks are saved as LF only, even though the line breaks between records are CRLF. However, no CSV reader I tested behaved differently when I interchanged LF and CRLF in various permutations.)

It is true that Excel saves the file like that, but it does not rely on that pattern of line endings when opening a file.

from gdal.

I am sceptical but I may be wrong. How could it make a difference between the LF that is separating the lines in the header and after the header? But anyway, user can simply avoid multiline headers or edit the CSV file before reading it with GDAL.

from gdal.