{
"loopBlockList": [],
"querySetting": {
"izOpenQueryBar": false,
"izDefaultQuery": true
},
"recordSubTableOrCollection": { "group": [], "record": [], "range": [] },
"printConfig": {
"paper": "A4",
"width": 210,
"height": 297,
"definition": 4,
"isBackend": false,
"marginX": 10,
"marginY": 10,
"layout": "portrait",
"printCallBackUrl": "",
"paginationShow": false,
"paginationLocation": "middle",
"paginationStart": 1,
"headerFooterShow": false,
"headerLocation": "left",
"headerText": "",
"footerLocation": "left",
"footerText": "",
"fontsize": 28,
"rotationAngle": -45,
"watermarkColor": "#246DDE",
"watermarkText": "积木报表",
"watermarkShow": true,
"printFootorFixBottom": false
},
"hidden": { "rows": [], "cols": [], "conditions": { "rows": {}, "cols": {} } },
"queryFormSetting": { "useQueryForm": false, "dbKey": "", "idField": "" },
"dbexps": [],
"dicts": [],
"fillFormToolbar": {
"show": true,
"btnList": ["save", "subTable_add", "verify", "subTable_del", "print", "close", "first", "prev", "next", "paging", "total", "last", "exportPDF", "exportExcel", "exportWord"]
},
"freeze": "A1",
"dataRectWidth": 687,
"isViewContentHorizontalCenter": false,
"autofilter": {},
"validations": [],
"cols": {
"0": { "width": 34 },
"1": { "width": 119 },
"3": { "width": 117 },
"6": { "width": 117 },
"7": { "width": 22 },
"len": 100
},
"area": { "sri": 16, "sci": 4, "eri": 16, "eci": 4, "width": 100, "height": 25 },
"pyGroupEngine": false,
"submitHandlers": [],
"excel_config_id": "1162913845578612736",
"hiddenCells": [],
"zonedEditionList": [],
"rows": {
"1": {
"cells": {
"1": {
"merge": [0, 5],
"style": 2,
"text": "纵向员工信息登记表",
"height": 0
}
},
"height": 40
},
"2": {
"cells": {
"1": { "style": 15, "text": "部门" },
"2": { "style": 15, "text": "学历" },
"3": { "style": 15, "text": "性别" },
"4": { "style": 15, "text": "年龄" },
"5": { "style": 15, "text": "姓名" },
"6": { "style": 15, "text": "薪水" }
},
"height": 34
},
"3": {
"cells": {
"1": {
"style": 17,
"text": "#{vegvkdueqw.group(department)}",
"aggregate": "group",
"subtotal": "groupField",
"funcname": "-1",
"subtotalText": "合计"
},
"2": {
"style": 17,
"text": "#{vegvkdueqw.group(education)}",
"aggregate": "group",
"subtotal": "groupField",
"funcname": "-1",
"subtotalText": "小计"
},
"3": { "style": 17, "text": "#{vegvkdueqw.sex}" },
"4": { "style": 17, "text": "#{vegvkdueqw.age}" },
"5": { "style": 17, "text": "#{vegvkdueqw.name}" },
"6": { "style": 17, "text": "#{vegvkdueqw.salary}" }
},
"height": 54
},
"len": 100
},
"rpbar": { "show": true, "pageSize": "", "btnList": [] },
"groupField": "vegvkdueqw.department",
"fixedPrintHeadRows": [],
"fixedPrintTailRows": [],
"displayConfig": {},
"fillFormInfo": { "layout": { "direction": "horizontal", "width": 200, "height": 45 } },
"background": false,
"name": "sheet1",
"styles": [
{ "font": { "bold": true } },
{ "font": { "size": 16, "bold": true } },
{ "align": "center", "font": { "size": 16, "bold": true } },
{ "align": "center" },
{ "bgcolor": "#5b9cd6", "align": "center" },
{ "bgcolor": "#5b9cd6", "color": "#ffffff", "align": "center" },
{ "border": { "top": ["thin", "#000"], "left": ["thin", "#000"], "bottom": ["thin", "#000"], "right": ["thin", "#000"] }, "bgcolor": "#5b9cd6", "color": "#ffffff", "align": "center" },
{ "border": { "top": ["thin", "#000"], "left": ["thin", "#000"], "bottom": ["thin", "#000"], "right": ["thin", "#000"] } },
{ "border": { "top": ["thin", "#bfbfbf"], "left": ["thin", "#bfbfbf"], "bottom": ["thin", "#bfbfbf"], "right": ["thin", "#bfbfbf"] }, "bgcolor": "#5b9cd6", "color": "#ffffff", "align": "center" },
{ "border": { "top": ["thin", "#bfbfbf"], "left": ["thin", "#bfbfbf"], "bottom": ["thin", "#bfbfbf"], "right": ["thin", "#bfbfbf"] } },
{ "border": { "top": ["thin", "#9cc2e6"], "left": ["thin", "#9cc2e6"], "bottom": ["thin", "#9cc2e6"], "right": ["thin", "#9cc2e6"] }, "bgcolor": "#5b9cd6", "color": "#ffffff", "align": "center" },
{ "border": { "top": ["thin", "#9cc2e6"], "left": ["thin", "#9cc2e6"], "bottom": ["thin", "#9cc2e6"], "right": ["thin", "#9cc2e6"] } },
{ "border": { "top": ["thin", "#9cc2e6"], "left": ["thin", "#9cc2e6"], "bottom": ["thin", "#9cc2e6"], "right": ["thin", "#9cc2e6"] }, "bgcolor": "#bdd7ee", "color": "#ffffff", "align": "center" },
{ "border": { "top": ["thin", "#9cc2e6"], "left": ["thin", "#9cc2e6"], "bottom": ["thin", "#9cc2e6"], "right": ["thin", "#9cc2e6"] }, "bgcolor": "#bdd7ee", "color": "#000100", "align": "center" },
{ "border": { "top": ["thin", "#9cc2e6"], "left": ["thin", "#9cc2e6"], "bottom": ["thin", "#9cc2e6"], "right": ["thin", "#9cc2e6"] }, "bgcolor": "#9cc2e6", "color": "#000100", "align": "center" },
{ "border": { "top": ["thin", "#5b9cd6"], "left": ["thin", "#5b9cd6"], "bottom": ["thin", "#5b9cd6"], "right": ["thin", "#5b9cd6"] }, "bgcolor": "#9cc2e6", "color": "#000100", "align": "center" },
{ "border": { "top": ["thin", "#5b9cd6"], "left": ["thin", "#5b9cd6"], "bottom": ["thin", "#5b9cd6"], "right": ["thin", "#5b9cd6"] } },
{ "border": { "top": ["thin", "#5b9cd6"], "left": ["thin", "#5b9cd6"], "bottom": ["thin", "#5b9cd6"], "right": ["thin", "#5b9cd6"] }, "align": "center" }
],
"isGroup": true,
"freezeLineColor": "rgb(185, 185, 185)",
"merges": ["B2:G2"]
}
