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=149
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=150", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=148", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060109.xhp\">Arvutustabel</link>" ], "id_hash": 8373712741553372247, "content_hash": 8373712741553372247, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3166428\nhelp.text", "note": "97qtM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429331/?format=api", "priority": 100, "id": 78439289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f435675f63737c57", "url": "https://translations.documentfoundation.org/api/units/78439289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.019349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp\">Text</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060110.xhp\">Tekst</link>" ], "id_hash": 8797103662154355724, "content_hash": 8797103662154355724, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3145585\nhelp.text", "note": "JeNA3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429332/?format=api", "priority": 100, "id": 78439290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=fa15972bf2ff940c", "url": "https://translations.documentfoundation.org/api/units/78439290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.020132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060111.xhp\">Add-in</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060111.xhp\">Lisatud</link>" ], "id_hash": 3122741936977352014, "content_hash": 3122741936977352014, "location": "04060100.xhp", "context": "04060100.xhp\nhd_id3156449\nhelp.text", "note": "b5ysX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429333/?format=api", "priority": 100, "id": 78439291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ab56353f26c0154e", "url": "https://translations.documentfoundation.org/api/units/78439291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.020904Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060199.xhp\">Operators</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2311250613624355920, "content_hash": -2311250613624355920, "location": "04060100.xhp", "context": "04060100.xhp\npar_id3150715\nhelp.text", "note": "mTLFx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429334/?format=api", "priority": 100, "id": 78439292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5fecc9cffc0443b0", "url": "https://translations.documentfoundation.org/api/units/78439292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.021677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Criteria can be created using wildcards, providing that wildcards have been enabled via the <menuitem>Enable wildcards in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled." ], "previous_source": "", "target": [ "" ], "id_hash": -1471934783837846393, "content_hash": -1471934783837846393, "location": "04060101.xhp", "context": "04060101.xhp\npar_id401615893095178\nhelp.text", "note": "7p3hk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/78429335/?format=api", "priority": 100, "id": 78439293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6b92a31cdccdc487", "url": "https://translations.documentfoundation.org/api/units/78439293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.024658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Even more powerful criteria can be created using regular expressions, providing that regular expressions have been enabled via the <menuitem>Enable regular expressions in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -3960201583785547978, "content_hash": -3960201583785547978, "location": "04060101.xhp", "context": "04060101.xhp\npar_id921615893158111\nhelp.text", "note": "HnAyF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/78429336/?format=api", "priority": 100, "id": 78439294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=490a89a43f85e736", "url": "https://translations.documentfoundation.org/api/units/78439294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.025442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Another setting that affects how the search criteria are handled is the <menuitem>Search criteria = and <> must apply to whole cells</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. This option controls whether the search criteria you set for the Database functions must match the whole cell exactly. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled." ], "previous_source": "", "target": [ "" ], "id_hash": -2781338395168835063, "content_hash": -2781338395168835063, "location": "04060101.xhp", "context": "04060101.xhp\npar_id881615893236930\nhelp.text", "note": "8WGaA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/78429337/?format=api", "priority": 100, "id": 78439295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5966b3773bce7a09", "url": "https://translations.documentfoundation.org/api/units/78439295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.026189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "This simple example shows the use of wildcards. For this example to work as intended, select to enable wildcards at <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letter “F”. The value 1 is returned (counting Frank)." ], "previous_source": "", "target": [ "" ], "id_hash": -5258611072821394625, "content_hash": -5258611072821394625, "location": "04060101.xhp", "context": "04060101.xhp\npar_id91616253394127\nhelp.text", "note": "VWsGS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/78429338/?format=api", "priority": 100, "id": 78439296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=3705a917308b833f", "url": "https://translations.documentfoundation.org/api/units/78439296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.029384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "This simple example shows the use of regular expressions. For this example to work as intended, select to enable regular expressions at <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and Charles)." ], "previous_source": "", "target": [ "" ], "id_hash": -48402918406530684, "content_hash": -48402918406530684, "location": "04060101.xhp", "context": "04060101.xhp\npar_id631616253692350\nhelp.text", "note": "uLJQe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 87, "source_unit": "https://translations.documentfoundation.org/api/units/78429339/?format=api", "priority": 100, "id": 78439297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7f5409cd5a495984", "url": "https://translations.documentfoundation.org/api/units/78439297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.030307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If the payments take place at irregular intervals, use the <link href=\"text/scalc/01/04060118.xhp#xirr\">XIRR</link> function." ], "previous_source": "", "target": [ "" ], "id_hash": -5774693938627689488, "content_hash": -5774693938627689488, "location": "04060103.xhp", "context": "04060103.xhp\npar_idN10E621\nhelp.text", "note": "ZCGGe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 877, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429340/?format=api", "priority": 100, "id": 78439298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2fdc2a755d7ec3f0", "url": "https://translations.documentfoundation.org/api/units/78439298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.055693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Because of the iterative method used, it is possible for IRR to fail and return <link href=\"text/scalc/05/02140000.xhp\">Error 523</link>, with \"Error: Calculation does not converge\" in the status bar. In that case, try another value for Guess." ], "previous_source": "", "target": [ "" ], "id_hash": 5557895677286575837, "content_hash": 5557895677286575837, "location": "04060103.xhp", "context": "04060103.xhp\npar_id461513468030965\nhelp.text", "note": "fhHQH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 882, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/78429341/?format=api", "priority": 100, "id": 78439299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=cd219cabe7586edd", "url": "https://translations.documentfoundation.org/api/units/78439299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.057109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060119.xhp\">Financial Functions Part Two</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060119.xhp\">Rahandusfunktsioonid, 2. osa</link>" ], "id_hash": -8284599475791481133, "content_hash": -8284599475791481133, "location": "04060103.xhp", "context": "04060103.xhp\npar_id3146812\nhelp.text", "note": "zy5K7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 893, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/78429342/?format=api", "priority": 100, "id": 78439300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0d0730aba30fb6d3", "url": "https://translations.documentfoundation.org/api/units/78439300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.058655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060118.xhp\">Rahandusfunktsioonid, 3. osa</link>" ], "id_hash": 7283326783858090152, "content_hash": 7283326783858090152, "location": "04060103.xhp", "context": "04060103.xhp\npar_id3154411\nhelp.text", "note": "9veCX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 894, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/78429343/?format=api", "priority": 100, "id": 78439301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e513931f06f320a8", "url": "https://translations.documentfoundation.org/api/units/78439301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.059671Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"math_functions_h1\"><link href=\"text/scalc/01/04060106.xhp\">Mathematical Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2255427585746688954, "content_hash": 2255427585746688954, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id3147124\nhelp.text", "note": "6DkNc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1209, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/78429344/?format=api", "priority": 100, "id": 78439302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9f4ce370810c5bba", "url": "https://translations.documentfoundation.org/api/units/78439302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.085058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"mathematiktext\">This category contains the <emph>Mathematical</emph> functions for Calc.</variable> To open the <emph>Function Wizard</emph>, choose <link href=\"text/scalc/01/04060000.xhp\"><emph>Insert - Function</emph></link>." ], "previous_source": "", "target": [ "<variable id=\"mathematiktext\">See kategooria sisaldab Calci <emph>matemaatilisi</emph> funktsioone.</variable> <emph>Funktsiooninõustaja</emph> avamiseks vali <link href=\"text/scalc/01/04060000.xhp\"><emph>Lisamine - Funktsioon</emph></link>." ], "id_hash": 3816640723560855602, "content_hash": 3816640723560855602, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3154943\nhelp.text", "note": "UNxJE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1210, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/78429345/?format=api", "priority": 100, "id": 78439303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b4f76e8443227832", "url": "https://translations.documentfoundation.org/api/units/78439303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.086047Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/func_trunc.xhp\">TRUNC</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -527729815458863531, "content_hash": -527729815458863531, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id561641930400206\nhelp.text", "note": "RFv2A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1421, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429346/?format=api", "priority": 100, "id": 78439304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=78ad208764312655", "url": "https://translations.documentfoundation.org/api/units/78439304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.100853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SERIESSUM\">SERIESSUM</link> wiki page for more details about this function." ], "previous_source": "", "target": [ "" ], "id_hash": 6599782740159124772, "content_hash": 6599782740159124772, "location": "04060106.xhp", "context": "04060106.xhp\npar_id881635251427220\nhelp.text", "note": "GAuUy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429347/?format=api", "priority": 100, "id": 78439305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=db97236f5df05524", "url": "https://translations.documentfoundation.org/api/units/78439305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.105086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/func_rounddown.xhp\">ROUNDDOWN</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7066360913107863096, "content_hash": -7066360913107863096, "location": "04060106.xhp", "context": "04060106.xhp\nhd_id561641930400105\nhelp.text", "note": "AEaRi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429348/?format=api", "priority": 100, "id": 78439306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1def3e304f8039c8", "url": "https://translations.documentfoundation.org/api/units/78439306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.108826Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT_OOO\">CONVERT_OOO</link> wiki page for more details about this function." ], "previous_source": "", "target": [ "" ], "id_hash": 2415275325709260457, "content_hash": 2415275325709260457, "location": "04060106.xhp", "context": "04060106.xhp\npar_id251631901851101\nhelp.text", "note": "TS87i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429349/?format=api", "priority": 100, "id": 78439307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=a184c81cafaa96a9", "url": "https://translations.documentfoundation.org/api/units/78439307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.117668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, when using the <link href=\"text/scalc/01/recalculate_hard.xhp\"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>) and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated." ], "previous_source": "", "target": [ "" ], "id_hash": 4653733655007460904, "content_hash": 4653733655007460904, "location": "04060106.xhp", "context": "04060106.xhp\npar_id91590242400917\nhelp.text", "note": "ztiBK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1682, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/78429350/?format=api", "priority": 100, "id": 78439308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c095621a49fffe28", "url": "https://translations.documentfoundation.org/api/units/78439308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.121955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function or using the <link href=\"text/scalc/01/recalculate_hard.xhp\"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>). The function is recalculated when opening the file." ], "previous_source": "", "target": [ "" ], "id_hash": -4917693435190103792, "content_hash": -4917693435190103792, "location": "04060106.xhp", "context": "04060106.xhp\npar_id271590239748534\nhelp.text", "note": "7pUhN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1699, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/78429351/?format=api", "priority": 100, "id": 78439309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=3bc0d7e031393110", "url": "https://translations.documentfoundation.org/api/units/78439309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.123801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"arrayfunctit\"><link href=\"text/scalc/01/04060107.xhp\">Array Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3906596139709364550, "content_hash": 3906596139709364550, "location": "04060107.xhp", "context": "04060107.xhp\nhd_id3147273\nhelp.text", "note": "8AUFn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1703, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/78429352/?format=api", "priority": 100, "id": 78439310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b637047db449f946", "url": "https://translations.documentfoundation.org/api/units/78439310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.124797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Use array formulas if you have to repeat calculations using different values. If you decide to change the calculation method later, you only have to update the array formula. To add an array formula, select the entire array range and then <link href=\"text/scalc/01/04060107.xhp\">make the required change to the array formula</link>." ], "previous_source": "", "target": [ "Massiivi valemeid kasutatakse, kui on tarvis korrata arvutusi erinevate väärtustega. Arvutusmeetodi hilisemal muutmisel piisab siis ainult massiivi valemi uuendamisest. Massiivi valemi uuendamiseks vali kogu massiivi vahemik <link href=\"text/scalc/01/04060107.xhp\">ja tee vajalikud muudatused massiivi valemisse</link>." ], "id_hash": 4506246476614111703, "content_hash": 4506246476614111703, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3149787\nhelp.text", "note": "iQ9Nx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1715, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/78429353/?format=api", "priority": 100, "id": 78439311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=be89674b9cf091d7", "url": "https://translations.documentfoundation.org/api/units/78439311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.126242Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Press <keycode>Delete</keycode> to delete the array contents, including the array formula, or press <keycode>Backspace</keycode> and this brings up the <link href=\"text/scalc/01/02150000.xhp\">Delete Contents</link> dialog box. Select <emph>Formula</emph> or <emph>Delete All</emph> and click <emph>OK</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 4965999565709457225, "content_hash": 4965999565709457225, "location": "04060107.xhp", "context": "04060107.xhp\npar_id61633516164519\nhelp.text", "note": "QeAAF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1753, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/78429354/?format=api", "priority": 100, "id": 78439312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c4eac64b44db3749", "url": "https://translations.documentfoundation.org/api/units/78439312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.129813Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Statistics Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -3653679829312444946, "content_hash": -3653679829312444946, "location": "04060108.xhp", "context": "04060108.xhp\nhd_id3153018\nhelp.text", "note": "EcgjZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/78429355/?format=api", "priority": 100, "id": 78439313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=4d4b858da2d265ee", "url": "https://translations.documentfoundation.org/api/units/78439313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.142985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Returns the number corresponding to an <link href=\"text/scalc/05/02140000.xhp\">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Tagastab arvu, mis vastab viidatud lahtris olevale <link href=\"text/scalc/05/02140000.xhp\">vea koodile</link>.</ahelp> Selle arvu abiga saab tekitada veateate teksti." ], "id_hash": -5680160780120138924, "content_hash": -5680160780120138924, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148568\nhelp.text", "note": "hEDCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/78429356/?format=api", "priority": 100, "id": 78439314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=312c03dd81d55b54", "url": "https://translations.documentfoundation.org/api/units/78439314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.147888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." ], "previous_source": "", "target": [ "" ], "id_hash": 2955182560504194790, "content_hash": 2955182560504194790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149711\nhelp.text", "note": "Kj3xA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2041, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/78429357/?format=api", "priority": 100, "id": 78439315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=a902eae1ad4826e6", "url": "https://translations.documentfoundation.org/api/units/78439315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.151015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> and <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." ], "previous_source": "", "target": [ "" ], "id_hash": 1649568430919950969, "content_hash": 1649568430919950969, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153389\nhelp.text", "note": "WYT2e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/78429358/?format=api", "priority": 100, "id": 78439316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=96e471bf85aea279", "url": "https://translations.documentfoundation.org/api/units/78439316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.156741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (columns and rows are exchanged)" ], "previous_source": "", "target": [ "" ], "id_hash": -1478624749447993405, "content_hash": -1478624749447993405, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148672\nhelp.text", "note": "SQxFe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/78429359/?format=api", "priority": 100, "id": 78439317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6b7ade9fdd0d27c3", "url": "https://translations.documentfoundation.org/api/units/78439317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.159577Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3064035665891014416, "content_hash": -3064035665891014416, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154564\nhelp.text", "note": "VAtaY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/78429360/?format=api", "priority": 100, "id": 78439318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=557a5bcbbb7048f0", "url": "https://translations.documentfoundation.org/api/units/78439318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.161204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"head_text\"><link href=\"text/scalc/01/04060110.xhp\">Text Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 1357603733246726307, "content_hash": 1357603733246726307, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id3145389\nhelp.text", "note": "7ZrHE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2206, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/78429361/?format=api", "priority": 100, "id": 78439319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=92d72d6709ea50a3", "url": "https://translations.documentfoundation.org/api/units/78439319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.165921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#number_system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used." ], "previous_source": "", "target": [ "" ], "id_hash": -7639209934285214946, "content_hash": -7639209934285214946, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3153289\nhelp.text", "note": "eNzkN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2235, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/78429362/?format=api", "priority": 100, "id": 78439320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=15fc1309fe4b6b1e", "url": "https://translations.documentfoundation.org/api/units/78439320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.167900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#decimal\">DECIMAL</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 1110650197008159491, "content_hash": 1110650197008159491, "location": "04060110.xhp", "context": "04060110.xhp\npar_id991655560817321\nhelp.text", "note": "eC4b7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2245, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429363/?format=api", "priority": 100, "id": 78439321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=8f69d2783e639303", "url": "https://translations.documentfoundation.org/api/units/78439321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.169226Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DEZIMAL\">Converts text that represents a number in a <link href=\"text/shared/00/00000005.xhp#number_system\">numeral system</link> with the given base radix to a positive integer.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs are ignored. The <emph>Text</emph> field is not case-sensitive." ], "previous_source": "", "target": [ "" ], "id_hash": 1014208628066483248, "content_hash": 1014208628066483248, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3156361\nhelp.text", "note": "R5L9j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/78429364/?format=api", "priority": 100, "id": 78439322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=8e13315fac09fc30", "url": "https://translations.documentfoundation.org/api/units/78439322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.171838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#base\">BASE</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 4358019250927596783, "content_hash": 4358019250927596783, "location": "04060110.xhp", "context": "04060110.xhp\npar_id421655560837244\nhelp.text", "note": "BLXEF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/78429365/?format=api", "priority": 100, "id": 78439323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=bc7acb6b3fda74ef", "url": "https://translations.documentfoundation.org/api/units/78439323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.173120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DM\">Converts a number to a string representing the amount in the currency format, rounded to a specified decimal places, using the decimal separator that corresponds to the <link href=\"text/shared/optionen/01140000.xhp\">current locale setting</link>.</ahelp> In the <item type=\"literal\">Value</item> field enter the number to be converted. Optionally, you may enter the number of decimal places in the <item type=\"literal\">Decimals</item> field. If no value is specified, all numbers in currency format will be displayed with two decimal places." ], "previous_source": "", "target": [ "" ], "id_hash": -4498867697217862239, "content_hash": -4498867697217862239, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3153049\nhelp.text", "note": "HBpWu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/78429366/?format=api", "priority": 100, "id": 78439324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=4190cfaa57d985a1", "url": "https://translations.documentfoundation.org/api/units/78439324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.173976Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Number</emph> is rounded to <literal>Decimals</literal> places (after the decimal separator) and the result formatted as text, using <link href=\"text/shared/optionen/01140000.xhp\">locale-specific settings</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -8704542875165443626, "content_hash": -8704542875165443626, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3151272\nhelp.text", "note": "LtU6B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2311, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/78429367/?format=api", "priority": 100, "id": 78439325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0733405fa99b39d6", "url": "https://translations.documentfoundation.org/api/units/78439325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.176485Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>NoThousandsSeparators</emph> (optional) determines whether the thousands separator is used. If it is <literal>TRUE</literal> or non-zero, then group separators are omitted from the resulting string. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your <link href=\"text/shared/optionen/01140000.xhp\">current locale setting</link> are displayed." ], "previous_source": "", "target": [ "" ], "id_hash": -5751167655227385048, "content_hash": -5751167655227385048, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3150877\nhelp.text", "note": "2BbRw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/78429368/?format=api", "priority": 100, "id": 78439326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=302fbf7d12749b28", "url": "https://translations.documentfoundation.org/api/units/78439326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.177415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"leftbvar\"><link href=\"text/scalc/01/04060110.xhp#leftb\">LEFTB</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -1576598950514515976, "content_hash": -1576598950514515976, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id2947083\nhelp.text", "note": "VRKR9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/78429369/?format=api", "priority": 100, "id": 78439327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6a1ecb9b91541ff8", "url": "https://translations.documentfoundation.org/api/units/78439327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.179181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"lenbvar\"><link href=\"text/scalc/01/04060110.xhp#lenb\">LENB</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -7287863624836544401, "content_hash": -7287863624836544401, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id2956110\nhelp.text", "note": "cUDuG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/78429370/?format=api", "priority": 100, "id": 78439328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1adc4ea55e20886f", "url": "https://translations.documentfoundation.org/api/units/78439328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.181050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"midbvar\"><link href=\"text/scalc/01/04060110.xhp#midb\">MIDB</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 5337148332814916641, "content_hash": 5337148332814916641, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id2954589\nhelp.text", "note": "XCNCE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2370, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/78429371/?format=api", "priority": 100, "id": 78439329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ca115c219b005c21", "url": "https://translations.documentfoundation.org/api/units/78439329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.183279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ERSETZEN\">Replaces part of a text string with a different text string.</ahelp> This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the <link href=\"text/scalc/01/04060110.xhp\">VALUE</link> function." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ERSETZEN\">Asendab tekstistringi osa teise stringiga.</ahelp> Funktsiooniga saab asendada nii teksti kui arve (arvud teisendatakse seejuures automaatselt tekstiks). Funktsiooni tulemuseks on alati tekst. Vajadusel teostada selle funktsiooni abil töödeldud arvuga edasisi tehteid, tuleb see funktsiooniga <link href=\"text/scalc/01/04060110.xhp\">VALUE</link> teisendada tagasi arvuks." ], "id_hash": -2198622493916018626, "content_hash": -2198622493916018626, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3148925\nhelp.text", "note": "ZveMF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://translations.documentfoundation.org/api/units/78429372/?format=api", "priority": 100, "id": 78439330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=617cec7d96f3c83e", "url": "https://translations.documentfoundation.org/api/units/78439330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.185673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT\">REPT</link> wiki page for more details about this function." ], "previous_source": "", "target": [ "" ], "id_hash": 8509221224449735366, "content_hash": 8509221224449735366, "location": "04060110.xhp", "context": "04060110.xhp\npar_id381626381556310\nhelp.text", "note": "SNGUL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2410, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429373/?format=api", "priority": 100, "id": 78439331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f616d39eae8a7ac6", "url": "https://translations.documentfoundation.org/api/units/78439331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.187819Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"rightbvar\"><link href=\"text/scalc/01/04060110.xhp#rightb\">RIGHTB</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6787686360792205066, "content_hash": -6787686360792205066, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id2949805\nhelp.text", "note": "hxvDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2419, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/78429374/?format=api", "priority": 100, "id": 78439332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=21cd4b37b23778f6", "url": "https://translations.documentfoundation.org/api/units/78439332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.189057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "See also <link href=\"text/shared/01/05020301.xhp\">Number format codes</link>: custom format codes defined by the user." ], "previous_source": "", "target": [ "" ], "id_hash": -3751956083450223167, "content_hash": -3751956083450223167, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3145364\nhelp.text", "note": "YAD8g", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429375/?format=api", "priority": 100, "id": 78439333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=4bee5fd2211565c1", "url": "https://translations.documentfoundation.org/api/units/78439333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.192676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"head_addin\"><link href=\"text/scalc/01/04060111.xhp\">Add-in Functions</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5791494577254750790, "content_hash": -5791494577254750790, "location": "04060111.xhp", "context": "04060111.xhp\nhd_id3150870\nhelp.text", "note": "EMbBZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/78429376/?format=api", "priority": 100, "id": 78439334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2fa07a5ddc2125ba", "url": "https://translations.documentfoundation.org/api/units/78439334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.195138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Refer to the <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ROT13\">ROT13</link> wiki page for more details about this function." ], "previous_source": "", "target": [ "" ], "id_hash": 3730763038407488719, "content_hash": 3730763038407488719, "location": "04060111.xhp", "context": "04060111.xhp\npar_id221626469509161\nhelp.text", "note": "Hzbcx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/78429377/?format=api", "priority": 100, "id": 78439335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b3c655378d6f74cf", "url": "https://translations.documentfoundation.org/api/units/78439335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.198240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The method of extending Calc by Add-Ins that is described in the following is outdated. The interfaces are still valid and supported, to ensure compatibility with existing Add-Ins, but for programming new Add-Ins you should use the new <link href=\"text/shared/guide/integratinguno.xhp\">API functions</link>." ], "previous_source": "", "target": [ "Järgmistes lõikudes kirjeldatud Calci lisafunktsioonide abil laiendamise meetod on aegunud. Liidesed on küll endiselt sobivad ja toetatud, et tagada ühilduvus olemasolevate lisafunktsioonidega, kuid uute lisafunktsioonide programmeerimiseks tuleks kasutada uusi <link href=\"text/shared/guide/integratinguno.xhp\">API-funktsioone</link>." ], "id_hash": -7538784891162487828, "content_hash": -7538784891162487828, "location": "04060112.xhp", "context": "04060112.xhp\npar_id3147001\nhelp.text", "note": "7vLLV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/78429379/?format=api", "priority": 100, "id": 78439337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1760db156c2d93ec", "url": "https://translations.documentfoundation.org/api/units/78439337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.202852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "At a minimum, the administrative functions <link href=\"text/scalc/01/04060112.xhp\">GetFunctionCount</link> and <link href=\"text/scalc/01/04060112.xhp\">GetFunctionData</link> must exist. Using these, the functions as well as parameter types and return values can be determined. As return values, the Double and String types are supported. As parameters, additionally the cell areas <link href=\"text/scalc/01/04060112.xhp\">Double Array</link>, <link href=\"text/scalc/01/04060112.xhp\">String Array</link>, and <link href=\"text/scalc/01/04060112.xhp\">Cell Array</link> are supported." ], "previous_source": "", "target": [ "Kindlasti peavad olemas olema haldusfunktsioonid <link href=\"text/scalc/01/04060112.xhp\">GetFunctionCount</link> ja <link href=\"text/scalc/01/04060112.xhp\">GetFunctionData</link>. Nende abil saab määratleda nii funktsioonid kui ka parameetrite tüübid ja tagastatavad väärtused. Tagastatavate väärtustena on toetatud tüübid Pikad reaalarvud ja String. Parameetritena on lisaks toetatud ka <link href=\"text/scalc/01/04060112.xhp\">pikkade reaalarvude massiivi</link>, <link href=\"text/scalc/01/04060112.xhp\">stringide massiivi</link> ja <link href=\"text/scalc/01/04060112.xhp\">lahtrite massiivi</link> lahtrialad." ], "id_hash": 6549824351625766991, "content_hash": 6549824351625766991, "location": "04060112.xhp", "context": "04060112.xhp\npar_id3148837\nhelp.text", "note": "Q8NDw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/78429380/?format=api", "priority": 100, "id": 78439338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=dae5a68b9bdb684f", "url": "https://translations.documentfoundation.org/api/units/78439338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.204578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Input</emph>: Any number of types (double&, char*, double*, char**, Cell area), where the <link href=\"text/scalc/01/04060112.xhp\">Cell area</link> is an array of types double array, string array, or cell array." ], "previous_source": "", "target": [ "" ], "id_hash": 6210990197319781247, "content_hash": 6210990197319781247, "location": "04060112.xhp", "context": "04060112.xhp\npar_id3159119\nhelp.text", "note": "kqhgX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/78429381/?format=api", "priority": 100, "id": 78439339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d631dead5eadcb7f", "url": "https://translations.documentfoundation.org/api/units/78439339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2022-12-07T19:08:08.208301Z" } ] }