What's New in IronCalc v0.6

A fresh release packed with arrays, implicit intersection, DATETIME support, UI upgrades, and behind-the-scenes fixes.

Highlights

  • Support for ARRAYS and the Implicit Intersection operator (bringing more modern formula semantics)
  • Introduction of core DATETIME functions (TIME, HOUR, MINUTE, etc.)
  • New Sidebar / Left Drawer for enhanced workbook navigation
  • Docker images and improved build / release pipeline
  • Many stability, import/export, UI, and documentation fixes and polish

Engine / Core

  • Added ARRAYS support (in formulas) #330
  • Introduced IMPLICIT INTERSECTION operator semantics #264
  • Added full DATETIME function suite #425:
    • NETWORKDAYS, NETWORKDAYS.INTL
    • TIME, TIMEVALUE, HOUR, MINUTE, SECOND
    • DATEDIF, DATEVALUE
    • DAYS, DAYS360, WEEKDAY, WEEKNUM, WORKDAY, WORKDAY.INTL, YEARFRAC, ISOWEEKNUM
  • FIX: Evaluate after deleting content in the user API #455
  • FIX: DAYS and ISOWEEKNUM not being recognized (“XLFN”) #460

App / UI / UX

  • Added a left sidebar for better workbook management/navigation #453
  • Added a Templates dialog with workbook examples [#445](https:// GitHub.com/ironcalc/IronCalc/pull/445)
  • Prompt a welcome dialog on first app use #447
  • In toolbar, allow scroll with arrow buttons in narrow screens #448
  • New Color Picker and theming tweaks + cleanup #329, #407
  • Replace many custom icons with Lucide icons & remove old references #413
  • Better import / export behaviors: handle Unicode in downloads, fix PNG off-by-one, freezing rows/cols export #396, #361, #412
  • Feature: support insert / delete rows/columns with automatic cell displacement #408
  • Feature: move column / move row with cell displacement #414
  • FIX: Rename sheet updates formulas in defined names #338
  • FIX: Stop propagation on copy / cut / double click in editor #404, #411
  • FIX: sync changes of left drawer from localStorage, remove drawer-close glitch #458, #459

Documentation & Developer Tools

  • Documentation pages added / improved for ASIN, ACOS, ATAN #435
  • Documentation pages added for SINH, COSH, TANH #438
  • Documentation pages for ATAN2, ASINH, ACOSH, ATANH #443
  • Documentation for COLUMN function #440
  • Docs: complete keyboard shortcuts page #416
  • Docs: update “Managing Workbooks” to mention sidebar #457
  • Add model.evaluate() call in Node.js README #432
  • Docker support: first Docker images, README updated with Dockerfile info #451, #452

Miscellaneous

  • Many dependencies / build cleanup, removal of unused modules
  • Grammar / typo / UI polish fixes

New Contributors