怎么清除自定义单元格的类型

Fiooona

export class LibraryUpdate extends GC.Spread.Sheets.CellTypes.Text {
constructor() {
super()
this._width = 0;
this._url = "";
this.typeName = 'libraryUpdate'
}
paint(ctx, value, x, y, w, h, style, context) {
if (!ctx) {
return
}
this._url = value;
this._width = parseInt(ctx.measureText(value).width.toString()) + 3;
ctx.save();
ctx.rect(x, y, w, h);
ctx.clip();
ctx.font = style.font;
ctx.fillStyle = style.foreColor;
const v = !!value ? (this.textValue || '') + value : ''
const backgroundImgStyle = new GC.Spread.Sheets.Style();
backgroundImgStyle.backgroundImageLayout = GC.Spread.Sheets.ImageLayout.stretch;
backgroundImgStyle.backgroundImage = 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAAAXNSR0IArs4c6QAABgNJREFUWAntWFtsVEUY/v85u6W09hINAhUbaukWGuQiagpNwKU1aiIvGghiovFBfQCJgAZqotFgWvECCRIToy+aiCBRNBglse0CCRQNd7DA9qYotxCSXpey2zPjN3tpz27Pnt2lwINhktmZM/NfvvOfmW/+WaI7ZXQR4HTVv1OLjXbfyVlEaiYpVaGISlmpCYp4PGwUwNAYzGVH7PEA5q+j382kLivmS5hvJ+YWIj5e6n3w2BLeYabj2xGgz/eY66C8sAjOXgAYL9qCdIymkoHTboD2of26UhTt8nr3DCbTSQrwg0bPUwD0mVJq8rAydzLTQUTiNBTPsqQrzKLbFKIn18jqpokTesKyFy/l95vBAkPKfKVkgRI0DrbKEflpSlElIl1itSmYlq+r9v86PDbcswVY31j2HES+gTHg4ZNKqC8NHvvDWu+Jf4dVb7y3wTdjkqmuPUOKXkadDifAT8/XVrd+m2g1CUBPHyKXizdbuXahfwszawM3vcAHb2jyrJCKNsNHf221/65EJyJxQD9rcHbjt3IsmU/bCNY1lA1F7HZ84tiLv1XTOgLPiAEtPAyQOxMXtN4kWDItxMKfySYhJT1Y0hV2myTmww6gK4berp1rFHniaUaVwEFJOLxKRlR0C0brM4NEf7fFmRnijqgogITnEZU4mmk2z4fiFC0PjgCj/LQT8jtvHVH79RezQIrvOgK0ikaZ/zDGdB1lOZO2vu0uTls7Q8H6xvL36xrL12eidlsBgr8W48hckgnAtD9xJkaTyeYb7jnJ5pKNOwKsa/TUZwn66g2vP/1Fk8wTxpd7/+yzTn/s80wNSnoRkbUOx/VT8GBEFsfQ76CIXYqpYYp31qF0U6U4T3jQTNC559QjSg7WSOJFAPaoVcaOB50BMn+h1wzebzjNYupixSBragFgZDXKT+y+6jZEj5CuXu3wujuUT0GVRyp0D/K/cugji1EV0Km02sJzN+a3K1KvaL2MAWqFjQfmjg0Frj4Brn0cNmpgzKON3WjB0elH+vWbIanhXqNo90vePQOxk8sOoOMa1CBWz2u+hubHaKVP9k6/P2SGHsLn0bndVERxCqJYiH4+MeVpHeQ+Pej34mhDtKlN54862gaPORKfsvm1uGNJCTBRe82CU/9gTNefEudSPX/UUD4D9e43a86eSCUbm88YYEzxRtoQq1+iepPS1b+tAFnQmnSBxeQcAdY1lW1gw72tdkHL0ZjCaNpar3+7Vb9+b8VsZYaW0lC2Y52N9J1pJiqPndeBRb8Pj/vdyn0grzC79dWHDydNkUa6Ifr80Bx3b9dAWYhD8zBfhcxrPhjhAaus3S52BAiC3gIji2FM332HCpT0nfY8agd25wXwYh+uLQHJHNBCQqkcEDGuDSoXu7gIQxrIfeBAQ88PFabLePkd4MgVeswOoOMnxiXmNbD/6381nZopabAKd5wqOAH7q2K0xbBZrHNQvETktIoeWZEvhgmUyC+oJ/xSuLYS/YGX2S/ItX/ywunH9akEHgwDDCsk/DgC1LLRY+0Iurp+qsfCF3rXhWIa1JHh8SwjEdOR0/M6koJUvxI6ouoyuaijcrDo3MgL+mkt7lhSArTTjjrqwJyuaRY/aR7Uwv8rHhR2rx+96WNdvWs7b6eTzpjmwUQu1BmO1o35TLRju4vx10cr1jvOWFqfbeRuXOU91pWoeDOeN/lmFQ6Y/auxkd4GwDb89THi9mQPsGnqs0rKrVjgWRDQf6P9LEhsG5uVs3fl/KNXRgNu877Z464FAwskyaWw8zTA4W87DrIQy2oXnvk+0bYtQC30YVN5lankO4hkDR6HPjV4C1tPNYMjW5GttAtBnZJcXdmG7L+ekxPmwTGBQM6AKXIFDRZKSSXIdkrBdYgOzwUhTYuBgHMT/NPIZLy3rvrMgdi4tU0KMCa0ad+0iQNBcxmen0TVDkb1vw1esB92mlF3Z2cZW1fNP30R/aQlJUCrpj6uunoDc/D5ZwNoKT5PKaJZjNMCeWDk5IjIaxDgQeSEGD8HJ+1o24QQxwrzcg5nekxaMdzp/+8i8B8KmJr5niajJAAAAABJRU5ErkJggg=='
const newX = context.sheet.getColumnWidth(context.col)
GC.Spread.Sheets.CellTypes.Text.prototype.paint.call(this, ctx, v, x, y, w, h, style, context);
GC.Spread.Sheets.CellTypes.Text.prototype.paint.call(this, ctx, "", x + newX / 2 - 10, y + 3, 20, 20, backgroundImgStyle, context);
ctx.restore();
}
getHitInfo = function (x, y, cellStyle, cellRect, context) {
var info = {
x: x,
y: y,
row: context.row,
col: context.col,
cellStyle: cellStyle,
cellRect: cellRect,
sheetArea: context.sheetArea
};
if (x >= cellRect.x && x <= cellRect.x + this._width && y >= cellRect.y && y <= cellRect.y + this._width) {
info.isReservedLocation = true;
}
return info;
}
processMouseMove(hitInfo) {
var sheet = hitInfo.sheet;
var div = sheet.getParent().getHost();
var canvasId = div.id + "vp_vp";
var canvas = $("#" + canvasId)[0];
var offset = $('#vp_vp').offset()
if (sheet && hitInfo.isReservedLocation) {
if (this._toolTipElement) {
$(this._toolTipElement).text(this.tooltip)
.css("top", offset.top - 35 + hitInfo.y)
.css("left", hitInfo.x + 70);
if (this.tooltip.length > 100) {
$(this._toolTipElement).css("top", offset.top - 75 + hitInfo.y);
}
} else if (this.tooltip) {
var div = document.createElement("div");
$(div).css("position", "absolute")
.css("border", "1px #C0C0C0 solid")
.css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
.css("font", "9pt Arial")
.css("background", "white")
.css('white-space', 'pre-line')
.css("padding", 5);
this._toolTipElement = div;
$(this._toolTipElement).text(this.tooltip)
.css("top", offset.top - 35 + hitInfo.y)
.css("left", hitInfo.x + 70);
if (this.tooltip.length > 100) {
$(this._toolTipElement).css("max-width", "500px").css("top", offset.top - 75 + hitInfo.y);
}
$(this._toolTipElement).hide();
canvas.parentElement.insertBefore(this._toolTipElement, null);
$(this._toolTipElement).show("fast");
}
canvas.style.cursor = 'pointer';
return true;
} else {
canvas.style.cursor = 'default';
}
return false;
}
processMouseLeave = function (hitInfo) {
if (this._toolTipElement) {
const sheet = hitInfo.sheet;
const div = sheet.getParent().getHost();
const canvasId = div.id + "vp_vp";
const canvas = $("#" + canvasId)[0];
canvas.parentElement.removeChild(this._toolTipElement);
this._toolTipElement = null;
}
}
processMouseUp(hitInfo) {
return false;
}
linkToolTip(value) {
this.tooltip = value
}
text(value) {
this.textValue = value
}
}

复制代码

自定义的单元格，怎么清除

Fiooona · Fiooona

清除自定义单元格： setCellType(0,0,null) 可以删除原先设置的单元格类型，

		自动登录	找回密码
密码			立即注册

[已处理] 怎么清除自定义单元格的类型

最佳答案

1 个回复

浏览过的版块

微信认证勋章