E-国际业务-通用插件/excelformat函数 — Chinese (Simplified) @ Weblate

4	Strings		100%	Browse Translate
196	Words		100%

4	All strings — 196 words	Browse Translate Zen
4	Translated strings — 196 words	Browse Translate Zen
1	Strings with any failing checks — 194 words	Browse Translate Zen
1	Failing check: Multiple failing checks — 194 words	Browse Translate Zen
4	Strings without a label — 196 words	Browse Translate Zen

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
teams集成插件(plugin-mobile-teams)	78%	60	0	0	60	32	0	0

word报告(Microsoft版)	98%	1	0	0	1	19	0	0

平台字体可配置		0	0	0	0	1	0	0

Glossary E-国际业务-通用插件		0	0	0	0	0	0	0

本地化函数集合		0	0	0	0	7	0	0

saml单点登录插件		0	0	0	0	13	0	0

定时调度多模板填报		0	0	0	0	0	0	0

增强版多ldap认证插件		0	0	0	0	26	0	0

导出到googledrive		0	0	0	0	0	0	0

平台语言切换		0	0	0	0	0	0	0

Project website	code.fineres.com/projects/I18N
Project maintainers	Heedong.Yeo
Translation process	Translations can be made directly. Translation suggestions can be made. Any authenticated user can contribute. The translation uses monolingual files. The translation base language is editable.
Source code repository	`ssh://code.fineres.com:7999/~okcean/plugin-report-excelformat-function.git`
Repository branch	release/11.0
Last remote commit	Pull request #24: INO-22246 fix:EXCELFORMAT函数导出文件汉字乱码 `e98ceee` Obo-王学仁 authored 2 weeks ago
Last commit in Weblate	Pull request #18: 无jira任务国际化更新 `b845690` inter authored a month ago
Weblate repository	`http://124.71.185.90:8080/git/I18N/excelformat/`
File mask	`src/main/resources/com/fr/plugin/excelformat/locale/main_*.properties`
Monolingual base language file	`src/main/resources/com/fr/plugin/excelformat/locale/main_zh.properties`
Translation file	Download `src/main/resources/com/fr/plugin/excelformat/locale/main_zh.properties`
Last change	None
Last author	None

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		4		196		2,119
Translated	100%	4	100%	196	100%	2,119
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	25%	1	98%	194	97%	2,072
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	0%	0	0%	0	0%	0

None Resource update E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	The "`src/main/resources/com/fr/plugin/excelformat/locale/main_zh.properties`" file was changed. a month ago
None String updated in the repository E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	Chinese (Simplified) Chinese (Simplified) 1 character edited Current translation Translated a month ago
None String updated in the repository E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	Chinese (Simplified) ExcelFormat函数插件,使用该函数导出数字可以保留格式 Chinese (Simplified) 31 characters edited Current translation Translated ExcelFormat函数插件,使用该函数导出数字可以保留格式 a month ago
None String updated in the repository E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	Chinese (Simplified) ExcelFormat函数插件 Chinese (Simplified) 15 characters edited Current translation Translated ExcelFormat函数插件 a month ago
None Resource update E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	The "`src/main/resources/com/fr/plugin/excelformat/locale/main_zh_CN.properties`" file was changed. a month ago
None String updated in the repository E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	Chinese (Simplified) EXCELFORMAT(object, format) 函数用于为 object 设置导出到 Excel 中的格式 (format)。object：需要被格式化的对象，支持字符串和数字。format：格式化的样式。注意事项： 1）当 format 设置为内置格式时，预览时生效（日期格式除外）；当 format 设置为自定义格式时，预览时不生效。 2）不支持新计算引擎。示例及说明： 1、数字格式化 EXCELFORMAT(1234.567, "0") => 1235 EXCELFORMAT(1234.567, "0.00") => 1234.57 EXCELFORMAT(1234567, "#,##0") => 1,234,567 EXCELFORMAT(1234567.891, "#,##0.00") => 1,234,567.89 EXCELFORMAT(1234, "$#,##0_);($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);($#,##0)") => ($1,234) EXCELFORMAT(1234, "$#,##0_);[Red]($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);[Red]($#,##0)") => ($1,234) (红色) EXCELFORMAT(1234.567, "$#,##0.00_);($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);($#,##0.00)") => ($1,234.57) EXCELFORMAT(1234.567, "$#,##0.00_);[Red]($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);[Red]($#,##0.00)") => ($1,234.57) (红色) EXCELFORMAT(0.75, "0%") => 75% EXCELFORMAT(0.752, "0.00%") => 75.20% EXCELFORMAT(12345678, "0.00E+00") => 1.23E+07 EXCELFORMAT(0.25, "# ?/?") => 1/4 EXCELFORMAT(0.3125, "# ??/??") => 5/16 EXCELFORMAT(1234, "#,##0_ ;(#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ ;(#,##0)") => (1,234) EXCELFORMAT(1234, "#,##0_ ;[Red](#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ ;[Red](#,##0)") => (1,234) (红色) EXCELFORMAT(1234.56, "#,##0.00_ ;(#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ ;(#,##0.00)") => (1,234.56) EXCELFORMAT(1234.56, "#,##0.00_ ;[Red](#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ ;[Red](#,##0.00)") => (1,234.56) (红色) EXCELFORMAT(12345, "##0.0E+0") => 1.2E+4 2、日期格式化当 object 为字符串时，按照给出的常规格式进行计算，只有 format 设置为 "yyyy/MM/dd" 或 "yyyy-MM-dd" 时生效。 EXCELFORMAT("2022-01-01", "yyyy/MM/dd") => 2022/01/01 EXCELFORMAT("2022-01-01", "yyyy-MM-dd") => 2022-01-01 当 object 为整数时，按照 Excel 规则进行计算。例如，45000 代表从 1900 年 1 月开始的第 45000 天，0.5 代表一天中的中点时间。导出效果受 Excel 国际化的影响。 EXCELFORMAT(45000, "m/d/yy") => 3/15/2023 EXCELFORMAT(45000, "d-mmm-yy") => 15-Mar-23 EXCELFORMAT(0.5, "h:mm AM/PM") => 12:00 PM EXCELFORMAT(0.5, "h:mm:ss AM/PM") => 12:00:00 PM EXCELFORMAT(45000.5, "m/d/yy h:mm") => 3/15/2023 12:00 Chinese (Simplified) 24 characters edited Current translation Translated EXCELFORMAT(object, format) 函数用于为 object 设置导出到 Excel 中的格式 (format)。object：需要被格式化的对象，支持字符串和数字。format：格式化的样式。注意事项： 1）当 format 设置为内置格式时，预览时生效（日期格式除外）；当 format 设置为自定义格式时，预览时不生效。 2）不支持新计算引擎。示例及说明： 1、数字格式化 EXCELFORMAT(1234.567, "0") => 1235 EXCELFORMAT(1234.567, "0.00") => 1234.57 EXCELFORMAT(1234567, "#,##0") => 1,234,567 EXCELFORMAT(1234567.891, "#,##0.00") => 1,234,567.89 EXCELFORMAT(1234, "$#,##0_);($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);($#,##0)") => ($1,234) EXCELFORMAT(1234, "$#,##0_);[Red]($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);[Red]($#,##0)") => ($1,234) (红色) EXCELFORMAT(1234.567, "$#,##0.00_);($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);($#,##0.00)") => ($1,234.57) EXCELFORMAT(1234.567, "$#,##0.00_);[Red]($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);[Red]($#,##0.00)") => ($1,234.57) (红色) EXCELFORMAT(0.75, "0%") => 75% EXCELFORMAT(0.752, "0.00%") => 75.20% EXCELFORMAT(12345678, "0.00E+00") => 1.23E+07 EXCELFORMAT(0.25, "# ?/?") => 1/4 EXCELFORMAT(0.3125, "# ??/??") => 5/16 EXCELFORMAT(1234, "#,##0_ );(#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );(#,##0)") => (1,234) EXCELFORMAT(1234, "#,##0_ );[Red](#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );[Red](#,##0)") => (1,234) (红色) EXCELFORMAT(1234.56, "#,##0.00_ );(#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );(#,##0.00)") => (1,234.56) EXCELFORMAT(1234.56, "#,##0.00_ );[Red](#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );[Red](#,##0.00)") => (1,234.56) (红色) EXCELFORMAT(12345, "##0.0E+0") => 1.2E+4 2、日期格式化当 object 为字符串时，按照给出的常规格式进行计算，只有 format 设置为 "yyyy/MM/dd" 或 "yyyy-MM-dd" 时生效。 EXCELFORMAT("2022-01-01", "yyyy/MM/dd") => 2022/01/01 EXCELFORMAT("2022-01-01", "yyyy-MM-dd") => 2022-01-01 当 object 为整数时，按照 Excel 规则进行计算。例如，45000 代表从 1900 年 1 月开始的第 45000 天，0.5 代表一天中的中点时间。导出效果受 Excel 国际化的影响。 EXCELFORMAT(45000, "m/d/yy") => ~~2023/3/15~~3/15/2023 EXCELFORMAT(45000, "d-mmm-yy") => 15-Mar-23 EXCELFORMAT(0.5, "h:mm AM/PM") => 12:00 PM EXCELFORMAT(0.5, "h:mm:ss AM/PM") => 12:00:00 PM EXCELFORMAT(45000.5, "m/d/yy h:mm") => ~~2023/3/15~~3/15/2023 12:00 a month ago
None Resource update E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	File `src/main/resources/com/fr/plugin/excelformat/locale/main_zh_CN.properties` was added. a month ago
None String updated in the repository E-国际业务-通用插件 / excelformat函数 — Chinese (Simplified)	Chinese (Simplified) EXCELFORMAT(object, format) 函数用于为 object 设置导出到 Excel 中的格式 (format)。object：需要被格式化的对象，支持字符串和数字。format：格式化的样式。注意事项： 1）当 format 设置为内置格式时，预览时生效（日期格式除外）；当 format 设置为自定义格式时，预览时不生效。 2）不支持新计算引擎。示例及说明： 1、数字格式化 EXCELFORMAT(1234.567, "0") => 1235 EXCELFORMAT(1234.567, "0.00") => 1234.57 EXCELFORMAT(1234567, "#,##0") => 1,234,567 EXCELFORMAT(1234567.891, "#,##0.00") => 1,234,567.89 EXCELFORMAT(1234, "$#,##0_);($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);($#,##0)") => ($1,234) EXCELFORMAT(1234, "$#,##0_);[Red]($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);[Red]($#,##0)") => ($1,234) (红色) EXCELFORMAT(1234.567, "$#,##0.00_);($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);($#,##0.00)") => ($1,234.57) EXCELFORMAT(1234.567, "$#,##0.00_);[Red]($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);[Red]($#,##0.00)") => ($1,234.57) (红色) EXCELFORMAT(0.75, "0%") => 75% EXCELFORMAT(0.752, "0.00%") => 75.20% EXCELFORMAT(12345678, "0.00E+00") => 1.23E+07 EXCELFORMAT(0.25, "# ?/?") => 1/4 EXCELFORMAT(0.3125, "# ??/??") => 5/16 EXCELFORMAT(1234, "#,##0_ );(#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );(#,##0)") => (1,234) EXCELFORMAT(1234, "#,##0_ );[Red](#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );[Red](#,##0)") => (1,234) (红色) EXCELFORMAT(1234.56, "#,##0.00_ );(#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );(#,##0.00)") => (1,234.56) EXCELFORMAT(1234.56, "#,##0.00_ );[Red](#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );[Red](#,##0.00)") => (1,234.56) (红色) EXCELFORMAT(12345, "##0.0E+0") => 1.2E+4 2、日期格式化当 object 为字符串时，按照给出的常规格式进行计算，只有 format 设置为 "yyyy/MM/dd" 或 "yyyy-MM-dd" 时生效。 EXCELFORMAT("2022-01-01", "yyyy/MM/dd") => 2022/01/01 EXCELFORMAT("2022-01-01", "yyyy-MM-dd") => 2022-01-01 当 object 为整数时，按照 Excel 规则进行计算。例如，45000 代表从 1900 年 1 月开始的第 45000 天，0.5 代表一天中的中点时间。导出效果受 Excel 国际化的影响。 EXCELFORMAT(45000, "m/d/yy") => 2023/3/15 EXCELFORMAT(45000, "d-mmm-yy") => 15-Mar-23 EXCELFORMAT(0.5, "h:mm AM/PM") => 12:00 PM EXCELFORMAT(0.5, "h:mm:ss AM/PM") => 12:00:00 PM EXCELFORMAT(45000.5, "m/d/yy h:mm") => 2023/3/15 12:00 Chinese (Simplified) 2080 characters edited Translated EXCELFORMAT(object, format) 函数用于为 object 设置导出到 Excel 中的格式 (format)。object：需要被格式化的对象，支持字符串和数字。format：格式化的样式。注意事项： 1）当 format 设置为内置格式时，预览时生效（日期格式除外）；当 format 设置为自定义格式时，预览时不生效。 2）不支持新计算引擎。示例及说明： 1、数字格式化 EXCELFORMAT(1234.567, "0") => 1235 EXCELFORMAT(1234.567, "0.00") => 1234.57 EXCELFORMAT(1234567, "#,##0") => 1,234,567 EXCELFORMAT(1234567.891, "#,##0.00") => 1,234,567.89 EXCELFORMAT(1234, "$#,##0_);($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);($#,##0)") => ($1,234) EXCELFORMAT(1234, "$#,##0_);[Red]($#,##0)") => $1,234 EXCELFORMAT(-1234, "$#,##0_);[Red]($#,##0)") => ($1,234) (红色) EXCELFORMAT(1234.567, "$#,##0.00_);($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);($#,##0.00)") => ($1,234.57) EXCELFORMAT(1234.567, "$#,##0.00_);[Red]($#,##0.00)") => $1,234.57 EXCELFORMAT(-1234.567, "$#,##0.00_);[Red]($#,##0.00)") => ($1,234.57) (红色) EXCELFORMAT(0.75, "0%") => 75% EXCELFORMAT(0.752, "0.00%") => 75.20% EXCELFORMAT(12345678, "0.00E+00") => 1.23E+07 EXCELFORMAT(0.25, "# ?/?") => 1/4 EXCELFORMAT(0.3125, "# ??/??") => 5/16 EXCELFORMAT(1234, "#,##0_ );(#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );(#,##0)") => (1,234) EXCELFORMAT(1234, "#,##0_ );[Red](#,##0)") => 1,234 EXCELFORMAT(-1234, "#,##0_ );[Red](#,##0)") => (1,234) (红色) EXCELFORMAT(1234.56, "#,##0.00_ );(#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );(#,##0.00)") => (1,234.56) EXCELFORMAT(1234.56, "#,##0.00_ );[Red](#,##0.00)") => 1,234.56 EXCELFORMAT(-1234.56, "#,##0.00_ );[Red](#,##0.00)") => (1,234.56) (红色) EXCELFORMAT(12345, "##0.0E+0") => 1.2E+4 2、日期格式化当 object 为字符串时，按照给出的常规格式进行计算，只有 format 设置为 "yyyy/MM/dd" 或 "yyyy-MM-dd" 时生效。 EXCELFORMAT("2022-01-01", "yyyy/MM/dd") => 2022/01/01 EXCELFORMAT("2022-01-01", "yyyy-MM-dd") => 2022-01-01 当 object 为整数时，按照 Excel 规则进行计算。例如，45000 代表从 1900 年 1 月开始的第 45000 天，0.5 代表一天中的中点时间。导出效果受 Excel 国际化的影响。 EXCELFORMAT(45000, "m/d/yy") => 2023/3/15 EXCELFORMAT(45000, "d-mmm-yy") => 15-Mar-23 EXCELFORMAT(0.5, "h:mm AM/PM") => 12:00 PM EXCELFORMAT(0.5, "h:mm:ss AM/PM") => 12:00:00 PM EXCELFORMAT(45000.5, "m/d/yy h:mm") => 2023/3/15 12:00 a month ago

Browse all translation changes


Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar

4	File in original format as translated in the repository	Java Properties (ISO 8859-1)
4	All strings, converted files enriched with comments; suitable for offline translation	Android String Resource	CSV	JSON	gettext PO	iOS strings	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Review strings changed by other users	`changed:>=2025-03-20 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2025-03-20 AND state:<=needs-editing`	Add

E-国际业务-通用插件

excelformat函数

Chinese (Simplified)

Source strings

Strings status

Other components

Overview

String statistics

Activity in last 12 months

Quick numbers

Trends of last 30 days

Quick downloads

Customize download

Search