User: kristynakitz Date: 2008-08-04 15:51:58+0000 Modified: cs/po/helpcontent2/source/text/scalc/01.po
Log: File Changes: Directory: /cs/po/helpcontent2/source/text/scalc/ ================================================= File [changed]: 01.po Url: http://cs.openoffice.org/source/browse/cs/po/helpcontent2/source/text/scalc/01.po?r1=1.320&r2=1.321 Delta lines: +126 -119 ----------------------- --- 01.po 2008-07-11 05:37:09+0000 1.320 +++ 01.po 2008-08-04 15:51:55+0000 1.321 @@ -7,8 +7,8 @@ "Project-Id-Version: 01\n" "Report-Msgid-Bugs-To: http://qa.openoffice.org/issues/enter_bug.cgi?subcomponent=ui&comment=&short_desc=Localization%20issue%20in%20file%3A%20helpcontent2/source/text/scalc/01.oo&component=l10n&form_name=enter_issue\n"; "POT-Creation-Date: 2008-06-04 09:15+0200\n" -"PO-Revision-Date: 2008-07-11 07:34+0200\n" -"Last-Translator: Adam Rambousek <[EMAIL PROTECTED]>\n" +"PO-Revision-Date: 2008-08-04 15:56+0200\n" +"Last-Translator: Kristyna Kitzbergerova <[EMAIL PROTECTED]>\n" "Language-Team: Czech <[EMAIL PROTECTED]>\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" @@ -7444,7 +7444,7 @@ #: 04060106.xhp#par_id3151884.625.help.text msgid "The formula is based on the fact that the result of a comparison is 1 if the criterion is met and 0 if it is not met. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix." -msgstr "" +msgstr "Vzorec je založen na skuteÄnosti, že výsledek porovnánà je 1, jsou-li kritéria splnÄna, a 0, nejsou-li splnÄna. Jednotlivé výsledky porovnánà budou zpracovány jako pole a použity pÅi násobenà matic. Výsledné hodnoty budou seskupeny do matice." #: 04060106.xhp#bm_id3151957.help.text msgid "<bookmark_value>SUMIF function</bookmark_value><bookmark_value>adding;specified numbers</bookmark_value>" @@ -8114,7 +8114,7 @@ #: 04060106.xhp#par_id9312417.help.text msgid "To generate random numbers which never recalculate, copy cells each containing =RAND(), and use <item type=\"menuitem\">Edit - Paste Special</item> (with <item type=\"menuitem\">Paste All</item> and <item type=\"menuitem\">Formulas</item> not marked and <item type=\"menuitem\">Numbers</item> marked)." -msgstr "" +msgstr "Pro generaci dále nemÄnných náhodných ÄÃsel, zkopÃrujte buÅky obsahujÃcà =RAND() a použijte <item type=\"menuitem\"> Ãpravy - Vložit jinak</item> (s neoznaÄanými položkami <item type=\"menuitem\">Vložit vÅ¡e</item> a <item type=\"menuitem\">Vzorce</item> a s oznaÄenou položkou <item type=\"menuitem\">ÄÃsla</item>)." #: 04060106.xhp#hd_id9089022.help.text msgctxt "04060106.xhp#hd_id9089022.help.text" @@ -8164,31 +8164,31 @@ #: 04060106.xhp#par_id3166505.627.help.text msgid "A1:A10 is a cell range containing the numbers <item type=\"input\">2000</item> to <item type=\"input\">2009</item>. Cell B1 contains the number <item type=\"input\">2006</item>. In cell B2, you enter a formula:" -msgstr "" +msgstr "A1:A10 je pole bunÄk obsahujÃcà ÄÃsla <item type=\"input\">2000</item> až <item type=\"input\">2009</item>. BuÅka B1 obsahuje ÄÃslo <item type=\"input\">2006</item>. Do buÅky B2 vložÃte tento vzorec:" #: 04060106.xhp#par_id3581652.help.text msgid "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - this returns 1" -msgstr "" +msgstr "<item type=\"input\">=COUNTIF(A1:A10;2006)</item> - toto vrátà 1" #: 04060106.xhp#par_id708639.help.text msgid "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - this returns 1" -msgstr "" +msgstr "<item type=\"input\">=COUNTIF(A1:A10;B1)</item> - toto vrátà 1" #: 04060106.xhp#par_id5169225.help.text msgid "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- this returns 3" -msgstr "" +msgstr "<item type=\"input\">=COUNTIF(A1:A10;\">=2006\") </item>- toto vrátà 3" #: 04060106.xhp#par_id2118594.help.text msgid "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - when B1 contains <item type=\"input\">2006</item>, this returns 6" -msgstr "" +msgstr "<item type=\"input\">=COUNTIF(A1:A10;\"<\"&B1)</item> - obsahuje-li B1 <item type=\"input\">2006</item>, výsledek bude 6" #: 04060106.xhp#par_id166020.help.text msgid "<item type=\"input\">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type=\"input\">>2006</item> counts the number of cells in the range A1:A10 which are >2006 " -msgstr "" +msgstr "<item type=\"input\">=COUNTIF(A1:A10;C2)</item>, kde buÅka C2 obsahuje text <item type=\"input\">>2006</item>, vrátà poÄet bunÄk v rozmezà A1:A10, které jsou >2006 " #: 04060106.xhp#par_id6386913.help.text msgid "To count only negative numbers: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" -msgstr "" +msgstr "Pro výpoÄet pouze záporných ÄÃsel: <item type=\"input\">=COUNTIF(A1:A10;\"<0\")</item>" #: 04060107.xhp#tit.help.text msgctxt "04060107.xhp#tit.help.text" @@ -8313,6 +8313,9 @@ "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys" "\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10." msgstr "" +"Pro vynásobenà hodnot ve vÅ¡ech buÅkách pole deseti, nemusÃte použÃt vzorec na každou buÅku nebo hodnotu. MÃsto toho použijte jednoduchý maticový vzorec. Vyberte pole o buÅkách 3 x 3 v jiné Äásti seÅ¡itu, vložte vzorec <item type=\"input\">=10*A1:C3</item> a potvrÄte jej kombinacà kláves <switchinline select=\"sys" +"\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. " +"Výsledkem je 3 x 3 matice, ve které jsou jednotlivé hodnoty v poli bunÄk (A1:C3) vynásobené faktorem 10." #: 04060107.xhp#par_id3149156.280.help.text msgid "In addition to multiplication, you can also use other operators on the reference range (an array). With $[officename] Calc, you can add (+), subtract (-), multiply (*), divide (/), use exponents (^), concatenation (&) and comparisons (=, <>, <, >, <=, >=). The operators can be used on each individual value in the cell range and return the result as an array if the array formula was entered." @@ -8320,7 +8323,7 @@ #: 04060107.xhp#par_id3166456.326.help.text msgid "Comparison operators in an array formula treat empty cells in the same way as in a normal formula, that is, either as zero or as an empty string. For example, if cells A1 and A2 are empty the array formulas <item type=\"input\">{=A1:A2=\"\"}</item> and <item type=\"input\">{=A1:A2=0}</item> will both return a 1 column 2 row array of cells containing TRUE." -msgstr "" +msgstr "Porovnávacà operátory ve vzorci zpracovávajà prázdné buÅky stejným způsobem jako normálnà vzorec, který existuje buÄ jako nula nebo jako prázdný ÅetÄzec. NapÅÃklad jsou-li buÅky A1 a A2 prázdné, oba vzorce <item type=\"input\">{=A1:A2=\"\"}</item> a <item type=\"input\">{=A1:A2=0}</item> vrátà jeden sloupec a 2 Åádky obsahujÃcà TRUE." #: 04060107.xhp#hd_id3150713.281.help.text msgid "When do you use array formulas?" @@ -8402,7 +8405,7 @@ #: 04060107.xhp#par_id6757103.help.text msgid "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press Ctrl+Shift+Enter." -msgstr "" +msgstr "Pro vloženà této matice konstant, vyberte 3 buÅky v Åádce a poté napiÅ¡te vzorec <item type=\"input\">={1;2;3}</item> s použitÃm složených závorek a stÅednÃků, poté kliknÄte na Ctrl+Shift+Enter." #: 04060107.xhp#par_id8868068.help.text msgid "={1;2;3|4;5;6}" @@ -8740,11 +8743,11 @@ #: 04060107.xhp#par_id3151260.19.help.text msgid "Without deselecting the range, select the MUNIT function. Mark the <emph>Array</emph> check box. Enter the desired dimensions for the array unit, in this case <item type=\"input\">5</item>, and click <emph>OK</emph>." -msgstr "" +msgstr "Without deselecting the range, select the MUNIT function. Mark the <emph>Array</emph> check box. Enter the desired dimensions for the array unit, in this case <item type=\"input\">5</item>, and click <emph>OK</emph>." #: 04060107.xhp#par_id3150403.20.help.text msgid "You can also enter the <item type=\"input\">=Munit(5)</item> formula in the last cell of the selected range (E5), and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter </caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>." -msgstr "" +msgstr "Můžete také vložit vzorec <item type=\"input\">=Munit(5)</item> do poslednà buÅky vybraného rozmezà (E5) a poté stisknout <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter </caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>." #: 04060107.xhp#par_id3156143.21.help.text msgid "You now see a unit array with a range of A1:E5." @@ -9173,21 +9176,21 @@ #: 04060107.xhp#par_id3152839.67.help.text msgid "LINEST(DataY; DataX; LinearType; Stats)" -msgstr "" +msgstr "LINEST(DataY; DataX; TypLinie; Parametr)" #: 04060107.xhp#par_id3152853.68.help.text msgctxt "04060107.xhp#par_id3152853.68.help.text" msgid "<emph>DataY</emph> represents the Y Data array." -msgstr "" +msgstr "<emph>DataY</emph> reprezentuje data Y." #: 04060107.xhp#par_id3154428.69.help.text msgctxt "04060107.xhp#par_id3154428.69.help.text" msgid "<emph>DataX</emph> (optional) represents the X Data array." -msgstr "" +msgstr "<emph>DataX</emph> (volitelné) reprezentuje data X." #: 04060107.xhp#par_id3154448.70.help.text msgid "<emph>LinearType</emph> (optional). If the line goes through the zero point, then set LinearType = 0." -msgstr "" +msgstr "<emph>TypLinie</emph> (volitelné). Pokud linie procházà bodem nula, potom nastavte TypLinie = 0." #: 04060107.xhp#par_id3154142.71.help.text msgid "<emph>Stats</emph> (optional). If Stats=0, only the regression coefficient is to be calculated. Otherwise, you will see other stats." @@ -9210,11 +9213,11 @@ #: 04060107.xhp#par_id3154176.73.help.text msgid "This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select DataY. If you want, you can enter other parameters. Select <emph>Array</emph> and click <emph>OK</emph>." -msgstr "" +msgstr "Tato funkce vracà matici a je ovládána stejným způsobem jako jiné maticové funkce. Vyberte oblast pro výsledek a poté funkci. Vyberte DataY. Pokud chcete, můžete vybrat i dalÅ¡Ã parametry. Vyberte <emph>Pole</emph> a kliknÄte na <emph>OK</emph>." #: 04060107.xhp#par_id3155468.74.help.text msgid "The results returned by the system (if Stats = 0), will at least show the slope of the regression line and its intersection with the Y axis. If Stats does not equal 0, other results are to be displayed." -msgstr "" +msgstr "Výsledek vrácený systémem (pokud parametr = 0) bude ukazovat minimálnÄ spád regresnà linie a jejà průseÄÃk s osou Y. Pokud se parametr nerovná 0, bude zobrazen jiný výsledek." #: 04060107.xhp#hd_id3155491.75.help.text msgid "Other LINEST Results:" @@ -9483,15 +9486,15 @@ #: 04060107.xhp#par_id3158020.133.help.text msgid "<emph>DataY</emph> is C2:C8" -msgstr "" +msgstr "<emph>DataY</emph> je C2:C8" #: 04060107.xhp#par_id3158039.134.help.text msgid "<emph>DataX</emph> is A2:B8" -msgstr "" +msgstr "<emph>DataX</emph> je A2:B8" #: 04060107.xhp#par_id3158058.135.help.text msgid "<emph>LinearType</emph> and <emph>Stats</emph> are both set to 1." -msgstr "" +msgstr "<emph>TypLinie</emph> a <emph>Parametr</emph> jsou oba nastaveny na 1." #: 04060107.xhp#par_id3158084.136.help.text msgid "As soon as you click <emph>OK</emph>, $[officename] Calc will fill the above example with the LINEST values as shown in the example." @@ -9499,7 +9502,7 @@ #: 04060107.xhp#par_id3158106.137.help.text msgid "The formula in the <emph>Formula</emph> Bar corresponds to each cell of the LINEST array <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>" -msgstr "" +msgstr "Vzorec v panelu <emph>Vzorec</emph> odpovÃdá každé buÅce v matici LINEST <item type=\"input\">{=LINEST(C2:C8;A2:B8;1;1)}</item>" #: 04060107.xhp#par_id3158128.138.help.text msgid "<emph>This represents the calculated LINEST values:</emph>" @@ -9507,11 +9510,11 @@ #: 04060107.xhp#bm_id3158146.help.text msgid "<bookmark_value>slopes, see also regression lines</bookmark_value><bookmark_value>regression lines;LINEST function</bookmark_value>" -msgstr "" +msgstr "<bookmark_value>smÄrnice, viz také regresnà linie</bookmark_value><bookmark_value>regresnà linie; funkce LINEST</bookmark_value>" #: 04060107.xhp#par_id3158146.139.help.text msgid "E2 and F2: Slope m of the regression line y=b+m*x for the x1 and x2 values. The values are given in reverse order; that is, the slope for x2 in E2 and the slope for x1 in F2." -msgstr "" +msgstr "E2a F2: SmÄrnice m regresnà linie y=b+m*x pro hodnoty x1 a x2. Hodnoty jsou dány v opaÄném poÅadÃ, tzn. smÄrnice pro x2 v E2 a smÄrnice pro x1 v F2." #: 04060107.xhp#par_id3158184.140.help.text msgid "G2: Intersection b with the y axis." @@ -9581,21 +9584,21 @@ #: 04060107.xhp#par_id3163123.153.help.text msgid "LOGEST(DataY; DataX; FunctionType; Stats)" -msgstr "" +msgstr "LOGEST(DataY; DataX; TypFunkce; Parametr)" #: 04060107.xhp#par_id3163137.154.help.text msgctxt "04060107.xhp#par_id3163137.154.help.text" msgid "<emph>DataY</emph> represents the Y Data array." -msgstr "" +msgstr "<emph>DataY</emph> reprezentuje data Y." #: 04060107.xhp#par_id3163155.155.help.text msgctxt "04060107.xhp#par_id3163155.155.help.text" msgid "<emph>DataX</emph> (optional) represents the X Data array." -msgstr "" +msgstr "<emph>DataX</emph> (volitelné) reprezentuje data X." #: 04060107.xhp#par_id3163174.156.help.text msgid "<emph>FunctionType</emph> (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." -msgstr "" +msgstr "<emph>TypFunkce</emph> (volitelné). Pokud je Typ_Funkce = 0, bude vzpoÄÃtána funkce ve tvaru y = m^x. Jinak se vypoÄÃtá funkce y = b*m^x." #: 04060107.xhp#par_id3163196.157.help.text msgid "<emph>Stats</emph> (optional). If Stats=0, only the regression coefficient is calculated." @@ -9639,11 +9642,11 @@ #: 04060107.xhp#par_id3163347.164.help.text msgid "SUMPRODUCT(Array1; Array2...Array30)" -msgstr "" +msgstr "SUMPRODUCT(Pole1; Pole2...Pole30)" #: 04060107.xhp#par_id3163362.165.help.text msgid "<emph>Array1, Array2...Array30</emph> represent arrays whose corresponding elements are to be multiplied." -msgstr "" +msgstr "<emph>Pole1, Pole2...Pole30</emph> reprezentuje pole, která odpovÃdajà elementům násobenÃ." #: 04060107.xhp#par_idN11B19.help.text msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed." @@ -9750,7 +9753,7 @@ #: 04060107.xhp#par_idN11BA1.help.text msgid "<item type=\"input\">=SUMPRODUCT(A1:B3;C1:D3)</item> returns 397." -msgstr "" +msgstr "<item type=\"input\">=SUMPRODUCT(A1:B3;C1:D3)</item> vrátà 397." #: 04060107.xhp#par_idN11BA4.help.text msgid "Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3" @@ -9788,15 +9791,15 @@ #: 04060107.xhp#par_id3144903.172.help.text msgid "SUMX2MY2(ArrayX; ArrayY)" -msgstr "" +msgstr "SUMX2MY2(PoleX; PoleY)" #: 04060107.xhp#par_id3144916.173.help.text msgid "<emph>ArrayX</emph> represents the first array whose elements are to be squared and added." -msgstr "" +msgstr "<emph>PoleX</emph> reprezentuje prvnà pole, jehož elementy budou umocnÄny na druhou a pÅidány." #: 04060107.xhp#par_id3144936.174.help.text msgid "<emph>ArrayY</emph> represents the second array whose elements are to be squared and subtracted." -msgstr "" +msgstr "<emph>PoleY</emph> reprezentuje druhé pole, jehož elementy budou umocnÄny na druhou a odeÄteny." #: 04060107.xhp#par_idN11D6B.help.text msgctxt "04060107.xhp#par_idN11D6B.help.text" @@ -9822,15 +9825,15 @@ #: 04060107.xhp#par_id3163404.181.help.text msgid "SUMX2PY2(ArrayX; ArrayY)" -msgstr "" +msgstr "SUMX2PY2(PoleX; PoleY)" #: 04060107.xhp#par_id3163417.182.help.text msgid "<emph>ArrayX</emph> represents the first array whose arguments are to be squared and added." -msgstr "" +msgstr "<emph>PoleX</emph> reprezentuje prvnà pole, jehož argumenty budou umocnÄny na druhou a pÅidány." #: 04060107.xhp#par_id3163437.183.help.text msgid "<emph>ArrayY</emph> represents the second array, whose elements are to be added and squared." -msgstr "" +msgstr "<emph>PoleY</emph> reprezentuje druhé pole, jehož argumenty budou pÅidány a umocnÄny na druhou." #: 04060107.xhp#par_idN11E45.help.text msgctxt "04060107.xhp#par_idN11E45.help.text" @@ -9856,15 +9859,15 @@ #: 04060107.xhp#par_id3163588.190.help.text msgid "SUMXMY2(ArrayX; ArrayY)" -msgstr "" +msgstr "SUMXMY2(PoleX; PoleY)" #: 04060107.xhp#par_id3163601.191.help.text msgid "<emph>ArrayX</emph> represents the first array whose elements are to be subtracted and squared." -msgstr "" +msgstr "<emph>PoleX</emph> reprezentuje prvnà pole, jehož elementy budou odeÄteny a umocnÄny na druhou." #: 04060107.xhp#par_id3163621.192.help.text msgid "<emph>ArrayY</emph> represents the second array, whose elements are to be subtracted and squared." -msgstr "" +msgstr "<emph>PoleY</emph> reprezentuje druhé pole, jehož elementy budou odeÄteny a umocnÄny na druhou.." #: 04060107.xhp#par_idN11F1F.help.text msgctxt "04060107.xhp#par_idN11F1F.help.text" @@ -9890,25 +9893,25 @@ #: 04060107.xhp#par_id3166122.199.help.text msgid "TREND(DataY; DataX; NewDataX; LinearType)" -msgstr "" +msgstr "TREND(DataY; DataX; NováDataX; TypLinie)" #: 04060107.xhp#par_id3166137.200.help.text msgctxt "04060107.xhp#par_id3166137.200.help.text" msgid "<emph>DataY</emph> represents the Y Data array." -msgstr "" +msgstr "<emph>DataY</emph> reprezentuje data Y." #: 04060107.xhp#par_id3166156.201.help.text msgctxt "04060107.xhp#par_id3166156.201.help.text" msgid "<emph>DataX</emph> (optional) represents the X Data array." -msgstr "" +msgstr "<emph>DataX</emph> (volitelné) reprezentuje data X." #: 04060107.xhp#par_id3166176.202.help.text msgid "<emph>NewDataX</emph> (optional) represents the array of the X data, which are used for recalculating values." -msgstr "" +msgstr "<emph>NováDataX</emph> (volitelné) reprezentuje pole dat X, které jsou použity pro pÅepoÄÃtánà hodnot." #: 04060107.xhp#par_id3166196.203.help.text msgid "<emph>LinearType</emph>(Optional). If LinearType = 0, then lines will be calculated through the zero point. Otherwise, offset lines will also be calculated. The default is LinearType <> 0." -msgstr "" +msgstr "<emph>TypLinie</emph>(volitelné). Pokud je TypLinie = 0, potom linie budou poÄÃtány pÅes poÄátek. Jinak bude také vypoÄÃtáno odsazenà liniÃ. Výchozà TypLinie je <> 0." #: 04060107.xhp#par_idN11D2F.help.text msgctxt "04060107.xhp#par_idN11D2F.help.text" @@ -9948,25 +9951,25 @@ #: 04060107.xhp#par_id3166377.210.help.text msgid "GROWTH(DataY; DataX; NewDataX; FunctionType)" -msgstr "" +msgstr "GROWTH(DataY; DataX; NováDataX; TypFunkce)" #: 04060107.xhp#par_id3166392.211.help.text msgctxt "04060107.xhp#par_id3166392.211.help.text" msgid "<emph>DataY</emph> represents the Y Data array." -msgstr "" +msgstr "<emph>DataY</emph> reprezentujà data Y." #: 04060107.xhp#par_id3166411.212.help.text msgctxt "04060107.xhp#par_id3166411.212.help.text" msgid "<emph>DataX</emph> (optional) represents the X Data array." -msgstr "" +msgstr "<emph>DataX</emph> (volitelné) reprezentuje data X." #: 04060107.xhp#par_id3173797.213.help.text msgid "<emph>NewDataX</emph> (optional) represents the X data array, in which the values are recalculated." -msgstr "" +msgstr "<emph>NováDataX</emph> (volitelné) reprezentujà data X, ve kterých budou pÅepoÄÃtány hodnoty." #: 04060107.xhp#par_id3173817.214.help.text msgid "<emph>FunctionType</emph>(optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." -msgstr "" +msgstr "<emph>TypFunkce</emph>(volitelné). Je-li TypFunkce = 0, bude vypoÄÃtána funkce ve tvaru y = m^x. Jinak se vypoÄÃtá funkce y = b*m^x." #: 04060107.xhp#par_idN11DFD.help.text msgctxt "04060107.xhp#par_idN11DFD.help.text" @@ -9985,7 +9988,7 @@ #: 04060107.xhp#par_id3173852.216.help.text msgid "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select DataY. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>." -msgstr "" +msgstr "Tato funkce vracà matici a je ovládána stejným způsobem jako jiné maticové funkce. Vyberte oblast, kde chcete, aby se objevily odpovÄdi a poté zvolte funkci." #: 04060108.xhp#tit.help.text msgctxt "04060108.xhp#tit.help.text" @@ -10026,11 +10029,11 @@ #: 04060108.xhp#par_id3153551.13.help.text msgid "x value" -msgstr "" +msgstr "hodnota x" #: 04060108.xhp#par_id3147536.14.help.text msgid "y value" -msgstr "" +msgstr "hodnota y" #: 04060108.xhp#par_id3153224.15.help.text msgctxt "04060108.xhp#par_id3153224.15.help.text" @@ -10180,19 +10183,19 @@ #: 04060109.xhp#par_id3154707.6.help.text msgid "ADDRESS(Row; Column; Abs; \"Sheet\")" -msgstr "" +msgstr "ADDRESS(Åádek; Sloupek; Abs; \"SeÅ¡it\")" #: 04060109.xhp#par_id3147505.7.help.text msgid "<emph>Row</emph> represents the row number for the cell reference" -msgstr "" +msgstr "<emph>Åádek</emph> reprezentuje Åádek ÄÃsel adresy buÅky." #: 04060109.xhp#par_id3145323.8.help.text msgid "<emph>Column</emph> represents the column number for the cell reference (the number, not the letter)" -msgstr "" +msgstr "<emph>Sloupec</emph> reprezentuje sloupec ÄÃsel adresy buÅky (ÄÃsla, ne pÃsmena)." #: 04060109.xhp#par_id3153074.9.help.text msgid "<emph>Abs</emph> determines the type of reference:" -msgstr "" +msgstr "<emph>Abs</emph>urÄuje typ adresy:" #: 04060109.xhp#par_id3153298.10.help.text msgid "1: absolute ($A$1)" @@ -10212,7 +10215,7 @@ #: 04060109.xhp#par_id3153962.14.help.text msgid "<emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes." -msgstr "" +msgstr "<emph>SeÅ¡it</emph> reprezentuje jméno seÅ¡itu. Musà být umÃstÄno v uvozovkách." #: 04060109.xhp#hd_id3147299.15.help.text msgid "Example:" @@ -10220,11 +10223,11 @@ #: 04060109.xhp#par_id3148744.16.help.text msgid "<item type=\"input\">=ADDRESS(1;1;2;\"Sheet2\")</item> returns the following: Sheet2.A$1" -msgstr "" +msgstr "<item type=\"input\">=ADDRESS(1;1;2;\"SeÅ¡it2\")</item> vracà následujÃcÃ: SeÅ¡it2.A$1" #: 04060109.xhp#par_id3159260.17.help.text msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." -msgstr "" +msgstr "Obsahuje-li buÅka A1 v seÅ¡itÄ2 hodnotu <item type=\"input\">-6</item>, můžete odkazovat nepÅÃmo na adresu buÅky s použitÃm funkce vloženÃm do B2 <item type=\"input\">=ABS(INDIRECT(B2))</item>. Výsledkem je absolutnà hodnota adresy buÅky specifikované v B2, která je v tomto pÅÃpadÄ 6." #: 04060109.xhp#bm_id3150372.help.text msgid "<bookmark_value>AREAS function</bookmark_value>" @@ -10258,11 +10261,11 @@ #: 04060109.xhp#par_id3149946.25.help.text msgid "<item type=\"input\">=AREAS(A1:B3;F2;G1)</item> returns 3, as it is a reference to three cells and/or areas." -msgstr "" +msgstr "<item type=\"input\">=AREAS(A1:B3;F2;G1)</item>vracà 3, protože se jedná o odkaz na 3 buÅky a/nebo oblasti." #: 04060109.xhp#par_id3146820.26.help.text msgid "<item type=\"input\">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>." -msgstr "" +msgstr "<item type=\"input\">=AREAS(All)</item> vracà 1, pokud máte definovanou oblast pojmenovanou All v menu <emph>Data - Definovat oblast</emph>." #: 04060109.xhp#bm_id3148727.help.text msgid "<bookmark_value>DDE function</bookmark_value>" @@ -10287,7 +10290,7 @@ #: 04060109.xhp#par_id3148886.31.help.text msgid "DDE(\"Server\"; \"File\"; \"Range\"; Mode)" -msgstr "" +msgstr "DDE(\"Server\"; \"Soubor\"; \"Oblast\"; Režim)" #: 04060109.xhp#par_id3154842.32.help.text msgid "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"Soffice\"." @@ -10347,13 +10350,15 @@ #: 04060109.xhp#par_id3148734.36.help.text msgid "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\data1.sxc\";\"sheet1.A1\")</item> reads the contents of cell A1 in sheet1 of the <item type=\"productname\">%PRODUCTNAME</item> Calc spreadsheet data1.sxc." -msgstr "" +msgstr "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\data1.sxc\";\"sheet1.A1\")</item>Äte obsah buÅky A1 v seÅ¡itÄ1 <item type=\"productname\">%PRODUCTNAME</item> Calc seÅ¡itu data1.sxc." #: 04060109.xhp#par_id3153081.37.help.text msgid "" "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\motto.sxw\";\"Today's motto\")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.sxw document containing the motto text and define it as the first line of a section named <item type=\"literal\">Today's Motto</item> (in <item type=\"productname\">%PRODUCTNAME</item> Writer under " "<emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type=\"productname\">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type=\"productname\">%PRODUCTNAME</item> Calc cells in which this DDE link is defined." msgstr "" +"<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\motto.sxw\";\"Moto dne\")</item> Vracà moto v buÅce obsahujÃcà tento vzorec. PrvnÄ musÃte vložit linii do dokumentu motto.sxw obsahujÃcà text mota a definovat ji jako prvnà linii sekce pojmenované <item type=\"literal\">Moto dne</item> (v <item type=\"productname\">%PRODUCTNAME</item> Writer v menu" +"<emph>Vložit - Sekce</emph>). Pokud je moto definováno (a uloženo) v dokumentu <item type=\"productname\">%PRODUCTNAME</item> Writer, moto je aktualizováno ve vÅ¡ech buÅkách <item type=\"productname\">%PRODUCTNAME</item> Calc, ve kterých je tento DDE odkaz definován." #: 04060109.xhp#bm_id3153114.help.text msgid "<bookmark_value>ERRORTYPE function</bookmark_value>" @@ -10391,7 +10396,7 @@ #: 04060109.xhp#par_id3146904.45.help.text msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." -msgstr "" +msgstr "Pokud buÅka A1 zobrazà Err:518, funkce <item type=\"input\">=ERRORTYPE(A1)</item> vracà ÄÃslo 518." #: 04060109.xhp#bm_id3151221.help.text msgid "<bookmark_value>INDEX function</bookmark_value>" @@ -10403,7 +10408,7 @@ #: 04060109.xhp#par_id3150268.48.help.text msgid "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_INDEX\">INDEX vracà podoblast specifikovanou ÄÃslami Åádků a sloupců nebo volitelným indexem oblasti. V závislosti na obsahu INDEX vracà odkaz nebo obsah." #: 04060109.xhp#hd_id3156063.49.help.text msgctxt "04060109.xhp#hd_id3156063.49.help.text" @@ -10412,23 +10417,23 @@ #: 04060109.xhp#par_id3149007.50.help.text msgid "INDEX(Reference; Row; Column; Range)" -msgstr "" +msgstr "INDEX(Odkaz; Åádek; Sloupec; Oblast)" #: 04060109.xhp#par_id3153260.51.help.text msgid "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the reference or range name in parentheses." -msgstr "" +msgstr "<emph>Odkaz</emph> je odkaz vložený buÄ pÅÃmo, nebo pomocà specifikovánà jména oblasti. Pokud se odkaz zkládá z vÃce oblastÃ, musÃte pÅipojit jméno odkazu nebo oblasti v kulatých závorkách. " #: 04060109.xhp#par_id3145302.52.help.text msgid "<emph>Row</emph> (optional) represents the row index of the reference range, for which to return a value. In case of zero (no specific row) all referenced rows are returned." -msgstr "" +msgstr "<emph>Åádek</emph> (volitelné) reprezentuje index Åádku adresy oblasti, pro kterou vracà hodnotu. V pÅÃpadÄ nuly (nespecifikovaná Åádka) budou vráceny vÅ¡echny odkazované Åádky." #: 04060109.xhp#par_id3154628.53.help.text msgid "<emph>Column</emph> (optional) represents the column index of the reference range, for which to return a value. In case of zero (no specific column) all referenced columns are returned." -msgstr "" +msgstr "<emph>Sloupec</emph> (volitelné) reprezentuje index sloupce adresy oblasti, pro kterou vracà hodnotu. V pÅÃpadÄ nuly (nespecifikovaný sloupec) budou vráceny vÅ¡echny sloupce." #: 04060109.xhp#par_id3155514.54.help.text msgid "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range." -msgstr "" +msgstr "<emph>Oblast</emph> (volitelné) reprezentuje index podoblasti, pokud existuje odkaz do vÃcenásobné oblasti." #: 04060109.xhp#hd_id3145264.55.help.text msgctxt "04060109.xhp#hd_id3145264.55.help.text" @@ -10437,33 +10442,35 @@ #: 04060109.xhp#par_id3159112.56.help.text msgid "<item type=\"input\">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>." -msgstr "" +msgstr "<item type=\"input\">=INDEX(Ceny;4;1)</item> vrátà hodnotu od Åádky 4 a sloupce 1 oblasti databáze definované v <emph>Data - Definice</emph> jako <emph>Ceny</emph>." #: 04060109.xhp#par_id3150691.57.help.text msgid "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Insert - Names - Define</emph>." -msgstr "" +msgstr "<item type=\"input\">=INDEX(SumX;4;1)</item> vrátà hodnoty z oblasti <emph>SumX</emph> v Åádce 4 a sloupci 1jak je definováno v menu <emph>Vložit - Jména - Definovat</emph>." #: 04060109.xhp#par_id4109012.help.text msgid "<item type=\"input\">=INDEX(A1:B6;1)</item> returns a reference to the first row of A1:B6." -msgstr "" +msgstr "<item type=\"input\">=INDEX(A1:B6;1)</item> vrátà odkaz na prvnà Åádek oblasti A1:B6." #: 04060109.xhp#par_id9272133.help.text msgid "<item type=\"input\">=INDEX(A1:B6;0;1)</item> returns a reference to the first column of A1:B6." -msgstr "" +msgstr "<item type=\"input\">=INDEX(A1:B6;0;1)</item> vrátà odkaz na prvnà sloupec oblasti A1:B6." #: 04060109.xhp#par_id3158419.58.help.text msgid "" "<item type=\"input\">=INDEX((multi);4;1)</item> indicates the value contained in row 4 and column 1 of the (multiple) range, which you named under <emph>Insert - Names - Set</emph> as <emph>multi</emph>. The multiple range may consist of several rectangular ranges, each with a row 4 and column 1. If you now want to call the second block of this multiple range enter the number <item type=\"input" "\">2</item> as the <emph>range</emph> parameter." msgstr "" +"<item type=\"input\">=INDEX((multi);4;1)</item> ukazuje hodnotu obsaženou v Åádce 4 a sloupci 1 (vÃcenásobné) oblasti, kterou jste pojmenovali v menu <emph>Vložit - Jméno - Nastavit</emph> jako <emph>multi</emph>. VÃcenásobná oblast se může skládat z nÄkolika obdélnÃkových oblastÃ, každá s Åádkou 4 a sloupcem 1. Chcete-li nynà zavolat druhý blok vÃcenásobné oblasti, vložte ÄÃslo <item type=\"input" +"\">2</item> jako parametr <emph>oblasti</emph>." #: 04060109.xhp#par_id3148595.59.help.text msgid "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range." -msgstr "" +msgstr "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indikuje hodnotu v hornà levé Äásti oblasti A1:B6." #: 04060109.xhp#par_id9960020.help.text msgid "<item type=\"input\">=INDEX((multi);0;0;2)</item> returns a reference to the second range of the multiple range." -msgstr "" +msgstr "<item type=\"input\">=INDEX((multi);0;0;2)</item> vrátà odkaz na druhou oblast vÃcenásobné oblasti." #: 04060109.xhp#bm_id3153181.help.text msgid "<bookmark_value>INDIRECT function</bookmark_value>" @@ -10484,11 +10491,11 @@ #: 04060109.xhp#par_id3149824.65.help.text msgid "INDIRECT(Ref)" -msgstr "" +msgstr "INDIRECT(Odkaz)" #: 04060109.xhp#par_id3154317.66.help.text msgid "<emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents." -msgstr "" +msgstr "<emph>Odkaz</emph> reprezentuje odkaz na buÅku nebo oblast (ve formÄ textu), pro kterou se vracà obsah." #: 04060109.xhp#par_idN10CAE.help.text msgid "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT(\"filename!sheetname\"&B1) is not converted into the Calc address in INDIRECT(\"filename.sheetname\"&B1)." @@ -10496,7 +10503,7 @@ #: 04060109.xhp#par_id7687917.help.text msgid "INDIRECT cannot resolve range names as in INDIRECT(\"RangeName\")." -msgstr "" +msgstr "INDIRECT nemůže vyÅeÅ¡it jméno oblasti jako v INDIRECT(\"JménoOblasti\")." #: 04060109.xhp#hd_id3150389.67.help.text msgctxt "04060109.xhp#hd_id3150389.67.help.text" @@ -10505,11 +10512,11 @@ #: 04060109.xhp#par_id3150608.68.help.text msgid "<item type=\"input\">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference and cell C108 contains a value of <item type=\"input\">100</item>." -msgstr "" +msgstr "<item type=\"input\">=INDIRECT(A1)</item> se rovná 100, pokud A1 obsahuje C108 jako odkaz a buÅka C108 obsahuje hodnotu <item type=\"input\">100</item>." #: 04060109.xhp#par_id3083286.181.help.text msgid "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> totals the cells in the area of A1 up to the cell with the address defined by row 1 and column 3. This means that area A1:C1 is totaled." -msgstr "" +msgstr "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> seÄte buÅky v oblasti A1 až do buÅky s adresou definovanou Åádkou 1 a sloupcem 3. To znamená, že oblast A1:C1 je seÄtena." #: 04060109.xhp#bm_id3691824.help.text msgid "<bookmark_value>INFO function</bookmark_value>" @@ -10530,15 +10537,15 @@ #: 04060109.xhp#par_id3928952.help.text msgid "INFO(\"Type\")" -msgstr "" +msgstr "INFO(\"Typ\")" #: 04060109.xhp#par_id5206762.help.text msgid "The following table lists the values for the text parameter \"<item type=\"literal\">Type\"</item> and the return values of the INFO function." -msgstr "" +msgstr "NásledujÃcà tabulka zobrazuje hodnoty textového parametru \"<item type=\"literal\">Typ\"</item> a vracà hodnotu funkce INFO." #: 04060109.xhp#par_id5735953.help.text msgid "Value for \"Type\"" -msgstr "" +msgstr "Hodnota pro \"Typ\"" #: 04060109.xhp#par_id8360850.help.text msgid "Return value" @@ -10586,7 +10593,7 @@ #: 04060109.xhp#par_id1161534.help.text msgid "Other spreadsheet applications may accept localized values for the <item type=\"literal\">Type</item> parameter, but %PRODUCTNAME Calc will only accept the English values." -msgstr "" +msgstr "Jiný tabulkový procesor může pÅipouÅ¡tÄt lokalizované hodnoty pro parametr <item type=\"literal\">Typ</item>, ale %PRODUCTNAME Calc pÅipouÅ¡tà pouze anglické hodnoty." #: 04060109.xhp#hd_id5459456.help.text msgctxt "04060109.xhp#hd_id5459456.help.text" @@ -10595,11 +10602,11 @@ #: 04060109.xhp#par_id3994567.help.text msgid "<item type=\"input\">=INFO(\"release\")</item> returns the product release number of the %PRODUCTNAME in use." -msgstr "" +msgstr "<item type=\"input\">=INFO(\"vydánÃ\")</item> vracà ÄÃslo vydánà produktu použÃvané aplikace %PRODUCTNAME." #: 04060109.xhp#par_id2873622.help.text msgid "<item type=\"input\">=INFO(D5)</item> with cell D5 containing a text string <item type=\"input\">system</item> returns the operation system type." -msgstr "" +msgstr "<item type=\"input\">=INFO(D5)</item>, kde buÅka D5 obsahuje textový ÅetÄzec <item type=\"input\">system</item>, vracà typ systémové operace." #: 04060109.xhp#bm_id3154818.help.text msgid "<bookmark_value>COLUMN function</bookmark_value>" @@ -10624,7 +10631,7 @@ #: 04060109.xhp#par_id3149447.73.help.text msgid "COLUMN(Reference)" -msgstr "" +msgstr "COLUMN(odkaz)" #: 04060109.xhp#par_id3156310.74.help.text msgid "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found." @@ -10641,27 +10648,27 @@ #: 04060109.xhp#par_id3147571.76.help.text msgid "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table." -msgstr "" +msgstr "<item type=\"input\">=COLUMN(A1)</item> se rovná 1. Sloupec A je prvnà sloupec v tabulce." #: 04060109.xhp#par_id3147079.77.help.text msgid "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table." -msgstr "" +msgstr "<item type=\"input\">=COLUMN(C3:E3)</item> se rovná 3. Sloupec C je tÅetà sloupec v tabulce." #: 04060109.xhp#par_id3146861.195.help.text msgid "<item type=\"input\">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.)" -msgstr "" +msgstr "<item type=\"input\">=COLUMN(D3:G10)</item> vrátà 4, protože sloupec D je Ätvrtý sloupec v tabulce a funkce COLUMN nenà implementována jako maticový vzorec. (V tomto pÅÃpadÄ je prvnà hodnota matice vždy použita jako výsledek.)" #: 04060109.xhp#par_id3156320.196.help.text msgid "<item type=\"input\">{=COLUMN(B2:B7)}</item> and <item type=\"input\">=COLUMN(B2:B7)</item> both return 2 because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula." -msgstr "" +msgstr "Oba vzorce<item type=\"input\">{=COLUMN(B2:B7)}</item> a <item type=\"input\">=COLUMN(B2:B7)</item> vracà 2, protože odkaz obsahuje pouze sloupec B, což je druhý sloupec v tabulce. Protože jednosloupcové oblasti majà jen jedno ÄÃslo sloupce, nenà rozdÃl v tom, zda je vzorec použit jako maticový vzorec Äi nikoliv." #: 04060109.xhp#par_id3150872.197.help.text msgid "<item type=\"input\">=COLUMN()</item> returns 3 if the formula was entered in column C." -msgstr "" +msgstr "<item type=\"input\">=COLUMN()</item> vracà 3, pokud byl vzorec vložen do sloupce C." #: 04060109.xhp#par_id3153277.198.help.text msgid "<item type=\"input\">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if \"Rabbit\" is the named area (C1:D3)." -msgstr "" +msgstr "<item type=\"input\">{=COLUMN(KrálÃÄek)}</item> vracà jednoÅádkovou matici (3,4), pokud \"KrálÃÄek\" je jméno oblasti (C1:D3)." #: 04060109.xhp#bm_id3154643.help.text msgid "<bookmark_value>COLUMNS function</bookmark_value>" @@ -10682,11 +10689,11 @@ #: 04060109.xhp#par_id3154047.82.help.text msgid "COLUMNS(Array)" -msgstr "" +msgstr "COLUMNS(oblast)" #: 04060109.xhp#par_id3154745.83.help.text msgid "<emph>Array</emph> is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell." -msgstr "" +msgstr "<emph>Oblast</emph> je odkaz na oblast bunÄk, jejÞ celkový poÄet sloupců je nalezen. Argument může být také jednoduchá buÅka." #: 04060109.xhp#hd_id3153622.84.help.text msgctxt "04060109.xhp#hd_id3153622.84.help.text" @@ -10695,15 +10702,15 @@ #: 04060109.xhp#par_id3149577.200.help.text msgid "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column." -msgstr "" +msgstr "<item type=\"input\">=COLUMNS(B5)</item> vrátà 1, protože buÅka může obsahovat pouze jeden sloupec." #: 04060109.xhp#par_id3145649.85.help.text msgid "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns." -msgstr "" +msgstr "<item type=\"input\">=COLUMNS(A1:C5)</item> se rovná 3. Odkaz zahrnuje 3 sloupce." #: 04060109.xhp#par_id3155846.201.help.text msgid "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3)." -msgstr "" +msgstr "<item type=\"input\">=COLUMNS(KrálÃÄek)</item> vrátà 2, pokud <item type=\"literal\">KrálÃÄek</item> je jméno oblasti (C1:D3)." #: 04060109.xhp#bm_id3153152.help.text msgid "<bookmark_value>vertical search function</bookmark_value><bookmark_value>VLOOKUP function</bookmark_value>" @@ -10718,7 +10725,7 @@ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">SortOrder</item> parameter is omitted or set to TRUE or one, it " "is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">SortOrder</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with " "a value of zero the data does not need to be sorted in ascending order." -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_SVERWEIS\"> Svislé hledánà s odkazem na vedlejÅ¡Ã buÅky doprava.</ahelp> Tato funkce kontroluje,zda jsou specifikované hodnoty obsaženy v prvnÃm sloupci matice. Funkce poté vracà hodnotu v té samé Åádce sloupce pojmenovaného <item type=\"literal\">Indexem</item>. Je-li vynechán parametr <item type=\"literal\">PoÅadÃÅazenÃ</item> nebo je-li nastaven na TRUE nebo 1, pÅedpokládá se, že jsou data již seÅazena vzestupnÄ. V tomto pÅÃpadÄ, nenÃ-li nalezeno pÅesné <item type=\"literal\">KritériumHledánÃ</item>, bude vrácena poslednà hodnota menÅ¡Ã než kritérium. Je-li parametr <item type=\"literal\">PoÅadÃÅazenÃ</item> nastaven na FALSE nebo 0, kritérium musà být nalezeno, jinak funkce skonÄà chybou <emph>Chyba: Hodnota nenà dostupná</emph>. Äili data nemusà být seÅazena vzestupnÄ s hodnotou nula." #: 04060109.xhp#hd_id3146898.89.help.text msgctxt "04060109.xhp#hd_id3146898.89.help.text" @@ -10727,25 +10734,25 @@ #: 04060109.xhp#par_id3150156.90.help.text msgid "=VLOOKUP(SearchCriterion; Array; Index; SortOrder)" -msgstr "" +msgstr "=VLOOKUP(KritériumHledánÃ; Matice; Index; PoÅadÃÅazenÃ)" #: 04060109.xhp#par_id3149289.91.help.text msgid "<emph>SearchCriterion</emph> is the value searched for in the first column of the array." -msgstr "" +msgstr "<emph>KritériumHledánÃ</emph> je hodnota hledaná pro prvnà sloupec matice." #: 04060109.xhp#par_id3153884.92.help.text msgid "<emph>Array</emph> is the reference, which is to comprise at least two columns." -msgstr "" +msgstr "<emph>Matice</emph> je odkaz, který zahrnuje alespoÅ 2 sloupce." #: 04060109.xhp#par_id3156005.93.help.text msgid "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." -msgstr "" +msgstr "<emph>Index</emph> je poÄet sloupců v poli, které obsahuje hodnotu, která má být vrácena. Prvnà sloupec má ÄÃslo 1." #: 04060109.xhp#par_id3151208.94.help.text msgid "" "<emph>SortOrder</emph> is an optional parameter that indicates whether the first column in the array is sorted in ascending order. Enter the Boolean value FALSE or zero if the first column is not sorted in ascending order. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is between the lowest and highest " "value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return this message: <emph>Error: Value Not Available</emph>." -msgstr "" +msgstr "<emph>PoÅadÃÅazenÃ</emph> je volitelný parametr, který ukazuje, zda je prvnà sloupec v matici seÅazen vzestupnÄ. Vložte logickou hodnotu FALSE nebo 0, pokud sloupec nenà vzestupnÄ seÅazen. SeÅazený sloupec může být prohledán mnohem rychleji a funkce vždy vrátà hodnotu, i když hledaná hodnota pÅesnÄ neodpovÃdá, pokud je mezi nejmenÅ¡Ã a nejvÄtÅ¡Ã hodnotou seÅazeného seznamu. V neseÅazeném seznamu, hledaná hodnota musà být odpovÃdat pÅesnÄ, jinak funkce vrátà tuto zprávu: <emph>Chyba: Hodnota nenà dostupná</emph>." #: 04060109.xhp#hd_id3147487.95.help.text msgctxt "04060109.xhp#hd_id3147487.95.help.text" @@ -10764,7 +10771,7 @@ #: 04060109.xhp#par_id3151172.98.help.text msgid "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" -msgstr "" +msgstr "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" #: 04060109.xhp#par_id3149200.99.help.text msgid "As soon as you enter a number in A1 B1 will show the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number displays the text with the next number down. To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered." @@ -10803,7 +10810,7 @@ #: 04060109.xhp#par_id3146988.221.help.text msgid "<item type=\"input\">=SHEET(Sheet2.A1)</item> returns 2 if Sheet2 is the second sheet in the spreadsheet document." -msgstr "" +msgstr "<item type=\"input\">=SHEET(SeÅ¡it2.A1)</item> vrátà 2, pokud SeÅ¡it2 je druhý seÅ¡it v tabulkovém procesoru." #: 04060109.xhp#bm_id3148829.help.text msgid "<bookmark_value>number of sheets; function</bookmark_value><bookmark_value>SHEETS function</bookmark_value>" @@ -10837,7 +10844,7 @@ #: 04060109.xhp#par_id3150507.228.help.text msgid "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated." -msgstr "" +msgstr "<item type=\"input\">=SHEETS(SeÅ¡it1.A1:SeÅ¡it3.G12)</item> vrátà 3, pokud SeÅ¡it1, SeÅ¡it2 a SeÅ¡it3 existuje v posloupnosti." #: 04060109.xhp#bm_id3158407.help.text msgid "<bookmark_value>MATCH function</bookmark_value>" @@ -10858,15 +10865,15 @@ #: 04060109.xhp#par_id3159152.104.help.text msgid "MATCH(SearchCriterion; LookupArray; Type)" -msgstr "" +msgstr "MATCH(KritériumHledánÃ, VyhledávacÃOblast, Typ)" #: 04060109.xhp#par_id3149336.105.help.text msgid "<emph>SearchCriterion</emph> is the value which is to be searched for in the single-row or single-column array." -msgstr "" +msgstr "<emph>KritériumHledánÃ</emph> je hodnota, která se hledá v jednoÅádkovém nebo jednosloupcovém poli." #: 04060109.xhp#par_id3159167.106.help.text msgid "<emph>LookupArray</emph> is the reference searched. A lookup array can be a single row or column, or part of a single row or column." -msgstr "" +msgstr "<emph>VyhledávacÃOblast</emph> je adresa hledánÃ. Vyhledávacà oblast může být jednoÅádková, jednosloupcová nebo jen jejich Äást." #: 04060109.xhp#par_id3147239.107.help.text msgid "<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel." @@ -10874,11 +10881,11 @@ #: 04060109.xhp#par_id3154265.231.help.text msgid "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions." -msgstr "" +msgstr "Je-li Typ=0, jsou nalezeny jen pÅesnÄ odpovÃdajÃcà si hodnoty. Je-li nalezeno kritérium hledánà vÃce než jednou, funkce vrátà index prvnà odpovÃdajÃcà hodnoty. Pouze pokud se Typ=0 můžete použÃt i regulárnà výrazy." #: 04060109.xhp#par_id3147528.232.help.text msgid "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. This applies even when the search array is not sorted. For Type = -1, the first value that is larger or equal is returned." -msgstr "" +msgstr "Pokud se Typ=0 nebo tÅetà parametr chybÃ, je vrácen index poslednà hodnoty, která je menÅ¡Ã nebo rovna hledanému kretériu. Toto je použito pouze pokud prohledávané pole nenà seÅazeno. Pro Typ=-1 je vrácena prvnà hodnota, která vÄtÅ¡Ã nebo rovna." #: 04060109.xhp#hd_id3155119.108.help.text msgctxt "04060109.xhp#hd_id3155119.108.help.text" @@ -10887,7 +10894,7 @@ #: 04060109.xhp#par_id3155343.109.help.text msgid "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." -msgstr "" +msgstr "<item type=\"input\">=MATCH(200;D1:D100)</item> prohledá oblast D1:D100, která je seÅazena podle sloupce D pro hodnotu 200. Jakmile je této hodnoty dosaženo, je vráceno ÄÃslo Åádku, ve které byla tato hodnota nalezena. Pokud je bÄhem hledánà nalezena vyÅ¡Å¡Ã hodnota ve sloupci, je vráceno ÄÃslo pÅedchozà Åádky." #: 04060109.xhp#bm_id3158430.help.text msgid "<bookmark_value>OFFSET function</bookmark_value>" @@ -10908,7 +10915,7 @@ #: 04060109.xhp#par_id3159194.114.help.text msgid "OFFSET(Reference; Rows; Columns; Height; Width)" -msgstr "" +msgstr "OFFSET(Odkaz, Åádky, Sloupce, Výška, Å ÃÅka)" #: 04060109.xhp#par_id3152360.115.help.text msgid "<emph>Reference</emph> is the reference from which the function searches for the new reference." --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
