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=20
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=21", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=19", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100448536/?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.883776Z", "action": 59, "target": "HORANUMERO", "id": 37834352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448534/?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.883728Z", "action": 59, "target": "", "id": 37834351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448532/?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.883681Z", "action": 59, "target": "<item type=\"input\">=NSHORA(4;20;4)</item> devuelve 04:20:04", "id": 37834350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448531/?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.883636Z", "action": 59, "target": "<item type=\"input\">=NSHORA(0;0;0)</item> devuelve 00:00:00", "id": 37834349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448526/?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.883592Z", "action": 59, "target": "Utilice un entero para configurar el <emph>Segundo</emph>.", "id": 37834348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448524/?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.883547Z", "action": 59, "target": "Utilice un entero para configurar el <emph>Minuto</emph>.", "id": 37834347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448521/?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.883502Z", "action": 59, "target": "Utilice un entero para configurar la <emph>Hora</emph>.", "id": 37834346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448519/?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.883458Z", "action": 59, "target": "NSHORA(Hora; Minuto; Segundo)", "id": 37834345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448517/?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.883412Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_ZEIT\">NSHORA devuelve el valor de hora actual a partir de los valores de horas, minutos y segundos.</ahelp> Esta función se puede utilizar para convertir una hora en un valor de tiempo decimal basándose en estos tres elementos.", "id": 37834344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448515/?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.883365Z", "action": 59, "target": "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\">NSHORA</link></variable>", "id": 37834343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834343/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448512/?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.883321Z", "action": 59, "target": "<bookmark_value>función NSHORA</bookmark_value>", "id": 37834342, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834342/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448509/?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.883276Z", "action": 59, "target": "NSHORA", "id": 37834341, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834341/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448506/?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.883231Z", "action": 59, "target": "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENAR</link>", "id": 37834340, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834340/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448504/?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.883187Z", "action": 59, "target": "", "id": 37834339, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834339/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448501/?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.883142Z", "action": 59, "target": "si A1:B2 contiene «Ya», «viene», «el» y «sol» respectivamente, <input>=UNIRCADENAS(\"-\";1;A1:B2)</input> devuelve «Ya-viene-el-sol» con el carácter de guion como delimitador e ignorando las cadenas vacías.", "id": 37834338, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448499/?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.883097Z", "action": 59, "target": "<input>=UNIRCADENAS(\" \"; 1; \"Ya\"; \"viene\"; \"el\"; \"sol\")</input> devuelve «Ya viene el sol» con el carácter de espacio como delimitador e ignorando las cadenas vacías.", "id": 37834337, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834337/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448496/?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.883053Z", "action": 59, "target": "Si, por el contrario, hubiere menos delimitadores que cadenas por unir, los delimitadores se utilizarán de nuevo desde el principio.", "id": 37834336, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834336/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448494/?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.883008Z", "action": 59, "target": "Si existen más delimitadores que cadenas por unir, no se emplearán todos los delimitadores.", "id": 37834335, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448491/?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.882964Z", "action": 59, "target": "Si <emph>delimitador</emph> es un intervalo, este no necesariamente debe ser del mismo tamaño que el número de cadenas que se unirán.", "id": 37834334, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834334/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448489/?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.882919Z", "action": 59, "target": "Los intervalos se recorren fila por fila (de arriba abajo).", "id": 37834333, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834333/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448487/?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.882874Z", "action": 59, "target": "<emph>Cadena1[; Cadena 2][; … ;[Cadena 253]</emph> son cadenas, referencias a celdas o a rangos de celdas de cadenas.", "id": 37834332, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448484/?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.882829Z", "action": 59, "target": "<emph>saltar_ vacío</emph> es un argumento lógico. Cuando se establece en FALSO o 0, se tendrán en cuenta las cadenas vacías y esto puede conducir a delimitadores adyacentes en la cadena devuelta. Cuando se establece en cualquier otro valor (por ejemplo, VERDAD o 1), se omitirán las cadenas vacías.", "id": 37834331, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834331/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448482/?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.882785Z", "action": 59, "target": "<emph>delimitador</emph> es una cadena de texto y puede ser un intervalo.", "id": 37834330, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834330/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448479/?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.882739Z", "action": 59, "target": "UNIRCADENAS( delimitador, saltar_ vacío, Cadena 1[; Cadena 2][; ... ; [Cadena 253]] )", "id": 37834329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448477/?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.882693Z", "action": 59, "target": "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatena una o más cadenas y utiliza delimitadores entre estas.</ahelp></variable>", "id": 37834328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448474/?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.882647Z", "action": 59, "target": "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\"> UNIRCADENAS</link></variable>", "id": 37834327, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834327/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448470/?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.882602Z", "action": 59, "target": "<bookmark_value>Función UNIRCADENAS</bookmark_value>", "id": 37834326, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834326/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448468/?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.882557Z", "action": 59, "target": "Función UNIRCADENAS", "id": 37834325, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834325/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448465/?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.882512Z", "action": 59, "target": "<link href=\"text/scalc/01/04060105.xhp#Section4\">SI</link>", "id": 37834324, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834324/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448464/?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.882467Z", "action": 59, "target": "", "id": 37834323, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834323/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448461/?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.882421Z", "action": 59, "target": "<input>= CAMBIAR(MES(A3),1,\"Enero\",2,\"Febrero\",3,\"Marzo\",\"Sin coincidir\")</input> devuelve \"enero\" cuando A3 contiene una fecha en enero, \"febrero\" cuando A3 contiene una fecha en febrero, etc...", "id": 37834322, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834322/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448458/?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.882376Z", "action": 59, "target": "SI no<emph>valor</emph>Igual<emph>expresión</emph>y si no se da ningún resultado predeterminado, se devuelve un error #N/A.", "id": 37834321, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834321/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448456/?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.882331Z", "action": 59, "target": "<emph>resultado_predeterminado</emph>: cualquier valor o referencia a una celda que se devuelve cuando no hay coincidencia.", "id": 37834320, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834320/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448453/?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.882286Z", "action": 59, "target": "<emph>resultado1, resultado2, ...</emph> es cualquier valor o referencia a una celda.", "id": 37834319, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834319/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448451/?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.882242Z", "action": 59, "target": "<emph>valor1, valor2, ...</emph> es cualquier valor o referencia a una celda. Cada valor debe tener un resultado dado.", "id": 37834318, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834318/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448449/?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.882198Z", "action": 59, "target": "<emph>expresión</emph> es una entrada de texto, numérica, lógica o de fecha, o bien, una referencia a otra celda.", "id": 37834317, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834317/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448447/?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.882152Z", "action": 59, "target": "Si elige no especificar un resultado predeterminado, se pueden introducir 127 pares de valor / resultado como parámetros. Si elige incluir un resultado predeterminado al final de la lista de parámetros, solo 126 valores/ se pueden introducir pares de resultados.", "id": 37834316, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834316/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448445/?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.882106Z", "action": 59, "target": "CAMBIAR((expresión; valor1; resultado1[; valor2; resultado2][; ... ; [valor127; resultado127][; predeterminado_resultado]])", "id": 37834315, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834315/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448443/?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.882060Z", "action": 59, "target": "<variable id=\"functionswitch\"><ahelp hid=\".\"> CAMBIAR Compara<emph>expresión</emph>con<emph>valor</emph>Para<emph>valor</emph>y devuelve el resultado que pertenece al primer valor que es igual a la expresión. Si no hay coincidencia y se da default_result, se devolverá</ahelp></variable>", "id": 37834314, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834314/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448441/?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.882015Z", "action": 59, "target": "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\">CAMBIAR</link></variable>", "id": 37834313, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834313/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448439/?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.881970Z", "action": 59, "target": "<bookmark_value>función CAMBIAR</bookmark_value>", "id": 37834312, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834312/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448437/?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.881926Z", "action": 59, "target": "Función CAMBIAR", "id": 37834311, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834311/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448436/?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.881881Z", "action": 59, "target": "", "id": 37834310, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834310/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448434/?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.881835Z", "action": 59, "target": "Si E2 = pen, la función devuelve 65 porque el link a la celda se sustituye por su contenido.", "id": 37834309, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834309/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448432/?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.881790Z", "action": 59, "target": "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37834308, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834308/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448430/?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.881745Z", "action": 59, "target": "Si se necesita cambiar un criterio fácilmente, puede especificarlo en ena celda separada y usar una referencia a esa celda en la condición de la función SUMAR.SI.CONJUNTO. Por ejemplo, la función anterios puede reescribirse así:", "id": 37834307, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834307/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448427/?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.881698Z", "action": 59, "target": "Referencia a una celda como criterio", "id": 37834306, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834306/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448425/?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.881651Z", "action": 59, "target": "Calcula la suma de los valores del intervalo C2:C6 que se corresponden con todas las celdas del intervalo A2:A6 que comienzan por «pan» y con todas las celdas del intervalo B2:B6 excepto su máximo. Devuelve 65 porque solo la segunda fila cumple con todos los criterios.", "id": 37834305, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834305/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448423/?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.881578Z", "action": 59, "target": "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;\"pan.*\";B2:B6;\"<\"&MAX(B2:B6))</item>", "id": 37834304, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834304/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100448421/?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.881533Z", "action": 59, "target": "Calcula la suma de los valores en el intervalo C2:C6 que se corresponden con todos los valores del intervalo B2:B6, exceptuando su mínimo y su máximo. Devuelve 255 porque las filas tercera y quinta no cumplen con por lo menos un criterio.", "id": 37834303, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37834303/?format=api" } ] }