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=158
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=159", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=157", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100424791/?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.735586Z", "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 hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822717, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822717/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424789/?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.735536Z", "action": 59, "target": "BDVARP(Base de Datos; Campo de la Base de Datos; Criterios de búsqueda)", "id": 37822716, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822716/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424787/?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.735486Z", "action": 59, "target": "Devuelve el error #¡NUM! si no se corresponde ningún registro con los criterios de búsqueda dados o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822715, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822715/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424784/?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.735435Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">BDVARP calcula la variación de la población basándose en los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coincidan con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos deben ignorarse.", "id": 37822714, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822714/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424782/?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.735385Z", "action": 59, "target": "BDVARP", "id": 37822713, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822713/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424780/?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.735336Z", "action": 59, "target": "<bookmark_value>Función BDVARP</bookmark_value><bookmark_value>varianzas;basadas en poblaciones</bookmark_value>", "id": 37822712, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822712/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424778/?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.735286Z", "action": 59, "target": "Inserta la fórmula <input>=BDVAR(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la varianza muestral de las distancias en metros que los invitados a la fiesta de Joe recorren hasta la escuela. Nos devolverá el valor 193125.", "id": 37822711, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822711/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424775/?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.735234Z", "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. Debe 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 hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822710, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822710/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424773/?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.735184Z", "action": 59, "target": "BDVAR(Base de Datos; Campo de la Base de Datos; Criterios de búsqueda)", "id": 37822709, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822709/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424771/?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.735134Z", "action": 59, "target": "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822708, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822708/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424769/?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.735084Z", "action": 59, "target": "Devuelve un error #¡NUM! si un registro coincide exactamente con los criterios de búsqueda especificados, o si solo hay un valor numérico en las celdas de la columna especificada para los registros coincidentes.", "id": 37822707, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822707/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424765/?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.735034Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBVARIANZ\">BDVAR calcula la varianza de la muestra en función de los valores numéricos en las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos son ignorados.", "id": 37822706, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822706/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424761/?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.734985Z", "action": 59, "target": "BDVAR", "id": 37822705, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822705/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424758/?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.734945Z", "action": 59, "target": "<bookmark_value>Función BDVAR</bookmark_value><bookmark_value>varianzas; basadas en muestras</bookmark_value>", "id": 37822704, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822704/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424754/?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.734918Z", "action": 59, "target": "Inserta la fórmula <input>=BDSUMA(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para encontrar la distancia total en metros que recorren todos los invitados a la fiesta de Joe hasta la escuela. Nos devolverá el valor 6000.", "id": 37822703, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822703/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424750/?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.734891Z", "action": 59, "target": "La tabla de base de datos del ejemplo que da la 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 hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822702, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822702/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424747/?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.734865Z", "action": 59, "target": "BDSUM(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)", "id": 37822701, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822701/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424744/?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.734839Z", "action": 59, "target": "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822700, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822700/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424741/?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.734808Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSUMME\">BDSUMA calcula la suma de todos los valores numéricos en las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Las celdas en blanco o celdas que contienen caracteres no numéricos no están incluidas.", "id": 37822699, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822699/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424737/?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.734776Z", "action": 59, "target": "BDSUMA", "id": 37822698, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822698/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424733/?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.734728Z", "action": 59, "target": "<bookmark_value>Función BDSUMA</bookmark_value><bookmark_value>calcular;sumas en bases de datos de Calc</bookmark_value><bookmark_value>sumas;celdas en bases de datos de Calc</bookmark_value>", "id": 37822697, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822697/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424728/?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.734679Z", "action": 59, "target": "Inserta la fórmula <input>=DBDDESVESTP(A1:E10; \"Peso\"; A12:E13)</input> en una celda vacía en cualquier lugar de la hoja para calcular la desviación estándar de la población de los pesos en kg de los invitados a la fiesta de Joe. Nos devolverá el valor 5,18545.", "id": 37822696, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822696/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424724/?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.734631Z", "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. Debe asegurarse de que las celdas A13:D13 estén en blanco y que la celda E13 contenga \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822695, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822695/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424721/?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.734583Z", "action": 59, "target": "BDDESVESTP(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)", "id": 37822694, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822694/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424717/?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.734531Z", "action": 59, "target": "Devuelve el error #¡NUM! si no se corresponde ningún registro con los criterios de búsqueda dados o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822693, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822693/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424714/?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.734480Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSTDABWN\">BDDESVESTP calcula la desviación estándar de la población basándose en los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coincidan con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos se ignoran.", "id": 37822692, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822692/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424711/?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.734431Z", "action": 59, "target": "BDDESVESTP", "id": 37822691, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822691/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424707/?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.734379Z", "action": 59, "target": "<bookmark_value>función BDDESVESTP</bookmark_value><bookmark_value>desviaciones típicas en bases de datos;basadas en poblaciones</bookmark_value>", "id": 37822690, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822690/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424704/?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.734328Z", "action": 59, "target": "Inserta la fórmula <input>=BDDESVEST(A1:E10; \"Peso\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular la desviación estándar muestral de los pesos en kg de los invitados a la fiesta de Joe. Nos devolverá el valor 5,5.", "id": 37822689, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822689/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424700/?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.734276Z", "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. Debe asegurarse que las celdas A13:D13 estén en blanco y que la celda E13 contenga \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822688, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822688/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424696/?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.734227Z", "action": 59, "target": "BDDSTDEV(Base de Datos; Campo Base de Datos; Búsqueda por Criterios)", "id": 37822687, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822687/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424693/?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.734176Z", "action": 59, "target": "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822686, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822686/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424689/?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.734126Z", "action": 59, "target": "Devuelve un error #¡NUM! si un registro coincide exactamente con los criterios de búsqueda especificados, o si solo hay un valor numérico en las celdas de la columna especificada para los registros coincidentes.", "id": 37822685, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822685/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424686/?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.734075Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBSTDABW\">BDDESVEST calcula la desviación estándar de la muestra basándose en los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coincidan con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos deben ignorarse.", "id": 37822684, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822684/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424683/?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.734026Z", "action": 59, "target": "BDDESVEST", "id": 37822683, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822683/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424679/?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.733976Z", "action": 59, "target": "<bookmark_value>función BDDESVEST</bookmark_value><bookmark_value>desviaciones típicas en bases de datos; basadas en una muestra</bookmark_value>", "id": 37822682, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822682/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424675/?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.733925Z", "action": 59, "target": "Inserta la fórmula <input>=BDPRODUCTO(A1:E10; \"Antigüedad\"; A12:E13)</input> en una celda vacía de la hoja para calcular el producto de las edades en años de los invitados a la fiesta de Joe. Nos dará el valor 279417600.", "id": 37822681, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822681/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424671/?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.733874Z", "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 C13, que debe contener \">0\" (este criterio de búsqueda pretende hacer coincidir con todos los registros de la tabla de la base de datos).", "id": 37822680, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822680/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424667/?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.733838Z", "action": 59, "target": "BDPRODUCTO(BaseDeDatos; CampoBaseDeDatos; CriteriosDeBúsqueda)", "id": 37822679, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822679/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424664/?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.733812Z", "action": 59, "target": "Devuelve 0 si no se produce ninguna correspondencia o si no hay valores numéricos en las celdas de la columna especificada para los registros correspondientes.", "id": 37822678, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822678/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424660/?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.733783Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBPRODUKT\">BDPRODUCTO calcula el producto de todos los valores numéricos de las celdas (campos) de la columna especificada, 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": 37822677, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822677/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424657/?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.733757Z", "action": 59, "target": "BDPRODUCTO", "id": 37822676, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822676/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424654/?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.733731Z", "action": 59, "target": "<bookmark_value>Función BDPRODUCTO</bookmark_value><bookmark_value>multiplicar;contenido de celda en bases de datos de Calc</bookmark_value>", "id": 37822675, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822675/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424650/?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.733700Z", "action": 59, "target": "Introduzca la fórmula <input>=BDPROMEDIO(A1:E10; \"Distancia\"; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular la distancia media en metros recorrida hasta la escuela por los invitados a la fiesta de Joe. Se obtendrá el valor 666,67.", "id": 37822674, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822674/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424644/?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.733652Z", "action": 59, "target": "La tabla de la base de datos de ejemplo que proporciona información sobre los invitados a la fiesta de cumpleaños de Juan (descrita anteriormente) debe situarse en 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 «>0» (este criterio de búsqueda tiene como objetivo hacer coincidir todos los registros en la tabla de la base de datos).", "id": 37822673, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822673/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424641/?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.733603Z", "action": 59, "target": "BDPROMEDIO(Base de datos; Campo de base de datos; Criterios de búsqueda)", "id": 37822672, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822672/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424638/?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.733553Z", "action": 59, "target": "Devuelve un error #¡DIV/0! si ningún registro coincide con los criterios de búsqueda especificados, o si no hay valores numéricos en las celdas de la columna especificada para los registros coincidentes.", "id": 37822671, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822671/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424635/?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.733500Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">BDPROMEDIO calcula la media de los valores numéricos de las celdas (campos) de la columna especificada, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Los valores no numéricos de esas celdas deben ser ignorados.", "id": 37822670, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822670/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424632/?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.733450Z", "action": 59, "target": "BDPROMEDIO", "id": 37822669, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822669/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424629/?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.733399Z", "action": 59, "target": "<bookmark_value>función BDPROMEDIO</bookmark_value><bookmark_value>promedios; en bases de datos Calc</bookmark_value><bookmark_value>cálculo; medias en bases de datos Calc</bookmark_value>", "id": 37822668, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822668/?format=api" } ] }