Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/gu/units/?format=api&page=23
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/units/?format=api&page=24", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/units/?format=api&page=22", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Naming Cells" ], "previous_source": "", "target": [ "Naming Cells" ], "id_hash": 2447709771474022857, "content_hash": 2447709771474022857, "location": "value_with_name.xhp", "context": "value_with_name.xhp\ntit\nhelp.text", "note": "cEdPu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1478, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940120/?format=api", "priority": 100, "id": 1965861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=a1f8031191f631c9", "url": "https://translations.documentfoundation.org/api/units/1965861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:57.943512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<bookmark_value>cells; defining names</bookmark_value> <bookmark_value>names; defining for cells</bookmark_value> <bookmark_value>values; defining names</bookmark_value> <bookmark_value>constants definition</bookmark_value> <bookmark_value>variables; defining names</bookmark_value> <bookmark_value>cell ranges; defining names</bookmark_value> <bookmark_value>defining;names for cell ranges</bookmark_value> <bookmark_value>formulas; defining names</bookmark_value> <bookmark_value>addressing; by defined names</bookmark_value> <bookmark_value>cell names; defining/addressing</bookmark_value> <bookmark_value>references; by defined names</bookmark_value> <bookmark_value>allowed cell names</bookmark_value> <bookmark_value>renaming;cells</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -409338067973107191, "content_hash": -409338067973107191, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nbm_id3147434\nhelp.text", "note": "DGAwD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24940121/?format=api", "priority": 100, "id": 1965862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=7a51bd32296b1209", "url": "https://translations.documentfoundation.org/api/units/1965862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:57.958248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Allowed names" ], "previous_source": "", "target": [ "" ], "id_hash": -244379193096465288, "content_hash": -244379193096465288, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id4391918\nhelp.text", "note": "EyNmi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940123/?format=api", "priority": 100, "id": 1965864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=7c9bca6b2cfd1478", "url": "https://translations.documentfoundation.org/api/units/1965864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:57.982279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Allowed special characters:" ], "previous_source": "", "target": [ "" ], "id_hash": 6626427312520721695, "content_hash": 6626427312520721695, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id1120029\nhelp.text", "note": "GztrF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940125/?format=api", "priority": 100, "id": 1965866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=dbf5cc884cbe751f", "url": "https://translations.documentfoundation.org/api/units/1965866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.009265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "underline (_)" ], "previous_source": "", "target": [ "" ], "id_hash": -1053212889508042268, "content_hash": -1053212889508042268, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3362224\nhelp.text", "note": "4VANL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940126/?format=api", "priority": 100, "id": 1965867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/1965867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.022189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell." ], "previous_source": "", "target": [ "" ], "id_hash": 6661512041254287758, "content_hash": 6661512041254287758, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id328989\nhelp.text", "note": "BvnNt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24940129/?format=api", "priority": 100, "id": 1965870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/1965870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.058171Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Naming cells and formulas" ], "previous_source": "", "target": [ "" ], "id_hash": 1905302747077356412, "content_hash": 1905302747077356412, "location": "value_with_name.xhp", "context": "value_with_name.xhp\nhd_id1226233\nhelp.text", "note": "ci2B9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940131/?format=api", "priority": 100, "id": 1965873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/1965873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.104939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as \"=SUM(Start)\". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces." ], "previous_source": "", "target": [ "A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as \"=SUM(Start)\". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces." ], "id_hash": -1484430074523089168, "content_hash": -1484430074523089168, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5489364\nhelp.text", "note": "FPo7Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1489, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24940132/?format=api", "priority": 100, "id": 1965874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/1965874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.118036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "For example, it is much easier to read a formula for sales tax if you can write \"= Amount * Tax_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"Tax_rate.\"" ], "previous_source": "", "target": [ "For example, it is much easier to read a formula for sales tax if you can write \"= Amount * Tax_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"Tax_rate.\"" ], "id_hash": -399800468479881712, "content_hash": -399800468479881712, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id953398\nhelp.text", "note": "aZZC8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1490, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24940133/?format=api", "priority": 100, "id": 1965875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/1965875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.140139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names," ], "previous_source": "", "target": [ "" ], "id_hash": 5827339612856761597, "content_hash": 5827339612856761597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id4889675\nhelp.text", "note": "LViNz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24940134/?format=api", "priority": 100, "id": 1965876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/1965876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.157757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears." ], "previous_source": "", "target": [ "" ], "id_hash": -8630882832493047597, "content_hash": -8630882832493047597, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3153954\nhelp.text", "note": "UNzu6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24940135/?format=api", "priority": 100, "id": 1965877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/1965877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.171462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog." ], "previous_source": "", "target": [ "Type the name of the selected area in the <emph>Name</emph> field. Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog." ], "id_hash": -2987755555787780700, "content_hash": -2987755555787780700, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3156283\nhelp.text", "note": "XRBXG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1493, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940136/?format=api", "priority": 100, "id": 1965878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/1965878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.184870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "You can also name other cell ranges in this dialog by entering the name in the field and then selecting the respective cells." ], "previous_source": "", "target": [ "" ], "id_hash": 5640040777354047699, "content_hash": 5640040777354047699, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id5774101\nhelp.text", "note": "wehKd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940137/?format=api", "priority": 100, "id": 1965879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/1965879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.200732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "If you type the name in a formula, after the first few characters entered you will see the entire name as a tip." ], "previous_source": "", "target": [ "If you type the name in a formula, after the first few characters entered you will see the entire name as a tip." ], "id_hash": -6183046363094129229, "content_hash": -6183046363094129229, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154942\nhelp.text", "note": "3sCdF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1495, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940138/?format=api", "priority": 100, "id": 1965880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/1965880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.212396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Press the Enter key in order to accept the name from the tip." ], "previous_source": "", "target": [ "Press the Enter key in order to accept the name from the tip." ], "id_hash": -5008415895440623148, "content_hash": -5008415895440623148, "location": "value_with_name.xhp", "context": "value_with_name.xhp\npar_id3154510\nhelp.text", "note": "SgWa3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1496, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24940139/?format=api", "priority": 100, "id": 1965881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/1965881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.224597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Inserting External Data in Table (WebQuery)" ], "previous_source": "", "target": [ "Inserting External Data in Table (WebQuery)" ], "id_hash": 4395953768542974508, "content_hash": 4395953768542974508, "location": "webquery.xhp", "context": "webquery.xhp\ntit\nhelp.text", "note": "tT8Ku", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1499, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940142/?format=api", "priority": 100, "id": 1965884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/1965884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.264258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<bookmark_value>HTML WebQuery</bookmark_value><bookmark_value>ranges; inserting in tables</bookmark_value><bookmark_value>external data; inserting</bookmark_value><bookmark_value>tables; inserting external data</bookmark_value><bookmark_value>web pages; importing data</bookmark_value><bookmark_value>WebQuery filter</bookmark_value><bookmark_value>inserting; external data</bookmark_value><bookmark_value>data sources; external data</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HTML WebQuery</bookmark_value><bookmark_value>ranges; inserting in tables</bookmark_value><bookmark_value>external data; inserting</bookmark_value><bookmark_value>tables; inserting external data</bookmark_value><bookmark_value>web pages; importing data</bookmark_value><bookmark_value>WebQuery filter</bookmark_value><bookmark_value>external data;WebQuery</bookmark_value><bookmark_value>inserting; external data</bookmark_value><bookmark_value>data sources; external data</bookmark_value>" ], "id_hash": 6483911236528808730, "content_hash": 6483911236528808730, "location": "webquery.xhp", "context": "webquery.xhp\nbm_id3154346\nhelp.text", "note": "eaFpE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1500, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940143/?format=api", "priority": 100, "id": 1965885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/1965885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.277230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet." ], "previous_source": "", "target": [ "With the help of the <emph>Web Page Query ($[officename] Calc)</emph> import filter, you can insert tables from HTML documents in a Calc spreadsheet." ], "id_hash": -1754040601858356598, "content_hash": -1754040601858356598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155131\nhelp.text", "note": "Uf8QW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1502, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940145/?format=api", "priority": 100, "id": 1965887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/1965887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.302587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet." ], "previous_source": "", "target": [ "You can use the same method to insert ranges defined by name from a Calc or Microsoft Excel spreadsheet." ], "id_hash": -5329861810833699027, "content_hash": -5329861810833699027, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148575\nhelp.text", "note": "eBygd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1503, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940146/?format=api", "priority": 100, "id": 1965888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/1965888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.314702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "The following insert methods are available:" ], "id_hash": -391306406609619005, "content_hash": -391306406609619005, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149664\nhelp.text", "note": "odxLF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1504, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940147/?format=api", "priority": 100, "id": 1965889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/1965889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.327654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Inserting by Dialog" ], "id_hash": 5827784301768704225, "content_hash": 5827784301768704225, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3146976\nhelp.text", "note": "kNB42", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1505, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940148/?format=api", "priority": 100, "id": 1965890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/1965890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.339654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Set the cell cursor at the cell where the new content will be inserted." ], "id_hash": 368152759068690997, "content_hash": 368152759068690997, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154319\nhelp.text", "note": "WJEih", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1506, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940149/?format=api", "priority": 100, "id": 1965891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/1965891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.349412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the <emph>Browse</emph> button to open a file selection dialog." ], "previous_source": "", "target": [ "Enter the URL of the HTML document or the name of the spreadsheet. Press Enter when finished. Click the <emph>...</emph> button to open a file selection dialog." ], "id_hash": -8100371161362078385, "content_hash": -8100371161362078385, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149958\nhelp.text", "note": "AGj3g", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24940151/?format=api", "priority": 100, "id": 1965893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/1965893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.373641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "id_hash": -7837232548087131163, "content_hash": -7837232548087131163, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149400\nhelp.text", "note": "5b5MC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1509, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24940152/?format=api", "priority": 100, "id": 1965894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/1965894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.388061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "You can also specify that the ranges or tables are updated every n seconds." ], "id_hash": -2554167218865827598, "content_hash": -2554167218865827598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155064\nhelp.text", "note": "Kegfn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1510, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940153/?format=api", "priority": 100, "id": 1965895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/1965895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.402188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images." ], "previous_source": "", "target": [ "The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images." ], "id_hash": -356872810792596919, "content_hash": -356872810792596919, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155443\nhelp.text", "note": "ywoJU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1511, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940154/?format=api", "priority": 100, "id": 1965896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/1965896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.415459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Inserting by Navigator" ], "id_hash": 6041129146140853600, "content_hash": 6041129146140853600, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149021\nhelp.text", "note": "HA9v2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1512, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940155/?format=api", "priority": 100, "id": 1965897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/1965897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.429430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document)." ], "previous_source": "", "target": [ "Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document)." ], "id_hash": 5609490903737553245, "content_hash": 5609490903737553245, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3153965\nhelp.text", "note": "KpQYC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1513, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24940156/?format=api", "priority": 100, "id": 1965898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/1965898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.440681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document." ], "previous_source": "", "target": [ "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document." ], "id_hash": 2800687121260673831, "content_hash": 2800687121260673831, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152990\nhelp.text", "note": "z9DtM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1515, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24940158/?format=api", "priority": 100, "id": 1965900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/1965900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.466554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Drag the desired external data from the Navigator into the target document." ], "id_hash": 3362152370996996680, "content_hash": 3362152370996996680, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3157978\nhelp.text", "note": "LS3Wf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1517, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24940160/?format=api", "priority": 100, "id": 1965902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/1965902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.494889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:" ], "previous_source": "", "target": [ "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:" ], "id_hash": 2359732934821486848, "content_hash": 2359732934821486848, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3144768\nhelp.text", "note": "9GfqA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1518, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24940161/?format=api", "priority": 100, "id": 1965903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/1965903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.510199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "id_hash": -6219590455625739876, "content_hash": -6219590455625739876, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152873\nhelp.text", "note": "rcjUt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1519, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24940162/?format=api", "priority": 100, "id": 1965904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/1965904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.525056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "id_hash": 6160391056425820477, "content_hash": 6160391056425820477, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149897\nhelp.text", "note": "ecFZG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1520, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24940163/?format=api", "priority": 100, "id": 1965905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/1965905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.537651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Editing the external data" ], "id_hash": -5310202282854161437, "content_hash": -5310202282854161437, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149126\nhelp.text", "note": "TGhCr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1521, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940164/?format=api", "priority": 100, "id": 1965906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/1965906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.552830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "id_hash": -3508314855120126624, "content_hash": -3508314855120126624, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3159228\nhelp.text", "note": "GEeyF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1522, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940165/?format=api", "priority": 100, "id": 1965907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/1965907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.564940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "19xx/20xx Years" ], "previous_source": "", "target": [ "19xx/20xx Years" ], "id_hash": -2226618037042233508, "content_hash": -2226618037042233508, "location": "year2000.xhp", "context": "year2000.xhp\ntit\nhelp.text", "note": "ysgCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1554, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940167/?format=api", "priority": 100, "id": 1965909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=611976b1439ebf5c", "url": "https://translations.documentfoundation.org/api/units/1965909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.590963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>" ], "id_hash": 144255379794335542, "content_hash": 144255379794335542, "location": "year2000.xhp", "context": "year2000.xhp\nbm_id3150439\nhelp.text", "note": "BzWuf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1555, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940168/?format=api", "priority": 100, "id": 1965910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=82007f80ed949736", "url": "https://translations.documentfoundation.org/api/units/1965910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.607017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years." ], "previous_source": "", "target": [ "The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years." ], "id_hash": -5471096442838752680, "content_hash": -5471096442838752680, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3151116\nhelp.text", "note": "DeEcT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1557, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24940170/?format=api", "priority": 100, "id": 1965912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=3412c2c5b8b16258", "url": "https://translations.documentfoundation.org/api/units/1965912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.636909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029." ], "previous_source": "", "target": [ "" ], "id_hash": 6606832830083740336, "content_hash": 6606832830083740336, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3154011\nhelp.text", "note": "VVD69", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24940171/?format=api", "priority": 100, "id": 1965913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=dbb02f745787b2b0", "url": "https://translations.documentfoundation.org/api/units/1965913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.652778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020." ], "previous_source": "", "target": [ "This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020." ], "id_hash": -4671804847480460976, "content_hash": -4671804847480460976, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3150010\nhelp.text", "note": "zB3Ff", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1559, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24940172/?format=api", "priority": 100, "id": 1965914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=3f2a6a3e55faa950", "url": "https://translations.documentfoundation.org/api/units/1965914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:58.666281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error." ], "previous_source": "", "target": [ "" ], "id_hash": -4760976697520235798, "content_hash": -4760976697520235798, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265127\nhelp.text", "note": "rpHje", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24958216/?format=api", "priority": 100, "id": 8436881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=3ded9ceb1864daea", "url": "https://translations.documentfoundation.org/api/units/8436881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:51.788683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 2067932330409150668, "content_hash": 2067932330409150668, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265196\nhelp.text", "note": "yhhMM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/24958217/?format=api", "priority": 100, "id": 8436882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=9cb2c57f859548cc", "url": "https://translations.documentfoundation.org/api/units/8436882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.176374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "The conversion is done for single scalar values only, not within ranges." ], "previous_source": "", "target": [ "" ], "id_hash": 5004329085934676593, "content_hash": 5004329085934676593, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id761567607207916\nhelp.text", "note": "iCp9E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24958218/?format=api", "priority": 100, "id": 8436883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=c572f2ca224aaa71", "url": "https://translations.documentfoundation.org/api/units/8436883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.223929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "The conversion is done for single scalar values, as in =A1+A2, or =\"1E2\"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string." ], "previous_source": "", "target": [ "" ], "id_hash": -577015322624017718, "content_hash": -577015322624017718, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265448\nhelp.text", "note": "C6ykS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24958219/?format=api", "priority": 100, "id": 8436884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=77fe079f0909baca", "url": "https://translations.documentfoundation.org/api/units/8436884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.380233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally)." ], "previous_source": "", "target": [ "" ], "id_hash": -8039049485159181135, "content_hash": -8039049485159181135, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485359\nhelp.text", "note": "Wn9uE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24958220/?format=api", "priority": 100, "id": 8436885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=106f8f16014cd4b1", "url": "https://translations.documentfoundation.org/api/units/8436885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.653223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "In A2 enter <literal>=A1+1</literal> (which correctly results in 101)." ], "previous_source": "", "target": [ "" ], "id_hash": 3204216414153960538, "content_hash": 3204216414153960538, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485341\nhelp.text", "note": "CFpmx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24958221/?format=api", "priority": 100, "id": 8436886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=ac77a9da1d1f6c5a", "url": "https://translations.documentfoundation.org/api/units/8436886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.837332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "<literal>=SUM(\"1E2\";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type." ], "previous_source": "", "target": [ "" ], "id_hash": 1527828562654866949, "content_hash": 1527828562654866949, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id611567607779380\nhelp.text", "note": "hoF73", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24958222/?format=api", "priority": 100, "id": 8436888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=9533effba2bd2e05", "url": "https://translations.documentfoundation.org/api/units/8436888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:52.957745Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Changing the default text to number conversion settings" ], "previous_source": "", "target": [ "" ], "id_hash": -7919377630657334895, "content_hash": -7919377630657334895, "location": "numbers_text.xhp", "context": "numbers_text.xhp\nhd_id871567772424915\nhelp.text", "note": "RNrFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24958223/?format=api", "priority": 100, "id": 8436889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=1218b800ea7eb191", "url": "https://translations.documentfoundation.org/api/units/8436889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-09-30T14:04:53.065319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on <emph>+</emph> button to the left of the sheet tab in the bottom (it will be named Sheet2 by default)." ], "previous_source": "", "target": [ "" ], "id_hash": 7593992851450333545, "content_hash": 7593992851450333545, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id2078005\nhelp.text", "note": "EruAD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24958336/?format=api", "priority": 100, "id": 8467496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=e9634843818d8969", "url": "https://translations.documentfoundation.org/api/units/8467496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:06.904196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gu/?format=api", "source": [ "When referencing a sheet with name containing spaces, use single quotes around the name: <item type=\"literal\">='Sheet with spaces in name'.A1</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 4874882256296687640, "content_hash": 4874882256296687640, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id3147338\nhelp.text", "note": "Epbaf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24958337/?format=api", "priority": 100, "id": 8467499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gu/?checksum=c3a70f95786b3818", "url": "https://translations.documentfoundation.org/api/units/8467499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.068741Z" } ] }{ "count": 1559, "next": "