Skip to content
Cellatrix

Changelog

  • Load Excel files straight into a model, with no separate conversion step
    • Model.fromXLSX() and Model.fromXLSXFile() create a model from XLSX data or a file path
    • Model.addWorkbookFromXLSX() and Model.addWorkbookFromXLSXFile() add a workbook to an existing model
  • Model.addWorkbook() now returns the added Workbook
  • Defined names in external workbooks that have no value now read as #NAME?, as in Apiary
  • Bump dependencies
  • Breaking change: WorkSheet.getCellByCoords() is now internal; use the new WorkSheet.getCellByRange() instead
  • Breaking change: Table.jsf is now internal; the new Table.style field exposes the table’s visual style
  • Breaking change: tables, comments and notes are now accessed through workbook managers
    • Workbook.getTable() and getTables() are replaced by Workbook.tables, a TableManager whose get() returns Table instances (matched case-insensitively) instead of raw JSF tables
    • WorkSheet.getComments() and getNotes() are replaced by the Workbook.comments and Workbook.notes managers
    • WorkSheet.comments and WorkSheet.notes are now always arrays
  • Bump dependencies
  • Breaking change: update to JSF v2
    • Colours are now typed objects rather than #-prefixed strings
    • showGridLines has moved from WorkSheet to the workbook views
    • StyleManager updated to handle new colour format; style value strings are now matched case-insensitively
    • Add ThemeManager to expose theme data from the workbook
    • Rows and columns are now GridSize definitions and no longer guaranteed to include a size
    • Add upgradeExternal helper to handle the distinction between Workbook and External
  • Fix WorkSheet.getComments() to exclude replies to resolved parent comments when excludeResolved is true
  • Bump dependencies
  • Add API for cell comments and notes
  • Bump dependencies
  • Support exporting workbooks to JSF format
  • Include only required files in distributed package
  • Type Model._writes as Map<string, CellValue>
  • JSF internals
  • Cell.id should not be optional
  • Formula evaluation
  • Depend on @jsfkit/types and remove @borgar/xslx-convert
  • Bump dependencies
  • Fix 1904 epoch bug when converting JSF to CSF
  • Adding Apiary’s row/col interface emulation
  • Enable TypeScript strict mode
  • Check cell value is not null rather than truthy
  • Handle tables like Apiary does
  • Don’t automatically change cells to errors
  • Initial release.