User: xrambous Date: 2008-12-09 22:47:15+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.331&r2=1.332 Delta lines: +66 -72 --------------------- --- 01.po 2008-11-30 15:18:23+0000 1.331 +++ 01.po 2008-12-09 22:47:12+0000 1.332 @@ -1,13 +1,13 @@ # translation of 01.po to Czech +#. extracted from helpcontent2/source/text/scalc/01.oo # Kristyna Kitzbergerova <[EMAIL PROTECTED]>, 2008. # Adam Rambousek <[EMAIL PROTECTED]>, 2008. -#. extracted from helpcontent2/source/text/scalc/01.oo msgid "" msgstr "" "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-11-30 16:01+0200\n" -"PO-Revision-Date: 2008-08-14 21:14+0200\n" +"PO-Revision-Date: 2008-12-09 23:47+0100\n" "Last-Translator: Adam Rambousek <[EMAIL PROTECTED]>\n" "Language-Team: Czech <[EMAIL PROTECTED]>\n" "MIME-Version: 1.0\n" @@ -35,7 +35,7 @@ #: 01120000.xhp#par_id9838862.help.text msgid "You can also press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up and Ctrl+Page Down keys to scroll through the pages." -msgstr "" +msgstr "Posouvat se po stránkách lze též stiskem kláves <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up a <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Down." #: 01120000.xhp#par_id7211828.help.text msgid "You cannot edit your document while you are in the page preview." @@ -605,8 +605,7 @@ #: 02140500.xhp#par_id3150767.3.help.text msgid "In contrast to copying an area to the clipboard, you can filter certain information and calculate values. This command is only visible if you have selected two sheets in the document. To select multiple sheets, click each sheet tab while pressing <switchinline select=\"sys\"> <caseinline select=\"MAC\">Command</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> or Shift." -msgstr "" -"Na rozdÃl od kopÃrovánà oblasti do schránky je možné filtrovat urÄité informace a poÄÃtat hodnoty. Tento pÅÃkaz je dostupný, pouze pokud jsou vybrány dva listy v dokumentu. Pro výbÄr vÃce listů klepnÄte na záložku každého listu a souÄasnÄ držte stisknutý <switchinline select=\"sys\"> <caseinline select=\"MAC\">pÅÃkaz</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> nebo Shift." +msgstr "Na rozdÃl od kopÃrovánà oblasti do schránky je možné filtrovat urÄité informace a poÄÃtat hodnoty. Tento pÅÃkaz je dostupný, pouze pokud jsou vybrány dva listy v dokumentu. Pro výbÄr vÃce listů klepnÄte na záložku každého listu a souÄasnÄ držte stisknutý <switchinline select=\"sys\"> <caseinline select=\"MAC\">pÅÃkaz</caseinline> <defaultinline>Ctrl</defaultinline> </switchinline> nebo Shift." #: 02140500.xhp#hd_id3155131.4.help.text msgid "Filling a Spreadsheet" @@ -1158,7 +1157,7 @@ #: 02210000.xhp#par_id3153969.3.help.text msgid "<ahelp hid=\"HID_SELECTTABLES\" visibility=\"visible\">Lists the sheets in the current document. To select a sheet, press the up or down arrow keys to move to a sheet in the list. To add a sheet to the selection, hold down Ctrl (Mac: Command) while pressing the arrow keys and then press Spacebar. To select a range of sheets, hold down Shift and press the arrow keys. </ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_SELECTTABLES\" visibility=\"visible\">V seznamu jsou vypsány listy aktuálnÃho dokumentu. Pro výbÄr jednoho listu použijte kurzorové klávesy nahoru nebo dolů. Chcete-li vybrat vÃce listů v seznamu, podržte stisknutou klávesu Ctrl (Mac: Command), pomocà kurzorových kláves nahoru nebo dolů najeÄte na požadovaný list a stisknÄte mezernÃk. Chcete-li vybrat vÃce listů jdoucÃch po sobÄ, podržte stisknutou klávesu Shift a vyberte požadovaný rozsah pomocà kláves nahoru nebo dolů.</ahelp>" #: 03070000.xhp#tit.help.text msgid "Column & Row Headers" @@ -1415,11 +1414,11 @@ #: 04040000.xhp#hd_id3155628.1.help.text msgid "<link href=\"text/scalc/01/04040000.xhp\" name=\"Columns\">Columns</link>" -msgstr "" +msgstr "<link href=\"text/scalc/01/04040000.xhp\" name=\"Sloupce\">Sloupce</link>" #: 04040000.xhp#par_id3150791.2.help.text msgid "<ahelp hid=\".uno:InsertColumns\">Inserts a new column to the left of the active cell.</ahelp> The number of columns inserted corresponds to the number of columns selected. The existing columns are moved to the right." -msgstr "" +msgstr "<ahelp hid=\".uno:InsertColumns\">Vložà nový sloupec nalevo od aktivnà buÅky.</ahelp>PoÄet vložených sloupců odpovÃdá poÄtu vybraných sloupců. ExistujÃcà sloupce se posunou doprava." #: 04050000.xhp#tit.help.text msgctxt "04050000.xhp#tit.help.text" @@ -1496,7 +1495,7 @@ #: 04050000.xhp#par_id3150718.8.help.text msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_INSERT_TABLE:ED_TABNAME\">Specifies the name of the new sheet.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_INSERT_TABLE:ED_TABNAME\">UrÄuje název nového listu.</ahelp>" #: 04050000.xhp#hd_id3155066.9.help.text msgid "From File" @@ -1615,7 +1614,7 @@ #: 04060000.xhp#par_id3155959.61.help.text msgid "The <emph>Array</emph> option is identical to the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter command, which is used to enter and confirm formulas in the sheet. The formula is inserted as a matrix formula indicated by two braces { }." -msgstr "" +msgstr "Volba <emph>Pole</emph> je shodná s pÅÃkazem <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter, který se použÃvá pro vloženà a potvrzenà vzorců v listu: Vzorec se vložà jako maticový vzorec, což je naznaÄeno složenými závorkami { }." #: 04060000.xhp#par_id3152993.40.help.text msgid "The maximum size of an array range is 128 by 128 cells." @@ -1815,7 +1814,7 @@ #: 04060100.xhp#par_id0902200809540918.help.text msgid "<variable id=\"drking\"><link href=\"http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category\";>Calc functions in the OpenOffice.org Wiki</link></variable>" -msgstr "" +msgstr "<variable id=\"drking\"><link href=\"http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category\";>Funkce Calcu v OpenOffice.org Wiki</link></variable>" #: 04060101.xhp#tit.help.text msgctxt "04060101.xhp#tit.help.text" @@ -1983,7 +1982,7 @@ #: 04060101.xhp#par_id3155752.31.help.text msgid "<item type=\"input\">300</item>" -msgstr "" +msgstr "<item type=\"input\">300</item>" #: 04060101.xhp#par_id3149052.32.help.text msgid "<item type=\"input\">51</item>" @@ -2052,7 +2051,7 @@ #: 04060101.xhp#par_id3145826.46.help.text msgid "<item type=\"input\">F</item><item type=\"input\">rank</item>" -msgstr "" +msgstr "<item type=\"input\">F</item><item type=\"input\">rantiÅ¡ek</item>" #: 04060101.xhp#par_id3150743.47.help.text msgctxt "04060101.xhp#par_id3150743.47.help.text" @@ -2066,11 +2065,11 @@ #: 04060101.xhp#par_id3148435.49.help.text msgid "<item type=\"input\">3</item><item type=\"input\">00</item>" -msgstr "" +msgstr "<item type=\"input\">3</item><item type=\"input\">00</item>" #: 04060101.xhp#par_id3148882.50.help.text msgid "<item type=\"input\">4</item><item type=\"input\">2</item>" -msgstr "" +msgstr "<item type=\"input\">4</item><item type=\"input\">2</item>" #: 04060101.xhp#par_id3150140.51.help.text msgctxt "04060101.xhp#par_id3150140.51.help.text" @@ -3423,7 +3422,7 @@ #: 04060103.xhp#par_id3146907.51.help.text msgid "<item type=\"input\">10,666.67 </item><item type=\"input\">currency units</item>" -msgstr "" +msgstr "<item type=\"input\">10,666.67 </item><item type=\"input\">jednotek mÄny</item>" #: 04060103.xhp#par_id3147356.52.help.text msgctxt "04060103.xhp#par_id3147356.52.help.text" @@ -4144,7 +4143,7 @@ #: 04060104.xhp#hd_id7693411.help.text msgctxt "04060104.xhp#hd_id7693411.help.text" msgid "Syntax" -msgstr "" +msgstr "Syntaxe" #: 04060104.xhp#par_id3928952.help.text msgid "INFO(\"Type\")" @@ -4152,7 +4151,7 @@ #: 04060104.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 návratové hodnoty funkce INFO." #: 04060104.xhp#par_id5735953.help.text msgid "Value for \"Type\"" @@ -4184,7 +4183,7 @@ #: 04060104.xhp#par_id2136295.help.text msgid "The product release identifier, for example \"300m25(Build:9876)\"" -msgstr "" +msgstr "Identifikace vydánà produktu, napÅ. \"300m25(Build:9876)\"" #: 04060104.xhp#par_id9200109.help.text msgid "\"numfile\"" @@ -4209,7 +4208,7 @@ #: 04060104.xhp#hd_id5459456.help.text msgctxt "04060104.xhp#hd_id5459456.help.text" msgid "Example" -msgstr "" +msgstr "PÅÃklad" #: 04060104.xhp#par_id3994567.help.text msgid "<item type=\"input\">=INFO(\"release\")</item> returns the product release number of the %PRODUCTNAME in use." @@ -4217,7 +4216,7 @@ #: 04060104.xhp#par_id2873622.help.text msgid "<item type=\"input\">=INFO(D5)</item> with cell <item type=\"literal\">D5</item> containing a text string <item type=\"literal\">system</item> returns the operation system type." -msgstr "" +msgstr "<item type=\"input\">=INFO(D5)</item>, kde buÅka <item type=\"literal\">D5</item> obsahuje textový ÅetÄzec <item type=\"input\">system</item>, vracà typ systémové operace." #: 04060104.xhp#bm_id3155625.help.text msgid "<bookmark_value>CURRENT function</bookmark_value>" @@ -7528,7 +7527,7 @@ #: 04060106.xhp#par_id3151828.623.help.text msgid "In order to enter this as an array formula, you must press the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+ Ctrl</defaultinline></switchinline>+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the <emph>Formula</emph> bar enclosed in braces." -msgstr "" +msgstr "Aby se vzorec vložil jako sloupcový, musÃte stisknout Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command </caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+ Enter mÃsto pouhého Enter pro potvrzenà vzorce. Vzorec bude poté zobrazen v Åádku <emph>Vzorec</emph> obklopený složenými závorkami." #: 04060106.xhp#par_id3151869.624.help.text msgid "{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}" @@ -8163,7 +8162,7 @@ #: 04060106.xhp#par_id2855616.help.text msgctxt "04060106.xhp#par_id2855616.help.text" msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9." -msgstr "" +msgstr "Tato funkce generuje nové náhodné ÄÃslo pÅi každém pÅepoÄtu. RuÄnÃho pÅepoÄtu docÃlÃte stiskem kláves Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9." #: 04060106.xhp#par_id2091433.help.text msgid "To generate random numbers which never recalculate, copy cells containing this function, 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)." @@ -8202,7 +8201,7 @@ #: 04060106.xhp#par_id5092318.help.text msgctxt "04060106.xhp#par_id5092318.help.text" msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9." -msgstr "" +msgstr "Tato funkce generuje nové náhodné ÄÃslo pÅi každém pÅepoÄtu. RuÄnÃho pÅepoÄtu docÃlÃte stiskem kláves Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9." #: 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)." @@ -8404,13 +8403,11 @@ msgid "" "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 "" +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." -msgstr "" -"KromÄ násobenà je také možné použÃt na daný rozsah bunÄk (matici) i jiné operátory. V programu $[officename] Calc můžete sÄÃtat (+), odÄÃtat (-), násobit (*), dÄlit (/), použÃvat exponenty (^), spojovat ÅetÄzce (&) a porovnávat (=, <>, <, >, <=, >=). Tyto operátory mohou být použity na každou jedineÄnou hodnotu v daném rozsahu bunÄk a pÅi použità v maticovém vzorci vracejà jako výsledek matici." +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." +msgstr "KromÄ násobenà je také možné použÃt na daný rozsah bunÄk (matici) i jiné operátory. V programu $[officename] Calc můžete sÄÃtat (+), odÄÃtat (-), násobit (*), dÄlit (/), použÃvat exponenty (^), spojovat ÅetÄzce (&) a porovnávat (=, <>, <, >, <=, >=). Tyto operátory mohou být použity na každou jedineÄnou hodnotu v daném rozsahu bunÄk a pÅi použità v maticovém vzorci vracejà jako výsledek matici." #: 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." @@ -8454,7 +8451,7 @@ #: 04060107.xhp#par_id3153392.4.help.text msgid "If you enter the array formula directly into the cell, you must use the key combination Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter instead of the Enter key. Only then does the formula become an array formula." -msgstr "" +msgstr "Pokud zadáte maticový vzorec pÅÃmo do buÅky, musÃte použÃt mÃsto klávesy Enter použÃt kombinaci Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. Pouze tak bude vzorec uložen jako maticový." #: 04060107.xhp#par_id3151120.315.help.text msgid "Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces." @@ -8496,7 +8493,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 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+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 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter." #: 04060107.xhp#par_id8868068.help.text msgid "={1;2;3|4;5;6}" @@ -8528,7 +8525,7 @@ #: 04060107.xhp#par_id3149241.317.help.text msgid "Select the cell range or array containing the array formula. To select the whole array, position the cell cursor inside the array range, then press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>+ /, where / is the Division key on the numeric keypad." -msgstr "" +msgstr "Vyberte rozsah bunÄk (matici) obsahujÃcà maticový vzorec. K výbÄru celé matice umÃstÄte kurzor dovnitÅ rozsahu a stisknÄte <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>+/ (Klávesou / se rozumà klávesa se znakem dÄlÃtka na numerické klávesnici)." #: 04060107.xhp#par_id3143274.318.help.text msgid "Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula." @@ -8536,7 +8533,7 @@ #: 04060107.xhp#par_id3154798.319.help.text msgid "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter." -msgstr "" +msgstr "Po dokonÄenà úprav stisknÄte <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter." #: 04060107.xhp#par_id3150628.334.help.text msgid "You can format the separate parts of an array. For example, you can change the font color. Select a cell range and then change the attribute you want." @@ -8557,16 +8554,15 @@ #: 04060107.xhp#par_id3150994.323.help.text msgid "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C." -msgstr "" +msgstr "StisknutÃm <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+C zkopÃrujte vzorec do vstupnà Åádky." #: 04060107.xhp#par_id3146787.324.help.text msgid "Select a range of cells where you want to insert the array formula and either press F2 or position the cursor in the input line." msgstr "Vyberte rozsah bunÄk, do kterého chcete vložit maticový vzorec, a stisknÄte F2 nebo umÃstÄte kurzor do vstupnà Åádky." #: 04060107.xhp#par_id3154419.325.help.text -msgid "" -"Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The selected range now contains the array formula." -msgstr "" +msgid "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. The selected range now contains the array formula." +msgstr "Vložte vzorec stisknutÃm <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+V na zvolené mÃsto a potvrÄte jej stisknutÃm kombinace kláves <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. Vybraný rozsah bunÄk nynà obsahuje maticový vzorec." #: 04060107.xhp#hd_id3154834.328.help.text msgid "Adjusting an Array Range" @@ -8591,7 +8587,7 @@ #: 04060107.xhp#par_id3146080.333.help.text msgid "By holding down the <switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key, you can create a copy of the array formula in the given range." -msgstr "" +msgstr "PÅidrženÃm klávesy <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> je možné v daném rozsahu vytvoÅit kopii maticového vzorce." #: 04060107.xhp#par_idN10D47.help.text msgid "Conditional Array Calculations" @@ -8680,8 +8676,7 @@ msgstr "ano" #: 04060107.xhp#par_idN10DD0.help.text -msgid "" -"The following functions provide forced array handling: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. If you use area references as arguments when you call one of these functions, the functions behave as array functions. The following table provides an example of forced array handling:" +msgid "The following functions provide forced array handling: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. If you use area references as arguments when you call one of these functions, the functions behave as array functions. The following table provides an example of forced array handling:" msgstr "NásledujÃcà funkce poskytujà vynucené zpracovánà matic: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. Je-li jako argument funkce použit rozsah bunÄk (matice), funkce se chová jako maticová. NásledujÃcà tabulka poskytuje pÅÃklady vynuceného zpracovánà matic:" #: 04060107.xhp#par_idN10DE2.help.text @@ -8836,7 +8831,7 @@ #: 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." @@ -9242,7 +9237,7 @@ msgid "" "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></" "switchinline>. Or, if you are using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. The transposed array appears in the selected target range and is protected automatically against changes." -msgstr "" +msgstr "Vyberte v listu rozsah bunÄk, ve kterém se objevà transponovaná matice. Pokud má původnà matice n Åádek a m sloupců, musà mÃt vámi zvolený rozsah bunÄk alespoÅ n sloupců a m Åádek. Potom zadejte vzorec pÅÃmo z ruky, zvolte zdrojovou matici a stisknÄte <switchinline select=\"sys\"><caseinline select=\"MAC\">Shift+Command+Enter</caseinline><defaultinline>Shift+Ctrl+Enter</defaultinline></switchinline>. Pokud použÃváte <emph>Průvodce maticÃ</emph>, nezapomeÅte zaÅ¡krtnout polÃÄko <emph>Matice</emph>. Transponovaná matice se objevà v cÃlovém rozsahu bunÄk a je automaticky chránÄna pÅed zmÄnami." #: 04060107.xhp#bm_id3109846.help.text msgid "<bookmark_value>LINEST function</bookmark_value>" @@ -9254,7 +9249,7 @@ #: 04060107.xhp#par_id3144733.65.help.text msgid "<ahelp hid=\"HID_FUNC_RGP\">Returns a table of statistics for a straight line that best fits a data set.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_FUNC_RGP\">Vrátà statistickou tabulku pro pÅÃmku, která nejlépe odpovÃdá datové ÅadÄ.</ahelp>" #: 04060107.xhp#hd_id3152825.66.help.text msgctxt "04060107.xhp#hd_id3152825.66.help.text" @@ -9263,31 +9258,31 @@ #: 04060107.xhp#par_id3152839.67.help.text msgid "LINEST(data_Y; data_X; linearType; stats)" -msgstr "" +msgstr "LINEST(data_Y; data_X; TypLinie; statistika)" #: 04060107.xhp#par_id3152853.68.help.text msgid "<emph>data_Y</emph> is a single row or column range specifying the y coordinates in a set of data points." -msgstr "" +msgstr "<emph>data_Y</emph> je jeden Åádek nebo sloupec, který urÄuje souÅadnice Y v sadÄ datových bodů." #: 04060107.xhp#par_id3154428.69.help.text msgid "<emph>data_X</emph> is a corresponding single row or column range specifying the x coordinates. If <emph>data_X</emph> is omitted it defaults to <item type=\"literal\">1, 2, 3, ..., n</item>. If there is more than one set of variables <emph>data_X</emph> may be a range with corresponding multiple rows or columns." -msgstr "" +msgstr "<emph>data_X</emph> je jeden Åádek nebo sloupec, který urÄuje souÅadnice X v sadÄ datových bodů. Pokud je <emph>data_X</emph> vynecháno, výchozà hodnota je <item type=\"literal\">1, 2, 3, ..., n</item>. Pokud je vÃce sad promÄnných, <emph>data_X</emph> může být rozsah nÄkolika Åádků Äi sloupců." #: 04060107.xhp#par_id0811200804502119.help.text msgid "LINEST finds a straight line <item type=\"literal\">y = a + bx</item> that best fits the data, using linear regression (the \"least squares\" method). With more than one set of variables the straight line is of the form <item type=\"literal\">y = a + b1x1 + b2x2 ... + bnxn</item>." -msgstr "" +msgstr "LINEST najde pÅÃmku <item type=\"literal\">y = a + bx</item>, která nejlépe odpovÃdá datům. Použije se pÅi tom lineárnà regrese (metoda \"nejmenÅ¡Ãch Ätverců\"). Pokud je vÃce sad promÄnných, má pÅÃmka rovnici <item type=\"literal\">y = a + b1x1 + b2x2 ... + bnxn</item>." #: 04060107.xhp#par_id3154448.70.help.text msgid " if<emph>linearType</emph> is FALSE the straight line found is forced to pass through the origin (the constant a is zero; y = bx). If omitted, <emph>linearType</emph> defaults to TRUE (the line is not forced through the origin)." -msgstr "" +msgstr "Pokud má <emph>typLinie</emph> hodnotu FALSE, pÅÃmka musà procházet poÄáteÄnÃm bodem (konstanta a je nula; y = bx). Pokud je parametr vynechán, má <emph>typLinie</emph> hodnotu TRUE (pÅÃmka nemusà procházet poÄátkem)." #: 04060107.xhp#par_id3154142.71.help.text msgid "if<emph>stats</emph> is omitted or FALSE only the top line of the statistics table is returned. If TRUE the entire table is returned." -msgstr "" +msgstr "Pokud je parametr <emph>statistika</emph> vynechán nebo FALSE, bude vrácen jen hornà Åádek statistické tabulky. Pokud má hodnotu TRUE, bude vrácena celá tabulka." #: 04060107.xhp#par_id0811200804502261.help.text msgid "LINEST returns a table (array) of statistics as below and must be entered as an array formula (for example by using <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Return rather than just Return)." -msgstr "" +msgstr "LINEST vracà tabulku (matici) statistik a musà být zadána jako maticový vzorec (napÅ. klávesovou zkratkou <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter namÃsto Enter)." #: 04060107.xhp#par_idN11416.help.text msgctxt "04060107.xhp#par_idN11416.help.text" @@ -9306,11 +9301,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 <emph>data_Y</emph>. 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 <emph>data_Y</emph>. Pokud chcete, můžete vybrat i dalÅ¡Ã parametry. Vyberte <emph>Pole</emph> a klepnÄte na <emph>OK</emph>." #: 04060107.xhp#par_id3155468.74.help.text msgid "The results returned by the system (if <emph>stats</emph> = 0), will at least show the slope of the regression line and its intersection with the Y axis. If <emph>stats</emph> does not equal 0, other results are to be displayed." -msgstr "" +msgstr "Výsledek vrácený systémem (pokud <emph>statistika</emph> = 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:" @@ -9372,7 +9367,7 @@ #: 04060107.xhp#par_id3163766.88.help.text msgid "<item type=\"input\">LIN</item><item type=\"input\">EST value</item>" -msgstr "" +msgstr "<item type=\"input\">Hodnota funkce LINEST</item>" #: 04060107.xhp#par_id3145686.89.help.text msgctxt "04060107.xhp#par_id3145686.89.help.text" @@ -9579,15 +9574,15 @@ #: 04060107.xhp#par_id3158020.133.help.text msgid "<emph>data_Y</emph> is C2:C8" -msgstr "" +msgstr "<emph>data_Y</emph> je C2:C8" #: 04060107.xhp#par_id3158039.134.help.text msgid "<emph>data_X</emph> is A2:B8" -msgstr "" +msgstr "<emph>data_X</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> i <emph>statistika</emph> nastaveno 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." @@ -10271,19 +10266,19 @@ #: 04060109.xhp#par_id1027200802301348.help.text msgid "For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used." -msgstr "" +msgstr "Z důvodů interoperability podporujà funkce ADDRESS a INDIRECT volitelný parametr, který urÄuje, zda se má použÃt notace R1C1 namÃsto obvyklé A1." #: 04060109.xhp#par_id1027200802301445.help.text msgid "In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position." -msgstr "" +msgstr "U funkce ADDRESS se parametr zapÃÅ¡e jako Ätvrtý parametr a volitelný název listu se posune na páté mÃsto." #: 04060109.xhp#par_id102720080230153.help.text msgid "In INDIRECT, the parameter is appended as the second parameter." -msgstr "" +msgstr "U funkce INDIRECT se parametr zapÃÅ¡e jako druhý parametr." #: 04060109.xhp#par_id102720080230151.help.text msgid "In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. " -msgstr "" +msgstr "U obou funkcà platÃ, že pokud má parametr hodnotu 0, použije se notace R1C1. Pokud nenà parametr uveden nebo má hodnotu jinou než 0, použije se notace A1." #: 04060109.xhp#par_id1027200802301556.help.text msgid "In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation." @@ -10312,7 +10307,7 @@ #: 04060109.xhp#par_id3154707.6.help.text msgid "ADDRESS(Row; Column; Abs; A1; \"Sheet\")" -msgstr "" +msgstr "ADDRESS(Åádek; Sloupec; Abs; A1; \"List\")" #: 04060109.xhp#par_id3147505.7.help.text msgid "<emph>Row</emph> represents the row number for the cell reference" @@ -10345,11 +10340,11 @@ #: 04060109.xhp#par_id1027200802465915.help.text msgctxt "04060109.xhp#par_id1027200802465915.help.text" msgid "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used." -msgstr "" +msgstr "<emph>A1</emph> (volitelné) - pokud je nastaveno na 0, použije se notace R1C1. Pokud parametr nenà uveden nebo je jiný než 0, použije se notace A1." #: 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 "<emph>SeÅ¡it</emph> reprezentuje jméno seÅ¡itu. Musà být umÃstÄno v uvozovkách." +msgstr "<emph>List</emph> reprezentuje jméno listu. Musà být umÃstÄno v uvozovkách." #: 04060109.xhp#hd_id3147299.15.help.text msgid "Example:" @@ -10357,11 +10352,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 "<item type=\"input\">=ADDRESS(1;1;2;\"SeÅ¡it2\")</item> vracà následujÃcÃ: SeÅ¡it2.A$1" +msgstr "<item type=\"input\">=ADDRESS(1;1;2;\"List2\")</item> vracà následujÃcÃ: List2.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 "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." +msgstr "Obsahuje-li buÅka A1 v listu2 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>" @@ -10625,7 +10620,7 @@ #: 04060109.xhp#par_id3149824.65.help.text msgid "INDIRECT(Ref; A1)" -msgstr "" +msgstr "INDIRECT(Odkaz; A1)" #: 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." @@ -10634,7 +10629,7 @@ #: 04060109.xhp#par_id1027200802470312.help.text msgctxt "04060109.xhp#par_id1027200802470312.help.text" msgid "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used." -msgstr "" +msgstr "<emph>A1</emph> (volitelné) - pokud je nastaveno na 0, použije se notace R1C1. Pokud parametr nenà uveden nebo je jiný než 0, použije se notace A1." #: 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)." @@ -10831,8 +10826,7 @@ #: 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." -msgstr "" -"Jakmile zadáte do buÅky A1 ÄÃslo, zobrazà se v buÅce B1 odpovÃdajÃcà text obsažený v druhém sloupci v oblasti bunÄk D1:E100. Pokud zadáte ÄÃslo, které se ve sloupci D nenalézá, bude zobrazen text odpovÃdajÃcà nejbližšà následujÃcà ÄÃselné hodnotÄ. Pokud chcete, aby pÅi zadánà neexistujÃcÃho ÄÃsla byla zobrazena chybová zpráva, zadejte v poslednÃm parametru vzorce logickou hodnotu NEPRAVDA." +msgstr "Jakmile zadáte do buÅky A1 ÄÃslo, zobrazà se v buÅce B1 odpovÃdajÃcà text obsažený v druhém sloupci v oblasti bunÄk D1:E100. Pokud zadáte ÄÃslo, které se ve sloupci D nenalézá, bude zobrazen text odpovÃdajÃcà nejbližšà následujÃcà ÄÃselné hodnotÄ. Pokud chcete, aby pÅi zadánà neexistujÃcÃho ÄÃsla byla zobrazena chybová zpráva, zadejte v poslednÃm parametru vzorce logickou hodnotu NEPRAVDA." #: 04060109.xhp#bm_id3153905.help.text msgid "<bookmark_value>sheet numbers; looking up</bookmark_value><bookmark_value>SHEET function</bookmark_value>" @@ -18801,8 +18795,7 @@ msgid "" "<ahelp hid=\"HID_FUNC_CHIVERT\">Returns the probability value from the indicated Chi square that a hypothesis is confirmed.</ahelp> CHIDIST compares the Chi square value to be given for a random sample that is calculated from the sum of (observed value-expected value)^2/expected value for all values with the theoretical Chi square distribution and determines from this the probability of error " "for the hypothesis to be tested." -msgstr "" -"<ahelp hid=\"HID_FUNC_CHIVERT\">Vracà hodnotu pravdÄpodobnosti urÄenou funkcà chÃ-kvadrát a urÄÃ, zda se hypotéza potvrdila.</ahelp> CHIDIST porovnává hodnotu chÃ-kvadrát pro náhodný vzorek, který se vypoÄte jako souÄet (pozorovaná hodnota - oÄekávaná hodnota)^2/oÄekávaná hodnota pro vÅ¡echny hodnoty teoretického rozdÄlenà chÃ-kvadrát. Z tohoto se urÄà pravdÄpodobnost chyby ovÄÅované hypotézy." +msgstr "<ahelp hid=\"HID_FUNC_CHIVERT\">Vracà hodnotu pravdÄpodobnosti urÄenou funkcà chÃ-kvadrát a urÄÃ, zda se hypotéza potvrdila.</ahelp> CHIDIST porovnává hodnotu chÃ-kvadrát pro náhodný vzorek, který se vypoÄte jako souÄet (pozorovaná hodnota - oÄekávaná hodnota)^2/oÄekávaná hodnota pro vÅ¡echny hodnoty teoretického rozdÄlenà chÃ-kvadrát. Z tohoto se urÄà pravdÄpodobnost chyby ovÄÅované hypotézy." #: 04060181.xhp#par_id3151316.157.help.text msgid "The probability determined by CHIDIST can also be determined by CHITEST." @@ -22556,7 +22549,7 @@ #: 05050100.xhp#par_id3155131.help.text msgid "<ahelp hid=\"HID_SC_APPEND_NAME\">Enter a new name for the sheet here.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_SC_APPEND_NAME\">Zadejte nové jméno listu.</ahelp>" #: 05050100.xhp#par_id3153092.5.help.text msgid "You can also open the<emph> Rename Sheet </emph>dialog through the context menu by positioning the mouse pointer over a sheet tab at the bottom of the window and <switchinline select=\"sys\"><caseinline select=\"MAC\">clicking while pressing Control</caseinline><defaultinline>clicking the right mouse button</defaultinline></switchinline>." @@ -28121,3 +28114,4 @@ #~ msgid "<emph>=DATEVALUE(\"1954-07-20\") y</emph>ields 19925." #~ msgstr "<emph>=DATEVALUE(\"1954-07-20\")</emph> vracà 19925." + --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
