排序

📊 Univer Sheet

import { LocaleType, Univer, UniverInstanceType } from '@univerjs/core'

import { UniverFormulaEnginePlugin } from '@univerjs/engine-formula'
import { UniverRenderEnginePlugin } from '@univerjs/engine-render'

import { UniverUIPlugin } from '@univerjs/ui'
import { defaultTheme } from '@univerjs/design'

import { UniverDocsPlugin } from '@univerjs/docs'
import { UniverDocsUIPlugin } from '@univerjs/docs-ui'

import { UniverSheetsPlugin } from '@univerjs/sheets'
import { UniverSheetsUIPlugin } from '@univerjs/sheets-ui'
import { UniverSheetsNumfmtPlugin } from '@univerjs/sheets-numfmt'
import { UniverSheetsFormulaPlugin } from '@univerjs/sheets-formula'

import { UniverSheetsSortPlugin } from '@univerjs/sheets-sort'
import { UniverSheetsSortUIPlugin } from '@univerjs/sheets-sort-ui'

import { enUS } from './locales'

import './style.css'

const univer = new Univer({
  theme: defaultTheme,
  locale: LocaleType.EN_US,
  locales: {
    [LocaleType.EN_US]: enUS,
  },
})

univer.registerPlugin(UniverRenderEnginePlugin)
univer.registerPlugin(UniverFormulaEnginePlugin)

univer.registerPlugin(UniverUIPlugin, {
  container: 'app',
  disableAutoFocus: true,
})

univer.registerPlugin(UniverDocsPlugin)
univer.registerPlugin(UniverDocsUIPlugin)

univer.registerPlugin(UniverSheetsPlugin)
univer.registerPlugin(UniverSheetsUIPlugin)
univer.registerPlugin(UniverSheetsNumfmtPlugin)
univer.registerPlugin(UniverSheetsFormulaPlugin)

univer.registerPlugin(UniverSheetsSortPlugin)
univer.registerPlugin(UniverSheetsSortUIPlugin)

univer.createUnit(UniverInstanceType.UNIVER_SHEET, {
  id: 'OCp-S1',
  sheetOrder: [
    'GZhB0cQMRadjWPwzzQOk9',
  ],
  name: '',
  appVersion: '0.2.7',
  locale: 'zhCN',
  styles: {},
  sheets: {
    GZhB0cQMRadjWPwzzQOk9: {
      id: 'GZhB0cQMRadjWPwzzQOk9',
      name: 'Sheet1',
      tabColor: '',
      hidden: 0,
      rowCount: 1000,
      columnCount: 20,
      zoomRatio: 1,
      freeze: {
        xSplit: 0,
        ySplit: 0,
        startRow: -1,
        startColumn: -1,
      },
      scrollTop: 0,
      scrollLeft: 0,
      defaultColumnWidth: 88,
      defaultRowHeight: 24,
      mergeData: [],
      cellData: {
        0: {
          0: {
            v: 67,
            t: 2,
          },
        },
        1: {
          0: {
            v: 29,
            t: 2,
          },
        },
        2: {
          0: {
            v: 2,
            t: 2,
          },
        },
        3: {
          0: {
            v: 88,
            t: 2,
          },
        },
        4: {
          0: {
            v: 212,
            t: 2,
          },
        },
        5: {
          0: {
            v: 99,
            t: 2,
          },
        },
      },
      rowData: {
        0: {
          hd: 0,
          h: 24,
          ah: 24,
        },
        1: {
          hd: 0,
          h: 24,
          ah: 24,
        },
        2: {
          hd: 0,
          h: 24,
          ah: 24,
        },
        3: {
          hd: 0,
          h: 24,
          ah: 24,
        },
        4: {
          hd: 0,
          h: 24,
          ah: 24,
        },
        5: {
          hd: 0,
          h: 24,
        },
      },
      columnData: {
        0: {
          w: 88,
          hd: 0,
        },
      },
      showGridlines: 1,
      rowHeader: {
        width: 46,
        hidden: 0,
      },
      columnHeader: {
        height: 20,
        hidden: 0,
      },
      selections: [
        'A1',
      ],
      rightToLeft: 0,
    },
  },
  resources: [],
})

排序插件提供了对指定区域内单元格的排序功能。

安装

pnpm add @univerjs/sheets-sort @univerjs/sheets-sort-ui

引入

import '@univerjs/sheets-sort-ui/lib/index.css';
 
import { UniverSheetsSortPlugin } from '@univerjs/sheets-sort';
import { UniverSheetsSortUIPlugin } from '@univerjs/sheets-sort-ui';

国际化

import { LocaleType, Tools } from '@univerjs/core';
import SheetsSortUIZhCN from '@univerjs/sheets-sort-ui/locale/zh-CN';
 
const univer = new Univer({
  theme: defaultTheme,
  locale: LocaleType.ZH_CN,
  locales: {
    [LocaleType.ZH_CN]: Tools.deepMerge(
      SheetsSortUIZhCN
    ),
  },
});

注册

univer.registerPlugin(UniverSheetsSortPlugin);
univer.registerPlugin(UniverSheetsSortUIPlugin);

筛选数据验证