Releases: cfsimplicity/spreadsheet-cfml
Releases · cfsimplicity/spreadsheet-cfml
v3.2.0
- Security update to log4j
- Allow row/column ranges specified for
read()
,deleteColumns()
,delete/Rows()
,formatColumns()
andformatRows()
to be open-ended - Fix
read()
not importing trailing empty columns
v3.1.0
- Upgrade to POI 5.1.0 and Commons CSV 1.9.0
- Various minor fixes
v3.0.0
- Rename project "spreadsheet-cfml"
- Add support for chainable syntax
- Reduce the size of
Spreadsheet.cfc
by refactoring private methods into separate helper modules - New function
getLastRowNumber()
v2.21.0
- Add
makeColumnNamesSafe
option toread()
andcsvToQuery()
- Allow
writeToCsv()
to exclude the workbook's header row
v2.20.0
- Add autoSizeColumns option to ``workbookFromQuery()`
- Fix multi-cell formatting methods throwing invalid arguments exception if overwriteCurrentStyle is set to false
v2.19.0
- Add
setActiveCell()
- Add
setRecalculateFormulasOnNextOpen()
- Minor fixes.
v2.18.2
v2.18.0
- Add
setHeaderImage()
andsetFooterImage()
- Add
setCellHyperLink()
andgetCellHyperLink()
- Fix issue with formatting functions when using
overwriteCurrentStyle=false
v2.17.0
- Allow
read()
andcsvToQuery()
to accept a defaultqueryColumnType
- Allow
read()
to acceptcolumnNames
as an array as well as a list - Allow column names to be specified when using
csvToQuery()
- Allow query column types to be specified or auto-detected when using
csvToQuery()