Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=23
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=24", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=22", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "underline (_)" ], "previous_source": "", "target": [ "underline (_)" ], "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": 20, "fuzzy": false, "translated": true, "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": 1953278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/1953278/?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/en_GB/?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": [ "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." ], "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": 20, "fuzzy": false, "translated": true, "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": 1953281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/1953281/?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/en_GB/?format=api", "source": [ "Naming cells and formulas" ], "previous_source": "", "target": [ "Naming cells and formulae" ], "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": 20, "fuzzy": false, "translated": true, "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": 1953284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/1953284/?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/en_GB/?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 formulae 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": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24940132/?format=api", "priority": 100, "id": 1953285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/1953285/?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/en_GB/?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 value-added tax if you can write \"= Amount * VAT_rate\" instead of \"= A5 * B12\". In this case, you would name cell A5 \"Amount\" and cell B12 \"VAT_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": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24940133/?format=api", "priority": 100, "id": 1953286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/1953286/?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/en_GB/?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": [ "Use the <emph>Define Names</emph> dialogue box to define names for formulae or parts of formulae you need more often. In order to specify range names," ], "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": 20, "fuzzy": false, "translated": true, "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": 1953287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/1953287/?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/en_GB/?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": [ "Select a cell or range of cells, then choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialogue box appears." ], "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": 20, "fuzzy": false, "translated": true, "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": 1953288, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/1953288/?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/en_GB/?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 dialogue box." ], "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": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940136/?format=api", "priority": 100, "id": 1953289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/1953289/?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/en_GB/?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": [ "You can also name other cell ranges in this dialogue box by entering the name in the field and then selecting the respective cells." ], "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": 20, "fuzzy": false, "translated": true, "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": 1953290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/1953290/?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/en_GB/?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": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940138/?format=api", "priority": 100, "id": 1953291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/1953291/?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/en_GB/?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": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24940139/?format=api", "priority": 100, "id": 1953292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/1953292/?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/en_GB/?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": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940142/?format=api", "priority": 100, "id": 1953295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/1953295/?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/en_GB/?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>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": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940143/?format=api", "priority": 100, "id": 1953296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/1953296/?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/en_GB/?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": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24940145/?format=api", "priority": 100, "id": 1953298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/1953298/?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/en_GB/?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": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940146/?format=api", "priority": 100, "id": 1953299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/1953299/?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/en_GB/?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": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940147/?format=api", "priority": 100, "id": 1953300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/1953300/?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/en_GB/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Inserting by Dialogue Box" ], "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": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940148/?format=api", "priority": 100, "id": 1953301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/1953301/?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/en_GB/?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": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940149/?format=api", "priority": 100, "id": 1953302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/1953302/?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/en_GB/?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>Browse</emph> button to open a file selection dialogue box." ], "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": 1953304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/1953304/?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/en_GB/?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 dialogue box, 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": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24940152/?format=api", "priority": 100, "id": 1953305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/1953305/?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/en_GB/?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": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940153/?format=api", "priority": 100, "id": 1953306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/1953306/?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/en_GB/?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": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24940154/?format=api", "priority": 100, "id": 1953307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/1953307/?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/en_GB/?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": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940155/?format=api", "priority": 100, "id": 1953308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/1953308/?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/en_GB/?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": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24940156/?format=api", "priority": 100, "id": 1953309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/1953309/?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/en_GB/?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": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24940158/?format=api", "priority": 100, "id": 1953311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/1953311/?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/en_GB/?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": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24940160/?format=api", "priority": 100, "id": 1953313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/1953313/?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/en_GB/?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": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24940161/?format=api", "priority": 100, "id": 1953314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/1953314/?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/en_GB/?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": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24940162/?format=api", "priority": 100, "id": 1953315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/1953315/?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/en_GB/?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": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24940163/?format=api", "priority": 100, "id": 1953316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/1953316/?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/en_GB/?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": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940164/?format=api", "priority": 100, "id": 1953317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/1953317/?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/en_GB/?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": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24940165/?format=api", "priority": 100, "id": 1953318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/1953318/?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/en_GB/?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": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940167/?format=api", "priority": 100, "id": 1953320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=611976b1439ebf5c", "url": "https://translations.documentfoundation.org/api/units/1953320/?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/en_GB/?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": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24940168/?format=api", "priority": 100, "id": 1953321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=82007f80ed949736", "url": "https://translations.documentfoundation.org/api/units/1953321/?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/en_GB/?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 01/01/99 to 01/01/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": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24940170/?format=api", "priority": 100, "id": 1953323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3412c2c5b8b16258", "url": "https://translations.documentfoundation.org/api/units/1953323/?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/en_GB/?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": [ "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." ], "id_hash": 6606832830083740336, "content_hash": 6606832830083740336, "location": "year2000.xhp", "context": "year2000.xhp\npar_id3154011\nhelp.text", "note": "VVD69", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 1953324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=dbb02f745787b2b0", "url": "https://translations.documentfoundation.org/api/units/1953324/?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/en_GB/?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 01/01/30 or higher, it will be converted to the internal date 1930-01-01 or higher. All lower two-digit years are converted to the 20xx century. So, for example, 01/01/20 is converted into 2020-01-01." ], "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": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24940172/?format=api", "priority": 100, "id": 1953325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3f2a6a3e55faa950", "url": "https://translations.documentfoundation.org/api/units/1953325/?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/en_GB/?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": [ "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." ], "id_hash": -4760976697520235798, "content_hash": -4760976697520235798, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265127\nhelp.text", "note": "rpHje", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3ded9ceb1864daea", "url": "https://translations.documentfoundation.org/api/units/8436774/?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/en_GB/?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": [ "<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." ], "id_hash": 2067932330409150668, "content_hash": 2067932330409150668, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265196\nhelp.text", "note": "yhhMM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9cb2c57f859548cc", "url": "https://translations.documentfoundation.org/api/units/8436775/?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/en_GB/?format=api", "source": [ "The conversion is done for single scalar values only, not within ranges." ], "previous_source": "", "target": [ "The conversion is done for single scalar values only, not within ranges." ], "id_hash": 5004329085934676593, "content_hash": 5004329085934676593, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id761567607207916\nhelp.text", "note": "iCp9E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c572f2ca224aaa71", "url": "https://translations.documentfoundation.org/api/units/8436776/?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/en_GB/?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": [ "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." ], "id_hash": -577015322624017718, "content_hash": -577015322624017718, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id0908200901265448\nhelp.text", "note": "C6ykS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=77fe079f0909baca", "url": "https://translations.documentfoundation.org/api/units/8436777/?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/en_GB/?format=api", "source": [ "In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally)." ], "previous_source": "", "target": [ "In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally)." ], "id_hash": -8039049485159181135, "content_hash": -8039049485159181135, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485359\nhelp.text", "note": "Wn9uE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=106f8f16014cd4b1", "url": "https://translations.documentfoundation.org/api/units/8436778/?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/en_GB/?format=api", "source": [ "In A2 enter <literal>=A1+1</literal> (which correctly results in 101)." ], "previous_source": "", "target": [ "In A2 enter <literal>=A1+1</literal> (which correctly results in 101)." ], "id_hash": 3204216414153960538, "content_hash": 3204216414153960538, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id1005200903485341\nhelp.text", "note": "CFpmx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ac77a9da1d1f6c5a", "url": "https://translations.documentfoundation.org/api/units/8436779/?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/en_GB/?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": [ "<literal>=SUM(\"1E2\";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type." ], "id_hash": 1527828562654866949, "content_hash": 1527828562654866949, "location": "numbers_text.xhp", "context": "numbers_text.xhp\npar_id611567607779380\nhelp.text", "note": "hoF73", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9533effba2bd2e05", "url": "https://translations.documentfoundation.org/api/units/8436781/?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/en_GB/?format=api", "source": [ "Changing the default text to number conversion settings" ], "previous_source": "", "target": [ "Changing the default text to number conversion settings" ], "id_hash": -7919377630657334895, "content_hash": -7919377630657334895, "location": "numbers_text.xhp", "context": "numbers_text.xhp\nhd_id871567772424915\nhelp.text", "note": "RNrFS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8436782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1218b800ea7eb191", "url": "https://translations.documentfoundation.org/api/units/8436782/?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/en_GB/?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": [ "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)." ], "id_hash": 7593992851450333545, "content_hash": 7593992851450333545, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id2078005\nhelp.text", "note": "EruAD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8467358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e9634843818d8969", "url": "https://translations.documentfoundation.org/api/units/8467358/?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/en_GB/?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": [ "When referencing a sheet with name containing spaces, use single quotes around the name: <item type=\"literal\">='Sheet with spaces in name'.A1</item>" ], "id_hash": 4874882256296687640, "content_hash": 4874882256296687640, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id3147338\nhelp.text", "note": "Epbaf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 8467359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c3a70f95786b3818", "url": "https://translations.documentfoundation.org/api/units/8467359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.068741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a \"$\" sign to designate it as an <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">absolute reference</link>." ], "previous_source": "", "target": [ "If you drag the box in the lower right corner of the active cell to select a range of cells, $[officename] automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a \"$\" sign to designate it as an <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">absolute reference</link>." ], "id_hash": 4638398756215628616, "content_hash": 4638398756215628616, "location": "cellreferences.xhp", "context": "cellreferences.xhp\npar_id7099826\nhelp.text", "note": "Vp5Cb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/24958338/?format=api", "priority": 100, "id": 8467361, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=c05ee717eed8a348", "url": "https://translations.documentfoundation.org/api/units/8467361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.564676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:" ], "previous_source": "", "target": [ "Enter the function code. In this example, we define a <literal>VOL(a; b; c)</literal> function that calculates the volume of a rectangular solid with side lengths <literal>a</literal>, <literal>b</literal> and <literal>c</literal>:" ], "id_hash": 6382220259405813353, "content_hash": 6382220259405813353, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3150327\nhelp.text", "note": "G6mwG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24958552/?format=api", "priority": 100, "id": 8536993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d8923382f02f5669", "url": "https://translations.documentfoundation.org/api/units/8536993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.558884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc." ], "previous_source": "", "target": [ "Once you have defined the function <literal>VOL(a; b; c)</literal> in the Basic-IDE, you can apply it the same way as the built-in functions of $[officename] Calc." ], "id_hash": -7294777281101260977, "content_hash": -7294777281101260977, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148869\nhelp.text", "note": "cKHUA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1451, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24958554/?format=api", "priority": 100, "id": 8536995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1ac3beb6545e974f", "url": "https://translations.documentfoundation.org/api/units/8536995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.764737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?format=api", "source": [ "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1." ], "previous_source": "", "target": [ "Open a Calc document and enter numbers for the function parameters <literal>a</literal>, <literal>b</literal> and <literal>c</literal> in cells A1, B1, and C1." ], "id_hash": 8918437824977058734, "content_hash": 8918437824977058734, "location": "userdefined_function.xhp", "context": "userdefined_function.xhp\npar_id3148606\nhelp.text", "note": "WtG8F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1452, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24958555/?format=api", "priority": 100, "id": 8536996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=fbc4a7f32d2a3bae", "url": "https://translations.documentfoundation.org/api/units/8536996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-08T21:56:38.923707Z" } ] }