Skip to content

Releases: cfsimplicity/spreadsheet-cfml

v3.2.0

11 Dec 08:01
Compare
Choose a tag to compare
  • Security update to log4j
  • Allow row/column ranges specified for read(), deleteColumns(), delete/Rows(), formatColumns() and formatRows() to be open-ended
  • Fix read() not importing trailing empty columns

v3.1.0

02 Nov 11:00
Compare
Choose a tag to compare
  • Upgrade to POI 5.1.0 and Commons CSV 1.9.0
  • Various minor fixes

v3.0.0

17 Sep 14:20
Compare
Choose a tag to compare
  • 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

29 Jul 14:37
Compare
Choose a tag to compare
  • Add makeColumnNamesSafe option to read() and csvToQuery()
  • Allow writeToCsv() to exclude the workbook's header row

v2.20.0

18 Jun 15:40
Compare
Choose a tag to compare
  • Add autoSizeColumns option to ``workbookFromQuery()`
  • Fix multi-cell formatting methods throwing invalid arguments exception if overwriteCurrentStyle is set to false

v2.19.0

14 May 16:40
Compare
Choose a tag to compare
  • Add setActiveCell()
  • Add setRecalculateFormulasOnNextOpen()
  • Minor fixes.

v2.18.2

15 Apr 19:26
Compare
Choose a tag to compare

Bug fix #236

v2.18.0

15 Apr 14:14
Compare
Choose a tag to compare
  • Add setHeaderImage() and setFooterImage()
  • Add setCellHyperLink() and getCellHyperLink()
  • Fix issue with formatting functions when using overwriteCurrentStyle=false

v2.17.0

12 Mar 16:50
Compare
Choose a tag to compare
  • Allow read() and csvToQuery() to accept a default queryColumnType
  • Allow read() to accept columnNames 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()

v2.16.0

09 Mar 15:03
Compare
Choose a tag to compare

#225 Allow query column types to be specified or auto-detected when reading a spreadsheet into a query