Luckysheet config边框设置


Luckysheet在config设置中可以设置合并单元格信息 / 边框颜色 / 每行的高度 / 每列的宽度

1. 合并单元格信息
merge下的key为"r_c"的格式,指定了左上角单元格的位置信息,
"r":左上角单元格在第几行; "c":左上角单元格在第几列; "rs":合并的行数, "rs":合并的列数

例如:

"merge": {
   "13_5": {
    "r": 13,
    "c": 5,
    "rs": 3,
    "cs": 1
   },
   "13_7": {
    "r": 13,
    "c": 7,
    "rs": 3,
    "cs": 2
   },
   "14_2": {
    "r": 14,
    "c": 2,
    "rs": 1,
    "cs": 2
   }
  },

2. 边框信息

rangeType: "range" 或者 "cell"

rangeType为"range"时: borderType: "border-left" / "border-right" / "border-top" /"border-bottom" / "border-all" / "border-outside" / "border-inside" / "border-horizontal" / "border-vertical" / "border-none",
rangeType为"cell"时: 需要设置"l" / "r" / "t" / "b"

具体可以搜索源码 getBorderInfoCompute 查看
例如:

"borderInfo": [{
		"rangeType": "cell",
		"value": {
			"row_index": 3,
			"col_index": 3,
			"l": {
				"style": 10,
				"color": "rgb(255, 0, 0)"
			},
			"r": {
				"style": 10,
				"color": "rgb(255, 0, 0)"
			},
			"t": {
				"style": 10,
				"color": "rgb(255, 0, 0)"
			},
			"b": {
				"style": 10,
				"color": "rgb(255, 0, 0)"
			}
		}
	}, {
		"rangeType": "range",
		"borderType": "border-none",
		"style": "2",
		"color": "#000",
		"range": [{
			"row": [3, 3],
			"column": [3, 4]
		}]
	}]

综合配置信息,可以参考以下可执行的初始化配置:





	
	
	
	
	Luckysheet