Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/ar/units/?format=api&page=23
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/ar/units/?format=api&page=24", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/ar/units/?format=api&page=22", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/ar/?format=api", "source": [ "Naming Cells" ], "previous_source": "", "target": [ "" ], "id_hash": 2447709771474022857, "content_hash": 2447709771474022857, "location": "value_with_name.xhp", "context": "value_with_name.xhp\ntit\nhelp.text", "note": "cEdPu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940120/?format=api", "priority": 100, "id": 1930869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=a1f8031191f631c9", "url": "https://translations.documentfoundation.org/api/units/1930869/?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/ar/?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": 1930870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=7a51bd32296b1209", "url": "https://translations.documentfoundation.org/api/units/1930870/?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/ar/?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": 1930872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=7c9bca6b2cfd1478", "url": "https://translations.documentfoundation.org/api/units/1930872/?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/ar/?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": 1930874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=dbf5cc884cbe751f", "url": "https://translations.documentfoundation.org/api/units/1930874/?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/ar/?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": 1930875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/1930875/?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/ar/?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": 1930878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/1930878/?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/ar/?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": 1930881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/1930881/?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/ar/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24940132/?format=api", "priority": 100, "id": 1930882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/1930882/?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/ar/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24940133/?format=api", "priority": 100, "id": 1930883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/1930883/?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/ar/?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": 1930884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/1930884/?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/ar/?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": 1930885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/1930885/?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/ar/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940136/?format=api", "priority": 100, "id": 1930886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/1930886/?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/ar/?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": 1930887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/1930887/?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/ar/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940138/?format=api", "priority": 100, "id": 1930888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/1930888/?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/ar/?format=api", "source": [ "Press the Enter key in order to accept the name from the tip." ], "previous_source": "", "target": [ "" ], "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": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24940139/?format=api", "priority": 100, "id": 1930889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/1930889/?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/ar/?format=api", "source": [ "Inserting External Data in Table (WebQuery)" ], "previous_source": "", "target": [ "" ], "id_hash": 4395953768542974508, "content_hash": 4395953768542974508, "location": "webquery.xhp", "context": "webquery.xhp\ntit\nhelp.text", "note": "tT8Ku", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940142/?format=api", "priority": 100, "id": 1930892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/1930892/?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/ar/?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": [ "" ], "id_hash": 6483911236528808730, "content_hash": 6483911236528808730, "location": "webquery.xhp", "context": "webquery.xhp\nbm_id3154346\nhelp.text", "note": "eaFpE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940143/?format=api", "priority": 100, "id": 1930893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/1930893/?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/ar/?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": [ "" ], "id_hash": -1754040601858356598, "content_hash": -1754040601858356598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155131\nhelp.text", "note": "Uf8QW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940145/?format=api", "priority": 100, "id": 1930895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/1930895/?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/ar/?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": [ "" ], "id_hash": -5329861810833699027, "content_hash": -5329861810833699027, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3148575\nhelp.text", "note": "eBygd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940146/?format=api", "priority": 100, "id": 1930896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/1930896/?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/ar/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "" ], "id_hash": -391306406609619005, "content_hash": -391306406609619005, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149664\nhelp.text", "note": "odxLF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940147/?format=api", "priority": 100, "id": 1930897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/1930897/?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/ar/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "" ], "id_hash": 5827784301768704225, "content_hash": 5827784301768704225, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3146976\nhelp.text", "note": "kNB42", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940148/?format=api", "priority": 100, "id": 1930898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/1930898/?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/ar/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "" ], "id_hash": 368152759068690997, "content_hash": 368152759068690997, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3154319\nhelp.text", "note": "WJEih", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940149/?format=api", "priority": 100, "id": 1930899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/1930899/?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/ar/?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": [ "" ], "id_hash": -8100371161362078385, "content_hash": -8100371161362078385, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149958\nhelp.text", "note": "AGj3g", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1930901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/1930901/?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/ar/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "" ], "id_hash": -7837232548087131163, "content_hash": -7837232548087131163, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149400\nhelp.text", "note": "5b5MC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24940152/?format=api", "priority": 100, "id": 1930902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/1930902/?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/ar/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "" ], "id_hash": -2554167218865827598, "content_hash": -2554167218865827598, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155064\nhelp.text", "note": "Kegfn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940153/?format=api", "priority": 100, "id": 1930903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/1930903/?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/ar/?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": [ "" ], "id_hash": -356872810792596919, "content_hash": -356872810792596919, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3155443\nhelp.text", "note": "ywoJU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940154/?format=api", "priority": 100, "id": 1930904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/1930904/?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/ar/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "" ], "id_hash": 6041129146140853600, "content_hash": 6041129146140853600, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149021\nhelp.text", "note": "HA9v2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940155/?format=api", "priority": 100, "id": 1930905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/1930905/?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/ar/?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": [ "" ], "id_hash": 5609490903737553245, "content_hash": 5609490903737553245, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3153965\nhelp.text", "note": "KpQYC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24940156/?format=api", "priority": 100, "id": 1930906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/1930906/?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/ar/?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": [ "" ], "id_hash": 2800687121260673831, "content_hash": 2800687121260673831, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152990\nhelp.text", "note": "z9DtM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24940158/?format=api", "priority": 100, "id": 1930908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/1930908/?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/ar/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "" ], "id_hash": 3362152370996996680, "content_hash": 3362152370996996680, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3157978\nhelp.text", "note": "LS3Wf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24940160/?format=api", "priority": 100, "id": 1930910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/1930910/?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/ar/?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": [ "" ], "id_hash": 2359732934821486848, "content_hash": 2359732934821486848, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3144768\nhelp.text", "note": "9GfqA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24940161/?format=api", "priority": 100, "id": 1930911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/1930911/?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/ar/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "" ], "id_hash": -6219590455625739876, "content_hash": -6219590455625739876, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3152873\nhelp.text", "note": "rcjUt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24940162/?format=api", "priority": 100, "id": 1930912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/1930912/?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/ar/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "" ], "id_hash": 6160391056425820477, "content_hash": 6160391056425820477, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3149897\nhelp.text", "note": "ecFZG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24940163/?format=api", "priority": 100, "id": 1930913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/1930913/?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/ar/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "" ], "id_hash": -5310202282854161437, "content_hash": -5310202282854161437, "location": "webquery.xhp", "context": "webquery.xhp\nhd_id3149126\nhelp.text", "note": "TGhCr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940164/?format=api", "priority": 100, "id": 1930914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/1930914/?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/ar/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "" ], "id_hash": -3508314855120126624, "content_hash": -3508314855120126624, "location": "webquery.xhp", "context": "webquery.xhp\npar_id3159228\nhelp.text", "note": "GEeyF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940165/?format=api", "priority": 100, "id": 1930915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/1930915/?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/ar/?format=api", "source": [ "19xx/20xx Years" ], "previous_source": "", "target": [ "" ], "id_hash": -2226618037042233508, "content_hash": -2226618037042233508, "location": "year2000.xhp", "context": "year2000.xhp\ntit\nhelp.text", "note": "ysgCC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940167/?format=api", "priority": 100, "id": 1930917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=611976b1439ebf5c", "url": "https://translations.documentfoundation.org/api/units/1930917/?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/ar/?format=api", "source": [ "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 144255379794335542, "content_hash": 144255379794335542, "location": "year2000.xhp", "context": "year2000.xhp\nbm_id3150439\nhelp.text", "note": "BzWuf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940168/?format=api", "priority": 100, "id": 1930918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=82007f80ed949736", "url": "https://translations.documentfoundation.org/api/units/1930918/?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/ar/?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": [ "" ], "id_hash": -5471096442838752680, "content_hash": -5471096442838752680, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3151116\nhelp.text", "note": "DeEcT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24940170/?format=api", "priority": 100, "id": 1930920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=3412c2c5b8b16258", "url": "https://translations.documentfoundation.org/api/units/1930920/?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/ar/?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": 1930921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=dbb02f745787b2b0", "url": "https://translations.documentfoundation.org/api/units/1930921/?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/ar/?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": [ "" ], "id_hash": -4671804847480460976, "content_hash": -4671804847480460976, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3150010\nhelp.text", "note": "zB3Ff", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24940172/?format=api", "priority": 100, "id": 1930922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=3f2a6a3e55faa950", "url": "https://translations.documentfoundation.org/api/units/1930922/?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/ar/?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": 8436613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=3ded9ceb1864daea", "url": "https://translations.documentfoundation.org/api/units/8436613/?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/ar/?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": 8436614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=9cb2c57f859548cc", "url": "https://translations.documentfoundation.org/api/units/8436614/?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/ar/?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": 8436615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=c572f2ca224aaa71", "url": "https://translations.documentfoundation.org/api/units/8436615/?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/ar/?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": 8436616, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=77fe079f0909baca", "url": "https://translations.documentfoundation.org/api/units/8436616/?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/ar/?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": 8436617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=106f8f16014cd4b1", "url": "https://translations.documentfoundation.org/api/units/8436617/?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/ar/?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": 8436618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=ac77a9da1d1f6c5a", "url": "https://translations.documentfoundation.org/api/units/8436618/?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/ar/?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": 8436620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=9533effba2bd2e05", "url": "https://translations.documentfoundation.org/api/units/8436620/?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/ar/?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": 8436621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=1218b800ea7eb191", "url": "https://translations.documentfoundation.org/api/units/8436621/?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/ar/?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": 8467124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=e9634843818d8969", "url": "https://translations.documentfoundation.org/api/units/8467124/?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/ar/?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": 8467125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/ar/?checksum=c3a70f95786b3818", "url": "https://translations.documentfoundation.org/api/units/8467125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.068741Z" } ] }