AddRows() should not convert empty values to zeros when they are in a numeric typed query column

cfsimplicity / spreadsheet-cfml

Standalone library for working with spreadsheets and CSV in CFML

MIT License

126 stars 35 forks source link

AddRows() should not convert empty values to zeros when they are in a numeric typed query column #377

Closed cfsimplicity closed 3 weeks ago

cfsimplicity commented 3 weeks ago

When adding rows to a sheet from a query, empty values in numeric columns (e.g Integer) are converted to zeros. This is not consistent with other types which set the value as a "blank".