Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=5
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=6", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=4", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/?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>ŝovi kaj demeti; referenci ĉelojn</bookmark_value> <bookmark_value>ĉelojn; referenci per ŝovo kaj demeto</bookmark_value> <bookmark_value>referencojn;enmeti per ŝovo kaj demeto</bookmark_value> <bookmark_value>enmeti;referencojn, per ŝovo kaj demeto</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": 1955424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2da36fdd884d163f", "url": "https://translations.documentfoundation.org/api/units/1955424/?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/eo/?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": [ "En la helpo de la Navigilo, vi povas referenci ĉelojn en iu folio al alia en la sama dokumento aŭ en malsama dokumento. La ĉeloj estas enmeteblaj kiel kopio, ligilo, aŭ hiperligilo. Necesas agordi la ĉelaron enmetotan per nomo en la origina dosiero por ke ĝi estu enmetebla en la cela dosiero." ], "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": 1955426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=7139101fbd4a9470", "url": "https://translations.documentfoundation.org/api/units/1955426/?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/eo/?format=api", "source": [ "Open the document that contains the source cells." ], "previous_source": "", "target": [ "Malfermu la dokumenton kiu enhavas la fontajn ĉelojn." ], "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": 1955427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=f6793baab66edc97", "url": "https://translations.documentfoundation.org/api/units/1955427/?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/eo/?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": [ "Por agordi la fontan ĉelaron esti la amplekso, elektu la ĉelojn kaj elektu je <emph>Folio - Nomitaj ampleksoj kaj esprimoj - Agordi</emph>. Konservi la fontan dokumenton, kaj ne fermu ĝin." ], "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": 1955428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=bed03ecc1ef0f22b", "url": "https://translations.documentfoundation.org/api/units/1955428/?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/eo/?format=api", "source": [ "Open the sheet in which you want to insert something." ], "previous_source": "", "target": [ "" ], "id_hash": -5193122400437830357, "content_hash": -5193122400437830357, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3151073\nhelp.text", "note": "UMVry", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=37ee52b0eec77d2b", "url": "https://translations.documentfoundation.org/api/units/1955429/?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/eo/?format=api", "source": [ "In the Navigator, the source file object appears under \"Range names\"." ], "previous_source": "", "target": [ "" ], "id_hash": 5453365853304296294, "content_hash": 5453365853304296294, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3150752\nhelp.text", "note": "36bq3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=cbae3f59b4729366", "url": "https://translations.documentfoundation.org/api/units/1955431/?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/eo/?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": [ "" ], "id_hash": 8610010747941911183, "content_hash": 8610010747941911183, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154754\nhelp.text", "note": "FAErG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=f77ce7284f5f7a8f", "url": "https://translations.documentfoundation.org/api/units/1955432/?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/eo/?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": [ "" ], "id_hash": 230719825451888764, "content_hash": 230719825451888764, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3154256\nhelp.text", "note": "Thq7N", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=8333ae7576b3307c", "url": "https://translations.documentfoundation.org/api/units/1955433/?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/eo/?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": [ "" ], "id_hash": -7443407704774671154, "content_hash": -7443407704774671154, "location": "cellreference_dragdrop.xhp", "context": "cellreference_dragdrop.xhp\npar_id3149565\nhelp.text", "note": "GK9kZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=18b3b4211e8004ce", "url": "https://translations.documentfoundation.org/api/units/1955434/?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/eo/?format=api", "source": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "previous_source": "", "target": [ "" ], "id_hash": -8607370243769690863, "content_hash": -8607370243769690863, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9663075\nhelp.text", "note": "S3C6m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=088c7a5df9d71511", "url": "https://translations.documentfoundation.org/api/units/1955438/?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/eo/?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": [ "" ], "id_hash": -2429795404084310918, "content_hash": -2429795404084310918, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id1879329\nhelp.text", "note": "guASx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5e47a1f41ead8c7a", "url": "https://translations.documentfoundation.org/api/units/1955439/?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/eo/?format=api", "source": [ "To Reference a Cell in the Same Document" ], "previous_source": "", "target": [ "" ], "id_hash": -8036396515988521485, "content_hash": -8036396515988521485, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id7122409\nhelp.text", "note": "miL8J", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=1078fbf286513df3", "url": "https://translations.documentfoundation.org/api/units/1955440/?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/eo/?format=api", "source": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "previous_source": "", "target": [ "" ], "id_hash": -3303896142266824515, "content_hash": -3303896142266824515, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id4943693\nhelp.text", "note": "paXnm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=522633f6a16708bd", "url": "https://translations.documentfoundation.org/api/units/1955442/?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/eo/?format=api", "source": [ "<item type=\"literal\">=Sheet2.A1</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 8487635637370999137, "content_hash": 8487635637370999137, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id9064302\nhelp.text", "note": "2HPD8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=f5ca23a48c71d161", "url": "https://translations.documentfoundation.org/api/units/1955443/?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/eo/?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": [ "" ], "id_hash": -2577446353386241861, "content_hash": -2577446353386241861, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7609790\nhelp.text", "note": "zwUqn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5c3b12328ec980bb", "url": "https://translations.documentfoundation.org/api/units/1955444/?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/eo/?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": [ "" ], "id_hash": 1625573124372639045, "content_hash": 1625573124372639045, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id809961\nhelp.text", "note": "PYRuC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=968f3224daa72d45", "url": "https://translations.documentfoundation.org/api/units/1955445/?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/eo/?format=api", "source": [ "To Reference a Cell in Another Document" ], "previous_source": "", "target": [ "" ], "id_hash": -8988584149462720279, "content_hash": -8988584149462720279, "location": "cellreferences.xhp", "context": "cellreferences.xhp\nhd_id9209570\nhelp.text", "note": "mK8vG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=03422256f19160e9", "url": "https://translations.documentfoundation.org/api/units/1955446/?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/eo/?format=api", "source": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -146034786211442772, "content_hash": -146034786211442772, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id5949278\nhelp.text", "note": "hRAmo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=7df92e22bb044fac", "url": "https://translations.documentfoundation.org/api/units/1955447/?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/eo/?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": [ "" ], "id_hash": 8075084161029904148, "content_hash": 8075084161029904148, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8001953\nhelp.text", "note": "XywAr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=f0107642c5921714", "url": "https://translations.documentfoundation.org/api/units/1955448/?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/eo/?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": [ "" ], "id_hash": -6970258483961703397, "content_hash": -6970258483961703397, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8571123\nhelp.text", "note": "BrDJf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=1f44aad6becf541b", "url": "https://translations.documentfoundation.org/api/units/1955449/?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/eo/?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": [ "" ], "id_hash": 6930991381245622366, "content_hash": 6930991381245622366, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id8261665\nhelp.text", "note": "rCxaG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e02fd3f07470785e", "url": "https://translations.documentfoundation.org/api/units/1955450/?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/eo/?format=api", "source": [ "Confirm the formula by clicking the green check mark." ], "previous_source": "", "target": [ "" ], "id_hash": -7075107501787663034, "content_hash": -7075107501787663034, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7697683\nhelp.text", "note": "ACCDQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=1dd02b36703eb546", "url": "https://translations.documentfoundation.org/api/units/1955452/?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/eo/?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": [ "" ], "id_hash": 7445518397165399414, "content_hash": 7445518397165399414, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\nbm_id3150441\nhelp.text", "note": "7ELAq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e753cb88bfaded76", "url": "https://translations.documentfoundation.org/api/units/1955456/?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/eo/?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": [ "" ], "id_hash": -5481595565578359873, "content_hash": -5481595565578359873, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id1955626\nhelp.text", "note": "VHDGU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=33ed75e037586bbf", "url": "https://translations.documentfoundation.org/api/units/1955458/?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/eo/?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": [ "" ], "id_hash": -8747435212634940298, "content_hash": -8747435212634940298, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152993\nhelp.text", "note": "2MWuc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=069ade051f269c76", "url": "https://translations.documentfoundation.org/api/units/1955459/?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/eo/?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": [ "" ], "id_hash": -5817784293971594154, "content_hash": -5817784293971594154, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152892\nhelp.text", "note": "EQzxX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2f43140231f9f456", "url": "https://translations.documentfoundation.org/api/units/1955461/?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/eo/?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": [ "" ], "id_hash": 2696750813408066630, "content_hash": 2696750813408066630, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153068\nhelp.text", "note": "ZVqcc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=a56cc893a8eefc46", "url": "https://translations.documentfoundation.org/api/units/1955462/?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/eo/?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": [ "" ], "id_hash": -6590297703472980074, "content_hash": -6590297703472980074, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3153914\nhelp.text", "note": "xzgJv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=248a8f27d46b9f96", "url": "https://translations.documentfoundation.org/api/units/1955463/?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/eo/?format=api", "source": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "previous_source": "", "target": [ "" ], "id_hash": 2106220966743135416, "content_hash": 2106220966743135416, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3157979\nhelp.text", "note": "BQaFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=9d3acccf5d3454b8", "url": "https://translations.documentfoundation.org/api/units/1955464/?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/eo/?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": [ "" ], "id_hash": -4663235078393552702, "content_hash": -4663235078393552702, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3144768\nhelp.text", "note": "LAC7R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=3f48dc67303620c2", "url": "https://translations.documentfoundation.org/api/units/1955465/?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/eo/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "" ], "id_hash": -3609957716354299150, "content_hash": -3609957716354299150, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\ntit\nhelp.text", "note": "4DFzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/1955467/?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/eo/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/1955468/?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/eo/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/1955470/?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/eo/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/1955471/?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/eo/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/1955472/?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/eo/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/1955473/?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/eo/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/1955474/?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/eo/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/1955475/?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/eo/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/1955476/?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/eo/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/1955477/?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/eo/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 1955479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/1955479/?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/eo/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Elektu je <item type=\"menuitem\">Formato - Ĉeloj</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": 1955480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/1955480/?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/eo/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "" ], "id_hash": 4878667856389839357, "content_hash": 4878667856389839357, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\ntit\nhelp.text", "note": "smBjq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/1955481/?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/eo/?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": [ "" ], "id_hash": -279766961116655222, "content_hash": -279766961116655222, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nbm_id3149263\nhelp.text", "note": "3TV3y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/1955482/?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/eo/?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": 1955485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/1955485/?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/eo/?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": 1955486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/1955486/?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/eo/?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": 1955487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/1955487/?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/eo/?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": 1955488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/1955488/?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/eo/?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": 1955491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/1955491/?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/eo/?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": 1955492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/1955492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.721667Z" } ] }