search

cfsimplicity / spreadsheet-cfml

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

setCellHyperlink() should re-use a single cell style over multiple calls by default #317

Closed cfsimplicity closed 1 year ago

cfsimplicity commented 1 year ago

Currently if you use setCellHyperLink() over multiple calls the default format will be applied on each call as a separate cellStyle object. This is not performant and can run into the workbook's cell style limit.

If no format is specified, then the default should be applied as a re-usable style to avoid this.