fix(sheet): support bind delete & date type source

[VicKun4937]

• support delete bind path when delete cell

const fWorkbook = univerAPI.getActiveWorkbook();
const fSheet = fWorkbook.getActiveSheet();

const source = fWorkbook.createSource(univerAPI.Enum.DataBindingNodeTypeEnum.Object);
source.setSourceData({
    user: {
        name: '猿婶'
    }
})

fSheet.setBindingNode({
    row: 1,
    column: 2,
    path: 'user.name',
    type: univerAPI.Enum.DataBindingNodeTypeEnum.Object,
    sourceId: source.getId()
})

const listSource = fWorkbook.createSource(univerAPI.Enum.DataBindingNodeTypeEnum.List, false);
listSource.setSourceData({
    fields: ['商品', '种类','日期'],
    records: [['苹果', '水果', 1736942545041], ['香蕉', '水果',1736942545041], ['圆珠笔', '文具',1736942545041]]
})
fSheet.setBindingNode({
    row: 1,
    column: 4,
    path: '商品',
    type: univerAPI.Enum.DataBindingNodeTypeEnum.List,
    sourceId: listSource.getId()
})

fSheet.setBindingNode({
    row: 1,
    column: 5,
    path: '种类',
    type: univerAPI.Enum.DataBindingNodeTypeEnum.List,
    sourceId: listSource.getId()
})
fSheet.setBindingNode({
    row: 1,
    column: 6,
    path: '日期',
    type: univerAPI.Enum.DataBindingNodeTypeEnum.List,
    sourceId: listSource.getId(),
    isDate:true,
})

[github-actions]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[github-actions]

Playwright test results

 23 passed

Details

 23 tests across 10 suites
 5 minutes, 8 seconds
 a45a662
 For more information, see full report

[codecov]

Codecov Report

Attention: Patch coverage is 0% with 120 lines in your changes missing coverage. Please review.

Project coverage is 32.79%. Comparing base (7957d95) to head (a45a662).
Report is 2 commits behind head on dev.

Files with missing lines	Patch %	Lines
...-source-binding/src/controllers/binding-manager.ts	0.00%	34 Missing ⚠️
...al/sheets-source-binding/src/model/source-model.ts	0.00%	31 Missing ⚠️
...s-source-binding/src/controllers/source-manager.ts	0.00%	24 Missing ⚠️
...tal/sheets-source-binding/src/facade/f-workbook.ts	0.00%	14 Missing ⚠️
...rce-binding/src/services/source-binding-service.ts	0.00%	9 Missing ⚠️
...l/sheets-source-binding/src/model/binding-model.ts	0.00%	8 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #4487      +/-   ##
==========================================
- Coverage   32.82%   32.79%   -0.03%     
==========================================
  Files        2595     2595              
  Lines      133973   134075     +102     
  Branches    29805    29820      +15     
==========================================
  Hits        43975    43975              
- Misses      89998    90100     +102     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: fix(sheet): support bind delete & date type source

Title: fix(sheet): support bind delete & date type source

---

• support delete bind path when delete cell