From f8c9905e15777052c4628602b41cad70ac8c782b Mon Sep 17 00:00:00 2001 From: licp <lichunping@guanfang.com.cn> Date: 星期五, 05 七月 2024 12:53:57 +0800 Subject: [PATCH] 修改luckysheet 源码 --- static/luckysheet/demoData/sheetPivotTable.js | 376 ++++++++++++++++++++++++++-------------------------- 1 files changed, 188 insertions(+), 188 deletions(-) diff --git a/static/luckysheet/demoData/sheetPivotTable.js b/static/luckysheet/demoData/sheetPivotTable.js index b938b41..8c33648 100644 --- a/static/luckysheet/demoData/sheetPivotTable.js +++ b/static/luckysheet/demoData/sheetPivotTable.js @@ -1,189 +1,189 @@ -window.sheetPivotTable = { - "name": "PivotTable", - "color": "", - "config": {}, - "index": "7", - "chart": [], - "status": 0, - "order": "7", - "column": 18, - "row": 36, - "celldata": [{ - "r": 0, - "c": 0, - "v": "count:score" - }, { - "r": 0, - "c": 1, - "v": "science" - }, { - "r": 0, - "c": 2, - "v": "mathematics" - }, { - "r": 0, - "c": 3, - "v": "foreign language" - }, { - "r": 0, - "c": 4, - "v": "English" - }, { - "r": 0, - "c": 5, - "v": "total" - }, { - "r": 1, - "c": 0, - "v": "Alex" - }, { - "r": 1, - "c": 1, - "v": 1 - }, { - "r": 1, - "c": 2, - "v": 1 - }, { - "r": 1, - "c": 3, - "v": 1 - }, { - "r": 1, - "c": 4, - "v": 1 - }, { - "r": 1, - "c": 5, - "v": 4 - }, { - "r": 2, - "c": 0, - "v": "Joy" - }, { - "r": 2, - "c": 1, - "v": 1 - }, { - "r": 2, - "c": 2, - "v": 1 - }, { - "r": 2, - "c": 3, - "v": 1 - }, { - "r": 2, - "c": 4, - "v": 1 - }, { - "r": 2, - "c": 5, - "v": 4 - }, { - "r": 3, - "c": 0, - "v": "Tim" - }, { - "r": 3, - "c": 1, - "v": 1 - }, { - "r": 3, - "c": 2, - "v": 1 - }, { - "r": 3, - "c": 3, - "v": 1 - }, { - "r": 3, - "c": 4, - "v": 1 - }, { - "r": 3, - "c": 5, - "v": 4 - }, { - "r": 4, - "c": 0, - "v": "total" - }, { - "r": 4, - "c": 1, - "v": 3 - }, { - "r": 4, - "c": 2, - "v": 3 - }, { - "r": 4, - "c": 3, - "v": 3 - }, { - "r": 4, - "c": 4, - "v": 3 - }, { - "r": 4, - "c": 5, - "v": 12 - }], - "ch_width": 4748, - "rh_height": 1790, - "luckysheet_select_save": [{ - "row": [0, 0], - "column": [0, 0] - }], - "luckysheet_selection_range": [], - "scrollLeft": 0, - "scrollTop": 0, - "isPivotTable": true, - "pivotTable": { - "pivot_select_save": { - "left": 0, - "width": 73, - "top": 0, - "height": 19, - "left_move": 0, - "width_move": 369, - "top_move": 0, - "height_move": 259, - "row": [0, 12], - "column": [0, 4], - "row_focus": 0, - "column_focus": 0 - }, - "pivotDataSheetIndex": 6, //The sheet index where the source data is located - "column": [{ - "index": 3, - "name": "subject", - "fullname": "subject" - }], - "row": [{ - "index": 1, - "name": "student", - "fullname": "student" - }], - "filter": [], - "values": [{ - "index": 4, - "name": "score", - "fullname": "count:score", - "sumtype": "COUNTA", - "nameindex": 0 - }], - "showType": "column", - "pivotDatas": [ - ["count:score", "science", "mathematics", "foreign language", "English", "total"], - ["Alex", 1, 1, 1, 1, 4], - ["Joy", 1, 1, 1, 1, 4], - ["Tim", 1, 1, 1, 1, 4], - ["total", 3, 3, 3, 3, 12] - ], - "drawPivotTable": false, - "pivotTableBoundary": [5, 6] - } -} - +window.sheetPivotTable = { + "name": "PivotTable", + "color": "", + "config": {}, + "index": "7", + "chart": [], + "status": 0, + "order": "7", + "column": 18, + "row": 36, + "celldata": [{ + "r": 0, + "c": 0, + "v": "count:score" + }, { + "r": 0, + "c": 1, + "v": "science" + }, { + "r": 0, + "c": 2, + "v": "mathematics" + }, { + "r": 0, + "c": 3, + "v": "foreign language" + }, { + "r": 0, + "c": 4, + "v": "English" + }, { + "r": 0, + "c": 5, + "v": "total" + }, { + "r": 1, + "c": 0, + "v": "Alex" + }, { + "r": 1, + "c": 1, + "v": 1 + }, { + "r": 1, + "c": 2, + "v": 1 + }, { + "r": 1, + "c": 3, + "v": 1 + }, { + "r": 1, + "c": 4, + "v": 1 + }, { + "r": 1, + "c": 5, + "v": 4 + }, { + "r": 2, + "c": 0, + "v": "Joy" + }, { + "r": 2, + "c": 1, + "v": 1 + }, { + "r": 2, + "c": 2, + "v": 1 + }, { + "r": 2, + "c": 3, + "v": 1 + }, { + "r": 2, + "c": 4, + "v": 1 + }, { + "r": 2, + "c": 5, + "v": 4 + }, { + "r": 3, + "c": 0, + "v": "Tim" + }, { + "r": 3, + "c": 1, + "v": 1 + }, { + "r": 3, + "c": 2, + "v": 1 + }, { + "r": 3, + "c": 3, + "v": 1 + }, { + "r": 3, + "c": 4, + "v": 1 + }, { + "r": 3, + "c": 5, + "v": 4 + }, { + "r": 4, + "c": 0, + "v": "total" + }, { + "r": 4, + "c": 1, + "v": 3 + }, { + "r": 4, + "c": 2, + "v": 3 + }, { + "r": 4, + "c": 3, + "v": 3 + }, { + "r": 4, + "c": 4, + "v": 3 + }, { + "r": 4, + "c": 5, + "v": 12 + }], + "ch_width": 4748, + "rh_height": 1790, + "luckysheet_select_save": [{ + "row": [0, 0], + "column": [0, 0] + }], + "luckysheet_selection_range": [], + "scrollLeft": 0, + "scrollTop": 0, + "isPivotTable": true, + "pivotTable": { + "pivot_select_save": { + "left": 0, + "width": 73, + "top": 0, + "height": 19, + "left_move": 0, + "width_move": 369, + "top_move": 0, + "height_move": 259, + "row": [0, 12], + "column": [0, 4], + "row_focus": 0, + "column_focus": 0 + }, + "pivotDataSheetIndex": 6, //The sheet index where the source data is located + "column": [{ + "index": 3, + "name": "subject", + "fullname": "subject" + }], + "row": [{ + "index": 1, + "name": "student", + "fullname": "student" + }], + "filter": [], + "values": [{ + "index": 4, + "name": "score", + "fullname": "count:score", + "sumtype": "COUNTA", + "nameindex": 0 + }], + "showType": "column", + "pivotDatas": [ + ["count:score", "science", "mathematics", "foreign language", "English", "total"], + ["Alex", 1, 1, 1, 1, 4], + ["Joy", 1, 1, 1, 1, 4], + ["Tim", 1, 1, 1, 1, 4], + ["total", 3, 3, 3, 3, 12] + ], + "drawPivotTable": false, + "pivotTableBoundary": [5, 6] + } +} + // export default sheetPivotTable; \ No newline at end of file -- Gitblit v1.9.3