feat(facade): add Facade Worksheet row column API

[Dushusir]

Facade Worksheet row/column API

API

• insertRowAfter
• insertRowBefore
• insertRows
• insertRowsAfter
• insertRowsBefore
• deleteRow
• deleteRows
• moveRows
• hideRow
• hideRows
• unhideRow
• showRows
• setRowHeight
• setRowHeights
• setRowHeightsForced
• insertColumnAfter
• insertColumnBefore
• insertColumns
• insertColumnsAfter
• insertColumnsBefore
• deleteColumn
• deleteColumns
• moveColumns
• hideColumn
• hideColumns
• unhideColumn
• showColumns
• setColumnWidth
• setColumnWidths

How to test?

Use Google Sheets Apps Script to test whether the result of Univer is the same as Google Sheets. Reference https://developers.google.com/apps-script/reference/spreadsheet/sheet#methods

e.g.
Google Sheets Apps Script:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

// This inserts a row after the first row position
sheet.insertRowAfter(1);

Uniscript

const activeSheet = univerAPI.getActiveWorkbook()?.getActiveSheet()
activeSheet?.insertRowAfter(0);

Pull Request Checklist

• Related tickets or issues have been linked in the PR description (or missing issue).
• Naming convention is followed (do please check it especially when you created new plugins, commands and resources).
• Unit tests have been added for the changes (if applicable).
• Breaking changes have been documented (or no breaking changes introduced in this PR).

[github-actions]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[codecov]

Codecov Report

Attention: Patch coverage is 98.02372% with 5 lines in your changes missing coverage. Please review.

Project coverage is 28.78%. Comparing base (e293aca) to head (27b6c80).
Report is 21 commits behind head on dev.

Files with missing lines	Patch %	Lines
packages/facade/src/apis/sheets/f-worksheet.ts	98.79%	2 Missing ⚠️
...ts/src/commands/commands/move-rows-cols.command.ts	94.44%	2 Missing ⚠️
...der-controllers/header-resize.render-controller.ts	0.00%	1 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #3163      +/-   ##
==========================================
+ Coverage   28.63%   28.78%   +0.15%     
==========================================
  Files        2025     2025              
  Lines      106970   107160     +190     
  Branches    23129    23149      +20     
==========================================
+ Hits        30629    30849     +220     
+ Misses      76341    76311      -30     

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

[zhaolixin7]

@Dushusir 1、有背景色时子修改行高失败，
2、无背景时再次执行时杭盖会被改变，预期不变
2024_8_28 15_55_06 video.webm

[Dushusir]

@Dushusir 1、有背景色时子修改行高失败， 2、无背景时再次执行时行高会被改变，预期不变 2024_8_28 15_55_06 video.webm

fixed

[univer-bot]

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

@Dushusir 1. Modifying the row height fails when there is a background color. 2. The row height will be changed when executed again without a background, and the expectation remains unchanged [2024_8_28 15_55_06 video.webm](https://github.com/user- attachments/assets/3ffb1cb5-391a-4af0-bbec-5739c3c711fe)

fixed

[wzhudev]

LGTM