Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=5
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=6", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=4", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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>arrastrar e soltar; referenciar celas</bookmark_value> <bookmark_value>celas; referenciar arrastrando e soltando </bookmark_value> <bookmark_value>referencias;inserir arrastrando e soltando </bookmark_value> <bookmark_value>inserir;referencias, arrastrando e soltando</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": 1963209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2da36fdd884d163f", "url": "https://translations.documentfoundation.org/api/units/1963209/?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/gl/?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": [ "Coa axuda do Navegador pódese referenciar celas dunha folla noutra do mesmo documento ou dun documento diferente. As celas pódense inserir como copia, ligazón ou hiperligazón. O intervalo a inserir pódese definir cun nome no ficheiro orixinal para podelo inserir no ficheiro de destino." ], "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": 1963211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=7139101fbd4a9470", "url": "https://translations.documentfoundation.org/api/units/1963211/?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/gl/?format=api", "source": [ "Open the document that contains the source cells." ], "previous_source": "", "target": [ "Abra o documento que contén as celas de orixe." ], "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": 1963212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f6793baab66edc97", "url": "https://translations.documentfoundation.org/api/units/1963212/?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/gl/?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": [ "Para definir o intervalo de orixe como o intervalo, seleccione as celas e escolla <emph>Folla - Intervalos e expresións con nome - Definir</emph>. Grave o documento de orixe e non o peche." ], "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": 1963213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=bed03ecc1ef0f22b", "url": "https://translations.documentfoundation.org/api/units/1963213/?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/gl/?format=api", "source": [ "Open the sheet in which you want to insert something." ], "previous_source": "", "target": [ "Abra a folla na que desexe inserir algo." ], "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": 1963214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=37ee52b0eec77d2b", "url": "https://translations.documentfoundation.org/api/units/1963214/?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/gl/?format=api", "source": [ "In the Navigator, the source file object appears under \"Range names\"." ], "previous_source": "", "target": [ "No Navegador, o obxecto do ficheiro de orixe aparece en «Nomes de intervalos»." ], "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": 1963216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=cbae3f59b4729366", "url": "https://translations.documentfoundation.org/api/units/1963216/?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/gl/?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": [ "Empregando a icona <emph>Modo de arrastre</emph> no Navegador, escolla se desexa que a referencia sexa unha hiperligazón, unha ligazón ou unha copia." ], "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": 1963217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f77ce7284f5f7a8f", "url": "https://translations.documentfoundation.org/api/units/1963217/?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/gl/?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": [ "Prema no nome en «Intervalos de nomes» no Navegador e arrástreo para a cela da folla actual na que desexa inserir a referencia." ], "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": 1963218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=8333ae7576b3307c", "url": "https://translations.documentfoundation.org/api/units/1963218/?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/gl/?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": [ "Tamén é posíbel usar este método para inserir un intervalo desde outra folla do mesmo documento na folla actual. Seleccione o documento activo como fonte no paso 4 de arriba." ], "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": 1963219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=18b3b4211e8004ce", "url": "https://translations.documentfoundation.org/api/units/1963219/?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/gl/?format=api", "source": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "previous_source": "", "target": [ "Nunha cela dunha folla pode mostrar unha referencia a unha cela doutra folla." ], "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": 1963223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=088c7a5df9d71511", "url": "https://translations.documentfoundation.org/api/units/1963223/?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/gl/?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": [ "Da mesma maneira, pódese facer unha referencia a unha cela desde outro documento sempre que ese documento xa fose gardado nun ficheiro." ], "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": 1963224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5e47a1f41ead8c7a", "url": "https://translations.documentfoundation.org/api/units/1963224/?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/gl/?format=api", "source": [ "To Reference a Cell in the Same Document" ], "previous_source": "", "target": [ "Para referenciar unha cela do mesmo documento" ], "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": 1963225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=1078fbf286513df3", "url": "https://translations.documentfoundation.org/api/units/1963225/?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/gl/?format=api", "source": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "previous_source": "", "target": [ "Como exemplo, introduza a fórmula seguinte na folla A1 da Folla1:" ], "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": 1963227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=522633f6a16708bd", "url": "https://translations.documentfoundation.org/api/units/1963227/?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/gl/?format=api", "source": [ "<item type=\"literal\">=Sheet2.A1</item>" ], "previous_source": "", "target": [ "<item type=\"literal\">=Folla2.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": 1963228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f5ca23a48c71d161", "url": "https://translations.documentfoundation.org/api/units/1963228/?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/gl/?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": [ "Prema na lapela <emph>Folla 2</emph> da parte inferior da folla de cálculo. Coloque o cursor na cela A1 e introduza un texto ou número." ], "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": 1963229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5c3b12328ec980bb", "url": "https://translations.documentfoundation.org/api/units/1963229/?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/gl/?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": [ "Se volve para a Folla1, verá o mesmo contido na cela A1. Se o contido de Folla2A1 cambia, o contido de Folla1.A1 tamén cambia." ], "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": 1963230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=968f3224daa72d45", "url": "https://translations.documentfoundation.org/api/units/1963230/?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/gl/?format=api", "source": [ "To Reference a Cell in Another Document" ], "previous_source": "", "target": [ "Para referenciar unha cela doutro documento" ], "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": 1963231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=03422256f19160e9", "url": "https://translations.documentfoundation.org/api/units/1963231/?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/gl/?format=api", "source": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "previous_source": "", "target": [ "Escolla <emph>Ficheiro - Abrir</emph> para cargar un documento de folla de cálculo existente." ], "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": 1963232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=7df92e22bb044fac", "url": "https://translations.documentfoundation.org/api/units/1963232/?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/gl/?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": [ "Escolla <emph>Ficheiro - Novo</emph>, para abrir un documento de folla de cálculo novo. Coloque o cursor na cela na que desexe inserir os datos externos e introduza un símbolo de igual para indicar que desexa comezar unha fórmula." ], "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": 1963233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f0107642c5921714", "url": "https://translations.documentfoundation.org/api/units/1963233/?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/gl/?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": [ "Pase entón ao documento que acaba de cargar. Prema na cela cos datos que desexa inserir no novo documento." ], "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": 1963234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=1f44aad6becf541b", "url": "https://translations.documentfoundation.org/api/units/1963234/?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/gl/?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": [ "Volva de novo para a folla de cálculo nova. Na liña de entrada verá que o Calc do $[officename] xa engadiu a referencia á fórmula." ], "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": 1963235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e02fd3f07470785e", "url": "https://translations.documentfoundation.org/api/units/1963235/?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/gl/?format=api", "source": [ "Confirm the formula by clicking the green check mark." ], "previous_source": "", "target": [ "Confirme a fórmula premendo na marca de comprobación verde." ], "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": 1963237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=1dd02b36703eb546", "url": "https://translations.documentfoundation.org/api/units/1963237/?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/gl/?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; en celas de follas</bookmark_value><bookmark_value>referencias; URL en celas</bookmark_value><bookmark_value>celas; referencias da Internet </bookmark_value><bookmark_value>URL; no Calc</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": 1963241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e753cb88bfaded76", "url": "https://translations.documentfoundation.org/api/units/1963241/?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/gl/?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": [ "Por exemplo, se atopa unha páxina en Internet que conteña información de bolsa en celas de folla de cálculo, pode cargar esta páxina no Calc do $[officename] empregando o procedemento seguinte:" ], "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": 1963243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=33ed75e037586bbf", "url": "https://translations.documentfoundation.org/api/units/1963243/?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/gl/?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": [ "Nun documento do Calc do $[officename], coloque o cursor na cela na que desexe inserir os datos externos." ], "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": 1963244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=069ade051f269c76", "url": "https://translations.documentfoundation.org/api/units/1963244/?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/gl/?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": [ "Introduza o URL do documento ou páxina web na caixa de diálogo. O URL debe ter o formato: http:///www.o-meu-banco.gal/táboa.html. O URL dos ficheiros locais ou da rede local está na ruta que ve a caixa de diálogo <item type=\"menuitem\">Ficheiro - Abrir</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": 1963246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2f43140231f9f456", "url": "https://translations.documentfoundation.org/api/units/1963246/?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/gl/?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": [ "O $[officename] carga a páxina web ou ficheiro «no fondo», ou sexa, sen mostrar o proceso. Na extensa lista da caixa de diálogo <item type=\"menuitem\">Datos externos</item> pódese ver o nome de todas as follas ou intervalos con nome que se poden escoller." ], "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": 1963247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a56cc893a8eefc46", "url": "https://translations.documentfoundation.org/api/units/1963247/?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/gl/?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": [ "Seleccione unha ou máis follas ou intervalos con nome. Tamén pode activar a función de actualización automática cada «n» segundos e premer en <item type=\"menuitem\">Aceptar</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": 1963248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=248a8f27d46b9f96", "url": "https://translations.documentfoundation.org/api/units/1963248/?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/gl/?format=api", "source": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "previous_source": "", "target": [ "O contido insírese como ligazón no documento do Calc do $[officename]." ], "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": 1963249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9d3acccf5d3454b8", "url": "https://translations.documentfoundation.org/api/units/1963249/?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/gl/?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": [ "Garde a folla de cálculo. Cando o abra máis tarde, o Calc do $[officename] actualizará as celas ligadas despois dunha consulta." ], "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": 1963250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3f48dc67303620c2", "url": "https://translations.documentfoundation.org/api/units/1963250/?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/gl/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Asignar formatos por fórmula" ], "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": 1963252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/1963252/?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/gl/?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>formatos; asignar por fórmulas</bookmark_value> <bookmark_value>formatos de cela; asignar por fórmulas</bookmark_value> <bookmark_value>exemplo da función ESTILO</bookmark_value> <bookmark_value>estilos de cela; asignar por fórmulas</bookmark_value> <bookmark_value>fórmulas;asignar formatos de cela</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": 1963253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/1963253/?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/gl/?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": [ "Pódese engadir a función ESTILO() a unha fórmula existente nunha cela. Por exemplo, xunto coa función ACTUAL é posíbel colorar unha cela dependendo do seu valor. A fórmula =...+ESTILO(SE(ACTUAL()>3; \"Vermello\"; \"Verde\")) aplica o estilo de cela «Vermello» ás celas se o valor é maior de 3 e, se non, aplica o estilo de cela «Verde»." ], "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": 1963255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/1963255/?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/gl/?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": [ "Se desexa aplicar unha fórmula a todas as celas dunha área seleccionada pode empregar a caixa de diálogo <item type=\"menuitem\">Atopar e substituír</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": 1963257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/1963257/?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/gl/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Seleccione todas as celas desexadas." ], "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": 1963258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/1963258/?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/gl/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Seleccione a orde do menú <emph>Editar - Atopar e substituír</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": 1963259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/1963259/?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/gl/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "No termo <item type=\"menuitem\">Atopar</item>, introduza: .<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": 1963260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/1963260/?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/gl/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" é unha expresión regular que designa o contido da cela actual." ], "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": 1963261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/1963261/?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/gl/?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": [ "Introduza a fórmula seguinte no campo <item type=\"menuitem\">Substituír</item>: <item type=\"literal\">=&+ESTILO(SE(ACTUAL()3;\"Vermello\";\"Verde\"))</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": 1963262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/1963262/?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/gl/?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": [ "O símbolo «&» designa o contido actual do campo <emph>Atopar</emph>. A liña debe comezar cun signo de igual, dado que se trata dunha fórmula. Asúmese que os estilos de cela «Vermello» e «Verde» xa existen." ], "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": 1963263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/1963263/?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/gl/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Todas as celas con contido que se incluíse na selección aparecerán realzadas." ], "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": 1963265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/1963265/?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/gl/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Prema en <item type=\"menuitem\">Substituír todo</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": 1963266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/1963266/?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/gl/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Aplicar formato condicional" ], "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": 1963267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/1963267/?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/gl/?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>formato condicional; celas</bookmark_value> <bookmark_value>celas; formato condicional</bookmark_value> <bookmark_value>formato; formato condicional</bookmark_value> <bookmark_value>estilos;estilos condicionais</bookmark_value> <bookmark_value>formatos de cela; condicional</bookmark_value> <bookmark_value>números aleatorios;exemplos</bookmark_value> <bookmark_value>estilos de cela; copiar</bookmark_value> <bookmark_value>copiar; estilos de cela</bookmark_value> <bookmark_value>táboas; copiar estilos de cela</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": 1963268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/1963268/?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/gl/?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": [ "" ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/1963271/?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/gl/?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": [ "" ], "id_hash": 3980182931444228703, "content_hash": 3980182931444228703, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154944\nhelp.text", "note": "Yy9Z2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/1963272/?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/gl/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/1963273/?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/gl/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "" ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/1963274/?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/gl/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/1963277/?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/gl/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/1963278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.721667Z" } ] }