Releases · dream-num/univer

30 Oct 07:42

hexf00

v0.4.2

31e58f0

🎉 Release v0.4.2 Latest

Latest

🎊 [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 auto column width #3798
Added @univerjs/watermark plugin, Learn more #3751

pnpm add @univerjs/watermark

import plugin

import '@univerjs/watermark/lib/index.css'

import { UniverWatermarkPlugin } from '@univerjs/watermark';

add locale

import { LocaleType, Tools } from '@univerjs/core'
import { defaultTheme } from "@univerjs/design";
+ import UniverWatermarkEnUS from '@univerjs/watermark/locale/en-US'


const univer = new Univer({
  theme: defaultTheme,
  locale: LocaleType.EN_US,
  locales: {
    [LocaleType.EN_US]: Tools.deepMerge(
+      UniverWatermarkEnUS,
    ),
  },
});

univer.registerPlugin(UniverWatermarkPlugin)

Added new Facade API for setting default custom properties for rows and columns: FWorksheet adds setColumnCustom, setRowCustom methods #3816
Added new Facade API for setting worksheet default styles: FWorksheet adds setDefaultStyle, setColumnDefaultStyle, setRowDefaultStyle methods, Learn more #3816
Added new Facade API to control gridlines visibility: FWorksheet adds setHiddenGridlines method #3805
Added @univerjs/network plugin, support request behavior override when registering plugins #3870
Added 20+ text formula functions and 2 math formula functions #3546
Added 10+ statistical formula functions #3749
Formula function count has reached 408, aiming to exceed 500

🐞 Bug Fixes

Fixed cell string type behavior #3872
Fixed SUMIF formula calculation with different range dimensions #3853 #3807
Added scrolling support for sheet switching menu #3821
Fixed 'local-fonts' console error #3811 #3841
Fixed sheet editor focus issues #3809
Fixed formula progress bar loading issue #3790

📝 Univer Docs

Support for modern mode #3706
Improved collaboration cursor #3846 #3863
Various other improvements

🌐 Univer Server

Enhanced collaboration permissions
Improved installation script experience

📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

GitHub Discussions
👾 Discord

📝 Changelog

Full changelog (2024-10-29)

Bug Fixes

add comments for set frozen cmd params (#3743) (ebcf3e0)
cell: fix cell string type (#3872) (bc65876)
demo: types (#3794) (0d313f2)
docs-link: error display url link when add link (#3822) (f6cd524)
docs-thread-comment-ui: doc comment ot (#3832) (1fd499a)
docs: close header and footer when switch doc mode (#3869) (888c15c)
docs: line break in collaboration (#3863) (e95449e)
docs: merge two paragraphs (#3871) (cf12b98)
docs: the apply result should be consistent (#3806) (d0054f3)
docs: transform in bullet list (#3830) (7451d2d)
docs: undefined error when call permission query (#3841) (d642327)
doc: transform with REPLACE type (#3827) (42e26e1)
drawing: fix inner dom position (#3864) (c37f24c)
drawing: fix remove drawing elements the control when not remove… (#3873) (448d32c)
fix type-check (#3796) (cc822fa)
formula: dependency for vlookup (#3817) (3a77cb2)
formula: fix CELL_INVERTED_INDEX_CACHE range set (#3807) (1092fcb)
formula: fix lookup related bugs (#3847) (ff9cf49)
formula: fix progress bar not loaded (#3790) (065dadc)
formula: fix sumif formula range and sumRange different dimensions (#3853) (faf7936)
getScale is not correct after ctx.rotate (#3792) (b0c5f13)
sheets-data-validation: can't copy checkbox with right checked status (#3818) (6da0f1e)
sheets-drawing-ui: float dom scroll not update on drag range (#3840) (575a604)
sheets-hyper-link-ui: sheet link menu display wrong in cell editing (#3825) (dbcdcba)
sheets-hyper-link: link ref range behavior error (#3862) (3126112)
sheets-ui: can't quit editor after enter '=' (#3861) (5343f2c)
sheets-ui: lag when editing (#3837) (251186e)
sheets-ui: should disable sheet menus on cell editing (#3809) (e758013)
thread-comment: comment datasource (#3787) (8978364)
thread-comment: thread-comment build types (#3802) (417fdee)
trigger selectionMoveEnd$ when using keyboard to change selections. (#3731) (7b67be2)
ui: improve layout and overflow handling in sheet bar menu (#3823) ([acb4a45](acb4a...

Assets 2

1 Join discussion

18 Oct 07:30

hexf00

v0.4.1

dbd1b8c

🔥 Release v0.4.1

📝 Changelog

Full changelog (2024-10-18)

Bug Fixes

sheets-ui: can't edit after dispose (#3788) (77b39cd)

Performance Improvements

formula: calculation speed up (#3738) (cea4571)

Assets 2

17 Oct 12:55

hexf00

v0.4.0

fb27675

🎉 Release v0.4.0

🎊 [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 formulaBar configuration option to control the display of the formula bar #3632
Added onCellDataChange and onBeforeCellDataChange methods to the Facade API FWorksheet for monitoring cell data changes #3626
Added Persian language fa_IR support #3558
Added REGEXEXTRACT, REGEXMATCH, and REGEXREPLACE formula functions #3633
The number of formula functions has now reached 372, with a goal of exceeding 500

🐞 Bug Fixes

Fixed merged cell rendering issue #3671
Fixed editor cursor position offset #3668
Fixed custom context menu items not displaying #3688
Fixed column header rendering issue after reinitializing following disposeUnit #3598
Fixed SetStyleCommand only affecting the current active sheet #3586
Fixed SetRangeValuesCommand changing user focus #3697
Fixed nested IF formula calculation error #3774
Fixed navigation bar flickering #3745

💔 Breaking Changes

Plugin developers should note that the following changes have been made:
- The OnLifecycle decorator has been removed. Please complete the corresponding instance initialization logic in the plugin's lifecycle methods instead #3672

example:

///plugin/controllers/custom-menu.controller.ts
-@OnLifecycle(LifecycleStages.Ready, CustomMenuController)
export class CustomMenuController extends Disposable {
...
}
...

//plugin/plugin.ts
export class UniverSheetsCustomMenuPlugin extends Plugin {
...
+    onReady(): void {
+       this._injector.get(CustomMenuController);
+   }
...
}

The injector parameter in plugin lifecycle methods has been removed. Please use the class property _injector directly #3672
Plugin refactoring #3527
- @univerjs/sheets-formula has been split into two plugins: @univerjs/sheets-formula and @univerjs/sheets-formula-ui. Please import @univerjs/sheets-formula-ui into your frontend code as well.

install:

-pnpm add @univerjs/sheets-formula
+pnpm add @univerjs/sheets-formula @univerjs/sheets-formula-ui

import:

-import '@univerjs/sheets-formula/lib/index.css'
+import '@univerjs/sheets-formula-ui/lib/index.css'

-import SheetsFormulaEnUS from '@univerjs/sheets-formula/locale/en-US';
+import SheetsFormulaUiEnUS from '@univerjs/sheets-formula-ui/locale/en-US';

import { UniverSheetsFormulaPlugin } from '@univerjs/sheets-formula'
+import { UniverSheetsFormulaUIPlugin } from '@univerjs/sheets-formula-ui'

univer.registerPlugin(UniverSheetsFormulaPlugin)
+univer.registerPlugin(UniverSheetsFormulaUIPlugin)

@univerjs/sheets-data-validation has been split into two plugins: @univerjs/sheets-data-validation and @univerjs/sheets-data-validation-ui. Please import @univerjs/sheets-data-validation-ui into your frontend code as well. The configuration for @univerjs/sheets-data-validation should also be moved to @univerjs/sheets-data-validation-ui.

install:

-pnpm add @univerjs/data-validation @univerjs/sheets-data-validation
+pnpm add @univerjs/data-validation @univerjs/sheets-data-validation @univerjs/sheets-data-validation-ui

import:

-import '@univerjs/sheets-data-validation/lib/index.css';
+import '@univerjs/sheets-data-validation-ui/lib/index.css';

-import SheetsDataValidationEnUS from '@univerjs/sheets-data-validation/locale/en-US';
+import SheetsDataValidationUiEnUS from '@univerjs/sheets-data-validation-ui/locale/en-US';

import { UniverDataValidationPlugin } from '@univerjs/data-validation';
import { UniverSheetsDataValidationPlugin } from '@univerjs/sheets-data-validation'
+import { UniverSheetsDataValidationUIPlugin } from '@univerjs/sheets-data-validation-ui'

univer.registerPlugin(UniverDataValidationPlugin)
univer.registerPlugin(UniverSheetsDataValidationPlugin)
+univer.registerPlugin(UniverSheetsDataValidationUIPlugin)

📝 Univer Docs

🔧 Improvements

Editor refactoring #3551

🎢 Special Thanks

Special thanks to the following community members who have made outstanding contributions to this release:

📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

GitHub Discussions
👾 Discord

📝 Changelog

Full changelog (2024-10-17)

Bug Fixes

docs-ui: don't refresh-selection after set list (#3780) (924dee7)
docs-ui: formula-editor should not render paragraph style (#3783) (b7301af)
docs: header footer setting not focus (#3698) (2db351b)
docs: no need to cache font style when has no text run (#3779) (8a48479)
engine-render: check box render (#3776) (83e0897)
fix permission rangeSelector & insert menu (#3757) (1f43484)
font render bounds (#3754) (4ecd764)
formula: fix some bug (#3774) (4c4efe4)
sheets-ui: can't save first edit cell (#3781) (d29da2f)
cell style in collaboration (#3748) (e138b95)
condition-formatting: date calculation error (#3733) (30da399)
conditional-formatting: reduce icon map size (#3769) (0f19fc0)
docs-ui: doc list render error after operation like break-line (#3766) (8c95a53)
flickering when init page (#3762) (fe3ff31)
formula: fix ArrayValueObject compare cache bug (#3764) (424bb02)
formula: fix datedif bug (#3747) (f9f4973)
refresh selection when collapsed (#3761) (a92a389)
sheet: fix can not delete when there are exclusive range (#3729) (d6db560)
sheets-data-validation: data validation validator status render error (#3752) (555e9d5)
snapshot area (#3715) (5957a04)
ui: fix missing context menu items (#3758) (421d009)
ui: ribbon others tab flickering resolved (#3745) (bc8bfb6)
docs: can not paste content when have both text ra...

Contributors

rahulnayanegali and ParsaArvanehPA

Assets 2

1 Join discussion

29 Sep 11:05

hexf00

v0.3.0

43a701f

🎉 Release v0.3.0

🎊 [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 hiding the edit button in the conditional formatting options dropdown menu using the showEditOnDropdown parameter #3574
Copy and paste now carry the custom field #3487
Added Facade API for freezing rows and columns #3561
Added 29 statistical and 19 compatibility formula functions #3463
The number of formula functions has now reached 369, with a goal of exceeding 500

🐞 Bug Fixes

Fixed issues with some document exports failing
Fixed merged cell border style anomalies #3475 #3506
Fixed rendering timing issues for merged cells #3516
Fixed BooleanNumber enum type error #3571
Fixed scroll bar position offset when dragging with the mouse #3556
Fixed display of extra dividers when hiding context menu items #3552
Fixed data bar style offset #3535
Removed the need to import lodash in UMD mode #3605

💔 Breaking Changes

Adjusted the configuration method for collaboration, import, and export plugins. The old usage will be removed in the future, and the configuration will be unified when registering plugins.

Before:

configService.setConfig(AUTHZ_URL_KEY, `${httpProtocol}://${host}/universer-api/authz`)
configService.setConfig(SNAPSHOT_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/snapshot`);
configService.setConfig(COLLAB_SUBMIT_CHANGESET_URL_KEY, `${httpProtocol}://${host}/universer-api/comb`);
configService.setConfig(COLLAB_WEB_SOCKET_URL_KEY, `${wsProtocol}://${host}/universer-api/comb/connect`);
configService.setConfig(SEND_CHANGESET_TIMEOUT_KEY, 200);

configService.setConfig(EXCHANGE_UPLOAD_FILE_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/stream/file/upload`);
configService.setConfig(EXCHANGE_IMPORT_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/exchange/{type}/import`);
configService.setConfig(EXCHANGE_EXPORT_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/exchange/{type}/export`);
configService.setConfig(EXCHANGE_GET_TASK_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/exchange/task/{taskID}`);
configService.setConfig(EXCHANGE_SIGN_URL_SERVER_URL_KEY, `${httpProtocol}://${host}/universer-api/file/{fileID}/sign-url`);

After:

univer.registerPlugin(UniverCollaborationClientPlugin, {
  authzUrl: `${httpProtocol}://${host}/universer-api/authz`,
  snapshotServerUrl: `${httpProtocol}://${host}/universer-api/snapshot`,
  collabSubmitChangesetUrl: `${httpProtocol}://${host}/universer-api/comb`,
  collabWebSocketUrl: `${wsProtocol}://${host}/universer-api/comb/connect`,
  sendChangesetTimeout: 200,
});

univer.registerPlugin(UniverExchangeClientPlugin, {
  uploadFileServerUrl: `${httpProtocol}://${host}/universer-api/stream/file/upload`,
  importServerUrl: `${httpProtocol}://${host}/universer-api/exchange/{type}/import`,
  exportServerUrl: `${httpProtocol}://${host}/universer-api/exchange/{type}/export`,
  getTaskServerUrl: `${httpProtocol}://${host}/universer-api/exchange/task/{taskID}`,
  signUrlServerUrl: `${httpProtocol}://${host}/universer-api/file/{fileID}/sign-url`,
});

Adjusted the licensing rules for commercial features. Commercial version users need to register their license key as follows when using commercial features:

Install

pnpm add @univerjs-pro/license

import { UniverLicensePlugin } from '@univerjs-pro/license';

univer.registerPlugin(UniverLicensePlugin, {
    license: 'your-license-txt'
});

Plugin registration order has been adjusted. If you encounter an error, please check and ensure
- UniverDocsUIPlugin must be registered after UniverUIPlugin
- UniverRenderEnginePlugin should be registered before most plugins

📝 Univer Docs

🎉 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 rendering more unicode characters #3512
Improved stability

💔 Breaking Changes

Plugin developers should note that the editor has been refactored. The editor service-related content has been moved from @univerjs/ui to @univerjs/docs-ui #3486

Before:

import { IRangeSelectorService, RangeSelector, TextEditor, IEditorService } from '@univerjs/ui';

After:

import { IRangeSelectorService, RangeSelector, TextEditor, IEditorService } from '@univerjs/docs-ui';

🌐 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:

Optimized server-side installation experience

📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

GitHub Discussions
👾 Discord

📝 Changelog

Full changelog (2024-09-28)

Bug Fixes

bg border return before getCell (#3623) (2e7b201)
data-validation: remove useless interceptor mutations (#3630) (fd48e15)
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 ([#34...

Assets 2

1 Join discussion

21 Sep 11:58

hexf00

v0.2.15

6dd2162

🎉 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 and LEFTB #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:

GitHub Discussions
👾 Discord

📝 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 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)

Assets 2

1 Join discussion

13 Sep 13:09

hexf00

v0.2.14

622ea81

🎉 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 to DocSelectionManagerService.
- Some of the APIs in the docs package were moved to the docs-ui package.
- TextSelectionRenderManagerService is migrated to the docs-ui package, renamed to DocSelectionRenderService, and the IRenderModule interface is implemented.

📢 Join the Conversation

We welcome your input and insights as we embark on this exciting journey. Connect with us on:

GitHub Discussions
👾 Discord

📝 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)

Assets 2

1 Join discussion

07 Sep 12:03

hexf00

v0.2.12

435ce34

🎉 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 to false when adding them to a worksheet. #3342
Added 3 new formula functions: ISFORMULA, N, and NA. #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

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

- 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 and group 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

 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:

GitHub Discussions
👾 Discord

📝 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 ([...

Assets 2

1 Join discussion

31 Aug 03:46

hexf00

v0.2.11

9380fa2

🎉 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 
    ),
  },
});

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:

GitHub Discussions
👾 Discord

📝 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...

Assets 2

1 Join discussion

23 Aug 11:56

hexf00

v0.2.9

820e79c

🎉 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 the FWorkbook.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:

GitHub Discussions
👾 Discord

📝 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...

Assets 2

2 Join discussion

16 Aug 09:06

hexf00

v0.2.8

7d0b87e

🎉 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,
    ),
  },
});

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:

GitHub Discussions
👾 Discord

📝 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 ([#...

Assets 2

1 Join discussion

Releases: dream-num/univer

🎉 Release v0.4.2

🎊 [email protected]

🚧 Important Note

🚀 Getting Started

📊 Univer Sheets

🎉 Highlights

🐞 Bug Fixes

📝 Univer Docs

🌐 Univer Server

📢 Join the Conversation

📝 Changelog

Bug Fixes

🔥 Release v0.4.1

📝 Changelog

Bug Fixes

Performance Improvements

🎉 Release v0.4.0

🎊 [email protected]

🚧 Important Note

🚀 Getting Started

📊 Univer Sheets

🎉 Highlights

🐞 Bug Fixes

💔 Breaking Changes

📝 Univer Docs

🔧 Improvements

🎢 Special Thanks

📢 Join the Conversation

📝 Changelog

Bug Fixes

Contributors

🎉 Release v0.3.0

🎊 [email protected]

🚧 Important Note

🚀 Getting Started

📊 Univer Sheets

🎉 Highlights

🐞 Bug Fixes

💔 Breaking Changes

📝 Univer Docs

🎉 Highlights

💔 Breaking Changes

🌐 Univer Server

🎉 Highlights

📢 Join the Conversation

📝 Changelog

Bug Fixes

🎉 Release v0.2.15

🎊 [email protected]

🚧 Important Note

🚀 Getting Started

📊 Univer Sheets

🎉 Highlights

🐞 Bug Fixes

📝 Univer Docs

🌐 Univer Server

📢 Join the Conversation

📝 Changelog

Bug Fixes

Features

Performance Improvements

🎉 Release v0.2.14

🎊 [email protected]

🚧 Important Note

🚀 Getting Started

📊 Univer Sheets

🎉 Highlights

🐞 Bug Fixes

💔 Breaking Changes

📝 Univer Docs

💔 Breaking Changes

📢 Join the Conversation

📝 Changelog

Bug Fixes

Features

🎉 Release v0.2.12

🎊 [email protected]

🚧 Important Note

🚀 Getting Started