请参考附件demo,主要代码如下:
- // 设置自定义单元格
- function BindingPathCellType() {
- spreadNS.CellTypes.Text.call(this);
- }
- BindingPathCellType.prototype = new spreadNS.CellTypes.Text();
- BindingPathCellType.prototype.paint = function (ctx, value, x, y, w, h, style, context) {
- if (value === null || value === undefined) {
- var sheet = context.sheet, row = context.row, col = context.col;
- if (sheet && (row === 0 || !!row) && (col === 0 || !!col)) {
- var bindingPath = sheet.getBindingPath(context.row, context.col);
- if (bindingPath) {
- value = "[" + bindingPath + "]";
- }
- }
- }
- spreadNS.CellTypes.Text.prototype.paint.apply(this, arguments);
- };
- var bindingPathCellType = new BindingPathCellType();
复制代码
测试结果如下图:
|
|