Translation status

4 Strings 100%
Browse Translate
196 Words 100%

Strings status

4
All strings — 196 words Browse Translate Zen
4
Translated strings — 196 words Browse Translate Zen
2
Strings with any failing checks — 195 words Browse Translate Zen
2
Translated strings with any failing checks — 195 words Browse Translate Zen
2
Failing check: Mismatched full stop — 195 words Browse Translate Zen
1
Failing check: Mismatching line breaks — 194 words Browse Translate Zen
1
Failing check: Consecutive duplicated words — 194 words Browse Translate Zen
4
Strings without a label — 196 words Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
saml单点登录插件 This translation does not yet exist. 0% 50 57 975 0 0 0 0
平台日志同步到pgsql This translation does not yet exist. 0% 65 64 523 0 0 0 0
Server dataset synchronization supports configuring user types This translation does not yet exist. 0% 5 5 72 0 0 0 0
导出到googledrive This translation does not yet exist. 0% 13 18 154 0 0 0 0
定时调度支持推送非平台 This translation does not yet exist. 0% 4 4 71 0 0 0 0
多语言(plugin-i18n-bundle) 98% 2 2 34 2 10 0 0
增强版多ldap认证插件 98% 1 1 58 0 23 0 0
本地化函数集合 0 0 0 0 7 0 0
平台字体可配置 Fix this component to clear its alerts. 0 0 0 0 1 0 0
Glossary E-国际业务-通用插件 0 0 0 0 0 0 0
Browse all components

Overview

Project website code.fineres.com/projects/I18N
Project maintainers User avatar 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_en.properties
Last change March 6, 2025, 2:06 a.m.
Last author Chauvet

String statistics

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 50% 2 99% 195 99% 2,103
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

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

Quick numbers

196
Hosted words
4
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+100%
—
Contributors
+100%
User avatar Chauvet

New translation

E-国际业务-通用插件 / excelformat函数 — English

ExcelFormat函数插件,使用该函数导出数字可以保留格式
The ExcelFormat Function plugin can be used to export numbers with their formats kept.
a month ago
User avatar Chauvet

New translation

E-国际业务-通用插件 / excelformat函数 — English

ExcelFormat函数插件
ExcelFormat Function
a month ago
User avatar Chauvet

New contributor

E-国际业务-通用插件 / excelformat函数 — English

New contributor a month ago
User avatar Griffin

New strings to translate

E-国际业务-通用插件 / excelformat函数 — English

2 new strings to translate appeared to the translation. a month ago
User avatar Griffin

Resource update

E-国际业务-通用插件 / excelformat函数 — English

File src/main/resources/com/fr/plugin/excelformat/locale/main_en.properties was added. a month ago
User avatar None

String updated in the repository

E-国际业务-通用插件 / excelformat函数 — English

a month ago
User avatar None

String updated in the repository

E-国际业务-通用插件 / excelformat函数 — English

ExcelFormat函数插件,使用该函数导出数字可以保留格式
 
a month ago
User avatar None

String updated in the repository

E-国际业务-通用插件 / excelformat函数 — English

ExcelFormat函数插件
 
a month ago
User avatar None

String updated in the repository

E-国际业务-通用插件 / excelformat函数 — English

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
The EXCELFORMAT(object, format) function is used to export the object in the specified format to Excel.
object: object to be formatted, which can be a string or number.
format: formatting style.
Note:
1. If the format is set to a built-in one, this function takes effect during preview (except for the date format). If the format is set to a custom one, this function does not take effect during preview.
2. This function is not supported by the new calculation engine.
Example & Description:
1. Number formatting
EXCELFORMAT(1234.567, "0") returns 1235.
EXCELFORMAT(1234.567, "0.00") returns 1234.57.
EXCELFORMAT(1234567, "#,##0") returns 1,234,567.
EXCELFORMAT(1234567.891, "#,##0.00") returns 1,234,567.89.
EXCELFORMAT(1234, "$#,##0_);($#,##0)") returns $1,234.
EXCELFORMAT(-1234, "$#,##0_);($#,##0)") returns ($1,234).
EXCELFORMAT(1234, "$#,##0_);[Red]($#,##0)") returns $1,234.
EXCELFORMAT(-1234, "$#,##0_);[Red]($#,##0)") returns ($1,234) in red.
EXCELFORMAT(1234.567, "$#,##0.00_);($#,##0.00)") returns $1,234.57.
EXCELFORMAT(-1234.567, "$#,##0.00_);($#,##0.00)") returns ($1,234.57).
EXCELFORMAT(1234.567, "$#,##0.00_);[Red]($#,##0.00)") returns $1,234.57.
EXCELFORMAT(-1234.567, "$#,##0.00_);[Red]($#,##0.00)") returns ($1,234.57) in red.
EXCELFORMAT(0.75, "0%") returns 75%.
EXCELFORMAT(0.752, "0.00%") returns 75.20%.
EXCELFORMAT(12345678, "0.00E+00") returns 1.23E+07.
EXCELFORMAT(0.25, "# ?/?") returns 1/4.
EXCELFORMAT(0.3125, "# ??/??") returns 5/16.
EXCELFORMAT(1234, "#,##0_ ;(#,##0)") returns 1,234.
EXCELFORMAT(-1234, "#,##0_ ;(#,##0)") returns (1,234).
EXCELFORMAT(1234, "#,##0_ ;[Red](#,##0)") returns 1,234.
EXCELFORMAT(-1234, "#,##0_ ;[Red](#,##0)") returns (1,234) in red.
EXCELFORMAT(1234.56, "#,##0.00_ ;(#,##0.00)") returns 1,234.56.
EXCELFORMAT(-1234.56, "#,##0.00_ ;(#,##0.00)") returns (1,234.56).
EXCELFORMAT(1234.56, "#,##0.00_ ;[Red](#,##0.00)") returns 1,234.56.
EXCELFORMAT(-1234.56, "#,##0.00_ ;[Red](#,##0.00)") returns (1,234.56) in red.
EXCELFORMAT(12345, "##0.0E+0") returns 1.2E+4.
2. Date formatting
If the object is a string, this function takes effect only when the format is set to yyyy/MM/dd or yyyy-MM-dd.
EXCELFORMAT("2022-01-01", "yyyy/MM/dd") returns 2022/01/01.
EXCELFORMAT("2022-01-01", "yyyy-MM-dd") returns 2022-01-01.
If the object is an integer, this function performs calculation based on Excel rules. For example, 45000 represents the 45000th day starting from January 1900, and 0.5 represents the midpoint of a day. The format of the exported result varies according to the Excel language setting.
EXCELFORMAT(45000, "m/d/yy") returns 3/15/2023.
EXCELFORMAT(45000, "d-mmm-yy") returns 15-Mar-23.
EXCELFORMAT(0.5, "h:mm AM/PM") returns 12:00 PM.
EXCELFORMAT(0.5, "h:mm:ss AM/PM") returns 12:00:00 PM.
EXCELFORMAT(45000.5, "m/d/yy h:mm") returns 3/15/2023 12:00.
a month ago
Browse all translation changes