Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=42
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=43", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=41", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>COLUMN function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>COLUMNA</bookmark_value>" ], "id_hash": -862982028918071288, "content_hash": -862982028918071288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154818\nhelp.text", "note": "T2BJo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99151550/?format=api", "priority": 100, "id": 99496267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7406126abecae008", "url": "https://translations.documentfoundation.org/api/units/99496267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.600575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLUMN" ], "previous_source": "", "target": [ "COLUMNA" ], "id_hash": 2443648171927541574, "content_hash": 2443648171927541574, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154818\nhelp.text", "note": "sHB7C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151590/?format=api", "priority": 100, "id": 99496271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a1e99510bbc61746", "url": "https://translations.documentfoundation.org/api/units/99496271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.603460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/99151633/?format=api", "priority": 100, "id": 99496275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a902eae1ad4826e6", "url": "https://translations.documentfoundation.org/api/units/99496275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.605869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLUMN([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": -3401701009952994570, "content_hash": -3401701009952994570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149447\nhelp.text", "note": "poCRX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151656/?format=api", "priority": 100, "id": 99496277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=50cabaf455aa0af6", "url": "https://translations.documentfoundation.org/api/units/99496277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.608469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found." ], "previous_source": "", "target": [ "<emph>Referencia</emph> ye la referencia a una caxella o una área de caxelles que'l so númberu de columnes va buscase." ], "id_hash": 2624934417222538836, "content_hash": 2624934417222538836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156310\nhelp.text", "note": "CAB6L", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99151702/?format=api", "priority": 100, "id": 99496281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a46da3f1e93f1654", "url": "https://translations.documentfoundation.org/api/units/99496281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.614356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If no reference is entered, the column number of the cell in which the formula is entered is found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Si nun indica denguna referencia, alcuentrase'l númberu de columna de la caxella na que s'introduz la fórmula. <item type=\"productname\">%PRODUCTNAME</item> Calc establez automáticamente la referencia a la caxella actual." ], "id_hash": 1245808751497917804, "content_hash": 1245808751497917804, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155837\nhelp.text", "note": "RHuRB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99151737/?format=api", "priority": 100, "id": 99496287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=914a00757b1b356c", "url": "https://translations.documentfoundation.org/api/units/99496287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.620143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(A1)</item> ye igual a 1. La columna A ye la primera de la tabla." ], "id_hash": -717789900446273925, "content_hash": -717789900446273925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147571\nhelp.text", "note": "9iffF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99151768/?format=api", "priority": 100, "id": 99496292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7609e5e378896e7b", "url": "https://translations.documentfoundation.org/api/units/99496292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.623464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(C3:Y3)</item> ye igual a 3. La columna C ye la tercera de la tabla." ], "id_hash": 5843269173771338390, "content_hash": 5843269173771338390, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147079\nhelp.text", "note": "ynF5Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99151794/?format=api", "priority": 100, "id": 99496295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d117765ac5a18296", "url": "https://translations.documentfoundation.org/api/units/99496295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.625484Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.)" ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(D3:G10)</item> devuelve 4 porque la columna D ye la cuarta columna de la tabla y la función COLUMNA nun s'utiliza como una fórmula de matriz. Nesti casu, el primer valor de la matriz utilízase siempres como la resultancia." ], "id_hash": 3637248509712134828, "content_hash": 3637248509712134828, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146861\nhelp.text", "note": "eJP98", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99151827/?format=api", "priority": 100, "id": 99496296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b27a1a3fa535f2ac", "url": "https://translations.documentfoundation.org/api/units/99496296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.627403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">{=COLUMN(B2:B7)}</item> and <item type=\"input\">=COLUMN(B2:B7)</item> both return 2 because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula." ], "previous_source": "", "target": [ "<item type=\"input\">{=COLUMNA(B2:B7)}</item> y <item type=\"input\">=COLUMNA(B2:B7)</item> devuelven 2 porque la referencia namái contién la columna B como la primer columna de la tabla. Por cuenta de que les árees d'una sola columna namái tienen un númberu de columna, nun hai nenguna estrema si la fórmula utilízase como fórmula de matriz o non." ], "id_hash": -5681665261762630883, "content_hash": -5681665261762630883, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156320\nhelp.text", "note": "7pQJY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/99151848/?format=api", "priority": 100, "id": 99496299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3126ab8c13f62b1d", "url": "https://translations.documentfoundation.org/api/units/99496299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.629710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMN()</item> returns 3 if the formula was entered in column C." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA()</item> devuelve 3 si la fórmula especificar na columna C." ], "id_hash": -5375268047102608714, "content_hash": -5375268047102608714, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150872\nhelp.text", "note": "ED6XM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99151869/?format=api", "priority": 100, "id": 99496304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=35673630c7f0fab6", "url": "https://translations.documentfoundation.org/api/units/99496304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.632071Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=COLUMNA(Coneyu)}</item> devuelve la matriz d'una filera (3, 4) si \"Coneyu\" ye l'área con nome (C1:D3)." ], "id_hash": 8245206584465583030, "content_hash": 8245206584465583030, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153277\nhelp.text", "note": "vsiPD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99151885/?format=api", "priority": 100, "id": 99496307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f26cdbb41ec86bb6", "url": "https://translations.documentfoundation.org/api/units/99496307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.634021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>COLUMNS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función COLUMNES</bookmark_value>" ], "id_hash": 4594670014859081288, "content_hash": 4594670014859081288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154643\nhelp.text", "note": "cGRsQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99151919/?format=api", "priority": 100, "id": 99496310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bfc38c08efd07648", "url": "https://translations.documentfoundation.org/api/units/99496310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.636028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLUMNS" ], "previous_source": "", "target": [ "COLUMNES" ], "id_hash": 4605148601445119632, "content_hash": 4605148601445119632, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154643\nhelp.text", "note": "VF3tg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151932/?format=api", "priority": 100, "id": 99496312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bfe8c640ff05f690", "url": "https://translations.documentfoundation.org/api/units/99496312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.637921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Returns the number of columns in the given reference.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Devuelve'l númberu de columnes na referencia especificada.</ahelp>" ], "id_hash": -6672832419299237583, "content_hash": -6672832419299237583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151182\nhelp.text", "note": "eydFV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99151953/?format=api", "priority": 100, "id": 99496315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=23655644d1f56131", "url": "https://translations.documentfoundation.org/api/units/99496315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.639451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLUMNS(Array)" ], "previous_source": "", "target": [ "COLUMNES(Matriz)" ], "id_hash": 1178941322166737854, "content_hash": 1178941322166737854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154047\nhelp.text", "note": "DDKAg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151967/?format=api", "priority": 100, "id": 99496319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=905c70e2dec71bbe", "url": "https://translations.documentfoundation.org/api/units/99496319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.641323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Array</emph> is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell." ], "previous_source": "", "target": [ "<emph>Matriz</emph> ye la referencia a un rangu de caxelles que'l so númberu total de columnes va buscase. L'argumentu tamién pue ser una única caxella." ], "id_hash": -4574496684817857887, "content_hash": -4574496684817857887, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154745\nhelp.text", "note": "YUPGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99151968/?format=api", "priority": 100, "id": 99496323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=40841f807b3ac2a1", "url": "https://translations.documentfoundation.org/api/units/99496323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.642977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNES(B5)</item> devuelve 1 porque una caxella contién solamente una columna." ], "id_hash": 6507744520544517154, "content_hash": 6507744520544517154, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149577\nhelp.text", "note": "dkd2t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99151969/?format=api", "priority": 100, "id": 99496326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=da502729740cfc22", "url": "https://translations.documentfoundation.org/api/units/99496326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.645142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNES(A1:C5)</item> ye igual a 3. La referencia inclúi tres columnes." ], "id_hash": 3411673746354730818, "content_hash": 3411673746354730818, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145649\nhelp.text", "note": "AyKRA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99151970/?format=api", "priority": 100, "id": 99496330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=af58b3324cfff742", "url": "https://translations.documentfoundation.org/api/units/99496330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.647180Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNES(Coneyu)</item> devuelve 2 si <item type=\"literal\">Coneyu</item> ye l'área con nome (C1:D3)." ], "id_hash": 8816812195949992683, "content_hash": 8816812195949992683, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155846\nhelp.text", "note": "F9UyA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99151971/?format=api", "priority": 100, "id": 99496338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fa5b9bfa8eee5aeb", "url": "https://translations.documentfoundation.org/api/units/99496338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.009371Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>vertical search function</bookmark_value> <bookmark_value>VLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función de busca vertical</bookmark_value> <bookmark_value>BUSCARV</bookmark_value>" ], "id_hash": -460514873228285841, "content_hash": -460514873228285841, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153152\nhelp.text", "note": "G5anB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99152008/?format=api", "priority": 100, "id": 99496342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=799bec29a771a86f", "url": "https://translations.documentfoundation.org/api/units/99496342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.011520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "VLOOKUP" ], "previous_source": "", "target": [ "BUSCARV" ], "id_hash": 9082438316321787784, "content_hash": 9082438316321787784, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153152\nhelp.text", "note": "fZRnb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152032/?format=api", "priority": 100, "id": 99496344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fe0b4d8722c1cf88", "url": "https://translations.documentfoundation.org/api/units/99496344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.013800Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "" ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/99152037/?format=api", "priority": 100, "id": 99496355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/99496355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.019044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99152051/?format=api", "priority": 100, "id": 99496362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/99496362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.025570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." ], "previous_source": "", "target": [ "" ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99152072/?format=api", "priority": 100, "id": 99496365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/99496365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.027296Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument." ], "previous_source": "", "target": [ "" ], "id_hash": 4049811973206833510, "content_hash": 4049811973206833510, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153884\nhelp.text", "note": "WFj5E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99152101/?format=api", "priority": 100, "id": 99496368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b833d288661df966", "url": "https://translations.documentfoundation.org/api/units/99496368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.028925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." ], "previous_source": "", "target": [ "<emph>Índiz</emph> ye'l númberu de la columna na matriz que contién el valor que se va a devolver. La primer columna tien el númberu 1." ], "id_hash": 4473339114076965019, "content_hash": 4473339114076965019, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156005\nhelp.text", "note": "tEMvM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99152130/?format=api", "priority": 100, "id": 99496373, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=be147e39366b089b", "url": "https://translations.documentfoundation.org/api/units/99496373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.031538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/99152168/?format=api", "priority": 100, "id": 99496378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/99496378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.034741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type=\"input\">100</item>, E1 contains the name <item type=\"input\">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type=\"literal\">Sorted</item> parameter is not necessary." ], "previous_source": "", "target": [ "" ], "id_hash": 5590887794157254537, "content_hash": 5590887794157254537, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154129\nhelp.text", "note": "fJQRf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/99152219/?format=api", "priority": 100, "id": 99496386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cd96d2d3b5cf7789", "url": "https://translations.documentfoundation.org/api/units/99496386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.040814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Enter the following formula in B1:" ], "previous_source": "", "target": [ "Introduza la fórmula siguiente en B1:" ], "id_hash": 3302636846429914310, "content_hash": 3302636846429914310, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145663\nhelp.text", "note": "2pTXc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152244/?format=api", "priority": 100, "id": 99496389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=add552b6b59244c6", "url": "https://translations.documentfoundation.org/api/units/99496389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.050196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=BUSCARV(A1;D1:Y100;2)</item>" ], "id_hash": -3636120927334144249, "content_hash": -3636120927334144249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151172\nhelp.text", "note": "W7BCf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2081, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99152301/?format=api", "priority": 100, "id": 99496393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4d89e74815e26707", "url": "https://translations.documentfoundation.org/api/units/99496393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.051875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "As soon as you enter a number in A1 B1 will show the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number displays the text with the next number down. To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered." ], "previous_source": "", "target": [ "Al introducir un númberu n'A1, en B1 apaez rápido'l testu conteníu na segunda columna de la referencia D1:Y100. Si introduz un númberu inesistente, el testu qu'apaez ye'l correspondiente al númberu inferior más cercanu. Con cuenta de qu'esto nun asoceda, hai qu'introducir un últimu parámetru FALSU na fórmula de forma que en casu d'introducir un númberu inesistente la función produza como resultáu un mensaxe de fallu." ], "id_hash": 259841606044098307, "content_hash": 259841606044098307, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149200\nhelp.text", "note": "oY9FV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/99152340/?format=api", "priority": 100, "id": 99496395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=839b249062201f03", "url": "https://translations.documentfoundation.org/api/units/99496395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.053822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>sheet numbers; looking up</bookmark_value> <bookmark_value>SHEET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>númberos de fueyes;guetar</bookmark_value> <bookmark_value>FUEYES</bookmark_value>" ], "id_hash": -2724982189634343269, "content_hash": -2724982189634343269, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153905\nhelp.text", "note": "BPHvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152400/?format=api", "priority": 100, "id": 99496398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5a2eeb22d7942e9b", "url": "https://translations.documentfoundation.org/api/units/99496398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.056337Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SHEET" ], "previous_source": "", "target": [ "SHEET" ], "id_hash": 8718762049278515776, "content_hash": 8718762049278515776, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153905\nhelp.text", "note": "tEpv8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152430/?format=api", "priority": 100, "id": 99496402, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f8ff43e3cc671a40", "url": "https://translations.documentfoundation.org/api/units/99496402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.058399Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." ], "previous_source": "", "target": [ "" ], "id_hash": 5500430683439494706, "content_hash": 5500430683439494706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150309\nhelp.text", "note": "BRXnw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99152459/?format=api", "priority": 100, "id": 99496404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cc5574906611f632", "url": "https://translations.documentfoundation.org/api/units/99496404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.060202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SHEET([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 7060171119697611283, "content_hash": 7060171119697611283, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153095\nhelp.text", "note": "KRzAZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152497/?format=api", "priority": 100, "id": 99496407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e1fac43a1b0c4a13", "url": "https://translations.documentfoundation.org/api/units/99496407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.061818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string." ], "previous_source": "", "target": [ "<emph>Referencia</emph> ye opcional; ye la referencia a una caxella, una área o una cadena de nome de fueya." ], "id_hash": 4523632215762722536, "content_hash": 4523632215762722536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154588\nhelp.text", "note": "9yCD8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99152536/?format=api", "priority": 100, "id": 99496411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bec72b88730cdee8", "url": "https://translations.documentfoundation.org/api/units/99496411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.063368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -8376814135589143232, "content_hash": -8376814135589143232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146988\nhelp.text", "note": "wbjCM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99152563/?format=api", "priority": 100, "id": 99496413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0bbf93ed0abcfd40", "url": "https://translations.documentfoundation.org/api/units/99496413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.065396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -4871450135322043081, "content_hash": -4871450135322043081, "location": "04060109.xhp", "context": "04060109.xhp\npar_id491612531793751\nhelp.text", "note": "fEQws", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99152588/?format=api", "priority": 100, "id": 99496416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3c6521e97719dd37", "url": "https://translations.documentfoundation.org/api/units/99496416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.066997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>number of sheets; function</bookmark_value> <bookmark_value>SHEETS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>númberu de fueyes; función</bookmark_value> <bookmark_value>FUEYES</bookmark_value>" ], "id_hash": -8252590773715677554, "content_hash": -8252590773715677554, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148829\nhelp.text", "note": "7ZBfD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152617/?format=api", "priority": 100, "id": 99496419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0d78e86a5802ce8e", "url": "https://translations.documentfoundation.org/api/units/99496419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.068598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SHEETS" ], "previous_source": "", "target": [ "FUEYES" ], "id_hash": -3688537779430513678, "content_hash": -3688537779430513678, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148829\nhelp.text", "note": "vGLG7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152646/?format=api", "priority": 100, "id": 99496427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4ccfae6eac6fa3f2", "url": "https://translations.documentfoundation.org/api/units/99496427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.078442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determina'l númberu de fueyes d'una referencia.</ahelp> Si nun especifica nengún parámetru, devuelve'l númberu de fueyes del documentu actual." ], "id_hash": -294850980343089500, "content_hash": -294850980343089500, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148820\nhelp.text", "note": "A5DpQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2092, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99152675/?format=api", "priority": 100, "id": 99496432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7be87a9876f976a4", "url": "https://translations.documentfoundation.org/api/units/99496432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.082981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SHEETS([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 3577486469911131972, "content_hash": 3577486469911131972, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150777\nhelp.text", "note": "j5Aps", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152736/?format=api", "priority": 100, "id": 99496435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b1a5c8fd73d1b744", "url": "https://translations.documentfoundation.org/api/units/99496435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.085117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> is the reference to a sheet or an area. This parameter is optional." ], "previous_source": "", "target": [ "<emph>Referencia</emph> ye la referencia a una fueya o área. Esti parámetru ye opcional." ], "id_hash": 4590120515219508661, "content_hash": 4590120515219508661, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153060\nhelp.text", "note": "5B3KF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99152782/?format=api", "priority": 100, "id": 99496438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bfb3624a01e44db5", "url": "https://translations.documentfoundation.org/api/units/99496438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.086478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated." ], "previous_source": "", "target": [ "<item type=\"input\">=FUEYES(Fueya1.A1:Fueya3.G12)</item> devuelve 3 si Fueya1, Fueya2 y Fueya3 esisten na secuencia indicada." ], "id_hash": 4255690796962648702, "content_hash": 4255690796962648702, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150507\nhelp.text", "note": "95EFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99152822/?format=api", "priority": 100, "id": 99496440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bb0f403b72db927e", "url": "https://translations.documentfoundation.org/api/units/99496440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.088634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>MATCH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>COINCIDIR</bookmark_value>" ], "id_hash": -1826328122546240505, "content_hash": -1826328122546240505, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158407\nhelp.text", "note": "JB3Ps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99152859/?format=api", "priority": 100, "id": 99496445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=66a7943fb4534407", "url": "https://translations.documentfoundation.org/api/units/99496445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.090426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MATCH" ], "previous_source": "", "target": [ "COINCIDIR" ], "id_hash": 2535335821939796260, "content_hash": 2535335821939796260, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158407\nhelp.text", "note": "ExoT8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2097, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152878/?format=api", "priority": 100, "id": 99496448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a32f527f4d0b6924", "url": "https://translations.documentfoundation.org/api/units/99496448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.092182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Devuelve la posición relativa d'un elementu d'una matriz que coincide col valor especificáu.</ahelp> La función devuelve, en forma de númberu, la posición del valor atopáu en guetar_matriz." ], "id_hash": -2486715686627209743, "content_hash": -2486715686627209743, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154896\nhelp.text", "note": "GPfn3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99152920/?format=api", "priority": 100, "id": 99496450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5d7d694219318df1", "url": "https://translations.documentfoundation.org/api/units/99496450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.093702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99152964/?format=api", "priority": 100, "id": 99496454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/99496454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.095525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "" ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99152996/?format=api", "priority": 100, "id": 99496456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/99496456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.096848Z" } ] }