cfspreadsheet action="read" format="csv" ignores empty fields in xls/xlsx file

[xouqoa]

If you read an Excel file which has empty cells and use the CSV format, the output from the CSV function ignores any empty fields.

I believe the cause of this is in the parseRowData function in Spreadsheet.cfc, line #2869.

With the change below, it should pick up the empty ones. (Untested, not sure how to replace the file once the extension is installed, and stupid IIS won't let me upload the zip file locally on my machine.)

-- var elements = listToArray( arguments.line, arguments.delimiter );

++ var elements = listToArray( arguments.line, arguments.delimiter, true );