feat(formula): add some lookup formulas

[wpxp123456]

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

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 99.15966% with 4 lines in your changes missing coverage. Please review.

Project coverage is 30.51%. Comparing base (56a27a7) to head (b29574d).
Report is 3 commits behind head on dev.

Files with missing lines	Patch %	Lines
...engine-formula/src/functions/lookup/tocol/index.ts	97.40%	2 Missing ⚠️
...engine-formula/src/functions/lookup/torow/index.ts	97.36%	2 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #3352      +/-   ##
==========================================
+ Coverage   30.20%   30.51%   +0.30%     
==========================================
  Files        2109     2117       +8     
  Lines      110029   110527     +498     
  Branches    23922    24126     +204     
==========================================
+ Hits        33233    33723     +490     
- Misses      76796    76804       +8     

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

[zhaolixin7]

@wpxp123456 drop1、删除引用值预期报#ref

2024_9_7 14_59_17 commands.json
2024_9_7 14_59_17 video.webm
2、参数错误时预取报#n/a或#value

3、参数为空时无报错

[univer-bot]

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

@wpxp123456 drop1, delete reference value expected report #ref

2024_9_7 14_59_17 commands.json
2024_9_7 14_59_17 video.webm
2. When the parameter is wrong, the prefetch report #n/a or #value

3. No error is reported when the parameter is empty

[zhaolixin7]

EXPAND1、参数为空时无报错

2、无效时错误码是#name(=EXPAND(D23:D25, true, false, 0) )

如：

3、引用选区时预期报#na(=EXPAND(A9:A11,B5:B8,A5:A7) )

[univer-bot]

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

EXPAND1, no error is reported when the parameter is empty

2. When invalid, the error code is #name(=EXPAND(D23:D25, true, false, 0) )

like:

3. When quoting a selection, it is expected to report #na(=EXPAND(A9:A11,B5:B8,A5:A7) )

[zhaolixin7]

take:1、参数为-1时公式显示为空，预期报错，


2、引用选区时公式结果计算错误（=TAKE(,A3:A4,B2:B5)）

[univer-bot]

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

take:1. When the parameter is -1, the formula is displayed as empty, and an error is expected.


2. The formula result is calculated incorrectly when referencing a selection (=TAKE(,A3:A4,B2:B5))

[zhaolixin7]

tocol:1、引用选区时（=TOCOL(,B4:B8,A7:A10)）预期显示#value，表现：显示#n/a


2、引用选区时公式计算结果错误=TOCOL((A1:A6,C1:F1,G3:G6),1)2024_9_9 15_41_50 snapshot.json

[univer-bot]

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

tocol: 1. When referencing a selection (=TOCOL(,B4:B8,A7:A10)), #value is expected to be displayed. Performance: #n/a is displayed.


2. The formula calculation result is wrong when referencing the selection =TOCOL((A1:A6,C1:F1,G3:G6),1)[2024_9_9 15_41_50 snapshot.json](https://github.com/user-attachments/files/ 16927125/2024_9_9.15_41_50.snapshot.json)

[zhaolixin7]

torow：引用选区计算不出结果=TOROW((A1:A6, C1:F1, G3:G6), 1)
2024_9_9 16_03_39 snapshot.json

[univer-bot]

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

torow: No result can be calculated by referencing the selection =TOROW((A1:A6, C1:F1, G3:G6), 1)
2024_9_9 16_03_39 snapshot.json

[zhaolixin7]

WRAPCOLS：1、引用选区、空时计算不出结果=WRAPCOLS(B1:B15,H11:I13)

[univer-bot]

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

WRAPCOLS: 1. When referencing the selection, the result cannot be calculated when it is empty =WRAPCOLS(B1:B15,H11:I13)

[zhaolixin7]

WRAPCOLS/ WRAPROWS：选区显示不出结果（=WRAPCOLS((A1:A6, C1:F1, G3:G6), 3)）

[univer-bot]

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

WRAPCOLS/ WRAPROWS: No results are displayed in the selection (=WRAPCOLS((A1:A6, C1:F1, G3:G6), 3))