本帖最后由 Dtttax 于 2019-5-23 14:25 编辑
请问 SpreadJS 数据绑定时 能否做到 两级标题呢？ 然后 子标题 可以做 排序/过滤/group ungroup效果类似这样
然后对数据绑定的 可以设置 一部分区域可以编辑， 一部分不能编辑。
在vue下，workbookInitialized 之后调用这个方法，报错. 但是这段代码 只用编辑成 html，在浏览器中打开报错！ 请问这里需要如何解决
const func2 = (spread) => {
var spreadNS = GC.Spread.Sheets;
//Get sheet instance
spread.suspendPaint();
var sheet = spread.getActiveSheet()
sheet.name("FINANCE CHARGE");
var table = sheet.tables.add("tableRecords", 1, 0, 5, 3, spreadNS.Tables.TableThemes.light6);
table.autoGenerateColumns(true);
var tableColumn1 = new spreadNS.Tables.TableColumn();
tableColumn1.name("FirstName1");
tableColumn1.dataField("FirstName");
var tableColumn2 = new spreadNS.Tables.TableColumn();
tableColumn2.name("LastName2");
tableColumn2.dataField("LastName");
var tableColumn3 = new spreadNS.Tables.TableColumn();
tableColumn3.name("Title3");
tableColumn3.dataField("Title");
table.bindColumns([tableColumn1, tableColumn2, tableColumn3]);
table.bindingPath('records');
console.log(table)
spread.resumePaint();
var source = [
{ LastName: "Freehafer", FirstName: "Nancy", Title: "Sales Representative", Phone: "(123)555-0100"},
{ LastName: "Cencini", FirstName: "Andrew", Title: "Vice President, Sales", Phone: "(123)555-0101"},
{ LastName: "Kotas", FirstName: "Jan", Title: "Sales Representative", Phone: "(123)555-0102"},
{ LastName: "Sergienko", FirstName: "Mariya", Title: "Sales Representative", Phone: "(123)555-0103"},
];
sheet.setDataSource(
new spreadNS.Bindings.CellBindingSource(
{
records: source
})
);
sheet.bind(GC.Spread.Sheets.Events.CellClick, (sender, args) => {
console.log(sheet.getDataSource())
})
}
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图