好的👌
我这边还有一个现象提供给您排查:
在您的#button2的 click 事件最后加上如下代码后,重复点击 button2,公式会变成#REF。
添加位置如图:
- const newDataSource2 = {
- [`${tableName}Data`]: [
- { No: null, CompanyName: null, Country: null, Currency: null, fs01: null, fi01: null},
- {},
- {},
- ]
- }
- const source2 = new GC.Spread.Sheets.Bindings.CellBindingSource(newDataSource2)
- sheet.setDataSource(source2)
-
- const newDataSource3 = {
- [`${tableName}Data`]: [
- { No: '123123', CompanyName: '1234234', Country: '2324', Currency: '123123', fs01: '555', fi01: '55'},
- { No: '123123', CompanyName: '1234234', Country: '2324', Currency: '123123', fs01: '6666', fi01: '66'}
- ]
- }
- const source3 = new GC.Spread.Sheets.Bindings.CellBindingSource(newDataSource3)
- sheet.setDataSource(source3)
复制代码 |