# spreadjs-practice-samples

**Repository Path**: GrapeCity/spreadjs-practice-samples

## Basic Information

- **Project Name**: spreadjs-practice-samples
- **Description**: SpreadJS-Practice-Samples
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-09-22
- **Last Updated**: 2026-09-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SpreadJS 实战代码库

SpreadJS 实战示例集合，按场景分类，每个示例是一个可独立运行的小工程。下面是完整索引。

## 相关仓库

| 仓库 | 内容 |
| --- | --- |
| [spreadjs-docs](https://github.com/GrapeCityXA/spreadjs-docs) | 产品文档：使用指南、功能说明、公式函数参考，按版本分目录 |
| [spreadjs-api-reference](https://github.com/GrapeCityXA/spreadjs-api-reference) | API 参考：TypeDoc 生成的完整符号文档，按版本分目录 |
| [spreadjs-practice-samples](https://github.com/GrapeCityXA/spreadjs-practice-samples) | 实战示例：按场景分类的可运行示例工程（本仓库） |

## 官方资源

| 资源 | 地址 |
| --- | --- |
| 官网 | https://www.grapecity.com.cn/developer/spreadjs |
| 在线文档 | https://demo.grapecity.com.cn/spreadjs/help/docs/started-guide |
| API 参考（在线） | https://demo.grapecity.com.cn/spreadjs/help/api/classes/GC.Spread.Sheets.Worksheet |
| 在线示例 | https://demo.grapecity.com.cn/spreadjs/SpreadJSTutorial/#/samples |

## 索引 (Index)

### 导入导出 (import-export)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| mutiple-excel-file-download | 多个 Excel 文件打包下载 | [./samples/import-export/mutiple-excel-file-download/](./samples/import-export/mutiple-excel-file-download/) |
| multiple-file-into-one-workbook | 多文件导入同一个工作簿 | [./samples/import-export/multiple-file-into-one-workbook/](./samples/import-export/multiple-file-into-one-workbook/) |
| export-file-before-filter | 导出筛选之前的页面 | [./samples/import-export/export-file-before-filter/](./samples/import-export/export-file-before-filter/) |
| csv-import | 导入 CSV 文件 | [./samples/import-export/csv-import/](./samples/import-export/csv-import/) |
| change-export-options | 修改导出和打印的默认选项 | [./samples/import-export/change-export-options/](./samples/import-export/change-export-options/) |
| attachment-upload-download | 上传、导出附件 | [./samples/import-export/attachment-upload-download/](./samples/import-export/attachment-upload-download/) |
| import-excel-to-append | 导入文件追加 | [./samples/import-export/import-excel-to-append/](./samples/import-export/import-excel-to-append/) |
| use-echarts-and-export-as-pdf | 使用Echarts并导出PDF | [./samples/import-export/use-echarts-and-export-as-pdf/](./samples/import-export/use-echarts-and-export-as-pdf/) |
| convert-chart-to-image | 图表转图片 | [./samples/import-export/convert-chart-to-image/](./samples/import-export/convert-chart-to-image/) |
| copy-between-different-workbook | 跨工作簿数据复制 | [./samples/import-export/copy-between-different-workbook/](./samples/import-export/copy-between-different-workbook/) |
| export-as-excel-and-keep-checkbox-style | CheckBox导出Excel显示复选框 | [./samples/import-export/export-as-excel-and-keep-checkbox-style/](./samples/import-export/export-as-excel-and-keep-checkbox-style/) |
| big-file-async-load | 大文件量下的异步加载 | [./samples/import-export/big-file-async-load/](./samples/import-export/big-file-async-load/) |
| insert-image-to-cell | 单元格插入图片 | [./samples/import-export/insert-image-to-cell/](./samples/import-export/insert-image-to-cell/) |
| import-and-export-ssjson | 导入，导出ssjson | [./samples/import-export/import-and-export-ssjson/](./samples/import-export/import-and-export-ssjson/) |
| take-shot-of-selected-range | 获取选择区域截图 | [./samples/import-export/take-shot-of-selected-range/](./samples/import-export/take-shot-of-selected-range/) |
| import-three-type-files-from-server | 从服务端导入三种格式的文件 | [./samples/import-export/import-three-type-files-from-server/](./samples/import-export/import-three-type-files-from-server/) |
| show-prgress-bar-when-importing | 导入Excel时显示进度条 | [./samples/import-export/show-prgress-bar-when-importing/](./samples/import-export/show-prgress-bar-when-importing/) |
| multi-reportsheet-combine-and-export | 多报表合并导出Excel | [./samples/import-export/multi-reportsheet-combine-and-export/](./samples/import-export/multi-reportsheet-combine-and-export/) |
| convert-dropdowns-to-excel-compatible-type | 转换多种下拉框 使其兼容Excel | [./samples/import-export/convert-dropdowns-to-excel-compatible-type/](./samples/import-export/convert-dropdowns-to-excel-compatible-type/) |
| import-wps-support-incell-image | 导入时支持WPS的单元格内图片 | [./samples/import-export/import-wps-support-incell-image/](./samples/import-export/import-wps-support-incell-image/) |
| image-lost-after-pdf-exported | 导出PDF后图片丢失问题 | [./samples/import-export/image-lost-after-pdf-exported/](./samples/import-export/image-lost-after-pdf-exported/) |

### 数据绑定 (data-binding)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| data-binding-basic-demo | 数据绑定基础示例 | [./samples/data-binding/data-binding-basic-demo/](./samples/data-binding/data-binding-basic-demo/) |
| dynamic-header-binding-data | 动态添加表头 | [./samples/data-binding/dynamic-header-binding-data/](./samples/data-binding/dynamic-header-binding-data/) |
| dynamic-generate-column | 动态生成列 | [./samples/data-binding/dynamic-generate-column/](./samples/data-binding/dynamic-generate-column/) |
| multiple-table-inline | 同一行多个Table绑定 | [./samples/data-binding/multiple-table-inline/](./samples/data-binding/multiple-table-inline/) |
| change-datasource-append-data | 更换数据源、追加数据 | [./samples/data-binding/change-datasource-append-data/](./samples/data-binding/change-datasource-append-data/) |
| binding-with-style | 同时绑定样式 | [./samples/data-binding/binding-with-style/](./samples/data-binding/binding-with-style/) |
| table-row-expand-with-style | 表格行扩展并复制样式 | [./samples/data-binding/table-row-expand-with-style/](./samples/data-binding/table-row-expand-with-style/) |
| dynamic-add-column | 动态增加列 | [./samples/data-binding/dynamic-add-column/](./samples/data-binding/dynamic-add-column/) |
| dynamic-update-column-data | 动态更新某列数据 | [./samples/data-binding/dynamic-update-column-data/](./samples/data-binding/dynamic-update-column-data/) |
| update-binding-path | 修改绑定路径 | [./samples/data-binding/update-binding-path/](./samples/data-binding/update-binding-path/) |
| merge-column-header-databinding | 包含合并列头的数据绑定 | [./samples/data-binding/merge-column-header-databinding/](./samples/data-binding/merge-column-header-databinding/) |
| binding-merged-cell | 绑定合并单元格 | [./samples/data-binding/binding-merged-cell/](./samples/data-binding/binding-merged-cell/) |
| different-sheet-different-binding-path-list | 多sheet页设置不同的数据绑定列表 | [./samples/data-binding/different-sheet-different-binding-path-list/](./samples/data-binding/different-sheet-different-binding-path-list/) |
| big-amount-data-load | 大数据加载 | [./samples/data-binding/big-amount-data-load/](./samples/data-binding/big-amount-data-load/) |
| show-detail-info-by-clicking-cell | 嵌套表单明细展示 | [./samples/data-binding/show-detail-info-by-clicking-cell/](./samples/data-binding/show-detail-info-by-clicking-cell/) |
| cell-binding-object | 单元格绑定对象 | [./samples/data-binding/cell-binding-object/](./samples/data-binding/cell-binding-object/) |
| prevent-bindingpath-multi-bind | 禁止重复绑定字段 | [./samples/data-binding/prevent-bindingpath-multi-bind/](./samples/data-binding/prevent-bindingpath-multi-bind/) |
| auto-load-data-bind-tree | 设计器自动加载数据绑定树 | [./samples/data-binding/auto-load-data-bind-tree/](./samples/data-binding/auto-load-data-bind-tree/) |
| support-fill-data-in-excel-when-using-databinding | 在excel中填报并关联数据绑定 | [./samples/data-binding/support-fill-data-in-excel-when-using-databinding/](./samples/data-binding/support-fill-data-in-excel-when-using-databinding/) |
| table-databind-include-functions | 包含公式的表格绑定 | [./samples/data-binding/table-databind-include-functions/](./samples/data-binding/table-databind-include-functions/) |
| table-binding-support-auto-merge | 绑定表格时支持合并单元格 | [./samples/data-binding/table-binding-support-auto-merge/](./samples/data-binding/table-binding-support-auto-merge/) |
| datasource-drving-chart-update | 图表动态更新（表格绑定） | [./samples/data-binding/datasource-drving-chart-update/](./samples/data-binding/datasource-drving-chart-update/) |
| keep-filter-and-sort-state-after-bind-datasource | 绑定数据源保留筛选排序状态 | [./samples/data-binding/keep-filter-and-sort-state-after-bind-datasource/](./samples/data-binding/keep-filter-and-sort-state-after-bind-datasource/) |
| databind-field-list-support-display-name | 字段列表支持绑定值与显示值不同 | [./samples/data-binding/databind-field-list-support-display-name/](./samples/data-binding/databind-field-list-support-display-name/) |
| table-column-value-convert | 表列值转换与修改 | [./samples/data-binding/table-column-value-convert/](./samples/data-binding/table-column-value-convert/) |
| cell-text-width | 获取单元格文本的宽度 | [./samples/data-binding/cell-text-width/](./samples/data-binding/cell-text-width/) |
| use-rangetemplate-in-databinding | 在数据绑定中使用区域模板 | [./samples/data-binding/use-rangetemplate-in-databinding/](./samples/data-binding/use-rangetemplate-in-databinding/) |
| table-binding-vertical-expand-keep-style | 纵向扩展时保持样式和公式 | [./samples/data-binding/table-binding-vertical-expand-keep-style/](./samples/data-binding/table-binding-vertical-expand-keep-style/) |
| table-binding-support-combox | 表格绑定时添加组合框列 | [./samples/data-binding/table-binding-support-combox/](./samples/data-binding/table-binding-support-combox/) |
| hidden-fields-remain-consist-after-copy | 隐藏字段在复制时保持一致 | [./samples/data-binding/hidden-fields-remain-consist-after-copy/](./samples/data-binding/hidden-fields-remain-consist-after-copy/) |
| copy-cut-does-not-effect-data-binding | 复制粘贴剪切不影响数据绑定 | [./samples/data-binding/copy-cut-does-not-effect-data-binding/](./samples/data-binding/copy-cut-does-not-effect-data-binding/) |

### 打印相关 (print)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| partial-sheet-print | 部分 Sheet 页打印 | [./samples/print/partial-sheet-print/](./samples/print/partial-sheet-print/) |
| print-background | 打印背景图的替代方案 | [./samples/print/print-background/](./samples/print/print-background/) |
| print-image-download | 打印导出图片 | [./samples/print/print-image-download/](./samples/print/print-image-download/) |
| grayscale-printing | 黑白打印去掉背景色 | [./samples/print/grayscale-printing/](./samples/print/grayscale-printing/) |
| print-preview | 打印预览 | [./samples/print/print-preview/](./samples/print/print-preview/) |
| save-workbook-to-image | 将工作簿保存为图片 | [./samples/print/save-workbook-to-image/](./samples/print/save-workbook-to-image/) |
| pagebreak-print-repeat-header-footer | 打印分页时重复表头表尾 | [./samples/print/pagebreak-print-repeat-header-footer/](./samples/print/pagebreak-print-repeat-header-footer/) |
| print-dynamic-adjust-rowheight-add-border | 打印时动态调整行高、添加边框 | [./samples/print/print-dynamic-adjust-rowheight-add-border/](./samples/print/print-dynamic-adjust-rowheight-add-border/) |
| customize-print-pape-size | 自定义打印纸张尺寸 | [./samples/print/customize-print-pape-size/](./samples/print/customize-print-pape-size/) |

### 单元格相关 (cell)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| upload-file-button | 文件上传按钮 | [./samples/cell/upload-file-button/](./samples/cell/upload-file-button/) |
| customize-cell-input-mask-box | 自定义-方框填写 | [./samples/cell/customize-cell-input-mask-box/](./samples/cell/customize-cell-input-mask-box/) |
| customize-cell-corner | 自定义-绘制角标 | [./samples/cell/customize-cell-corner/](./samples/cell/customize-cell-corner/) |
| customize-cell-highlight-search-key-words | 单元格高亮搜索 | [./samples/cell/customize-cell-highlight-search-key-words/](./samples/cell/customize-cell-highlight-search-key-words/) |
| customize-cell-image-hyperlink | 自定义-图片与超链接 | [./samples/cell/customize-cell-image-hyperlink/](./samples/cell/customize-cell-image-hyperlink/) |
| customize-cell-progress | 自定义-进度条 | [./samples/cell/customize-cell-progress/](./samples/cell/customize-cell-progress/) |
| customize-cell-html | HTML 元素单元格 | [./samples/cell/customize-cell-html/](./samples/cell/customize-cell-html/) |
| change-cell-type | 改变单元格类型 | [./samples/cell/change-cell-type/](./samples/cell/change-cell-type/) |
| hide-formula-readonly | 不显示公式且只读 | [./samples/cell/hide-formula-readonly/](./samples/cell/hide-formula-readonly/) |
| customize-cell-ztree | 自定义-实现 zTree 树 | [./samples/cell/customize-cell-ztree/](./samples/cell/customize-cell-ztree/) |
| check-if-richtext | 判断是否为富文本格式 | [./samples/cell/check-if-richtext/](./samples/cell/check-if-richtext/) |
| empty-cell-show-content | 空单元格显示指定内容 | [./samples/cell/empty-cell-show-content/](./samples/cell/empty-cell-show-content/) |
| customize-cell-buttons | 自定义-按钮 | [./samples/cell/customize-cell-buttons/](./samples/cell/customize-cell-buttons/) |
| customize-cell-button-with-image | 自定义-图片按钮 | [./samples/cell/customize-cell-button-with-image/](./samples/cell/customize-cell-button-with-image/) |
| cell-image-hover-hint | 单元格图片 hover 提示 | [./samples/cell/cell-image-hover-hint/](./samples/cell/cell-image-hover-hint/) |
| customize-cell-filter | 自定义筛选按钮 | [./samples/cell/customize-cell-filter/](./samples/cell/customize-cell-filter/) |
| control-editable-cell | 自定义-编辑可控 | [./samples/cell/control-editable-cell/](./samples/cell/control-editable-cell/) |
| customize-cell-hover-cell-image | 自定义-添加鼠标悬浮图片 | [./samples/cell/customize-cell-hover-cell-image/](./samples/cell/customize-cell-hover-cell-image/) |
| range-editable-according-user-group | 根据权限设置表格可操作区域 | [./samples/cell/range-editable-according-user-group/](./samples/cell/range-editable-according-user-group/) |
| customize-cell-slider | 数字滑动条筛选功能 | [./samples/cell/customize-cell-slider/](./samples/cell/customize-cell-slider/) |
| get-cell-cursor-index | 获取单元格光标索引 | [./samples/cell/get-cell-cursor-index/](./samples/cell/get-cell-cursor-index/) |
| element-ui-cell-type | 类 ElementUI 样式单元格 | [./samples/cell/element-ui-cell-type/](./samples/cell/element-ui-cell-type/) |
| multiple-datetime-picker-in-one-cell | 多个日期选择器 | [./samples/cell/multiple-datetime-picker-in-one-cell/](./samples/cell/multiple-datetime-picker-in-one-cell/) |
| change-style-by-binding-value | 根据绑定路径同级的值修改样式 | [./samples/cell/change-style-by-binding-value/](./samples/cell/change-style-by-binding-value/) |
| custom-switch-button | 自定义-switch开关 | [./samples/cell/custom-switch-button/](./samples/cell/custom-switch-button/) |
| choose-function-with-dropdown-box | 下拉框选择公式 | [./samples/cell/choose-function-with-dropdown-box/](./samples/cell/choose-function-with-dropdown-box/) |
| mouse-hover-change-text | 自定义-鼠标悬浮改变文字 | [./samples/cell/mouse-hover-change-text/](./samples/cell/mouse-hover-change-text/) |
| drag-ztree-as-table | 拖拽ztree生成表格 | [./samples/cell/drag-ztree-as-table/](./samples/cell/drag-ztree-as-table/) |
| show-image-when-mouse-enter | 鼠标移入单元格 显示图片 | [./samples/cell/show-image-when-mouse-enter/](./samples/cell/show-image-when-mouse-enter/) |
| highlight-area-and-add-tag | 高亮编辑框 右下角加标识 | [./samples/cell/highlight-area-and-add-tag/](./samples/cell/highlight-area-and-add-tag/) |
| rewrite-sheet-corner | 重写表角 | [./samples/cell/rewrite-sheet-corner/](./samples/cell/rewrite-sheet-corner/) |
| image-cell-type-with-data-binding | 图片类型单元格 | [./samples/cell/image-cell-type-with-data-binding/](./samples/cell/image-cell-type-with-data-binding/) |
| cellbuttons-hovertext | 单元格按钮添加hover提示功能 | [./samples/cell/cellbuttons-hovertext/](./samples/cell/cellbuttons-hovertext/) |
| string-number-add-corner-icon | 文本类字符串增加角标 | [./samples/cell/string-number-add-corner-icon/](./samples/cell/string-number-add-corner-icon/) |
| big-number-display-as-excel | 大数字精度丢失处理 | [./samples/cell/big-number-display-as-excel/](./samples/cell/big-number-display-as-excel/) |
| toggle-show-binding-path | 切换显示单元格绑定路径 | [./samples/cell/toggle-show-binding-path/](./samples/cell/toggle-show-binding-path/) |
| combobox-cascase-select | 级联选择（ComboBox） | [./samples/cell/combobox-cascase-select/](./samples/cell/combobox-cascase-select/) |
| multi-dimension-table-header | 多维度表头 | [./samples/cell/multi-dimension-table-header/](./samples/cell/multi-dimension-table-header/) |
| handwriting-celltype-and-ocr | 单元格手写OCR识别 | [./samples/cell/handwriting-celltype-and-ocr/](./samples/cell/handwriting-celltype-and-ocr/) |
| show-object-array-key | 单元格显示对象数组的值 | [./samples/cell/show-object-array-key/](./samples/cell/show-object-array-key/) |
| designer-add-combobox-support-value-as-number | 设计器设置组合框的值可为数字类型 | [./samples/cell/designer-add-combobox-support-value-as-number/](./samples/cell/designer-add-combobox-support-value-as-number/) |
| multi-select-dropdown-support-backcolor | 多选下拉框item支持背景色 | [./samples/cell/multi-select-dropdown-support-backcolor/](./samples/cell/multi-select-dropdown-support-backcolor/) |
| tree-data-transfer-to-cell-level | 树形数据转换为单元格层级关系 | [./samples/cell/tree-data-transfer-to-cell-level/](./samples/cell/tree-data-transfer-to-cell-level/) |
| hide-combobox-dropdown-when-cell-unselected | 未选中组合框时隐藏下拉箭头 | [./samples/cell/hide-combobox-dropdown-when-cell-unselected/](./samples/cell/hide-combobox-dropdown-when-cell-unselected/) |
| paint-checkboxlist-with-text | 使用Text单元格渲染CheckBoxList | [./samples/cell/paint-checkboxlist-with-text/](./samples/cell/paint-checkboxlist-with-text/) |
| custom-celltype-with-dropdownlist-and-search | 带搜索功能的下拉多选 | [./samples/cell/custom-celltype-with-dropdownlist-and-search/](./samples/cell/custom-celltype-with-dropdownlist-and-search/) |
| change-fileupload-celltype-style | 修改文件上传单元格样式 | [./samples/cell/change-fileupload-celltype-style/](./samples/cell/change-fileupload-celltype-style/) |
| custom-ellipsis-celltype | 自定制省略符提示框 | [./samples/cell/custom-ellipsis-celltype/](./samples/cell/custom-ellipsis-celltype/) |
| custom-celltype-forbid-cn-character | 自定义单元格-不允许接受中文字符 | [./samples/cell/custom-celltype-forbid-cn-character/](./samples/cell/custom-celltype-forbid-cn-character/) |
| customsize-button-background-image | 单元格按钮如何自定义单元格背景图 | [./samples/cell/customsize-button-background-image/](./samples/cell/customsize-button-background-image/) |
| dropdown-multiselect-celltype | 下拉多选类型单元格 | [./samples/cell/dropdown-multiselect-celltype/](./samples/cell/dropdown-multiselect-celltype/) |
| spreadjs-dropwdown-list-supports | SpreadJS内置支持下拉列表实现汇总 | [./samples/cell/spreadjs-dropwdown-list-supports/](./samples/cell/spreadjs-dropwdown-list-supports/) |
| control-cell-editable | 实现单元格编辑可控 | [./samples/cell/control-cell-editable/](./samples/cell/control-cell-editable/) |
| custom-celltype-copy-paste-issue | 自定义单元格复制失效问题 | [./samples/cell/custom-celltype-copy-paste-issue/](./samples/cell/custom-celltype-copy-paste-issue/) |
| cellbuttons-command-register | 单元格按钮（CellButtons）命令注册 | [./samples/cell/cellbuttons-command-register/](./samples/cell/cellbuttons-command-register/) |
| richtext-dropdown-list | 富文本下拉框 | [./samples/cell/richtext-dropdown-list/](./samples/cell/richtext-dropdown-list/) |

### 行列设置 (row-column)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| highlight-selected-row-col | 单元格选中十字高亮 | [./samples/row-column/highlight-selected-row-col/](./samples/row-column/highlight-selected-row-col/) |
| column-header-check-all | 列头添加复选框全选 | [./samples/row-column/column-header-check-all/](./samples/row-column/column-header-check-all/) |
| prevent-corner-click | Corner 禁止点击 | [./samples/row-column/prevent-corner-click/](./samples/row-column/prevent-corner-click/) |
| customize-filter-dialog | 自定义筛选菜单 UI | [./samples/row-column/customize-filter-dialog/](./samples/row-column/customize-filter-dialog/) |
| code-multi-column-filter | 代码实现多列筛选 | [./samples/row-column/code-multi-column-filter/](./samples/row-column/code-multi-column-filter/) |
| combobox-column-header | 列头下拉框 | [./samples/row-column/combobox-column-header/](./samples/row-column/combobox-column-header/) |
| customize-column-sort | 自定义列排序功能 | [./samples/row-column/customize-column-sort/](./samples/row-column/customize-column-sort/) |
| column-autofit-width | 根据输入内容自适应列宽 | [./samples/row-column/column-autofit-width/](./samples/row-column/column-autofit-width/) |
| customize-context-menu-insert-rows | 行头右键菜单-插入多行 | [./samples/row-column/customize-context-menu-insert-rows/](./samples/row-column/customize-context-menu-insert-rows/) |
| row-header-icon | 行头显示编辑图标 | [./samples/row-column/row-header-icon/](./samples/row-column/row-header-icon/) |
| sync-filter-condition | 同步筛选条件 | [./samples/row-column/sync-filter-condition/](./samples/row-column/sync-filter-condition/) |
| add-filter-condition-by-button | 点击按钮添加/取消筛选条件 | [./samples/row-column/add-filter-condition-by-button/](./samples/row-column/add-filter-condition-by-button/) |
| sort-by-Chinese | 按中文排序 | [./samples/row-column/sort-by-Chinese/](./samples/row-column/sort-by-Chinese/) |
| add-default-condition-to-date-filter | 日期筛选器添加默认筛选条件 | [./samples/row-column/add-default-condition-to-date-filter/](./samples/row-column/add-default-condition-to-date-filter/) |
| col-header-and-cell-width-self-adjust | 列头与单元格宽度自适应 | [./samples/row-column/col-header-and-cell-width-self-adjust/](./samples/row-column/col-header-and-cell-width-self-adjust/) |
| big-data-collapse | 大数据量的分组列展开折叠 | [./samples/row-column/big-data-collapse/](./samples/row-column/big-data-collapse/) |
| table-number-range-filter | 表格数字的区间筛选 | [./samples/row-column/table-number-range-filter/](./samples/row-column/table-number-range-filter/) |
| string-number-sort-by-number | 字符串类型的数字按照大小排序 | [./samples/row-column/string-number-sort-by-number/](./samples/row-column/string-number-sort-by-number/) |
| fill-empty-range-with-cells | 用单元格填充空白区域 | [./samples/row-column/fill-empty-range-with-cells/](./samples/row-column/fill-empty-range-with-cells/) |
| unhide-rows-when-expand-group | 展开分组时自动显示隐藏行 | [./samples/row-column/unhide-rows-when-expand-group/](./samples/row-column/unhide-rows-when-expand-group/) |
| support-insert-new-line-to-table-by-tab-under-certain-case | 特定情况下支持通过Tab新增表格行 | [./samples/row-column/support-insert-new-line-to-table-by-tab-under-certain-case/](./samples/row-column/support-insert-new-line-to-table-by-tab-under-certain-case/) |
| filter-logic-same-with-wps | 筛选逻辑和WPS相同 | [./samples/row-column/filter-logic-same-with-wps/](./samples/row-column/filter-logic-same-with-wps/) |
| alt-enter-enable-auto-wrap | Alt+Enter 开启自动换行 | [./samples/row-column/alt-enter-enable-auto-wrap/](./samples/row-column/alt-enter-enable-auto-wrap/) |
| set-alt-row-style | 交替行样式 | [./samples/row-column/set-alt-row-style/](./samples/row-column/set-alt-row-style/) |
| auto-expand-pivottable-column-count | 自动扩展透视表列 | [./samples/row-column/auto-expand-pivottable-column-count/](./samples/row-column/auto-expand-pivottable-column-count/) |
| update-pivottable-when-insert-column-to-datasource | 表格绑定插入列时更新数据透视表 | [./samples/row-column/update-pivottable-when-insert-column-to-datasource/](./samples/row-column/update-pivottable-when-insert-column-to-datasource/) |
| pagination-preview-enhancement | 分页预览线样式增强 | [./samples/row-column/pagination-preview-enhancement/](./samples/row-column/pagination-preview-enhancement/) |

### 事件行为 (events)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| more-flexible-permission-control | 更灵活的权限控制 | [./samples/events/more-flexible-permission-control/](./samples/events/more-flexible-permission-control/) |
| customize-command-redo-undo-conditionformat | 自定义命令-撤销、重做、条件格式 | [./samples/events/customize-command-redo-undo-conditionformat/](./samples/events/customize-command-redo-undo-conditionformat/) |
| show-dialog-try-to-edit-protect-sheet | 表单保护下弹出提示框 | [./samples/events/show-dialog-try-to-edit-protect-sheet/](./samples/events/show-dialog-try-to-edit-protect-sheet/) |
| related-combobox | 下拉框联动 | [./samples/events/related-combobox/](./samples/events/related-combobox/) |
| scroll-load-data | 表格绑定滚动加载数据 | [./samples/events/scroll-load-data/](./samples/events/scroll-load-data/) |
| tab-next-editable-cell | Tab 跳转下一个可编辑单元格 | [./samples/events/tab-next-editable-cell/](./samples/events/tab-next-editable-cell/) |
| auto-word-wrap-when-enter | 设置单元格自动换行 | [./samples/events/auto-word-wrap-when-enter/](./samples/events/auto-word-wrap-when-enter/) |
| related-input-form | 实现关联表单信息查询及修改 | [./samples/events/related-input-form/](./samples/events/related-input-form/) |
| hide-table-column | 表格列隐藏 | [./samples/events/hide-table-column/](./samples/events/hide-table-column/) |
| select-whole-row-when-click-cell | 选中区域时自动选中整行 | [./samples/events/select-whole-row-when-click-cell/](./samples/events/select-whole-row-when-click-cell/) |
| command-edit-multiple-workbook | 通过命令，同步编辑多个工作簿 | [./samples/events/command-edit-multiple-workbook/](./samples/events/command-edit-multiple-workbook/) |
| rewrite-tojson | 重写 toJSON 方法 | [./samples/events/rewrite-tojson/](./samples/events/rewrite-tojson/) |
| change-row-backcolor-checkbox | 选中 Checkbox 所在行改变背景色 | [./samples/events/change-row-backcolor-checkbox/](./samples/events/change-row-backcolor-checkbox/) |
| pasting-loading-effect | 复制粘贴动画效果 | [./samples/events/pasting-loading-effect/](./samples/events/pasting-loading-effect/) |
| drag-column | 拖拽移动列 | [./samples/events/drag-column/](./samples/events/drag-column/) |
| rewrite-ctrl-enter-auto-fill | 重写"Ctrl+Enter",实现自动填充 | [./samples/events/rewrite-ctrl-enter-auto-fill/](./samples/events/rewrite-ctrl-enter-auto-fill/) |
| monitor-checkbox-cell-value-change | 监听复选框中值的变化 | [./samples/events/monitor-checkbox-cell-value-change/](./samples/events/monitor-checkbox-cell-value-change/) |
| rewrite-delete | 重写 Delete 键 | [./samples/events/rewrite-delete/](./samples/events/rewrite-delete/) |
| scroll-and-add-rows | 滚动表单添加行 | [./samples/events/scroll-and-add-rows/](./samples/events/scroll-and-add-rows/) |
| drag-element-to-spreadjs | 将外部元素拖拽进SpreadJS | [./samples/events/drag-element-to-spreadjs/](./samples/events/drag-element-to-spreadjs/) |
| custom-command-support-undo-redo | 自定义命令—支持undo、redo | [./samples/events/custom-command-support-undo-redo/](./samples/events/custom-command-support-undo-redo/) |
| selected-chart-to-the-top | 当前选中Chart置顶 | [./samples/events/selected-chart-to-the-top/](./samples/events/selected-chart-to-the-top/) |
| get-showvalue-of-cell | 获取单元格显示值 | [./samples/events/get-showvalue-of-cell/](./samples/events/get-showvalue-of-cell/) |
| change-bgcolor-after-clear-content | 清除单元格后背景变色 | [./samples/events/change-bgcolor-after-clear-content/](./samples/events/change-bgcolor-after-clear-content/) |
| forbid-sheet-multiselect | 禁止sheet多选 | [./samples/events/forbid-sheet-multiselect/](./samples/events/forbid-sheet-multiselect/) |
| change-cell-value-under-edit-status-by-clicking-button | 点击外部按钮修改处于编辑状态的单元格 | [./samples/events/change-cell-value-under-edit-status-by-clicking-button/](./samples/events/change-cell-value-under-edit-status-by-clicking-button/) |
| custom-range-selector | 自定义区域选择器 | [./samples/events/custom-range-selector/](./samples/events/custom-range-selector/) |
| click-image-popup-replace-modal | 点击图片弹出替换框 | [./samples/events/click-image-popup-replace-modal/](./samples/events/click-image-popup-replace-modal/) |
| auto-fit-row-when-scrolling | 滚动时调整行高 | [./samples/events/auto-fit-row-when-scrolling/](./samples/events/auto-fit-row-when-scrolling/) |
| enable-horizental-scroll-with-shift | 按住shift时支持横向滚动 | [./samples/events/enable-horizental-scroll-with-shift/](./samples/events/enable-horizental-scroll-with-shift/) |
| rewrite-selection-bottom-short-key | 重写快捷键——向下扩展选中 | [./samples/events/rewrite-selection-bottom-short-key/](./samples/events/rewrite-selection-bottom-short-key/) |
| shape-double-click-event | 形状的双击事件 | [./samples/events/shape-double-click-event/](./samples/events/shape-double-click-event/) |
| dbclick-open-format-panel | 双击图片打开格式面板 | [./samples/events/dbclick-open-format-panel/](./samples/events/dbclick-open-format-panel/) |
| forbid-menecontext-switch-tab | 禁止鼠标右键切换sheet | [./samples/events/forbid-menecontext-switch-tab/](./samples/events/forbid-menecontext-switch-tab/) |
| change-newtab-event | 修改默认的新增Sheet按钮事件 | [./samples/events/change-newtab-event/](./samples/events/change-newtab-event/) |
| alt-pagedown-horizental-pagescroll | Alt+PageDown实现横向换页 | [./samples/events/alt-pagedown-horizental-pagescroll/](./samples/events/alt-pagedown-horizental-pagescroll/) |
| judge-if-scroll-to-bottom | 判断是否滚动到底 | [./samples/events/judge-if-scroll-to-bottom/](./samples/events/judge-if-scroll-to-bottom/) |
| limit-datetimepicker-select-range | 限制时间选择器的时间范围 | [./samples/events/limit-datetimepicker-select-range/](./samples/events/limit-datetimepicker-select-range/) |
| force-delete-rows-ignore-protect | 强制删除行（无视保护） | [./samples/events/force-delete-rows-ignore-protect/](./samples/events/force-delete-rows-ignore-protect/) |
| forbid-spreadjs-grab-outter-input-focus-state | 防止单元格和外部输入框抢夺focus状态 | [./samples/events/forbid-spreadjs-grab-outter-input-focus-state/](./samples/events/forbid-spreadjs-grab-outter-input-focus-state/) |
| over-text-show-in-next-row | 超出文本自动在下一行显示 | [./samples/events/over-text-show-in-next-row/](./samples/events/over-text-show-in-next-row/) |
| listen-hyperlink-click | 点击超链接时添加监听 | [./samples/events/listen-hyperlink-click/](./samples/events/listen-hyperlink-click/) |
| control-user-enter-edit | 控制输入行为 | [./samples/events/control-user-enter-edit/](./samples/events/control-user-enter-edit/) |
| forbid-drag-cell | 禁止单元格移动/拖动 | [./samples/events/forbid-drag-cell/](./samples/events/forbid-drag-cell/) |
| rewrite-insert-chart-command | 重写插入图表命令 | [./samples/events/rewrite-insert-chart-command/](./samples/events/rewrite-insert-chart-command/) |
| add-excel-like-dialog-when-sort | 排序时实现类Excel提示 | [./samples/events/add-excel-like-dialog-when-sort/](./samples/events/add-excel-like-dialog-when-sort/) |
| get-table-deleted-row-info | 获取表格删除行信息 | [./samples/events/get-table-deleted-row-info/](./samples/events/get-table-deleted-row-info/) |
| area-limited-when-drag-floating-object | 限制浮动对象的拖动范围 | [./samples/events/area-limited-when-drag-floating-object/](./samples/events/area-limited-when-drag-floating-object/) |
| rewrite-deisgner-command | 重写设计器命令 | [./samples/events/rewrite-deisgner-command/](./samples/events/rewrite-deisgner-command/) |
| data-validation-error-msg | 运行时数据验证失败弹框 | [./samples/events/data-validation-error-msg/](./samples/events/data-validation-error-msg/) |
| merge-cells-shortcut | 快捷键实现单元格合并 | [./samples/events/merge-cells-shortcut/](./samples/events/merge-cells-shortcut/) |
| insert-table-to-filter-range | 筛选区域可添加table | [./samples/events/insert-table-to-filter-range/](./samples/events/insert-table-to-filter-range/) |

### 格式样式 (format-style)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| modify-default-style | 修改默认样式（CSS） | [./samples/format-style/modify-default-style/](./samples/format-style/modify-default-style/) |
| not-display-scientific-notation | 不显示科学计数法 | [./samples/format-style/not-display-scientific-notation/](./samples/format-style/not-display-scientific-notation/) |
| limit-text-length | 限制单元格中输入内容的长度 | [./samples/format-style/limit-text-length/](./samples/format-style/limit-text-length/) |
| oadate-datetime-sort | OADate 转日期格式并实现排序 | [./samples/format-style/oadate-datetime-sort/](./samples/format-style/oadate-datetime-sort/) |
| auto-row-height-merge-cells | 包含合并单元格的自适应行高 | [./samples/format-style/auto-row-height-merge-cells/](./samples/format-style/auto-row-height-merge-cells/) |
| customize-formatter | 自定义格式化 | [./samples/format-style/customize-formatter/](./samples/format-style/customize-formatter/) |
| resize-animation | Resize 动画 | [./samples/format-style/resize-animation/](./samples/format-style/resize-animation/) |
| show-dialog-invalidation | 数据验证失败时弹窗 | [./samples/format-style/show-dialog-invalidation/](./samples/format-style/show-dialog-invalidation/) |
| scientific-notation-formatter | 真正科学计数法 | [./samples/format-style/scientific-notation-formatter/](./samples/format-style/scientific-notation-formatter/) |
| mouse-hover-whole-row-style | 鼠标悬浮整行高亮 | [./samples/format-style/mouse-hover-whole-row-style/](./samples/format-style/mouse-hover-whole-row-style/) |
| change-cell-default-style | 修改单元格默认style | [./samples/format-style/change-cell-default-style/](./samples/format-style/change-cell-default-style/) |
| set-cell-format-to-number | 设置数字单元格格式 | [./samples/format-style/set-cell-format-to-number/](./samples/format-style/set-cell-format-to-number/) |
| set-cell-text-seperate-align | 单元格文本分散对齐 | [./samples/format-style/set-cell-text-seperate-align/](./samples/format-style/set-cell-text-seperate-align/) |
| set-cell-half-adjust | 单元格格式（百分数）：四舍五入 | [./samples/format-style/set-cell-half-adjust/](./samples/format-style/set-cell-half-adjust/) |
| set-bgcolor-to-condition-format-passed-cell | 公式条件验证通过设置背景色 | [./samples/format-style/set-bgcolor-to-condition-format-passed-cell/](./samples/format-style/set-bgcolor-to-condition-format-passed-cell/) |
| self-ajdust-height | 自适应行高 | [./samples/format-style/self-ajdust-height/](./samples/format-style/self-ajdust-height/) |
| set-mouse-gusture-to-hovered-cell | 自定义单选框鼠标滑过手势 | [./samples/format-style/set-mouse-gusture-to-hovered-cell/](./samples/format-style/set-mouse-gusture-to-hovered-cell/) |
| only-number-entering-allowed | 单元格仅能输入数字 | [./samples/format-style/only-number-entering-allowed/](./samples/format-style/only-number-entering-allowed/) |
| click-button-to-change-font | 点击按钮改变字体 | [./samples/format-style/click-button-to-change-font/](./samples/format-style/click-button-to-change-font/) |
| hide-content-when-cell-value-is-zero | 单元格内容为0时隐藏 | [./samples/format-style/hide-content-when-cell-value-is-zero/](./samples/format-style/hide-content-when-cell-value-is-zero/) |
| cusomize-cell-set-hyperlink | 自定义-上下标及超链接 | [./samples/format-style/cusomize-cell-set-hyperlink/](./samples/format-style/cusomize-cell-set-hyperlink/) |
| convert-number-to-percentage | 输入数字转化为百分比 | [./samples/format-style/convert-number-to-percentage/](./samples/format-style/convert-number-to-percentage/) |
| replace-content-when-calculate-error | 计算错误异常时替换显示内容 | [./samples/format-style/replace-content-when-calculate-error/](./samples/format-style/replace-content-when-calculate-error/) |
| get-merged-cell-value | 获取合并单元格的值 | [./samples/format-style/get-merged-cell-value/](./samples/format-style/get-merged-cell-value/) |
| convert-html-to-richtext | 将html解析为富文本 | [./samples/format-style/convert-html-to-richtext/](./samples/format-style/convert-html-to-richtext/) |
| automerge-cells-when-value-is-same | 自动合并同值单元格 | [./samples/format-style/automerge-cells-when-value-is-same/](./samples/format-style/automerge-cells-when-value-is-same/) |
| change-designer-popup-title | 设计器弹框修改标题 | [./samples/format-style/change-designer-popup-title/](./samples/format-style/change-designer-popup-title/) |
| add-watermark | 添加水印 | [./samples/format-style/add-watermark/](./samples/format-style/add-watermark/) |
| format-number-to-wan-yuan | 显示时将金额转换为“万元“ | [./samples/format-style/format-number-to-wan-yuan/](./samples/format-style/format-number-to-wan-yuan/) |
| auto-convert-number-to-Chinese | 自动化数字转金额大写 | [./samples/format-style/auto-convert-number-to-Chinese/](./samples/format-style/auto-convert-number-to-Chinese/) |
| header-footer-template-dynamic-insert | 头尾模板动态插入 | [./samples/format-style/header-footer-template-dynamic-insert/](./samples/format-style/header-footer-template-dynamic-insert/) |
| mouse-enter-highlight-range | 鼠标进入后区域高亮 | [./samples/format-style/mouse-enter-highlight-range/](./samples/format-style/mouse-enter-highlight-range/) |
| dirty-cell-style-toggle | 脏数据样式开启、关闭 | [./samples/format-style/dirty-cell-style-toggle/](./samples/format-style/dirty-cell-style-toggle/) |
| use-same-wrap-rule-between-en-zh | 中英文采用相同换行规则 | [./samples/format-style/use-same-wrap-rule-between-en-zh/](./samples/format-style/use-same-wrap-rule-between-en-zh/) |
| string-number-format-performs-same-with-excel | 字符串数字的格式化表现与Excel一致 | [./samples/format-style/string-number-format-performs-same-with-excel/](./samples/format-style/string-number-format-performs-same-with-excel/) |
| show-zero-as-short-line | 0值显示为指定字符 | [./samples/format-style/show-zero-as-short-line/](./samples/format-style/show-zero-as-short-line/) |
| checkbox-conditional-format-change | 条件格式实现单元格格式转换 | [./samples/format-style/checkbox-conditional-format-change/](./samples/format-style/checkbox-conditional-format-change/) |
| keep-integer-with-float-format | 小数格式时保留整数格式 | [./samples/format-style/keep-integer-with-float-format/](./samples/format-style/keep-integer-with-float-format/) |
| multi-header-table-binding | 表格绑定-多层表头设计 | [./samples/format-style/multi-header-table-binding/](./samples/format-style/multi-header-table-binding/) |
| use-fontawesome | 使用FontAwesome字体 | [./samples/format-style/use-fontawesome/](./samples/format-style/use-fontawesome/) |
| border-style-priority | 边框样式优先级 | [./samples/format-style/border-style-priority/](./samples/format-style/border-style-priority/) |
| change-cell-editing-border-style | 修改单元格编辑时的边框样式 | [./samples/format-style/change-cell-editing-border-style/](./samples/format-style/change-cell-editing-border-style/) |
| dropbox-support-scrollbar | 下拉框增加滚动条 | [./samples/format-style/dropbox-support-scrollbar/](./samples/format-style/dropbox-support-scrollbar/) |
| reuse-custom-table-style | 自定义table样式复用 | [./samples/format-style/reuse-custom-table-style/](./samples/format-style/reuse-custom-table-style/) |
| pivottable-formula-conditional-formattin | 透视表的公式条件格式 | [./samples/format-style/pivottable-formula-conditional-formattin/](./samples/format-style/pivottable-formula-conditional-formattin/) |

### 公式函数 (formula)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| customize-formula-fill-other-range | 自定义公式填充其他单元格的值 | [./samples/formula/customize-formula-fill-other-range/](./samples/formula/customize-formula-fill-other-range/) |
| customize-formula-evaluate | 自定义函数实现 Evaluate | [./samples/formula/customize-formula-evaluate/](./samples/formula/customize-formula-evaluate/) |
| complex-formula-semantic | 复杂公式语义化 | [./samples/formula/complex-formula-semantic/](./samples/formula/complex-formula-semantic/) |
| customize-formula-rounding | 自定义函数：四舍六入 | [./samples/formula/customize-formula-rounding/](./samples/formula/customize-formula-rounding/) |
| formula-trace | 公式追踪 | [./samples/formula/formula-trace/](./samples/formula/formula-trace/) |
| outline-group-subtotal | 分组统计求和 | [./samples/formula/outline-group-subtotal/](./samples/formula/outline-group-subtotal/) |
| customize-formula-join-ranges | 自定义函数拼接引用区域 | [./samples/formula/customize-formula-join-ranges/](./samples/formula/customize-formula-join-ranges/) |
| rewrite-tofix-function | 重写浮点数toFix()函数 | [./samples/formula/rewrite-tofix-function/](./samples/formula/rewrite-tofix-function/) |
| trigger-all-async-functions-by-one-click | 一键触发工作表中所有异步函数 | [./samples/formula/trigger-all-async-functions-by-one-click/](./samples/formula/trigger-all-async-functions-by-one-click/) |
| get-data-of-namespace | 获取命名空间的数据 | [./samples/formula/get-data-of-namespace/](./samples/formula/get-data-of-namespace/) |
| refer-cell-in-other-sheet | 引用其他sheet页单元格 | [./samples/formula/refer-cell-in-other-sheet/](./samples/formula/refer-cell-in-other-sheet/) |
| custom-function-gettag | 自定义函数-GetTag | [./samples/formula/custom-function-gettag/](./samples/formula/custom-function-gettag/) |
| export-custom-function-value-to-excel | 自定义公式导出Excel时仅导出值 | [./samples/formula/export-custom-function-value-to-excel/](./samples/formula/export-custom-function-value-to-excel/) |
| cover-built-in-formula | 覆盖内置公式 | [./samples/formula/cover-built-in-formula/](./samples/formula/cover-built-in-formula/) |
| simulate-RTD-function | 模拟RTD函数 | [./samples/formula/simulate-RTD-function/](./samples/formula/simulate-RTD-function/) |
| display-number-as-chinese | 用大写中文显示数字 | [./samples/formula/display-number-as-chinese/](./samples/formula/display-number-as-chinese/) |
| F4-toggle-abs-rel-reference | F4切换绝对引用/相对引用 | [./samples/formula/F4-toggle-abs-rel-reference/](./samples/formula/F4-toggle-abs-rel-reference/) |
| cell-reference-style | 利用公式追踪实现单击标注公式 | [./samples/formula/cell-reference-style/](./samples/formula/cell-reference-style/) |
| add-custom-function-to-dialog | 插入函数按钮添加自定义公式 | [./samples/formula/add-custom-function-to-dialog/](./samples/formula/add-custom-function-to-dialog/) |
| input-formula-validation | 输入公式验证 | [./samples/formula/input-formula-validation/](./samples/formula/input-formula-validation/) |
| formula-cell-value-change-listen | 监听公式单元格值变化 | [./samples/formula/formula-cell-value-change-listen/](./samples/formula/formula-cell-value-change-listen/) |
| formula-arrow-trace | 公式依赖箭头绘制 | [./samples/formula/formula-arrow-trace/](./samples/formula/formula-arrow-trace/) |

### 设计器相关 (designer)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| designer-open-default-databinding-panel | 默认开启数据绑定面板 | [./samples/designer/designer-open-default-databinding-panel/](./samples/designer/designer-open-default-databinding-panel/) |
| designer-add-top-menu | 设计器-新增一级菜单 | [./samples/designer/designer-add-top-menu/](./samples/designer/designer-add-top-menu/) |
| designer-customize-command | 设计器-新增二级菜单 | [./samples/designer/designer-customize-command/](./samples/designer/designer-customize-command/) |
| replace-config | 设计器隐藏替换 | [./samples/designer/replace-config/](./samples/designer/replace-config/) |
| customize-dropdown | 设计器自定制 - 下拉框 | [./samples/designer/customize-dropdown/](./samples/designer/customize-dropdown/) |
| modify-file-dialog | 新增文件保存菜单 | [./samples/designer/modify-file-dialog/](./samples/designer/modify-file-dialog/) |
| change-priority | 修改菜单优先级 | [./samples/designer/change-priority/](./samples/designer/change-priority/) |
| fold-ribbon | 菜单默认折叠 | [./samples/designer/fold-ribbon/](./samples/designer/fold-ribbon/) |
| hide-show-ribbon | 工具栏隐藏显示 | [./samples/designer/hide-show-ribbon/](./samples/designer/hide-show-ribbon/) |
| float-ribbon | 浮动工具栏 | [./samples/designer/float-ribbon/](./samples/designer/float-ribbon/) |
| disable-designer-toolbar-button | 禁用设计器按钮 | [./samples/designer/disable-designer-toolbar-button/](./samples/designer/disable-designer-toolbar-button/) |
| change-designer-popup-text | 修改保护状态弹出框 | [./samples/designer/change-designer-popup-text/](./samples/designer/change-designer-popup-text/) |
| control-filemenu-open-or-close | 控制文件菜单打开或关闭 | [./samples/designer/control-filemenu-open-or-close/](./samples/designer/control-filemenu-open-or-close/) |
| disable-sheet-tab-context-menu | 禁用工作表页签的右键菜单 | [./samples/designer/disable-sheet-tab-context-menu/](./samples/designer/disable-sheet-tab-context-menu/) |
| delete-filemenu-export-function | 删除文件菜单-导出功能 | [./samples/designer/delete-filemenu-export-function/](./samples/designer/delete-filemenu-export-function/) |
| toggle-designer-toolbar-visible | 设计器工具栏显示隐藏切换 | [./samples/designer/toggle-designer-toolbar-visible/](./samples/designer/toggle-designer-toolbar-visible/) |
| filemenu-avalible-control | 控制文件按钮可用状态 | [./samples/designer/filemenu-avalible-control/](./samples/designer/filemenu-avalible-control/) |
| change-designer-font-to-traditional-chinese | 修改设计器字体为繁体 | [./samples/designer/change-designer-font-to-traditional-chinese/](./samples/designer/change-designer-font-to-traditional-chinese/) |
| disable-part-designer-context-menu | 禁用设计器部分右键菜单 | [./samples/designer/disable-part-designer-context-menu/](./samples/designer/disable-part-designer-context-menu/) |
| customized-designer-sidepanel | 设计器自定义侧边栏 | [./samples/designer/customized-designer-sidepanel/](./samples/designer/customized-designer-sidepanel/) |
| designer-add-font | 设计器下拉框中添加字体 | [./samples/designer/designer-add-font/](./samples/designer/designer-add-font/) |
| customize-toolbar-checkbox | 自定义工具栏-复选框 | [./samples/designer/customize-toolbar-checkbox/](./samples/designer/customize-toolbar-checkbox/) |
| disable-file-submenu | 禁用文件Tab下的部分选项 | [./samples/designer/disable-file-submenu/](./samples/designer/disable-file-submenu/) |
| designer-toolbar-add-custom-formula | 工具栏新增自定义公式 | [./samples/designer/designer-toolbar-add-custom-formula/](./samples/designer/designer-toolbar-add-custom-formula/) |
| intercept-designer-confrim-box | 拦截设计器确认框 | [./samples/designer/intercept-designer-confrim-box/](./samples/designer/intercept-designer-confrim-box/) |
| dynamic-toggle-designer-lang | 动态切换设计器语言 | [./samples/designer/dynamic-toggle-designer-lang/](./samples/designer/dynamic-toggle-designer-lang/) |
| hide-table-list-side-panel | 隐藏报表的数据源侧边栏 | [./samples/designer/hide-table-list-side-panel/](./samples/designer/hide-table-list-side-panel/) |
| listener-datamanager-closed | 监听关闭数据源事件 | [./samples/designer/listener-datamanager-closed/](./samples/designer/listener-datamanager-closed/) |
| sheet-protection-regardless-control-designer-enabled | 无视表单保护 控制设计器工具栏权限 | [./samples/designer/sheet-protection-regardless-control-designer-enabled/](./samples/designer/sheet-protection-regardless-control-designer-enabled/) |
| designer-add-area-selection-menu | 设计器添加区域选择菜单 | [./samples/designer/designer-add-area-selection-menu/](./samples/designer/designer-add-area-selection-menu/) |
| designer-add-dropdown-combobox | 设计器添加下拉comboBox | [./samples/designer/designer-add-dropdown-combobox/](./samples/designer/designer-add-dropdown-combobox/) |
| unable-some-options-in-file-menu | 禁用文件菜单的一些选项 | [./samples/designer/unable-some-options-in-file-menu/](./samples/designer/unable-some-options-in-file-menu/) |
| change-error-msg-dialog-content | 修改错误提示对话框的标题和内容 | [./samples/designer/change-error-msg-dialog-content/](./samples/designer/change-error-msg-dialog-content/) |
| add-more-font-size-to-designer | 工具栏添加更多字号 | [./samples/designer/add-more-font-size-to-designer/](./samples/designer/add-more-font-size-to-designer/) |
| preset-toolbarmode-context-menu-priority | 预设ToolbarMode工具栏按钮显示优先级 | [./samples/designer/preset-toolbarmode-context-menu-priority/](./samples/designer/preset-toolbarmode-context-menu-priority/) |
| control-designer-button-available | 控制工具栏按钮可用性 | [./samples/designer/control-designer-button-available/](./samples/designer/control-designer-button-available/) |
| resolve-the-problem-of-full-screen-popup-disappear | 解决全屏模式下弹窗不生效问题 | [./samples/designer/resolve-the-problem-of-full-screen-popup-disappear/](./samples/designer/resolve-the-problem-of-full-screen-popup-disappear/) |
| save-tip-before-open-another-file | 保存提示的弹窗 | [./samples/designer/save-tip-before-open-another-file/](./samples/designer/save-tip-before-open-another-file/) |
| designer-menu-add-spinner-input | 设计器菜单添加步进输入框 | [./samples/designer/designer-menu-add-spinner-input/](./samples/designer/designer-menu-add-spinner-input/) |

### 复制粘贴 (copy-paste)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| insert-row-with-style | 工作表插入行时复制样式 | [./samples/copy-paste/insert-row-with-style/](./samples/copy-paste/insert-row-with-style/) |
| copy-paste-by-button | 复制粘贴按钮实现 | [./samples/copy-paste/copy-paste-by-button/](./samples/copy-paste/copy-paste-by-button/) |
| copy-range | 拷贝指定区域 | [./samples/copy-paste/copy-range/](./samples/copy-paste/copy-range/) |
| rewrite-copy-paste | 重写 CopyPast 命令实现内部复制粘贴 | [./samples/copy-paste/rewrite-copy-paste/](./samples/copy-paste/rewrite-copy-paste/) |
| paste-data-ignore-protect-cell | 黏贴数据时跳过被保护单元格 | [./samples/copy-paste/paste-data-ignore-protect-cell/](./samples/copy-paste/paste-data-ignore-protect-cell/) |
| prevent-paste | 条件验证禁止粘贴 | [./samples/copy-paste/prevent-paste/](./samples/copy-paste/prevent-paste/) |
| paste-ignore-tag | 粘贴不影响单元格 Tag | [./samples/copy-paste/paste-ignore-tag/](./samples/copy-paste/paste-ignore-tag/) |
| paste-translate | 粘贴转置 | [./samples/copy-paste/paste-translate/](./samples/copy-paste/paste-translate/) |
| allow-protected-sheet-paste | 被保护的sheet允许粘贴 | [./samples/copy-paste/allow-protected-sheet-paste/](./samples/copy-paste/allow-protected-sheet-paste/) |
| copy-between-different-html-with-tag | 不同网页间复制时携带tag信息 | [./samples/copy-paste/copy-between-different-html-with-tag/](./samples/copy-paste/copy-between-different-html-with-tag/) |
| one-click-copy-whole-sheet | 一键复制整个sheet | [./samples/copy-paste/one-click-copy-whole-sheet/](./samples/copy-paste/one-click-copy-whole-sheet/) |
| copy-chart-as-image-to-clipboard | 复制图表到系统剪贴板 | [./samples/copy-paste/copy-chart-as-image-to-clipboard/](./samples/copy-paste/copy-chart-as-image-to-clipboard/) |
| context-menu-copy-to-system-clipboard | 菜单右键复制时写入系统剪贴板 | [./samples/copy-paste/context-menu-copy-to-system-clipboard/](./samples/copy-paste/context-menu-copy-to-system-clipboard/) |
| only-paste-values-and-formulas | CtrlV只粘贴值和公式 | [./samples/copy-paste/only-paste-values-and-formulas/](./samples/copy-paste/only-paste-values-and-formulas/) |
| paste-skip-formula | 粘贴跳过公式 | [./samples/copy-paste/paste-skip-formula/](./samples/copy-paste/paste-skip-formula/) |
| paste-skip-filtered-cells | 粘贴时仅跳过被筛选的单元格 | [./samples/copy-paste/paste-skip-filtered-cells/](./samples/copy-paste/paste-skip-filtered-cells/) |
| copy-incell-image-from-excel | 从Excel复制单元格内图片 | [./samples/copy-paste/copy-incell-image-from-excel/](./samples/copy-paste/copy-incell-image-from-excel/) |
| allow-paste-image-when-allowpasteexcelstyle-is-false | 禁止粘贴Excel样式时 允许粘贴图片 | [./samples/copy-paste/allow-paste-image-when-allowpasteexcelstyle-is-false/](./samples/copy-paste/allow-paste-image-when-allowpasteexcelstyle-is-false/) |
| ignore-hidden-row-when-copy | 复制时忽略隐藏行 | [./samples/copy-paste/ignore-hidden-row-when-copy/](./samples/copy-paste/ignore-hidden-row-when-copy/) |
| ctrl-c-performance-optimize-under-big-data | Ctrl+C复制卡死问题优化 | [./samples/copy-paste/ctrl-c-performance-optimize-under-big-data/](./samples/copy-paste/ctrl-c-performance-optimize-under-big-data/) |

### 数据校验 (data-validation)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| manuall-data-validation | 输入完成后进行验证 | [./samples/data-validation/manuall-data-validation/](./samples/data-validation/manuall-data-validation/) |
| customize-data-validation | 自定义数据校验 | [./samples/data-validation/customize-data-validation/](./samples/data-validation/customize-data-validation/) |
| caculate-all-valid-data-number | 计算符合规则的数据总数 | [./samples/data-validation/caculate-all-valid-data-number/](./samples/data-validation/caculate-all-valid-data-number/) |
| modify-condition-format-value | 修改条件格式基准值 | [./samples/data-validation/modify-condition-format-value/](./samples/data-validation/modify-condition-format-value/) |
| regex-data-validation | 正则表达式数据验证 | [./samples/data-validation/regex-data-validation/](./samples/data-validation/regex-data-validation/) |
| empty-cell-when-invalidate | 用户输入非法内容时自动清空 | [./samples/data-validation/empty-cell-when-invalidate/](./samples/data-validation/empty-cell-when-invalidate/) |
| related-data-validation | 数据验证实现级联效果 | [./samples/data-validation/related-data-validation/](./samples/data-validation/related-data-validation/) |
| abstract-cells-and-examine | 部分单元格内容提取审查 | [./samples/data-validation/abstract-cells-and-examine/](./samples/data-validation/abstract-cells-and-examine/) |
| get-datavalidation-result | 获取sheet中所有数据验证结果 | [./samples/data-validation/get-datavalidation-result/](./samples/data-validation/get-datavalidation-result/) |
| mutilple-datavalidation | 多规则组合数据验证 | [./samples/data-validation/mutilple-datavalidation/](./samples/data-validation/mutilple-datavalidation/) |
| datavalidator-cascading-dropdown | 数据验证实现级联下拉列表 | [./samples/data-validation/datavalidator-cascading-dropdown/](./samples/data-validation/datavalidator-cascading-dropdown/) |
| cell-input-limited-in-numbers | 限制单元格只能输入数字 | [./samples/data-validation/cell-input-limited-in-numbers/](./samples/data-validation/cell-input-limited-in-numbers/) |

### 菜单相关 (menu)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| spread-add-custom-context-menu | 新增右键菜单-Spread | [./samples/menu/spread-add-custom-context-menu/](./samples/menu/spread-add-custom-context-menu/) |
| add-context-menu-designer | 新增右键菜单-设计器 | [./samples/menu/add-context-menu-designer/](./samples/menu/add-context-menu-designer/) |
| add-context-menu-add-row-below | 菜单向下插入行-Spread | [./samples/menu/add-context-menu-add-row-below/](./samples/menu/add-context-menu-add-row-below/) |
| add-context-menu-insert-row-below-designer | 菜单向下插入行-设计器 | [./samples/menu/add-context-menu-insert-row-below-designer/](./samples/menu/add-context-menu-insert-row-below-designer/) |
| insert-copied-row-spread | 插入复制的行-Spread | [./samples/menu/insert-copied-row-spread/](./samples/menu/insert-copied-row-spread/) |
| context-menu-add-multi-line-spread | 右键菜单插入指定行数-Spread | [./samples/menu/context-menu-add-multi-line-spread/](./samples/menu/context-menu-add-multi-line-spread/) |
| row-header-menu-insert-rows | 右键菜单插入指定行数-设计器 | [./samples/menu/row-header-menu-insert-rows/](./samples/menu/row-header-menu-insert-rows/) |
| customize-context-menu-row-header-insert-row | 修改右键菜单-插入时携带上方样式 | [./samples/menu/customize-context-menu-row-header-insert-row/](./samples/menu/customize-context-menu-row-header-insert-row/) |
| customize-context-menu-tabstrip | 自定义工作表 Tab 右键删除功能 | [./samples/menu/customize-context-menu-tabstrip/](./samples/menu/customize-context-menu-tabstrip/) |
| customize-context-menu-row-header | 自定义右键菜单-局部行显示 | [./samples/menu/customize-context-menu-row-header/](./samples/menu/customize-context-menu-row-header/) |
| allow-context-menu-under-protect-sheet | 保护状态 不禁用右键菜单 | [./samples/menu/allow-context-menu-under-protect-sheet/](./samples/menu/allow-context-menu-under-protect-sheet/) |
| customize-menu-column-header | 修改列头右键菜单-删除操作 | [./samples/menu/customize-menu-column-header/](./samples/menu/customize-menu-column-header/) |
| forbidden-context-menu-under-sheet-protect | 表单保护下禁用右键菜单某项功能 | [./samples/menu/forbidden-context-menu-under-sheet-protect/](./samples/menu/forbidden-context-menu-under-sheet-protect/) |
| column-header-context-menu | 列头右键菜单获取列头显示内容 | [./samples/menu/column-header-context-menu/](./samples/menu/column-header-context-menu/) |
| some-context-avalible-when-sheet-is-protected | 表单保护下部分工具栏按钮及右键菜单可用 | [./samples/menu/some-context-avalible-when-sheet-is-protected/](./samples/menu/some-context-avalible-when-sheet-is-protected/) |
| context-menu-get-chart-image | 右键获取图表截图 | [./samples/menu/context-menu-get-chart-image/](./samples/menu/context-menu-get-chart-image/) |
| context-menu-get-cellrange-image | 右键获取单元格截图 | [./samples/menu/context-menu-get-cellrange-image/](./samples/menu/context-menu-get-cellrange-image/) |
| change-sheet-name-by-context-menu | 右键sheetTab修改表单名称 | [./samples/menu/change-sheet-name-by-context-menu/](./samples/menu/change-sheet-name-by-context-menu/) |
| statusbar-context-menu-default-selected | 状态栏右键菜单项全部勾选 | [./samples/menu/statusbar-context-menu-default-selected/](./samples/menu/statusbar-context-menu-default-selected/) |
| edit-richtext-by-double-clicking | 双击单元格编辑富文本 | [./samples/menu/edit-richtext-by-double-clicking/](./samples/menu/edit-richtext-by-double-clicking/) |
| delete-context-menu | 删除右键菜单 | [./samples/menu/delete-context-menu/](./samples/menu/delete-context-menu/) |
| change-context-menu-position | 修改右键菜单显示位置 | [./samples/menu/change-context-menu-position/](./samples/menu/change-context-menu-position/) |
| add-designer-multi-level-context-menu | 新增设计器-右键多层级菜单 | [./samples/menu/add-designer-multi-level-context-menu/](./samples/menu/add-designer-multi-level-context-menu/) |
| context-menu-add-seperator | 右键菜单添加分隔符 | [./samples/menu/context-menu-add-seperator/](./samples/menu/context-menu-add-seperator/) |

### 其他 (others)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| customize-statusbar | 自定义状态栏 | [./samples/others/customize-statusbar/](./samples/others/customize-statusbar/) |
| customize-statusbar-icon | 自定义状态栏图标 | [./samples/others/customize-statusbar-icon/](./samples/others/customize-statusbar-icon/) |
| statusbar-show-filtered-amount | 状态栏提示筛选数量 | [./samples/others/statusbar-show-filtered-amount/](./samples/others/statusbar-show-filtered-amount/) |
| register-pdf-font | 注册PDF字体 | [./samples/others/register-pdf-font/](./samples/others/register-pdf-font/) |
| history-view-rollback | 历史数据保存、查看与回滚 | [./samples/others/history-view-rollback/](./samples/others/history-view-rollback/) |
| draw-mario | 绘制超级马里奥 | [./samples/others/draw-mario/](./samples/others/draw-mario/) |
| embed-spread-in-popover | 在弹框中嵌入spread | [./samples/others/embed-spread-in-popover/](./samples/others/embed-spread-in-popover/) |
| dynamic-generate-flow-chart | 动态生成流程图 | [./samples/others/dynamic-generate-flow-chart/](./samples/others/dynamic-generate-flow-chart/) |
| custom-menu-hand-writing | 自定义右键菜单—手写签名 | [./samples/others/custom-menu-hand-writing/](./samples/others/custom-menu-hand-writing/) |
| cross-workbook-formula-reference | 跨工作簿公式引用 | [./samples/others/cross-workbook-formula-reference/](./samples/others/cross-workbook-formula-reference/) |
| support-tiff-image | 支持Tiff格式图片 | [./samples/others/support-tiff-image/](./samples/others/support-tiff-image/) |
| custom-name-manager | 自定制名称管理器 | [./samples/others/custom-name-manager/](./samples/others/custom-name-manager/) |
| remove-the-space-copied-from-styled-excel | 去除从Excel复制的单元格携带的空格 | [./samples/others/remove-the-space-copied-from-styled-excel/](./samples/others/remove-the-space-copied-from-styled-excel/) |
| hide-ascending-descending-order-option | 隐藏表格筛选中的升序降序选项 | [./samples/others/hide-ascending-descending-order-option/](./samples/others/hide-ascending-descending-order-option/) |
| three-methods-of-input-prompt | 多种输入提示实现方式 | [./samples/others/three-methods-of-input-prompt/](./samples/others/three-methods-of-input-prompt/) |
| sheet-tab-scroll-by-wheel | 标签页添加滚轮滚动功能 | [./samples/others/sheet-tab-scroll-by-wheel/](./samples/others/sheet-tab-scroll-by-wheel/) |
| spread-content-area-changes-with-dom-host | 表格区域大小跟随host元素变化 | [./samples/others/spread-content-area-changes-with-dom-host/](./samples/others/spread-content-area-changes-with-dom-host/) |
| workbook-global-search | 工作簿全局查找 | [./samples/others/workbook-global-search/](./samples/others/workbook-global-search/) |
| camershape-to-image | 照相机转换为图片 | [./samples/others/camershape-to-image/](./samples/others/camershape-to-image/) |
| custom-feature-serilization | 自定义特性序列化 | [./samples/others/custom-feature-serilization/](./samples/others/custom-feature-serilization/) |
| change-reportsheet-datasource | 更换报表数据源 | [./samples/others/change-reportsheet-datasource/](./samples/others/change-reportsheet-datasource/) |
| lp-solver | 规划求解 | [./samples/others/lp-solver/](./samples/others/lp-solver/) |
| pivottable-custom-sorting | 透视表自定义排序 | [./samples/others/pivottable-custom-sorting/](./samples/others/pivottable-custom-sorting/) |
| custom-range-selector | 自定义区域选择器 | [./samples/others/custom-range-selector/](./samples/others/custom-range-selector/) |

### 注册模板 (register-template)

| 英文名 | 中文名 | 链接 |
|---|---|---|
| register-linkage-selector-dialog-template | 联动弹窗 | [./samples/register-template/register-linkage-selector-dialog-template/](./samples/register-template/register-linkage-selector-dialog-template/) |
| add-customize-dialog | 自定义对话框 | [./samples/register-template/add-customize-dialog/](./samples/register-template/add-customize-dialog/) |
| remove-some-template-page | 删除Template部分功能 | [./samples/register-template/remove-some-template-page/](./samples/register-template/remove-some-template-page/) |