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=36
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=37", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=35", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100446548/?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:38.775357Z", "action": 59, "target": "<item type=\"input\">=SIFECHA(\"1974-04-17\";\"2012-06-13\";\"d\")</item> devuelve 13937: ha vivido 13 937 días.", "id": 37833329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446546/?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:38.775318Z", "action": 59, "target": "<item type=\"input\">=SIFECHA(FECHA(1974,4,17);\"2012-06-13\";\"m\")</item> devuelve 457: ha vivido 457 meses.", "id": 37833328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446544/?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:38.775277Z", "action": 59, "target": "Por tanto, tiene 38 años, 1 mes y 27 días de edad.", "id": 37833327, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833327/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446541/?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:38.775237Z", "action": 59, "target": "<item type=\"input\">=SIFECHA(\"1974-04-17\";\"2012-06-13\";\"md\")</item> devuelve 27.", "id": 37833326, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833326/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446539/?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:38.775196Z", "action": 59, "target": "<item type=\"input\">=SIFECHA(\"1974-04-17\";\"2012-06-13\";\"ym\")</item> devuelve 1.", "id": 37833325, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833325/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446536/?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:38.775098Z", "action": 59, "target": "<item type=\"input\">=SIFECHA(\"1974-04-17\";\"2012-06-13\";\"y\")</item> devuelve 38.", "id": 37833324, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833324/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446534/?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:38.775060Z", "action": 59, "target": "Cálculo del cumpleaños. Un hombre nació el 17 de abril de 1974. Hoy es 13 de junio de 2012.", "id": 37833323, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833323/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446532/?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:38.775021Z", "action": 59, "target": "Número de días completos al restar los años de la diferencia entre la Fecha de inicio y la Fecha de finalización.", "id": 37833322, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833322/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446530/?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:38.774982Z", "action": 59, "target": "Número de días completos al restar los años y los meses de la diferencia entre la Fecha de inicio y la Fecha de finalización.", "id": 37833321, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833321/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446528/?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:38.774943Z", "action": 59, "target": "Número de meses completos al restar los años de la diferencia entre la Fecha de inicio y la Fecha de finalización.", "id": 37833320, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833320/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446525/?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:38.774904Z", "action": 59, "target": "Número de años completos entre Fecha de inicio y Fecha de finalización.", "id": 37833319, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833319/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446522/?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:38.774866Z", "action": 59, "target": "Número de meses completos entre Fecha de inicio y Fecha de finalización.", "id": 37833318, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833318/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446521/?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:38.774827Z", "action": 59, "target": "Número de días completos entre Fecha de inicio y Fecha de finalización.", "id": 37833317, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833317/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446519/?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:38.774788Z", "action": 59, "target": "Valor devuelto", "id": 37833316, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833316/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446517/?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:38.774748Z", "action": 59, "target": "Valor para «Intervalo»", "id": 37833315, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833315/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446515/?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:38.774704Z", "action": 59, "target": "<emph>Intervalo</emph> es una cadena que determina cómo se calculará la diferencia. Los valores posibles son \"d\", \"m\", \"y\", \"ym\", \"md\" o \"yd\", independientemente de la configuración actual del idioma.", "id": 37833314, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833314/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446513/?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:38.774665Z", "action": 59, "target": "<emph>Fecha final</emph> es la fecha final para el cálculo. La fecha final debe ser posterior a la fecha inicial.", "id": 37833313, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833313/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446512/?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:38.774626Z", "action": 59, "target": "<emph>Fecha de inicio</emph> es la fecha a partir de la cual el cálculo se lleva a cabo.", "id": 37833312, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833312/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446511/?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:38.774587Z", "action": 59, "target": "<input>SIFECHA(Fecha de inicio; Fecha de finalización; Intervalo)</input>", "id": 37833311, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833311/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446510/?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:38.774546Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DATEDIF\">Esta función devuelve el número de días, meses o años completos entre la fecha de inicio y la fecha de fin.</ahelp><br>(En español, un nombre más apropiado para esta función podría ser «DIF.FECHAS»; sin embargo, se mantiene el <link href=\"https://books.google.com/books?id=9mqg1CZRLdsC&pg=PA86\">nombre histórico empleado en Microsoft Excel</link> por razones de interoperatividad.)", "id": 37833310, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833310/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446509/?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:38.774507Z", "action": 59, "target": "<variable id=\"datedif\"><link href=\"text/scalc/01/func_datedif.xhp\">SIFECHA</link></variable>", "id": 37833309, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833309/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446508/?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:38.774467Z", "action": 59, "target": "<bookmark_value>función SIFECHA</bookmark_value>", "id": 37833308, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833308/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446507/?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:38.774428Z", "action": 59, "target": "SIFECHA", "id": 37833307, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833307/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446505/?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:38.774388Z", "action": 59, "target": "", "id": 37833306, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833306/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446503/?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:38.774349Z", "action": 59, "target": "<item type=\"input\">=FECHA(00;1;31)</item> emite 1/31/00 si la configuración de formato de la celda es MM/DD/AA.", "id": 37833305, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833305/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446501/?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:38.774309Z", "action": 59, "target": "Si los valores del mes y del día sobrepasan los límites, se sumarán al próximo dígito. Si escribe <item type=\"input\">=FECHA(00;12;31)</item> el resultado será 2000-12-31. Si, por el contrario, escribe <item type=\"input\">=FECHA(00;13;31)</item> el resultado será 2001-01-31.", "id": 37833304, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833304/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446499/?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:38.774270Z", "action": 59, "target": "<emph>Día</emph> es un entero que indica el día del mes.", "id": 37833303, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833303/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446497/?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:38.774232Z", "action": 59, "target": "<emph>Mes</emph> es un entero que indica el mes.", "id": 37833302, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833302/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446495/?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:38.774190Z", "action": 59, "target": "En <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME ▸ Preferencias</item></caseinline><defaultinline><item type=\"menuitem\">Herramientas ▸ Opciones</item></defaultinline></switchinline><item type=\"menuitem\"> ▸ $[officename] ▸ General </item>puede establecer desde qué año se reconocerá la introducción de un número de dos dígitos como 20xx.", "id": 37833301, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833301/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446493/?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:38.774151Z", "action": 59, "target": "<emph>Año</emph> es un entero entre 1583 y 9957 o entre 0 y 99.", "id": 37833300, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833300/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446492/?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:38.774112Z", "action": 59, "target": "FECHA(Año; Mes; Día)", "id": 37833299, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833299/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446489/?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:38.774072Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_DATUM\">Este función calcula una fecha, especificada por año, mes, día y lo muestra en el formato de la celda.</ahelp> El formato predeterminado de una celda que contiene la función DATE es el formato de fecha, pero puede formatearlo las celdas con cualquier otro formato numérico.", "id": 37833298, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833298/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446487/?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:38.774032Z", "action": 59, "target": "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">FECHA</link></variable>", "id": 37833297, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833297/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446485/?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:38.773992Z", "action": 59, "target": "<bookmark_value>FECHA</bookmark_value>", "id": 37833296, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833296/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446483/?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:38.773953Z", "action": 59, "target": "FECHA", "id": 37833295, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833295/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446481/?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:38.773913Z", "action": 59, "target": "", "id": 37833294, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833294/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446479/?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:38.773874Z", "action": 59, "target": "Si E2 = pen, la función devuelve 1, porque el enlace a la celda se sustituye por su contenido y funciona como la función anterior.", "id": 37833293, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833293/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446477/?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:38.773835Z", "action": 59, "target": "<item type=\"input\">=CONTAR.SI.CONJUNTO(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37833292, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833292/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446474/?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:38.773794Z", "action": 59, "target": "Si se necesita cambiar un criterio fácilmente, se puede especificar en una celda separada y usar la referencia a esa celda en la condición de la función CONTAR.SI.CONJUNTO. Por ejemplo, la función anterior puede reescribirse así:", "id": 37833291, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833291/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446472/?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:38.773755Z", "action": 59, "target": "Referencia a una celda como criterio", "id": 37833290, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833290/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446470/?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:38.773709Z", "action": 59, "target": "Cuenta la cantidad de filas que corresponde a todas las celdas del intervalo A2:A6 que comienzan por «cla» y a todas las celdas del intervalo B2:B6 con la excepción de su máximo. Devuelve 1 porque solo la segunda fila cumple con todos los criterios.", "id": 37833289, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833289/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446469/?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:38.773670Z", "action": 59, "target": "<item type=\"input\">=CONTAR.SI.CONJUNTO(A2:A6;\"cla.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37833288, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833288/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446466/?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:38.773630Z", "action": 59, "target": "Contabiliza las filas en el intervalo B2:B6, excluyendo las filas con los valores mínimo y máximo de este intervalo. Devuelve 2, porque las filas tercera, quinta y sexta no cumplen con por lo menos un criterio.", "id": 37833287, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833287/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446464/?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:38.773590Z", "action": 59, "target": "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37833286, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833286/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446462/?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:38.773549Z", "action": 59, "target": "Cuenta la cantidad de filas del intervalo B2:B6 que contienen solamente símbolos alfabéticos. Devuelve 1 porque solo la sexta fila cumple con el criterio.", "id": 37833285, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833285/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446460/?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:38.773510Z", "action": 59, "target": "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\"[:alpha:]*\")</item>", "id": 37833284, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833284/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446457/?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:38.773467Z", "action": 59, "target": "Para que estos ejemplos funcionen como se han descrito, asegúrese de que esté seleccionada la opción <emph>Activar expresiones regulares en fórmulas</emph>, la cual se halla en <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME ▸ Preferencias</menuitem></caseinline><defaultinline><menuitem>Herramientas ▸ Opciones</menuitem></defaultinline></switchinline><menuitem> ▸ $[officename] Calc ▸ Calcular</menuitem>.", "id": 37833283, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833283/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446454/?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:38.773427Z", "action": 59, "target": "Uso de expresiones regulares y funciones anidadas", "id": 37833282, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833282/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446451/?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:38.773387Z", "action": 59, "target": "Cuenta la cantidad de filas que contiene simultáneamente valores mayores que 70 en el intervalo C2:C6 y valores mayores o iguales que 20 en el intervalo B2:B6. Devuelve 2 porque las filas segunda, quinta y sexta no cumplen con al menos un criterio.", "id": 37833281, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833281/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100446446/?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:38.773347Z", "action": 59, "target": "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\">=20\";C2:C6;\">70\")</item>", "id": 37833280, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37833280/?format=api" } ] }