LibreOffice Help - master/text/scalc/guide — English (South Africa) @ 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>.

English (South Africa)

Needs editing

Insufficient privileges for saving translations.

Skip

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	English (South Africa)
%PRODUCTNAME Calc		LibreOffice UI - master
Tools		LibreOffice Help - master
From the menu bar

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

en-ZA/helpcontent2/source/text/scalc/guide.po, string 167

Context	English	English (South Africa)
calc_date.xhp par_id3147001 help.text	The number of days between today's date and the specified date is displayed in cell A3.	The number of days between today's date and the specified date is displayed in cell 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.	Experiment with some additional formulae: 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 <item type="keycode">Enter</item> key after each formula.
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	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>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>
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">Automatically Filling in Data Based on Adjacent Cells</link></variable>
calc_series.xhp par_idN106A8 help.text	You can automatically fill cells with data with the AutoFill command or the Series command.	You can automatically fill cells with data with the AutoFill command or the Series command.
calc_series.xhp par_idN106D3 help.text	Using AutoFill	Using AutoFill
calc_series.xhp par_idN106D7 help.text	AutoFill automatically generates a data series based on a defined pattern.	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.	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.	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.	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.	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.	To quickly create a list of consecutive days, enter <item type="literal">Monday</item> in a cell, and drag the fill handle.
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>.	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 recognised in the numbers. The AutoFill function also recognises customised lists that are defined under <item type="menuitem"><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</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.	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.
calc_series.xhp par_idN10713 help.text	Using a Defined Series	Using a Defined Series
calc_series.xhp par_id3150749 help.text	Select the cell range in the sheet that you want to fill.	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>.	Choose <item type="menuitem">Edit - Fill - Series</item>.
calc_series.xhp par_idN10716 help.text	Select the parameters for the series.	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.	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.
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.	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.
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.	If you select a <emph>date</emph> series, the increment that you enter is added to the time unit that you specify.
calc_series.xhp par_id3159173 help.text	<link href="text/shared/optionen/01060400.xhp">Sort lists</link>	<link href="text/shared/optionen/01060400.xhp">Sort lists</link>
calc_timevalues.xhp tit help.text	Calculating Time Differences	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>calculating;time differences</bookmark_value><bookmark_value>time differences</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">Calculating Time Differences</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:	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:
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.	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.