ironcalc/IronCalc v0.9.0 on GitHub

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