PhenoApps/Field-Book

[BUG]: XLSX import skips empty cells, causing column shifts in imported data

bellerbrock opened this issue · 0 comments

Description

Some columns in import files may have blank cells or missing data (see attached example). CSV import handles that as expected, importing empty strings for empty cells. XLSX import skips the empty cells causing values from later columns to appear in earlier columns.
24Caswell_Seconds.csv

Expected behavior

XLSX import should handle empty cells the same as CSV import

Field Book version

5.6.22