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=43
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=44", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=42", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>LookupArray</emph> is the reference searched. A lookup array can be a single row or column, or part of a single row or column." ], "previous_source": "", "target": [ "<emph>GuetarMatriz</emph> ye la referencia buscada. Una matriz de busca pue ser una sola filera o columna, o parte d'una sola filera o columna." ], "id_hash": -4473176383460664918, "content_hash": -4473176383460664918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159167\nhelp.text", "note": "9j4xw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99153029/?format=api", "priority": 100, "id": 99496459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=41ec15c7762919aa", "url": "https://translations.documentfoundation.org/api/units/99496459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.098172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel." ], "previous_source": "", "target": [ "<emph>Tipu</emph> pue tomar los valores 1, 0 o -1. Si Tipu = 1 o si falta esti parámetru opcional, asumir que la primer columna de la matriz de busca ordenar n'orde ascendente. Si Tipu = -1, asumir que la columna ordenar n'orde descendente. Esto correspuende cola mesma función en Microsoft Excel." ], "id_hash": 4627981797138480774, "content_hash": 4627981797138480774, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147239\nhelp.text", "note": "Z4dMn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/99153060/?format=api", "priority": 100, "id": 99496462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c039e4eca569be86", "url": "https://translations.documentfoundation.org/api/units/99496462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.099931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." ], "previous_source": "", "target": [ "" ], "id_hash": 6051458463366102660, "content_hash": 6051458463366102660, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154265\nhelp.text", "note": "8cpYu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/99153071/?format=api", "priority": 100, "id": 99496465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d3fb196911f7be84", "url": "https://translations.documentfoundation.org/api/units/99496465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.102047Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the index of the last value that is larger or equal is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -270661938800531536, "content_hash": -270661938800531536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147528\nhelp.text", "note": "vCFkE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/99153081/?format=api", "priority": 100, "id": 99496467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7c3e6a66939367b0", "url": "https://translations.documentfoundation.org/api/units/99496467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.103505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=COINCIDIR(200;D1:D100)</item> busca l'área D1:D100, que s'ordenar pola columna D, pal valor 200. Asina algámase esti valor, el devuelve'l númberu de la filera en que s'atopó. Si atopa un valor mayor mientres la busca na columna, devuélvese'l númberu de la filera anterior." ], "id_hash": -8348883544228323497, "content_hash": -8348883544228323497, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155343\nhelp.text", "note": "eFMjk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/99153090/?format=api", "priority": 100, "id": 99496470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/99496470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.104752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>OFFSET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DESREF</bookmark_value>" ], "id_hash": -3038312647783775519, "content_hash": -3038312647783775519, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158430\nhelp.text", "note": "JqPAK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153094/?format=api", "priority": 100, "id": 99496472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/99496472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.106655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "OFFSET" ], "previous_source": "", "target": [ "DESREF" ], "id_hash": 4884207378341721603, "content_hash": 4884207378341721603, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158430\nhelp.text", "note": "MwiPA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153117/?format=api", "priority": 100, "id": 99496475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/99496475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.108366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Devuelve'l valor d'una caxella movida una determinada cantidá de fileres y columnes d'un puntu de referencia concretu.</ahelp>" ], "id_hash": -7919841624111631330, "content_hash": -7919841624111631330, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149167\nhelp.text", "note": "tSGCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99153133/?format=api", "priority": 100, "id": 99496478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/99496478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.109857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "OFFSET(Reference; Rows; Columns [; Height [; Width]])" ], "previous_source": "", "target": [ "" ], "id_hash": -6274711237888482790, "content_hash": -6274711237888482790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159194\nhelp.text", "note": "nED4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99153164/?format=api", "priority": 100, "id": 99496482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=28ebbf5fbd81621a", "url": "https://translations.documentfoundation.org/api/units/99496482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.111721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> is the reference from which the function searches for the new reference." ], "previous_source": "", "target": [ "<emph>Referencia</emph> ye la referencia dende la que la función busca una nueva referencia." ], "id_hash": -3109094795117095836, "content_hash": -3109094795117095836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152360\nhelp.text", "note": "3Q5gL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99153191/?format=api", "priority": 100, "id": 99496483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/99496483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.113030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row." ], "previous_source": "", "target": [ "<emph>Files</emph> ye'l númberu de fileres en que se corrixó la referencia escontra riba (valor negativu) o escontra baxo." ], "id_hash": -7759693311848095052, "content_hash": -7759693311848095052, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156032\nhelp.text", "note": "Q5SeM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99153218/?format=api", "priority": 100, "id": 99496486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/99496486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.114816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column" ], "previous_source": "", "target": [ "<emph>Files</emph> ye'l númberu de fileres en que se corrixó la referencia escontra riba (valor negativu) o escontra baxo." ], "id_hash": -2855369498407954685, "content_hash": -2855369498407954685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3166458\nhelp.text", "note": "CEqaQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99153237/?format=api", "priority": 100, "id": 99496490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/99496490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.116584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Alto</emph> (opcional) ye l'altu vertical d'una área qu'empieza na nueva posición de referencia." ], "id_hash": -6370777246515822578, "content_hash": -6370777246515822578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150708\nhelp.text", "note": "K2dos", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153259/?format=api", "priority": 100, "id": 99496493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/99496493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.118368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Anchu</emph> (opcional) ye l'anchu horizontal d'una área qu'empieza na nueva posición de referencia." ], "id_hash": 6677511436333980503, "content_hash": 6677511436333980503, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147278\nhelp.text", "note": "NEDfS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153284/?format=api", "priority": 100, "id": 99496496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/99496496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.120074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column." ], "previous_source": "", "target": [ "Los argumentos <emph>Files</emph> y <emph>Columnes</emph> nun tienen de resultar nuna filera o columna inicial que dea cero o un valor negativu." ], "id_hash": 3258256735597929644, "content_hash": 3258256735597929644, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8662373\nhelp.text", "note": "uQEQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99153308/?format=api", "priority": 100, "id": 99496499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/99496499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.122013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns." ], "previous_source": "", "target": [ "Argumentos <emph>Files</emph> y <emph>Columnes</emph> nun tien de llevar a cero o un empiezu negativu de filera o columna." ], "id_hash": 4191163419148031225, "content_hash": 4191163419148031225, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9051484\nhelp.text", "note": "cuFvq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153340/?format=api", "priority": 100, "id": 99496503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/99496503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.123888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(A1;2;2)</item> devuelve'l valor na caxella C3 (A1 movida por dos fileres y dos columnes escontra baxo). Si C3 contién el valor <item type=\"input\">100</item>, esta función devuelve'l valor 100." ], "id_hash": -2369817467347873031, "content_hash": -2369817467347873031, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149744\nhelp.text", "note": "cUGMh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99153371/?format=api", "priority": 100, "id": 99496506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/99496506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.126016Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;1;1)</item> devuelve una referencia a B2:C3 movida embaxo 1 filera y una columna a la derecha (C3:D4)." ], "id_hash": -742657699281128448, "content_hash": -742657699281128448, "location": "04060109.xhp", "context": "04060109.xhp\npar_id7439802\nhelp.text", "note": "pZtbS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99153428/?format=api", "priority": 100, "id": 99496512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/99496512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.129750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;-1;-1)</item> devuelve una referencia a B2:C3 movida enriba 1 filera y una columna a la izquierda (A1:B2)." ], "id_hash": 3535053803764573335, "content_hash": 3535053803764573335, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3009430\nhelp.text", "note": "QQGzq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99153500/?format=api", "priority": 100, "id": 99496515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/99496515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.131538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;0;0;3;4)</item> devuelve una referencia a B2:C3 con cambéu de tamañu a 3 files y 4 columnes (B2:Y4)." ], "id_hash": 5510456478988959992, "content_hash": 5510456478988959992, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2629169\nhelp.text", "note": "ZngJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99153534/?format=api", "priority": 100, "id": 99496517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/99496517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.133293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;1;0;3;4)</item> devuelve una referencia a B2:C3 movida embaxo una filera y con cambéu de tamañu a 3 files y 4 columnes (B2:Y4)." ], "id_hash": 1923255265426347232, "content_hash": 1923255265426347232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6668599\nhelp.text", "note": "4XD3D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99153555/?format=api", "priority": 100, "id": 99496521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/99496521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.135063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMA(DESREF(A1;2;2;5;6))</item> determina'l total del área qu'empieza na caxella C3 y tien un altor de 5 files y un anchu de 6 columnes (área=C3:H7)." ], "id_hash": -7553978692711600114, "content_hash": -7553978692711600114, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153739\nhelp.text", "note": "jpz9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99153585/?format=api", "priority": 100, "id": 99496527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/99496527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.509480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned." ], "previous_source": "", "target": [ "Si s'especifiquen <emph>Anchor</emph> o <emph>Altor</emph>, la función ESPLAZAMIENTU devuelve una referencia a un intervalu de celdes. Si <emph>Referencia</emph> ye una referencia a una única celda y s'omiten <emph>Anchor</emph> y <emph>Altor</emph>, devuélvese una referencia a una única celda." ], "id_hash": -7194728458143845642, "content_hash": -7194728458143845642, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153740\nhelp.text", "note": "VCAvt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99153634/?format=api", "priority": 100, "id": 99496535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1c2730962cf132f6", "url": "https://translations.documentfoundation.org/api/units/99496535/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.515951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>LOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>BUSCAR</bookmark_value>" ], "id_hash": 7361603316006066001, "content_hash": 7361603316006066001, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3159273\nhelp.text", "note": "AFMxC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153660/?format=api", "priority": 100, "id": 99496545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/99496545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.520205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "BUSCAR" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153663/?format=api", "priority": 100, "id": 99496549, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/99496549/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.524635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/99153698/?format=api", "priority": 100, "id": 99496554, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=96e471bf85aea279", "url": "https://translations.documentfoundation.org/api/units/99496554/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.527413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "Si LOOKUP nun pue atopar el criteriu de busca, utiliza'l valor más grande del vector de busca que seya menor o igual que criteriu de busca." ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99153722/?format=api", "priority": 100, "id": 99496556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/99496556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.529197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "LOOKUP(Lookup; SearchVector [; ResultVector])" ], "previous_source": "", "target": [ "" ], "id_hash": -8386330871162544930, "content_hash": -8386330871162544930, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154104\nhelp.text", "note": "sLcHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99153779/?format=api", "priority": 100, "id": 99496559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0b9dc4815f76dcde", "url": "https://translations.documentfoundation.org/api/units/99496559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.531201Z" }, { "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 to be looked for; entered either directly or as a reference." ], "previous_source": "", "target": [ "" ], "id_hash": 7237691220109810230, "content_hash": 7237691220109810230, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150646\nhelp.text", "note": "yGLLE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99153796/?format=api", "priority": 100, "id": 99496562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e47171d1589bda36", "url": "https://translations.documentfoundation.org/api/units/99496562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.532650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>VectordeBúsqueda</emph> ye l'área d'una columna o una filera que se va a guetar." ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99153815/?format=api", "priority": 100, "id": 99496565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/99496565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.534066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>VectordeResultado</emph> ye otra área d'una columna o una filera dende la que se toma la resultancia de la función. La resultancia ye la caxella del vector de resultancia col mesmu índiz que la instancia que s'atopó col vector de busca." ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99153836/?format=api", "priority": 100, "id": 99496567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/99496567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.535948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "<item type=\"input\">=BUSCAR(A1;D1:D100;F1:F100)</item> busca la caxella correspondiente nel área D1:D100 del númberu especificáu n'A1. Pa la instancia atopada, determinar l'índiz, por exemplu, la caxella 12 d'esta área. De siguío, el conteníu de la caxella 12 devuélvese como'l valor de la función (nel vector de resultancia)." ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/99153847/?format=api", "priority": 100, "id": 99496572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/99496572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.539106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función ESCOYER</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153870/?format=api", "priority": 100, "id": 99496576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/99496576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.541411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "ESCOYER" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153895/?format=api", "priority": 100, "id": 99496580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/99496580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.543238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Utiliza un índiz pa producir un valor a partir d'una llista formada por hasta 30 valores.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153919/?format=api", "priority": 100, "id": 99496584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/99496584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.545286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])" ], "previous_source": "", "target": [ "" ], "id_hash": -4068678915336599423, "content_hash": -4068678915336599423, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155425\nhelp.text", "note": "V8cAu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99153945/?format=api", "priority": 100, "id": 99496587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=47892615523d8881", "url": "https://translations.documentfoundation.org/api/units/99496587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.547235Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." ], "previous_source": "", "target": [ "<emph>Índiz</emph> ye una referencia o númberu ente 1 y 30 qu'indica'l valor que se va a tomar de la llista." ], "id_hash": 2029050507715629929, "content_hash": 2029050507715629929, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144755\nhelp.text", "note": "CNK7e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99153962/?format=api", "priority": 100, "id": 99496589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c28a2afb7b75369", "url": "https://translations.documentfoundation.org/api/units/99496589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.548660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values." ], "previous_source": "", "target": [ "" ], "id_hash": 7994380975018243295, "content_hash": 7994380975018243295, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149939\nhelp.text", "note": "GGWDt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99153998/?format=api", "priority": 100, "id": 99496592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eef1bf24071a74df", "url": "https://translations.documentfoundation.org/api/units/99496592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.550359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "<item type=\"input\">=ESCOYER(A1;B1;B2;B3;\"Güei\";\"Ayeri\";\"Mañana\")</item>, por exemplu, devuelve'l conteníu de la caxella B2 pa A1 = 2; pa A1 = 4, la función devuelve'l testu \"Güei\"." ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99154053/?format=api", "priority": 100, "id": 99496594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/99496594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.551724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BUSCARH</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99154092/?format=api", "priority": 100, "id": 99496596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/99496596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.553298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "BUSCARH" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154126/?format=api", "priority": 100, "id": 99496598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/99496598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.555344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Busca un valor y una referencia a les caxelles asitiaes per debaxo del área escoyida.</ahelp> Esta función comprueba si la primer filera d'una matriz contién un ciertu valor. La función devuelve'l valor asitiáu nuna filera de la matriz, indicada en <emph>Índiz</emph>, na mesma columna." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/99154164/?format=api", "priority": 100, "id": 99496600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/99496600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.556562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -7751377004937243571, "content_hash": -7751377004937243571, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146070\nhelp.text", "note": "NWzFA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99154201/?format=api", "priority": 100, "id": 99496603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=146d93aebc95944d", "url": "https://translations.documentfoundation.org/api/units/99496603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.558287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99154232/?format=api", "priority": 100, "id": 99496605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6b7ade9fdd0d27c3", "url": "https://translations.documentfoundation.org/api/units/99496605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.559415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”." ], "previous_source": "", "target": [ "" ], "id_hash": 4634706998389279706, "content_hash": 4634706998389279706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id141612447324913\nhelp.text", "note": "vwqHz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/99154244/?format=api", "priority": 100, "id": 99496607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c051c97595028bda", "url": "https://translations.documentfoundation.org/api/units/99496607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.560564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Element" ], "previous_source": "", "target": [ "Elementu" ], "id_hash": 2569298458541281685, "content_hash": 2569298458541281685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id151612978320063\nhelp.text", "note": "eAMVa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154294/?format=api", "priority": 100, "id": 99496609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a3a7fb55d74fd195", "url": "https://translations.documentfoundation.org/api/units/99496609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.561737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Hydrogen" ], "previous_source": "", "target": [ "Hidróxenu" ], "id_hash": -2956641131870373628, "content_hash": -2956641131870373628, "location": "04060109.xhp", "context": "04060109.xhp\npar_id711612450364379\nhelp.text", "note": "BcKD5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154318/?format=api", "priority": 100, "id": 99496611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=56f7e68e368eb904", "url": "https://translations.documentfoundation.org/api/units/99496611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.562931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "Heliu" ], "id_hash": -3753674292092525244, "content_hash": -3753674292092525244, "location": "04060109.xhp", "context": "04060109.xhp\npar_id681612450364379\nhelp.text", "note": "ACHPj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154344/?format=api", "priority": 100, "id": 99496613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4be8451e814f2544", "url": "https://translations.documentfoundation.org/api/units/99496613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.564135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Lithium" ], "previous_source": "", "target": [ "Litiu" ], "id_hash": 6395355888623892843, "content_hash": 6395355888623892843, "location": "04060109.xhp", "context": "04060109.xhp\npar_id531612453345232\nhelp.text", "note": "7YEmL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154391/?format=api", "priority": 100, "id": 99496615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d8c0de4bf1a1396b", "url": "https://translations.documentfoundation.org/api/units/99496615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.565339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Oganesson" ], "previous_source": "", "target": [ "Oganesón" ], "id_hash": -6406307038623048080, "content_hash": -6406307038623048080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id571612453039430\nhelp.text", "note": "Y3c6z", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154434/?format=api", "priority": 100, "id": 99496618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=271839b0c0c9de70", "url": "https://translations.documentfoundation.org/api/units/99496618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:42.566710Z" } ] }{ "count": 8352, "next": "