search

cfsimplicity / spreadsheet-cfml

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

Add option to return visible or raw value from getCellValue() #308

Closed cfsimplicity closed 1 year ago

cfsimplicity commented 1 year ago

Currently getCellValue() returns the visible (aka formatted) value, so make that the default for a new returnVisibleValue 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/309 and https://github.com/cfsimplicity/spreadsheet-cfml/issues/305