Changes
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/changes/?format=api&page=159
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=160", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=158", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100424625/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733348Z", "action": 59, "target": "Inserta la fórmula <input>=BDMIN(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la distancia mínima en metros que recorre cualquiera de los invitados a la fiesta de Joe hasta la escuela. Nos devolverá el valor 150.", "id": 37822667, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822667/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424622/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733295Z", "action": 59, "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": 37822666, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822666/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424619/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733245Z", "action": 59, "target": "BDMIN(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)", "id": 37822665, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822665/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424616/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733195Z", "action": 59, "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": 37822664, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822664/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424612/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733144Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBMIN\">BDMIN calcula el valor mínimo 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": 37822663, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822663/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424609/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733094Z", "action": 59, "target": "BDMIN", "id": 37822662, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822662/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424606/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.733043Z", "action": 59, "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": 37822661, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822661/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424602/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732991Z", "action": 59, "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": 37822660, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822660/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424599/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732939Z", "action": 59, "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": 37822659, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822659/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424595/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732890Z", "action": 59, "target": "BDMAX(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)", "id": 37822658, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822658/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424592/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732841Z", "action": 59, "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": 37822657, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822657/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424588/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732806Z", "action": 59, "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": 37822656, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822656/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424585/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732779Z", "action": 59, "target": "BDMAX", "id": 37822655, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822655/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424581/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732752Z", "action": 59, "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": 37822654, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822654/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424576/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732724Z", "action": 59, "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": 37822653, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822653/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424571/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732696Z", "action": 59, "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": 37822652, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822652/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424566/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732667Z", "action": 59, "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": 37822651, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822651/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424563/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732639Z", "action": 59, "target": "BDEXTRAER(BaseDeDatos; CampoDeBaseDeDatos; CriteriosDeBúsqueda)", "id": 37822650, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822650/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424559/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732611Z", "action": 59, "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": 37822649, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822649/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424556/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732575Z", "action": 59, "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": 37822648, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822648/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424550/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732528Z", "action": 59, "target": "BDEXTRAER", "id": 37822647, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822647/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424546/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732479Z", "action": 59, "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": 37822646, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822646/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424543/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732426Z", "action": 59, "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": 37822645, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822645/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424540/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732374Z", "action": 59, "target": "Inserta la fórmula <input>=BDCONTARA(A1:E10;; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular cuántos de los invitados a la fiesta de Joe viajan más de 600 metros hasta la escuela. Nos devolverá el valor 5.", "id": 37822644, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822644/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424535/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732324Z", "action": 59, "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": 37822643, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822643/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424531/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732273Z", "action": 59, "target": "BDCONTARA(BaseDeDatos;[CampoDeBaseDeDatos];CriteriosDeBúsqueda)", "id": 37822642, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822642/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424527/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732221Z", "action": 59, "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": 37822641, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822641/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424523/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732170Z", "action": 59, "target": "BDCONTARA", "id": 37822640, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822640/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424520/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732119Z", "action": 59, "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": 37822639, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822639/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424517/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732067Z", "action": 59, "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": 37822638, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822638/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424514/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.732016Z", "action": 59, "target": "Añada 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. Arrojara el valor 5.", "id": 37822637, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822637/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424511/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731963Z", "action": 59, "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": 37822636, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822636/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424508/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731913Z", "action": 59, "target": "BDCONTAR(BaseDeDatos; [CampoDeBaseDeDatos]; CriteriosDeBúsqueda)", "id": 37822635, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822635/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424505/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731861Z", "action": 59, "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": 37822634, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822634/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424502/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731811Z", "action": 59, "target": "BDCONTAR", "id": 37822633, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822633/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424499/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731760Z", "action": 59, "target": "<bookmark_value>BDCONTAR función</bookmark_value><bookmark_value>recuento de filas;con valores numéricos</bookmark_value>", "id": 37822632, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822632/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424495/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731706Z", "action": 59, "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": 37822631, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822631/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424493/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731666Z", "action": 59, "target": "<emph>Nombre</emph>", "id": 37822630, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822630/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424491/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731639Z", "action": 59, "target": "Ejemplo 6", "id": 37822629, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822629/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424487/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731608Z", "action": 59, "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": 37822628, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822628/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424485/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731582Z", "action": 59, "target": "<emph>Nombre</emph>", "id": 37822627, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822627/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424482/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731554Z", "action": 59, "target": "Ejemplo 5", "id": 37822626, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822626/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424478/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731522Z", "action": 59, "target": "En este ejemplo, el área de criterios de búsqueda contiene dos apariciones del mismo título. Como hay dos condiciones en la misma fila, éstas están conectadas por AND. Con la tabla de base de datos del ejemplo anterior y esta área de criterios de búsqueda, inserta la fórmula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> en una celda vacía en otro lugar de la hoja para contar cuántos de los invitados de Joe tienen entre 8 y 10 años (inclusive). Se devuelve el valor 6 (contando a Andy, Betty, Charles, Eva, Harry e Irene).", "id": 37822625, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822625/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424476/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731481Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822624, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822624/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424473/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731433Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822623, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822623/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424471/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731384Z", "action": 59, "target": "Ejemplo 4", "id": 37822622, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822622/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424467/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731330Z", "action": 59, "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": 37822621, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822621/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424464/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731279Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822620, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822620/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424461/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731228Z", "action": 59, "target": "Ejemplo 3", "id": 37822619, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822619/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424457/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:34.731175Z", "action": 59, "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": 37822618, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822618/?format=api" } ] }