🎊 Univer@v0.2.11

🚧 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

1. Install the following packages:

pnpm add @univerjs/sheets-crosshair-highlight

2. Import the plugins:

import '@univerjs/sheets-crosshair-highlight/lib/index.css';
 
import { UniverSheetsCrosshairHighlightPlugin } from '@univerjs/sheets-crosshair-highlight';

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

4. 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:

• :octocat: 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) (e1f4f46)
• paste should clear style when paste to editor in sheet (#3215) (781c72e)
• retry interceptor params (#3220) (2e2044a)
• sheet dispose cause scroll update scene size failed. (#3205) (6e1a234)
• sheet text (#3189) (5fd5350)
• sheet: insert wrong columns when shift right (#3193) (ebe1dda)
• sheet: make dirty when only local false (#3247) (5b31804)
• sheets-data-validation: data validation auto height (#3175) (9e53c79)
• sheets-data-validation: date picker can't input by type when errorStyle is STOP (#3237) (99cfb4b)
• sheets-drawing: drawing snapshot error (#3230) (f5f52bf)
• sheets-filter: some filter bugs (#3199) (ec69831)
• sheets-sort: wrong order colIndex (#3196) (33fdbde)
• sheets-ui: popup can't show (#3252) (f1a45fd)
• sheets: do not copy cell bg color to rich text bg (#3207) (e293aca)
• sheets: no style in blank cell (#3231) (e9360c4)
• sheets: ref-range watch-range on insert-move-down & insert-move-right (#3218) (ca0f47a)
• underline not work when align bottom & moving clipboard controller from steady to render (#3139) (10484d8)

Features

• export facade api (1d4b185)
• facade: add facade api for sheets-thread-comment & float-dom & optmize data-validation facade api (#3200) (5aa3342)
• facade: add Facade Worksheet row column API (#3163) (7d903d7)
• facade: add redo undo facade hooks (#3217) (a2be933)
• formula: add some engineering functions (#3070) (dbe1dab)
• formula: add some financial functions (#3137) (62bb41b)
• pivot: fix scroll height & add hooks to format paint (#3224) (84e8c89)
• sheet: dialog close all (#3240) (f06192d)
• sheet: performan the expand range (#3187) (4a72204)