Jump to content
Toggle sidebar
The Document Foundation Wiki
Search
English
Personal tools
Create account
Log in
Navigation
Main page
Get Involved
Recent changes
Random page
Support LibreOffice!
Editing the wiki
Help resources
Tools
What links here
Related changes
Special pages
Printable version
Permanent link
Page information
In other languages
Add languages
Translations
:
ReleaseNotes/7.0/79/zh-cn
Translation unit
Discussion
大陆简体
Read
View source
View history
More
Read
View source
View history
From The Document Foundation Wiki
TEXT()
函数从现在起允许第二个参数为空的格式字符串了,以保持和其它电子表格程序的兼容。如果第一个参数是数字或是能被转化为数字的字符串(按照公式相关的设置转化),则返回空字符串。如果第一个参数是不能被转化为数字的字符串,则返回该字符串。在以前的版本中,空的格式字符串会导致 Err:502(无效的参数)错误。参看
tdf#131536
(Eike Rathke (Red Hat, Inc.))