本帖最后由 Dtttax 于 2019-5-26 13:58 编辑
升级到v12.1.0,同样的代码，不同的电脑，有的会有这个问题，有的没有这个问题。都是一样的node 和npm版本。如果升级最新的nodejs全部都是报这个错误
删除的时候重新排序比如有A,A2,A3,A4,如果删除了A2,就把A3改为A2 A4改为A3.
主要代码：
spread.removeSheet(spread.getSheetIndex(sheetName))
let name="A2"
let originName="A1"
const [prefix] = name
const regexp = new RegExp('^' + prefix)
if (originName.startsWith(prefix) ) {
let deleteIndex = +name.replace(regexp, '')
spread.sheets.map(v => {
return {
n: v.name(),
ref: v
}
})
.filter(v => v.n.startsWith(prefix))
.filter(v => +v.n.replace(regexp, '') > deleteIndex)
.forEach(v => {
let suffix = v.n.replace(regexp, '')
if(suffix == '2'){
suffix = ''
}else{
suffix = parseInt(suffix)-1
}
v.ref.name(prefix + suffix)
refreshSheetLink(spread,v.ref)
})
}
执行到这里v.ref.name(prefix + suffix)就报以下错误。
asyncToGenerator.js?74f6:20 Uncaught (in promise) TypeError: Cannot read property 'getRowCount' of null
at oa.getRowCount (gc.spread.sheets.all.min.js?c74a:29)
at b.getRowCount (gc.spread.sheets.all.min.js?c74a:32)
at a.getWorkingNodeInfo (gc.spread.sheets.all.min.js?c74a:31)
at a.ATa (gc.spread.sheets.all.min.js?c74a:31)
at a.getFormula (gc.spread.sheets.all.min.js?c74a:31)
at a.setFormula (gc.spread.sheets.all.min.js?c74a:31)
at z (gc.spread.sheets.all.min.js?c74a:34)
at Function.o.adjustModelFormulasAfterSetSheetName (gc.spread.sheets.all.min.js?c74a:34)
at oa.setName (gc.spread.sheets.all.min.js?c74a:34)
at Function.a.ao (gc.spread.sheets.all.min.js?c74a:25)
如果点击其他sheet.就报下面错误：这个错误主要是在切换表的时候执行了
sheet.setFormula(row, col,"=0") 这个地方就开始报下面的错误了。
Uncaught (in promise) TypeError: Cannot read property 'getRowCount' of null
at oa.getRowCount (gc.spread.sheets.all.min.js?c74a:29)
at b.getRowCount (gc.spread.sheets.all.min.js?c74a:32)
at a.rC (gc.spread.sheets.all.min.js?c74a:31)
at a.initDelay (gc.spread.sheets.all.min.js?c74a:32)
at a.Gg (gc.spread.sheets.all.min.js?c74a:17)
at a.recalculateAll (gc.spread.sheets.all.min.js?c74a:17)
at a.resume (gc.spread.sheets.all.min.js?c74a:17)
at oa.resumeCalcService (gc.spread.sheets.all.min.js?c74a:33)
at sheetTabClick (refresh-sheet.js?16dd:848)
at activeSheetChanged (spread-ptc-extension.js?85a1:11252) |
陕公网安备：61019002000258 |
隐私政策 |
网站地图
