@univerjs/engine-formula - npm Package Versions

0.4.0-alpha.1 (2024-10-12)

Bug Fixes

• docs: can not paste content when have both text range and rect range (#3720) (3cfcf7e)
• docs: insert image after table (#3719) (942dc4e)
• docs: selection offset is wrong when refresh (#3724) (0babbab)
• formula: fix some formula bugs (#3722) (559825a)
• sheets-ui: set focus editing mode when dbclick & error resize when change sub sheet (#3725) (84ac33f)

0.4.0-alpha.0 (2024-10-12)

Bug Fixes

• add remove sheet intercept (#3622) (1f7fedb)
• after modifying the value, the filter hidden state needs to be r… (#3601) (dc963b0)
• array formula border deps (#3654) (8d9b1aa)
• conditional-formatting: ranking error (#3589) (f0252ca)
• core: fix plugin holder of univer type not set (#3702) (851b1ce)
• dispose and createUnit cause viewport height collapse (#3598) (36b676f)
• docs: arrow in table when table across two pages (#3692) (9e98122)
• docs: copy table in univer (#3625) (8fb395f)
• docs: editing drawing is not working (#3718) (b253b32)
• docs: no need to add cursor when select multi text ranges (#3691) (f2aab59)
• docs: optimization of text selection (#3660) (a2f2215)
• docs: wrong header footer icon (#3689) (0cfeece)
• fix error display not shown (433da50)
• fix permission init should build cache (#3651) (6dac0d0)
• formula show editor selection when using filter (#3621) (1149cff)
• formula: add r_tree for dependency and fix bug (#3647) (f5140c0)
• formula: array formula spill error (#3673) (e8ffd23)
• merged cell bg not fully ender (#3671) (5bbbec3)
• sheets-hyper-link: hyper-link operator issues (#3628) (e27bf5e)
• sheets-ui: editor state not correctly reset when active (#3668) (16a08bf)
• sheets-ui: error quit edit when set-range-values was called (#3697) (0c29785)
• sheets-ui: remove useless mark dirty on data-validation & thread-comment (#3639) (6b48993)
• sheets: correct subUnitId usage in SetStyleCommand (#3586) (b03711d)
• ui: resolve issue preventing custom context menus from displaying (#3688) (b3a3cbc)
• underline was hidden by background in next line (#3638) (71229b3)
• zen: fix zen editor cannot be opened (#3699) (405a715)

Features

• add replay-only mode to actionRecordPlugin (#3695) (a3cb5c4)
• facade: add lifecycle and cellChange event api (#3626) (5fad25f)
• formula: regexextract/regexmatch/regexreplace (#3282) (7ce334f)
• sheets-ui: add formulaBar option (#3632) (d0a9f24)
• support for rtl and farsi i18n (#3558) (b13168d)

Performance Improvements

• permission: add row and column cache to optimize performance (#3634) (27eb2a3)
• render in viewrange not all model (#3637) (7b1462b)

0.3.0 (2024-09-29)

Features

• sheet: add flag to get better performance (#3631) (7f0d181)

0.3.0-alpha.1 (2024-09-29)

Bug Fixes

• bg border return before getCell (#3623) (2e7b201)
• data-validation: remove useless interceptor mutations (#3630) (fd48e15)

0.3.0-alpha.0 (2024-09-28)

Bug Fixes

• auto focus after select menu item (#3507) (a02e78b)
• auto-fill: merge-cell bugs in auto-fill (#3606) (bf21d58)
• border for merged cell (#3506) (1c4c237)
• cell margin bottom should over 1 (#3595) (65ee6b2)
• conditional-formatting: data bar render error (#3535) (f11c87f)
• copy sheet should copy filter (#3592) (e3620ce)
• design: improve empty options styling and messaging for Select (#3569) (3762706)
• docs-link-ui: link text error (#3620) (1e1522c)
• docs-ui: formula-editor can't scroll & edit link on cell editor (#3530) (6c4b96c)
• docs-ui: paste link on link (#3518) (9fcd45b)
• docs: doc selection refresh (#3585) (3687fff)
• docs: flickering issues when first visit into the page (#3578) (b0afd99)
• docs: support special emoticons (#3512) (61ee1cd)
• e2e scrolling & add missing interface for sheet skeleton (#3584) (25609a0)
• fix dv custom cell permission (#3559) (d1964fc)
• fix horizontal merge wrong value (#3545) (b1ea6c3)
• fix reduce function type error (#3563) (2506c3a)
• formula: fix bycol/byrow/map (#3568) (5473a11)
• mark selection should remove after some commands execute (#3467) (1e9cc47)
• perf improving in set style cache (#3471) (03acbbb)
• permission check use compose points (#3540) (7ef5059)
• protect: fix protect performance (#3520) (d8b9271)
• scrollbar offset when moving by mouse (#3556) (5ebbc02)
• sheet: fix span cache not right issue (#3541) (543ade1)
• sheet: fix summary performance (#3517) (0ab07d9)
• sheets-data-validation: data validation perf issue on getCell (#3619) (4f3cd5c)
• sheets-data-validation: ref-range (#3533) (f7f8269)
• sheets-drawing-ui: float-dom error on scale (#3612) (5621216)
• sheets-hyper-link-ui: link & doc markSelection error on merged cell (#3615) (21853cc)
• sheets-thread-comment: comment export (#3543) (33f4592)
• sheets-ui: fix issue causing a blank screen when clicking on the border panel (#3531) (99dd398)
• sheets-ui: formula across subsheet (#3583) (69d513e)
• sheets: disbale zoom ration on cell editing (#3596) (051094e)
• sheets: fix insert row col range type (#3602) (8262f7f)
• should scroll to changed position on set range values (bb4f035)
• ui: fix display values for certain menu items (#3522) (3035e39)
• ui: improve handling of CustomLabel default values (#3536) (fde58d7)
• ui: optimize Menu component rendering and filtering logic (#3552) (6338846)
• ui: revert column width input to initial value on menu close (#3562) (3cc2392)
• use tab to insert new row (#3524) (1c34bd0)

Features

• add before render hook (#3576) (e8f113e)
• add scrolling fps e2e test (#3532) (741665c)
• core: optimize split into grid function (#3565) (4e8d9a5)
• docs: add gray background color to docs (#3525) (edb3719)
• facade: add facade for freeze and getCellData (#3561) (983ad9f)
• formula: add some statistical formulas (#3463) (0a7658a)
• set document (#3521) (5489ce8)
• sheet: group sheet get cell intercptor to performance well (#3534) (ab97ea1)
• sheets-data-validation: support hide edit button on dropdown (#3574) (f2224c3)
• sheet: support fork file (#3549) (6a475a7)

Performance Improvements

• fix permission perf (#3618) (56f248c)

0.2.15 (2024-09-21)

Bug Fixes

• add filter with one cell should adjust expend range permission (#3469) (b4b0763)
• clipboard: fix paste col width (#3450) (2175c49)
• design: prevent suffix showing with allowClear is false (#3449) (32b2cac)
• docs-ui: doc list can't toggle (#3473) (3dc6d95)
• docs: scroll to selection (#3458) (3cf7b46)
• docs: wrong ime position after scroll (#3457) (6e6b0b2)
• fix edit cell with remove sheet (#3474) (38b03fb)
• fix pasting twice in formula editor (#3481) (13cf373)
• formula: binary search supports match type (#3402) (6db4cf8)
• formula: fix some bugs (#3470) (7c66482)
• hide sheet should operation right sheet (#3468) (a4bfe0d)
• menu: sort menu should be hide (#3505) (9530fe4)
• numfmt: do not block when syntax is not supported (#3491) (b8c9256)
• scroll cmd for pointer down at scrolltrack (#3429) (8e9f513)
• sheet: getDiscreteRanges filter empty cell (#3437) (92a063a)
• sheets-data-validation: data validation event trigger before data applied (#3498) (c4601a0)
• sheets-data-validation: data-validation oom on extreme-big-range (#3494) (86c2dd9)
• sheets-data-validation: large data validation oom (#3492) (42ce257)
• sheets-hyper-link-ui: input link error (#3513) (b4fcb4a)
• sheets-hyper-link-ui: link redo undo (#3465) (9ddcaf5)
• sheets-hyper-link: build url (#3503) (25b7b66)
• sheets-thread-comment-ui: delete comment error (#3476) (01a78da)
• sheets-thread-comment: comment ui issues (#3510) (05616d4)
• sheet: set selection should ensure the selection is not null (#3497) (7b89f27)
• span: fix editor position not right issue (#3443) (4b86a65)
• type errors (20d35a3)
• ui: hide column header arrow when contextMenu is false (#3444) (1355807)

Features

• core: unify the handler of get plain text from rich-text model (#3421) (e9395d2)
• demo: add support for dynamic imports (#3433) (33571b6)
• facade: add FWorksheet.getRange(a1Notation) (#3504) (a697a49)
• formula: add function leftb (#3418) (b66e8ce)
• formula: add function mid (#3417) (32fb95e)
• sheets-data-validation: data validation optimize (#3422) (93c3659)
• sheets-ui: undo set cols visible should scroll to cols (#3355) (ed6d783)

Performance Improvements

• refactor local file service (#3479) (23e47c2)
• sheet: add span model (#3403) (c357724)

0.2.14 (2024-09-13)

Bug Fixes

• sheet: custom will overwrite the original value (#3431) (e1042d4)
• sheets-ui: formula error when cross sub-sheet (#3436) (97ae314)

Features

• sheets-ui: optimize shortcut for comment & hyperlink editor (#3434) (9604020)

0.2.13 (2024-09-13)

Bug Fixes

• border auxiliary is unexpectedly cleared after the merge cell is hidden (#3358) (c11c324)
• cell margin top is not right (#3382) (8b4027e)
• cell value should adjust rich text & function (#3385) (ca628e1)
• docs-drawing: drawing resource (#3410) (4f2b148)
• docs-ui: editor focusing conflict when update content (#3423) (f2deabc)
• formular: fix sheet maximum (#3384) (41affb7)
• formula: update formula id (#3339) (1434966)
• incorrectly quit autofill mode (#3390) (f0fc942)
• render: fix the issue loop span many times (#3394) (f3d55f7)
• sheet getRowVisible lags after filter (#3396) (cb2cf7e)
• sheet: adjust move range old mutation not has fromRange property (#3361) (11748a5)
• sheet: fix type error (#3401) (7ce40a5)
• sheet: merge cell custom property (#3365) (880ef44)
• sheets-ui: recover float-dom delete menu & focusing when zen-editor mount (#3426) (2bf1177)
• sheet: the first style of span is not set is merge to true (#3398) (6def773)
• sort: i18n error in sheet sort (#3419) (771eeb6)
• the viewport size is too big after cancel filter rule, then viewport main is blank because graphic mem is full. (#3415) (f31cefd)
• ui: prevent dropdown usage when menu bar is disabled (#3400) (5f2e9fa)

Features

• action-recorder: add experimental action recorder plugin (#3386) (83238fa)
• conditional-formatting: support formatting painter (#3420) (2b121d7)
• doc-hyper-link: polyfill history data for doc hyper link (#3406) (5f2c2fe)
• formula: add some lookup formulas (#3352) (5ab9c7d)
• formula: add some math formulas (#3381) (e736b8a)
• formula: bycol/byrow/map/reduce/scan (#3320) (85b9d90)
• sheets-hyper-link-ui: sheet link support rich-text mode (#3322) (d19d224)