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-TW/helpcontent2/source/text/scalc/guide.po
Last change Feb. 1, 2024, 6:56 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 75% 1,169 68% 17,226 69% 137,058
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 23 1% 485 2% 5,170
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 24% 389 31% 7,744 30% 61,015
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
75%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Traditional)
File zh-TW/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 (Traditional)
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.
也就是說，如果您輸入日期 30/1/1 或是更高，則系統內部會設定為 1930/1/1 或更高。所有較小的年份適用於下一個世紀，因此，例如 20/1/1 會轉換成 2020/1/1 。
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Chinese (Traditional)
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.
在 <emph><switchinline select="sys"><caseinline select="MAC">[%PRODUCTNAME] - [喜好設定]</caseinline><defaultinline>[工具] - [選項]</defaultinline></switchinline> - [$[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 (Traditional)
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 (Traditional)
<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 (Traditional)
<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 (Traditional)
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 (Traditional)
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 (Traditional)
<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 (Traditional)
<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