Translation

04060000.xhp hd_id3159264 help.text
English rcQMa
Context English Latvian Actions
04060000.xhp
tit
help.text
Function Wizard Funkciju vednis
04060000.xhp
bm_id3147426
help.text
<bookmark_value>inserting functions; Function Wizard</bookmark_value><bookmark_value>functions;Function Wizard</bookmark_value><bookmark_value>wizards; functions</bookmark_value>
04060000.xhp
hd_id3147426
help.text
<link href="text/scalc/01/04060000.xhp" name="AutoPilot: Functions">Function</link>
04060000.xhp
par_id3145271
help.text
<variable id="funktionsautopilottext"><ahelp hid=".">Opens the <emph>Function Wizard</emph>, which helps you to interactively create formulas.</ahelp></variable>
04060000.xhp
par_id491577286833512
help.text
Before you start the Wizard, select a cell or a range of cells from the current sheet, in order to determine the position at which the formula will be inserted.
04060000.xhp
par_id8007446
help.text
You can download the complete ODFF (OpenDocument Format Formula) specification from the <link href="https://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.odt"><emph>OASIS</emph></link> web site.
04060000.xhp
par_id3159153
help.text
The <emph>Function Wizard</emph> has two tabs: <emph>Functions</emph> is used to create formulas, and <emph>Structure</emph> is used to check the formula build.
04060000.xhp
hd_id3154490
help.text
Functions Tab Funkciju cilne
04060000.xhp
hd_id3154731
help.text
Search
04060000.xhp
par_id3155440
help.text
<ahelp hid="formula/ui/functionpage/search">Search for a part of the function name.</ahelp>
04060000.xhp
hd_id3154730
help.text
Category Kategorija
04060000.xhp
par_id3153417
help.text
<variable id="kategorienliste"><ahelp hid="formula/ui/functionpage/category">Lists all the categories to which the different functions are assigned. Select a category to view the appropriate functions in the list field below.</ahelp> Select "All" to view all functions in alphabetical order, irrespective of category. "Last Used" lists the functions you have most recently used.</variable>
04060000.xhp
par_id3149378
help.text
You can browse the full <link href="text/scalc/01/04060100.xhp" name="List of Categories and Functions"><emph>List of Categories and Functions</emph></link>.
04060000.xhp
hd_id3150749
help.text
Function Funkcija
04060000.xhp
par_id3155445
help.text
<ahelp hid="formula/ui/functionpage/function">Displays the functions found under the selected category. Double-click to select a function.</ahelp> A single-click displays a short function description.
04060000.xhp
hd_id3159264
help.text
Array Masīvs
04060000.xhp
par_id3149566
help.text
<ahelp hid="formula/ui/formuladialog/array">Specifies that the selected function is inserted into the selected cell range as an array formula.</ahelp> Array formulas operate on multiple cells. Each cell in the array contains the formula, not as a copy but as a common formula shared by all matrix cells.
04060000.xhp
par_id3155959
help.text
The <emph>Array</emph> option is identical to the <switchinline select="sys"><caseinline select="MAC"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph> command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces: <emph>{ }</emph>.
04060000.xhp
par_id3152993
help.text
The maximum size of an array range is 128 by 128 cells.
04060000.xhp
hd_id3150367
help.text
Argument Input Fields Argumentu ievades lauki
04060000.xhp
par_id3145587
help.text
When you double-click a function, the argument input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell, or drag across the required range on the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using <link href="text/scalc/01/04060102.xhp" name="date entries"><emph>date entries</emph></link>, make sure you use the correct format. Click <emph>OK</emph> to insert the result into the spreadsheet.
04060000.xhp
hd_id3149408
help.text
Function Result Funkcijas rezultāts
04060000.xhp
par_id3155809
help.text
As soon you enter arguments in the function, the result is calculated. This preview informs you if the calculation can be carried out with the arguments given. If the arguments result in an error, the corresponding <link href="text/scalc/05/02140000.xhp" name="error code"><emph>error code</emph></link> is displayed.
04060000.xhp
par_id3148700
help.text
The required arguments are indicated by names in bold print.
04060000.xhp
hd_id3153064
help.text
f(x) (depending on the selected function)
04060000.xhp
par_id3157980
help.text
<ahelp hid=".">Allows you to access a subordinate level of the <emph>Function Wizard</emph> in order to nest another function within the function, instead of a value or reference.</ahelp>
04060000.xhp
hd_id3145076
help.text
Argument/Parameter/Cell Reference (depending on the selected function)
04060000.xhp
par_id3159097
help.text
The number of visible text fields depends on the function. Enter arguments either directly into the argument fields or by clicking a cell in the table.
04060000.xhp
hd_id3154957
help.text
Result Rezultāts
04060000.xhp
par_id3150211
help.text
<ahelp hid="formula/ui/formuladialog/formula_result">Displays the calculation result or an error message.</ahelp>
04060000.xhp
hd_id3151304
help.text
Formula Formula

Loading…

No matching activity found.
Browse all component changes

Things to check

Trailing space

Source and translation do not both end with a space

Fix string

Reset

Glossary

English Latvian
No related strings found in the glossary.

String information

Context
04060000.xhp
hd_id3159264
help.text
Source string description
rcQMa
Source string location
04060000.xhp
String age
8 months ago
Source string age
8 months ago
Translation file
lv/helpcontent2/source/text/scalc/01.po, string 438