fix(sheet): save edit content when select other tab

[Dushusir]

close #xxx, #yyy, #zzzz

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 91.98113% with 17 lines in your changes are missing coverage. Please review.

Project coverage is 30.75%. Comparing base (0ed9f56) to head (18ec824).

Files	Patch %	Lines
packages/sheets-formula/src/services/utils.ts	0.00%	9 Missing :warning:
...es/engine-formula/src/functions/meta/cube/index.ts	0.00%	3 Missing :warning:
...engine-formula/src/functions/meta/compare/index.ts	0.00%	2 Missing :warning:
...engine-formula/src/functions/meta/divided/index.ts	0.00%	2 Missing :warning:
...s-ui/src/controllers/editor/end-edit.controller.ts	0.00%	1 Missing :warning:

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #2160      +/-   ##
==========================================
+ Coverage   30.65%   30.75%   +0.10%     
==========================================
  Files        1272     1272              
  Lines       70149    70172      +23     
  Branches    14863    14801      -62     
==========================================
+ Hits        21504    21582      +78     
+ Misses      48645    48590      -55     

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

[github-actions[bot]]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[univer-bot[bot]]

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

Origin Title: fix(sheet): save edit content when select other tab

Title: fix(sheet): save edit content when select other tab

---

• [x] Fixed the problem of switching to other worksheets when selecting a formula range and saving data to other worksheets. How to test?

1. Create two new blank worksheets: Worksheet 1, Worksheet 2
2. Edit = in cell A1 of Sheet 1, switch to Sheet 2 and select the B1 range
3. Enter to confirm. At this time, it automatically switches back to worksheet 1, and the content of A1 is updated to =worksheet 2!B1 (previously, the data was saved to worksheet 2, [Univer Preview](https://univer-preview .vercel.app/sheets/))

• [x] Completed all formula parameter number error prompts How to test? For example, when testing OFFSET, if there are less than 3 or more than 5 parameters, a #N/A error will be reported. The same applies to other formulas (other types of errors are not included for now)

[oumomomo]

问题1、 max函数引用非数字外的值，计算结果为空

excel及google显示为0

问题2、 MOD函数被除数过长时结果计算为0，未报错

excel：报错 google：报错

[univer-bot[bot]]

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

Question 1, The max function refers to a value other than a number, and the calculation result is empty.

excel and google display as 0

Question 2. When the dividend of the MOD function is too long, the result is calculated as 0 and no error is reported.

excel: error google: error report

[zhaolixin7]

@Dushusir 编辑时切换表格，编辑内容没有先保存

[univer-bot[bot]]

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

@Dushusir When switching tables during editing, the edited content is not saved first