@univerjs/engine-numfmt - npm Package Versions

0.1.9 (2024-04-29)

Bug Fixes

• fix doc editor cannot focus (ab4fe64)
• global-zone componentKey initial value error (#2100) (2404690)
• sheet-formula: store themeColor to reuse (#2079) (6c2e1d3)
• sheet: set bottom by default for vertical align (#1929) (392f320)
• skeleton change will remove autofill popupmenu (#2092) (5b80ca7)
• ui: fix close ui plugin config and focus capturing (#2086) (4a360f7), closes #1914 #1967

Features

• facade: workbook and worksheet operation (#2076) (2daefd7)

0.1.8 (2024-04-26)

Bug Fixes

• columns is not render properly (#1952) (039e5e2)
• conditional-formatting: create cf rule error (#1969) (ee8f8de)
• conditional-formatting: disregarding computation beyond the tables region (#1891) (c14a3a8)
• conditional-formatting: gradient fills may conceal cell values (#1898) (70d3a7e)
• design: fix checkbox group not updating visually on click (#1989) (967eb39)
• dv: fix data validation plugin type to prevent loading error (#2084) (937fa13)
• editor: formula input esc invalid (#1902) (87f0994)
• facade: fix handling of empty selections in onSelectionChange method (#2066) (e440e04)
• fix API not exported (b4913f9)
• fix current render handling in desktop controller (#2067) (ddbeb02)
• fix lifecycle stages (37777f1)
• fix lint errors (4e970d4)
• fix memory leak on dispose sheet unit (#1900) (4a5eca1)
• fix memory leaking in active cell (761a372)
• fix non-sheet renderer should not be set container (#2044) (00b30e5)
• fix plugin not added to seen list (7591212)
• fix unit cannot be destroyed or recreate (#2081) (b67a9f8)
• fix univer plugin lifecycle not triggered (#2023) (827e5a3)
• fix univer plugin not started (5f5b0a7)
• getCurrent methods should possibly return null (#1892) (859d7fc)
• punctuation adjustment (#1867) (e921128)
• rect-popup event bind error (#1922) (ac17c69)
• refocus sheet cell when create new sheet (#1896) (db88447)
• render-engine: punctuation render error in sheet cell (#2034) (d7ddad1)
• replace whitespace characters in html str (#1904) (1ff1261)
• sheet-formula: fix error message on missing formula (#1885) (0ab866e)
• sheet: add cell custom field (#2021) (53b9041)
• sheet: cell custom supports updating from mutation (#2058) (bec1944)
• sheet: defined name move (#1888) (be2fec3)
• sheet: defined name update name (#1917) (5b6e223)
• sheet: editor set rich error (#1918) (d4f67f8)
• sheet: esc key for editor (#1928) (54487b8)
• sheet: fix some copy/paste bugs (#1754) (496dcb8)
• sheet: header hidden (#1954) (e3dc9ce)
• sheet: life cycle steady (#1927) (fbabfaa)
• sheet: move formula ref (#2078) (fa4ebea)
• sheet: range selector drag row (#1729) (530a852)
• sheet: range selector error (#1897) (a2c8cb6)
• sheets-data-validation: fix reject input incorrect (#2082) (6e03118)
• sheets-formula initialize time (#1910) (a461d16)
• sheets-ui: after unhiding row or col icon doesn't disappear (#2075) (f07c2d9)
• sheets: the text is aligned at editorial and non-editorial states (#1874) (c7e26a0)
• text is cropped when rendered in italic style with background (#1862) (80f43b8)
• the strickthough position is wrong when fontsize is different (#1919) (2564456)
• ui: stop onblur propagation at root to prevent external focusout conflicts (#1894) (04abb1b)
• univer plugin holder start immediately (8c3bb90)
• univer should auto start (af032c8)

Features

• core: refactoring resources load and snapshot (#1853) (8ae91b7)
• core: univer support override dependencies (#2050) (cfad0da)
• data-validation: transform support for data validation (#1915) (22ccbb1)
• doc: refactor of text shaping and support kerning (#1785) (e7f1036)
• engine-formula: add iseven isodd (#1873) (21d145c)
• engine-render: add render unit system (#2025) (a5243da)
• export identifiers from packages index.ts (#2049) (bced914)
• facade: f-worksheet add getName method (#2042) (10cc6e1)
• formula: formula calculation progress (#1985) (ad1d632)
• formula: implement formula lower (#1970) (db3fa45)
• image: add plugin (#1962) (9c494ae)
• numfmt: refactor the numfmt model (#1945) (1840166)
• sheet: force string adds popup (#1934) (add1214)
• sheet: indirect support defined name (#1899) (6c0833a)
• sheets-ui: optimize popup service (#1912) (a555160)
• sheets: filter (#1465) (1f03b7a)
• sheets: register other formula (#2045) (4a8ffd9)
• umd: create all-in-one UMD bundle (#2062) (e76fe4e)
• univer can take parent injector (f8ea16a)
• update codeowners (#2019) (5b0a103)

Performance Improvements

• formula: dependency maintain (#1638) (b745845)

0.1.7 (2024-04-12)

Bug Fixes

• auto height is not work when at default column width (#1840) (55e0869)
• condiational-formatting: rename SheetsConditionalFormattingUiPlugin (#1801) (9b14a5a)
• conditional-formatting: fix the logic for hidden$ in conditional formatting (#1813) (cd631af)
• design: ensure popup component is appended to root to prevent offset from stacking contexts (#1850) (1ad518a)
• design: fix slider to stop responding to mouse movement after release during zoom operations (#1834) (3d5a26e)
• design: fix tooltip behavior (#1845) (bd85759)
• design: set default language to zhCN (#1863) (08e8d58)
• display error in font family (#1700) (8c2282b)
• docs: list indent and hanging (#1675) (4020055)
• docs: strikethrough position is incorrect (#1836) (3f68158)
• engine-render: ignore media change on printing mode (#1808) (f5fc6be)
• formula: copy paste range with formulas (#1765) (58c7d3e)
• formula: null value return not zero (#1851) (87d8e20)
• formula: use ref range formula (#1694) (d8f1dc4)
• inline format error in cell (#1843) (2002fdf)
• rpc: skip missing mutations in remote replica (#1826) (1e10cbf)
• sheet-ui: make the default font family and font size correct (#1827) (ea18b99)
• sheet: defined name vertical (#1832) (edf86f4)
• sheet: editor and selection position (#1830) (e23992f)
• sheet: remove set current mutation (#1802) (79ce85d)
• sheets-ui: data-validation event bind timing (#1804) (d0cac23)
• sheets-ui: fix border panel icons (#1815) (ea7636e)
• sheets: fix the issue where the editor position is incorrect after unmerging cells (#1717) (7d27f11)
• sheet: update internal id (#1825) (fc4cc4c)
• ts-error (#1858) (b8007cb)
• uniscript entry is displayed in zen mode (#1842) (337af7d)
• uniscript: script editor service is not exposed (68647a6)

Features

• conditional-formatting: bugfix (#1838) (c0b3dce)
• design: add indeterminate property support to Checkbox component (#1870) (f522a34)
• docs: support background color in doc (#1846) (3a38828)
• formula: add the Maxifs function (#1711) (52b2698)
• sheets-data-validation: move draggable-list to design (#1822) (3acf286)
• sheets-ui: add f2 to start editing (#1875) (b740dfa)
• sheets-ui: sheet popup service should respond to row col changes (#1848) (6868a47)
• sheets: add watch API to ref-range-service (#1635) (5f7e9a2)
• sheets: data-validation ref-range & optimize package orignize (#1784) (a475474)
• ui: add disable auto focus config (#1682) (6256c15)
• ui: optimize scrollbar (#1856) (9e76a28)

0.1.6 (2024-04-03)

Bug Fixes

• backspace will cause error when doc is not ready (#1725) (f24fdb1)
• conditional-formatting: configuration exceptions are specifically handled (#1750) (37a7787)
• conditional-formatting: support row/col hidden (#1747) (7ed59d1)
• data-validation i18n (#1788) (73aae0b)
• delete undo redo (#1781) (8d8e615)
• design: apply pointer-events: none to avoid ::selection in Safari (#1792) (86bb772)
• design: change tooltip to not remain active after hover (#1756) (2019a77)
• facade: fix set horizontal, vertical, warp (#1766) (1876e68)
• find-replace: add locale exports (#1760) (a573166)
• formula: bracket nested (#1799) (d84a618)
• formula: today fill error (#1798) (4b35198)
• punctuation adjustment in the middle of line (#1686) (2382e3b)
• sheet: error while creating an empty subunit (#1748) (662b4e0)
• sheet: selection size and editor position (#1743) (fd83cbf)
• sheets: fix shallow copy bugs of the sheet snapshot (#1742) (83d910c)
• sheets: fix the issue with selection during autofill (#1707) (eb6f8d0)
• sheets: fix value type casting in set range values (#1646) (227f5b0)
• sheets: merge disappear on hide row (#1714) (e68d47f)
• sheets: some bugs about copy&paste / remove row&col / autofill (#1561) (e1072c7)
• the error clip the last char when linebreak (#1745) (009b5b4)

Features

• condiational-formatting: update enUS locale (#1787) (785e141)
• conditional-formatting: support set cfId (#1753) (4a277f9)
• design: add Textarea component (#1778) (a2dd33d)
• design: set default text color to prevent inheritance (#1751) (71e1d94)
• facade: add getMaxColumns and getMaxRows API on FWorksheet (#1775) (c903780)
• facade: add getSheetBySheetId API on FWorkbook (#1762) (436b1b4)
• facade: sheet api getId rename to getSheetId (#1770) (dff654c)
• sheet: defined name (#1737) (cfa9375)
• sheet: optimize data validation i18n & dropdown bugfix (#1768) (a8c9452)
• sheets: support data validation (#1676) (9961b32)
• support char which length is great than 1 (#1783) (32cfb3b)

0.1.5 (2024-03-29)

Bug Fixes

• editor: range selector and range drag (#1713) (02e9647)
• editor: short key error and normal range show (#1688) (571ec0b)
• fixing the range of remove merged selection and filter empty ranges (#1680) (117cbbe)
• formula: index function handles base value object (#1692) (1f0b700)
• punctuation adjustment issues in slide (#1690) (15cb6df)
• render: media change for refresh canvas (#1697) (dd6bfed)
• sheet: active dirty dependency ui (#1728) (d8c9e4b)
• sheet: fix the selection is incorrect when autofill intersects w… (#1661) (ebdcc6c)
• sheet: fix toolbar state when there's overlapping selection (#1521) (1ebfe1a)
• sheet: handle key value conflicts (#1720) (9abc7c5)
• sheet: null-value will not unexpected deleted when moving row/cols (#1691) (1a1f7c8)
• sheet: set-tab-order-mutation should has fromIndex in parmas for transforming (#1704) (6d05bd9)
• slides: export locale (#1702) (403c529)
• ui: canvas popup event bind error (#1683) (8a0bfd6)
• ui: fix toolbar display issues by adjusting reactive hidden item filtering logic (8b604eb)
• ui: fix toolbar responsiveness on small screens (#1716) (a9755e8)
• ui: fix use observable (#1719) (eabe6fb)

Features

• conditional-format: support conditional format (#1681) (50edd34), closes #433 #439 #495 #489 #487 #485 #483 #480 #475 #472 #468 #458 #433 #437 #446 #486 #437 #461 #454 #480

0.1.4 (2024-03-25)

Bug Fixes

• design: correct checkbox checked state logic for standalone usage (#1627) (5eea109)
• design: fix checkbox group value couldn't be modified (#1613) (dcb3e93)
• docs: remove deprecated property standalone (#1670) (ff686e6)
• editor: control state (#1649) (c39799f)
• editor: optimize editor focus (#1616) (e4231eb)
• editor: preload the editor (#1662) (09ceb16)
• editor: short key error (#1679) (7afaff0)
• engine-render: add missing IPageRenderConfig type export (d972f5d)
• export more types from render engine plugin (#1608) (cf134be)
• facade: should not return promise in syncExecuteCommand (#1648) (9a0d300)
• find-replace: fix dialog issues (#1590) (2390086)
• fix extracted value from cell content (2e22324)
• formula: add OR/TEXT/LEN functions (#1593) (c26eed1)
• formula: array cache error (#1644) (19d9612)
• formula: index function supports reference object (#1657) (b47487a)
• formula: math functions support string number calculation (#1581) (0779488)
• rectangle subtract func (#1647) (345fddc)
• sheet: error value object (#1596) (e3714e1)
• sheet: fix error edit position after merging (#1520) (8685e14)
• sheet: fix the issue of incorrect number of merged cells in the format painter (#1526) (cd9b6f8)
• sheet: handleRemoveRowsCols util func (#1656) (f30b987)
• sheets-ui: merge setRangeValuesMutation at clipboardservice (#1665) (bf9fc0d)
• sheets: boolean should store as number (#1605) (78e5426), closes #1534
• slide: image loaded (#1653) (9cecaaa)
• slide: slide initialize (#1641) (599ed71)
• ui: cleanup DOMs when dispose (#1663) (b81ba1a)
• ui: prevent formula bar from displaying when header is set to false & remove unused code (#1633) (e3d875c)
• ui: should not make clipboard util iframe visible (#1620) (06760b5)
• wrong doc example data (#1667) (a875a31)

Features

• add disable status to doc (#1622) (b03c707)
• core: add registerPlugin config types (#1484) (a5a073c)
• create empty doc by pass empty object {} (#1606) (ff54fa0)
• design: add component Segmented (#1618) (78156fd)
• design: ssr support (#1603) (cdb7d49)
• doc: continuous punctuation extrusion and paragraph align (#1625) (b50997d), closes #1670
• network: add retry and threshold interceptor (#1664) (5791d4d)
• sheet: add range merge util (#1615) (e2118b5)
• sheet: numfmt support i18n (#1558) (b39f982)
• ui: support popup service (#1640) (5e597fd)

Performance Improvements

• engine-render: optimize border perf (#1574) (0aa2898)
• formula: optimize dependency calculate and array value object compare (#1629) (d884ee0)
• render: optimize doc render (#1599) (ab76ebd)
• sheet: statistic and formula perf (#1583) (9e63af7)

BREAKING CHANGES

• sheets: Before: Boolean values ("TRUE" "FALSE") were stored in the IWorkbooData as strings. After: Boolean values would be store as number (0, 1).

0.1.3 (2024-03-15)

Bug Fixes

• design: fix title in Dialog to use passed variable (#1556) (5aeb65f)
• design: restore styles for non-draggable dialog (#1498) (ee694f2)
• doc: copy form univer text and paste to univer (#1473) (4f3ab13)
• editor: range selector (#1568) (bba50e7)
• editor: add value (#1512) (d398384)
• editor: controlled component and readonly (#1507) (c8c7bf3)
• editor: cursor and menu and single choice (#1499) (6cdccde)
• editor: range selector (#1503) (eee2aab)
• editor: value change (#1514) (4a21331)
• formula: check syntax (#1543) (15a04ed)
• formula: formula select and negative (#1444) (75de31c)
• formula: isMatchWildcard escape regular string, add icons (#1493) (c520ad7)
• formula: token uppercase (#1579) (5c99f3a)
• formula: worker error (#1565) (47377ae)
• inline format in cell with rich text (#1560) (447a095)
• render: rect blurring (#1511) (97ed99a)
• render: update font offset (#1545) (42fb8a2)
• sheet: add focus change (#1500) (ed27e84)
• sheet: border corner (#1567) (0fc3a6d)
• sheet: border excel compatibility (#1539) (d68896a)
• sheet: editor error (#1533) (0da7b64)
• sheet: first sheet hidden (#1538) (6123772)
• sheet: inline format menu display error when paste (#1482) (c66f9e1)
• sheet: keep consistent with excel rotation (#1562) (c100bc8)
• sheet: merge align (#1537) (e0b49cc)
• sheets-ui: fix z-index value in operate-container (#1516) (0ce931d)
• sheets-ui: room slide does not need to be disabled (45c60bf)
• sheet: selection color (#1572) (609f907)
• sheet: string bool and number align (#1525) (473cf6f)
• sheet: the icons for hiding rows and columns do not disappear. (#1527) (598e7eb)
• sheet: wrap and rotation (#1517) (9e8cc45)
• system shortcut teminate ime input (#1535) (91397c6)
• ui: fix layout service throwing error (#1490) (c2ee6d2)
• ui: fix menu not displaying as expected (#1529) (48c1ab8)
• ui: handle dynamic import in renderVue3Component with try-catch due to esbuild limitations (#1518) (a684e9d)
• warning for postcss-preset-env (#1544) (351e2a4)

Features

• add function to extract pure text from cell (#1575) (fe0c8de)
• collaboration: move snapshot transform to core (#1519) (6557ea5)
• core: add getCurrentLocale to LocaleService (#1555) (05866a3)
• core: export function to use in exchange (#1547) (54da0dc)
• design: add className props to Input (#1569) (b73df3f)
• design: add DateRangePicker (#1510) (9f0a842)
• design: add DatePicker (#1497) (44ec056)
• design: implement edge avoidance for Dialog (#1522) (290e5d0)
• editor: style and placeholder (#1571) (be4482c)
• editor: support shortcut (#1513) (b362e73)
• example: add doc uniscript example (#1495) (ed01f92)
• facade: register sheet render extension (#1356) (264c097)
• formula: support cubeValueObject (#1536) (1c77658)
• sheet-ui: find & replace (#1349) (3828239)
• sheet: add font method (#1506) (9cf028f)
• sheet: empty formular bar when in array range (#1532) (eea95ac)
• sheet: range selector (#1463) (b639394)
• sheet: support font render config (#1542) (ef48825)
• ui: extend support for registering and using Vue 3 components (#1502) (7c28761)

0.1.2 (2024-03-06)

Bug Fixes

• design: fix z-index for SubMenu (#1440) (4d49dad)
• doc: copy error when range is empty (#1488) (1ae73ca)
• doc: need to serialize text ranges (#1487) (de87e10)
• engine-formula: ensure super is called at the beginning of the constructor (#1452) (a9cb84d)
• examples: fix multi-instance & uniscript UI rendering error (#1469) (1d6e257)
• insert row col with effect freeze (#1464) (8de2b10)
• only editing need to scroll to selection (#1455) (5296f32)
• sheet: fix unreasonable merged selections (#1477) (bd8c5df)
• sheet: inline format error when textRuns is empty (#1480) (8f5caae)
• sheet: insert row/col undo bug (#1350) (5781a63)
• sheets-ui: dynamically adjust row header width (#1475) (371b4f1), closes #1471
• wrong cell value in cell data (#1461) (0cda975)

Features

• add focus handler for doc (#1433) (7c3ad49)
• design: add preservePositionOnDestroy & defaultPosition to Dialog (#1439) (b1d18ca)
• editor: editor modifications to accommodate the range selector (#1460) (22b2734)
• formula: add functions, fix function calculation error (#1395) (885ba4b)
• numfmt: support enUs (#1456) (0f825fb)
• numfmt: support percent (#1457) (22b9c0c)
• replacement in document body (#1451) (e258abd)
• sheets: add row col iterator in worksheet (#1478) (5abd68e)

0.1.1 (2024-03-01)

Bug Fixes

• apply mutation (#1423) (ccd30dc)
• double click to selection also need to share cursor (#1446) (c6ae623)
• editor: zen error and formula align (#1437) (60d94a3)
• inline menu highlight (#1401) (b3d25e9)
• page width should great than 0 (#1402) (281a4b9)
• sheet: formula boolean value (#1360) (9a8a4be)
• sheet: optimize memory release and resolve issues with the editor being recreated repeatedly (#1432) (b14207b)

Features

• add isEditing param (#1428) (aa92e60)
• add trigger in the if condition for share cursor use (#1431) (c781f22)
• export is active for share cursor use (#1420) (ba51971)
• i18n: add TypeScript type checking for localization files (#1424) (4afe9e5)

0.1.0-beta.5 (2024-02-23)

Bug Fixes

• cursor position (#1363) (34508a0)
• cut paste undo bug & optimize status bar calc (#1353) (072e0de)
• design: remove duplicate z-index property from Select's dropdown CSS definition (#1408) (abc13b4)
• doc: copy data (#1399) (1eb9113)
• doc: ts check (#1354) (bca22c6)
• examples: fix the broken uniscript demo (70c2a5c)
• fix autofixable lint (#1325) (4065ea8)
• fix sheet command preconditions (#1319) (6e92c60)
• formula: get rich text data stream as content (#1305) (51ae0e1)
• formula: sum get error when cell has error (#1306) (a13c450)
• inline format error (#1365) (a3f1e9b)
• modify doc rev default value (#1377) (86f93be)
• no history no need to collaboration (#1348) (157b4db)
• no need to convert to px (#1385) (a655169)
• paste row height and col width (#1330) (60bd78a)
• render: context native line width (#1381) (36aa429)
• render: px to pt (#1382) (608f9df)
• sheet-ui: fix clipboard not available in unsecure context (#1345) (bd57a84)
• sheet: auto add bracket (#1358) (fdecc66)
• sheet: binary search (#1361) (23221c4)
• sheet: default vertical align (#1383) (d96edf0)
• sheet: editor input (#1411) (76f5e9c)
• sheet: fix snapshot references are not consistent (#1339) (bf71b36), closes #1332
• sheet: formula ref move (#1359) (65e64bf)
• sheets: inline menu highlight error (#1388) (8ca9cc1)
• sheet: suffix (#1409) (fdd7b72)

Features

• add destroyOnClose for Dialog (#1391) (a6e17ef)
• add resources in IDocumentData (#1327) (339c36b)
• add string interpolation support for locale service (#1362) (8f338ba)
• core: set appVersion to package version (#1328) (c9193a1)
• design: change the style of the Dialog and Select (#1352) (0204b43)
• export IDocStateChangeParams and DocStateChangeManagerService (#1336) (8a99b05)
• facade: add onBeforeCommandExecute API (#1370) (b842579), closes #1346
• facade: add set font apis and get cell model data api (#1266) (d0a8709)
• formula: today function, set numfmt data (#1295) (f069dd8)
• hide the header menu when there is no content in it (#1331) (bf692c2)
• ref-range: support default range change util (#1351) (54512ea)
• sheet: optimize sheet render (#1245) (33bc465)
• sheets-zen-editor: export language packs (#1413) (0ec2dc9)