【16.2.5】可以粘贴图片，但是图片无法被选中，无法被删除

Joestar.Xu

本帖最后由哗啦啦于 2024-6-4 10:31 编辑

【可以粘贴图片，但是图片无法被选中，无法被删除】

我想把表格中粘贴进去的图片能选中然后删除
下面是我的程序粘贴进去的
图片以html 的节点行是存在的
图片无法被选中
image.png848575439.png

这个是代码

看到官网上的案例是图片是canvas中的一个元素而非html的节点

Joestar.Xu · Joestar.Xu

您好，这是因为您的表单是被保护的状态，且没有勾选这个选项，导致图片对象无法被拖动，勾选上后重新保护即可：

image.png149792784.png

对应的接口为：https://demo.grapecity.com.cn/sp ... ns#alloweditobjects

哗啦啦 · 哗啦啦

[code] designerInitialized() {
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteOptions'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteAll'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteFormula'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteFormatting'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteValues') && !item.name.includes('pasteValuesFormatting'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('pasteFormulaFormatting'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('insertSheet'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('hideSheet'))
}
})
this.spread.contextMenu.menuData = this.spread.contextMenu.menuData.filter((item) => {
if (typeof (item.name) === 'string') {
return !(item.name.includes('deleteSheet'))
}
})
// console.log('this.spread.contextMenu.menuData11', this.spread.contextMenu.menuData)
this.spread.contextMenu.menuData.forEach(item => {
if (item.name.includes('pasteValuesFormatting')) {
item.text = '粘贴'
}
})
var fbx = new GC.Spread.Sheets.FormulaTextBox.FormulaTextBox(document.getElementById('formulaBox'))
new GC.Spread.Sheets.NameBox.NameBox('addressBox', this.spread)
fbx.workbook(this.spread)
// 阻止用户重命名sheet
this.spread.options.tabEditable = false
// 阻止用户添加表单
this.spread.options.newTabVisible = false
this.spread.options.scrollByPixel = true
// 楷体
registerServerFont('楷体', 'normal', './fonts_grapecity/simkai.ttf')
registerServerFont('Calibri', 'normal', './fonts_grapecity/calibri.ttf')
registerServerFont('Cambria', 'normal', './fonts_grapecity/cambriab.ttf')
// 默认导出宋体
registerFallbackFont('./fonts_grapecity/songti.ttf')
this.spread.options.grayAreaBackColor = 'white'
// 查询或报送管理或财务三大报表跳转而来
if (this.$route.query.pageId || this.$route.query.itype) {
this.viewReport()
} else {
this.onloadGetdata()
}
this.spread.bind(GC.Spread.Sheets.Events.ColumnChanged, (e, info) => {
this.isFileModified = true
})
this.spread.bind(GC.Spread.Sheets.Events.RowChanged, (e, info) => {
this.isFileModified = true
})
// 去掉监测活动表单
// this.spread.bind(GC.Spread.Sheets.Events.SheetChanged, (e, info) => {
// this.isFileModified = true
// })
this.spread.bind(GC.Spread.Sheets.Events.RowHeightChanged, (e, info) => {
this.isFileModified = true
})
this.spread.bind(GC.Spread.Sheets.Events.ColumnWidthChanged, (e, info) => {
this.isFileModified = true
})
this.spread.bind(GC.Spread.Sheets.Events.ActiveSheetChanging, (sender, args) => {
this.$refs.popbox.style.display = 'none'
})
this.spread.bind(GC.Spread.Sheets.Events.EditChange, (sender, args) => {
this.cellValue = args.editingText
})
this.spread.bind(GC.Spread.Sheets.Events.TopRowChanged, (sender, args) => {
this.$refs.popbox.style.display = 'none'
})
this.spread.bind(GC.Spread.Sheets.Events.LeftColumnChanged, (sender, args) => {
this.$refs.popbox.style.display = 'none'
})
this.spread.bind(GC.Spread.Sheets.Events.EditStarting, (s, e) => {
if (this.paramdatainput && this.paramdatainput === '1') {
const sheet = e.sheet; const row = e.row; const col = e.col; const cell = sheet.getCell(row, col)
const formula = cell.formula()
if (formula) {
// const tag = cell.tag() || {}
// tag.formula = formula
cell.formula(undefined)
// cell.tag(tag)
sheet.startEdit()
}
}
})
this.spread.bind(GC.Spread.Sheets.Events.ActiveSheetChanged, (s, e) => {
this.cellValue = this.getActiveCellInfo(this.spread)
})
// 监听键盘上下左右动态显示单元格值
this.spread.bind(GC.Spread.Sheets.Events.SelectionChanged, async(e, info) => {
console.log('SelectionChanged')
const args = info.newSelections[0]
const sheetnow = info.sheet
const sheetname = info.sheetName
this.cellValue = this.getActiveCellInfo(this.spread)
var deletedCellFormula = ''
this.workSheetAllFormulaCells.forEach(item => {
if (item.irow === args.row && item.icol === args.col && item.csheetName === sheetname) {
deletedCellFormula = item.cformula
}
})
if (sheetnow.hasFormula(args.row, args.col) || deletedCellFormula) {
const formula = sheetnow.getFormula(args.row, args.col) || deletedCellFormula
this.formulatype = formula.slice(0, 4)
var positionInfo = sheetnow.getCellRect(args.row, args.col)
this.$refs.popbox.style.top = this.showBtn ? positionInfo.y + 98 + (positionInfo.height) / 2 + 'px' : positionInfo.y + 22 + (positionInfo.height) / 2 + 'px'
this.$refs.popbox.style.left = positionInfo.x + positionInfo.width + 19 + 'px'
var isShow = formula.includes('ACCT') || formula.includes('XJLL') || formula.includes('VOUCHERACCT') || formula.includes('REF')
if (!isShow) {
this.$refs.popbox.style.display = 'none'
return
}
this.$refs.popbox.style.display = 'block'
if (sheetnow.toJSON().names) {
var names = sheetnow.toJSON().names
// 获取单元格设置的名称管理器
for (var i = 0; i < names.length; i++) {
if (Number(names[i].row) === args.row && Number(names[i].col) === args.col) {
this.cformulaname = names[i].name
}
}
}
const data = {
corgnid: this.cjoborgnid,
creportid: this.creportid,
creporthistoryid: this.creporthistoryid,
ctype: '1',
cell: {
csheetname: args.sheetName,
cformulaname: this.cformulaname,
cformula: sheetnow.getFormula(args.row, args.col) || deletedCellFormula
},
iperiodclass: this.iperiodclassUsedByipeiodchanged,
iyear: this.yearValue,
iperiod: Number(this.iperiod),
iendperiod: Number(this.iendperiod),
include: this.iincludeaccount ? 1 : 0,
idigits: this.decimalNumber
}
this.fullscreenLoading_popbox = true
await viewsourse(data).then(res => {
if (this.cformulaname === data.cell.cformulaname) {
this.fullscreenLoading_popbox = false
this.sourcedata = res
}
})
} else {
this.$refs.popbox.style.display = 'none'
}
})
},

复制代码

[/code]

Joestar.Xu · Joestar.Xu

您好，我看了一下您提供的代码，没有发现明显的错误会导致这个问题，还需要您提供一下相关的JSON，这边本地测试一下看看是否和JSON相关，或者直接提供一个可以复现此问题的Demo，只要能够复现就行。

哗啦啦 · 哗啦啦

哗啦啦发表于 2024-6-4 10:24
[/code]

谢谢您附件中就是json的数据

哗啦啦 · 哗啦啦

Joestar.Xu 发表于 2024-6-4 18:01
您好，我看了一下您提供的代码，没有发现明显的错误会导致这个问题，还需要您提供一下相关的JSON，这边本地 ...

谢谢您 json的数据在附件中

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

[已处理] 【16.2.5】可以粘贴图片，但是图片无法被选中，无法被删除

最佳答案

5 个回复

SpreadJS 认证

SpreadJS 高级认证