fix(formula): formula string results are displayed as regular strings #2206
Add this suggestion to a batch that can be applied as a single commit.
This suggestion is invalid because no changes were made to the code.
Suggestions cannot be applied while the pull request is closed.
Suggestions cannot be applied while viewing a subset of changes.
Only one suggestion per line can be applied in a batch.
Add this suggestion to a batch that can be applied as a single commit.
Applying suggestions on deleted lines is not supported.
You must change the existing code in this line in order to create a valid suggestion.
Outdated suggestions cannot be applied.
This suggestion has been applied or marked resolved.
Suggestions cannot be applied from pending reviews.
Suggestions cannot be applied on multi-line comments.
Suggestions cannot be applied while the pull request is queued to merge.
Suggestion cannot be applied right now. Please check back later.
close [Bug] When the formula result is equal to "0", no error message is expected #2194
如何测试?
场景 1. 输入
=IF(1,"0")
,不会再出现强制字符串角标场景 2. 输入
#N/A
不会再出现公式报错提醒close https://github.com/dream-num/univer-pro/issues/661
close https://github.com/dream-num/univer-pro/issues/658
如何测试?(2,3 是同一个问题)
整两个货币格式或者日期格式的单元格,用公式做一下加减乘除即可
LOWER 函数支持处理 TRUE FALSE 为小写
![企业微信截图_17153306109868](https://private-user-images.githubusercontent.com/26371161/329520240-deb362b8-b0ea-4e3c-b5d5-32beddab9a21.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjAwMDA4OTMsIm5iZiI6MTcyMDAwMDU5MywicGF0aCI6Ii8yNjM3MTE2MS8zMjk1MjAyNDAtZGViMzYyYjgtYjBlYS00ZTNjLWI1ZDUtMzJiZWRkYWI5YTIxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MDMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzAzVDA5NTYzM1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWYzZDI1NGY2N2UwNDUyMzJkMjIxNTQzMWE0NWIxNTg3NDFhNDAzNDgzMGNjYTI4ZjI4Nzc2ZDUzY2FmNDM3NGMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0._BEHZIZgrHwZPe3FBrMuii2B4P2whCjIdS0GuQtFFWs)
错误情况:显示了TRUE
实际情况:显示true