Releases: dream-num/univer
🎉 Release v0.2.15
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheets
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Optimized merged cell implementation, significantly improving performance with large datasets #3403
- Added new formula functions:
MID
andLEFTB
#3417 #3418 FWorksheet.getRange
now supports A1 notation input #3504- Now supporting 321 formula functions, with a goal of 500+
🐞 Bug Fixes
- Fixed an issue where column widths were not preserved when pasting from Excel #3450
- Resolved a problem where clicking the scrollbar didn't trigger scroll commands #3429
- Improved permissions, allowing cell size adjustment when setEditable(false) #3464
- Fixed the "permissionPoint does not exist!" error when recreating units #3392
- Column header arrows are now hidden when contextMenu is set to false #3444
- Addressed incomplete display issues in hyperlink editing #3462
📝 Univer Docs
- Stability improvements
🌐 Univer Server
- Table insertion is supported after importing the Docx file
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (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
isfalse
(#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
isfalse
(#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
🎉 Release v0.2.14
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheets
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Support for hyperlinks in rich text within cells #3322
- Format painter now supports conditional formatting #3420
- Added 7 new lookup and reference formula functions #3352
- Introduced new formula functions: bycol, byrow, map, reduce, and scan #3320
- Added 16 new mathematical formula functions #3381
- Now supporting 319 formula functions, with a goal of 500+
🐞 Bug Fixes
- Optimized scrolling performance when using filters with large datasets #3396
- Permission errors no longer output to console #3363
- Optimized behavior related to formula IDs #3339
- Fixed issue where
custom
property was being overwritten as{ __link_url: "" }
#3434
💔 Breaking Changes
- Refactored data-validation model #3383
📝 Univer Docs
💔 Breaking Changes
- refactor of doc selections #3299
- The
TextSelectionManagerService
service was renamed toDocSelectionManagerService
. - Some of the APIs in the docs package were moved to the
docs-ui
package. TextSelectionRenderManagerService
is migrated to thedocs-ui
package, renamed toDocSelectionRenderService
, and theIRenderModule
interface is implemented.
- The
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (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)
- sheet: custom will overwrite the original value (#3431) (e1042d4)
- sheets-ui: formula error when cross sub-sheet (#3436) (97ae314)
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)
- sheets-ui: optimize shortcut for comment & hyperlink editor (#3434) (9604020)
🎉 Release v0.2.12
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheets
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Added support to disable transform for floating elements by setting
allowTransform
tofalse
when adding them to a worksheet. #3342 - Added 3 new formula functions:
ISFORMULA
,N
, andNA
. #3304 - Added new facade APIs supporting cell data retrieval (
FRange.getValues
), simplified merge operations, clipboard functionality, and selection management. #3344 #3289 #3216 - Now supporting 291 formula functions, with a goal of 500+
🐞 Bug Fixes
- Fixed scroll freezing issue when filtering large datasets by optimizing row visibility checks. #3319
- Fixed errors in the UniScript panel for smooth typing and editing. #3350
- Fixed permission-related rendering bugs. #3300
- Other optimizations and fixes
💔 Breaking Changes
A new way to customize the menu
Refactored the menu service and configuration service (#3246).
The purpose is to prepare for the inability to specify menu sorting and to provide simplified registration of menus and more customization capabilities in the future.
Key differences:
- Service Change:
- Before: Used
IMenuService
for menu management - After: Now uses
IMenuManagerService
- Before: Used
IMenuService
will provide several versions of fallback compatibility for developers to migrate.
- @IMenuService private readonly _menuService: IMenuService,
+ @IMenuManagerService private readonly _menuMangerService: IMenuManagerService,
- Menu Registration:
- Before: Added menu items individually using
addMenuItem
- After: Uses a new
mergeMenu
method to define the entire menu structure
- Before: Added menu items individually using
- this.disposeWithMe(this._menuService.addMenuItem(this._injector.invoke(MenuItemFactory), {}));
+ this._menuMangerService.mergeMenu({
+ [RibbonStartGroup.OTHERS]: {
+ [MenuItemId]: {
+ order: 10,
+ menuItemFactory: MenuItemFactory
+ },
+ // ... other menu items
+ },
+ // ... other menu groups
+ });
- Menu Item Configuration:
- Before: Included
positions
andgroup
properties in menu item definitions - After: These properties are now defined in the menu item configuration within the
mergeMenu
method, rather than in the menu item definition itself
- Before: Included
return {
id: MENU_ITEM_ID,
type: MenuItemType.BUTTON,
icon: 'IconName',
tooltip: 'tooltipKey',
title: 'titleKey',
- group: MenuGroup.TOOLBAR_FORMULAS_INSERT,
- positions: [MenuPosition.TOOLBAR_START, MenuPosition.CONTEXT_MENU],
};
These changes provide a more centralized and structured approach to menu management. Univer plugin developers will need to update their menu registration code to align with this new structure.
📝 Univer Docs
- Added support for line height settings in documents, allowing both fixed values and multiple line spacing options. #3176
- Hyperlink refactor. #3148
- Other optimizations and fixes
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-09-07)
Bug Fixes
- auto-fill: change apply type will undo last commands (#3311) (391c523)
- clipboard: copy will not use filtered-out rows content (#3292) (ec601c3)
- conditional-formatting: init view model (#3349) (ad145f2)
- conditional-formatting: render cache error (#3345) (e812441)
- conditional-formatting: the maximum and minimum values are corre… (#3270) (5d41a9b)
- crosshair: fix no plugin name for the plugin (19564c7)
- design: popup style (#3325) (675933c)
- detect row/col index in selection (#3348) (c9fef1b)
- docs: link break in link (#3254) (ff17894)
- drawing issues (#3245) (d848d33)
- filter: filter range change error when remove rows/cols (#3324) (a70ef37)
- filter: filter render controller should dispose its vars when unit disposed (#3340) (be7da80)
- fix dependencies of telemetry (#3280) (965064e)
- fix the sorting menu item display position (#3314) (3f18a4f)
- fix threshold error handling (#3261) (1e1dde5)
- fix uni menu (#3338) (af63f7d)
- font rendering diffrange condition fix (#3264) (c920d53)
- formula: bracket has more blank (#3331) (4900a3c)
- formula: fix formula paste (#3257) (771f191)
- formular: fix dependency performance issue (#3359) (f2f7f5b)
- mobile selection did not drawing (#3312) (d1773ed)
- permission: fix permission render bugs (#3300) (9751c0a)
- selection type did not update when set type to normal(0) (#3317) (2909cf8)
- sheet-data-validation: auto-format data validation non-standard date string & data-validation auto-fill (#3336) (fc3dc44)
- sheets-drawing-ui: sheet-drawing error receive data from doc (#3337) (b8e6e42)
- sheets-drawing-ui: sheet-drawing-import (#3277) (183b3e0)
- sheets-formula: fix the issue of missing formula description list (#3323) (9d314ce)
- sheets-ui: auto-fill will copy auto-height strategy from origin region (#3287) (04f156e)
- sheets: skip remove-sheet on watch range if skipIntersects was set ([...
🎉 Release v0.2.11
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheets
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Added cross-highlighting plugin, which highlights the row and column of the selected cell when enabled
- Install the following packages:
pnpm add @univerjs/sheets-crosshair-highlight
- Import the plugins:
import '@univerjs/sheets-crosshair-highlight/lib/index.css';
import { UniverSheetsCrosshairHighlightPlugin } from '@univerjs/sheets-crosshair-highlight';
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core';
+import SheetsCrosshairHighlightZhCN from '@univerjs/sheets-crosshair-highlight/locale/zh-CN';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.ZH_CN,
locales: {
[LocaleType.ZH_CN]: Tools.deepMerge(
+ SheetsCrosshairHighlightZhCN
),
},
});
- Register the plugin:
univer.registerPlugin(UniverSheetsCrosshairHighlightPlugin);
- Added 26 new financial formula functions #3137
- Added 26 new engineering formula functions #3070
- Added row and column operation Facade APIs #3163
- Added comment and floating DOM Facade APIs #3200
- Now supporting 288 formula functions, with a goal of 500+
🐞 Bug Fixes
- Fixed abnormal issue when users of lower versions of React upgrade to 0.2.9 #3248
- Fixed modifying selection range with shift+arrow keys when selected #3193
- Fixed scrolling lag caused by incorrect destruction after import #3205
- Fixed decimal place interaction #3195
- Fixed number format to support percentage calculation display #3195
- Fixed number format to skip null or undefined #3188
- Fixed underline not displaying when bottom-aligned #3139
- Fixed merged cell performance optimization #3187
- Fixed inability to input dates in STOP mode #3237
- Optimized formula calculation precision #3244
📝 Univer Docs
🐞 Bug Fixes
- Fixed selection issues in tables and paragraphs #3170
- Optimized table operations #3214 #3234
- Improved copy and paste functionality #3233 #3227
- Various other optimizations
🌐 Univer Server
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Fixed the export failure issue, no need to configure the S3 address after deployment.
- Optimizations for domestic developers' deployment:
- Choose appropriate mirror addresses based on network conditions;
- Improved the installation experience of one-click deployment scripts, including:
- System checks before installation;
- Service health checks after installation;
- Installation guidance of Docker if not exists;
- Simplified one-click deployment command:
bash -c "$(curl -fsSL https://get.univer.ai)"
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-08-30)
Bug Fixes
- sheet: render after every mutation executed (#3258) (91217dc)
- sheets-data-validation: cant resume data-validation on undo remove-sheet (#3260) (7e9e69f)
- some operations can be performed when have view permission (#3180) (8664a75)
- add missing exports (c6ee109)
- add rows by paste should support undo (#3208) (9ee12c2)
- conditional-formatting: hidden values do not take effect when us… (#3228) (4e888d0)
- conditional-formatting: setting highlight error can not be confi… (#3229) (5c16e04)
- copy paste between sheet and doc (#2993) (617986d)
- docs: copy paste image form univer doc to univer doc (#3227) (c2f417c)
- docs: copy table only has one row and col (#3234) (08034d0)
- docs: find cursor by cood (#3105) (5d80b5b)
- docs: no need to scroll when enter zen mode (#3222) (1ebbe27)
- docs: paste content to univer (#3071) (97e19b3)
- docs: paste table after table (#3214) (1899d34)
- docs: remove content and insert drawing (#3198) (f68e8eb)
- docs: reserve the first remove text run (#3225) (01fdcca)
- docs: selection error in table and paragraph (#3170) (c6f2eb7)
- docs: show font family after copy from header (#3233) (480e9f1)
- docs: wrong font family in menu (#3232) (f896261)
- editor: boolean values do not need to be processed (#3204) (f060863)
- fix the judgment logic of editor returning empty textRun (#3211) (9a57c5d)
- formula: fix operation accuracy (#3244) (20b4dd5)
- formula: parser error (#3174) (6e2db5a)
- modify the rich text judgment logic (#3178) (0431c1f)
- multi normal selections did not refresh when changing sheets. (#3166) (1314465)
- numfmt: add or substract decimal inheritance (#3195) (67f25c8)
- numfmt: menu circular dependencies (#3248) (5087f29)
- numfmt: numfmt skip null or undefined (#3188) (a923a93)
- numfmt: support edit percent with numfmt (#3190) (d8ca9f6)
- paste col should keep wider column width ([#3185](https://github.com/dream-num/univer/issu...
🎉 Release v0.2.9
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheets
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Added more Facade APIs related to permission protection #3132
- Added more Facade APIs related to filter #3103
- Added more Facade APIs related to pivot table
- Added internationalization support for currency shortcuts #3062
- Added rank/rank.avg/rank.eq sorting functions #3140
- 236 formula functions are supported, with a goal of 500+
🐞 Bug Fixes
- Fixed an issue with formula calculations #3114
- Fixed an issue where imports were not displayed completely #3114
- Fixed an issue with incorrect positioning of the floating DOM layer #3152
- Fixed a timing issue during the initialization of conditional formatting #3142
- Fixed an issue where custom menu items were hidden by default when hidden$ was not configured #3122
- Fixed a date validator error when errorStyle=STOP was set in sheets data validation #3102
💔 Breaking Changes
-
The method to get workbook data has been updated. Also,
FWorkbook.getSnapshot
will be removed in the future, so please switch to theFWorkbook.save
method. #3128 -
Some useless properties on snapshots are removed:
houldStartRenderingImmediately
,container
,selections
#3154 -
The package name for the pivot table plugin has been updated from
@univerjs-pro/pivot-engine
to@univerjs-pro/engine-pivot
. Additionally, the default configuration options required by the plugin have been removed.
install the new package:
pnpm add @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui
- pnpm add @univerjs-pro/pivot-engine
+ pnpm add @univerjs-pro/engine-pivot
plugin registration:
-univer.registerPlugin(UniverSheetsPivotTablePlugin, {
- notExecuteFormula: true,
- registerInOneThread: true,
-})
+univer.registerPlugin(UniverSheetsPivotTablePlugin)
univer.registerPlugin(UniverSheetsPivotTableUIPlugin)
📝 Univer Docs
🐞 Bug Fixes
- Fixed bugs in
docs-ui
/docs
/docs-drawing-ui
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-08-23)
Bug Fixes
- conditional-formatting: initialization timing problem (#3142) (7d1c9d6)
- crosshair: fix rendering controller (f697951)
- debug currentSkeleton$ if param is null (#3164) (3283d61)
- docs-ui: limit list maxLevel to 3 when in table & set line-through style on checklist (#3096) (9a62d77)
- docs-ui: link & checklist can't work on header-footer (#3107) (106e7c4)
- docs: disable some menu items when no selections (#3094) (07a24cb)
- docs: find cursor by coods (#3143) (9998feb)
- docs: line space between image and line (#3101) (32915ff)
- docs: no need to scroll to selection when resize page (#3092) (9697d87)
- fix issue where custom menu items are hidden by default when
hidden$
is not configured (#3122) (701131d) - fix some permission bugs (#3037) (eb30bdc)
- fix type error (983a323)
- formula: array input (#3097) (774d09c)
- formula: skip tree after add to formula run list (#3114) (a238ea9)
- hyper-link ref-range error on filter (#3135) (014dd67)
- permission: optimize permission calculation logic in dv (#2811) (d127e02)
- ref selection expand after bottom line is over top line, and ref selection fill area(primary cell) and formula editor should clear when change sheet. (#3104) (e73fc3c)
- selection render and insert char (#2982) (411d328)
- sheet: defined name panel style (#2797) (23a581b)
- sheet: mixin should not use class self (#3130) (1d7c3ab)
- sheet: move function to a file and export (#3125) (8483725)
- sheets-data-validation: data-validation absolute offset (#3091) (135e5c0)
- sheets-data-validation: date validator error when errorStyle=STOP was set (#3102) (a5015c8)
- sheets-drawing-ui: float-dom-layer position not correct on sheets and uni mode (#3152) (4e434b0)
- sheets-ui: data-validation dropdown hidden when selection change (#3119) (b8bf3b1)
Features
- add crosshair highlight plugin for Univer Sheet (#3118) (3e9c34c)
- docs: tab in table (#3064) (39ce155)
- facade: add FFormula api (#3144) (610be1f)
- filter: add facade API and docs (#3103) (dc37071)
- formula: add rank/rank.avg/rank.eq function (#3140) (d2a3ec2)
- numfmt: currency shortcuts support internationalization (#3062) (736cb9b)
- permission: add facade api (#3132) (ca21fb8)
- pivot: add mixin to util (#3124) ([53f6610](53f6610864ddc5f269bc94dafd5...
🎉 Release v0.2.8
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
📊 Univer Sheet
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Add data validation facade API #3050
- support dropdown filter for data validation #3057
- add 28 financial formula functions #2868
- add 28 engineering formula functions #2893
- 233 formula functions are supported, with a goal of 500+
🐞 Bug Fixes
- ensure state is correctly updated after modifying the hover image #3069
- fix data validation paste #3057
- permission protection focus judgment optimization #3081
- fix error prompt that may occur when setting styles in some cases #3059
- fix abnormal display of data validation dropdown date, multi-language display #3055 #3018
💔 Breaking Changes
- Pivot table plugin registration configuration adjustment
univer.registerPlugin(UniverSheetsPivotTablePlugin, {
notExecuteFormula: true,
- isServer: true,
+ registerInOneThread: true,
})
📝 Univer Doc
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Support docx file import
- Install the following packages:
pnpm add @univerjs-pro/exchange-client @univerjs-pro/docs-exchange-client
- Import the plugins:
import '@univerjs-pro/exchange-client/lib/index.css'
import { UniverExchangeClientPlugin } from '@univerjs-pro/exchange-client'
import { UniverDocsExchangeClientPlugin } from '@univerjs-pro/docs-exchange-client'
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import UniverExchangeClientEnUS from '@univerjs-pro/exchange-client/locale/en-US'
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ UniverExchangeClientEnUS,
),
},
});
- Register the plugin:
univer.registerPlugin(UniverExchangeClientPlugin)
univer.registerPlugin(UniverDocsExchangeClientPlugin)
🌐 Univer Server
- Support docx file import
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-08-16)
Bug Fixes
- add inputFormula$ (#3013) (c5ce261)
- doc drawing load error on uni mode (#3033) (bd32e08)
- docs-drawing-ui: doc drawing load error on uni mode (#3034) (ba4ce37)
- docs: delete list between tables (#3041) (97842a0)
- docs: delete paragraph break in table cell (#3077) (dc566fd)
- doc: should not resize all internal editors except zen mode (#3005) (0cf5e2d)
- docs: insert footer (#3058) (14469e5)
- docs: line space (#3082) (f5dcea0)
- editor: slide editor should use a different id from sheet cell editor (#3008) (b95d337)
- export resetCahce from sheet-skeleton (#3087) (c400ab1)
- filtered & hidden rows should not be calculated in statusbar (#3026) (803ced4)
- fix permission initialization in multi-unit situation (#3019) (fd73710)
- fix sheet editor life (fc08d5f)
- formula: async formula (#3025) (aff2b29)
- lint (#3088) (397e446)
- permission: fix permission bugs 0815 (#3081) (870cd22)
- sheet: add from & to range in moverange & clone the cellvalue (#3044) (bd91317)
- sheet: pivot data spill (#3039) (bf697b6)
- sheets-data-validation: date data validation format not work & optimize popup-service (#3018) (92dedd6)
- sheets-data-validation: date dropdown display error on invalid value (#3055) (2e89983)
- sheets-drawing-ui: export SheetsHyperLinkCopyPasteController for usage of pro (#3052) (dbf2101)
- sheets-drawing: drawing on uni mode (#3009) (9644695)
- sheets-drawing: sheet-drawing error depend on renderManagerService (#3030) (efc1702)
- sheets-ui: watch-range error on move-range (#3060) (7430e84)
- slide canvasview to slide render controller (#3032) (dbdd85c)
- slide&sheet image component-name duplicated (#3012) (afe89d4)
- slide: init cursor stage change listener really late (759ba75)
- some ui problems in uni-mode (#3029) (19eb1dc)
- spread operator with Math.min max cause Maximum call stack size … (#3059) (1e52972)
- ui: move event bubbling prevention from "More" menu to button (#3031) (e07e0c8)
- ui: optimize Menu component rendering and filtering logic (#3028) (9a19335)
- uni drawing update (#3016) (607e400)
- update drawing panel state at end of changing (#3069) (3a5635f)
- worker not disposed ([#...
🎉 Release v0.2.7
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- pivot table (beta) and restoration from history in Univer Sheet
- custom style lists, to-do lists, and table insertion in Univer Doc
- commenting in both documents and spreadsheets
- new server APIs for querying, document deletion, and USIP, and expands formula support to 176 with a goal of over 500 formulas.
Univer Sheet Supports Pivot Table(beta)
- Install the following packages:
pnpm add @univerjs-pro/pivot-engine @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui
- Import the plugins:
import '@univerjs-pro/sheets-pivot-ui/lib/index.css';
import { UniverSheetsPivotTablePlugin } from '@univerjs-pro/sheets-pivot'
import { UniverSheetsPivotTableUIPlugin } from '@univerjs-pro/sheets-pivot-ui'
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import UniverSheetsPivotEnUs from '@univerjs-pro/sheets-pivot/locale/en-US';
+ import UniverSheetsPivotUiEnUs from '@univerjs-pro/sheets-pivot-ui/locale/en-US';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ UniverSheetsPivotEnUs,
+ UniverSheetsPivotUiEnUs
),
},
});
- Register the plugin:
// tip: Please note that the configs in the beta version are not stable, and be mindful of future updates.
univer.registerPlugin(UniverSheetsPivotTablePlugin, {
notExecuteFormula: true,
isServer: true,
})
univer.registerPlugin(UniverSheetsPivotTableUIPlugin)
Univer Sheet supports restoration from history.
To use this feature, please refer to the documentation and install version 0.2.7
of the Univer server first.
- Install the following packages:
pnpm add @univerjs-pro/edit-history-viewer @univerjs-pro/edit-history-loader
- Import the plugins:
import '@univerjs-pro/edit-history-viewer/lib/index.css'
import { UniverEditHistoryLoaderPlugin } from '@univerjs-pro/edit-history-loader'
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import EditHistoryViewerEnUS from '@univerjs-pro/edit-history-viewer/locale/en-US'
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ EditHistoryViewerEnUS
),
},
});
- Register the plugin:
// need equal to the univer container id, if not set, default is univer-container
const configService = univer.__getInjector().get(IConfigService);
configService.setConfig('UNIVER_CONTAINER_ID', `univer`)
univer.registerPlugin(UniverEditHistoryLoaderPlugin)
Univer Sheet supports comments
- Install the following packages:
pnpm add @univerjs/thread-comment-ui @univerjs/sheets-thread-comment
- Import the plugins:
import '@univerjs/thread-comment-ui/lib/index.css'
import { UniverSheetsThreadCommentPlugin } from '@univerjs/sheets-thread-comment'
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import UniverThreadCommentUiEnUs from '@univerjs/thread-comment-ui/locale/en-US';
+ import UniverSheetsThreadCommentEnUs from '@univerjs/sheets-thread-comment/locale/en-US';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ UniverThreadCommentUiEnUs
+ UniverSheetsThreadCommentEnUs
),
},
});
- Register the plugin:
univer.registerPlugin(UniverSheetsThreadCommentPlugin);
Univer Doc supports comments
- Install the following packages:
pnpm add @univerjs/thread-comment-ui @univerjs/docs-thread-comment-ui
- Import the plugins:
import '@univerjs/thread-comment-ui/lib/index.css'
import { UniverDocsThreadCommentUIPlugin } from '@univerjs/docs-thread-comment-ui'
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import UniverThreadCommentUiEnUs from '@univerjs/thread-comment-ui/locale/en-US';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ UniverThreadCommentUiEnUs
),
},
});
- Register the plugin:
univer.registerPlugin(UniverDocsThreadCommentUIPlugin);
-
Univer Doc supports custom styles for ordered and unordered lists, to-do lists, table insertion with nested content, and paragraph panel settings.
-
Univer Server adds document query API, document deletion API, and USIP API.
-
Formula expansion: Now supports 176 formulas with a target to support over 500 formulas.
For more information, please visit the official website documentation.
🐞 Bug Fixes
- fix DataValidation config ui styles #2991
- fix formula
iseven
andisodd
#2920 - fix formula sheet name uppercase bug #2908
- fix data-validation ref-range error init form snapshot & support hyperlink target #2975
- fix can not add custom formula #2915
🎢 Special Thanks
Special thanks to the following contributors who have made this release possible:
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-08-10)
Bug Fixes
- add range type when create selection (#2965) (ff6a667)
- add rect ranges to share cursor (#2942) (1d5d42f)
- add table create row col limit to 20 (#2967) (04accd2)
- adjust toolbar item position in uni-mode (#2987) (285cdf5)
- can not edit in footer (#2956) (28c951b)
- can not insert table in link (#2960) (7448724)
- can not select text when the last page ends with table (#2954) (d5d3b39)
- change element to save editing state & update doc sk after resize (#2950) (35b0bac)
- col visible (#2981) (184ffdd)
- conditional-formatting: can not add custom formula (#2915) (e9435ee)
- conditional-formatting: fixed a performance issue during the initialization phase of the conditional format (#2919) (8ddc701)
- context menu disable status (#2943) (510c178)
- context menu should not clear selections (#2949) (b5fcb55)
- core: fix editor set focus element by mistake (9b0ba21)
- core: fix resource loader not work for created units (#2996) (9df348d)
- core: fix resource manager get unrelated data (#2989) (b29cf76)
- data-validation ref-range error init form snapshot & support hyperlink target ([#2975](#2...
🎉 Release v0.2.6
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Added 4 text formulas, 1 math formulas, and 10 find reference formulas. (169/508 formulas supported) #2842
- Support for custom number formats #2888
@univerjs-pro/sheets-print
now supports screenshots, with a right-click menu option to copy as an image.
🐞 Bug Fixes
- When destroying a Univer instance, leftover DOM from custom Vue3 components will be cleaned up #2892
- Fix error occurring after input cancellation #2907
💔 Breaking Changes
- Adjustments to the import and export plugin
@univerjs-pro/sheets-exchange-client
introduction
- Install the following packages:
-pnpm add @univerjs-pro/sheets-exchange-client
+pnpm add @univerjs-pro/exchange-client @univerjs-pro/sheets-exchange-client
- Import the plugins:
-import '@univerjs-pro/sheets-exchange-client/lib/index.css';
+import '@univerjs-pro/exchange-client/lib/index.css';
- Add locale resources:
-import SheetsExchangeClientEnUS from '@univerjs-pro/sheets-exchange-client/locale/en-US';
+import ExchangeClientEnUS from '@univerjs-pro/exchange-client/locale/en-US';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
- SheetsExchangeClientEnUS
+ ExchangeClientEnUS
),
},
});
- Plugin developers should be aware that the Injector parameter in onStarting will be deprecated in upcoming versions. Please transition to using class properties promptly #2903
export class UniverXXXPlugin extends Plugin {
static override type = UniverInstanceType.UNIVER_DOC;
static override pluginName = PLUGIN_NAME;
constructor(
private _config: unknown,
@Inject(Injector) protected override _injector: Injector
) {
super();
}
- override onStarting(injector: Injector): void {
+ override onStarting(): void {
- injector.add(dep);
+ this._injector.add(dep);
}
}
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-08-02)
Bug Fixes
- doc: list update (#2862) (b045042)
- docs-drawing: formula ts error & docs-drawing load error (#2879) (1182bee)
- drawing: update (#2871) (1880552)
- formula: fix formula parameter assignment (#2905) (8fb9655)
- ref selection should call updateSelection after skelenton change (#2839) (d37f669)
- sheet: fix expand range performance (#2882) (0de3488)
- sheet: parse snapshot string (#2897) (f4fe38d)
- ui: ensure container DOM is removed when destroying Vue 3 components (#2892) (5c38528)
- unitId type error in handle editor invisible (#2907) (5e09017)
- use new selectionData not workbook._worksheetSelections (#2909) (b597194)
Features
- deprecated float-dom.props (#2864) (43220a1)
- docs-ui: debounce doc-hover event (#2865) (ce949fd)
- docs-ui: doc daily optimization (#2869) (f0b6410)
- docs: doc-rename (#2891) (307d1de)
- formula: add some Text/Math/Lookup formulas (#2842) (778e371)
- numfmt: support custom format (#2888) (95314eb)
- sheet-data-valiation: using cell-raw on data-validation (#2878) (935bdba)
- slides: support partial slides function (#2890) (3a90918)
Performance Improvements
🎉 Release v0.2.5
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Univer Doc supports context menus and zooming #2830
- Added 30+ math formulas, 7 date formulas, and 3 information formulas #2761 #2798
- Optimized table scrolling #2779
- Enhanced formula input experience #2772
🐞 Bug Fixes
- Improved URL recognition #2845
💔 Breaking Changes
- The
Inject
related imports fromredi
have been moved to@univerjs/core
#2801
Before:
import type { Dependency } from '@wendellhu/redi';
import { Inject, Injector } from '@wendellhu/redi';
Now:
import type { Dependency } from '@univerjs/core';
import { Inject, Injector } from '@univerjs/core';
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-07-26)
Bug Fixes
- conditional-formatting: close panel when switch subunit (#2828) (6e772bc)
- doc-resize causing formula error (#2857) (8d037a2)
- editor: paste and selection error (#2843) (e6869e4)
- formula: array formula clear old value (#2840) (efb5ecd)
- formula: feature calculation update (#2838) (f66e5a7)
- get SheetScrollManagerService from renderManagerSrv (#2833) (ce4e7c4)
- move selection (#2832) (b4205ff)
- ref selection (#2770) (e885f76)
- sheet: blur table name triggers slide (#2772) (c328662)
- sheets-drawing-ui: load float-dom from snapshot & support presist custom data with float dom drawing object (#2841) (ca38723)
- sheets-ui: formula editor can't exit (#2858) (eb3c0dd)
- sheet: type import (#2848) (ae0b012)
Features
- core: optimize url validator & popup on selection moving (#2845) (c6ab2a7)
- data-validation: code optimize for data-validation (#2815) (ab242a3)
- docs-thread-comment-ui: doc datasource (#2851) (b3ae99a)
- docs-ui: support docs zoom bar & context menu (#2830) (d840cb5)
- docs: support doc-hover-service (#2824) (28dbb78)
- formula: add some information and date function (#2798) (6b3413e)
- formula: add some math function (#2761) (344f4dd)
- formula: get dirty data (#2837) (b3ebd79)
🎉 Release v0.2.4
🎊 [email protected]
🚧 Important Note
This project is still in heavy development, and major API changes are expected. Your feedback is crucial! Please submit issues and suggestions to help us shape the future of Univer.
🚀 Getting Started
If you're eager to explore Univer, check out our getting started documentation.
Dive into the world of collaborative document, spreadsheet, and presentation editing powered by Univer!
🎉 Highlights
In this release, we are excited to introduce a new set of features and improvements to enhance your Univer experience. Here are the highlights:
- Univer Doc supports headers and footers, as well as image insertion.
docs-drawing-ui
Allows you to insert images in Univer Doc.
- Install the following packages:
pnpm add @univerjs/docs-drawing-ui
- Import the plugins:
import '@univerjs/docs-drawing-ui/lib/index.css';
import { UniverDocsDrawingUIPlugin } from '@univerjs/docs-drawing-ui';
- Add locale resources:
import { LocaleType, Tools } from '@univerjs/core'
+ import DocsDrawingUiEnUs from '@univerjs/docs-drawing-ui/locale/en-US';
const univer = new Univer({
theme: defaultTheme,
locale: LocaleType.EN_US,
locales: {
[LocaleType.EN_US]: Tools.deepMerge(
+ DocsDrawingUiEnUs
),
},
});
- Register the plugin:
univer.registerPlugin(UniverDocsDrawingUIPlugin);
- Added some date-related formulas #2729
- Enhanced the ability to configure protection range pop-up #2603
🐞 Bug Fixes
FRange.generateHTML
fix, copy-paste enhancement #2773
💔 Breaking Changes
- Adjustments made to the unit property data structure in
IParagraphStyle
withinIDocumentBody
of Univer Doc #2760
🎢 Special Thanks
Special thanks to the following contributors who have made this release possible:
📢 Join the Conversation
We welcome your input and insights as we embark on this exciting journey. Connect with us on:
📝 Changelog
Full changelog (2024-07-19)
Bug Fixes
- conditional-formatting: adjust the frequency of calculations (#2804) (1b65361)
- core: merge range util error (#2776) (7a41b9c)
- design: add class name as poperty of select list (#2788) (f78b538)
- doc: default line pitch (#2805) (ae466b2)
- fix invalid color str in paste (#2783) (d0ac904)
- formula: formula carries numfmt of ref cell (#2756) (30b3b24)
- formula: great than equal error (#2758) (65e471d)
- min cursor height and move cursor (#2789) (beb9146)
- permission: optimize formula bar permission & resize header permission (#2603) (de05ff8)
- permission: when user exists should not set again (#2799) (99a56dc)
- selection: selection error after insert col (#2786) (a02b719)
- sheet: copy&paste clip cell (#2773) (af845a2)
- sheet: range selector and editor (#2748) (15b1d8e)
- sheets-data-validation: data-validation perf issues (#2810) (3a4de22)
- sheets-drawing-ui: float-dom deps error (#2791) (0a6d4d1)
- sheets-hyper-link: re-render perf issue (#2812) (706aa04)
- sheets-ui: bugfix for data-validation/comments (#2734) (75bb1f6)
- ui: fix focus editor position with padding (#2819) (57dd020)
Features
- add method to get message portal container (#2775) (603d62e)
- docs-mention-ui: support docs-mention (#2785) (57232a5)
- docs-mention: add resource-controller (#2803) (37a1d58)
- docs: image in header and footer (#2747) (0fe6867)
- formula: add some date function (#2729) (26af2cc)
- permission: initial permission is modified to false for the set… (#2768) (c2f3056)
- sheet: init history permission point in sheet (#2790) (dc04d7a)
- uni: init uni mode (#2793) (8228c5a)