Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/cs/units/?format=api&page=6
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting." ], "previous_source": "", "target": [ "Určité hodnoty v tabulce lze patřičně zvýraznit. Například v tabulce obratů je možné všechny hodnoty nad průměrem zobrazit zeleně a ty pod průměrem červeně. To umožňuje Podmíněné formátování:" ], "id_hash": -4753521984506958934, "content_hash": -4753521984506958934, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text", "note": "5TVr9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936420/?format=api", "priority": 100, "id": 1944969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/1944969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.736445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50)." ], "previous_source": "", "target": [ "Do buňky napište =RAND(), čímž dostanete náhodné číslo mezi 0 a 1. Celá čísla mezi 0 a 50 dostanete zápisem =INT(RAND()*50)." ], "id_hash": 7837711463613136779, "content_hash": 7837711463613136779, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text", "note": "A66qh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936422/?format=api", "priority": 100, "id": 1944971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/1944971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.763384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected." ], "previous_source": "", "target": [ "Rozkopírujte vzorec, abyste dostali řádek náhodných čísel. Potáhněte za pravý dolní roh buňky, dokud se nevytvoří požadovaný počet buněk." ], "id_hash": 6892568724043407820, "content_hash": 6892568724043407820, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text", "note": "rCrEf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936423/?format=api", "priority": 100, "id": 1944972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/1944972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.779000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers." ], "previous_source": "", "target": [ "Stejným způsobem potáhněte za pravý dolní roh buňky nejvíce vpravo, čímž vytvoříte další řádky náhodných čísel." ], "id_hash": -2947348419295557648, "content_hash": -2947348419295557648, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text", "note": "Tm6MA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936424/?format=api", "priority": 100, "id": 1944973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/1944973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.790358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Krok 2: Definování stylů buňky" ], "id_hash": 1860090573670708058, "content_hash": 1860090573670708058, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text", "note": "i3CTm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936425/?format=api", "priority": 100, "id": 1944974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/1944974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.802578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding." ], "previous_source": "", "target": [ "Dalším krokem je použití stylu na hodnoty nad a pod průměrem hodnot. Před pokračováním se ujistěte, že okno Styly je viditelné." ], "id_hash": 2515053443613502634, "content_hash": 2515053443613502634, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text", "note": "sr6WY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24936426/?format=api", "priority": 100, "id": 1944975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/1944975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.815221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Klepněte na prázdnou buňku a z místní nabídky vyberte <emph>Formát buněk...</emph>." ], "id_hash": -6456560012199126547, "content_hash": -6456560012199126547, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text", "note": "CVM3G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936427/?format=api", "priority": 100, "id": 1944976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/1944976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.828935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, \"Below\")." ], "previous_source": "", "target": [ "Druhý styl nadefinujte stejným postupem jako první, jen vyberte jinou barvu pozadí a nazvěte ho \"Pod\"." ], "id_hash": 2559261581071111980, "content_hash": 2559261581071111980, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text", "note": "4bRZa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24936430/?format=api", "priority": 100, "id": 1944979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/1944979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.871288Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Krok 3: Výpočet průměru" ], "id_hash": 7675455618679043080, "content_hash": 7675455618679043080, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text", "note": "x3rxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936431/?format=api", "priority": 100, "id": 1944980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/1944980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.884037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In our particular example, we are calculating the average of the random values. The result is placed in a cell:" ], "previous_source": "", "target": [ "V tomto příkladu spočítáme průměr náhodných čísel. Výsledek bude v buňce:" ], "id_hash": 4578609383930617086, "content_hash": 4578609383930617086, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text", "note": "f5sxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936432/?format=api", "priority": 100, "id": 1944981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/1944981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.895935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Nastavte kurzor do buňky (např. J14) a vyberte <emph>Vložit - Funkce...</emph>." ], "id_hash": -1641327560713127346, "content_hash": -1641327560713127346, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text", "note": "GhHpd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936433/?format=api", "priority": 100, "id": 1944982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/1944982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.917597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Zavřete Průvodce funkcí klepnutím na <item type=\"menuitem\">OK</item>." ], "id_hash": -5015363106791229593, "content_hash": -5015363106791229593, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text", "note": "YEqsh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936435/?format=api", "priority": 100, "id": 1944984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/1944984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.946764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Krok 4: Použití stylů buňky" ], "id_hash": -6453200130585452393, "content_hash": -6453200130585452393, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text", "note": "75WFf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936436/?format=api", "priority": 100, "id": 1944985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/1944985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.964238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Nyní lze použít podmíněné formátování listu." ], "id_hash": 7382243818509673232, "content_hash": 7382243818509673232, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text", "note": "AA6JP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936437/?format=api", "priority": 100, "id": 1944986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/1944986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.981056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Vyberte všechny buňky s náhodnými čísly jako blok." ], "id_hash": 7136521799982947324, "content_hash": 7136521799982947324, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text", "note": "7YuzB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936438/?format=api", "priority": 100, "id": 1944987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/1944987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.997202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Define the condition as follows: If cell value is less than J14, format with cell style \"Below\", and if cell value is greater than or equal to J14, format with cell style \"Above\"." ], "previous_source": "", "target": [ "Zadejte tuto podmínku: je-li hodnota buňky menší než J14, formátujte ji stylem Pod, je-li hodnota buňky větší nebo se rovná J14, formátujte ji stylem Nad." ], "id_hash": -3867351834357650696, "content_hash": -3867351834357650696, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text", "note": "oaUQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936440/?format=api", "priority": 100, "id": 1944989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/1944989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.017956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Krok 5: Kopírování stylu buňky" ], "id_hash": 6888277942235367290, "content_hash": 6888277942235367290, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text", "note": "p9FR7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936441/?format=api", "priority": 100, "id": 1944990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/1944990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.027002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "Chcete-li později použít podmíněné formátování u dalších buněk, použijte následující postup:" ], "id_hash": -7215413165649662082, "content_hash": -7215413165649662082, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text", "note": "GBgrB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936442/?format=api", "priority": 100, "id": 1944991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/1944991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.035349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click one of the cells that has been assigned conditional formatting." ], "previous_source": "", "target": [ "Klepněte na jednu z buněk, k níž bylo přiřazeno podmíněné formátování." ], "id_hash": 7196379235401938805, "content_hash": 7196379235401938805, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153074\nhelp.text", "note": "soRTt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 352, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936443/?format=api", "priority": 100, "id": 1944992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e3deacc95b213775", "url": "https://translations.documentfoundation.org/api/units/1944992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.043738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Copy the cell to the clipboard." ], "previous_source": "", "target": [ "Zkopírujte buňku do schránky." ], "id_hash": 5333275245432870135, "content_hash": 5333275245432870135, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149051\nhelp.text", "note": "35S7X", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 353, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936444/?format=api", "priority": 100, "id": 1944993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=ca0399942d6914f7", "url": "https://translations.documentfoundation.org/api/units/1944993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.052647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select the cells that are to receive this same formatting." ], "previous_source": "", "target": [ "Označte jako blok buňky, k nimž chcete přiřadit stejný typ formátování." ], "id_hash": 5816052215023921773, "content_hash": 5816052215023921773, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150436\nhelp.text", "note": "ogFEX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936445/?format=api", "priority": 100, "id": 1944994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=d0b6c4acbf9fea6d", "url": "https://translations.documentfoundation.org/api/units/1944994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.061543Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Highlighting Negative Numbers" ], "previous_source": "", "target": [ "Zvýraznění záporných čísel" ], "id_hash": -4059404321177657037, "content_hash": -4059404321177657037, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\ntit\nhelp.text", "note": "HFoKB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 358, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936449/?format=api", "priority": 100, "id": 1944998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=47aa19470c852133", "url": "https://translations.documentfoundation.org/api/units/1944998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.115322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>negative numbers</bookmark_value> <bookmark_value>numbers; highlighting negative numbers</bookmark_value> <bookmark_value>highlighting;negative numbers</bookmark_value> <bookmark_value>colors;negative numbers</bookmark_value> <bookmark_value>number formats;colors for negative numbers</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>záporná čísla</bookmark_value> <bookmark_value>čísla; zvýrazňování záporných čísel</bookmark_value> <bookmark_value>zvýrazňování;záporná čísla</bookmark_value> <bookmark_value>barvy;záporná čísla</bookmark_value> <bookmark_value>formáty čísla;barvy pro záporná čísla</bookmark_value>" ], "id_hash": 2690907695207962454, "content_hash": 2690907695207962454, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\nbm_id3147434\nhelp.text", "note": "9Zqdi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 359, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936450/?format=api", "priority": 100, "id": 1944999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=a558064ab03c5756", "url": "https://translations.documentfoundation.org/api/units/1944999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.124531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors." ], "previous_source": "", "target": [ "Buňkám lze nastavit formát čísla, který záporná čísla zobrazuje červenou barvou. Popřípadě je možné definovat vlastní formát, který záporná čísla zobrazí jinou barvou." ], "id_hash": -2401469527218566303, "content_hash": -2401469527218566303, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3153878\nhelp.text", "note": "YGxpk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 361, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936452/?format=api", "priority": 100, "id": 1945001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5eac443043364b61", "url": "https://translations.documentfoundation.org/api/units/1945001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.142333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select the cells and choose <emph>Format - Cells</emph>." ], "previous_source": "", "target": [ "Označte buňky a vyberte <emph>Formát - Buňky</emph>." ], "id_hash": -2610375749824612289, "content_hash": -2610375749824612289, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3155600\nhelp.text", "note": "ZFJHU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 362, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936453/?format=api", "priority": 100, "id": 1945002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5bc61515fd68f83f", "url": "https://translations.documentfoundation.org/api/units/1945002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.154994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</emph>." ], "previous_source": "", "target": [ "Na kartě <emph>Čísla</emph> vyberte formát čísla a zaškrtněte <emph>Záporná čísla červeně</emph>. Klepněte na <emph>OK</emph>." ], "id_hash": -2531380645435629521, "content_hash": -2531380645435629521, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3146969\nhelp.text", "note": "tYEZ3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 363, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24936454/?format=api", "priority": 100, "id": 1945003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5cdebab6fd82a02f", "url": "https://translations.documentfoundation.org/api/units/1945003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.171355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type=\"menuitem\">Format code</item>. For example, instead of RED, enter <item type=\"literal\">YELLOW</item>. If the new code appears in the list after clicking the <item type=\"menuitem\">Add</item> icon, this is a valid entry." ], "previous_source": "", "target": [ "Formát čísla v buňce je definován ve dvou částech. Formát pro kladná čísla a nulu je definován před středníkem; za středníkem je definován vzorec pro záporná čísla. Kód (RED) v <item type=\"menuitem\">Formátovací kód</item> můžete změnit. Například místo RED zadejte <item type=\"literal\">YELLOW</item>. Pokud se nový kód objeví v seznamu po klepnutí na ikonu <item type=\"menuitem\">Přidat</item>, jedná se o platný zápis." ], "id_hash": -4422457703490035149, "content_hash": -4422457703490035149, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3145640\nhelp.text", "note": "23n86", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 364, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://translations.documentfoundation.org/api/units/24936455/?format=api", "priority": 100, "id": 1945004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=42a046265d496233", "url": "https://translations.documentfoundation.org/api/units/1945004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.183430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Consolidating Data" ], "previous_source": "", "target": [ "Konsolidace dat" ], "id_hash": 5372822363492069186, "content_hash": 5372822363492069186, "location": "consolidate.xhp", "context": "consolidate.xhp\ntit\nhelp.text", "note": "G5Dfz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 376, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936456/?format=api", "priority": 100, "id": 1945005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=ca90197921382f42", "url": "https://translations.documentfoundation.org/api/units/1945005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.194727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>consolidating data</bookmark_value> <bookmark_value>ranges; combining</bookmark_value> <bookmark_value>combining;cell ranges</bookmark_value> <bookmark_value>tables; combining</bookmark_value> <bookmark_value>data; merging cell ranges</bookmark_value> <bookmark_value>merging;data ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>konsolidace dat</bookmark_value> <bookmark_value>oblasti; kombinování</bookmark_value> <bookmark_value>kombinování;oblasti buněk</bookmark_value> <bookmark_value>tabulky; kombinování</bookmark_value> <bookmark_value>data; spojování oblastí buněk</bookmark_value> <bookmark_value>spojování;oblasti dat</bookmark_value>" ], "id_hash": -8699824088904455889, "content_hash": -8699824088904455889, "location": "consolidate.xhp", "context": "consolidate.xhp\nbm_id3150791\nhelp.text", "note": "dEYi9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 377, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936457/?format=api", "priority": 100, "id": 1945006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=07440415b476a92f", "url": "https://translations.documentfoundation.org/api/units/1945006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.212385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "During consolidation, the contents of the cells from several sheets will be combined in one place." ], "previous_source": "", "target": [ "Během konsolidace bude obsah buněk z několika sešitů spojen do jednoho místa." ], "id_hash": 2863811470568569986, "content_hash": 2863811470568569986, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153191\nhelp.text", "note": "dcJqU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 379, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936459/?format=api", "priority": 100, "id": 1945008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=a7be4d5bfeedbc82", "url": "https://translations.documentfoundation.org/api/units/1945008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.238149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To Combine Cell Contents" ], "previous_source": "", "target": [ "Kombinování obsahu buněk" ], "id_hash": -7418047071167571604, "content_hash": -7418047071167571604, "location": "consolidate.xhp", "context": "consolidate.xhp\nhd_id892056\nhelp.text", "note": "GyvFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 380, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936460/?format=api", "priority": 100, "id": 1945009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=190dcd7dc3ee196c", "url": "https://translations.documentfoundation.org/api/units/1945009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.249515Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Open the document that contains the cell ranges to be consolidated." ], "previous_source": "", "target": [ "Otevřete dokument obsahující oblasti buněk, které chcete konsolidovat." ], "id_hash": 830377358914747267, "content_hash": 830377358914747267, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3151073\nhelp.text", "note": "4tD6G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936461/?format=api", "priority": 100, "id": 1945010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=8b8617cef3a3fb83", "url": "https://translations.documentfoundation.org/api/units/1945010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.260620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog." ], "previous_source": "", "target": [ "Zvolte <item type=\"menuitem\">Data - Konsolidovat</item> a otevře se dialogové okno <emph>Konsolidovat</emph>." ], "id_hash": -1340262079201837017, "content_hash": -1340262079201837017, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3154513\nhelp.text", "note": "77VUk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936462/?format=api", "priority": 100, "id": 1945011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=6d666ebd6f3f8027", "url": "https://translations.documentfoundation.org/api/units/1945011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.272156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas." ], "previous_source": "", "target": [ "V poli <emph>Zdrojová oblast dat</emph> vyberte oblast buněk, kterou chcete konsolidovat." ], "id_hash": 3568547474734044916, "content_hash": 3568547474734044916, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147345\nhelp.text", "note": "hJHqN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936463/?format=api", "priority": 100, "id": 1945012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=b186070573a3d6f4", "url": "https://translations.documentfoundation.org/api/units/1945012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.286464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse." ], "previous_source": "", "target": [ "Není-li oblast pojmenována, klepněte do pole vedle pole <emph>Zdrojová oblast dat</emph>. Objeví se blikající kurzor. Zadejte oblast buněk nebo jí vyberte myší." ], "id_hash": -667679353442180552, "content_hash": -667679353442180552, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149209\nhelp.text", "note": "CvGP2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 384, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24936464/?format=api", "priority": 100, "id": 1945013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=76bbed2a62376238", "url": "https://translations.documentfoundation.org/api/units/1945013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.300907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field." ], "previous_source": "", "target": [ "Klepnutím na <emph>Přidat</emph> vložíte vybranou oblast do pole <emph>Oblasti konsolidace</emph>." ], "id_hash": 3848135511423935069, "content_hash": 3848135511423935069, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3155529\nhelp.text", "note": "zSGyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936465/?format=api", "priority": 100, "id": 1945014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=b56752dbfdfd625d", "url": "https://translations.documentfoundation.org/api/units/1945014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.313588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select additional ranges and click <emph>Add</emph> after each selection." ], "previous_source": "", "target": [ "Vyberte další oblasti a každou přidejte klepnutím na <emph>Přidat</emph>." ], "id_hash": 7169276099035941393, "content_hash": 7169276099035941393, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153816\nhelp.text", "note": "Fo56E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 386, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936466/?format=api", "priority": 100, "id": 1945015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e37e62a0abbc4a11", "url": "https://translations.documentfoundation.org/api/units/1945015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.325129Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box." ], "previous_source": "", "target": [ "Vyberte cílovou oblast v poli <emph>Kopírovat výsledky do</emph>." ], "id_hash": 398797832588757125, "content_hash": 398797832588757125, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157983\nhelp.text", "note": "85CXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936467/?format=api", "priority": 100, "id": 1945016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=8588d0840ca60885", "url": "https://translations.documentfoundation.org/api/units/1945016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.336261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "If the target range is not named, click in the field next to <emph>Copy results to</emph> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range." ], "previous_source": "", "target": [ "Není-li cílová oblast pojmenována, klepněte do pole vedle pole <emph>Kopírovat výsledky do</emph> a zadejte oblast buněk. Oblast buněk lze též zadat pomocí myši nebo umístěním kurzoru do levé horní buňky cílové oblasti." ], "id_hash": -1876994938870961530, "content_hash": -1876994938870961530, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150215\nhelp.text", "note": "UByCi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24936468/?format=api", "priority": 100, "id": 1945017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=65f3930c3f63ea86", "url": "https://translations.documentfoundation.org/api/units/1945017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.350609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select a function from the <emph>Function</emph> box. The function specifies how the values of the consolidation ranges are linked. The \"Sum\" function is the default setting." ], "previous_source": "", "target": [ "V poli <emph>Funkce</emph> vyberte požadovanou funkci. Tato funkce bude použita na konsolidovaná data. Přednastavená je funkce \"Součet\"." ], "id_hash": -6052783438683441990, "content_hash": -6052783438683441990, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153813\nhelp.text", "note": "JvD9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936469/?format=api", "priority": 100, "id": 1945018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2c00318812e7f4ba", "url": "https://translations.documentfoundation.org/api/units/1945018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.364157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click <emph>OK</emph> to consolidate the ranges." ], "previous_source": "", "target": [ "Klepnutím na <emph>OK</emph> spustíte konsolidaci." ], "id_hash": -897663849380064562, "content_hash": -897663849380064562, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149315\nhelp.text", "note": "Z3iG2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936470/?format=api", "priority": 100, "id": 1945019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=738adb7c29fdd2ce", "url": "https://translations.documentfoundation.org/api/units/1945019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.379348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Additional Settings" ], "previous_source": "", "target": [ "Další nastavení" ], "id_hash": 1386989742513126216, "content_hash": 1386989742513126216, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_idN107DE\nhelp.text", "note": "qbEFs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 391, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936471/?format=api", "priority": 100, "id": 1945020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=933f93d27d9afb48", "url": "https://translations.documentfoundation.org/api/units/1945020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.395802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:" ], "previous_source": "", "target": [ "Klepněte na <emph>Více</emph> v dialogu <emph>Konsolidovat</emph>, čímž zobrazíte další nastavení:" ], "id_hash": -8685282467281095460, "content_hash": -8685282467281095460, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147250\nhelp.text", "note": "BSAXP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936472/?format=api", "priority": 100, "id": 1945021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=0777ad9cd3c834dc", "url": "https://translations.documentfoundation.org/api/units/1945021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.411727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range." ], "previous_source": "", "target": [ "Zaškrtnutím <emph>Odkaz na zdrojová data</emph> vložíte do cílové oblasti vzorce namísto výsledků. Kdykoliv se ve zdrojových oblastech změní hodnoty, budou automaticky přepočítány výsledky i v cílové oblasti." ], "id_hash": -3631865130924125807, "content_hash": -3631865130924125807, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3156400\nhelp.text", "note": "DEEPq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24936473/?format=api", "priority": 100, "id": 1945022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4d9905e7e723d191", "url": "https://translations.documentfoundation.org/api/units/1945022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.428007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed." ], "previous_source": "", "target": [ "Odpovídající buňky jsou vloženy do cílové oblasti, kde jsou automaticky uspořádány a poté skryty. Jsou zobrazeny.pouze konečné výsledky použití vybrané funkce." ], "id_hash": -1379167358946436983, "content_hash": -1379167358946436983, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150538\nhelp.text", "note": "VJPHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936474/?format=api", "priority": 100, "id": 1945023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=6cdc36981c2f1889", "url": "https://translations.documentfoundation.org/api/units/1945023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.439647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label." ], "previous_source": "", "target": [ "V části <emph>Konsolidovat</emph> zaškrtněte <emph>Popisky řádků</emph> nebo <emph>Popisky sloupců</emph>, chcete-li data ze zdrojové oblasti konsolidovat ne podle umístění v tabulce, ale podle odpovídajících popisků řádků či sloupců." ], "id_hash": 2054559487241974870, "content_hash": 2054559487241974870, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149945\nhelp.text", "note": "UubEm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24936475/?format=api", "priority": 100, "id": 1945024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=9c8342f7d6f77456", "url": "https://translations.documentfoundation.org/api/units/1945024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.451633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To consolidate by row labels or column labels, the label must be contained in the selected source ranges." ], "previous_source": "", "target": [ "Konsolidace podle popisků řádků či sloupců vyžaduje, aby popisky byly součástí zdrojových oblastí." ], "id_hash": -3469891027884511483, "content_hash": -3469891027884511483, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157871\nhelp.text", "note": "AEjpi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24936476/?format=api", "priority": 100, "id": 1945025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4fd8787e91a0ef05", "url": "https://translations.documentfoundation.org/api/units/1945025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.467558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column." ], "previous_source": "", "target": [ "Text v popiscích musí být stejný, aby bylo řádky či sloupce možné správně přiřadit. Pokud se popisky řádků či sloupců nepodaří přiřadit žádnému sloupci v cílové oblasti, budou přidány jako nový sloupec nebo řádek." ], "id_hash": 9184278295374865548, "content_hash": 9184278295374865548, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150478\nhelp.text", "note": "mQ3x2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936477/?format=api", "priority": 100, "id": 1945026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=ff751c730226248c", "url": "https://translations.documentfoundation.org/api/units/1945026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.485792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available." ], "previous_source": "", "target": [ "Data ze zdrojových oblastí a cílové oblasti jsou uložena při uložení souboru. Při pozdějším otevření souboru s konsolidací budou opět k dispozici." ], "id_hash": -6048694902205384958, "content_hash": -6048694902205384958, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147468\nhelp.text", "note": "UMqz7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24936478/?format=api", "priority": 100, "id": 1945027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2c0eb808a754f702", "url": "https://translations.documentfoundation.org/api/units/1945027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.498350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Importing and Exporting CSV Files" ], "previous_source": "", "target": [ "Import a export CSV souborů" ], "id_hash": 1932064022427195821, "content_hash": 1932064022427195821, "location": "csv_files.xhp", "context": "csv_files.xhp\ntit\nhelp.text", "note": "UNSjU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 400, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936480/?format=api", "priority": 100, "id": 1945029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=9ad011fdec15d9ad", "url": "https://translations.documentfoundation.org/api/units/1945029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.522480Z" } ] }