User: pjanik Date: 2008-03-08 17:45:26+0000 Modified: cs/po/helpcontent2/source/text/scalc/05.po
Log: Update to DEV300_m2. File Changes: Directory: /cs/po/helpcontent2/source/text/scalc/ ================================================= File [changed]: 05.po Url: http://cs.openoffice.org/source/browse/cs/po/helpcontent2/source/text/scalc/05.po?r1=1.23&r2=1.24 Delta lines: +211 -158 ----------------------- --- 05.po 2008-02-15 16:37:58+0000 1.23 +++ 05.po 2008-03-08 17:45:23+0000 1.24 @@ -2,10 +2,8 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"Report-Msgid-Bugs-To: http://qa.openoffice.org/issues/enter_bug.cgi?subcompo"; -"nent=ui&comment=&short_desc=Localization%20issue%20in%20file%3A%20helpconten" -"t2/source/text/scalc/05.oo&component=l10n&form_name=enter_issue\n" -"POT-Creation-Date: 2008-02-15 16:43+0200\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/05.oo&component=l10n&form_name=enter_issue\n"; +"POT-Creation-Date: 2008-03-08 17:11+0200\n" "PO-Revision-Date: 2008-02-15 17:07+0100\n" "Last-Translator: FULL NAME <[EMAIL PROTECTED]>\n" "Language-Team: LANGUAGE <[EMAIL PROTECTED]>\n" @@ -24,26 +22,12 @@ msgstr "<bookmark_value>kôdy chyb;seznam</bookmark_value>" #: 02140000.xhp#hd_id3146797.1.help.text -msgid "" -"<link href=\"text/scalc/05/02140000.xhp\" name=\"Error Codes in %PRODUCTNAME " -"Calc\">Error Codes in <item type=\"productname\">%PRODUCTNAME</item> " -"Calc</link>" -msgstr "" -"<link href=\"text/scalc/05/02140000.xhp\" name=\"Kódy chyb v aplikaci " -"%PRODUCTNAME Calc\">Kódy chyb v aplikaci <item " -"type=\"productname\">%PRODUCTNAME</item> Calc</link>" +msgid "<link href=\"text/scalc/05/02140000.xhp\" name=\"Error Codes in %PRODUCTNAME Calc\">Error Codes in <item type=\"productname\">%PRODUCTNAME</item> Calc</link>" +msgstr "<link href=\"text/scalc/05/02140000.xhp\" name=\"Kódy chyb v aplikaci %PRODUCTNAME Calc\">Kódy chyb v aplikaci <item type=\"productname\">%PRODUCTNAME</item> Calc</link>" #: 02140000.xhp#par_id3150275.2.help.text -msgid "" -"The following table is an overview of the error messages for <item " -"type=\"productname\">%PRODUCTNAME</item> Calc. If the error occurs in the cell " -"that contains the cursor, the error message is displayed on the " -"<emph>Status Bar</emph>." -msgstr "" -"Následuje tabulka s pÅehledem chybových hlášenà <item " -"type=\"productname\">%PRODUCTNAME</item> Calc. Pokud nastane chyba v buÅce, " -"která obsahuje kurzor, chybové hlášenà se zobrazà ve <emph>stavovém " -"Åádku</emph>." +msgid "The following table is an overview of the error messages for <item type=\"productname\">%PRODUCTNAME</item> Calc. If the error occurs in the cell that contains the cursor, the error message is displayed on the <emph>Status Bar</emph>." +msgstr "Následuje tabulka s pÅehledem chybových hlášenà <item type=\"productname\">%PRODUCTNAME</item> Calc. Pokud nastane chyba v buÅce, která obsahuje kurzor, chybové hlášenà se zobrazà ve <emph>stavovém Åádku</emph>." #: 02140000.xhp#par_id3153968.3.help.text msgid "Error Code" @@ -66,8 +50,7 @@ msgstr "Neplatný znak" #: 02140000.xhp#par_id3155854.8.help.text -msgid "" -"Character in a formula is not valid, for example, \"=1Eq\" instead of \"=1E2\"." +msgid "Character in a formula is not valid, for example, \"=1Eq\" instead of \"=1E2\"." msgstr "Znak ve vzorci je neplatný, napÅ.: \"=1Eq\" mÃsto \"=1E2\"." #: 02140000.xhp#par_id3145253.9.help.text @@ -79,12 +62,8 @@ msgstr "Neplatný argument" #: 02140000.xhp#par_id3153160.11.help.text -msgid "" -"Function argument is not valid, for example, a negative number for the root " -"function." -msgstr "" -"Argument funkce obsahuje neplatnou hodnotu, napÅ. záporné ÄÃslo v pÅÃpadÄ " -"odmocniny." +msgid "Function argument is not valid, for example, a negative number for the root function." +msgstr "Argument funkce obsahuje neplatnou hodnotu, napÅ. záporné ÄÃslo v pÅÃpadÄ odmocniny." #: 02140000.xhp#par_id3154015.12.help.text msgid "503" @@ -111,12 +90,8 @@ msgstr "Chyba v seznamu parametrů" #: 02140000.xhp#par_id3147003.17.help.text -msgid "" -"Function parameter is not valid, for example, text instead of a number, or a " -"domain reference instead of cell reference." -msgstr "" -"Parametr funkce je neplatného typu, napÅ. text mÃsto ÄÃsla nebo odkaz k " -"doménÄ mÃsto odkazu k buÅce." +msgid "Function parameter is not valid, for example, text instead of a number, or a domain reference instead of cell reference." +msgstr "Parametr funkce je neplatného typu, napÅ. text mÃsto ÄÃsla nebo odkaz k doménÄ mÃsto odkazu k buÅce." #: 02140000.xhp#par_id3154532.27.help.text msgid "508" @@ -128,9 +103,7 @@ #: 02140000.xhp#par_id3149129.29.help.text msgid "Missing bracket, for example, closing brackets, but no opening brackets" -msgstr "" -"ChybÄjÃcà závorka, napÅ. uzavÃrajÃcà závorka bez odpovÃdajÃcà otevÃracà " -"závorky" +msgstr "ChybÄjÃcà závorka, napÅ. uzavÃrajÃcà závorka bez odpovÃdajÃcà otevÃracà závorky" #: 02140000.xhp#par_id3149895.30.help.text msgid "509" @@ -141,11 +114,8 @@ msgstr "Chybà operátor" #: 02140000.xhp#par_id3154649.32.help.text -msgid "" -"Operator is missing, for example, \"=2(3+4) * \", where the operator between " -"\"2\" and \"(\" is missing." -msgstr "" -"ChybÄjÃcà operátor, napÅ. v \"=2(3+4) * \", kde chybà operátor mezi \"2\" a \"(\"." +msgid "Operator is missing, for example, \"=2(3+4) * \", where the operator between \"2\" and \"(\" is missing." +msgstr "ChybÄjÃcà operátor, napÅ. v \"=2(3+4) * \", kde chybà operátor mezi \"2\" a \"(\"." #: 02140000.xhp#par_id3153813.33.help.text msgid "510" @@ -157,8 +127,7 @@ msgstr "Chybà promÄnná" #: 02140000.xhp#par_id3154710.35.help.text -msgid "" -"Variable is missing, for example when two operators are together \"=1+*2\"." +msgid "Variable is missing, for example when two operators are together \"=1+*2\"." msgstr "ChybÄjÃcà promÄnná, napÅ. když jsou dva operátory vedle sebe \"=1+*2\"." #: 02140000.xhp#par_id3154739.36.help.text @@ -171,11 +140,8 @@ msgstr "Chybà promÄnná" #: 02140000.xhp#par_id3145319.38.help.text -msgid "" -"Function requires more variables than are provided, for example, AND() and " -"OR()." -msgstr "" -"Funkce vyžaduje vÃce promÄnných než je zadáno, napÅ. funkce AND() nebo OR()." +msgid "Function requires more variables than are provided, for example, AND() and OR()." +msgstr "Funkce vyžaduje vÃce promÄnných než je zadáno, napÅ. funkce AND() nebo OR()." #: 02140000.xhp#par_id3149050.39.help.text msgid "512" @@ -186,18 +152,8 @@ msgstr "PÅeteÄenà vzorce" #: 02140000.xhp#par_id3159259.41.help.text -msgid "" -"<emph>Compiler:</emph> the total number of internal tokens, (that is, " -"operators, variables, brackets) in the formula exceeds 512. " -"<emph>Interpreter:</emph> the total number of matrices that the formula " -"creates exceeds 150. This includes basic functions that receive too large an " -"array as a parameter (max. 0xFFFE, for example, 65534 bytes)." -msgstr "" -"<emph>Kompilátor:</emph> celkový poÄet internÃch symbolů (tj. operátorů, " -"promÄnných, závorek) ve vzorci pÅesáhl 512. <emph>Interpreter:</emph> " -"celkový poÄet matric ve vzorci pÅesáhl 150. Zahrnuje také základnà funkce, " -"kterým bylo jako parametr pÅedáno pÅÃliÅ¡ velké pole (max. 0xFFFE, napÅ 65534 " -"bytů)." +msgid "<emph>Compiler:</emph> the total number of internal tokens, (that is, operators, variables, brackets) in the formula exceeds 512. <emph>Interpreter:</emph> the total number of matrices that the formula creates exceeds 150. This includes basic functions that receive too large an array as a parameter (max. 0xFFFE, for example, 65534 bytes)." +msgstr "<emph>Kompilátor:</emph> celkový poÄet internÃch symbolů (tj. operátorů, promÄnných, závorek) ve vzorci pÅesáhl 512. <emph>Interpreter:</emph> celkový poÄet matric ve vzorci pÅesáhl 150. Zahrnuje také základnà funkce, kterým bylo jako parametr pÅedáno pÅÃliÅ¡ velké pole (max. 0xFFFE, napÅ 65534 bytů)." #: 02140000.xhp#par_id3150537.42.help.text msgid "513" @@ -208,14 +164,8 @@ msgstr "PÅeteÄenà ÅetÄzce" #: 02140000.xhp#par_id3145635.44.help.text -msgid "" -"<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. " -"<emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in " -"size." -msgstr "" -"<emph>Kompilátor:</emph> identifikátor ve vzorci pÅesahuje velikost 64 KB. " -"<emph>Interpreter:</emph> výsledek ÅetÄzcové operace pÅesahuje velikost 64 " -"KB." +msgid "<emph>Compiler:</emph> an identifier in the formula exceeds 64 KB in size. <emph>Interpreter:</emph> a result of a string operation exceeds 64 KB in size." +msgstr "<emph>Kompilátor:</emph> identifikátor ve vzorci pÅesahuje velikost 64 KB. <emph>Interpreter:</emph> výsledek ÅetÄzcové operace pÅesahuje velikost 64 KB." #: 02140000.xhp#par_id3149147.45.help.text msgid "514" @@ -227,12 +177,8 @@ msgstr "Internà pÅeteÄenÃ" #: 02140000.xhp#par_id3149352.47.help.text -msgid "" -"Sort operation attempted on too much numerical data (max. 100000) or a " -"calculation stack overflow." -msgstr "" -"ÅadÃcà operace s pÅÃliÅ¡ velkým objemem ÄÃselných dat (max. 100 000), nebo " -"pÅeteÄenà zásobnÃku výpoÄtu." +msgid "Sort operation attempted on too much numerical data (max. 100000) or a calculation stack overflow." +msgstr "ÅadÃcà operace s pÅÃliÅ¡ velkým objemem ÄÃselných dat (max. 100 000), nebo pÅeteÄenà zásobnÃku výpoÄtu." #: 02140000.xhp#par_id3154841.51.help.text msgid "516" @@ -257,12 +203,8 @@ msgstr "VnitÅnà syntaktická chyba" #: 02140000.xhp#par_id3149507.56.help.text -msgid "" -"Unknown code, for example, a document with a newer function is loaded in an " -"older version that does not contain the function." -msgstr "" -"Neznámá instrukce, napÅ. dokument s novÄjÅ¡Ã funkcà je naÄten do starÅ¡Ã " -"verze, která tuto funkci neobsahuje." +msgid "Unknown code, for example, a document with a newer function is loaded in an older version that does not contain the function." +msgstr "Neznámá instrukce, napÅ. dokument s novÄjÅ¡Ã funkcà je naÄten do starÅ¡Ã verze, která tuto funkci neobsahuje." #: 02140000.xhp#par_id3148585.57.help.text msgid "518" @@ -290,12 +232,8 @@ msgstr "Žádný výsledek (v buÅce se zobrazà #VALUE namÃsto Chyba:519!)" #: 02140000.xhp#par_id3153108.62.help.text -msgid "" -"The formula yields a value that does not correspond to the definition; or a " -"cell that is referenced in the formula contains text instead of a number." -msgstr "" -"Výsledkem vzorce je hodnota, která neodpovÃdá definici; nebo buÅka " -"odkazovaná ve vzorci obsahuje text mÃsto ÄÃsla." +msgid "The formula yields a value that does not correspond to the definition; or a cell that is referenced in the formula contains text instead of a number." +msgstr "Výsledkem vzorce je hodnota, která neodpovÃdá definici; nebo buÅka odkazovaná ve vzorci obsahuje text mÃsto ÄÃsla." #: 02140000.xhp#par_id3150338.63.help.text msgid "520" @@ -332,13 +270,8 @@ msgstr "Cyklický odkaz" #: 02140000.xhp#par_id3157972.71.help.text -msgid "" -"Formula refers directly or indirectly to itself and the " -"<emph>Iterations</emph> option is not set under Tools - Options - " -"%PRODUCTNAME Calc - Calculate." -msgstr "" -"Vzorec odkazuje pÅÃmo nebo nepÅÃmo sám na sebe a v nabÃdce Nástroje - Volby " -"- %PRODUCTNAME Calc - VýpoÄty nenà povolena volba <emph>Iterace</emph>." +msgid "Formula refers directly or indirectly to itself and the <emph>Iterations</emph> option is not set under Tools - Options - %PRODUCTNAME Calc - Calculate." +msgstr "Vzorec odkazuje pÅÃmo nebo nepÅÃmo sám na sebe a v nabÃdce Nástroje - Volby - %PRODUCTNAME Calc - VýpoÄty nenà povolena volba <emph>Iterace</emph>." #: 02140000.xhp#par_id3149538.72.help.text msgid "523" @@ -349,14 +282,8 @@ msgstr "VýpoÄet nekonverguje" #: 02140000.xhp#par_id3150272.74.help.text -msgid "" -"Function missed a targeted value, or <link " -"href=\"text/shared/optionen/01060500.xhp\">iterative references</link> do not " -"reach the minimum change within the maximum steps that are set." -msgstr "" -"Funkce nedosáhla cÃlové hodnoty, nebo <link " -"href=\"text/shared/optionen/01060500.xhp\">iterativnà odkazy</link> nedosáhly " -"minimálnà zmÄny v nastavených mezÃch." +msgid "Function missed a targeted value, or <link href=\"text/shared/optionen/01060500.xhp\">iterative references</link> do not reach the minimum change within the maximum steps that are set." +msgstr "Funkce nedosáhla cÃlové hodnoty, nebo <link href=\"text/shared/optionen/01060500.xhp\">iterativnà odkazy</link> nedosáhly minimálnà zmÄny v nastavených mezÃch." #: 02140000.xhp#par_id3153544.75.help.text msgid "524" @@ -367,29 +294,16 @@ msgstr "#REF" #: 02140000.xhp#bm_id3154634.help.text -msgid "" -"<bookmark_value>invalid references; error " -"messages</bookmark_value><bookmark_value>error messages;invalid " -"references</bookmark_value><bookmark_value>#REF error " -"message</bookmark_value>" -msgstr "" -"<bookmark_value>neplatný odkaz; chybové " -"hlášenÃ</bookmark_value><bookmark_value>chybové hlášenÃ; neplatný " -"odkaz</bookmark_value><bookmark_value>chybové hlášenà #REF</bookmark_value>" +msgid "<bookmark_value>invalid references; error messages</bookmark_value><bookmark_value>error messages;invalid references</bookmark_value><bookmark_value>#REF error message</bookmark_value>" +msgstr "<bookmark_value>neplatný odkaz; chybové hlášenÃ</bookmark_value><bookmark_value>chybové hlášenÃ; neplatný odkaz</bookmark_value><bookmark_value>chybové hlášenà #REF</bookmark_value>" #: 02140000.xhp#par_id3154634.76.help.text msgid "invalid references (instead of Err:524 cell contains #REF)" msgstr "Neplatný odkaz (v buÅce se zobrazà #REF namÃsto Chyba:524)" #: 02140000.xhp#par_id3147539.77.help.text -msgid "" -"<emph>Compiler:</emph> a column or row description name could not be " -"resolved. <emph>Interpreter:</emph> in a formula, the column, row, or sheet " -"that contains a referenced cell is missing." -msgstr "" -"<emph>Kompilátor:</emph> nelze vyhodnotit název sloupce nebo Åádku. " -"<emph>Interpreter:</emph> ve vzorci chybà sloupec, Åádek nebo list s " -"odkazovanou buÅkou." +msgid "<emph>Compiler:</emph> a column or row description name could not be resolved. <emph>Interpreter:</emph> in a formula, the column, row, or sheet that contains a referenced cell is missing." +msgstr "<emph>Kompilátor:</emph> nelze vyhodnotit název sloupce nebo Åádku. <emph>Interpreter:</emph> ve vzorci chybà sloupec, Åádek nebo list s odkazovanou buÅkou." #: 02140000.xhp#par_id3155984.78.help.text msgid "525" @@ -400,27 +314,16 @@ msgstr "#NAME?" #: 02140000.xhp#bm_id3148428.help.text -msgid "" -"<bookmark_value>invalid names; error " -"messages</bookmark_value><bookmark_value>#NAME error " -"message</bookmark_value>" -msgstr "" -"<bookmark_value>neplatné názvy; chybová " -"hlášenÃ</bookmark_value><bookmark_value>chybové hlášenà " -"#NAME</bookmark_value>" +msgid "<bookmark_value>invalid names; error messages</bookmark_value><bookmark_value>#NAME error message</bookmark_value>" +msgstr "<bookmark_value>neplatné názvy; chybová hlášenÃ</bookmark_value><bookmark_value>chybové hlášenà #NAME</bookmark_value>" #: 02140000.xhp#par_id3148428.79.help.text msgid "invalid names (instead of Err:525 cell contains #NAME?)" msgstr "Neplatné názvy (v buÅce se zobrazà #NAME? namÃsto Chyba:525)" #: 02140000.xhp#par_id3156259.80.help.text -msgid "" -"An identifier could not be evaluated, for example, no valid reference, no " -"valid domain name, no column/row label, no macro, incorrect decimal divider, " -"add-in not found." -msgstr "" -"Identifikátor nelze vyhodnotit. NapÅ. neplatný odkaz, neplatný název domény, " -"neplatný sloupec/Åádek, chybÄjÃcà makro nebo nesprávný desetinný oddÄlovaÄ." +msgid "An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found." +msgstr "Identifikátor nelze vyhodnotit. NapÅ. neplatný odkaz, neplatný název domény, neplatný sloupec/Åádek, chybÄjÃcà makro nebo nesprávný desetinný oddÄlovaÄ." #: 02140000.xhp#par_id3153720.81.help.text msgid "526" @@ -432,12 +335,8 @@ msgstr "VnitÅnà syntaktická chyba" #: 02140000.xhp#par_id3083286.83.help.text -msgid "" -"Obsolete, no longer used, but could come from old documents if the result is " -"a formula from a domain." -msgstr "" -"Již se nepoužÃvá, ale může vzniknout ve starých dokumentech, je-li výsledkem " -"vzorec z domény." +msgid "Obsolete, no longer used, but could come from old documents if the result is a formula from a domain." +msgstr "Již se nepoužÃvá, ale může vzniknout ve starých dokumentech, je-li výsledkem vzorec z domény." #: 02140000.xhp#par_id3152483.84.help.text msgid "527" @@ -449,12 +348,8 @@ msgstr "Internà pÅeteÄenÃ" #: 02140000.xhp#par_id3149709.86.help.text -msgid "" -"<emph>Interpreter: </emph>References, such as when a cell references a cell, " -"are too encapsulated." -msgstr "" -"<emph>Interpreter: </emph> Odkazy (napÅ. když buÅka odkazuje na buÅku) jsou " -"pÅÃliÅ¡ zanoÅené." +msgid "<emph>Interpreter: </emph>References, such as when a cell references a cell, are too encapsulated." +msgstr "<emph>Interpreter: </emph> Odkazy (napÅ. když buÅka odkazuje na buÅku) jsou pÅÃliÅ¡ zanoÅené." #: 02140000.xhp#par_id5324564.help.text msgid "532" @@ -469,13 +364,171 @@ msgstr "DÄlenà nulou" #: 02140000.xhp#par_id5844294.help.text -msgid "" -"Division operator / if the denominator is 0<br/>Some more functions return " -"this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with " -"less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less " -"than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0" -msgstr "" -"DÄlenà nulou pomocà operátoru /<br/>Tuto chybu vracà i jiné funkce, " -"napÅÃklad:<br/>VARP s ménÄ než 1 argumentem<br/>STDEVP s ménÄ než jednÃm " -"argumentem<br/>VAR s ménÄ než 2 argumenty<br/>STDEV s ménÄ než 2 " -"argumenty<br/>STANDARDIZE pÅi stdev=0<br/>NORMDIST pÅi stdev=0" +msgid "Division operator / if the denominator is 0<br/>Some more functions return this error, for example:<br/>VARP with less than 1 argument<br/>STDEVP with less than 1 argument<br/>VAR with less than 2 arguments<br/>STDEV with less than 2 arguments<br/>STANDARDIZE with stdev=0<br/>NORMDIST with stdev=0" +msgstr "DÄlenà nulou pomocà operátoru /<br/>Tuto chybu vracà i jiné funkce, napÅÃklad:<br/>VARP s ménÄ než 1 argumentem<br/>STDEVP s ménÄ než jednÃm argumentem<br/>VAR s ménÄ než 2 argumenty<br/>STDEV s ménÄ než 2 argumenty<br/>STANDARDIZE pÅi stdev=0<br/>NORMDIST pÅi stdev=0" + +#: empty_cells.xhp#tit.help.text +msgid "Handling of Empty Cells" +msgstr "" + +#: empty_cells.xhp#bm_id3146799.help.text +msgid "<bookmark_value>empty cells;handling of</bookmark_value>" +msgstr "" + +#: empty_cells.xhp#hd_id1502121.help.text +msgid "<variable id=\"empty_cells\"><link href=\"text/scalc/05/empty_cells.xhp\">Handling of Empty Cells</link></variable>" +msgstr "" + +#: empty_cells.xhp#par_id2871181.help.text +msgid "Starting with OpenOffice.org 3.0 and StarOffice 9, the handling of empty cells got changed." +msgstr "" + +#: empty_cells.xhp#par_id8266853.help.text +msgid "Previously, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1=\"\" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)=\"\" give TRUE if the lookup resulted in an empty cell being returned. " +msgstr "" + +#: empty_cells.xhp#par_id2733542.help.text +msgid "A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. " +msgstr "" + +#: empty_cells.xhp#par_id4238715.help.text +msgid "For the following examples, A1 contains a number, B1 is empty, C1 contains the reference to B1:" +msgstr "" + +#: empty_cells.xhp#par_id8277230.help.text +msgid "A1: 1 B1: <empty> C1: =B1 (displays 0)" +msgstr "" + +#: empty_cells.xhp#par_id4086428.help.text +msgctxt "empty_cells.xhp#par_id4086428.help.text" +msgid "=B1=0 => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id9024628.help.text +msgid "=B1=\"\" => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id3067110.help.text +msgid "=C1=0 => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id8841822.help.text +msgid "=C1=\"\" => TRUE (previously was FALSE)" +msgstr "" + +#: empty_cells.xhp#par_id4077578.help.text +msgid "=ISNUMBER(B1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id9094515.help.text +msgid "=ISNUMBER(C1) => FALSE (previously was TRUE)" +msgstr "" + +#: empty_cells.xhp#par_id396740.help.text +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1)" +msgstr "" + +#: empty_cells.xhp#par_id3859675.help.text +msgid "=ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE)" +msgstr "" + +#: empty_cells.xhp#par_id402233.help.text +msgctxt "empty_cells.xhp#par_id402233.help.text" +msgid "=ISTEXT(B1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id1623889.help.text +msgctxt "empty_cells.xhp#par_id1623889.help.text" +msgid "=ISTEXT(C1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id7781914.help.text +msgid "=ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE)" +msgstr "" + +#: empty_cells.xhp#par_id300912.help.text +msgid "=ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" +msgstr "" + +#: empty_cells.xhp#par_id9534592.help.text +msgid "=ISBLANK(B1) => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id4969328.help.text +msgid "=ISBLANK(C1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id9635914.help.text +msgid "=ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE)" +msgstr "" + +#: empty_cells.xhp#par_id2476577.help.text +msgid "=ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1)" +msgstr "" + +#: empty_cells.xhp#par_id4217047.help.text +msgid "Note that Microsoft Excel behaves different and always returns a number as the result of a reference to an empty cell or a formula cell with the result of an empty cell. For example:" +msgstr "" + +#: empty_cells.xhp#par_id2629474.help.text +msgid "A1: <empty>" +msgstr "" + +#: empty_cells.xhp#par_id8069704.help.text +msgid "B1: =A1 => displays 0, but is just a reference to an empty cell" +msgstr "" + +#: empty_cells.xhp#par_id4524674.help.text +msgid "=ISNUMBER(A1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id4396801.help.text +msgid "=ISTEXT(A1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id5293740.help.text +msgid "=A1=0 => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id7623828.help.text +msgid "=A1=\"\" => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id2861720.help.text +msgid "=ISNUMBER(B1) => FALSE (MS-Excel: TRUE)" +msgstr "" + +#: empty_cells.xhp#par_id9604480.help.text +msgctxt "empty_cells.xhp#par_id9604480.help.text" +msgid "=ISTEXT(B1) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id2298959.help.text +msgctxt "empty_cells.xhp#par_id2298959.help.text" +msgid "=B1=0 => TRUE" +msgstr "" + +#: empty_cells.xhp#par_id4653767.help.text +msgid "=B1=\"\" => TRUE (MS-Excel: FALSE)" +msgstr "" + +#: empty_cells.xhp#par_id8801538.help.text +msgid "C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0)" +msgstr "" + +#: empty_cells.xhp#par_id6746421.help.text +msgid "=ISNUMBER(VLOOKUP(...)) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id4876247.help.text +msgid "=ISTEXT(VLOOKUP(...)) => FALSE" +msgstr "" + +#: empty_cells.xhp#par_id7458723.help.text +msgid "=ISNUMBER(C1) => FALSE (MS-Excel: TRUE)" +msgstr "" + +#: empty_cells.xhp#par_id2753379.help.text +msgctxt "empty_cells.xhp#par_id2753379.help.text" +msgid "=ISTEXT(C1) => FALSE" +msgstr "" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
