Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/om/units/?format=api&page=23
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/om/units/?format=api&page=24", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/om/units/?format=api&page=22", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/om/?format=api", "source": [ "Naming Cells" ], "previous_source": "", "target": [ "Maadheelee moggaasuu" ], "id_hash": 2447709771474022857, "content_hash": 2447709771474022857, "location": "value_with_name.xhp", "context": "value_with_name.xhp\ntit\nhelp.text", "note": "cEdPu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940120/?format=api", "priority": 100, "id": 2001478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=a1f8031191f631c9", "url": "https://translations.documentfoundation.org/api/units/2001478/?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/om/?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": [ "<bookmark_value>man'eelee; maqaalee ibsuu</bookmark_value> <bookmark_value>maqaalee; man'eeleef ibsuu</bookmark_value> <bookmark_value>gatiiwwan; maqaalee ibsuu</bookmark_value> <bookmark_value>hiikoo seranaa</bookmark_value> <bookmark_value>jijjiiramtoota; maqaalee ibsuu</bookmark_value> <bookmark_value>hangiiwwan man'ee; maqaalee ibsuu</bookmark_value> <bookmark_value>ibsuu;maqaalee hangiiwwan man'eetiif</bookmark_value> <bookmark_value>foormulaawwan; maqaalee ibsuu</bookmark_value> <bookmark_value>teessessuu; maqaalee ibsamaniin</bookmark_value> <bookmark_value>maqaalee man'ee; ibsuu/teessessuu</bookmark_value> <bookmark_value>wabiilee; maqaalee ibsamaniin</bookmark_value> <bookmark_value>maqaalee man'ee eeyyamaman</bookmark_value> <bookmark_value>maqaa jijjiiruu;man'eewwan</bookmark_value>" ], "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": 20, "fuzzy": false, "translated": true, "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": 2001479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=7a51bd32296b1209", "url": "https://translations.documentfoundation.org/api/units/2001479/?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/om/?format=api", "source": [ "Allowed names" ], "previous_source": "", "target": [ "Maqaalee eeyyamaman" ], "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": 20, "fuzzy": false, "translated": true, "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": 2001481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=7c9bca6b2cfd1478", "url": "https://translations.documentfoundation.org/api/units/2001481/?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/om/?format=api", "source": [ "Allowed special characters:" ], "previous_source": "", "target": [ "Arfiilee addaa eeyyamaman" ], "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": 20, "fuzzy": false, "translated": true, "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": 2001483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=dbf5cc884cbe751f", "url": "https://translations.documentfoundation.org/api/units/2001483/?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/om/?format=api", "source": [ "underline (_)" ], "previous_source": "", "target": [ "jalmura(_)" ], "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": 2001484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=71623c750802a9e4", "url": "https://translations.documentfoundation.org/api/units/2001484/?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/om/?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": [ "Maqaaleen akka qabii man'eetti tokko ta'uu hin qaban.Fakkeenyaaf,maqaan A1 sirrii miti sababni isaas A1 wabii man'ee gubbaa bitaa ti." ], "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": 2001490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=dc7271e845f2f98e", "url": "https://translations.documentfoundation.org/api/units/2001490/?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/om/?format=api", "source": [ "Naming cells and formulas" ], "previous_source": "", "target": [ "Maadheelee fi foormulaa moggaasuu" ], "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": 2001497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=9a70fec0f51f2b7c", "url": "https://translations.documentfoundation.org/api/units/2001497/?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/om/?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": [ "Karaan man'eelee fi hammangaa man'eee foormulaa keessa jiru wabeeffachuu gaariin maqaalee hammangaawwanii kennuu dha.Fakkenyaaf,hammangaa A1:B2 <emph>Jalqaba</emph> jettee moggaasuu dandeessa.Achiin foormulaa kan akka \"=SUM(Jalqaba)\" barreessuu dandessa.Erga tarreewwan ykn sarjaawwan saagdee yookiin haqxee boodayyuu,$[officename] ammayyuu hammangaawwan maqaan addaan bahan sirriidhaan ramada.Maqaaleen hammangaa iddoolee qabaachuu hin qaban." ], "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": 2001500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=6b663eb64a2506f0", "url": "https://translations.documentfoundation.org/api/units/2001500/?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/om/?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": [ "Fakkeenyaaf,foormulaa ashuuraa gurgurtaa dubbisuun yoo \"= Amount * Tax_rate\" barreessuu dandeesse,\"= A5 * B12\" irra baay'ee salphaa dha." ], "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": 2001504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=7a739f979738ce10", "url": "https://translations.documentfoundation.org/api/units/2001504/?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/om/?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": [ "Maqaalee formulaawwan yookiin qaamolee foormulaawwanii kan yeroo baay'ee barbaadamaniif qindeessuuf qaaqa <emph>Maqaalee qindeessuu</emph>fayyadami.Maqaalee hammangaa qindeessuuf," ], "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": 2001507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=d0dede80d9e3bcfd", "url": "https://translations.documentfoundation.org/api/units/2001507/?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/om/?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": 2001508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=0838f1cacf3c10d3", "url": "https://translations.documentfoundation.org/api/units/2001508/?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/om/?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": [ "Maqaa bal'ina filatamee dirree <emph>Maqaa</emph> keessatti barreessi.<emph>Dabali</emph> cuqaasi.Maqaan haaraa qindaa'e tarree armaan gadii keessatti mul'ata.Qaaqa cufuuf TOLE cuqaasi." ], "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": 2001510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=56895c26dd91cda4", "url": "https://translations.documentfoundation.org/api/units/2001510/?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/om/?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": [ "Hammangaawwan maadhee biroos qaaqa kana keessatti maqaa dirree keesatti galchuudhaan moggaasuu fi achiin maadheelee isaanii filachuu dandeessa." ], "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": 2001512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=ce4573346ce7f0d3", "url": "https://translations.documentfoundation.org/api/units/2001512/?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/om/?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": [ "Yoo maqaa foormulaa keessatti barreessite,erga qubeen muraasni barreeffamee maqaa guutuu akka qajeelchaatti argita." ], "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": 2001514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=2a3168178a00e5b3", "url": "https://translations.documentfoundation.org/api/units/2001514/?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/om/?format=api", "source": [ "Press the Enter key in order to accept the name from the tip." ], "previous_source": "", "target": [ "Maqaa qajeelcha irraa fudhachuuf furtuu Enter tuqi." ], "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": 2001517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=3a7e884760d779d4", "url": "https://translations.documentfoundation.org/api/units/2001517/?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/om/?format=api", "source": [ "Inserting External Data in Table (WebQuery)" ], "previous_source": "", "target": [ "Deetaa alaa gabatee keessatti saaguu(GaafataSaaphaphuu)" ], "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": 2001521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=bd0190a9670b322c", "url": "https://translations.documentfoundation.org/api/units/2001521/?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/om/?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>GaafataSaaphaphuu HTML</bookmark_value><bookmark_value>hammangaawwan; gabateewwan keessatti saaguu</bookmark_value><bookmark_value>deetaa alaa; saaguu</bookmark_value><bookmark_value>gabateewwan; deetaa alaa saaguu</bookmark_value><bookmark_value>fuulota saaphaphuu; deetaa alaaguu</bookmark_value><bookmark_value>gingilcha GaafataSaaphaphuu</bookmark_value><bookmark_value>saaguu; deetaa alaa</bookmark_value><bookmark_value>maddeen deetaa; deetaa alaa</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": 2001523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=d9fb7aea9876a31a", "url": "https://translations.documentfoundation.org/api/units/2001523/?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/om/?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": [ "Gingilcha alaaguu <emph>Gaafata fuula saaphaphuu ($[officename] Calc)</emph> fayyadamuudhaan, gabateewwan galmee HTML irraa wardii Calc keessaa saaguu dandeessa." ], "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": 2001525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=67a8655dac9eca8a", "url": "https://translations.documentfoundation.org/api/units/2001525/?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/om/?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": [ "Hammanga murtaa'e maqaadhaan Calc yookiin wardii Microsoft Excel irraa saaguuf mala sanumatti fayyadamuu dandeessa." ], "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": 2001526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=360886ebff564f2d", "url": "https://translations.documentfoundation.org/api/units/2001526/?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/om/?format=api", "source": [ "The following insert methods are available:" ], "previous_source": "", "target": [ "Malli saaguu armaan gadii ni jiru:" ], "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": 2001527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=7a91cce57bb2f7c3", "url": "https://translations.documentfoundation.org/api/units/2001527/?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/om/?format=api", "source": [ "Inserting by Dialog" ], "previous_source": "", "target": [ "Qaaqaan saaguu" ], "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": 2001529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=d0e072f20e8580e1", "url": "https://translations.documentfoundation.org/api/units/2001529/?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/om/?format=api", "source": [ "Set the cell cursor at the cell where the new content will be inserted." ], "previous_source": "", "target": [ "Qaree maadhee bakka qabiyyeen haaraa saagamutti kaa'a." ], "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": 2001531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=851bf0fbdb5e8a35", "url": "https://translations.documentfoundation.org/api/units/2001531/?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/om/?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": [ "URL galmee HTML yookiin maqaa wardii galchi.Yeroo dhumu Enter tuqi.Qaaqa filannoo faayilii banuuf qabduu <emph>...</emph> cuqaasi." ], "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": 2001535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=0f95b358aa31e54f", "url": "https://translations.documentfoundation.org/api/units/2001535/?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/om/?format=api", "source": [ "In the large list box of the dialog, select the named ranges or tables you want to insert." ], "previous_source": "", "target": [ "Sanduuqa tarree guddaa kan qaaqaa keessatti,hammangaawwan mogga'an yookiin gabateewwan saaguu barbaaddu filadhu." ], "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": 2001536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=133c8e855d2313e5", "url": "https://translations.documentfoundation.org/api/units/2001536/?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/om/?format=api", "source": [ "You can also specify that the ranges or tables are updated every n seconds." ], "previous_source": "", "target": [ "Hammangaawwan yookiin gabateewwan akka hoggayyuu sekondiiwwan n keessatti fooyya'an ifteessuus ni dandeessa." ], "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": 2001538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=5c8dc6726e8e10f2", "url": "https://translations.documentfoundation.org/api/units/2001538/?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/om/?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": [ "Gingilchi alaaguu maqaalee hammangaawwan man'eetiif uumuu danda'a.Dhangeessi amma danda'amu ni qabatama,gingilchi garuu beekuma fakkii homaayyuu hin fe'u." ], "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": 2001540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=7b0c2211c2b64a49", "url": "https://translations.documentfoundation.org/api/units/2001540/?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/om/?format=api", "source": [ "Inserting by Navigator" ], "previous_source": "", "target": [ "Naannessaadhaan saaguu" ], "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": 2001542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=d3d666f37dfc0560", "url": "https://translations.documentfoundation.org/api/units/2001542/?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/om/?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": [ "Galmeelee lama bani:wardii $[officename] Calc kan deetaan alaa keessatti saagamuuf jedhu(galmee galtee) fi galmee kan deetaan alaa irraa ba'u(galmee maddaa)" ], "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": 2001544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=cdd8ea41b00fd15d", "url": "https://translations.documentfoundation.org/api/units/2001544/?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/om/?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": [ "Sanduuqa makaa naannessaa gadii keessaa galmee maddaa filadhu.Naannessi amma maqaalee hammangaa fi hammangaawwan kuusaa deetaa yookiin gabateewwan galmee maddaa keessa jiran agarsiisa." ], "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": 2001556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=a6de0a191dc0fb27", "url": "https://translations.documentfoundation.org/api/units/2001556/?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/om/?format=api", "source": [ "Drag the desired external data from the Navigator into the target document." ], "previous_source": "", "target": [ "Deetaa alaa feete naannessa irraa gara galmee galteetti harkisi." ], "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": 2001567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=aea8c3c49a036a48", "url": "https://translations.documentfoundation.org/api/units/2001567/?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/om/?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": [ "Yoo galmee HTML gingilcha <emph>Gaafata teessoo saaphaphuu</emph> wajjin akka galmee maddaatti feetee jiraatte,gabateewwan naannessa keessatti itti fufaan \"HTML_gabatee1\" irraa kaasanii kan mogga'an , akkasumas maqoota hammanga lamaa kan uumamanii turan agarta." ], "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": 2001569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=a0bf749a10d32100", "url": "https://translations.documentfoundation.org/api/units/2001569/?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/om/?format=api", "source": [ "<item type=\"literal\">HTML_all</item> - designates the entire document" ], "previous_source": "", "target": [ "<item type=\"literal\">HTML_hunda</item> - galmee hunda agarsiisa" ], "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": 2001571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=29af936ef404919c", "url": "https://translations.documentfoundation.org/api/units/2001571/?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/om/?format=api", "source": [ "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document" ], "previous_source": "", "target": [ "<item type=\"literal\">Gabateewwan_HTML</item> - gabateewwan HTML hunda galmee keessa jiran agarsiisa" ], "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": 2001574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=d57e1b06d3c1213d", "url": "https://translations.documentfoundation.org/api/units/2001574/?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/om/?format=api", "source": [ "Editing the external data" ], "previous_source": "", "target": [ "Deetaa alaa gulaaluu" ], "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": 2001576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=364e5f288d0263e3", "url": "https://translations.documentfoundation.org/api/units/2001576/?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/om/?format=api", "source": [ "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data." ], "previous_source": "", "target": [ "<emph>Gulaali - Geessituu</emph> bani. Asitti geessituu gara deetaa alaa gulaaluu dandeessa." ], "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": 2001582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=4f4ff63a2456bd60", "url": "https://translations.documentfoundation.org/api/units/2001582/?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/om/?format=api", "source": [ "19xx/20xx Years" ], "previous_source": "", "target": [ "Baroota 19xx/20xx" ], "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": 2001587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=611976b1439ebf5c", "url": "https://translations.documentfoundation.org/api/units/2001587/?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/om/?format=api", "source": [ "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>waggoota; dijiitii-2</bookmark_value><bookmark_value>guyyoota; 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": 2001588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=82007f80ed949736", "url": "https://translations.documentfoundation.org/api/units/2001588/?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/om/?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": [ "Barri galfata guyyaa keessaa yeroo baay'ee akka dijiitii lamaatti galchama.Keessatti,barri akka dijiitii afuriitti taliigama, kanaafuu shallaggii garaagarummaa 1/1/99 irraa gara 1/1/01 keessatti bu'aan sirrii waggaa lama dha." ], "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": 2001590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=3412c2c5b8b16258", "url": "https://translations.documentfoundation.org/api/units/2001590/?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/om/?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": 2001591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=dbb02f745787b2b0", "url": "https://translations.documentfoundation.org/api/units/2001591/?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/om/?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": [ "Kana jechuun yoo guyyaa 1/1/30 yookiin ol galchite,keessatti akka 1/1/1930 yookiin oliitti beekama.Barootni dijiitii lamaa gadii hundi jaarraa 20xx tti raawwatu.Kanaafuu,fakkeenyaaf,1/1/20 gara 1/1/2020 tti jijjiirama." ], "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": 2001592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=3f2a6a3e55faa950", "url": "https://translations.documentfoundation.org/api/units/2001592/?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/om/?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": 8437140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=3ded9ceb1864daea", "url": "https://translations.documentfoundation.org/api/units/8437140/?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/om/?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": 8437141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=9cb2c57f859548cc", "url": "https://translations.documentfoundation.org/api/units/8437141/?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/om/?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": 8437142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=c572f2ca224aaa71", "url": "https://translations.documentfoundation.org/api/units/8437142/?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/om/?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": 8437143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=77fe079f0909baca", "url": "https://translations.documentfoundation.org/api/units/8437143/?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/om/?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": 8437144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=106f8f16014cd4b1", "url": "https://translations.documentfoundation.org/api/units/8437144/?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/om/?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": 8437145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=ac77a9da1d1f6c5a", "url": "https://translations.documentfoundation.org/api/units/8437145/?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/om/?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": 8437147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=9533effba2bd2e05", "url": "https://translations.documentfoundation.org/api/units/8437147/?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/om/?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": 8437148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=1218b800ea7eb191", "url": "https://translations.documentfoundation.org/api/units/8437148/?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/om/?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": 8470382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=e9634843818d8969", "url": "https://translations.documentfoundation.org/api/units/8470382/?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/om/?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": 8470383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/om/?checksum=c3a70f95786b3818", "url": "https://translations.documentfoundation.org/api/units/8470383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-11-05T14:46:07.068741Z" } ] }