Page History

JavaScript

Copy Code

//

自定义单元格

         function FivePointedStarCellType() {             this.fillStyle = "orange";             this.size = 10;         }         FivePointedStarCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();         FivePointedStarCellType.prototype.paint = function (ctx, value, x, y, w, h, style, context) {              if (!ctx) {                 return;             }
            ctx.save();
            //

画在单元格的边界内

            ctx.rect(x, y, w, h);             ctx.clip();             ctx.beginPath();
            if (value) {                 ctx.fillStyle = this.fillStyle;             } else {                 ctx.fillStyle = "gray";             }
            var size = this.size;             var dx = x + w / 2;             var dy = y + h / 2;             ctx.beginPath();             var dig = Math.PI / 5 * 4;             for (var i = 0; i < 5; i++) {                 ctx.lineTo(dx + Math.sin(i * dig) * size, dy + Math.cos(i * dig) * size);             }             ctx.closePath();             ctx.fill();
            ctx.restore();         };         FivePointedStarCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {             var xm = cellRect.x + cellRect.width / 2,                      ym = cellRect.y + cellRect.height / 2,                     size = 10;             var info = { x: x, y: y, row: context.row, col: context.col, cellRect: cellRect, sheetArea: context.sheetArea };             if (xm - size <= x && x <= xm + size && ym - size <= y && y <= ym + size) {                 info.isReservedLocation = true;             }             return info;         };         FivePointedStarCellType.prototype.processMouseUp = function (hitInfo) {             var sheet = hitInfo.sheet;             if (sheet && hitInfo.isReservedLocation) {                 var row = hitInfo.row, col = hitInfo.col, sheetArea = hitInfo.sheetArea;                 var newValue = !sheet.getValue(row, col, sheetArea);                 var cellEditInfo = { row: row, col: col, newValue: newValue };        spread.commandManager().execute({cmd: "editCell", sheetName: activeSheet.name(), row: row, col: col, newValue: newValue});                 return true;             }             return false;         };
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="8429acda-79c4-4170-8f31-78a86f66581f"><ac:plain-text-body><![CDATA[        function FullNameCellType() {         }         FullNameCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();         FullNameCellType.prototype.paint = function (ctx, value, x, y, w, h, style, context) {             if (value) {                 GC.Spread.Sheets.CellTypes.Base.prototype.paint.apply(this, [ctx, value.firstName + "." + value.lastName, x, y, w, h, style, context]);             }         };          FullNameCellType.prototype.updateEditor = function (editorContext, cellStyle, cellRect, context) {             if (editorContext) {                 $(editorContext).width(cellRect.width);                 $(editorContext).height(100);             }         };         FullNameCellType.prototype.createEditorElement = function (context) {             var div = document.createElement("div");             var $div = $(div);             $div.attr("gcUIElement", "gcEditingInput");             $div.css("background-color", "white");             $div.css("position", "absolute");             $div.css("overflow", "hidden");             $div.css("border", "2px #5292f7 solid");             var $span1 = $("<span></span>");             $span1.css("display", "block");             var $span2 = $("<span></span>");             $span2.css("display", "block");             var $input1 = $("<input type='text'/>");             var $input2 = $("<input type='text'/>");             $div.append($span1);             $div.append($input1);             $div.append($span2);             $div.append($input2);             return div;         };         FullNameCellType.prototype.getEditorValue = function (editorContext) {             if (editorContext && editorContext.children.length === 4) {                 var input1 = editorContext.children[1];                 var firstName = $(input1).val();                  var input2 = editorContext.children[3];                 var lastName = $(input2).val();                 return { firstName: firstName, lastName: lastName };             }         };         FullNameCellType.prototype.setEditorValue = function (editorContext, value) {             if (editorContext && editorContext.children.length === 4) {                 var span1 = editorContext.children[0];                 $(span1).text("First Name:");                 var span2 = editorContext.children[2];                 $(span2).text("Last Name:");                 if (value) {                     var input1 = editorContext.children[1];                     $(input1).val(value.firstName);                     var input2 = editorContext.children[3];                     $(input2).val(value.lastName);                 }             }         };         FullNameCellType.prototype.isReservedKey = function (e, context) {             //

单元格将会自己处理 Tab键

           return (e.keyCode === GC.Spread.Commands.Key.tab && !e.ctrlKey && !e.shiftKey && !e.altKey);         };         FullNameCellType.prototype.isEditingValueChanged = function (oldValue, newValue,context) {             if (newValue.firstName != oldValue.firstName