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 None
Last author None
2 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,558 24,972 198,077
Translated 84% 1,312 81% 20,258 81% 162,002
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 15% 246 18% 4,714 18% 36,075
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 1,560 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
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr

Quick numbers

24,972
Hosted words
1,558
Hosted strings
84%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

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

String updated in the repository

  1. LibreOffice Help – 7.6
  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。
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  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。
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  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 之间相差的年数时，结果是正确的，即两年。
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  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>
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  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>
8 months ago
User avatar None

String updated in the repository

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

String updated in the repository

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

String updated in the repository

  1. LibreOffice Help – 7.6
  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.
 
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  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.
 
8 months ago
Browse all translation changes