🎊 Univer@v0.2.8

🚧 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

1. Install the following packages:

pnpm add @univerjs-pro/exchange-client @univerjs-pro/docs-exchange-client

2. 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'

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

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

• :octocat: 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 (#3086) (3da4e67)

Features

• add unit param for slide cmd (#3038) (1d1d59c)
• dialog: add property to control whether click mask to close to … (#3020) (8820862)
• facade: add sheet-data-validation facade api (#3050) (9ce3f8d)
• formula: add some engineering function (#2893) (9386c6b)
• formula: add some financial function (#2868) (2e475b3)
• sheet: matrix test (#3027) (8f15ea4)
• sheets-data-validation: support dropdown filter & fix paste error on data-validation cell (#3057) (e2e7d2a)
• slides: add text editing and shapes transform operations (#3015) (3284b38)
• ui: add use-virtual-list hooks (#3084) (a17d436)
• ui: support modifying the toolbar items through setMenuItem (#3083) (ff51551)
• uni-formula: support slide (#3014) (b6cc556)