search

cfsimplicity / spreadsheet-cfml

Standalone library for working with spreadsheets and CSV in CFML
MIT License
126 stars 35 forks source link

Add option to return visible values from read() and readLargeFile() #309

Closed cfsimplicity closed 1 year ago

cfsimplicity commented 1 year ago

Currently read() and readLargeFile() return the raw cell values when returning a query/csv/html, so make that the default for a new optional returnVisibleValues argument.

This mostly affects numeric/date values which are often formatted differently to their raw value.

See also https://github.com/cfsimplicity/spreadsheet-cfml/issues/308 and https://github.com/cfsimplicity/spreadsheet-cfml/issues/305