Skip to content

v0.8.0

Choose a tag to compare

@github-actions github-actions released this 29 Jul 14:33

What's Changed

  • FIX: Update docker tag by @nhatcher in #717
  • adding Documentation for CHOOSE function by @ff2400t in #723
  • FIX[Widget]: Uses useTranslation properly by @nhatcher in #729
  • update: add three additional border styles by @dg-ac in #722
  • fix: treat leading comma as text by @rezat-c in #739
  • fix: CHISQ functions now handle booleans and deg_freedom has an upper bound by @elsaminsut in #737
  • update: adds locale testing for DATABASE functions by @elsaminsut in #718
  • FIX: Cut and paste on partially selected range by @nhatcher in #745
  • FIX: Adds missing test by @nhatcher in #746
  • fix: currency tooltip in toolbar by @dg-ac in #755
  • FIX: User input dates and quote prefix by @nhatcher in #759
  • UPDATE: Adds hide/show row/column to the API by @nhatcher in #747
  • FIX: Always set "quote-prefix" style when an input starts with ' by @nhatcher in #760
  • Remove personal note from contributing guidelines by @nhatcher in #768
  • Accept + and - as formula prefixes by @rezat-c in #754
  • chore: move workbook stories to components/workbook by @dg-ac in #799
  • Update modules by @nhatcher in #802
  • Widget update: Updates dependencies and moves tests by @nhatcher in #803
  • update: add reusable Button component to Storybook by @dg-ac in #800
  • Update themes by @nhatcher in #805
  • FIX: Update Toolbar by @nhatcher in #806
  • Update theme styled by @nhatcher in #807
  • FIX: Remove unused code by @nhatcher in #808
  • Allow theme override by @jvdp in #804
  • UPDATE: Move some items to the theme, makes IronCalc themable by @nhatcher in #810
  • Dani toolbars by @nhatcher in #811
  • More cleanup by @nhatcher in #812
  • FIX: Include test that was previously ignored by @nhatcher in #815
  • Storybook fix by @nhatcher in #816
  • UPDATE: Use css variables as the single source of truth for themes by @nhatcher in #817
  • UPDATE: Simplify Button.tsx and IconButton.tsx to use css variables by @nhatcher in #818
  • FIX[Widget]: Uses CSS variables instead of Theme in worksheetCanvas by @nhatcher in #820
  • UPDATE[Widget]: Remove MUI from Worksheet.tsx by @nhatcher in #821
  • UPDATE[Widget]: Remove MUI from Workbook.tsx by @nhatcher in #822
  • UPDATE[Widget]: Removed styled from Toolbar and use plain css by @nhatcher in #823
  • Css variables right drawer by @nhatcher in #824
  • FIX: Fixes some a11y issues for the drawer separator by @nhatcher in #827
  • Tooltip by @nhatcher in #828
  • Css variables named ranges by @nhatcher in #829
  • Css variables form andtextfields by @nhatcher in #830
  • UPDATE: Add vscode files to .gitignore by @nhatcher in #833
  • update: add reusable Input component by @dg-ac in #832
  • UPDATE: Adds a minimal Select component by @nhatcher in #834
  • Css variabless formula bar by @nhatcher in #835
  • UPDATE: Remove MUI dependencies from SheetTabBar by @nhatcher in #836
  • FIX: Use a hand mane FromatMenu by @nhatcher in #837
  • UPDATE: Remove MUI from FormatPicker.tsx by @nhatcher in #838
  • FIX: Remove MUI from SheetDEleteDialog by @nhatcher in #839
  • FIX: Removes MUI from SheetTab.tsx by @nhatcher in #840
  • FIX: Remove MUI dependencies de SheetListMenu by @nhatcher in #841
  • Css variables context menu by @nhatcher in #842
  • UPDATE: Removes MUI from ColorPicker and AdvancedColorPicker. by @nhatcher in #843
  • UPDATE: Remove MUI from border picker by @nhatcher in #845
  • FIX: Remove MUI as a dependency in the Widget by @nhatcher in #846
  • UPDATE: Refactor color pickers to improve accessibility and focus handling by @nhatcher in #847
  • UPDATE[App]: Forcefully delete cache by @nhatcher in #848
  • UPDATE: Use build.rs to generate test files by @nhatcher in #862
  • FIX: Have a nicer output of Excel incompatibility errors by @nhatcher in #863
  • update: add reusable Select component by @dg-ac in #850
  • Improves testing for DATABASE functions by @elsaminsut in #776
  • update: add reusable Tooltip component by @dg-ac in #866
  • fix: stop event propagation at Input component level by @dg-ac in #867
  • FIX: editor font not themed by @jvdp in #873
  • FIX: Proper "selected area" navigation in browse mode by @nhatcher in #876
  • update: search, filter, and UX improvements in Named Ranges by @dg-ac in #868
  • update: add reusable Modal component by @dg-ac in #870
  • UPDATE: Array Formulas and Dynamic Arrays by @nhatcher in #877
  • FIX: Issues with Array formulas and undo/redo by @nhatcher in #878
  • UPDATE: Adds Spill Operator by @nhatcher in #879
  • UPDATE: Update nodejs packages by @nhatcher in #880
  • fix: import css from all 3 modal types by @dg-ac in #881
  • UPDATE: Adds SORT, SORTBY, FILTER and UNIQUE functions by @nhatcher in #882
  • Implement INFO function by @elsaminsut in #883
  • UPDATE: Adds RANDARRAY, TEXTSPLIT and SEQUENCE by @nhatcher in #884
  • Live annd LET live! by @nhatcher in #885
  • update: allow confirm via enter in Alert and Confirm modals by @dg-ac in #886
  • UPDATE: Add code deployed on https://embed.ironcalc.com by @nhatcher in #856
  • update: implements CELL("filename") by @elsaminsut in #890
  • Make SUM and PRODUCT functions more consistent with Excel by @elsaminsut in #892
  • update: adds unit testing for GCD, LCM by @elsaminsut in #891
  • xlsx import: tolerate whitespace text nodes in worksheet rels by @duane1024 in #888
  • UPDATE: Use embed instead of functions in app.ironcalc.com for docs by @nhatcher in #895
  • fix: improve keyboard navigation in Prompt by @dg-ac in #897
  • FIX: format files using biome by @phanirithvij in #898
  • FIX: recreate server cargo lock file by @phanirithvij in #899
  • FIX: few frontend ux and performance improvements by @phanirithvij in #896
  • Resolve theme colors against the workbook's theme file by @duane1024 in #893
  • app: add workbook search to left drawer by @dg-ac in #853
  • Improve autofill progression detection by @rezat-c in #742
  • Introducing the LAMBDA function by @nhatcher in #901
  • update: add testing for CHISQ functions by @elsaminsut in #767
  • update: adds testing for YEARFRAC and DATEDIF by @elsaminsut in #615
  • fix: BINOM functions bug fixes by @elsaminsut in #749
  • update: adds testing for WORKDAY, WORKDAY.INTL by @elsaminsut in #630
  • update: adds testing for WEEKDAY, WEEKNUM and ISOWEEKNUM by @elsaminsut in #619
  • FIX: Uses regex-lite in the wasm build by @nhatcher in #905
  • UPDATE: Use the browser's tz database in the wasm build by @nhatcher in #906
  • app: use css variables in Share button by @dg-ac in #907
  • update[app]: remove MUI from ShareWorkbookDialog by @dg-ac in #908
  • UPDATE: Correct Dynamic Arrays evaluation by @nhatcher in #909
  • UPDATE: Adds functions DROP, TAKE, TOROW, TOCOL and TRANSPOSE by @nhatcher in #912
  • update[app]: remove MUI from FileBar by @dg-ac in #910
  • update[app]: rename classes in ShareWorkbook by @dg-ac in #913
  • UPDATE: Adds BYCOL, BYROW, MAP and REDUCE by @nhatcher in #914
  • UPDATE: Implments SCAN function by @nhatcher in #915
  • fix: bug fixes in GCD and LCM by @elsaminsut in #757
  • update[app]: remove MUI from app menus by @dg-ac in #918
  • update: bump lucide to v1.14.0 by @dg-ac in #922
  • update: remove custom LineStyle icon and use Lucide's by @dg-ac in #923
  • update[app]: remove MUI from DeleteWorkbookDialog.tsx by @dg-ac in #924
  • update[app]: remove MUI from WelcomeDialog.tsx and TemplatesDialog.tsx by @dg-ac in #925
  • update[app]: remove MUI from UploadFileDialog.tsx by @dg-ac in #926
  • update[app]: remove MUI from LeftDrawer.tsx by @dg-ac in #927
  • update[app]: remove MUI from LocalStorageAlert.tsx by @dg-ac in #928
  • update: add unit testing for FACT, FACTDOUBLE and mark some functions as available in the docs by @elsaminsut in #920
  • docs: add INFO, CELL, NOW pages and mark some functions as implemented by @elsaminsut in #930
  • update[app]: remove styled from App.tsx by @dg-ac in #931
  • update[app]: remove MUI from DrawerContent.tsx by @dg-ac in #929
  • update[app]: remove dependencies by @dg-ac in #933
  • update[app]: fix styling for focus state in WelcomeDialog by @dg-ac in #936
  • fix: overlapping chevrons in toolbar by @dg-ac in #937
  • docs: fix some typos, styles and broken links by @elsaminsut in #938
  • update[app]: allow bulk deletion of workbooks by @dg-ac in #935
  • update: add reusable Menu component by @dg-ac in #887
  • Treat unset font color as None instead of black (import + engine default) by @duane1024 in #894
  • update[app]: use Menu component in remaining menus by @dg-ac in #942
  • update: use Menu component on Col/RowHeader contexts by @dg-ac in #944
  • Fix build_criteria for date comparisons in COUNTIF / SUMIF / AVERAGEIF functions by @duane1024 in #916
  • fix: scalar-context conversion for arrays in non-spilling positions by @wermelinger in #939
  • FIX: Adds regression test by @nhatcher in #945
  • fix: display autofill results immediately by @rezat-c in #948
  • UPDATE: Add list of locales in human readable form by @nhatcher in #946
  • chore: format locales json by @rezat-c in #949
  • UPDATE: Ladies and gentlemen: conditional formatting! by @nhatcher in #951
  • FIX[CF]: Have a solid background by default by @nhatcher in #954
  • FIX[CF]: Correct order of priority by @nhatcher in #957
  • UPDATE: Add Heart, ThumbsUp and ThumbsDown icons. Add an IconPicker by @nhatcher in #959
  • Feature/nicolas biome lints by @nhatcher in #960
  • UPDATE: Use stop if true by @nhatcher in #961
  • chore: exclude nodejs from coverage by @rezat-c in #963
  • update[docs]: fixes and additions to /features and /web-application by @dg-ac in #950
  • UPDATE: Add ACCRINTM function (accrued interest at maturity) by @albertodiazdurana in #865
  • UPDATE: Implemented basic TEXT functions (18) by @nhatcher in #968
  • update: multiple fixes and small refinements in CF by @dg-ac in #971
  • FIX: Fixes and tests for the CHAR function by @nhatcher in #969
  • UPDATE: Add REGEXEXTRACT, REGEXREPLACE and REGEXTEST functions by @nhatcher in #972
  • UPDATE: Adds most of remaining LOOKUP and REFERENCE functions by @nhatcher in #973
  • update: several refinements in CF/IconSets by @dg-ac in #974
  • UPDATE: Arrange Test files in folders by @nhatcher in #976
  • update[docs]: mark available functions as available by @dg-ac in #975
  • UPDATE: Adds a first implementation XMATCH and TRIMRANGE by @nhatcher in #981
  • FIX: Handle booleans in FISHER and FISHERINV by @nhatcher in #982
  • fix: typo in test folder by @elsaminsut in #980
  • FIX: Add missing types to wasm bindings by @nhatcher in #984
  • update: add argument test for FISHER, FISHERINV by @elsaminsut in #979
  • UPDATE: Adds ISOMITTED function by @nhatcher in #983
  • update: add testing for GAMMA functions by @elsaminsut in #985
  • FIX: Also fill dxf_id for formulas by @nhatcher in #990
  • fix: submenu behavior and menu anchor positioning by @dg-ac in #991
  • fix: styling and flickering in Name Manager input by @dg-ac in #992
  • FIX: Removes z-index from css-file by @nhatcher in #993
  • UPDATE: Adds PROPER test case by @nhatcher in #994
  • feat: implement MMULT (matrix multiplication) by @wermelinger in #940
  • update: add a cell context menu by @dg-ac in #964
  • feat: Add extensive tests for cell behavior and styles by @rezat-c in #640
  • UPDATE: Adds named cell styles by @nhatcher in #995
  • fix: MMULT edge cases (empty/boolean inputs, overflow, omitted args) by @wermelinger in #996
  • UPDATE: Adds MDETERM, MINVERSE, MUNIT, MULTINOMIAL, SERIESSUM, SUMPRODUCT by @nhatcher in #997
  • FIX: Show the Dynamic array outline as in the design by @nhatcher in #998
  • fix: element overlap in CF tabs by @dg-ac in #1000
  • update: cell styles drawer by @dg-ac in #1010
  • fix: hide tooltips on touchscreens by @dg-ac in #1013
  • fix: stick footer to bottom in CF drawer by @dg-ac in #1012
  • UPDATE: Glue create named styles by @nhatcher in #1014
  • Biome rule by @nhatcher in #1015
  • UPDATE: You can now edit and delete name styles by @nhatcher in #1016
  • FIX: When a dynamic formula goes beyond the boundary is a #SPILL error by @nhatcher in #1018
  • FIX: Dynamic array functions cal also SPILL out of boundaries by @nhatcher in #1019
  • FIX: Clear Dynamic Ranges on Undo by @nhatcher in #1020
  • FIX: Do not copy spill cells in undo/redo diffs by @nhatcher in #1021
  • FIX: Don't clear the full range on cut by @nhatcher in #1022
  • FIX: Undo'ing paste into soilled range clears properly by @nhatcher in #1023
  • FIX: Typing an empty string would delete the cell's content by @nhatcher in #1024
  • FIX: Remove spills during undo by @nhatcher in #1025
  • update: more refinements in Cell Styles drawer by @dg-ac in #1027
  • update: swap download and hide grid buttons in toolbar by @dg-ac in #1028
  • fix: autofill on double-click by @rezat-c in #962
  • FIX: Deal properly with case of empty arrays by @nhatcher in #1026
  • Feature/nicolas 19 statistical functions by @nhatcher in #1031
  • FIX: skip spilled values when copy/cut pasting from clipboard by @nhatcher in #1033
  • FIX: Delete original cell style on cut/paste by @nhatcher in #1034
  • Fix: Preserve original date case during autofill by @rezat-c in #947
  • FIX: Clear cell contents instead of all in undo by @nhatcher in #1041
  • Bugfix/nicolas anchor style by @nhatcher in #1043
  • FIX: Array formulas should also clean spill by @nhatcher in #1044
  • update[docs]: new feature pages by @dg-ac in #1045
  • FIX: Import styles in storybook properly by @nhatcher in #1051
  • fix[app]: consistent workbook selection after delete by @dg-ac in #1052
  • fix: in toolbar, make focus border visible for Format Menu by @dg-ac in #1054
  • update: in CF/Icon Sets, change default select to first item in the list by @dg-ac in #1053
  • FIX: Volatile Spill cells might contain by @nhatcher in #1055
  • FIX: Address copilot's review from last PR by @nhatcher in #1056
  • FIX: Autofill and array formulas by @nhatcher in #1057
  • UPDATE: IF array and date fucntions by @nhatcher in #1058
  • FIX: Do nothing if extendto fails in the frontend by @nhatcher in #1060
  • UPDATE: Adds STDEV alias by @nhatcher in #1061
  • FIX: Prevent LET and LAMBDA from ever getting automatic II by @nhatcher in #1059
  • UPDATE: Adds 8 Finantial functions by @nhatcher in #1062
  • UPDATE: Now we have Makerray :) by @nhatcher in #1064
  • FIX[parser]: Correct parenthesys in compare cases by @nhatcher in #1066
  • fix: modal dialogs rendered inside the worksheet now work correctly by @dg-ac in #1063
  • 1040 cut and paste fixed references should be maintained by @nhatcher in #1067
  • FIX: We can use r and c and variable names in LET/LAMBDA by @nhatcher in #1071
  • update: add a common modal component by @dg-ac in #1072
  • update: make font size toolbar control an editable input by @dg-ac in #1065
  • UPDATE: 37 compatibility functions added. by @nhatcher in #1074
  • update: place resizing handle on top of other drawer content by @dg-ac in #1075
  • UPDATE: Add ACCRINT function (accrued interest) by @albertodiazdurana in #1077
  • FIX: Import CF rules with a formula by @nhatcher in #1081
  • UPDATE: Now we export conditional formatting by @nhatcher in #1083
  • UPDATE: We now properly support themes by @nhatcher in #1085
  • UPDATE: Adds TIMEZONE and TIMEZONES to INFO function by @nhatcher in #1087
  • UPDATE: Update nodejs dependencies by @nhatcher in #1086
  • UPDATE: Values of default cell sizes closer to Excel and other engines by @nhatcher in #1089
  • update: add a themes drawer, add more themes by @dg-ac in #1088
  • FIX: fix tests from previous PR by @nhatcher in #1090
  • UPDATE: Full implementation of themes by @nhatcher in #1091
  • FIX: When importing Colors from Excel indexed 64 is transparent (= None) by @nhatcher in #1092
  • fix: use stand-alone date forms by @rezat-c in #1080
  • update: redesign Welcome and TemplatesDialog by @dg-ac in #1095
  • FIX: Fixes in array formulas by @nhatcher in #1094
  • UPDATE: Make clear the app is only a proof of concept by @nhatcher in #1099
  • UPDATE: Change the default width/height from cells by @nhatcher in #1098
  • fix: preview stacking, dark-background contrast, and imported themes in panel by @dg-ac in #1097
  • update: add hyperlink colors to EditTheme by @dg-ac in #1101
  • fix: accept booleans as arguments in EXPON.DIST by @elsaminsut in #1102
  • FIX: Draw the background border in spilled cells. by @nhatcher in #1106
  • UPDATE: Set column width or row height precisely via prompt by @nhatcher in #1107
  • fix: accept booleans as arguments in GAMMALN and GAMMALN.PRECISE by @elsaminsut in #1104
  • FIX: Fix welcome dialog in Mobile by @nhatcher in #1108
  • fix: accept booleans as arguments in GAUSS function by @elsaminsut in #1109
  • update: add xlsx test cases and extend unit tests for EXPON.DIST by @elsaminsut in #1103
  • update: Color picker cleanup and improvements by @dg-ac in #1100
  • FIX[xlsx]: Some engines omit the "r" in a xml row tag by @nhatcher in #1117
  • xlsx: make xfId optional in cellXfs by @sylvinus in #1114
  • UPDATE: Adds 15 more functions by @nhatcher in #1121
  • update: refine current themes and add new ones by @dg-ac in #1120
  • FIX: Remove unused lists in docs.ironcalc.com by @nhatcher in #1122
  • update: add NumberInput variant to Input, use it for column/row size dialogs by @dg-ac in #1119
  • update: add xlsx test cases and extend unit tests for GAUSS by @elsaminsut in #1110
  • update: add xlsx test cases and extend unit tests for GAMMALN functions by @elsaminsut in #1105
  • update: WelcomeDialog mobile improvements, CSS cleanup by @dg-ac in #1118
  • FIX: Small issue with LET LAMBDA :) by @nhatcher in #1132
  • fix: remove webkit by @dg-ac in #1136
  • FIX: Formulas en CF and Named ranges are kept in English by @nhatcher in #1135
  • fix: long formulas overflow in Named Ranges drawer and menu by @dg-ac in #1131
  • FIX[CF]: UI now supports multiple range in applyTo by @nhatcher in #1139
  • Header border by @nhatcher in #1141
  • update: add a textarea component to design system by @dg-ac in #1140
  • update: use textarea component in Named Ranges drawer by @dg-ac in #1143
  • fix: wrap text in CF rules reference by @dg-ac in #1144
  • FIX: Use (min column, min row) as anchor in multiple areas CF by @nhatcher in #1145
  • FIX: Row header separator is to thin in MacOS. by @nhatcher in #1147
  • FIX: ACCRINT defeated! by @nhatcher in #1148
  • UPDATE: Adds AMORDEGRC, AMORLINC and VDB financial functions by @nhatcher in #1149
  • UPDATE: Adds FUNDING.yml by @nhatcher in #1150
  • UPDATE: Massive ammount of fixes for financial functions. by @nhatcher in #1159
  • UPDATE: Proper priorities in CF by @nhatcher in #1162
  • UPDATE: We can now duplicate sheets :) by @nhatcher in #1163
  • fix: sticky search bar in right drawers by @dg-ac in #1161
  • update[docs]: document new templates by @dg-ac in #1164
  • FIX: Fixes for DAYS360 by @nhatcher in #1170
  • update: improve list reordering in Conditional Formatting by @dg-ac in #1169
  • update: add a 'duplicate rule' action to CF by @dg-ac in #1171
  • FIX: Fixes fro LCM and GCD (and many other vector functions) by @nhatcher in #1173
  • fix: styling in NM items by @dg-ac in #1175
  • UPDATE: SUMIF, IFERROR and IFNA are dynamic arrays ready by @nhatcher in #1182
  • UPDATE: MATCH supports now arrays by @nhatcher in #1184
  • FIX: Accept more general currency formats with locale specific content by @nhatcher in #1186
  • fix: missing checkmark on selected theme colors in ColorPicker by @dg-ac in #1188
  • FIX: Show spill ranges properly by @nhatcher in #1189
  • fix: a few mobile-specific styling issues by @dg-ac in #1192
  • FIX: Named Cell Styles could have undefined references by @nhatcher in #1193
  • UPDATE: Uses a real parser to see if we are in "reference mode" by @nhatcher in #1194
  • FIX: Addressed Copilot's comments. Tests added by @nhatcher in #1195
  • update[app]: use an unified warning message by @dg-ac in #1196
  • update[docs]: add documentation for the themes feature by @dg-ac in #1197
  • rootContainer prop by @jvdp in #1203
  • UPDATE: Adds a formula helper by @nhatcher in #1206
  • fix: reduce font size to 12px in worksheet, editor, and color picker by @dg-ac in #1205
  • fix[app]: pin/unpin/duplicate not refreshing the workbook list instantly by @dg-ac in #1204
  • update: multiple improvements in cell styles screens by @dg-ac in #1202
  • update: formula helper improvements by @dg-ac in #1208
  • update: theme colors by @dg-ac in #1211
  • UPDATE: F4 now cycles references by @nhatcher in #1212
  • fix: hitting tab saves cell value by @dg-ac in #1213
  • UPDATE: Adds templates and fixes by @nhatcher in #1214
  • FIX: Cursor hint was shown too often by @nhatcher in #1215
  • Correct the built-in numFmtId table (ECMA-376) by @scosman in #1223
  • FIX: Have a dedicated endpoint for create/update named cell styles by @nhatcher in #1225
  • update[functions]: add missing arguments for BINOM.DIST.RANGE and BINOM.INV by @dg-ac in #1227
  • fix: formula helper positioning by @dg-ac in #1220
  • update[functions]: add missing arguments for CHISQ functions by @dg-ac in #1228
  • update[functions]: add missing arguments for CONFIDENCE.NORM and CONFIDENCE.T by @dg-ac in #1229
  • UPDATE: Add apply* flags to the API for name styles by @nhatcher in #1230
  • FIX: Correct partial parse of LAMBDA and arguments by @nhatcher in #1233
  • FIX: Implement Date is/is not between in conditional formatting by @nhatcher in #1234
  • update[functions]: add missing arguments for ERF functions by @dg-ac in #1232
  • update: new layout for Cell Styles by @dg-ac in #1235
  • FIX: Deactivate formula helper by @nhatcher in #1238
  • FIX: Set ranges in CF in canonical form by @nhatcher in #1239
  • Bugfix/nicolas rezat c format locale separator by @nhatcher in #1240
  • fix(xlsx): preserve font on import by @scosman in #1236
  • FIX: Take applyBorder out of the React mount loop by @nhatcher in #1245
  • fix(xlsx): honour the workbook palette override by @scosman in #1224
  • update: add alignment and border properties to Cell Styles by @dg-ac in #1243
  • update: read-only mode via canEdit by @dg-ac in #1218
  • FIX: Fix border types by @nhatcher in #1246
  • fix: adapt some translations to sound more natural by @elsaminsut in #1249
  • fix: minor icon inconsistency by @elsaminsut in #1254
  • fix: context menu positioning after refresh by @dg-ac in #1256
  • fix: translate CF rule names by @dg-ac in #1253
  • fix(xlsx): accept ECMA-376 true/false forms for xsd:boolean attributes by @scosman in #1259
  • feat(base): add UserModel::set_worksheet_index to reorder worksheets by @scosman in #1257
  • UPDATE: Rust update by @nhatcher in #1268
  • Move sheet intregration by @nhatcher in #1261
  • update: add xlsx test cases and extend unit tests for COVARIANCE by @elsaminsut in #1267
  • FIX: If there are no selection set the selectection to A1 by @nhatcher in #1270
  • FIX: Formulas in defined names must be parsed and stringified to xlsx by @nhatcher in #1272
  • FIX: Parse shared formulas correctly. by @nhatcher in #1274
  • update[app]: replace templates by @dg-ac in #1275
  • fix[templates]: add metadata sheet by @dg-ac in #1279
  • FIX: Show cell handle even when selected cell is out of view by @nhatcher in #1278
  • FIX: Reparse functions correctly on insert/delete/move rows/columns by @nhatcher in #1280
  • FIX: Use canonical name ranges by @nhatcher in #1281
  • update[functions]: add missing arguments for F.DIST, F.INV, F.TEST functions by @dg-ac in #1282
  • update[functions]: add missing arguments for FISHER and FISHERINV by @dg-ac in #1283
  • update[functions]: add missing arguments for GAUSS, GESTEP, HYPGEOM.DIST, ISO.CEILING and KURT by @dg-ac in #1284
  • update[functions]: add missing arguments for LEFTB and LENB by @dg-ac in #1285
  • update[functions]: add missing arguments for LOGNORM.DIST and LOGNORM.INV by @dg-ac in #1286
  • update[functions]: add missing arguments for MIDB, NEGBINOM.DIST, NETWORKDAYS.INTL, POISSON.DIST by @dg-ac in #1287
  • update[functions]: add missing arguments for REPLACEB, RIGHTB, RSQ by @dg-ac in #1288
  • update[functions]: add missing arguments for SEARCHB, SERIESSUM, STEYX and T functions by @dg-ac in #1289
  • update[functions]: add missing arguments for WORKDAY.INTL and Z.TEST by @dg-ac in #1291
  • update[functions]: add a few missing functions to formula helper by @dg-ac in #1296
  • update[functions]: add last missing functions to formula helper by @dg-ac in #1297
  • Fix ADDRESS to prefix ! for an empty sheet_text argument by @scosman in #1294
  • FIX: Set name goes through history by @nhatcher in #1298
  • Fix TRIM to collapse internal runs of spaces (Excel-compatible) by @scosman in #1292
  • Add array-constant support to XMATCH lookup_array by @scosman in #1295
  • feat: add @ironcalc/wasm and @ironcalc/workbook to npm publish workflow by @iamanaws in #750
  • UPDATE: Prepare for release v0.8.* by @nhatcher in #1299

New Contributors

Full Changelog: v0.7.1...v0.8.0