Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=5
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=6", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=4", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?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>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>" ], "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": 1951954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2da36fdd884d163f", "url": "https://translations.documentfoundation.org/api/units/1951954/?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/en_GB/?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": [ "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." ], "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": 1951956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7139101fbd4a9470", "url": "https://translations.documentfoundation.org/api/units/1951956/?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/en_GB/?format=api", "source": [ "Open the document that contains the source cells." ], "previous_source": "", "target": [ "Open the document that contains the source cells." ], "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": 1951957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f6793baab66edc97", "url": "https://translations.documentfoundation.org/api/units/1951957/?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/en_GB/?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": [ "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." ], "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": 1951958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=bed03ecc1ef0f22b", "url": "https://translations.documentfoundation.org/api/units/1951958/?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/en_GB/?format=api", "source": [ "Open the sheet in which you want to insert something." ], "previous_source": "", "target": [ "Open the sheet in which you want to insert something." ], "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": 1951959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=37ee52b0eec77d2b", "url": "https://translations.documentfoundation.org/api/units/1951959/?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/en_GB/?format=api", "source": [ "In the Navigator, the source file object appears under \"Range names\"." ], "previous_source": "", "target": [ "In the Navigator, the source file object appears under \"Range names\"." ], "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": 1951961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cbae3f59b4729366", "url": "https://translations.documentfoundation.org/api/units/1951961/?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/en_GB/?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": [ "Using the <emph>Drag Mode</emph> icon in Navigator, choose whether you want the reference to be a hyperlink, link, or copy." ], "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": 1951962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f77ce7284f5f7a8f", "url": "https://translations.documentfoundation.org/api/units/1951962/?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/en_GB/?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": [ "Click the name under \"Range names\" in the Navigator, and drag into the cell of the current sheet into which you want to insert the reference." ], "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": 1951963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=8333ae7576b3307c", "url": "https://translations.documentfoundation.org/api/units/1951963/?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/en_GB/?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": [ "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." ], "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": 1951964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=18b3b4211e8004ce", "url": "https://translations.documentfoundation.org/api/units/1951964/?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/en_GB/?format=api", "source": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "previous_source": "", "target": [ "In a sheet cell you can show a reference to a cell in another sheet." ], "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": 1951968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=088c7a5df9d71511", "url": "https://translations.documentfoundation.org/api/units/1951968/?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/en_GB/?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": [ "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." ], "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": 1951969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5e47a1f41ead8c7a", "url": "https://translations.documentfoundation.org/api/units/1951969/?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/en_GB/?format=api", "source": [ "To Reference a Cell in the Same Document" ], "previous_source": "", "target": [ "To Reference a Cell in the Same Document" ], "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": 1951970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1078fbf286513df3", "url": "https://translations.documentfoundation.org/api/units/1951970/?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/en_GB/?format=api", "source": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "previous_source": "", "target": [ "By way of example, enter the following formula in cell A1 of Sheet1:" ], "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": 1951972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=522633f6a16708bd", "url": "https://translations.documentfoundation.org/api/units/1951972/?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/en_GB/?format=api", "source": [ "<item type=\"literal\">=Sheet2.A1</item>" ], "previous_source": "", "target": [ "<item type=\"literal\">=Sheet2.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": 1951975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f5ca23a48c71d161", "url": "https://translations.documentfoundation.org/api/units/1951975/?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/en_GB/?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": [ "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." ], "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": 1951977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5c3b12328ec980bb", "url": "https://translations.documentfoundation.org/api/units/1951977/?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/en_GB/?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": [ "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 changes." ], "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": 1951978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=968f3224daa72d45", "url": "https://translations.documentfoundation.org/api/units/1951978/?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/en_GB/?format=api", "source": [ "To Reference a Cell in Another Document" ], "previous_source": "", "target": [ "To Reference a Cell in Another Document" ], "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": 1951979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=03422256f19160e9", "url": "https://translations.documentfoundation.org/api/units/1951979/?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/en_GB/?format=api", "source": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "previous_source": "", "target": [ "Choose <emph>File - Open</emph>, to load an existing spreadsheet document." ], "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": 1951980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7df92e22bb044fac", "url": "https://translations.documentfoundation.org/api/units/1951980/?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/en_GB/?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": [ "Choose <emph>File - New</emph>, to open a new spreadsheet document. Set the cursor in the cell into which you want to insert the external data and enter an equals sign to indicate that you want to begin a formula." ], "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": 1951981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f0107642c5921714", "url": "https://translations.documentfoundation.org/api/units/1951981/?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/en_GB/?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": [ "Now switch to the document you have just loaded. Click the cell with the data that you want to insert in the new document." ], "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": 1951982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1f44aad6becf541b", "url": "https://translations.documentfoundation.org/api/units/1951982/?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/en_GB/?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": [ "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." ], "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": 1951984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e02fd3f07470785e", "url": "https://translations.documentfoundation.org/api/units/1951984/?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/en_GB/?format=api", "source": [ "Confirm the formula by clicking the green check mark." ], "previous_source": "", "target": [ "Confirm the formula by clicking the green tick mark." ], "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": 1951988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1dd02b36703eb546", "url": "https://translations.documentfoundation.org/api/units/1951988/?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/en_GB/?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; 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>" ], "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": 1951997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e753cb88bfaded76", "url": "https://translations.documentfoundation.org/api/units/1951997/?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/en_GB/?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": [ "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:" ], "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": 1952001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=33ed75e037586bbf", "url": "https://translations.documentfoundation.org/api/units/1952001/?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/en_GB/?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": [ "In a $[officename] Calc document, position the cursor in the cell into which you want to insert the external data." ], "id_hash": -8747435212634940298, "content_hash": -8747435212634940298, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3152993\nhelp.text", "note": "2MWuc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936172/?format=api", "priority": 100, "id": 1952003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=069ade051f269c76", "url": "https://translations.documentfoundation.org/api/units/1952003/?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/en_GB/?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": [ "Enter the URL of the document or Web page in the dialogue box. 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> dialogue box." ], "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": 1952011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2f43140231f9f456", "url": "https://translations.documentfoundation.org/api/units/1952011/?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/en_GB/?format=api", "source": [ "$[officename] loads the Web page or file in the \"background\", that is, without displaying it. In the large list box of the <item type=\"menuitem\">External Data</item> dialog, you can see the name of all the sheets or named ranges you can choose from." ], "previous_source": "", "target": [ "$[officename] 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> dialogue box, you can see the name of all the sheets or named ranges you can choose from." ], "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": 1952013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a56cc893a8eefc46", "url": "https://translations.documentfoundation.org/api/units/1952013/?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/en_GB/?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": [ "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>." ], "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": 1952015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=248a8f27d46b9f96", "url": "https://translations.documentfoundation.org/api/units/1952015/?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/en_GB/?format=api", "source": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "previous_source": "", "target": [ "The contents will be inserted as a link in the $[officename] Calc document." ], "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": 1952017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9d3acccf5d3454b8", "url": "https://translations.documentfoundation.org/api/units/1952017/?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/en_GB/?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": [ "Save your spreadsheet. When you open it again later, $[officename] Calc will update the linked cells following an inquiry." ], "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": 1952019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3f48dc67303620c2", "url": "https://translations.documentfoundation.org/api/units/1952019/?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/en_GB/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Assigning Formats by Formula" ], "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": 1952024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/1952024/?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/en_GB/?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>formats; assigning by formulae</bookmark_value> <bookmark_value>cell formats; assigning by formulae</bookmark_value> <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulae</bookmark_value> <bookmark_value>formulae;assigning cell formats</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": 1952026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/1952026/?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/en_GB/?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": [ "The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can colour 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." ], "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": 1952029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/1952029/?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/en_GB/?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": [ "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> dialogue box." ], "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": 1952032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/1952032/?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/en_GB/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Select all the desired cells." ], "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": 1952034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/1952034/?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/en_GB/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Select the menu command <emph>Edit - Find & Replace</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": 1952036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/1952036/?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/en_GB/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<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": 1952038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/1952038/?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/en_GB/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "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": 1952040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/1952040/?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/en_GB/?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": [ "Enter the following formula in the <item type=\"menuitem\">Replace</item> field: <item type=\"literal\">=&+STYLE(IF(CURRENT()>3;\"Red\";\"Green\"))</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": 1952042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/1952042/?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/en_GB/?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": [ "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." ], "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": 1952043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/1952043/?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/en_GB/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "All cells with contents that were included in the selection are now highlighted." ], "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": 1952047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/1952047/?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/en_GB/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Click <item type=\"menuitem\">Replace all</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": 1952048, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/1952048/?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/en_GB/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Applying Conditional Formatting" ], "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": 1952049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/1952049/?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/en_GB/?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>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>" ], "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": 1952050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/1952050/?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/en_GB/?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": [ "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)." ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 321, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24936412/?format=api", "priority": 100, "id": 1952053, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/1952053/?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/en_GB/?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": [ "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." ], "id_hash": 3980182931444228703, "content_hash": 3980182931444228703, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154944\nhelp.text", "note": "Yy9Z2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 322, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936413/?format=api", "priority": 100, "id": 1952054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/1952054/?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/en_GB/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "To Define the Conditions" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936414/?format=api", "priority": 100, "id": 1952055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/1952055/?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/en_GB/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Select the cells to which you want to apply a conditional style." ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936415/?format=api", "priority": 100, "id": 1952056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/1952056/?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/en_GB/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 327, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936418/?format=api", "priority": 100, "id": 1952059, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/1952059/?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/en_GB/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Step1: Generate Number Values" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936419/?format=api", "priority": 100, "id": 1952060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/1952060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.721667Z" } ] }