IronCalc v0.7 marks a major milestone for us, with full internationalization support! Beyond English, IronCalc now speaks Spanish, French, German, and Italian, with proper locale handling for dates, times, currencies, and formulas. Alongside this, we've added dozens of new spreadsheet functions and made significant improvements to correctness, testing, and the UI. We didn't stop there though! v0.7.1 quickly followed with autofill, additional polish and some critical fixes that make everything run even smoother.
The open source community continues to grow, and we're thrilled to welcome 7 new contributors who have made significant contributions across testing, documentation, build tooling, UI improvements, and core engine functionality. Thank you all for your help!
Highlights
- Localization & multi-language support (ES, FR, DE, IT)
- Massive expansion of mathematical, statistical, and database functions
- Improved autofill behavior
- Better date, time, timezone, and locale handling
- Hundreds of new unit, XLSX, and integration tests
- UI, mobile, and usability improvements
Localization & Internationalization
- Multi-language support added to the frontend
- Added Spanish, French, German, and Italian translations, both for UI and engine
- Fixed multiple localization-related issues
- Improved handling of locale + timezone changes
Engine & Formula Support
New Functions (v0.7.0)
- Added DEGREES and RADIANS
- Added GCD and LCM
- Added BASE and DECIMAL
- Added ARABIC and ROMAN
- Added COMBIN, COMBINA, and SUMSQ
- Added DATABASE functions (full set)
- Added SUMX2MY2, SUMX2PY2, and SUMXMY2
- Added advanced statistical functions including FTEST, CORREL, SLOPE, INTERCEPT, RSQ, STEYX
- Added 68+ statistical functions overall
Date, Time & Localization
- Added time formats and timezone support
- NOW and TODAY now respect the local language
- TIMEVALUE supports case-insensitive AM/PM (e.g.
4 pm) - Currency formatting now respects Locale
- Fixed multiple edge cases in YEARFRAC, SEC, WORKDAY.INTL, DATEVALUE, TIMEVALUE
- DATABASE functions now parse dates correctly
Fixes & Correctness
- Fixed operator precedence issues (e.g.
-(A1^1.22)vs(-A1)^1.22) - Sheet names are now properly quoted and can be renamed using different casing
- Fixed floating-point precision issues in FLOOR, CEILING, INT, SIGN, EXP
- Corrected argument handling in BETA.DIST, BETA.INV, QUOTIENT
- Improved currency token parsing
- Improved stringification and casting behavior
- Number formats updated to match ECMA-376
App & UX
Autofill & Interaction
UI Improvements
- Improved cell selection
- Added named ranges menu to the formula bar
- Added data storage warnings
- Improved mobile navigation and menus
- Added context menus for row and column headers
- Improved selected color indicators
- Fixed multiple mobile scrolling and interaction issues
Documentation
- Added documentation for many new functions
- by @elsaminsut and @blueboy93
- Added documentation for all new features
- Added a documentation guide for contributors
- Improved documentation consistency and status tracking
Testing & Quality
- Extensive new unit tests for:
- Date & Time functions
- Trigonometric and reciprocal functions
- Statistical functions
- DATABASE functions
- Localization edge cases
- by @elsaminsut
- Added XLSX compatibility tests
- Added lexer behavior tests
- Removed duplicate tests and improved overall coverage
Build, CI & Tooling
- Workbook builds now ship ES modules only (no bundled dependencies)
- Improved CI performance
- by @samshadwell in #652
- Fixed macOS builds
- by @samshadwell in #649
- Updated dependencies and release tooling
New Contributors (v0.7.x)
We're incredibly grateful to all the amazing contributors who joined us in v0.7.x! Your contributions have made this release possible.
For the full list of changes, see the v0.7.0 and v0.7.1 releases on GitHub.