cfsimplicity / spreadsheet-cfml

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

Allow control of whether to return cached or freshly calculated formula values #358

Closed cfsimplicity closed 7 months ago

cfsimplicity commented 7 months ago

By default, when reading formula cells, the formula will be evaluated to ensure you are getting an up-to-date result. But formula results are cached in the sheet and sometimes it may be useful/performant to skip recalculation and just grab the cached value.

Implement as a global library switch that can be turned on and off rather than yet another argument to the many methods that would need it.

cfsimplicity commented 7 months ago

Example usage:

data = spreadsheet
  .setReturnCachedFormulaValues( true )
  .read( src=path, format="query" );