1、配置Data validations，选值后回车，页面报错，界面不能操作。
2、vue中，当同时打开两个表格页面时，xs.on(‘cell-selected’)等监听事件会互相干涉，应该要做事件监听隔离。
3、前端合并行，json提交保存到数据库后，重新生成文件时报错
@feng.qun.zhu.avaryholding.com,
-
我能够重现您提到的问题。我发现从单元格中选择值时出现问题（已应用数据验证）。存在问题，选择并按下 Enter 键后矩阵没有响应。我已为您的问题记录了一张 ID 为“CELLSGRIDJS-1408”的票据。
-
和 3)。请向我们提供更多详细信息和示例代码片段/应用程序以重现该问题，我们将为这些问题添加适当的票证。
2、同一个页面，多个xs实例对象可以独立，他们的监听事件不会互相影响
3、我稍等看一下，能否提供实例
@feng.qun.zhu.avaryholding.com
2单页面多实例，已建单
Issue ID(s): CELLSGRIDJS-1409 Support multiple instances in one page
3请提供一下 sample文件。
@feng.qun.zhu.avaryholding.com
使用.net 版本没有报错
但是java 版本确实有问题
建单了 CELLSGRIDJS-1412 Fail to importExcelFileFromJson in GridJs java version for json string with merge area
您好，此三点，有修改时程吗？尤其第二点，不修复，vue系统多菜单情况下无法使用
可否提供临时版本，供我们开发使用？我们也可协助验证
@feng.qun.zhu.avaryholding.com
这次fix里面和你们相关的是这些单子
1.CELLSGRIDJS-1412
Fail to importExcelFileFromJson in GridJs java version for json string with merge area
2.CELLSGRIDJS-1409
Support multiple instances in one page
add js method xs.setActiveForMultipleInstance(isactive)
when there are more than one xs GridJs instances,we need to call:setActiveForMultipleInstance
we only support edit operation for one instances at a page.
for example,if we have two instances: xs1 and xs2 in one html page.
if we need to keep edit operation in xs1,
we shall call:
xs1.setActiveForMultipleInstance(true);
xs2.setActiveForMultipleInstance(false);
3.CELLSGRIDJS-1393
Support js event for update cell
xs.on('cells-updated', (name, cells) => {
console.log('cells updated for sheet name:', name);
cells.forEach((acell, index, array) => {
console.log('acell got updated:', acell);
})
}).on('cells-deleted', (range) => {
console.log('cells deleted :', range);
})
4.CELLSGRIDJS-1366
Support row/column insert/delete event for client api
xs.on('rows-deleted', (ri, n) => {
console.log('rows-deleted :', ri, ",size", n);
}).on('columns-deleted', (ci, n) => {
console.log('columns-deleted :', ci, ",size", n);
}).on('rows-inserted', (ri, n) => {
console.log('rows-inserted :', ri, ",size", n);
}).on('columns-inserted', (ci, n) => {
console.log('columns-inserted :', ci, ",size", n);
});
5.CELLSGRIDJS-1388
HTML page input text box get affected by GridJs
6.CELLSGRIDJS-1368
Support pre-check event for row/column delete/insert operation
xs.checkRowInsert = (ri, size) => { if (ri % 2 == 1) return true; else return false; };
xs.checkColumnInsert = (ci, size) => { if (ci % 2 == 1) return true; else return false; };
xs.checkRowDelete = (ri, size) => { if (ri % 2 == 1) return true; else return false; };
xs.checkColumnDelete = (ci, size) => { if (ci % 2 == 1) return true; else return false; };
if return false,the insert/delete will not go on.
7.CELLSGRIDJS-1406 Formulas are not removed when deleting cells with formulas
8.CELLSGRIDJS-1395
Support api to show html node and interact with html node at specified cell position
add xs.sheet.showHtmlAtCell(isShow,html,ri,ci,deltX,deltY)
please note in order to response to html event,GridJs default event will be disabled when the html node is show,you can not select any cell/do edit operation until the html is hide.
//show any html at cell A1
xs.sheet.showHtmlAtCell(true,"<span>html span</span><input length=30 id='myinput'>test</input>",0,0)
//hide
xs.sheet.showHtmlAtCell(false)