Translation status

1,558 Strings 83%
Browse Translate
24,970 Words 80%
198,073 Characters 80%

Strings status

Strings Words Characters
1,558 24,970 198,073
All strings Browse Translate Zen
1,306 20,067 160,035
Translated strings Browse Translate Zen
252 4,903 38,038
Unfinished strings Browse Translate Zen
252 4,903 38,038
Untranslated strings Browse Translate Zen
252 4,903 38,038
Unfinished strings without suggestions Browse Translate Zen
17 30 234
Strings with any failing checks Browse Translate Zen
17 30 234
Translated strings with any failing checks Browse Translate Zen
17 30 234
Failing check: Unchanged translation Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
text/scalc/02 MPL-2.0 77% 22 331 2,788 22 0 0 0
text/scalc/01 MPL-2.0 68% 2,670 31,909 281,035 2,670 143 0 0
text/smath/02 MPL-2.0 0 0 0 0 0 0 0
text/sdatabase MPL-2.0 9% 1,570 18,012 134,532 1,570 4 0 0
text/sbasic/shared/01 MPL-2.0 0 0 0 0 0 0 0
text/schart/02 MPL-2.0 92% 2 18 274 2 0 0 0
text/smath/04 MPL-2.0 0 0 0 0 0 0 0
text/simpress/04 MPL-2.0 81% 46 295 4,181 46 2 1 0
text/simpress/01 MPL-2.0 86% 135 1,282 14,323 135 0 0 0
text/sdraw/guide MPL-2.0 82% 57 692 5,440 57 0 0 0
Browse all components

Overview

Project website www.libreoffice.org
Instructions for translators

Mailing list for translators: <l10n@global.libreoffice.org>
Translation license Mozilla Public License 2.0
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
File mask */helpcontent2/source/text/scalc/guide.po
Translation file Download zh-CN/helpcontent2/source/text/scalc/guide.po
Last change Feb. 1, 2024, 6:55 p.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,558 24,970 198,073
Translated 83% 1,306 80% 20,067 80% 160,035
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 17 1% 30 1% 234
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 16% 252 19% 4,903 19% 38,038
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 1,559 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
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

24,970
Hosted words
1,558
Hosted strings
83%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+83%
—
Contributors
—
User avatar None

Resource updated

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
File zh-CN/helpcontent2/source/text/scalc/guide.po was added. 9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020.
也就是说，如果输入日期 1/1/30 或更大数字，内部程序会将该日期处理为 1/1/1930 或以后的日期。较小的两位数年份表示 20xx 年。例如，输入 1/1/20 时将转换成 1/1/2020。
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
Under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029.
在「<switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - 偏好设置</emph></caseinline><defaultinline><emph>工具 - 选项</emph></defaultinline></switchinline><emph> - $[officename] - 常规</emph>」下，可以定义在只输入两位数年份时使用的世纪。默认为 1930 至 2029。
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years.
在日期条目中，通常用两个数字表示年份。但 $[officename] 内部使用的是四位数字的年份，因此在计算日期 1/1/99 和 1/1/01 之间相差的年数时，结果是正确的，即两年。
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
<variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link></variable>
<variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx 年</link></variable>
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
<bookmark_value>年份; 两位</bookmark_value><bookmark_value>日期; 19xx/20xx</bookmark_value>
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
19xx/20xx Years
19xx/20xx 年
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
 
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
<input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with "A" followed by exactly two other characters.
 
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Simplified)
<input>=COUNTIF(A1:A10;"Chi*")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with "Chi" followed by zero or more characters.
 
9 months ago
Browse all translation changes