v0.7.1

What's Changed

• Feat: Enhance autofill functionality by @rezat-c in #666
• docs: update feature and webapp pages by @dg-ac in #706
• FIX: Dead link in docs by @nhatcher in #711
• FIX: Parses dates separated with dots properly by @nhatcher in #714
• FIX: We can now rename sheets into a different case by @nhatcher in #713
• FIX: Currency formatting changes currency depending on Locale by @nhatcher in #712
• Remove space from number formats to match ECMA-376 by @syabro in #710
• Workbook: don't bundle dependencies, only build ES module by @jvdp in #683
• FIX: Parses dates correctly for DATABASE functions by @nhatcher in #715
• UPDATE: Prepare for release v0.7.1 by @nhatcher in #716

New Contributors

• @syabro made their first contribution in #710
• @jvdp made their first contribution in #683

Full Changelog: v0.7.0...v0.7.1

v0.7.0

What's Changed

• FIX: Updates docs and minor fixes by @nhatcher in #474
• update: fixes to Date and Time main page by @elsaminsut in #477
• FIX: Add image info by @nhatcher in #479
• FIX: Uses a dump randomUUID in non secure environmentes by @nhatcher in #482
• FIX: Correct order when stringify -(A1^1.22) and (-A1)^1.22 by @nhatcher in #484
• FIX: Quote sheet names properly by @nhatcher in #486
• UPDATE: Add some missing trigonometric functions by @nhatcher in #487
• UPDATE: Adds simple functions by @nhatcher in #489
• Bugfix/nicolas bufixes by @nhatcher in #491
• UPDATE: Adds DEGREES and RADIANS by @nhatcher in #493
• UPDATE: Adds unit tests for DEGREES and RADIANS by @nhatcher in #495
• UPDATE: Adds a bunch of mathematical functions by @nhatcher in #496
• UPDATE: Adds time formats by @nhatcher in #501
• UPDATE: Adds GCD and LCM functions by @nhatcher in #502
• style: widget footer improvements by @dg-ac in #503
• UPDATE: Implements BASE and DECIMAL by @nhatcher in #504
• UPDATE: Adds ARABIC and ROMAN by @nhatcher in #509
• UPDATE: Adds COMBIN, COMBINA and SUMSQ by @nhatcher in #511
• update: in the app, add missing favicons and use dynamic title by @dg-ac in #508
• UPDATE: Adds missing information functions by @nhatcher in #514
• update: adds docs and xlsx tests for DEGREES and RADIANS functions by @elsaminsut in #507
• update: adds docs, unit tests and xlsx tests for DATEVALUE and TIMEVALUE functions by @elsaminsut in #506
• update: adds docs, unit tests and xlsx tests for EVEN and ODD functions by @elsaminsut in #517
• FIX: Make clippy happy by @nhatcher in #521
• update: fixes status for implemented functions by @elsaminsut in #520
• FIX: TRUE/FALSE for QUOTIENT by @nhatcher in #524
• update: adds docs, unit tests and xlsx tests for MOD and QUOTIENT functions by @elsaminsut in #516
• FIX: Two small fixes to YEARFRAC by @nhatcher in #525
• Timezones by @nhatcher in #529
• FIX: Value of SEC at 0 was incorrect by @nhatcher in #532
• update: adds tests for COMBIN and COMBINA functions by @elsaminsut in #534
• update: name manager v2 by @dg-ac in #526
• UPDATE: Add some DATABASE functions by @nhatcher in #537
• UPDATE: updates test for TIME, HOUR, MINUTE, SECOND by @elsaminsut in #461
• Upgrade deps by @nhatcher in #543
• update: adds testing for ARABIC, ROMAN by @elsaminsut in #545
• update: adds testing for MROUND, TRUNC, and INT by @elsaminsut in #542
• FIX: Fixes several issues with DATABASE functions by @nhatcher in #552
• FIX: Cast to string now checks for dates, currencies or percentages by @nhatcher in #554
• FIX: Issues with INT by @nhatcher in #555
• docs: add a guide for documenting functions by @dg-ac in #558
• FIX: Issues with SIGN and EXP by @nhatcher in #565
• FIX: Issues with trigonometric functions by @nhatcher in #567
• Name manager cleanup by @nhatcher in #544
• UPDATE: Uses statrs instead of our own erf by @nhatcher in #569
• docs: documentation style guide edits by @elsaminsut in #568
• update: adds testing for EXP and SIGN by @elsaminsut in #566
• update: adds testing for the reciprocal trigonometric functions by @elsaminsut in #562
• UPDATE: Adds the rest of the DATABASE functions by @nhatcher in #556
• update: upgrade sheet tabs interactions by @dg-ac in #564
• update: add data-storage warnings to the app by @dg-ac in #570
• FIX: Correct number of arguments for functions by @nhatcher in #575
• UPDATE: Adds 56 functions in the Statistical section by @nhatcher in #582
• UPDATE: Implement FTEST function by @nhatcher in #590
• fix: mobile issues in app by @dg-ac in #591
• UPDATE: Adds SUMX2MY2, SUMX2PY2 and SUMXMY2 mathematical functions by @nhatcher in #593
• UPDATE: Implements CORREL, SLOPE, INTERCEPT, RSQ and STEYX by @nhatcher in #595
• Edited Column Documentation by @blueboy93 in #581
• UPDATE: Adds 12 more statistical functions: by @nhatcher in #608
• FIX: Floating-point precision bug in FLOOR functions by @tolgakaan12 in #592
• update: use different header styling for full column or row selection by @dg-ac in #599
• update: adds testing for SUMSQ by @elsaminsut in #597
• update: adds testing for CELL, INFO, N, SHEET and SHEETS by @elsaminsut in #540
• UPDATE(easter egg): Add an argument for NOW by @nhatcher in #580
• update: add named ranges menu to formula bar by @dg-ac in #572
• fix: remove duplicate xlsx tests by @elsaminsut in #598
• fix: remove unintended vertical scroll in workbook by @dg-ac in #620
• fix: floating-point precision bug in CEILING functions by @elsaminsut in #636
• UPDATE: Updates bitcode version by @nhatcher in #641
• Fix: Prevent closing bracket being swallowed in consume condition by @rezat-c in #643
• Docs dates by @nhatcher in #622
• Fix macOS builds by @samshadwell in #649
• Speed up CI by @samshadwell in #652
• Fix: Add escape quote in consume string by @rezat-c in #645
• Improve currency token parsing and add tests by @rezat-c in #647
• Fix running python tests on macos by @samshadwell in #653
• feat: Add extensive tests for lexer behavior by @rezat-c in #651
• update: a bunch of refinements in cell selector by @dg-ac in #617
• fix: abort copy styles action when pressing esc by @dg-ac in #614
• update: adds testing for recent formatting updates by @elsaminsut in #656
• update: smooth selection of multiple rows and columns by @dg-ac in #609
• fix/inverted-range-evaluation by @iamanaws in #607
• Update GitHub Actions badge links in README by @nhatcher in #659
• FIX: TIMEVALUE now supports case-insensitive simple AM/PM (e.g. 4 pm) by @tolgakaan12 in #611
• FIX: Use false as cumulative when argument is missing by @nhatcher in #662
• FIX: p arguments in BETA.INV should be (0, 1) by @nhatcher in #663
• FIX: In BETA.DIST and empty cell is treated as FALSE by @nhatcher in #664
• Documentation for COLUMNS + consitency fixes for COLUMN by @blueboy93 in #632
• update: adds testing for BETA.DIST and BETA.INV by @elsaminsut in #665
• Feature/nicolas i18n and localization by @nhatcher in #616
• update: adds unit test for NETWORKDAYS, NETWORKDAYS.INTL by @elsaminsut in #631
• update: adds testing for AVEDEV by @elsaminsut in #639
• update: add specific context menus to co...

v0.6.0

What's Changed

• FIX: Fix CI script to deal with conflicting names by @nhatcher in #322
• FIX: We are back on tial and error, regrettably by @nhatcher in #323
• FIX: The glog was wrong :S by @nhatcher in #324
• FIX: Wrap text properly by @nhatcher in #325
• UPDATE: Adds implicit intersection operator! by @nhatcher in #264
• FIX: Update missing packages by @nhatcher in #326
• FIX[app.ironcalc.com]: Clean up code for the title by @nhatcher in #327
• UPDATE: Introducing Arrays by @nhatcher in #330
• UPDATE: New color picker by @dg-ac in #329
• FIX: Cleanup code on new color picker by @dg-ac in #333
• Bugfix/nicolas rust update by @nhatcher in #339
• FIX: Use local typescript instead of global by @nhatcher in #336
• FIX: thick line should be 3px in the picker by @nhatcher in #337
• FIX: Renaming a sheet updates formula in defined name by @nhatcher in #338
• FIX: Download all selected area by @nhatcher in #344
• FIX: control+shitf selects area by @nhatcher in #360
• FIX: Download to png off by one errors by @nhatcher in #361
• FIX: There are two fills in every new Excel model by @nhatcher in #363
• Feature/cell handle dblclick by @nhatcher in #366
• FIX: Remove some unused dependencies and updated dependencies by @nhatcher in #367
• fix grammar spelling by @BrianHung in #370
• feat: use wasm-bindgen unchecked_return_type by @BrianHung in #382
• FIX: Include "tests" is the set of phony files by @nhatcher in #385
• FIX[import xlsx]: Sets default text color to black by @nhatcher in #387
• FIX[import]: Set color black for text properly by @nhatcher in #388
• Update/nicolas rust version lints by @nhatcher in #389
• Bugfix/nicolas embedding by @nhatcher in #391
• FIX[webapp]: Allow downloading workbooks with unicode charaters by @nhatcher in #396
• UPDATE: Removes once_Cell dependency by @nhatcher in #397
• FIX[workbook]: Default fill should be None by @nhatcher in #401
• FIX: Removing styles of full columns or rows are a single diff list by @nhatcher in #402
• FIX: Quote sheet names properly by @nhatcher in #399
• FIX: Checks also that the sheet is the same by @nhatcher in #403
• FIX: stop propagation on copy in the editor by @nhatcher in #404
• Bugfix/nicolas copy paste issues by @nhatcher in #405
• FIX: Remove wrong content-type is sharing workbooks by @nhatcher in #406
• FIX: Use correct shades in theme palette by @dg-ac in #407
• UPDATE: Adds LOG10, LOG and LN by @nhatcher in #410
• FIX: Do not propagate on cut or double click in the editor by @nhatcher in #411
• FIX: Export fronzen rows/columns properly by @nhatcher in #412
• update: replace custom made icons with lucide's by @dg-ac in #413
• FIX: Removes old icon references by @nhatcher in #418
• docs: complete the Keyboard Shortcuts page by @dg-ac in #416
• fix: corners in Type and Cell background color buttons by @dg-ac in #417
• FIX: Adds sheet "block" navigation by @nhatcher in #419
• Bugfix/nicolas updates docs by @nhatcher in #420
• update: add a Help menu to App by @dg-ac in #409
• UPDATE: Text spills now to adjacent cells if needed by @nhatcher in #422
• feat: insert delete rows cols by @BrianHung in #408
• move column move row with cell displacement by @BrianHung in #414
• Feature/nicolas move insert keyboard by @nhatcher in #423
• FIX: Minimal support for inlineStr by @nhatcher in #429
• UPDATE: Python bindings for the user API by @nhatcher in #368
• Bugfix/nicolas round by @nhatcher in #430
• docs: fix typo in TAN function page by @elsaminsut in #434
• Updates/nicolas rust updates by @nhatcher in #439
• added dimensions to python by @dioptre in #437
• docs: adds ASIN, ACOS, ATAN documentation pages by @elsaminsut in #435
• docs: adds SINH, COSH, TANH documentation pages by @elsaminsut in #438
• FIX: Shift+Letter starts editing cell by @nhatcher in #441
• FIX: Update documentation of some documented functions by @nhatcher in #442
• docs: adds ATAN2, ASINH, ACOSH, ATANH documentation pages by @elsaminsut in #443
• UPDATE: Added documentation for the Column Function by @blueboy93 in #440
• add model.evaluate() call in nodejs binding README by @mattlehrer in #432
• Add templates by @nhatcher in #445
• Small fixes by @nhatcher in #446
• update: multiple updates to the toolbar by @dg-ac in #448
• Fix example in README to reference Model correctly. by @dsagal in #449
• update: prompt a welcome dialog to the app on first use by @dg-ac in #447
• UPDATE: First Docker images! by @nhatcher in #451
• UPDATE: Add info in README about the Dockerfile by @nhatcher in #452
• date time functions by @BrianHung in #425
• update: Add a left drawer to improve workbook management by @dg-ac in #453
• update: show which format is active in FormatMenu by @dg-ac in #450
• FIX: Adds test for TIME/HOUR/MINUTE/SECOND by @nhatcher in #456
• docs: update the section 'managing workbooks' with new info about the left sidebar by @dg-ac in #457
• FIX: sync changes of the localstorage in the left drawer by @nhatcher in #458
• FIX: Remove transition so there is no close drawer glitch by @nhatcher in #459
• FIX: DAYS and ISOWEEKNUM are "XLFN" functions by @nhatcher in #460
• FIX: Evaluate after deleting content in the user API by @nhatcher in #455
• FIX: Cleanup CSS code by @nhatcher in #462
• UPDATE: Update release to 0.6.0 by @nhatcher in #463

New Contributors

• @BrianHung made their first contribution in #370
• @elsaminsut made their first contribution in #434
• @blueboy93 made their first contribution in #440
• @mattlehrer made their first contribution in #432
• @dsagal made their first contribution in #449

Full Changelog: v0.5.1...v0.6.0

v0.5.1

FIX: Fixes for the CI builds

MVP

What's Changed

• UPDATE: Add python workflow to publish on testpypi by @nhatcher in #260
• UPDATE: Name Manager page by @dg-ac in #256
• FIX: Wrong Discord invite link by @dg-ac in #257
• UPDATE: Adds fixes to python upload script by @nhatcher in #261
• UPDATE: Exposes the model in UserModel by @nhatcher in #263
• Update: Mobile improvements by @dg-ac in #255
• UPDATE: Add an empty state message to the Name Manager by @dg-ac in #253
• FIX: Use @ironcalc/workbook from file and bump dependencies by @nhatcher in #265
• UPDATE: Python docs by @nhatcher in #266
• UPDATE: Add clear formatting by @nhatcher in #268
• UPDATE: Update to React 19.0.0 by @nhatcher in #269
• FIX: Undo/redo delete/add page by @nhatcher in #270
• UPDATE: Update documentation by @nhatcher in #272
• UPDATE: Adds cell context menu by @nhatcher in #271
• UPDATE: Style changes in new contextual menus by @dg-ac in #275
• UPDATE: Add rows/column style APIs by @nhatcher in #276
• FIX: Forces calculation after insert/delete columns/rows by @nhatcher in #278
• FIX: Shows borders correctly in case of frozen rows. by @nhatcher in #279
• Bugfix/nicolas insert columns style by @nhatcher in #280
• FIX: It it possible to have DF scoped to the first sheet by @nhatcher in #282
• Feature/nicolas multiple rows columns by @nhatcher in #283
• FIX: Adds localhost in the development server Caddyfile by @nhatcher in #284
• FIX: Control+B,I,U work again by @nhatcher in #285
• FIX: Add "Apply" button to color picker by @nhatcher in #289
• Feature/nicolas webapp reorganizing by @nhatcher in #312
• UPDATE: We can now change the font size! by @nhatcher in #313
• UPDATE: Donload to PNG selected area by @nhatcher in #314
• FIX: Default size should be 13 pixels by @nhatcher in #315
• FIX: Correct height/width of cells with different font sizes by @nhatcher in #317
• UPDATE: Add a dialog when 'Share' buttons is clickled by @nhatcher in #318

Full Changelog: v0.3.1...v0.5.0

v0.3.1

UPDATE: Add raw API to nodejs bindings

v0.3.0

UPDATE: Add node bindings

v0.2.0

0.2.0 - 2024-11-06 (The HN release)

Added

• Rust crate ironcalc_base
• Rust crate ironcalc
• Minimal Python bindings (only Linux)
• JavaScript bindings
• React WebApp