@univerjs-pro/sheets-pivot

@univerjs/sheet-pivot

Introduction

A pivot table is a powerful data analysis tool used for quickly and dynamically summarizing and analyzing large volumes of data. It allows users to group, filter, sort, and aggregate raw data across different dimensions, revealing patterns and trends within the data. By dragging and dropping fields to define rows, columns, and values, users can create cross-tabulated tables for multi-level data summarization. Common functions include sum, count, average, maximum/minimum, and more, enabling users to derive valuable insights from complex data. Pivot tables are ideal for scenarios such as financial analysis, business monitoring, and sales data reporting.

Usage

Installation

# Using npm
npm install @univerjs/sheet-pivot-ui @univerjs/sheet-pivot

# Using pnpm
pnpm add @univerjs/sheet-pivot-ui @univerjs/sheet-pivot

Import

import { UniverSheetsPivotTablePlugin } from '@univerjs-pro/sheets-pivot';
import { UniverSheetsPivotTableUIPlugin } from '@univerjs-pro/sheets-pivot-ui';

univer.registerPlugin(UniverSheetsPivotTablePlugin);
univer.registerPlugin(UniverSheetsPivotTableUIPlugin);

Changelog

0.5.1 (2024-11-30)

Bug Fixes

• auto fill should delete dv rules (#4075) (b9439c5)
• clipboard deps (#4115) (57c595e)
• conditional-formatting: fix type (#4181) (9db1edf)
• conditional-formatting: the style that involves conditional formatting does not fall (#4195) (d7f5f72)
• cursor blink lags when pointer down at text range (#4180) (de4d70b)
• docs-ui: cursor valished at paragraph beginning (#4147) (ae027eb)
• docs-ui: double paste issue (#4168) (f0e8c92)
• dup list glyph type name (#4169) (6b68364)
• fix client may miss the INITIALIZE event (#4158) (f0234bb)
• formula: fix iferror (#4163) (1a9f83d)
• formula: fix networkdays.intl (#4152) (d1d4bbe)
• formula: update formula data model (#4159) (243acdb)
• optimization of create empty doc (#4149) (c88e709)
• ref selection change by arrow key (#4135) (444c065)
• selection should stop response after a popup shown (#4156) (a4b38af)
• sheet: parseValue handle number (#4049) (59b95fa)
• sheets-filter-ui: fix the react compatibility issue with sheets filter (#4189) (61e8ebf)
• sheet: sheet name normalize string (#4172) (d9b1149)
• ui: progress bar animation (#4136) (f578296)

Features

• i18n: add fr-FR locale (#3564) (9b7da8d)
• remove zen-zone sidebar (#4193) (0f651d6)
• render-engine: support repeat table header (#4139) (c26f9b0)
• sheets-drawing-ui: support sheet cell image (#4036) (244511d)

Bug Fixes

• bugs in cut-paste undo scenario (#4095) (afc72cf)
• cal page size in modern mode (#4128) (a58350b)
• doc text selection begin from list marker (#4132) (798e1fd)
• doc: bad image path when parsing clipboard HTML (#4119) (adfaf14)
• doc: failed to process image upload (#4120) (2547183)
• docs-ui: menu align when select table cells (#4127) (e1d7713)
• drawing: set drawing bounding in left/top to A1 cell (#4096) (e695309)
• formula: init trigger calculation controller on rendered (#4118) (9e7b9fb)
• formula: update formula string in other sheet (#4107) (3cf0e3b)
• selection before table (#4134) (744a203)
• set pointer caputure when pointer out (#4099) (e194a1e)
• sheet: cell related facade api (#4032) (545dc82)
• sheet: maximum call stack (#4088) (d6d2e3f)
• sheets-hyper-link-ui: link ref -range (#4131) (924ad5e)
• sheets-ui: gridlines permission (#4091) (9630498)

Features

• docs-link: support acrossing-paragraph add link (#4104) (cea9cb8)
• docs-mention-ui: support doc mention (#4093) (5b80481)
• docs: pictures support writing to the clipboard (#4086) (bf8329f)
• drawing: drawing popup support custom menu (#4113) (1ec6dbe)
• export types for facade api (#4126) (0d07c86)
• facade: add api for cell editing (#4124) (19808d0)
• facade: add component api (#4125) (e0025ab)
• facade: export syncExecuteCommand (#4102) (d882624)
• formula: supplement ARRAY_CONSTRAIN/FLATTEN formula (#3922) (20c81f3)
• formula: supplement EPOCHTODATE/TO_DATE/ISDATE formula (#3979) (0656167)
• formula: supplement IMCOTH/IMLOG/IMTANH formula (#3909) (77e7c67)
• formula: supplement ISBETWEEN/AVERAGE.WEIGHTED/MARGINOFERROR formula (#3998) (0dc0027)
• formula: supplement ISEMAIL/ISURL/ENCODEURL formula (#3990) (224e88c)
• formula: supplement LINEST/LOGEST/TREND formula (#3965) (ff20170)
• formula: supplement ROUNDBANK formula (#4013) (7c3807f)
• render-engine: split table row (#4054) (379221e)
• sheets-data-validation: optimize data validation memory usage (#4129) (814bc84)
• sheets-ui: add hover facade api (#4092) (a23f2fb)