LibreOffice Help - master/text/scalc/guide — Chinese (Traditional) @ TDF Weblate - LibreOffice: If you select two or more adjacent cells that contain …

Translation

Context calc_series.xhp par_id3154490 help.text

English aDZ5t

If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - %PRODUCTNAME Calc - Sort Lists</item>.

Chinese (Traditional)

Needs editing

Insufficient privileges for saving translations.

Skip

Context	English	Chinese (Traditional)
calc_date.xhp par_id3147001 help.text	The number of days between today's date and the specified date is displayed in cell A3.	您現在會看見在儲存格 A3 的天數介於今天和所輸入的日期之間。
calc_date.xhp par_id3150304 help.text	Experiment with some additional formulas: in A4 enter =A324 to calculate the hours, in A5 enter =A460 for the minutes, and in A6 enter =A5*60 for seconds. Press the Enter key after each formula.	您可以依希望輸入下列的公式：A4 中「=A324」為時數，A5 中「=A460」為分鐘數，以及和 A6 中「=A5*60」為秒數(全部不含引號)，然後依上所述分別確認輸入。
calc_date.xhp par_id3149207 help.text	The time since your date of birth will be calculated and displayed in the various units. The values are calculated as of the exact moment when you entered the last formula and pressed the Enter key. This value is not automatically updated, although "Now" continuously changes. In the <emph>Data</emph> menu, the menu item <emph>Calculate - AutoCalculate</emph> is normally active; however, automatic calculation does not apply to the function NOW. This ensures that your computer is not solely occupied with updating the sheet.
calc_series.xhp tit help.text	Automatically Calculating Series	自動計算數列
calc_series.xhp bm_id3150769 help.text	<bookmark_value>series; calculating</bookmark_value> <bookmark_value>calculating; series</bookmark_value> <bookmark_value>linear series</bookmark_value> <bookmark_value>growth series</bookmark_value> <bookmark_value>date series</bookmark_value> <bookmark_value>powers of 2 calculations</bookmark_value> <bookmark_value>cells; filling automatically</bookmark_value> <bookmark_value>automatic cell filling</bookmark_value> <bookmark_value>AutoFill function</bookmark_value> <bookmark_value>filling;cells, automatically</bookmark_value>	<bookmark_value>數列; 計算</bookmark_value> <bookmark_value>計算; 數列</bookmark_value> <bookmark_value>線性數列</bookmark_value> <bookmark_value>成長數列</bookmark_value> <bookmark_value>日期數列</bookmark_value> <bookmark_value>2 次方計算</bookmark_value> <bookmark_value>儲存格; 自動填入</bookmark_value> <bookmark_value>自動填入儲存格</bookmark_value> <bookmark_value>自動填入功能</bookmark_value> <bookmark_value>填入; 儲存格, 自動</bookmark_value>
calc_series.xhp hd_id3150769 help.text	<variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp">Automatically Filling in Data Based on Adjacent Cells</link></variable>	<variable id="calc_series"><link href="text/scalc/guide/calc_series.xhp">根據鄰近儲存格自動填入資料</link></variable>
calc_series.xhp par_idN106A8 help.text	You can automatically fill cells with data with the AutoFill command or the Series command.	您可以使用自動完成指令或排列指令以自動將資料填入儲存格。
calc_series.xhp par_idN106D3 help.text	Using AutoFill	使用自動完成
calc_series.xhp par_idN106D7 help.text	AutoFill automatically generates a data series based on a defined pattern.	自動完成會自動產生基於已定義樣式的資料排列。
calc_series.xhp par_id3154319 help.text	On a sheet, click in a cell, and type a number.	在工作表上按一下儲存格，並鍵入一個數字。
calc_series.xhp par_idN106CB help.text	Click in another cell and then click back in the cell where you typed the number.	在其他儲存格按一下，然後回到您輸入數字的儲存格按一下。
calc_series.xhp par_id3145272 help.text	Drag the fill handle in the bottom right corner of the cell across the cells that you want to fill, and release the mouse button.	拖曳儲存格右下角的填入控點橫跨您要填入的儲存格，然後放掉滑鼠按鈕。
calc_series.xhp par_id3145801 help.text	The cells are filled with ascending numbers.	儲存格以升序數字填入。
calc_series.xhp par_idN106EE help.text	To quickly create a list of consecutive days, enter <item type="literal">Monday</item> in a cell, and drag the fill handle.	若要快速建立連續日期的清單，請在儲存格中輸入 <item type="literal">Monday</item> 並拖曳填入控點。
calc_series.xhp par_id9720145 help.text	Hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values.
calc_series.xhp par_id3154490 help.text	If you select two or more adjacent cells that contain different numbers, and drag, the remaining cells are filled with the arithmetic pattern that is recognized in the numbers. The AutoFill function also recognizes customized lists that are defined under <switchinline select="sys"><caseinline select="MAC"><item type="menuitem">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type="menuitem">Tools - Options</item></defaultinline></switchinline><item type="menuitem"> - %PRODUCTNAME Calc - Sort Lists</item>.	若您選取兩個或兩個以上包含不同數字之相鄰的儲存格，並加以拖曳，則剩餘的儲存格便會以可以數字加以辨識的運算模式填滿。[自動填入] 功能也可辨識定義在 <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">[%PRODUCTNAME] - [喜好設定]</caseinline><defaultinline>[工具] - [選項]</defaultinline></switchinline> - [%PRODUCTNAME Calc] - [排序清單]</item> 下的自訂清單。
calc_series.xhp par_idN10737 help.text	You can double-click the fill handle to automatically fill all empty columns of the current data block. For example, first enter Jan into A1 and drag the fill handle down to A12 to get the twelve months in the first column. Now enter some values into B1 and C1. Select those two cells, and double-click the fill handle. This fills automatically the data block B1:C12.	連按兩下填入控點可自動填入目前資料區塊內的所有空欄。例如，先將 Jan 輸入 A1 中，然後將填入控點往下拖曳至 A12，以在第一欄中取得 12 個月。然後在 B1 和 C1 中輸入一些值。選取這兩個儲存格，然後連按兩下填入控點。這樣即可自動填入資料區塊 B1:C12。
calc_series.xhp par_idN10713 help.text	Using a Defined Series	使用已定義的排列
calc_series.xhp par_id3150749 help.text	Select the cell range in the sheet that you want to fill.	選取要填入的試算表中的儲存格範圍。
calc_series.xhp par_id3154754 help.text	Choose <item type="menuitem">Sheet - Fill Cells - Series</item>.	選擇 <item type="menuitem">[編輯] - [填入] - [排列]</item>。
calc_series.xhp par_idN10716 help.text	Select the parameters for the series.	選取排列的參數。
calc_series.xhp par_idN10731 help.text	If you select a <emph>linear</emph> series, the increment that you enter is <emph>added</emph> to each consecutive number in the series to create the next value.	如果您選取 <emph>[線性]</emph> 排列，您輸入的遞增會<emph>增加</emph>至排列中的每個連續數字以建立下一個值。
calc_series.xhp par_idN1073C help.text	If you select a <emph>growth</emph> series, the increment that you enter is <emph>multiplied</emph> by each consecutive number to create the next value.	如果您選取 <emph>[成長]</emph> 數列，您輸入的遞增會由每個連續數字<emph>相乘</emph>以建立下一個值。
calc_series.xhp par_idN10747 help.text	If you select a <emph>date</emph> series, the increment that you enter is added to the time unit that you specify.	如果您選取 <emph>[日期]</emph> 數列，您輸入的遞增會增加至所指定的時間單位。
calc_series.xhp par_id3159173 help.text	<link href="text/shared/optionen/01060400.xhp">Sort lists</link>	<link href="text/shared/optionen/01060400.xhp">排序清單</link>
calc_timevalues.xhp tit help.text	Calculating Time Differences	計算時間差異值
calc_timevalues.xhp bm_id3150769 help.text	<bookmark_value>calculating;time differences</bookmark_value><bookmark_value>time differences</bookmark_value>	<bookmark_value>計算;時間差異值</bookmark_value><bookmark_value>時間差異值</bookmark_value>
calc_timevalues.xhp hd_id3150769 help.text	<variable id="calc_timevalues"><link href="text/scalc/guide/calc_timevalues.xhp">Calculating Time Differences</link></variable>	<variable id="calc_timevalues"><link href="text/scalc/guide/calc_timevalues.xhp">計算時間差</link></variable>
calc_timevalues.xhp par_id3149263 help.text	If you want to calculate time differences, for example, the time between 23:30 and 01:10 in the same night, use the following formula:	若您要計算時間的差異值，例如同一夜裡的 23:30 到 01:10 的時間是多長，最好使用下列公式：
calc_timevalues.xhp par_id3159153 help.text	=(B2<A2)+B2-A2	=(B2<A2)+B2-A2
calc_timevalues.xhp par_id3152598 help.text	The later time is B2 and the earlier time is A2. The result of the example is 01:40 or 1 hour and 40 minutes.	接著在 B2 設定之後的時間，以及在 A2 中設定之前的時間。這個範例的結果為 01:40，也就是 1 小時 40 分鐘。

Loading…

No matching activity found.

Browse all string changes

Things to check

XML markup

XML tags in translation do not match source

Reset

Glossary

English	Chinese (Traditional)
%PRODUCTNAME Calc	%PRODUCTNAME Calc	LibreOffice UI - master
function	函式/功能	LibreOffice UI - master
select	選取	LibreOffice UI - master
Tools		LibreOffice Help - master
From the menu bar
type	類型	LibreOffice UI - master

String information

Context

calc_series.xhp
par_id3154490
help.text

Source string description

aDZ5t

Source string location

calc_series.xhp

String age

4 years ago

Last updated

8 months ago

Source string age

4 years ago

Translation file

zh-TW/helpcontent2/source/text/scalc/guide.po, string 167