fix: selection expand with shift

[lumixraku]

close https://github.com/dream-num/univer-pro/issues/3537 close https://github.com/dream-num/univer-pro/issues/3524

close https://github.com/dream-num/univer-pro/issues/3576

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[bot]]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[github-actions[bot]]

Playwright test results

 20 passed

Details

 20 tests across 9 suites
 4 minutes, 49 seconds
 6a534c1
 For more information, [see full report]()

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 26.66667% with 44 lines in your changes missing coverage. Please review.

Project coverage is 33.68%. Comparing base (1de083c) to head (6a534c1). Report is 1 commits behind head on dev.

Files with missing lines	Patch %	Lines
...ts-formula-ui/src/controllers/prompt.controller.ts	0.00%	14 Missing :warning:
...src/services/selection/selection-render.service.ts	0.00%	8 Missing :warning:
...ts/src/services/selections/selection-data-model.ts	50.00%	8 Missing :warning:
...s/render-services/ref-selections.render-service.ts	0.00%	6 Missing :warning:
...rc/services/selection/selection-shape-extension.ts	0.00%	3 Missing :warning:
...sheets-ui/src/controllers/move-range.controller.ts	0.00%	1 Missing :warning:
...heets-ui/src/controllers/utils/selections-tools.ts	0.00%	1 Missing :warning:
...ervices/selection/base-selection-render.service.ts	0.00%	1 Missing :warning:
...ets-ui/src/services/selection/selection-control.ts	0.00%	1 Missing :warning:
.../src/services/selections/ref-selections.service.ts	0.00%	1 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## dev #4166 +/- ## ========================================== + Coverage 33.67% 33.68% +0.01% ========================================== Files 2490 2490 Lines 128019 128028 +9 Branches 28692 28695 +3 ========================================== + Hits 43105 43128 +23 + Misses 84914 84900 -14 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[oumomomo]

https://github.com/dream-num/univer-pro/issues/3537

问题1、 选中行作为公式选区后使用shift+左右键 选中列作为公式选区后使用shift+上下键

预期表现：无法调整选区 实际表现：可以调整选区，且调整选区后背景色超出 2024_11_29 11_42_49 video.webm

[univer-bot[bot]]

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

https://github.com/dream-num/univer-pro/issues/3537

Question 1. After selecting the row as a formula selection, use shift + left and right keys After selecting a column as a formula selection, use shift+up and down keys

Expected performance: Unable to adjust selection Actual performance: The selection can be adjusted, and the background color exceeds the 2024_11_29 11_42_49 video.webm

[univer-bot[bot]]

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

https://github.com/dream-num/univer-pro/issues/3537 Question 2: When Table 1 refers to the selection of Table 2 across tables, the selection cannot be adjusted using shift+arrow keys. 2024_11_29 11_46_54 video.webm

Expected performance: can be adjusted normally

[oumomomo]

https://github.com/dream-num/univer-pro/issues/3537

问题2、引用行列使用shift+方向键

实际表现 引用行列时使用方向键会展示列标题+行序号

excel表现： 引用列时使用左右键调整选区，公式内仅展示列标题不展示单元格序号 2024_11_29 11_54_45 video.webm

引用行时使用上下键调整选区，仅展示行序号不展示列标题

[univer-bot[bot]]

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

https://github.com/dream-num/univer-pro/issues/3537

Question 2. Use shift+arrow keys to reference rows and columns.

actual performance When referencing a row or column, using the arrow keys will display the column title + row number.

excel performance: When referencing a column, use the left and right keys to adjust the selection. Only the column title is displayed in the formula and the cell serial number is not displayed. 2024_11_29 11_54_45 video.webm

When referencing a row, use the up and down keys to adjust the selection. Only row numbers are displayed and column titles are not displayed.

[univer-bot[bot]]

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

https://github.com/dream-num/univer-pro/issues/3524

Note: After referencing the selection in Table 1, the format is =I21:J25,K27:M32. The comma after the second selection is switched to Table 2 and added, otherwise it cannot be reproduced.

1. Enter = in the cell of Table 1 to reference the two selections in this table.
2. Switch to Table 2 input, and then reference a selection
3. Switch back to Table 1 to view the selection lines 2024_11_29 14_34_14 video.webm

Expected performance: The selection lines in Table 1 are displayed normally. Actual performance: The selection lines in Table 1 are not displayed.