Skip to content

🎉 Release v0.2.7
Compare
Choose a tag to compare
@hexf00 hexf00 released this 10 Aug 04:23
· 323 commits to dev since this release
v0.2.7
d08f436

🎊 [email protected]

Univer Banner

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

  1. Install the following packages:
pnpm add @univerjs-pro/pivot-engine @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui
  1. 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'
  1. 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
    ),
  },
});
  1. 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.

  1. Install the following packages:
pnpm add @univerjs-pro/edit-history-viewer @univerjs-pro/edit-history-loader
  1. Import the plugins:
import '@univerjs-pro/edit-history-viewer/lib/index.css'

import { UniverEditHistoryLoaderPlugin } from '@univerjs-pro/edit-history-loader'
  1. 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
    ),
  },
});
  1. 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

  1. Install the following packages:
pnpm add @univerjs/thread-comment-ui @univerjs/sheets-thread-comment
  1. Import the plugins:
import '@univerjs/thread-comment-ui/lib/index.css'

import { UniverSheetsThreadCommentPlugin } from '@univerjs/sheets-thread-comment'
  1. 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
    ),
  },
});
  1. Register the plugin:
univer.registerPlugin(UniverSheetsThreadCommentPlugin);

Univer Doc supports comments

  1. Install the following packages:
pnpm add @univerjs/thread-comment-ui @univerjs/docs-thread-comment-ui
  1. Import the plugins:
import '@univerjs/thread-comment-ui/lib/index.css'

import { UniverDocsThreadCommentUIPlugin } from '@univerjs/docs-thread-comment-ui'
  1. 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
    ),
  },
});
  1. 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 and isodd #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) (c1a342d)
  • default setting in header and footer (#2977) (eeaf78f)
  • design: add missing css import file (#2991) (f007237)
  • disable image when select table (#2962) (770385b)
  • docs-thread-comment-ui: comment when cross table (#2939) (678816c)
  • docs-ui: doc list indent wrong after remove list & copy paste sheet-link (#3002) (94d436c)
  • docs: change list type error when cross table (#2963) (8416e8b)
  • docs: refresh image positions after resize (#2976) (a7a3c95)
  • export some apis of render engine (#2941) (6c1211c)
  • filter should not hidden col (#2980) (683d251)
  • fix create lists in table (#2947) (6ac854f)
  • fix custom formula service not handle other units (d4b3767)
  • fix slide errors (0145ea5)
  • fix sort menu hidden$ (4f61745)
  • fix type error (4cda2fb)
  • fix uni formula collab (#2951) (5b75469)
  • fix uni mode errors (#2959) (de57b8e)
  • fix zen editor id (c5de1a2)
  • formula: fix formula sheet name uppercase bug (#2908) (b4122b1)
  • formula: fix some bugs (#2920) (323e085)
  • highlight not work when select link (#2978) (6a97ced)
  • image initial render (#2921) (c165edc)
  • image: switch tab error (#2926) (2cee8d6)
  • insert col right to cursor (#2964) (912d666)
  • issue #1791 (#2918) (4cba768)
  • modify the judgment logic of rich text (#2957) (041f889)
  • paragraph: when switching from 2 lines to 1 line, the selection … (#2997) (21d09eb)
  • permission: permission validation performance problem (#2916) (60ae402)
  • selection is wrong when select table (#2953) (b15b46b)
  • sheets-data-validation: data validation validator empty ranges & comment active issue & sheet-hyper-link autofill (#3003) (3271885)
  • sheets-ui: set frozen to max column should limited & doc list-paragraph optimize (#2983) (64917c2)
  • slide editing scale (#2999) (8017323)
  • slide editor disappear when moving curor by keyboard (arrow key) (#2972) (448dcb1)
  • snapshot (#2940) (47ebfb7)
  • uni: scale uni frame (#2955) (ba7902f)
  • uni: uni formula service should run on server without formula (#2946) (2aa0d84)
  • uni: use uni formula controller to regiter commands (d2ba71e)

Features

Contributors

Hossein-Khan
Assets 2
Loading
1 Join discussion