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=5
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/units/?format=api&page=6", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/units/?format=api&page=4", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>drag and drop; referencing cells</bookmark_value> <bookmark_value>cells; referencing by drag and drop </bookmark_value> <bookmark_value>references;inserting by drag and drop</bookmark_value> <bookmark_value>inserting;references, by drag and drop</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>přetažení; odkazování na buňky</bookmark_value> <bookmark_value>buňky; odkazování přetažením</bookmark_value> <bookmark_value>odkazy;vkládání přetažením</bookmark_value> <bookmark_value>vkládání;odkazy přetažením</bookmark_value>" ], "id_hash": -5934776886678972865, "content_hash": -5934776886678972865, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\nbm_id3154686\nhelp.text", "note": "DN7Zz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24936139/?format=api", "priority": 100, "id": 1944900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2da36fdd884d163f", "url": "https://translations.documentfoundation.org/api/units/1944900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.815872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "With the help of the Navigator you can reference cells from one sheet to another sheet in the same document or in a different document. The cells can be inserted as a copy, link, or hyperlink. The range to be inserted must be defined with a name in the original file so that it can be inserted in the target file." ], "previous_source": "", "target": [ "Pomocí Navigátoru lze na buňky odkazovat z jednoho listu do dalšího, a to ve stejném nebo v různých dokumentech. Buňky mohou být vloženy jako kopie, odkaz nebo hypertextový odkaz. Aby mohla být oblast vložena do cílového souboru, musí mít v původním souboru určen název." ], "id_hash": -1064802108390599568, "content_hash": -1064802108390599568, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3156444\nhelp.text", "note": "ANUwC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/24936141/?format=api", "priority": 100, "id": 1944902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=7139101fbd4a9470", "url": "https://translations.documentfoundation.org/api/units/1944902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.848020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Open the document that contains the source cells." ], "previous_source": "", "target": [ "Otevřete dokument obsahující zdrojové buňky." ], "id_hash": 8536920173048683671, "content_hash": 8536920173048683671, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3152576\nhelp.text", "note": "eV8oB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936142/?format=api", "priority": 100, "id": 1944903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=f6793baab66edc97", "url": "https://translations.documentfoundation.org/api/units/1944903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.863673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To set the source range as the range, select the cells and choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. Save the source document, and do not close it." ], "previous_source": "", "target": [ "Zdrojové buňky vyberte a přiřaďte jim název klepnutím na <emph>List - Pojmenované oblasti a výrazy</emph>. Uložte sešit a nezavírejte ho." ], "id_hash": 4526186671920706091, "content_hash": 4526186671920706091, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154011\nhelp.text", "note": "SFWrp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24936143/?format=api", "priority": 100, "id": 1944904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=bed03ecc1ef0f22b", "url": "https://translations.documentfoundation.org/api/units/1944904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.873763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Open the sheet in which you want to insert something." ], "previous_source": "", "target": [ "Otevřete sešit, kam chcete buňky vložit." ], "id_hash": -5193122400437830357, "content_hash": -5193122400437830357, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3151073\nhelp.text", "note": "UMVry", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936144/?format=api", "priority": 100, "id": 1944905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=37ee52b0eec77d2b", "url": "https://translations.documentfoundation.org/api/units/1944905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.885975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In the Navigator, the source file object appears under \"Range names\"." ], "previous_source": "", "target": [ "V části \"Názvy oblastí\" Navigátoru se objeví názvy ze zdrojového sešitu." ], "id_hash": 5453365853304296294, "content_hash": 5453365853304296294, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3150752\nhelp.text", "note": "36bq3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936146/?format=api", "priority": 100, "id": 1944907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=cbae3f59b4729366", "url": "https://translations.documentfoundation.org/api/units/1944907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.912706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Using the <emph>Drag Mode</emph> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy." ], "previous_source": "", "target": [ "V ikoně <emph>Způsob přetáhnutí</emph> v Navigátoru, nastavte, zda se má vytvořit kopie, propojení či hypertextový odkaz." ], "id_hash": 8610010747941911183, "content_hash": 8610010747941911183, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154754\nhelp.text", "note": "FAErG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936147/?format=api", "priority": 100, "id": 1944908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=f77ce7284f5f7a8f", "url": "https://translations.documentfoundation.org/api/units/1944908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.922470Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click the name under \"Range names\" in the Navigator, and drag into the cell of the current sheet where you want to insert the reference." ], "previous_source": "", "target": [ "Klepněte na název pod \"Názvy oblastí\" v Navigátoru a přetáhněte ho na místo, kam ho chcete vložit." ], "id_hash": 230719825451888764, "content_hash": 230719825451888764, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154256\nhelp.text", "note": "Thq7N", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24936148/?format=api", "priority": 100, "id": 1944909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=8333ae7576b3307c", "url": "https://translations.documentfoundation.org/api/units/1944909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.933537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "This method can also be used to insert a range from another sheet of the same document into the current sheet. Select the active document as source in step 4 above." ], "previous_source": "", "target": [ "Stejným způsobem je možné vložit buňky z jiného listu stejného dokumentu na aktuální list. V kroku čtyři vyberte Aktivní okno." ], "id_hash": -7443407704774671154, "content_hash": -7443407704774671154, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3149565\nhelp.text", "note": "GK9kZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936149/?format=api", "priority": 100, "id": 1944910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=18b3b4211e8004ce", "url": "https://translations.documentfoundation.org/api/units/1944910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:42.946385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "previous_source": "", "target": [ "V buňce listu je možné zobrazit odkaz na buňku v jiném listu." ], "id_hash": -8607370243769690863, "content_hash": -8607370243769690863, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9663075\nhelp.text", "note": "S3C6m", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936153/?format=api", "priority": 100, "id": 1944914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=088c7a5df9d71511", "url": "https://translations.documentfoundation.org/api/units/1944914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.000237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In the same way, a reference can also be made to a cell from another document provided that this document has already been saved as a file." ], "previous_source": "", "target": [ "Stejným způsobem můžete vytvořit odkaz na buňku v druhém dokumentu. Podmínkou je, aby druhý dokument už byl uložen jako soubor." ], "id_hash": -2429795404084310918, "content_hash": -2429795404084310918, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id1879329\nhelp.text", "note": "guASx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936154/?format=api", "priority": 100, "id": 1944915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5e47a1f41ead8c7a", "url": "https://translations.documentfoundation.org/api/units/1944915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.013487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To Reference a Cell in the Same Document" ], "previous_source": "", "target": [ "Vytvoření odkazu na buňku stejného dokumentu" ], "id_hash": -8036396515988521485, "content_hash": -8036396515988521485, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id7122409\nhelp.text", "note": "miL8J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936155/?format=api", "priority": 100, "id": 1944916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=1078fbf286513df3", "url": "https://translations.documentfoundation.org/api/units/1944916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.027676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "previous_source": "", "target": [ "Do buňky A1 na List1 zadejte vzorec:" ], "id_hash": -3303896142266824515, "content_hash": -3303896142266824515, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id4943693\nhelp.text", "note": "paXnm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936156/?format=api", "priority": 100, "id": 1944918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=522633f6a16708bd", "url": "https://translations.documentfoundation.org/api/units/1944918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.058388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<item type=\"literal\">=Sheet2.A1</item>" ], "previous_source": "", "target": [ "<item type=\"literal\">=List2.A1</item>" ], "id_hash": 8487635637370999137, "content_hash": 8487635637370999137, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9064302\nhelp.text", "note": "2HPD8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936157/?format=api", "priority": 100, "id": 1944919, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=f5ca23a48c71d161", "url": "https://translations.documentfoundation.org/api/units/1944919/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.071286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click the <emph>Sheet 2</emph> tab at the bottom of the spreadsheet. Set the cursor in cell A1 there and enter text or a number." ], "previous_source": "", "target": [ "Klepněte na kartu <emph>List2</emph> ve spodní části sešitu. Nastavte kurzor do buňky A1 a zadejte text nebo číslo." ], "id_hash": -2577446353386241861, "content_hash": -2577446353386241861, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7609790\nhelp.text", "note": "zwUqn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936158/?format=api", "priority": 100, "id": 1944920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=5c3b12328ec980bb", "url": "https://translations.documentfoundation.org/api/units/1944920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.082879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "If you switch back to Sheet1, you will see the same content in cell A1 there. If the contents of Sheet2.A1 change, then the contents of Sheet1.A1 also change." ], "previous_source": "", "target": [ "Přejdete-li zpět na List1, v buňce A1 se zobrazí tentýž obsah. Změní-li se obsah buňky A1 Listu2, změní se také obsah buňky A1 Listu1." ], "id_hash": 1625573124372639045, "content_hash": 1625573124372639045, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id809961\nhelp.text", "note": "PYRuC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936159/?format=api", "priority": 100, "id": 1944921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=968f3224daa72d45", "url": "https://translations.documentfoundation.org/api/units/1944921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.096323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To Reference a Cell in Another Document" ], "previous_source": "", "target": [ "Vytvoření odkazu na buňku jiného dokumentu" ], "id_hash": -8988584149462720279, "content_hash": -8988584149462720279, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id9209570\nhelp.text", "note": "mK8vG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936160/?format=api", "priority": 100, "id": 1944922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=03422256f19160e9", "url": "https://translations.documentfoundation.org/api/units/1944922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.108687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "previous_source": "", "target": [ "Zvolte <emph>Soubor - Otevřít</emph> pro otevření už existujícího sešitu." ], "id_hash": -146034786211442772, "content_hash": -146034786211442772, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id5949278\nhelp.text", "note": "hRAmo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936161/?format=api", "priority": 100, "id": 1944923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=7df92e22bb044fac", "url": "https://translations.documentfoundation.org/api/units/1944923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.122026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell where you want to insert the external data and enter an equals sign to indicate that you want to begin a formula." ], "previous_source": "", "target": [ "Pomocí <emph>Soubor - Nový</emph> založte nový sešit. Přesuňte kurzor na buňku, do níž chcete vložit externí data. Potom jako první znak napište rovnítko. Tím dáte najevo, že chcete vložit vzorec." ], "id_hash": 8075084161029904148, "content_hash": 8075084161029904148, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8001953\nhelp.text", "note": "XywAr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24936162/?format=api", "priority": 100, "id": 1944924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=f0107642c5921714", "url": "https://translations.documentfoundation.org/api/units/1944924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.135699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document." ], "previous_source": "", "target": [ "Nyní se přepněte do dokumentu, který byl před chvílí otevřen. Klepněte myší na buňku s údaji, které chcete do nového dokumentu vložit." ], "id_hash": -6970258483961703397, "content_hash": -6970258483961703397, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8571123\nhelp.text", "note": "BrDJf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936163/?format=api", "priority": 100, "id": 1944925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=1f44aad6becf541b", "url": "https://translations.documentfoundation.org/api/units/1944925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.149417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Switch back to the new spreadsheet. In the input line you will now see how $[officename] Calc has added the reference to the formula for you." ], "previous_source": "", "target": [ "Přepněte se zpět do nového sešitu. Ve vstupním řádku teď uvidíte, jak pro vás $[officename]·Calc·přidal do vzorce odkaz." ], "id_hash": 6930991381245622366, "content_hash": 6930991381245622366, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8261665\nhelp.text", "note": "rCxaG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936164/?format=api", "priority": 100, "id": 1944926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e02fd3f07470785e", "url": "https://translations.documentfoundation.org/api/units/1944926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.163892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Confirm the formula by clicking the green check mark." ], "previous_source": "", "target": [ "Klepnutím na ikonu se zelenou zaškrtávací značkou vzorec potvrdíte." ], "id_hash": -7075107501787663034, "content_hash": -7075107501787663034, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7697683\nhelp.text", "note": "ACCDQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936166/?format=api", "priority": 100, "id": 1944928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=1dd02b36703eb546", "url": "https://translations.documentfoundation.org/api/units/1944928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.192867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>HTML; in sheet cells</bookmark_value><bookmark_value>references; URL in cells</bookmark_value><bookmark_value>cells; Internet references</bookmark_value><bookmark_value>URL; in Calc</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HTML; v buňkách listu</bookmark_value><bookmark_value>odkazy; URL v buňkách</bookmark_value><bookmark_value>buňky; internetové odkazy</bookmark_value><bookmark_value>URL; v Calcu</bookmark_value>" ], "id_hash": 7445518397165399414, "content_hash": 7445518397165399414, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\nbm_id3150441\nhelp.text", "note": "7ELAq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936169/?format=api", "priority": 100, "id": 1944932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e753cb88bfaded76", "url": "https://translations.documentfoundation.org/api/units/1944932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.240294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "For example, if you found an Internet page containing current stock exchange information in spreadsheet cells, you can load this page in $[officename] Calc by using the following procedure:" ], "previous_source": "", "target": [ "Pokud například naleznete na internetu stránku, obsahující aktuální burzovní údaje v buňkách sešitu, můžete tuto stránku použít v programu $[officename] Calc pomocí následujícího postupu:" ], "id_hash": -5481595565578359873, "content_hash": -5481595565578359873, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id1955626\nhelp.text", "note": "VHDGU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24936171/?format=api", "priority": 100, "id": 1944934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=33ed75e037586bbf", "url": "https://translations.documentfoundation.org/api/units/1944934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.263588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data." ], "previous_source": "", "target": [ "V dokumentu $[officename] Calc nastavte kurzor do buňky, kam chcete načíst externí data." ], "id_hash": -8747435212634940298, "content_hash": -8747435212634940298, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152993\nhelp.text", "note": "2MWuc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936172/?format=api", "priority": 100, "id": 1944935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=069ade051f269c76", "url": "https://translations.documentfoundation.org/api/units/1944935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.277689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Enter the URL of the document or Web page in the dialog. The URL must be in the format: http://www.my-bank.com/table.html. The URL for local or local area network files is the path seen in the <item type=\"menuitem\">File - Open</item> dialog." ], "previous_source": "", "target": [ "V dialogovém okně zadejte URL dokumentu nebo webové stránky. URL musí být ve formátu: http://www.my-bank.com/table.html. Pro místní soubory a soubory v místní síti je URL cesta, která se objevuje v dialogovém okně <item type=\"menuitem\">Soubor - Otevřít</item>." ], "id_hash": -5817784293971594154, "content_hash": -5817784293971594154, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152892\nhelp.text", "note": "EQzxX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24936174/?format=api", "priority": 100, "id": 1944937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=2f43140231f9f456", "url": "https://translations.documentfoundation.org/api/units/1944937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.301090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "$[officename] loads the Web page or file in the \"background\", that is, without displaying it. In the large list box of the <item type=\"menuitem\">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from." ], "previous_source": "", "target": [ "$[officename] načte webovou stránku nebo soubor \"na pozadí\", tedy je nezobrazí. Ve větším seznamu v dialogu <item type=\"menuitem\">Externí data</item> se zobrazí názvy všech listů nebo pojmenovaných oblastí, ze kterých můžete vybírat." ], "id_hash": 2696750813408066630, "content_hash": 2696750813408066630, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153068\nhelp.text", "note": "ZVqcc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24936175/?format=api", "priority": 100, "id": 1944938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=a56cc893a8eefc46", "url": "https://translations.documentfoundation.org/api/units/1944938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.314843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select one or more sheets or named ranges. You can also activate the automatic update function every \"n\" seconds and click <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Vyberte jeden nebo několik listů nebo pojmenovaných oblastí. Můžete také zapnout automatické aktualizace každých \"n\" sekund. Klepněte na <item type=\"menuitem\">OK</item>." ], "id_hash": -6590297703472980074, "content_hash": -6590297703472980074, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153914\nhelp.text", "note": "xzgJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24936176/?format=api", "priority": 100, "id": 1944939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=248a8f27d46b9f96", "url": "https://translations.documentfoundation.org/api/units/1944939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.328272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "previous_source": "", "target": [ "Obsah bude jako odkaz vložen do dokumentu $[officename] Calc." ], "id_hash": 2106220966743135416, "content_hash": 2106220966743135416, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3157979\nhelp.text", "note": "BQaFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936177/?format=api", "priority": 100, "id": 1944940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=9d3acccf5d3454b8", "url": "https://translations.documentfoundation.org/api/units/1944940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.341261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry." ], "previous_source": "", "target": [ "Sešit uložte. Když ho později opět otevřete, $[officename] Calc po dotazu zaktualizuje propojené buňky." ], "id_hash": -4663235078393552702, "content_hash": -4663235078393552702, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3144768\nhelp.text", "note": "LAC7R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 301, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936178/?format=api", "priority": 100, "id": 1944941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=3f48dc67303620c2", "url": "https://translations.documentfoundation.org/api/units/1944941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.354222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Přiřazení formátu pomocí vzorce" ], "id_hash": -3609957716354299150, "content_hash": -3609957716354299150, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\ntit\nhelp.text", "note": "4DFzJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 303, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936180/?format=api", "priority": 100, "id": 1944943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/1944943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.380384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>formats; assigning by formulas</bookmark_value> <bookmark_value>cell formats; assigning by formulas</bookmark_value> <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulas</bookmark_value> <bookmark_value>formulas;assigning cell formats</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>formáty; přiřazení vzorci</bookmark_value><bookmark_value>formáty buňky; přiřazení vzorci</bookmark_value><bookmark_value>příklad pro funkci STYLE</bookmark_value><bookmark_value>styly buněk;přiřazení vzorci</bookmark_value><bookmark_value>vzorce;přiřazení formátů buněk</bookmark_value>" ], "id_hash": 164411229929034979, "content_hash": 164411229929034979, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\nbm_id3145673\nhelp.text", "note": "ewC9e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936181/?format=api", "priority": 100, "id": 1944944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/1944944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.392404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; \"Red\"; \"Green\")) applies the cell style \"Red\" to cells if the value is greater than 3, otherwise the cell style \"Green\" is applied." ], "previous_source": "", "target": [ "Funkce STYLE() může být přidána ke stávajícímu vzorci v buňce. Můžete například ve spojení s funkcí CURRENT obarvit buňku podle její hodnoty. Vzorec =...+STYLE(IF(CURRENT()>3; \"Červená\"; \"Zelená\")) nastaví buňce styl \"Červená\", pokud je její hodnota větší než 3, v opačném případě bude použit styl \"Zelená\"." ], "id_hash": 3545701820741360435, "content_hash": 3545701820741360435, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150275\nhelp.text", "note": "EzSnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 306, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/24936397/?format=api", "priority": 100, "id": 1944946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/1944946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.419259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "If you would like to apply a formula to all cells in a selected area, you can use the <item type=\"menuitem\">Find & Replace</item> dialog." ], "previous_source": "", "target": [ "Chcete-li použít vzorec pro všechny buňky ve vybrané oblasti, můžete použít dialogové okno <item type=\"menuitem\">Najít a nahradit</item>." ], "id_hash": 4662496989831300287, "content_hash": 4662496989831300287, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3151385\nhelp.text", "note": "bMcgv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936398/?format=api", "priority": 100, "id": 1944947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/1944947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.433666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Označte všechny požadované buňky jako blok." ], "id_hash": -7915414649820688558, "content_hash": -7915414649820688558, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149456\nhelp.text", "note": "qAH7F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 308, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936399/?format=api", "priority": 100, "id": 1944948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/1944948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.446095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Vyberte v nabídce příkaz <emph>Úpravy - Najít a nahradit</emph>." ], "id_hash": -3871256957612398730, "content_hash": -3871256957612398730, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3148797\nhelp.text", "note": "FyUDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936400/?format=api", "priority": 100, "id": 1944949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/1944949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.458023Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "Do pole <item type=\"menuitem\">Najít</item> zadejte: .<item type=\"literal\">*</item>" ], "id_hash": -3542223392916196599, "content_hash": -3542223392916196599, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150767\nhelp.text", "note": "STxmA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936401/?format=api", "priority": 100, "id": 1944950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/1944950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.473057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" je regulární výraz znamenající obsah aktuální buňky." ], "id_hash": 2250458990697445731, "content_hash": 2250458990697445731, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153770\nhelp.text", "note": "EN8wF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 311, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936402/?format=api", "priority": 100, "id": 1944951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/1944951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.486835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Enter the following formula in the <item type=\"menuitem\">Replace</item> field: <item type=\"literal\">=&+STYLE(IF(CURRENT()>3;\"Red\";\"Green\"))</item>" ], "previous_source": "", "target": [ "Zadejte následující vzorec do pole <item type=\"menuitem\">Nahradit</item>: <item type=\"literal\">=&+STYLE(IF(CURRENT()>3;\"Červená\";\"Zelená\"))</item>" ], "id_hash": 7564866201628513913, "content_hash": 7564866201628513913, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153143\nhelp.text", "note": "r8m3j", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936403/?format=api", "priority": 100, "id": 1944952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/1944952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.499475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "The \"&\" symbol designates the current contents of the <emph>Find</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles \"Red\" and \"Green\" already exist." ], "previous_source": "", "target": [ "Znak \"&\" zastupuje obsah pole <emph>Najít</emph>. Řádek musí začínat rovnítkem, protože je to vzorec. Předpokládáme, že styly buňky \"Červená\" a \"Zelená\" existují." ], "id_hash": 2301038259609661742, "content_hash": 2301038259609661742, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3146975\nhelp.text", "note": "prHDb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24936404/?format=api", "priority": 100, "id": 1944953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/1944953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.512606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Všechny buňky s obsahem ve vybrané oblasti se zvýrazní." ], "id_hash": 8123534687943202457, "content_hash": 8123534687943202457, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3144767\nhelp.text", "note": "A3CBV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24936406/?format=api", "priority": 100, "id": 1944955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/1944955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.539435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Klepněte na <item type=\"menuitem\">Nahradit vše</item>." ], "id_hash": 6497422687296759040, "content_hash": 6497422687296759040, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3147127\nhelp.text", "note": "CxKWs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936407/?format=api", "priority": 100, "id": 1944956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/1944956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.552578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Použití podmíněného formátování" ], "id_hash": 4878667856389839357, "content_hash": 4878667856389839357, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\ntit\nhelp.text", "note": "smBjq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936408/?format=api", "priority": 100, "id": 1944957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/1944957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.566534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "<bookmark_value>conditional formatting; cells</bookmark_value> <bookmark_value>cells; conditional formatting</bookmark_value> <bookmark_value>formatting; conditional formatting</bookmark_value> <bookmark_value>styles;conditional styles</bookmark_value> <bookmark_value>cell formats; conditional</bookmark_value> <bookmark_value>random numbers;examples</bookmark_value> <bookmark_value>cell styles; copying</bookmark_value> <bookmark_value>copying; cell styles</bookmark_value> <bookmark_value>tables; copying cell styles</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>podmíněné formátování; buňky</bookmark_value> <bookmark_value>buňky; podmíněné formátování</bookmark_value> <bookmark_value>formátování; podmíněné formátování</bookmark_value> <bookmark_value>styly;podmíněné styly</bookmark_value> <bookmark_value>formáty buňky; podmíněné</bookmark_value> <bookmark_value>náhodná čísla;příklady</bookmark_value> <bookmark_value>styly buněk; kopírování</bookmark_value> <bookmark_value>kopírování; styly buněk</bookmark_value> <bookmark_value>tabulky; kopírování stylů buněk</bookmark_value>" ], "id_hash": -279766961116655222, "content_hash": -279766961116655222, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nbm_id3149263\nhelp.text", "note": "3TV3y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936409/?format=api", "priority": 100, "id": 1944958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/1944958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.579995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled)." ], "previous_source": "", "target": [ "Aby podmíněné formátování fungovalo, musí být povolena funkce Automatický výpočet. Zvolte <emph>Data - Spočítat - Automatický výpočet</emph> (pokud je funkce povolena, uvidíte vedle příkazu značku zaškrtnutí)." ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 321, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936412/?format=api", "priority": 100, "id": 1944961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/1944961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.623012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually." ], "previous_source": "", "target": [ "Pomocí podmíněného formátování je možné například zvýraznit součty, které přesáhnou průměr ostatních součtů. Změní-li se součty, je formát automaticky změněn též, bez nutnosti měnit formátování ručně." ], "id_hash": 3980182931444228703, "content_hash": 3980182931444228703, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154944\nhelp.text", "note": "Yy9Z2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 322, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936413/?format=api", "priority": 100, "id": 1944962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/1944962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.636466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "Definování podmínek" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936414/?format=api", "priority": 100, "id": 1944963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/1944963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.648901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Vyberte buňky, u nichž chcete použít podmíněný styl." ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936415/?format=api", "priority": 100, "id": 1944964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/1944964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.660802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Příklad podmíněného formátování: zvýraznění součtů vyšších/nižších než průměrná hodnota" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 327, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936418/?format=api", "priority": 100, "id": 1944967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/1944967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.706567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/cs/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Krok 1: Generování náhodných hodnot" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936419/?format=api", "priority": 100, "id": 1944968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/cs/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/1944968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.721667Z" } ] }