User: pjanik Date: 2007-09-23 08:52:36+0000 Modified: cs/po/helpcontent2/source/text/scalc/01.po
Log: Update to SRC680_m230. 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.283&r2=1.284 Delta lines: +231 -42 ---------------------- --- 01.po 2007-09-10 06:23:29+0000 1.283 +++ 01.po 2007-09-23 08:52:34+0000 1.284 @@ -4,7 +4,7 @@ msgstr "" "Project-Id-Version: 01\n" "Report-Msgid-Bugs-To: \n" -"POT-Creation-Date: 2007-09-08 08:52+0200\n" +"POT-Creation-Date: 2007-09-22 21:18+0200\n" "PO-Revision-Date: 2007-04-21 14:38+0200\n" "Last-Translator: Adam Rambousek <[EMAIL PROTECTED]>\n" "Language-Team: Czech <[EMAIL PROTECTED]>\n" @@ -3735,12 +3735,6 @@ "7" msgstr "7" -#: 04060103.xhp#par_id3146148.66.help.text -msgid "" -"_: 04060103.xhp#par_id3146148.66.help.text\n" -"-" -msgstr "-" - #: 04060103.xhp#par_id3083443.67.help.text msgid "" "_: 04060103.xhp#par_id3083443.67.help.text\n" @@ -3753,12 +3747,6 @@ "8" msgstr "8" -#: 04060103.xhp#par_id3156378.69.help.text -msgid "" -"_: 04060103.xhp#par_id3156378.69.help.text\n" -"-" -msgstr "-" - #: 04060103.xhp#par_id3145082.70.help.text msgid "" "_: 04060103.xhp#par_id3145082.70.help.text\n" @@ -3771,12 +3759,6 @@ "9" msgstr "9" -#: 04060103.xhp#par_id3155838.72.help.text -msgid "" -"_: 04060103.xhp#par_id3155838.72.help.text\n" -"-" -msgstr "-" - #: 04060103.xhp#par_id3147564.73.help.text msgid "" "_: 04060103.xhp#par_id3147564.73.help.text\n" @@ -3789,12 +3771,6 @@ "10" msgstr "10" -#: 04060103.xhp#par_id3156316.75.help.text -msgid "" -"_: 04060103.xhp#par_id3156316.75.help.text\n" -"-" -msgstr "-" - #: 04060103.xhp#par_id3150880.76.help.text msgid "" "_: 04060103.xhp#par_id3150880.76.help.text\n" @@ -9553,10 +9529,8 @@ #: 04060107.xhp#par_id3155904.219.help.text msgid "" "In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of " -"measured values that are greater than 5 or greater than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." +"measured values that are greater than 5 and less than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." msgstr "" -"Sloupec A v následujÃcà tabulce obsahuje nesetÅÃdÄné hodnoty mÄÅenÃ. Sloupec B obsahuje hornà meze intervalů, do kterých chceme rozdÄlit údaje ze sloupce A. Funkce FREQUENCY použije hodnotu v B1 k tomu, aby vrátila poÄet hodnot mÄÅenÃ, které jsou menÅ¡Ã nebo rovny 5. Na základÄ hodnoty B2 zase funkce FREQUENCY vrátà poÄet namÄÅených hodnot, které jsou vÄtÅ¡Ã než 5, nebo menÅ¡Ã nebo rovny 10. Text " -"\">25\" zadaný do B6 nemá na funkci FREQUENCY vliv a sloužà pouze pro lepÅ¡Ã názornost." #: 04060107.xhp#par_id3155869.220.help.text msgid "" @@ -9774,11 +9748,9 @@ #: 04060107.xhp#par_id3150312.29.help.text msgid "" -"Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the \\<emph\\>Data\\</emph\\> range in (A1:A11), and then the \\<emph\\>Classes\\</emph\\> range in " -"which you entered the class limits (B1:B6). Select the \\<emph\\>Array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the range C1:C6." +"Select a single column range in which to enter the frequency according to the class limits. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the \\<emph\\>Data\\</emph\\> range in (A1:A11), and then the \\<emph\\>Classes\\</emph\\> range in which you entered the " +"class limits (B1:B6). Select the \\<emph\\>Array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the range C1:C6." msgstr "" -"Vyberte jednosloupcový rozsah bunÄk, do kterých chcete vložit Äetnosti zdrojových hodnot, spoÄtené pro jednotlivé intervaly (tÅÃdy). MusÃte vybrat o jednu buÅku vÃce, než je poÄet tÅÃd, do této buÅky bude vložena Äetnost hodnot, které pÅekraÄujà hornà limit poslednà tÅÃdy. V tomto pÅÃkladÄ vyberte buÅky C1:C6. V \\<emph\\>Průvodci funkcÃ\\</emph\\> zvolte funkci FREQUENCY. Jako \\<emph\\>Data" -"\\</emph\\> dále zadejte rozsah bunÄk obsahujÃcÃch hodnoty mÄÅenà (A1:A11) a také sloupec obsahujÃcà hornà meze zkoumaných intervalů jako \\<emph\\>TÅÃdy\\</emph\\>; tedy buÅky B1:B6. ZaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\> a klepnÄte na \\<emph\\>OK\\</emph\\>. V původnÄ oznaÄeném rozsahu bunÄk C1:C6 nynà vidÃte Äetnosti hodnot mÄÅenà v pÅÃsluÅ¡ných intervalech." #: 04060107.xhp#par_idN11269.help.text msgid "" @@ -11659,11 +11631,9 @@ #: 04060109.xhp#par_id3149984.88.help.text msgid "" "\\<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 \\<emph\\>index\\</emph\\>. If the \\<emph\\>Sort order\\</emph\\> parameter is omitted or set to TRUE, it is assumed " -"that the data is sorted in ascending order. In this case, if the exact \\<emph\\>search criterion\\</emph\\> is not found, the next value will be returned. If \\<emph\\>Sort order\\</emph\\> 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." +"that the data is sorted in ascending order. In this case, if the exact \\<emph\\>search criterion\\</emph\\> is not found, the last value that is smaller than the criterion will be returned. If \\<emph\\>Sort order\\</emph\\> 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 "" -"\\<ahelp hid=\\\"HID_FUNC_SVERWEIS\\\"\\>Svislé vyhledávánà s vracejÃcà hodnotu z prava pÅilehlých bunÄk.\\</ahelp\\> Tato funkce hledá požadovanou hodnotu v prvnÃm sloupci oblasti a navracà hodnotu z takto nalezeného Åádku, která se nacházà ve sloupci urÄeném parametrem \\<emph\\>index\\</emph\\>. Pokud je parametr \\<emph\\>ÅazenÃ\\</emph\\> vynechán nebo nastaven na TRUE, pÅedpokládá se, že " -"data jsou seÅazena vzestupnÄ. V tom pÅÃpadÄ (pokud nenà nalezeno pÅesné \\<emph\\>Kritérium vyhledávánÃ\\</emph\\>), se vrátà následujÃcà hodnota. Pokud je \\<emph\\>ÅazenÃ\\</emph\\> nastaveno na FALSE nebo nulu, musà být nalezena pÅesná hodnota, jinak funkce vrátà chybu \\<emph\\>Chyba: hodnota nenà k dispozici\\</emph\\>. Data pak nemusà být seÅazena vzestupnÄ." #: 04060109.xhp#hd_id3146898.89.help.text msgid "" @@ -12248,6 +12218,96 @@ msgid "=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\" displays the text \"Click example.org\" in the cell and executes the hyperlink http://www.example.org when clicked." msgstr "=HYPERLINK(\"http://www.\";\"KlepnÄte na \") & \"example.org\" zobrazà v buÅce text \"KlepnÄte na example.org\" a po klepnutà otevÅe hypertextový odkaz http://www.example.org."; +#: 04060109.xhp#bm_id7682424.help.text +msgid "\\<bookmark_value\\>GETPIVOTDATA function\\</bookmark_value\\>" +msgstr "" + +#: 04060109.xhp#hd_id3747062.help.text +msgid "GETPIVOTDATA" +msgstr "" + +#: 04060109.xhp#par_id3593859.help.text +msgid "\\<ahelp hid=\\\".\\\"\\>The GETPIVOTDATA function returns a result value from a DataPilot table. The value is addressed using field and item names, so it remains valid if the layout of the DataPilot table changes.\\</ahelp\\>" +msgstr "" + +#: 04060109.xhp#hd_id9741508.help.text +msgid "" +"_: 04060109.xhp#hd_id9741508.help.text\n" +"Syntax" +msgstr "" + +#: 04060109.xhp#par_id909451.help.text +msgid "Two different syntax definitions can be used:" +msgstr "" + +#: 04060109.xhp#par_id1665089.help.text +msgid "GETPIVOTDATA(Target Field; DataPilot; [ Field 1; Item 1; ... ])" +msgstr "" + +#: 04060109.xhp#par_id4997100.help.text +msgid "GETPIVOTDATA(DataPilot; Constraints)" +msgstr "" + +#: 04060109.xhp#par_id1672109.help.text +msgid "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." +msgstr "" + +#: 04060109.xhp#hd_id9464094.help.text +msgid "First Syntax" +msgstr "" + +#: 04060109.xhp#par_id9302346.help.text +msgid "\\<emph\\>Target Field\\</emph\\> is a string that selects one of the DataPilot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." +msgstr "" + +#: 04060109.xhp#par_id8296151.help.text +msgid "\\<emph\\>DataPilot\\</emph\\> is a reference to a cell or cell range that is positioned within a DataPilot table or contains a DataPilot table. If the cell range contains several DataPilot tables, the table that was created last is used." +msgstr "" + +#: 04060109.xhp#par_id4809411.help.text +msgid "If no \\<emph\\>Field n / Item n\\</emph\\> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. \\<emph\\>Field n\\</emph\\> is the name of a field from the DataPilot table. \\<emph\\>Item n\\</emph\\> is the name of an item from that field." +msgstr "" + +#: 04060109.xhp#par_id6454969.help.text +msgid "If the DataPilot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the DataPilot table." +msgstr "" + +#: 04060109.xhp#par_id79042.help.text +msgid "If the source data contains entries that are hidden by settings of the DataPilot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive." +msgstr "" + +#: 04060109.xhp#par_id7928708.help.text +msgid "If no constraint for a page field is given, the field's selected value is implicitly used. If a constraint for a page field is given, it must match the field's selected value, or an error is returned." +msgstr "" + +#: 04060109.xhp#par_id3864253.help.text +msgid "Subtotal values from the DataPilot table are only used if they use the function \"auto\" (except when specified in the constraint, see \\<item type=\\\"literal\\\"\\>Second Syntax\\</item\\> below)." +msgstr "" + +#: 04060109.xhp#hd_id3144016.help.text +msgid "Second Syntax" +msgstr "" + +#: 04060109.xhp#par_id9937131.help.text +msgid "\\<emph\\>DataPilot\\</emph\\> has the same meaning as in the first syntax." +msgstr "" + +#: 04060109.xhp#par_id5616626.help.text +msgid "\\<emph\\>Constraints\\</emph\\> is a space-separated list. Entries can be quoted (single quotes). " +msgstr "" + +#: 04060109.xhp#par_id4076357.help.text +msgid "One of the entries can be the data field name. The data field name can be left out if the DataPilot table contains only one data field, otherwise it must be present. " +msgstr "" + +#: 04060109.xhp#par_id8231757.help.text +msgid "Each of the other entries specifies a constraint in the form \\<item type=\\\"literal\\\"\\>Field[Item]\\</item\\>. The item must be enclosed in square brackets, unless the item name is unique within all fields that are used in the DataPilot table. " +msgstr "" + +#: 04060109.xhp#par_id3168736.help.text +msgid "A function name can be added in the form \\<emph\\>Field[Item;Function]\\</emph\\>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, CountNums, StDev, StDevp, Var, and Varp, case-insensitive." +msgstr "" + #: 04060110.xhp#tit.help.text msgid "" "_: 04060110.xhp#tit.help.text\n" @@ -12308,6 +12368,44 @@ msgid "ARABIC(\"MMII\") returns 2002" msgstr "ARABIC(\"MMII\") vrátà 2002" +#: 04060110.xhp#bm_id8796349.help.text +msgid "\\<bookmark_value\\>ASC function\\</bookmark_value\\>" +msgstr "" + +#: 04060110.xhp#hd_id7723929.help.text +msgid "ASC" +msgstr "" + +#: 04060110.xhp#par_id8455153.help.text +msgid "\\<ahelp hid=\\\".\\\"\\>The ASC function converts full-width to half-width ASCII and katakana characters. Returns a text string.\\</ahelp\\>" +msgstr "" + +#: 04060110.xhp#par_id9912411.help.text +msgid "" +"_: 04060110.xhp#par_id9912411.help.text\n" +"See \\<link href=\\\"http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions\\\"\\>http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions\\</link\\> for a conversion table." +msgstr "" + +#: 04060110.xhp#hd_id9204992.help.text +msgid "" +"_: 04060110.xhp#hd_id9204992.help.text\n" +"Syntax" +msgstr "" + +#: 04060110.xhp#par_id1993774.help.text +msgid "ASC(text)" +msgstr "" + +#: 04060110.xhp#par_id2949919.help.text +msgid "" +"_: 04060110.xhp#par_id2949919.help.text\n" +"\\<emph\\>text\\</emph\\> is the text that contains characters to be converted." +msgstr "" + +#: 04060110.xhp#par_id2355113.help.text +msgid "See also JIS function." +msgstr "" + #: 04060110.xhp#bm_id9323709.help.text msgid "\\<bookmark_value\\>BAHTTEXT function\\</bookmark_value\\>" msgstr "\\<bookmark_value\\>funkce BAHTTEXT\\</bookmark_value\\>" @@ -12786,6 +12884,44 @@ msgid "FIXED(1234567.89;3;1) returns 1234567.890 as a text string." msgstr "FIXED(1234567.89;3;1) vrátà textový ÅetÄzec 1234567.890." +#: 04060110.xhp#bm_id7319864.help.text +msgid "\\<bookmark_value\\>JIS function\\</bookmark_value\\>" +msgstr "" + +#: 04060110.xhp#hd_id3666188.help.text +msgid "JIS" +msgstr "" + +#: 04060110.xhp#par_id964384.help.text +msgid "\\<ahelp hid=\\\".\\\"\\>The JIS function converts half-width to full-width ASCII and katakana characters. Returns a text string.\\</ahelp\\>" +msgstr "" + +#: 04060110.xhp#par_id1551561.help.text +msgid "" +"_: 04060110.xhp#par_id1551561.help.text\n" +"See \\<link href=\\\"http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions\\\"\\>http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions\\</link\\> for a conversion table." +msgstr "" + +#: 04060110.xhp#hd_id2212897.help.text +msgid "" +"_: 04060110.xhp#hd_id2212897.help.text\n" +"Syntax" +msgstr "" + +#: 04060110.xhp#par_id2504654.help.text +msgid "JIS(text)" +msgstr "" + +#: 04060110.xhp#par_id5292519.help.text +msgid "" +"_: 04060110.xhp#par_id5292519.help.text\n" +"\\<emph\\>text\\</emph\\> is the text that contains characters to be converted." +msgstr "" + +#: 04060110.xhp#par_id3984496.help.text +msgid "See also ASC function." +msgstr "" + #: 04060110.xhp#bm_id3147083.help.text msgid "\\<bookmark_value\\>LEFT function\\</bookmark_value\\>" msgstr "\\<bookmark_value\\>funkce LEFT\\</bookmark_value\\>" @@ -23119,8 +23255,10 @@ msgstr "Operátory v $[officename] Calc" #: 04060199.xhp#bm_id3156445.help.text -msgid "\\<bookmark_value\\>formulas; operators\\</bookmark_value\\>\\<bookmark_value\\>operators; formula functions\\</bookmark_value\\>" -msgstr "\\<bookmark_value\\>funkce vzorců; operátory\\</bookmark_value\\>\\<bookmark_value\\>operátory; funkce vzorců\\</bookmark_value\\>" +msgid "" +"\\<bookmark_value\\>formulas; operators\\</bookmark_value\\>\\<bookmark_value\\>operators; formula functions\\</bookmark_value\\>\\<bookmark_value\\>division sign, see also operators\\</bookmark_value\\>\\<bookmark_value\\>multiplication sign, see also operators\\</bookmark_value\\>\\<bookmark_value\\>minus sign, see also operators\\</bookmark_value\\>\\<bookmark_value\\>plus sign, see also " +"operators\\</bookmark_value\\>\\<bookmark_value\\>text operators\\</bookmark_value\\>\\<bookmark_value\\>comparisons;operators in Calc\\</bookmark_value\\>\\<bookmark_value\\>arithmetical operators\\</bookmark_value\\>" +msgstr "" #: 04060199.xhp#hd_id3156445.1.help.text msgid "" @@ -26778,16 +26916,16 @@ msgstr "Skryje doplÅujÃcà volby." #: 12080000.xhp#tit.help.text -msgid "Outline" -msgstr "Osnova" +msgid "Group and Outline" +msgstr "" #: 12080000.xhp#bm_id3152350.help.text msgid "\\<bookmark_value\\>sheets; outlines\\</bookmark_value\\>\\<bookmark_value\\>outlines; sheets\\</bookmark_value\\>\\<bookmark_value\\>hiding; sheet details\\</bookmark_value\\>\\<bookmark_value\\>showing; sheet details\\</bookmark_value\\>\\<bookmark_value\\>grouping;cells\\</bookmark_value\\>" msgstr "\\<bookmark_value\\>listy; souhrn\\</bookmark_value\\>\\<bookmark_value\\>souhrn; listy\\</bookmark_value\\>\\<bookmark_value\\>skrytÃ; podrobnosti listu\\</bookmark_value\\>\\<bookmark_value\\>zobrazenÃ; podrobnosti listu\\</bookmark_value\\>\\<bookmark_value\\>seskupenÃ; buÅky\\</bookmark_value\\>" #: 12080000.xhp#hd_id3152350.1.help.text -msgid "\\<link href=\\\"text/scalc/01/12080000.xhp\\\" name=\\\"Outline\\\"\\>Outline\\</link\\>" -msgstr "\\<link href=\\\"text/scalc/01/12080000.xhp\\\" name=\\\"Souhrn\\\"\\>Souhrn\\</link\\>" +msgid "\\<link href=\\\"text/scalc/01/12080000.xhp\\\" name=\\\"Group and Outline\\\"\\>Group and Outline\\</link\\>" +msgstr "" #: 12080000.xhp#par_id3150793.2.help.text msgid "You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click." @@ -29640,6 +29778,57 @@ msgid "=YEARFRAC(\"1.1.2002\"; \"7.1.2002\";1) returns 0.495890." msgstr "=YEARFRAC(\"1.1.2002\"; \"7.1.2002\";1) vrátà 0,495890." +#~ msgid "" +#~ "_: 04060103.xhp#par_id3146148.66.help.text\n" +#~ "-" +#~ msgstr "-" + +#~ msgid "" +#~ "_: 04060103.xhp#par_id3156378.69.help.text\n" +#~ "-" +#~ msgstr "-" + +#~ msgid "" +#~ "_: 04060103.xhp#par_id3155838.72.help.text\n" +#~ "-" +#~ msgstr "-" + +#~ msgid "" +#~ "_: 04060103.xhp#par_id3156316.75.help.text\n" +#~ "-" +#~ msgstr "-" + +#~ msgid "" +#~ "In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number " +#~ "of measured values that are greater than 5 or greater than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." +#~ msgstr "" +#~ "Sloupec A v následujÃcà tabulce obsahuje nesetÅÃdÄné hodnoty mÄÅenÃ. Sloupec B obsahuje hornà meze intervalů, do kterých chceme rozdÄlit údaje ze sloupce A. Funkce FREQUENCY použije hodnotu v B1 k tomu, aby vrátila poÄet hodnot mÄÅenÃ, které jsou menÅ¡Ã nebo rovny 5. Na základÄ hodnoty B2 zase funkce FREQUENCY vrátà poÄet namÄÅených hodnot, které jsou vÄtÅ¡Ã než 5, nebo menÅ¡Ã nebo rovny 10. " +#~ "Text \">25\" zadaný do B6 nemá na funkci FREQUENCY vliv a sloužà pouze pro lepÅ¡Ã názornost." + +#~ msgid "" +#~ "Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the \\<emph\\>Data\\</emph\\> range in (A1:A11), and then the \\<emph\\>Classes\\</emph\\> range " +#~ "in which you entered the class limits (B1:B6). Select the \\<emph\\>Array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the range C1:C6." +#~ msgstr "" +#~ "Vyberte jednosloupcový rozsah bunÄk, do kterých chcete vložit Äetnosti zdrojových hodnot, spoÄtené pro jednotlivé intervaly (tÅÃdy). MusÃte vybrat o jednu buÅku vÃce, než je poÄet tÅÃd, do této buÅky bude vložena Äetnost hodnot, které pÅekraÄujà hornà limit poslednà tÅÃdy. V tomto pÅÃkladÄ vyberte buÅky C1:C6. V \\<emph\\>Průvodci funkcÃ\\</emph\\> zvolte funkci FREQUENCY. Jako \\<emph\\>Data" +#~ "\\</emph\\> dále zadejte rozsah bunÄk obsahujÃcÃch hodnoty mÄÅenà (A1:A11) a také sloupec obsahujÃcà hornà meze zkoumaných intervalů jako \\<emph\\>TÅÃdy\\</emph\\>; tedy buÅky B1:B6. ZaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\> a klepnÄte na \\<emph\\>OK\\</emph\\>. V původnÄ oznaÄeném rozsahu bunÄk C1:C6 nynà vidÃte Äetnosti hodnot mÄÅenà v pÅÃsluÅ¡ných intervalech." + +#~ msgid "" +#~ "\\<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 \\<emph\\>index\\</emph\\>. If the \\<emph\\>Sort order\\</emph\\> parameter is omitted or set to TRUE, it is " +#~ "assumed that the data is sorted in ascending order. In this case, if the exact \\<emph\\>search criterion\\</emph\\> is not found, the next value will be returned. If \\<emph\\>Sort order\\</emph\\> 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 "" +#~ "\\<ahelp hid=\\\"HID_FUNC_SVERWEIS\\\"\\>Svislé vyhledávánà s vracejÃcà hodnotu z prava pÅilehlých bunÄk.\\</ahelp\\> Tato funkce hledá požadovanou hodnotu v prvnÃm sloupci oblasti a navracà hodnotu z takto nalezeného Åádku, která se nacházà ve sloupci urÄeném parametrem \\<emph\\>index\\</emph\\>. Pokud je parametr \\<emph\\>ÅazenÃ\\</emph\\> vynechán nebo nastaven na TRUE, pÅedpokládá se, " +#~ "že data jsou seÅazena vzestupnÄ. V tom pÅÃpadÄ (pokud nenà nalezeno pÅesné \\<emph\\>Kritérium vyhledávánÃ\\</emph\\>), se vrátà následujÃcà hodnota. Pokud je \\<emph\\>ÅazenÃ\\</emph\\> nastaveno na FALSE nebo nulu, musà být nalezena pÅesná hodnota, jinak funkce vrátà chybu \\<emph\\>Chyba: hodnota nenà k dispozici\\</emph\\>. Data pak nemusà být seÅazena vzestupnÄ." + +#~ msgid "\\<bookmark_value\\>formulas; operators\\</bookmark_value\\>\\<bookmark_value\\>operators; formula functions\\</bookmark_value\\>" +#~ msgstr "\\<bookmark_value\\>funkce vzorců; operátory\\</bookmark_value\\>\\<bookmark_value\\>operátory; funkce vzorců\\</bookmark_value\\>" + +#~ msgid "Outline" +#~ msgstr "Osnova" + +#~ msgid "\\<link href=\\\"text/scalc/01/12080000.xhp\\\" name=\\\"Outline\\\"\\>Outline\\</link\\>" +#~ msgstr "\\<link href=\\\"text/scalc/01/12080000.xhp\\\" name=\\\"Souhrn\\\"\\>Souhrn\\</link\\>" + #~ msgid "Strings" #~ msgstr "ÅetÄzce" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
