🎊 Univer@v0.4.2

🚧 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

1. register plugin

pnpm add @univerjs/watermark

2. import plugin

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

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

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

4. register plugin

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:

• :octocat: 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)
• unitId for canvas (#3804) (7107be6)

Features

• add network plugin (#3782) (3e3e795)
• auto col (#3798) (c66cff0)
• design: component style optimize (#3860) (1ab5eff)
• doc: add more apply test case (#3865) (e7b2f78)
• doc: handle custom range transform (#3836) (89d6441)
• docs: set inline style at cursor (#3846) (caed6de)
• docs: support modern mode (#3706) (bea0e78)
• floatdom: add some hookes (#3854) (3747cd4)
• formula: add some text formulas (#3546) (4094288)
• formula: supplement sheet and sheets formula (#3859) (5fcd97a)
• formula: support database-related formulas (#3749) (3b8af5a)
• func addFloatDomToPosition may not execute command (#3855) (e99aec1)
• network: network plugin support overrides (#3870) (cbabe12)
• permission: change permission point logic (#3826) (7e49171)
• sheet: add custom for row and column (#3693) (4e31b24)
• sheets-data-validation: add data validation any-validator and allowBlank options (#3845) (b415476)
• sheets: toggle gridlines (#3805) (c3a7ddf)
• sheet: styles on rows and columns (#3816) (8a27b31)
• thread-comment: didn't show tips on merge-cell comment (#3819) (65cb1c5)
• thread-comment: sync comment after rendered (#3810) (0fec7a9)
• watermark (#3751) (9630e31)

Performance Improvements

• sheets-drawing-ui: float dom scroll performance optimize (#3838) (b4b8810)