Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/et/units/?format=api&page=27
{ "count": 8675, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=28", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=26", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "RAND()" ], "previous_source": "", "target": [ "RAND()" ], "id_hash": 2576394956774026887, "content_hash": 2576394956774026887, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3164884\nhelp.text", "note": "frWts", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1688, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24940981/?format=api", "priority": 100, "id": 1514376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=a3c13190179fae87", "url": "https://translations.documentfoundation.org/api/units/1514376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.502244Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9." ], "previous_source": "", "target": [ "" ], "id_hash": -7134952938802336385, "content_hash": -7134952938802336385, "location": "04060106.xhp", "context": "04060106.xhp\npar_id5092318\nhelp.text", "note": "hMfj3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1689, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24940982/?format=api", "priority": 100, "id": 1514377, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1cfb8e1ad18ead7f", "url": "https://translations.documentfoundation.org/api/units/1514377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.514280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<item type=\"input\">=RAND()</item> returns a random number between 0 and 1." ], "previous_source": "", "target": [ "<item type=\"input\">=RAND()</item> tagastab juhuarvu vahemikus 0 kuni 1." ], "id_hash": -6621165530051609748, "content_hash": -6621165530051609748, "location": "04060106.xhp", "context": "04060106.xhp\npar_id9569078\nhelp.text", "note": "BLkte", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1694, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24940984/?format=api", "priority": 100, "id": 1514379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=241ce507e6367b6c", "url": "https://translations.documentfoundation.org/api/units/1514379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.542325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Array Functions" ], "previous_source": "", "target": [ "Massiivi funktsioonid" ], "id_hash": -8491463463039040247, "content_hash": -8491463463039040247, "location": "04060107.xhp", "context": "04060107.xhp\ntit\nhelp.text", "note": "Zsp2R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1701, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24940985/?format=api", "priority": 100, "id": 1514380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0a2842f856598509", "url": "https://translations.documentfoundation.org/api/units/1514380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.554839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"matrixtext\">This category contains the array functions.</variable>" ], "previous_source": "", "target": [ "<variable id=\"matrixtext\">See kategooria sisaldab massiivide funktsioone. </variable>" ], "id_hash": -7105156721673995951, "content_hash": -7105156721673995951, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154744\nhelp.text", "note": "BDGKz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1704, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24940987/?format=api", "priority": 100, "id": 1514383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1d65699b3b247951", "url": "https://translations.documentfoundation.org/api/units/1514383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.593707Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "What is an Array?" ], "previous_source": "", "target": [ "Mis on massiiv?" ], "id_hash": -3069835133593799746, "content_hash": -3069835133593799746, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3146084\nhelp.text", "note": "sWmxg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1705, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24940988/?format=api", "priority": 100, "id": 1514384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5565c135ef20b3be", "url": "https://translations.documentfoundation.org/api/units/1514384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.605902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"wasmatrix\">An array is a linked range of cells on a spreadsheet containing values.</variable> A square range of 3 rows and 3 columns is a 3 x 3 array:" ], "previous_source": "", "target": [ "<variable id=\"wasmatrix\">Massiiv on väärtusi sisaldavate arvutustabeli lahtrite seotud vahemik. </variable> Ruudukujulist vahemikku 3 reast ja 3 veerust nimetatakse 3 x 3 massiiviks." ], "id_hash": 6603962923005371307, "content_hash": 6603962923005371307, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154298\nhelp.text", "note": "kisLJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1706, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24940989/?format=api", "priority": 100, "id": 1514385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=dba5fd4a0795e3ab", "url": "https://translations.documentfoundation.org/api/units/1514385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.618810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The smallest possible array is a 1 x 2 or 2 x 1 array with two adjacent cells." ], "previous_source": "", "target": [ "Väikseim võimalik massiiv on kahest kõrvutiasuvast lahtrist koosnev 1 x 2 või 2 x 1 massiiv." ], "id_hash": -1982402718010332163, "content_hash": -1982402718010332163, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153583\nhelp.text", "note": "NYW8Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1707, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24940990/?format=api", "priority": 100, "id": 1514401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=647d173b2f39abfd", "url": "https://translations.documentfoundation.org/api/units/1514401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.820813Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "What is an array formula?" ], "previous_source": "", "target": [ "Mis on massiivi valem?" ], "id_hash": 7664599740272887349, "content_hash": 7664599740272887349, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3148474\nhelp.text", "note": "9rqkN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1708, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24940991/?format=api", "priority": 100, "id": 1514402, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ea5e20dae0844635", "url": "https://translations.documentfoundation.org/api/units/1514402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.836330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "A formula in which the individual values in a cell range are evaluated is referred to as an array formula. The difference between an array formula and other formulas is that the array formula deals with several values simultaneously instead of just one." ], "previous_source": "", "target": [ "Valemit, mis tegeleb lahtrite vahemiku väärtustega, nimetatakse massiivi valemiks. Massiivi valem erineb muudest valemitest selle poolest, et see opereerib samaaegselt mitme väärtusega, mitte ühega." ], "id_hash": 6926452568019365786, "content_hash": 6926452568019365786, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3155355\nhelp.text", "note": "EBQsz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1709, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24940992/?format=api", "priority": 100, "id": 1514403, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e01fb3e9a662ef9a", "url": "https://translations.documentfoundation.org/api/units/1514403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.849247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Not only can an array formula process several values, but it can also return several values. The results of an array formula is also an array." ], "previous_source": "", "target": [ "Massiivi valem mitte ainult ei tegele mitme väärtusega, vaid ka tagastab mitu väärtust. Massiivi valemi tulemus on samuti massiiv." ], "id_hash": 4252575777410394434, "content_hash": 4252575777410394434, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151052\nhelp.text", "note": "UMVaF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1710, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24940993/?format=api", "priority": 100, "id": 1514404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=bb042f2370fa2942", "url": "https://translations.documentfoundation.org/api/units/1514404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.860495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "To multiply the values in the individual cells by 10 in the above array, you do not need to apply a formula to each individual cell or value. Instead you just need to use a single array formula. Select a range of 3 x 3 cells on another part of the spreadsheet, enter the formula <item type=\"input\">=10*A1:C3</item> and confirm this entry using the key combination <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The result is a 3 x 3 array in which the individual values in the cell range (A1:C3) are multiplied by a factor of 10." ], "previous_source": "", "target": [ "" ], "id_hash": -6612756508864884240, "content_hash": -6612756508864884240, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3158432\nhelp.text", "note": "hFrtB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1711, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 97, "source_unit": "https://translations.documentfoundation.org/api/units/24940994/?format=api", "priority": 100, "id": 1514405, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=243ac4fdb6f4d1f0", "url": "https://translations.documentfoundation.org/api/units/1514405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.874695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "In addition to multiplication, you can also use other operators on the reference range (an array). With $[officename] Calc, you can add (+), subtract (-), multiply (*), divide (/), use exponents (^), concatenation (&) and comparisons (=, <>, <, >, <=, >=). The operators can be used on each individual value in the cell range and return the result as an array if the array formula was entered." ], "previous_source": "", "target": [ "Lisaks korrutamisele võib viidatud alale (massiivile) rakendada ka muid tehteid. $[officename] Calcis saab liita (+), lahutada (-), korrutada (*), jagada (/), astendada (^), ühendada (&) ja võrrelda (=, <>, <, >, <=, >=). Neid tehteid võib kasutada iga lahtrite vahemiku üksiku väärtuse puhul ning saada vastuse massiivina, kui sisestatakse massiivi valem." ], "id_hash": -4339403822367743253, "content_hash": -4339403822367743253, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149156\nhelp.text", "note": "8NCA2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1712, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 68, "source_unit": "https://translations.documentfoundation.org/api/units/24940995/?format=api", "priority": 100, "id": 1514406, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=43c75736f6cc62eb", "url": "https://translations.documentfoundation.org/api/units/1514406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.890314Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Comparison operators in an array formula treat empty cells in the same way as in a normal formula, that is, either as zero or as an empty string. For example, if cells A1 and A2 are empty the array formulas <item type=\"input\">{=A1:A2=\"\"}</item> and <item type=\"input\">{=A1:A2=0}</item> will both return a 1 column 2 row array of cells containing TRUE." ], "previous_source": "", "target": [ "Võrdlustehete teostamisel massiivi valemitega käituvad tühjad lahtrid samuti nagu tehete teostamisel tavaliste valemitega, see tähendab, et neid käsitletakse kas nullväärtuste või tühjade stringidena. Seetõttu annavad massiivi valemid <item type=\"input\">{=A1:A2=\"\"}</item> ja <item type=\"input\">{=A1:A2=0}</item> mõlemad vastuseks üheveerulise ja kaherealise väärtust TÕENE sisaldavate lahtrite massiivi, kui lahtrid A1 ja A2 on tühjad." ], "id_hash": 1530006406767689101, "content_hash": 1530006406767689101, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3166456\nhelp.text", "note": "eFkfc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1713, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/24940996/?format=api", "priority": 100, "id": 1514407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=953bacb87b75bd8d", "url": "https://translations.documentfoundation.org/api/units/1514407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.905911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "When do you use array formulas?" ], "previous_source": "", "target": [ "Millisel juhul kasutatakse massiivi valemeid?" ], "id_hash": 2070830481432881644, "content_hash": 2070830481432881644, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3150713\nhelp.text", "note": "rDSKx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1714, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24940997/?format=api", "priority": 100, "id": 1514408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9cbd1159e3dba9ec", "url": "https://translations.documentfoundation.org/api/units/1514408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.921216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Array formulas are also a space saving option when several values must be calculated, since they are not very memory-intensive. In addition, arrays are an essential tool for carrying out complex calculations, because you can have several cell ranges included in your calculations. $[officename] has different math functions for arrays, such as the MMULT function for multiplying two arrays or the SUMPRODUCT function for calculating the scalar products of two arrays." ], "previous_source": "", "target": [ "Massiivi valemid on ka säästlikuks lahenduseks, kui arvutatakse mitut väärtust, kuna need ei vaja väga palju mälu. Lisaks on massiivi valemeid mõistlik kasutada keeruliste arvutuste puhul, kuna arvutustesse saab kaasata mitu lahtrite vahemikku. $[officename]'is on massiivide jaoks mitmeid funktsioone, näiteks funktsioon MMULT kahe massiivi korrutamiseks ja funktsioon SUMPRODUCT kahe massiivi skalaarkorrutise arvutamiseks." ], "id_hash": 624047521922218059, "content_hash": 624047521922218059, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149798\nhelp.text", "note": "vRLSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1716, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/24940999/?format=api", "priority": 100, "id": 1514410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=88a90fea3322f84b", "url": "https://translations.documentfoundation.org/api/units/1514410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.949021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Using Array Formulas in $[officename] Calc" ], "previous_source": "", "target": [ "Massiivi valemite kasutamine $[officename] Calcis" ], "id_hash": 7804092165811085239, "content_hash": 7804092165811085239, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3155588\nhelp.text", "note": "BU7BQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1717, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24941000/?format=api", "priority": 100, "id": 1514411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ec4db47a19941fb7", "url": "https://translations.documentfoundation.org/api/units/1514411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.964143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Creating Array Formulas" ], "previous_source": "", "target": [ "Massiivi valemite loomine" ], "id_hash": 1458459038130295821, "content_hash": 1458459038130295821, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3151271\nhelp.text", "note": "EcJu6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1726, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24941002/?format=api", "priority": 100, "id": 1514413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=943d7cc49736d40d", "url": "https://translations.documentfoundation.org/api/units/1514413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:02.988901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If you create an array formula using the <emph>Function Wizard</emph>, you must mark the <emph>Array</emph> check box each time so that the results are returned in an array. Otherwise, only the value in the upper-left cell of the array being calculated is returned." ], "previous_source": "", "target": [ "Massiivi valemi koostamisel <emph>Funktsiooninõustaja</emph> abil tuleb iga kord märkida ruut <emph>Massiiv</emph>, et tulemused tagastataks massiivina. Vastasel juhul arvutatakse ja tagastatakse ainult massiivi ülemises vasakpoolses lahtris asuv väärtus." ], "id_hash": -8909948733881653646, "content_hash": -8909948733881653646, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149102\nhelp.text", "note": "keWKE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1727, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24941003/?format=api", "priority": 100, "id": 1514414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=045980d55e0ae672", "url": "https://translations.documentfoundation.org/api/units/1514414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.001155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If you enter the array formula directly into the cell, you must use the key combination <emph>Shift + </emph><switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Enter</emph> instead of the <emph>Enter</emph> key. Only then does the formula become an array formula." ], "previous_source": "", "target": [ "" ], "id_hash": 2721636926122805715, "content_hash": 2721636926122805715, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3153392\nhelp.text", "note": "G9EUo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1728, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24941004/?format=api", "priority": 100, "id": 1514415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=a5c5325d4d22c9d3", "url": "https://translations.documentfoundation.org/api/units/1514415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.015416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Array formulas appear in braces in $[officename] Calc. You cannot create array formulas by manually entering the braces." ], "previous_source": "", "target": [ "$[officename] Calcis kuvatakse massiivi valemeid loogelistes sulgudes. Massiivi valemeid ei saa koostada loogelisi sulge käsitsi sisestades." ], "id_hash": 47085003508969128, "content_hash": 47085003508969128, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151120\nhelp.text", "note": "iGmCa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1729, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24941005/?format=api", "priority": 100, "id": 1514416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=80a7478fac666ea8", "url": "https://translations.documentfoundation.org/api/units/1514416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.028462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Using Inline Array Constants in Formulas" ], "previous_source": "", "target": [ "Sisestatud konstantsete massiivide kasutamine valemites." ], "id_hash": 7897937023576546203, "content_hash": 7897937023576546203, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id8834803\nhelp.text", "note": "2tDZj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1731, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24941007/?format=api", "priority": 100, "id": 1514418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ed9b1be0bcaf9b9b", "url": "https://translations.documentfoundation.org/api/units/1514418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.059912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Calc supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE), or a literal string. Non-constant expressions are not allowed. Arrays can be entered with one or more rows, and one or more columns. All rows must consist of the same number of elements, all columns must consist of the same number of elements." ], "previous_source": "", "target": [ "Calc toetab valemites põimitud maatriksi- ja massiivikonstante. Põimitud massiiv ümbritsetakse looksulgudega '{' ja '}'. Elementideks võivad olla arvud (sealhulgas negatiivsed), tõeväärtused (TÕENE, VÄÄR) ja tekstistringid. Mittekonstantsed avaldised pole lubatud. Massiive võib sisestada ühe või mitme rea või veeruna. Kõik read peavad sisaldama sama arvu elemente, samuti ka kõik veerud." ], "id_hash": 1499165111631514125, "content_hash": 1499165111631514125, "location": "04060107.xhp", "context": "04060107.xhp\npar_id985747\nhelp.text", "note": "fuAHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1732, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/24941008/?format=api", "priority": 100, "id": 1514419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=94ce1ab9e2748a0d", "url": "https://translations.documentfoundation.org/api/units/1514419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.076037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The column separator (separating elements in one row) and the row separator are language and locale dependent. But in this help content, the ';' semicolon and '|' pipe symbol are used to indicate the column and row separators, respectively. For example, in the English locale, the ',' comma is used as the column separator, while the ';' semicolon is used as the row separator." ], "previous_source": "", "target": [ "Veerueraldaja (eraldab ühes reas asuvaid elemente) ja reaeraldaja sõltuvad keelest ja lokaadist. Käesolevas abitekstis kasutatakse veeru- ja reaeraldajatele viitamiseks vastavalt semikoolonit \";\" ja püstkriipsu \"|\". Ingliskeelsetes lokaatides näiteks kasutatakse veerueraldajana koma \",\" ja semikoolonit \";\" kasutatakse hoopis reaeraldajana." ], "id_hash": -1130093870058358447, "content_hash": -1130093870058358447, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936613\nhelp.text", "note": "CYxYN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1733, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24941009/?format=api", "priority": 100, "id": 1514420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7051199cd8533951", "url": "https://translations.documentfoundation.org/api/units/1514420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.091545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "You can view and change the row and column separator in <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - Calc - Formula - Separators</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 8587874512318753548, "content_hash": 8587874512318753548, "location": "04060107.xhp", "context": "04060107.xhp\npar_id936615\nhelp.text", "note": "4oGDs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1734, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24941243/?format=api", "priority": 100, "id": 1514421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f72e425e5263eb0c", "url": "https://translations.documentfoundation.org/api/units/1514421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.106686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Arrays can not be nested." ], "previous_source": "", "target": [ "Massiive ei saa põimida." ], "id_hash": 1299848693747545101, "content_hash": 1299848693747545101, "location": "04060107.xhp", "context": "04060107.xhp\npar_id1877498\nhelp.text", "note": "pseAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1735, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24941244/?format=api", "priority": 100, "id": 1514422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9209fd800493f40d", "url": "https://translations.documentfoundation.org/api/units/1514422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.124937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Examples:</emph>" ], "previous_source": "", "target": [ "<emph>Näited:</emph>" ], "id_hash": -6721006601462134751, "content_hash": -6721006601462134751, "location": "04060107.xhp", "context": "04060107.xhp\npar_id4262520\nhelp.text", "note": "frzGa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1736, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24941245/?format=api", "priority": 100, "id": 1514423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=22ba301afacb4821", "url": "https://translations.documentfoundation.org/api/units/1514423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.139201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "={1;2;3}" ], "previous_source": "", "target": [ "={1;2;3}" ], "id_hash": -5472199178574305970, "content_hash": -5472199178574305970, "location": "04060107.xhp", "context": "04060107.xhp\npar_id9387493\nhelp.text", "note": "Adzmh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1737, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24941246/?format=api", "priority": 100, "id": 1514424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=340ed7d70ce4e54e", "url": "https://translations.documentfoundation.org/api/units/1514424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.150431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "An array with one row consisting of the three numbers 1, 2, and 3." ], "previous_source": "", "target": [ "Üherealine massiiv, mis koosneb arvudest 1, 2 ja 3." ], "id_hash": 4368698498817009668, "content_hash": 4368698498817009668, "location": "04060107.xhp", "context": "04060107.xhp\npar_id8207037\nhelp.text", "note": "CcDoT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1738, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24941247/?format=api", "priority": 100, "id": 1514425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=bca0bc2368c52804", "url": "https://translations.documentfoundation.org/api/units/1514425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.162439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "To enter this array constant, you select three cells in a row, then you type the formula <item type=\"input\">={1;2;3}</item> using the curly braces and the semicolons, then press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -6166838000608858977, "content_hash": -6166838000608858977, "location": "04060107.xhp", "context": "04060107.xhp\npar_id6757103\nhelp.text", "note": "WhqRD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1739, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24941248/?format=api", "priority": 100, "id": 1514426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2a6afd8302542c9f", "url": "https://translations.documentfoundation.org/api/units/1514426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.173802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "={1;2;3|4;5;6}" ], "previous_source": "", "target": [ "={1;2;3|4;5;6}" ], "id_hash": 3378176491584765927, "content_hash": 3378176491584765927, "location": "04060107.xhp", "context": "04060107.xhp\npar_id8868068\nhelp.text", "note": "uTzcj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1740, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24941249/?format=api", "priority": 100, "id": 1514427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=aee1b19ee97c3fe7", "url": "https://translations.documentfoundation.org/api/units/1514427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.192564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "An array with two rows and three values in each row." ], "previous_source": "", "target": [ "Kaherealine massiiv, mille kummaski reas on kolm väärtust." ], "id_hash": 1733505000064845412, "content_hash": 1733505000064845412, "location": "04060107.xhp", "context": "04060107.xhp\npar_id6626483\nhelp.text", "note": "cTAWF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1741, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24941250/?format=api", "priority": 100, "id": 1514428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=980ea59cf13a8664", "url": "https://translations.documentfoundation.org/api/units/1514428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.208119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "={0;1;2|FALSE;TRUE;\"two\"}" ], "previous_source": "", "target": [ "={0;1;2|VÄÄR;TÕENEE;\"kaks\"}" ], "id_hash": -9089575004969020083, "content_hash": -9089575004969020083, "location": "04060107.xhp", "context": "04060107.xhp\npar_id5262916\nhelp.text", "note": "BkvQP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1742, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24941251/?format=api", "priority": 100, "id": 1514429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=01db57b10d8d554d", "url": "https://translations.documentfoundation.org/api/units/1514429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.222896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "A mixed data array." ], "previous_source": "", "target": [ "Segatüüpi andmetega massiiv." ], "id_hash": -1267502952022058965, "content_hash": -1267502952022058965, "location": "04060107.xhp", "context": "04060107.xhp\npar_id1623889\nhelp.text", "note": "c4DEy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1743, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24941252/?format=api", "priority": 100, "id": 1514430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6e68ecc7d8f7582b", "url": "https://translations.documentfoundation.org/api/units/1514430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.235837Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "=SIN({1;2;3})" ], "previous_source": "", "target": [ "=SIN({1;2;3})" ], "id_hash": 3663114837006921589, "content_hash": 3663114837006921589, "location": "04060107.xhp", "context": "04060107.xhp\npar_id7781914\nhelp.text", "note": "x4xmB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1744, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24941253/?format=api", "priority": 100, "id": 1514431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b2d5ff894742af75", "url": "https://translations.documentfoundation.org/api/units/1514431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.242280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Entered as a matrix formula, delivers the result of three SIN calculations with the arguments 1, 2, and 3." ], "previous_source": "", "target": [ "Massiivi valemina sisestatuna annab see tulemuseks kolm siinuse arvutust argumentidega 1, 2 ja 3." ], "id_hash": 5882182741764859460, "content_hash": 5882182741764859460, "location": "04060107.xhp", "context": "04060107.xhp\npar_id300912\nhelp.text", "note": "6LVeK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1745, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24941254/?format=api", "priority": 100, "id": 1514432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d1a1b609dad3e644", "url": "https://translations.documentfoundation.org/api/units/1514432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.250095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Editing Array Formulas" ], "previous_source": "", "target": [ "Massiivi valemite redigeerimine" ], "id_hash": -8987518121119238300, "content_hash": -8987518121119238300, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3148660\nhelp.text", "note": "PDitA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1746, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24941255/?format=api", "priority": 100, "id": 1514433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0345ebe3024d3764", "url": "https://translations.documentfoundation.org/api/units/1514433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.257621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Either press <emph>F2</emph> or position the cursor in the input line. Both of these actions let you edit the formula." ], "previous_source": "", "target": [ "Vajuta <emph>F2</emph> või vii kursor sisestusreale. Mõlemad tegevused võimaldavad valemit redigeerida." ], "id_hash": 7278492055898349011, "content_hash": 7278492055898349011, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3143274\nhelp.text", "note": "BzLzG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1748, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24941257/?format=api", "priority": 100, "id": 1514435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e50265f63452ddd3", "url": "https://translations.documentfoundation.org/api/units/1514435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.274311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "After you have made changes, press <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>." ], "previous_source": "", "target": [ "Pärast muudatuste tegemist vajuta <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph>." ], "id_hash": -9074301476292271688, "content_hash": -9074301476292271688, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154798\nhelp.text", "note": "A2ZDT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1749, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24941258/?format=api", "priority": 100, "id": 1514436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=02119ae290cbe1b8", "url": "https://translations.documentfoundation.org/api/units/1514436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.283009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "You can format the separate parts of an array. For example, you can change the font color. Select a cell range and then change the attribute you want." ], "previous_source": "", "target": [ "Massiivi osi saab vormindada, näiteks saab muuta fondi värvi. Vali lahtrite vahemik ja muuda soovitud atribuuti." ], "id_hash": -7750153685691771721, "content_hash": -7750153685691771721, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150628\nhelp.text", "note": "AKFjm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1750, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24941259/?format=api", "priority": 100, "id": 1514437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1471ec48f1a854b7", "url": "https://translations.documentfoundation.org/api/units/1514437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.292772Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Copying Array Formulas" ], "previous_source": "", "target": [ "Massiivi valemite kopeerimine" ], "id_hash": 1676510538604054781, "content_hash": 1676510538604054781, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3145608\nhelp.text", "note": "dEcVJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1754, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24941260/?format=api", "priority": 100, "id": 1514438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=97442973cbb188fd", "url": "https://translations.documentfoundation.org/api/units/1514438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.302890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Select the cell range or array containing the array formula." ], "previous_source": "", "target": [ "Vali massiivi valemit sisaldav lahtrivahemik või massiiv." ], "id_hash": -7084734565661562764, "content_hash": -7084734565661562764, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149585\nhelp.text", "note": "DAJJs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1755, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24941261/?format=api", "priority": 100, "id": 1514439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1dadf772f5cfa874", "url": "https://translations.documentfoundation.org/api/units/1514439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.315807Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Either press <emph>F2</emph> or position the cursor in the input line." ], "previous_source": "", "target": [ "Vajuta <emph>F2</emph> või vii kursor sisestusreale." ], "id_hash": 8374723647050280888, "content_hash": 8374723647050280888, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154619\nhelp.text", "note": "onH9W", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1756, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24941262/?format=api", "priority": 100, "id": 1514440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f438fec92a7eefb8", "url": "https://translations.documentfoundation.org/api/units/1514440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.329584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Copy the formula into the input line by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + C</emph>." ], "previous_source": "", "target": [ "Kopeeri valem sisestusreale klahvikombinatsiooni <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+C</emph> abil." ], "id_hash": -7683201351717349728, "content_hash": -7683201351717349728, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3150994\nhelp.text", "note": "MTD8j", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1757, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24941263/?format=api", "priority": 100, "id": 1514441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=155fc913f51616a0", "url": "https://translations.documentfoundation.org/api/units/1514441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.340403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Select a range of cells where you want to insert the array formula and either press <emph>F2</emph> or position the cursor in the input line." ], "previous_source": "", "target": [ "Vali lahtrite vahemik, kuhu soovid asetada massiivi valemit, ja vajuta <emph>F2</emph> või vii kursor sisestusreale." ], "id_hash": -1959733745056771180, "content_hash": -1959733745056771180, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3146787\nhelp.text", "note": "8GbwE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1758, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24941264/?format=api", "priority": 100, "id": 1514442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=64cda08abf8b9394", "url": "https://translations.documentfoundation.org/api/units/1514442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.353643Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Paste the formula by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + V</emph> in the selected space and confirm it by pressing <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph> + Shift + Enter</emph>. The selected range now contains the array formula." ], "previous_source": "", "target": [ "Aseta valem klahvikombinatsiooniga <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+V</emph> valitud alasse ja kinnita sisestamine klahvikombinatsiooniga <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>Command</emph></caseinline><defaultinline><emph>Ctrl</emph></defaultinline></switchinline><emph>+Shift+Enter</emph>. Valitud vahemik sisaldab nüüd massiivi valemit." ], "id_hash": 7815994709322409099, "content_hash": 7815994709322409099, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3154419\nhelp.text", "note": "EBtxq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1759, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24941265/?format=api", "priority": 100, "id": 1514443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ec77fdc6f77ea48b", "url": "https://translations.documentfoundation.org/api/units/1514443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.366425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Adjusting an Array Range" ], "previous_source": "", "target": [ "Massiivi vahemiku muutmine" ], "id_hash": 5700326475281852220, "content_hash": 5700326475281852220, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3154834\nhelp.text", "note": "HehUu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1760, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24941266/?format=api", "priority": 100, "id": 1514444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=cf1ba0ba46ede73c", "url": "https://translations.documentfoundation.org/api/units/1514444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.380468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If you want to edit the output array, do the following:" ], "previous_source": "", "target": [ "Kui soovid väljundmassiivi redigeerida, tee nii:" ], "id_hash": 1399936845028187009, "content_hash": 1399936845028187009, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3148679\nhelp.text", "note": "RNWq6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1761, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24941267/?format=api", "priority": 100, "id": 1514445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=936d9324b3e2db81", "url": "https://translations.documentfoundation.org/api/units/1514445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.391942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Select the cell range or array containing the array formula." ], "previous_source": "", "target": [ "Vali massiivi valemit sisaldav lahtrivahemik või massiiv." ], "id_hash": -1784065105379803792, "content_hash": -1784065105379803792, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3151102\nhelp.text", "note": "FjHFw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1762, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24941268/?format=api", "priority": 100, "id": 1514446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=673dba3d31aabd70", "url": "https://translations.documentfoundation.org/api/units/1514446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.404699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Below the selection, to the right, you will see a small icon with which you can zoom in or out on the range using your mouse." ], "previous_source": "", "target": [ "Valikuala all paremas nurgas on väike ikoon, mida kasutades saab hiire abiga vahemikku suurendada ja vähendada." ], "id_hash": 3114240252121889431, "content_hash": 3114240252121889431, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3147096\nhelp.text", "note": "HiEAu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1763, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24941269/?format=api", "priority": 100, "id": 1514447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ab38010264f2ba97", "url": "https://translations.documentfoundation.org/api/units/1514447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:03.417008Z" } ] }