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=42
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=43", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=41", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100445894/?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:37.781354Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR.MAT(3.45; -3)</input> devuelve 6.", "id": 37832528, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832528/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445891/?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:37.781329Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR.MAT(3.45)</input> devuelve 4.", "id": 37832527, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832527/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445888/?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:37.781303Z", "action": 59, "target": "<emph>Modo</emph> (opcional) es un número, o una referencia a una celda que contiene un número. Si <emph>Modo</emph> se da y no es igual a cero, un <emph>Número</emph> negativo se redondea hacia abajo (lejos de cero). Si <emph>Modo</emph> es igual a cero o no se da, un <emph>Número</emph> negativo se redondea hacia arriba (hacia el cero).", "id": 37832526, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832526/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445886/?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:37.781277Z", "action": 59, "target": "<emph>Significatividad</emph> (opcional) es el valor, o bien, una referencia a una celda que lo contenga, a cuyo múltiplo el <emph>Número</emph> debe redondearse. El valor predeterminado es 1.", "id": 37832525, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832525/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445883/?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:37.781252Z", "action": 59, "target": "MULTIPLO.SUPERIOR.MAT(Número [; Significatividad [; Modo]])", "id": 37832524, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832524/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445882/?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:37.781227Z", "action": 59, "target": "Esta función existe por razones de interoperatividad con Microsoft Excel, versión 2013 o más reciente.", "id": 37832523, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832523/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445880/?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:37.781201Z", "action": 59, "target": "Para un número positivo, la función redondea al alza (alejándose de cero). Para un número negativo, la dirección del redondeo queda determinada por el valor de un parámetro de modo. Se pasa por alto el signo del valor de la significatividad.", "id": 37832522, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832522/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445878/?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:37.781175Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Redondea un número al múltiplo más cercano de un valor significativo. </ahelp>", "id": 37832521, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832521/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445877/?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:37.781150Z", "action": 59, "target": "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\">MULTIPLO.SUPERIOR.MAT</link></variable>", "id": 37832520, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832520/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445875/?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:37.781125Z", "action": 59, "target": "<bookmark_value>Función MULTIPLO.SUPERIOR.MAT</bookmark_value>", "id": 37832519, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832519/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445873/?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:37.781099Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR.EXACTO(-45.67; 2)</input> devuelve -44.", "id": 37832518, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832518/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445871/?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:37.781073Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR.EXACTO(3.45)</input> devuelve 4.", "id": 37832517, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832517/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445869/?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:37.781048Z", "action": 59, "target": "<emph>Significatividad</emph> (opcional) es el valor, o bien, una referencia a una celda que lo contenga, a cuyo múltiplo el <emph>Número</emph> debe redondearse. El valor predeterminado es 1.", "id": 37832516, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832516/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445866/?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:37.781023Z", "action": 59, "target": "MULTIPLO.SUPERIOR.EXACTO(Número [; Significatividad])", "id": 37832515, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832515/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445865/?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:37.780997Z", "action": 59, "target": "Esta función calcula resultados idénticos a la función <link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">MULTIPLO.SUPERIOR.ISO</link>.", "id": 37832514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445864/?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:37.780971Z", "action": 59, "target": "Para un número positivo, la función redondea al alza (alejándose de cero). Para un número negativo, la función redondea al alza (aproximándose a cero). Se pasa por alto el signo del valor de la significatividad.", "id": 37832513, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832513/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445863/?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:37.780946Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_CEIL_MS\">Redondea al alza un número hacia el múltiplo de significatividad más próximo.</ahelp>", "id": 37832512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445861/?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:37.780921Z", "action": 59, "target": "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\">MULTIPLO.SUPERIOR.EXACTO</link></variable>", "id": 37832511, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832511/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445860/?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:37.780896Z", "action": 59, "target": "<bookmark_value>función MULTIPLO.SUPERIOR.EXACTO</bookmark_value><bookmark_value>redondear;al alza a múltiplos de significatividad</bookmark_value>", "id": 37832510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445859/?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:37.780871Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR(-45.67; -2; 1)</input> devuelve −46.", "id": 37832509, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832509/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445857/?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:37.780845Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR(-45.67; -2; 0)</input> devuelve −44.", "id": 37832508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445854/?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:37.780821Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR(-1,234)</input> devuelve −1.", "id": 37832507, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832507/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445852/?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:37.780796Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR(3,45; 3)</input> devuelve 6.", "id": 37832506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445850/?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:37.780769Z", "action": 59, "target": "<input>=MULTIPLO.SUPERIOR(3,45)</input> devuelve 4.", "id": 37832505, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832505/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445848/?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:37.780740Z", "action": 59, "target": "<emph>Modo</emph> (opcional) es un número, o una referencia a una celda que contiene un número. La función solo utiliza el <emph>Modo</emph> si tanto <emph>Número</emph> como <emph>Significatividad</emph> son negativos. Así, si <emph>Modo</emph> se da y no es igual a cero, los números se redondean a la baja (alejándose de cero); si <emph>Modo</emph> es igual a cero o no se proporciona, los números negativos se redondean al alza (aproximándose a cero).", "id": 37832504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445846/?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:37.780715Z", "action": 59, "target": "<emph>Significatividad</emph> (opcional) es el valor, o una referencia a una celda que contiene el valor, a cuyo múltiplo <emph>Número</emph> se redondeará. Su valor predeterminado es +1 o −1, en función del signo de <emph>Número</emph>.", "id": 37832503, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832503/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445844/?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:37.780689Z", "action": 59, "target": "<emph>Número</emph> es el número que se va a redondear o una referencia a una celda que contiene el número.", "id": 37832502, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832502/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445841/?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:37.780665Z", "action": 59, "target": "MULTIPLO.SUPERIOR(Número [; Significatividad [; Modo]])", "id": 37832501, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832501/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445839/?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:37.780639Z", "action": 59, "target": "Si el libro se exporta a Microsoft Excel, la función MULTIPLO.SUPERIOR se exportará como la función equivalente MULTIPLO.SUPERIOR.MAT, la cual existe desde Excel 2013. Si tiene pensado utilizar el libro con versiones anteriores de Excel, elija entre emplear MÚLTIPLO.SUPERIOR.EXACTO, disponible desde Excel 2010, o MULTIPLO.SUPERIOR.XCL, la cual se exporta como MULTIPLO.SUPERIOR, compatible con todas las versiones de Excel.", "id": 37832500, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832500/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445836/?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:37.780614Z", "action": 59, "target": "Para un número positivo y un valor de significación positivo, la función redondea hacia arriba (alejándose de cero). Para un número negativo y un valor de significación negativo, la dirección del redondeo viene determinada por el valor de un parámetro de modo. La función devuelve un error si los valores de número y significado tienen signos opuestos.s opuestos.", "id": 37832499, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832499/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445834/?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:37.780589Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_OBERGRENZE\"> Redondea un número al múltiplo más cercano de un valor significativo. </ahelp>", "id": 37832498, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832498/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445832/?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:37.780563Z", "action": 59, "target": "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">MULTIPLO.SUPERIOR</link></variable>", "id": 37832497, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832497/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445830/?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:37.780538Z", "action": 59, "target": "<bookmark_value>función MULTIPLO.SUPERIOR</bookmark_value><bookmark_value>redondear;al alza a múltiplos de significatividad</bookmark_value>", "id": 37832496, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832496/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445828/?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:37.780513Z", "action": 59, "target": "Funciones del techo", "id": 37832495, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832495/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445825/?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:37.780488Z", "action": 59, "target": "Funciones de techo", "id": 37832494, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832494/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445822/?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:37.780463Z", "action": 59, "target": "", "id": 37832493, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832493/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445820/?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:37.780438Z", "action": 59, "target": "Si E2 = pan, la función devuelve 65 porque el enlace a la celda se sustituye por su contenido.", "id": 37832492, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832492/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445817/?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:37.780413Z", "action": 59, "target": "<item type=\"input\">=PROMEDIO.SI.CONJUNTO(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37832491, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832491/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445812/?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:37.780387Z", "action": 59, "target": "Si se necesita cambiar un criterio fácilmente, se puede especificar en una celda separada y usar una referencia a esa celda en la condición de la función PROMEDIO.SI.CONJUNTO. Por ejemplo, la función anterior se puede reescribir asi:", "id": 37832490, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832490/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445811/?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:37.780362Z", "action": 59, "target": "Referencia a una celda como criterio", "id": 37832489, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832489/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445809/?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:37.780335Z", "action": 59, "target": "Calcula el promedio de los valores del intervalo C2:C6 que se correspondan con todas las celdas del intervalo A2:A6 que comienzan por «pan» y a todas las celdas del intervalo B2:B6 excepto su máximo. Devuelve 65 porque solo la segunda fila cumple con todos los criterios.", "id": 37832488, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832488/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445807/?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:37.780310Z", "action": 59, "target": "<item type=\"input\">PROMEDIO.SI.CONJUNTO(C2:C6;A2:A6;\"pan.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37832487, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832487/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445805/?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:37.780282Z", "action": 59, "target": "Calcula el promedio de los valores en el intervalo C2:C6 que se correspondan con todos los valores en el intervalo B2:B6, exceptuando el menor y el mayor. Devuelve 127,5, porque las filas tercera y quinta no cumplen con por lo menos un criterio.", "id": 37832486, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832486/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445803/?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:37.780251Z", "action": 59, "target": "<item type=\"input\">=PROMEDIO.SI.CONJUNTO(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37832485, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832485/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445800/?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:37.780226Z", "action": 59, "target": "Uso de expresiones regulares y funciones anidadas", "id": 37832484, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832484/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445798/?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:37.780200Z", "action": 59, "target": "Calcula el promedio de los valores en el intervalo C2:C6 que sean mayores que 70 y se correspondan con las celdas en B2:B6 con valores mayores o iguales que 20. Devuelve 137,5, porque las filas segunda y quinta no cumplen con por lo menos un criterio.", "id": 37832483, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832483/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445795/?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:37.780175Z", "action": 59, "target": "<item type=\"input\">=PROMEDIO.SI.CONJUNTO(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>", "id": 37832482, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832482/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445792/?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:37.780150Z", "action": 59, "target": "Calcula el promedio de los valores del intervalo B2:B6 que sean mayores o iguales a 20. Devuelve 25 porque la quinta fila no cumple con el criterio.", "id": 37832481, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832481/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445790/?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:37.780125Z", "action": 59, "target": "<item type=\"input\">=PROMEDIO.SI.CONJUNTO(B2:B6;B2:B6;\">=20\")</item>", "id": 37832480, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832480/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100445788/?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:37.780100Z", "action": 59, "target": "Uso simple", "id": 37832479, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37832479/?format=api" } ] }