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/es/units/?format=api&page=12
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=13", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=11", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "<emph>Peso</emph>" ], "id_hash": -6395470323821589166, "content_hash": -6395470323821589166, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616245891772\nhelp.text", "note": "ggUUj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098290/?format=api", "priority": 100, "id": 100424439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=273eb9a0090fcd52", "url": "https://translations.documentfoundation.org/api/units/100424439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.534548Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "As in this simple example, it is sometimes desirable (but not essential) to place the search criteria area directly under the database table, with the columns of the two areas vertically aligned. Blank entries in the search criteria area are ignored. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests travel further than 600 meters to school. The value 5 is returned (counting Betty, Daniel, Eva, Harry, and Irene)." ], "previous_source": "", "target": [ "Como en este sencillo ejemplo, a veces es recomendable (pero no esencial) colocar el área de criterios de búsqueda directamente debajo de la tabla de la base de datos, con las columnas de las dos áreas alineadas verticalmente. Las entradas en blanco en el área de criterios de búsqueda se ignoran. Con la tabla de base de datos del ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los huéspedes de Joe viajan más de 600 metros a la escuela. Se devuelve el valor 5 (contando a Betty, Daniel, Eva, Harry e Irene)." ], "id_hash": -2265215871166592434, "content_hash": -2265215871166592434, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616246535763\nhelp.text", "note": "4SkNQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 91, "source_unit": "https://translations.documentfoundation.org/api/units/99098318/?format=api", "priority": 100, "id": 100424442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6090562ab389ca4e", "url": "https://translations.documentfoundation.org/api/units/100424442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.535775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Note also that the formula <item type=\"input\">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly the same value, demonstrating that it is only necessary for the search criteria area to contain relevant column headings." ], "previous_source": "", "target": [ "Observe también que la fórmula <item type=\"input\">=BDCONTAR(A1:E10;;D12:D13)</item> devuelve el mismo valor exacto, lo que demuestra que solo es necesario que el área de criterios de búsqueda contenga los títulos de columnas pertinentes." ], "id_hash": -502229047337922985, "content_hash": -502229047337922985, "location": "04060101.xhp", "context": "04060101.xhp\npar_id731616246561901\nhelp.text", "note": "bBHFr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99098342/?format=api", "priority": 100, "id": 100424445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7907b957a58a4e57", "url": "https://translations.documentfoundation.org/api/units/100424445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.538298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "Ejemplo 2" ], "id_hash": 8586984018776430693, "content_hash": 8586984018776430693, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id191616246773750\nhelp.text", "note": "VyrBb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99098346/?format=api", "priority": 100, "id": 100424449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f72b187823201865", "url": "https://translations.documentfoundation.org/api/units/100424449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.540476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edad</emph>" ], "id_hash": -7039863768950871566, "content_hash": -7039863768950871566, "location": "04060101.xhp", "context": "04060101.xhp\npar_id71616246804093\nhelp.text", "note": "V4PCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098347/?format=api", "priority": 100, "id": 100424452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1e4d6133708a69f2", "url": "https://translations.documentfoundation.org/api/units/100424452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.541940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "<emph>Grado</emph>" ], "id_hash": -7748343131352010190, "content_hash": -7748343131352010190, "location": "04060101.xhp", "context": "04060101.xhp\npar_id41616250394431\nhelp.text", "note": "KjH3p", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098348/?format=api", "priority": 100, "id": 100424455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=14785af979ecf232", "url": "https://translations.documentfoundation.org/api/units/100424455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.543299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In this example the search criteria area contains only two headings and these are not vertically aligned with the corresponding headings in the example database table. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are in grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and Irene)." ], "previous_source": "", "target": [ "En este ejemplo, el área de criterios de búsqueda contiene solo dos encabezados y estos no están alineados verticalmente con los encabezados correspondientes en la tabla de la base de datos del ejemplo. Como hay dos condiciones en la misma fila, estas están conectadas por Y (AND). Con la tabla de base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=BDCONTAR(A1:E10;;B12:C13)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan están en el grado 2 y son mayores de 7 años. Devolverá el valor 2 (Eva e Irene)." ], "id_hash": -8139039694367435245, "content_hash": -8139039694367435245, "location": "04060101.xhp", "context": "04060101.xhp\npar_id361616251794063\nhelp.text", "note": "hfPeb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 90, "source_unit": "https://translations.documentfoundation.org/api/units/99098380/?format=api", "priority": 100, "id": 100424457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0f0c52853c6cd613", "url": "https://translations.documentfoundation.org/api/units/100424457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.544663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example 3" ], "previous_source": "", "target": [ "Ejemplo 3" ], "id_hash": 911904328441734396, "content_hash": 911904328441734396, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id221616251986854\nhelp.text", "note": "6Tfyk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99098406/?format=api", "priority": 100, "id": 100424461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8ca7bc27bde924fc", "url": "https://translations.documentfoundation.org/api/units/100424461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.546862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edad</emph>" ], "id_hash": -4858803826530149922, "content_hash": -4858803826530149922, "location": "04060101.xhp", "context": "04060101.xhp\npar_id141616251871487\nhelp.text", "note": "kAXbc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098445/?format=api", "priority": 100, "id": 100424464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3c920fa9ae5c99de", "url": "https://translations.documentfoundation.org/api/units/100424464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.548256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In this example the search criteria area contains only one heading. Since there are two conditions in consecutive rows, these are connected by OR. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are either 9 or 10 years old. The value 4 is returned (counting Andy, Betty, Charles, and Harry)." ], "previous_source": "", "target": [ "En este ejemplo, el área de criterios de búsqueda contiene solo un título. Dado que hay dos condiciones en filas consecutivas, estas están conectadas por O (OR). Con la tabla de la base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=BDCONTAR(A1:E10;;B12:B14)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan tienen 9 o 10 años. Se devolverá el valor 4 (contando a Andrés, Beatriz, Carlos y Henrique)." ], "id_hash": 2665154283656902008, "content_hash": 2665154283656902008, "location": "04060101.xhp", "context": "04060101.xhp\npar_id351616252313215\nhelp.text", "note": "CQA2G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/99098508/?format=api", "priority": 100, "id": 100424467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a4fc87b34cfaf578", "url": "https://translations.documentfoundation.org/api/units/100424467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.549631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example 4" ], "previous_source": "", "target": [ "Ejemplo 4" ], "id_hash": -4662874895325839425, "content_hash": -4662874895325839425, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id71616252395407\nhelp.text", "note": "GFADM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99098544/?format=api", "priority": 100, "id": 100424471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3f4a23fcd8043fbf", "url": "https://translations.documentfoundation.org/api/units/100424471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.551558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edad</emph>" ], "id_hash": -5269598212477428295, "content_hash": -5269598212477428295, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616252413665\nhelp.text", "note": "kNw3F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098591/?format=api", "priority": 100, "id": 100424473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=36dea058643fddb9", "url": "https://translations.documentfoundation.org/api/units/100424473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.552715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edad</emph>" ], "id_hash": -2346374291651790593, "content_hash": -2346374291651790593, "location": "04060101.xhp", "context": "04060101.xhp\npar_id431616252540783\nhelp.text", "note": "QPqDb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098622/?format=api", "priority": 100, "id": 100424476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5f7001036bfc78ff", "url": "https://translations.documentfoundation.org/api/units/100424476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.553864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In this example the search criteria area contains two occurrences of the same heading. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are aged between 8 and 10 (inclusive). The value 6 is returned (counting Andy, Betty, Charles, Eva, Harry, and Irene)." ], "previous_source": "", "target": [ "En este ejemplo, el área de criterios de búsqueda contiene dos ocurrencias del mismo título. Como hay dos condiciones en la misma fila, estas están conectadas por Y (AND). Con la tabla de la base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=BDCONTAR(A1:E10;;B12:C13)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan tienen entre 8 y 10 años (inclusive). Devolverá el valor 6 (Andrés, Beatriz, Carlos, Eva, Henrique e Irene)." ], "id_hash": -2146421101149350830, "content_hash": -2146421101149350830, "location": "04060101.xhp", "context": "04060101.xhp\npar_id991616252981928\nhelp.text", "note": "6Dk9D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/99098658/?format=api", "priority": 100, "id": 100424478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6236616177971452", "url": "https://translations.documentfoundation.org/api/units/100424478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.555083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example 5" ], "previous_source": "", "target": [ "Ejemplo 5" ], "id_hash": -324658860970524845, "content_hash": -324658860970524845, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id561616253067881\nhelp.text", "note": "vgeRe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99098686/?format=api", "priority": 100, "id": 100424482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7b7e947c6eab3f53", "url": "https://translations.documentfoundation.org/api/units/100424482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.557040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "<emph>Nombre</emph>" ], "id_hash": -2193654779250235911, "content_hash": -2193654779250235911, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616253073598\nhelp.text", "note": "yvXQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098725/?format=api", "priority": 100, "id": 100424485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=618e9299caf3a5f9", "url": "https://translations.documentfoundation.org/api/units/100424485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.558298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "This simple example shows the use of wildcards. For this example to work as intended, select to enable wildcards at <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letter “F”. The value 1 is returned (counting Frank)." ], "previous_source": "", "target": [ "Este sencillo ejemplo muestra el uso de comodines. Para que este ejemplo funcione como se pretende, seleccione activar los comodines en <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferencias</menuitem></caseinline><defaultinline><menuitem>Herramientas - Opciones</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calcular</menuitem></link>. Con la tabla de base de datos del ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item>en una celda vacía en cualquier lugar de la hoja para contar cuántos de los huéspedes de Joe tienen nombres que empiezan por la letra \"F\". Se devuelve el valor 1 (contando a Frank)." ], "id_hash": -5258611072821394625, "content_hash": -5258611072821394625, "location": "04060101.xhp", "context": "04060101.xhp\npar_id91616253394127\nhelp.text", "note": "VWsGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 79, "source_unit": "https://translations.documentfoundation.org/api/units/99098755/?format=api", "priority": 100, "id": 100424487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3705a917308b833f", "url": "https://translations.documentfoundation.org/api/units/100424487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.559617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example 6" ], "previous_source": "", "target": [ "Ejemplo 6" ], "id_hash": 4840185821901800294, "content_hash": 4840185821901800294, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id121616253593255\nhelp.text", "note": "BAnVJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99098801/?format=api", "priority": 100, "id": 100424491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c32bcb5c5156c366", "url": "https://translations.documentfoundation.org/api/units/100424491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.561660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "<emph>Nombre</emph>" ], "id_hash": -7954698572275290402, "content_hash": -7954698572275290402, "location": "04060101.xhp", "context": "04060101.xhp\npar_id731616253599063\nhelp.text", "note": "3RcET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098840/?format=api", "priority": 100, "id": 100424493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=119b3bcb58396ede", "url": "https://translations.documentfoundation.org/api/units/100424493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.562715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "This simple example shows the use of regular expressions. For this example to work as intended, select to enable regular expressions at <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and Charles)." ], "previous_source": "", "target": [ "Este sencillo ejemplo muestra el uso de expresiones regulares. Para que este ejemplo funcione como se pretende, seleccione activar las expresiones regulares en<link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferencias</menuitem></caseinline><defaultinline><menuitem>Herramienas - Opciones</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calcular</menuitem></link>. Con la tabla de base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> en una celda vacía en cualquier lugar de la hoja para contar cuántos de las visitas de Joe tienen nombres que empiezan por las letras \"A\", \"B\" o \"C\". Se devuelve el valor 3 (contando a Andy, Betty y Charles)." ], "id_hash": -48402918406530684, "content_hash": -48402918406530684, "location": "04060101.xhp", "context": "04060101.xhp\npar_id631616253692350\nhelp.text", "note": "uLJQe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 87, "source_unit": "https://translations.documentfoundation.org/api/units/99098856/?format=api", "priority": 100, "id": 100424495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7f5409cd5a495984", "url": "https://translations.documentfoundation.org/api/units/100424495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.563824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>BDCONTAR función</bookmark_value><bookmark_value>recuento de filas;con valores numéricos</bookmark_value>" ], "id_hash": -4283882863480380764, "content_hash": -4283882863480380764, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150882\nhelp.text", "note": "KBZPC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99098880/?format=api", "priority": 100, "id": 100424499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/100424499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.565914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DCOUNT" ], "previous_source": "", "target": [ "BDCONTAR" ], "id_hash": 6491962665610057081, "content_hash": 6491962665610057081, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150882\nhelp.text", "note": "DLGGD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99098889/?format=api", "priority": 100, "id": 100424502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=da1815a602c91579", "url": "https://translations.documentfoundation.org/api/units/100424502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.567075Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBANZAHL\">DCOUNT counts the number of cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> However, if no column is specified, DCOUNT returns the count of all records that match the specified search criteria irrespective of their contents." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBANZAHL\">BDCONTAR cuenta el número de celdas (campos) de la columna especificada que contienen valores numéricos, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados. </ahelp>Sin embargo, si no se especifica ninguna columna, BDCONTAR devuelve el recuento de todos los registros que coinciden con los criterios de búsqueda especificados, independientemente de su contenido." ], "id_hash": 1483139158921304215, "content_hash": 1483139158921304215, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156133\nhelp.text", "note": "RAGuV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99098915/?format=api", "priority": 100, "id": 100424505, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=94952b34fff9d897", "url": "https://translations.documentfoundation.org/api/units/100424505/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.754544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DCOUNT(Database; [DatabaseField]; SearchCriteria)" ], "previous_source": "", "target": [ "BDCONTAR(BaseDeDatos; [CampoDeBaseDeDatos]; CriteriosDeBúsqueda)" ], "id_hash": 7836394680376233599, "content_hash": 7836394680376233599, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153218\nhelp.text", "note": "EetM7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99098942/?format=api", "priority": 100, "id": 100424508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ecc077715b960e7f", "url": "https://translations.documentfoundation.org/api/units/100424508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.757216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)." ], "previous_source": "", "target": [ "La tabla de la base de datos del ejemplo que nos da información sobre los invitados a la fiesta de cumpleaños de Juan (descrita anteriormente) debería ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico a las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, a excepción de la celda D13 que debe contener \">600\" (este criterio de búsqueda coincidirá con los registros en la tabla de la base de datos que tengan un valor superior a 600 en la columna Distancia)." ], "id_hash": -4908936595083014625, "content_hash": -4908936595083014625, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153623\nhelp.text", "note": "KYvAJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 75, "source_unit": "https://translations.documentfoundation.org/api/units/99098963/?format=api", "priority": 100, "id": 100424511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3bdff42ce9294e1f", "url": "https://translations.documentfoundation.org/api/units/100424511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.759123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DCOUNT(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned." ], "previous_source": "", "target": [ "Inserte la fórmula <input>=BDCONTAR(A1:E10;; A12:E13)</input> en una celda vacía en otra parte de la hoja para calcular cuántos de los invitados a la fiesta de Juan viajan más de 600 metros a la escuela. Devolverá el valor 5." ], "id_hash": 8615944371971135905, "content_hash": 8615944371971135905, "location": "04060101.xhp", "context": "04060101.xhp\npar_id441616368480646\nhelp.text", "note": "kVciZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99098991/?format=api", "priority": 100, "id": 100424514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f791fbc1cfdd99a1", "url": "https://translations.documentfoundation.org/api/units/100424514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.761539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; \"Distance\"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; \"Name\"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric." ], "previous_source": "", "target": [ "Se obtiene el mismo resultado si usa la fórmula <input>=BDCONTAR(A1:E10; \"Distancia\"; A12:E13)</input>, porque todas las entradas en la columna distancia son numéricas. Sin embargo, si se usa la fórmula <input>=BDCONTAR(A1:E10; \"Nombre\"; A12:E13)</input>, devuelve el valor 0 porque todas las entradas en la columna nombre no son numéricas." ], "id_hash": 4818335463995276433, "content_hash": 4818335463995276433, "location": "04060101.xhp", "context": "04060101.xhp\npar_id361616368488119\nhelp.text", "note": "UZFcp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99099025/?format=api", "priority": 100, "id": 100424517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c2de2a936c1afc91", "url": "https://translations.documentfoundation.org/api/units/100424517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.763577Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDCONTARA</bookmark_value><bookmark_value>registros; conteo en bases de datos Calc</bookmark_value><bookmark_value>contar filas; con valores numéricos o alfanuméricos</bookmark_value>" ], "id_hash": -1670587375212033188, "content_hash": -1670587375212033188, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3156123\nhelp.text", "note": "tGFyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99099038/?format=api", "priority": 100, "id": 100424520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/100424520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.765622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DCOUNTA" ], "previous_source": "", "target": [ "BDCONTARA" ], "id_hash": -5740492071699703142, "content_hash": -5740492071699703142, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3156123\nhelp.text", "note": "aJdyL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099055/?format=api", "priority": 100, "id": 100424523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3055ace00e649a9a", "url": "https://translations.documentfoundation.org/api/units/100424523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.767596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBANZAHL2\">DCOUNTA counts the number of cells (fields) of the specified column that are not blank, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells of the specified column are not counted. However, if no column is specified, DCOUNTA returns the count of all records that match the specified search criteria irrespective of their contents." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBANZAHL2\">BDCONTARA cuenta el número de celdas (campos) de la columna especificada que no están en blanco, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Las celdas en blanco de la columna especificada no se cuentan. Sin embargo, si no se especifica ninguna columna, BDCONTARA hace el recuento de todos los registros que coinciden con los criterios de búsqueda especificados, independientemente de su contenido." ], "id_hash": 7270039479559557665, "content_hash": 7270039479559557665, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156110\nhelp.text", "note": "T7ebL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/99099072/?format=api", "priority": 100, "id": 100424527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e4e45e636a369221", "url": "https://translations.documentfoundation.org/api/units/100424527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.769193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DCOUNTA(Database; [DatabaseField]; SearchCriteria)" ], "previous_source": "", "target": [ "BDCONTARA(BaseDeDatos;[CampoDeBaseDeDatos];CriteriosDeBúsqueda)" ], "id_hash": -6880415476483424408, "content_hash": -6880415476483424408, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3146893\nhelp.text", "note": "CxWGV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099083/?format=api", "priority": 100, "id": 100424531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2083da94011aff68", "url": "https://translations.documentfoundation.org/api/units/100424531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.771567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">600\" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">600\" (este criterio de búsqueda coincidirá con los registros de la tabla de la base de datos que tengan un valor superior a 600 en la columna Distancia)." ], "id_hash": -5841457304444537664, "content_hash": -5841457304444537664, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153982\nhelp.text", "note": "dLvi2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 75, "source_unit": "https://translations.documentfoundation.org/api/units/99099107/?format=api", "priority": 100, "id": 100424535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2eeef987edf8f4c0", "url": "https://translations.documentfoundation.org/api/units/100424535/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.773518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DCOUNTA(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned." ], "previous_source": "", "target": [ "Inserte la fórmula <input>=BDCONTARA(A1:E10;; A12:E13)</input> en una celda vacía en otra parte de la hoja para calcular cuántos de los invitados a la fiesta de Juan viajan más de 600 metros a la escuela. Devolverá el valor 5." ], "id_hash": 766938552696551172, "content_hash": 766938552696551172, "location": "04060101.xhp", "context": "04060101.xhp\npar_id61616368616093\nhelp.text", "note": "SSD7D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99099142/?format=api", "priority": 100, "id": 100424540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8aa4b68cde07b704", "url": "https://translations.documentfoundation.org/api/units/100424540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.775755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; \"Distance\"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; \"Name\"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument." ], "previous_source": "", "target": [ "Se obtiene el mismo resultado si utiliza la fórmula <input>=BDCONTARA(A1:E10; \"Distancia\"; A12:E13)</input> o la fórmula <input>=BDCONTARA(A1:E10; \"Nombre\"; A12 :E13)</input>. El último caso refleja que, a diferencia de BDCONTAR, BDCONTARA cuenta valores numéricos y alfanuméricos en la columna indicada por el argumento <emph>CampoDeBaseDeDatos</emph>." ], "id_hash": 7257426684067171338, "content_hash": 7257426684067171338, "location": "04060101.xhp", "context": "04060101.xhp\npar_id841616368623207\nhelp.text", "note": "WyEGc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99099149/?format=api", "priority": 100, "id": 100424543, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e4b78f1e1f43cc0a", "url": "https://translations.documentfoundation.org/api/units/100424543/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.778067Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDEXTRAER</bookmark_value><bookmark_value>contenido de las celdas; búsqueda en bases de datos Calc</bookmark_value><bookmark_value>búsqueda; contenido de las celdas en bases de datos Calc</bookmark_value>" ], "id_hash": 746247400884686976, "content_hash": 746247400884686976, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3147256\nhelp.text", "note": "GasLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99099161/?format=api", "priority": 100, "id": 100424546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/100424546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.780237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DGET" ], "previous_source": "", "target": [ "BDEXTRAER" ], "id_hash": 2113816338668624127, "content_hash": 2113816338668624127, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3147256\nhelp.text", "note": "wj7ck", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099162/?format=api", "priority": 100, "id": 100424550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9d55c8c2b2c298ff", "url": "https://translations.documentfoundation.org/api/units/100424550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.782314Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBAUSZUG\">DGET returns the contents of the cell (field) of the specified column, for the single row (database record) that matches the specified search criteria.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBAUSZUG\">BDEXTRAER devuelve el contenido de la celda (campo) de la columna especificada, para la única fila (registro de la base de datos) que coincide con los criterios de búsqueda especificados.</ahelp>" ], "id_hash": -8754729041208694592, "content_hash": -8754729041208694592, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152801\nhelp.text", "note": "WwRCV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99099163/?format=api", "priority": 100, "id": 100424556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0680f45251f5a8c0", "url": "https://translations.documentfoundation.org/api/units/100424556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.786606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Calc reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE! error (wrong data type) if no matches are found. A #VALUE! error is also reported if a single match is found but the relevant cell is empty." ], "previous_source": "", "target": [ "Calc emite el Err:502 (argumento no válido) si se encuentran varias coincidencias, o bien, un error #¡VALOR! (tipo de datos incorrecto) si no se encuentran coincidencias. También se devuelve un error #¡VALOR! si se encuentra una sola coincidencia pero la celda correspondiente está vacía." ], "id_hash": 4751847368264665738, "content_hash": 4751847368264665738, "location": "04060101.xhp", "context": "04060101.xhp\npar_id171616180137385\nhelp.text", "note": "GxBWY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99099183/?format=api", "priority": 100, "id": 100424559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c1f1f4014c4a4a8a", "url": "https://translations.documentfoundation.org/api/units/100424559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.788808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DGET(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDEXTRAER(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)" ], "id_hash": 4860280775107388463, "content_hash": 4860280775107388463, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154696\nhelp.text", "note": "oFi8J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099213/?format=api", "priority": 100, "id": 100424563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c3732f9d34efa42f", "url": "https://translations.documentfoundation.org/api/units/100424563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.790901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain \"11\" (this search criterion will match records in the database table that have a value of 11 in the Age column)." ], "previous_source": "", "target": [ "La tabla de base de datos de ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda C13 que debe contener \"11\" (este criterio de búsqueda coincidirá con los registros de la tabla de la base de datos que tengan un valor de 11 en la columna edad)." ], "id_hash": 6083915940761712785, "content_hash": 6083915940761712785, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155388\nhelp.text", "note": "G2EsJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/99099230/?format=api", "priority": 100, "id": 100424566, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d46e69506c703891", "url": "https://translations.documentfoundation.org/api/units/100424566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.792592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the name of Joe’s party guest who is age 11. The name Daniel is returned." ], "previous_source": "", "target": [ "Inserta la fórmula <input>=BDEXTRAER(A1:E10; \"Nombre\"; A12:E13)</input> en una celda vacía en otro lugar de la hoja para encontrar el nombre del invitado a la fiesta de Joe que tiene 11 años. Nos devolverá el nombre de Daniel." ], "id_hash": 1756185399227638645, "content_hash": 1756185399227638645, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153096\nhelp.text", "note": "A942C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99099251/?format=api", "priority": 100, "id": 100424571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=985f3950e0b0e375", "url": "https://translations.documentfoundation.org/api/units/100424571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.794817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10)." ], "previous_source": "", "target": [ "Si cambia el valor de la celda C13 a «10», la fórmula <input>=BDEXTRAER(A1:E10; \"Nombre\"; A12:E13)</input> devuelve un error de argumento no válido (Err:502). Refleja que varios registros coinciden con el criterio especificado (tanto Beatriz como Carlos tienen 10 años)." ], "id_hash": 8525727055743563041, "content_hash": 8525727055743563041, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150524\nhelp.text", "note": "6AKoj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99099276/?format=api", "priority": 100, "id": 100424576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f651779601883521", "url": "https://translations.documentfoundation.org/api/units/100424576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.796795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BDMAX</bookmark_value><bookmark_value>valores máximos en bases de datos de Calc</bookmark_value><bookmark_value>buscar;valores máximos en columnas</bookmark_value>" ], "id_hash": 6067482821286383874, "content_hash": 6067482821286383874, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3149766\nhelp.text", "note": "rB9Ek", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99099302/?format=api", "priority": 100, "id": 100424581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d434077aa38f5102", "url": "https://translations.documentfoundation.org/api/units/100424581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.798749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DMAX" ], "previous_source": "", "target": [ "BDMAX" ], "id_hash": 5319420635195521008, "content_hash": 5319420635195521008, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3149766\nhelp.text", "note": "MDBf2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99099336/?format=api", "priority": 100, "id": 100424585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c9d260e25bb637f0", "url": "https://translations.documentfoundation.org/api/units/100424585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.800161Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMAX\">DMAX calculates the maximum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DBMAX\">BDMAX calcula el valor máximo en todas las celdas (campos) de la columna especificada que contienen valores numéricos, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> No se incluyen las celdas en blanco ni las que contienen caracteres no numéricos." ], "id_hash": 5866006761851499666, "content_hash": 5866006761851499666, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154903\nhelp.text", "note": "9ek2J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99099349/?format=api", "priority": 100, "id": 100424588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d1683e120a32b492", "url": "https://translations.documentfoundation.org/api/units/100424588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.801194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "Devuelve 0 si no se encuentran coincidencias o si no hay valores numéricos distintos de cero en las celdas de la columna especificada para los registros coincidentes." ], "id_hash": 461198565969660414, "content_hash": 461198565969660414, "location": "04060101.xhp", "context": "04060101.xhp\npar_id51616180409281\nhelp.text", "note": "pUGwd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99099350/?format=api", "priority": 100, "id": 100424592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=866681a6f78a89fe", "url": "https://translations.documentfoundation.org/api/units/100424592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.802592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DMAX(Database; DatabaseField; SearchCriteria)" ], "previous_source": "", "target": [ "BDMAX(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)" ], "id_hash": -6365429543769971486, "content_hash": -6365429543769971486, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3159157\nhelp.text", "note": "ho2GW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99099380/?format=api", "priority": 100, "id": 100424595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=27a9738e30d064e2", "url": "https://translations.documentfoundation.org/api/units/100424595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.803717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">0\" (este criterio de búsqueda pretende coincidir con todos los registros de la tabla de la base de datos)." ], "id_hash": 171330541003347509, "content_hash": 171330541003347509, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148442\nhelp.text", "note": "S57iG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99099383/?format=api", "priority": 100, "id": 100424599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8260b03823ae1635", "url": "https://translations.documentfoundation.org/api/units/100424599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.804784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Insert the formula <input>=DMAX(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned." ], "previous_source": "", "target": [ "Inserte la fórmula <input>=BDMAX(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía en otra parte de la hoja para encontrar la distancia máxima en metros que recorre cualquiera de los invitados a la fiesta de Juan hasta a la escuela. Devolverá el valor 1200." ], "id_hash": 4686675797043308700, "content_hash": 4686675797043308700, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148804\nhelp.text", "note": "Mqocw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99099384/?format=api", "priority": 100, "id": 100424602, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c10a6ace6c2fe89c", "url": "https://translations.documentfoundation.org/api/units/100424602/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.806170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función BDMIN</bookmark_value><bookmark_value>valores mínimos en bases de datos de Calc</bookmark_value><bookmark_value>búsqueda;valores mínimos en columnas</bookmark_value>" ], "id_hash": -7229204091064779011, "content_hash": -7229204091064779011, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159141\nhelp.text", "note": "CnaXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99099423/?format=api", "priority": 100, "id": 100424606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1bacb52e5f487efd", "url": "https://translations.documentfoundation.org/api/units/100424606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:42.807456Z" } ] }