v0.9.0

What's Changed

• FIX: Include snippets/ in the published @ironcalc/wasm package by @nhatcher in #1317
• UPDATE: Bump wasm package to version v0.8.4 by @nhatcher in #1318
• update: dark mode support by @dg-ac in #1327
• update[docs]: refine wording in templates page by @dg-ac in #1329
• update[docs]: styling for dev landing page by @dg-ac in #1324
• Implements links by @nhatcher in #1328
• UPDATE: Control/Command+Click follows link by @nhatcher in #1334
• FIX: Smooth scrolling by @nhatcher in #1335
• update: improve testing for NETWORKDAYS, NETWORKDAYS.INTL by @elsaminsut in #1340
• update: improve testing for DAY, MONTH, YEAR by @elsaminsut in #1339
• update: improve testing for T.DIST functions by @elsaminsut in #1325
• update: extend testing for NOW, TODAY by @elsaminsut in #1355
• update: extend testing for WORKDAY, WORKDAY.INTL by @elsaminsut in #1354
• UPDATE: Adds typechecks and renames from_types => fromBytes in the js by @nhatcher in #1357
• UPDATE: Remove not needed deps in the xlsx package by @nhatcher in #1359
• update: links styling and pointer by @dg-ac in #1368
• feat: publish xlsx import export as a second wasm package by @BrianHung in #1363
• update: improve testing for DATE by @elsaminsut in #1375
• update: dark mode adjustments in frozen panes, borders and named styles by @dg-ac in #1336
• FIX: number format date/time tokens must be case-insensitive by @tommy230 in #1349
• update: improve testing for DATEVALUE by @elsaminsut in #1382
• FIX: UPDATE Rust version (automatic fixes) by @nhatcher in #1399
• update: improve testing for EDATE by @elsaminsut in #1401
• update: improve testing for TIMEVALUE by @elsaminsut in #1404
• FIX: Drop zip's time feature so xlsx export works on wasm32 by @jleclanche in #1406
• update: promote the toggle to a reusable Switch component by @dg-ac in #1405
• update: improve testing for DAYS, DAYS360 by @elsaminsut in #1332
• update: add a reusable Checkbox component by @dg-ac in #1407
• update: add a reusable component for Toggle Buttons by @dg-ac in #1408
• UPDATE: Merged cells by @nhatcher in #1377
• update: improve testing for EOMONTH by @elsaminsut in #1393
• fix: double-click autofill stops incorrectly when target range has values by @rezat-c in #1178
• update: improve testing in YEARFRAC, DATEDIF by @elsaminsut in #1410
• UPDATE: Add merge across, merge and center, merge down and unmerge by @nhatcher in #1412
• update: replace toggle buttons with reusable component by @dg-ac in #1411
• update[app]: add a mode switch to File Menu by @dg-ac in #1413
• UPDATE: Do not rebuilt everything if not needed by @nhatcher in #1415
• UPDATE: Autofill merged cells by @nhatcher in #1416
• Two implicit intersection fixes by @Bobstin in #1326
• UPDATE: Some Implicit Insersection issues by @nhatcher in #1418
• Add ENCODEURL function by @wms2537 in #1419
• FIX: Enforce Linux Like endings (CR) by @nhatcher in #1424
• feat(python): add get_cell_value to UserModel by @Yudhyy in #1421
• fix: quote sheet names containing any non-identifier character by @getdom in #1422
• feat(python): add cell readers to UserModel by @Yudhyy in #1427
• UPDATE: Fixes to the general evaluation algorithm by @nhatcher in #1420
• TYPE returns 64 for an array by @svettypoo in #1431
• UPDATE: Use IndexedDB instead of LocalStorage by @nhatcher in #1451
• Streaming parser by @nhatcher in #1453
• update: improve testing for all trigonometric functions by @elsaminsut in #1457
• MINUTE and SECOND round the time to the nearest millisecond by @svettypoo in #1432
• Fix BINOM.INV panic: search the CDF directly instead of statrs inverse_cdf by @su79eu7k in #1459
• update: improve testing for TIME, HOUR, MINUTE, SECOND by @elsaminsut in #1456
• Update/nicolas update packages and minor fixes by @nhatcher in #1462
• update: Storybook fixes and cleanup by @dg-ac in #1458
• TIMEVALUE: accept fractional seconds like Excel (#1403) by @Yi-111-a in #1463
• fix: INDIRECT reads R1C1 references by @svettypoo in #1444
• FIX: Fixes to INDIRECT function and tests by @nhatcher in #1467
• FIX: ROW and column can deal with ranges by @nhatcher in #1469
• Bugfix/nicolas power arrays and ii fix by @nhatcher in #1470
• FIX: some text functions support arrays now by @nhatcher in #1471
• FIX: Check a number is nt NaN or inf before acepting the parse by @nhatcher in #1472
• FIX: Several issues with --A1:B4 by @nhatcher in #1473
• FIX: Minor issues with MAX and MIN by @nhatcher in #1475
• FIX: Propgate arith errors properly (broadcast) by @nhatcher in #1476
• UPDATE: Only evaluate cells with formulas by @nhatcher in #1480
• UPDATE: Try to use less memory per cell by @nhatcher in #1481
• UPDATE: Memory improvements while loading workbooks by @nhatcher in #1482
• FIX: Rust compiler recognizes Eurler Gamma constant by @nhatcher in #1484
• update: use theme colors in scrollbars by @dg-ac in #1483
• DATEVALUE and TIMEVALUE: ignore spaces around separators like Excel (#1380, #1402) by @theluckystrike in #1485
• DATEVALUE: roll the date over when the time part reaches 24 hours like Excel (#1379) by @theluckystrike in #1486
• Escape quotes in conditional-format text rules for every operator by @philip-pentatonic in #1491
• Index shared strings while sheets load by @philip-pentatonic in #1496
• Round to 15 significant digits in ROUND/ROUNDUP/ROUNDDOWN/TRUNC, as Excel does by @su79eu7k in #1460
• UPDATE: Use a nicer shape for sheet data by @nhatcher in #1497
• feat: ECMA.CEILING as Excel CEILING by @svettypoo in #1447
• fix: keep named range scope when a sheet is renamed by @dg-ac in #1511
• update: improve testing for WEEKDAY, WEEKNUM, ISOWEEKNUM by @elsaminsut in #1520
• fix(xlsx): accept without a width attribute using sheet default by @Yi-111-a in #1521
• fix(ROWS,COLUMNS): count the rows and columns of an array argument by @Yi-111-a in #1515
• Write theme colour tints with full precision by @philip-pentatonic in #1507
• FIX: Use CSS to do the CF priority change animation by @nhatcher in #1522
• Write rows without cells that have a height or are hidden by @philip-pentatonic in #1506
• FIX: Use useLayoutEffect instead of useEffect by @nhatcher in #1523
• UPDATE: Ands system Appearance by @nhatcher in #1527
• fix(EOMONTH): return #NUM! on date overflow instead of panicking by @Yi-111-a in #1524
• FIX: Treat only wasm32-unknown-unknown as a browser target by @devonanderson in #1526
• FIX: Fill rect exactly so there is no a background leftover by @nhatcher in #1529
• update: adapt default text and border colors in dark mode by @dg-ac in #1464
• UPDATE: Update README to help Dani by @nhatcher in #1533
• fix(WEEKDAY): evaluate the date argument before return_type by @Yi-111-a in #1519
• FIX: Use "#2E414D" for the text color of the "Goldens" by @nhatcher in #1534
• update: keep cell styles content readable in dark mode by @dg-ac in #1468
• Let menus taller than the window scroll (#1176) by @MFornander in #1536
• fix[app]: dark mode inconsistencies in share dialog and base text color by @dg-ac in #1537
• update[storybook]: oppen Sb on the Workbook story by default by @dg-ac in #1538
• update[app]: refine copy to clarify that shared links can't be deleted by @dg-ac in #1539
• update[app]: adapt templates to v09 by @dg-ac in #1541
• update: increase contrast in input placeholder text by @dg-ac in #1544
• update[app]: multiple refinements on workbook sharing by @dg-ac in #1540
• UPDATE: Update python bindings by @nhatcher in #1545
• fix: clear shared workbook URL when switching to a local workbook by @dg-ac in #1546
• UPDATE: Prepare for version v0.9.0 by @nhatcher in #1548

New Contributors

• @tommy230 made their first contribution in #1349
• @jleclanche made their first contribution in #1406
• @Bobstin made their first contribution in #1326
• @wms2537 made their first contribution in #1419
• @Yudhyy made their first contribution in #1421
• @getdom made their first contribution in #1422
• @svettypoo made their first contribution in #1431
• @su79eu7k made their first contribution in #1459
• @Yi-111-a made their first contribution in #1463
• @theluckystrike made their first contribution in #1485
• @philip-pentatonic made their first contribution in #1491
• @devonanderson made their first contribution in #1526
• @MFornander made their first contribution in #1536

Full Changelog: v0.8.3...v0.9.0