本帖最后由 齐天大猫 于 2022-7-6 16:45 编辑
(图1)
(图2)
spreadjson中已保存A列排序信息,在与数据绑定后排序条件失效(图2)。
核心代码:
//加载模板
let spread = this.designer.getWorkbook();
let activeSheet = spread.getActiveSheet();
activeSheet.showRow(1, GC.Spread.Sheets.VerticalPosition.top);
spread.fromJSON(template);
//绑定数据
var table = sheet.tables.find(udataTable.rowRange.start, udataTable.colRange.start);
sheet.setColumnCount(udataTable.colRange.start + this.columnCountMax + 100, GC.Spread.Sheets.SheetArea.viewport);//新增
sheet.setRowCount(udataTable.rowRange.start + this.rowCountMax + 100, GC.Spread.Sheets.SheetArea.viewport);
sheet.showRow(0, GC.Spread.Sheets.VerticalPosition.top);//滚动条位置设置
table.bind(tableColumns, "data", tableData);
|