Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=117
{ "count": 8388, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=118", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=116", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/8669838/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:17:53.853677Z", "action": 4, "target": "<input>=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0)</input> devuelve 0.060954 o el 6.0954 por ciento.", "id": 3379096, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379096/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669838/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:17:45.351825Z", "action": 26, "target": "<input>=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0)</input> devuelve 0.060954 ó el 6.0954 por ciento.", "id": 3379095, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3379095/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669837/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:17:20.469914Z", "action": 4, "target": "<input>=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2)</input> devuelve 0.052823 o el 5.2823 por ciento.", "id": 3379094, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379094/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669837/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:17:05.724163Z", "action": 26, "target": "<input>=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2)</input> devuelve 0.052823 ó el 5.2823 por ciento.", "id": 3379093, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3379093/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:14:23.720258Z", "action": 4, "target": "<input>=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0)</input> devuelve 0.065 o el 6.50 por ciento.", "id": 3379092, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379092/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T21:12:09.890102Z", "action": 26, "target": "<input>=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0)</input> devuelve 0.065 ó el 6.50 por ciento.", "id": 3379091, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3379091/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669840/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:55:12.549149Z", "action": 4, "target": "<input>=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09)</input> devuelve 98.45.", "id": 3379086, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379086/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669839/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:53:58.375816Z", "action": 4, "target": "<input>=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914)</input>devuelve 0.094151 ó el 9.4151 por ciento.", "id": 3379085, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379085/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25460116/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:53:03.919770Z", "action": 4, "target": "PMT(Tasa; NPer; PV [ ; [ FV ] [ ; Tipo ] ])", "id": 3379084, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379084/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669838/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:48:21.828310Z", "action": 4, "target": "<input>=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0)</input> devuelve 0.060954 ó el 6.0954 por ciento.", "id": 3379082, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379082/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25460110/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:47:09.114589Z", "action": 4, "target": "YIELDMAT(Liquidación; Vencimiento; Informe; Tasa; Precio [; Base])", "id": 3379081, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379081/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669837/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:45:08.919389Z", "action": 4, "target": "<input>=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2)</input> devuelve 0.052823 ó el 5.2823 por ciento.", "id": 3379080, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379080/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25460106/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:43:06.770830Z", "action": 4, "target": "YIELDDISC(Liquidación; Vencimiento; Precio; Devolución [; Base])", "id": 3379079, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379079/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:33:50.472256Z", "action": 4, "target": "<input>=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0)</input> devuelve 0.065 ó el 6.50 por ciento.", "id": 3379069, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379069/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25460101/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:24:32.301252Z", "action": 4, "target": "YIELD(Liquidación; Vencimiento; Tasa; Precio; Devolución; Frecuencia [; Base])", "id": 3379066, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3379066/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209276/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:09:47.599760Z", "action": 4, "target": "NPV(Tasa; <embedvar href=\"text/scalc/01/ful_func.xhp#number254_1\" markup=\"keep\"/>)", "id": 3378895, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3378895/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/8669835/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T20:07:39.902724Z", "action": 4, "target": "<input>=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3)</input> devuelve 4.02 años.", "id": 3378877, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3378877/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56164930/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T18:40:34.572171Z", "action": 26, "target": "Si mas de una celda a combinar tiene contenido al<emph>Combinar Celdas</emph>se abre el cuadro de diálogo.", "id": 3363017, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3363017/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530996/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:14:18.311856Z", "action": 4, "target": "Si cambia el valor de la celda C13 por \"10\", la fórmula <input>=DOBTENER(A1:E10; \"Nombre\"; A12:E13)</input> devuelve un error de argumento no válido (Err:502). Refleja que varios registros coinciden con el criterio especificado (tanto Betty como Carlos tienen 10 años).", "id": 3363006, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3363006/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530995/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:12:09.077633Z", "action": 4, "target": "Inserta la fórmula <input>=DOBTENER(A1:E10; \"Nombre\"; A12:E13)</input> en una celda vacía en otro lugar de la hoja para encontrar el nombre del invitado a la fiesta de Joe que tiene 11 años. Nos devolverá el nombre de Daniel.", "id": 3363004, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3363004/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530995/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:11:59.112915Z", "action": 26, "target": "Inserta la fórmula <input>=DOBTENER(A1:E10; \"Nombre\"; A12:E13)</input> en una celda vacía en otro lugar de la hoja para encontrar el nombre del invitado a la fiesta de Joe que tiene 11 años. Nos devolverá el nombre Daniel.", "id": 3363003, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3363003/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624237/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:11:27.860090Z", "action": 4, "target": "<bookmark_value>Función DOBTENER</bookmark_value><bookmark_value>contenido de las celdas; búsqueda en bases de datos Calc</bookmark_value><bookmark_value>búsqueda; contenido de las celdas en bases de datos Calc</bookmark_value>", "id": 3363002, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3363002/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624237/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:11:11.674072Z", "action": 26, "target": "<bookmark_value>Función DEXTRAE</bookmark_value><bookmark_value>contenido de las celdas; búsqueda en bases de datos Calc</bookmark_value><bookmark_value>búsqueda; contenido de las celdas en bases de datos Calc</bookmark_value>", "id": 3363001, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3363001/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530995/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:10:21.504733Z", "action": 4, "target": "Inserta la fórmula <input>=DOBTENER(A1:E10; \"Nombre\"; A12:E13)</input> en una celda vacía en otro lugar de la hoja para encontrar el nombre del invitado a la fiesta de Joe que tiene 11 años. Nos devolverá el nombre Daniel.", "id": 3363000, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3363000/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530994/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:07:02.318218Z", "action": 4, "target": "La tabla de base de datos de ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda C13 que debe contener \"11\" (este criterio de búsqueda coincidirá con los registros de la tabla de la base de datos que tengan un valor de 11 en la columna edad).", "id": 3362998, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362998/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624237/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:05:49.847146Z", "action": 4, "target": "<bookmark_value>Función DEXTRAE</bookmark_value><bookmark_value>contenido de las celdas; búsqueda en bases de datos Calc</bookmark_value><bookmark_value>búsqueda; contenido de las celdas en bases de datos Calc</bookmark_value>", "id": 3362997, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362997/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530990/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:04:16.670557Z", "action": 4, "target": "Se obtiene el mismo resultado si utiliza la fórmula <input>=DCONTARA(A1:E10; \"Distancia\"; A12:E13)</input> o la fórmula <input>=DCONTARA(A1:E10; \"Nombre\"; A12 :E13)</input>. El último caso refleja que, a diferencia de DCONTAR, DCONTARA cuenta valores numéricos y alfanuméricos en la columna indicada por el argumento <emph>Campo de base de datos</emph", "id": 3362996, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362996/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530989/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T18:02:54.532005Z", "action": 4, "target": "Inserta la fórmula <input>=DCONTARA(A1:E10;; A12:E13)</input> en una celda vacía de otro lugar de la hoja para calcular cuántos de los invitados a la fiesta de Joe viajan más de 600 metros hasta la escuela. Nos devolverá el valor 5.", "id": 3362995, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362995/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530988/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T17:56:20.924163Z", "action": 4, "target": "La tabla de base de datos del ejemplo que da información sobre los invitados a la fiesta de cumpleaños de Joe (descrita anteriormente) debe ocupar las celdas A1:E10. El contenido de las celdas A12:E12 debe ser idéntico al de las etiquetas de cabecera de la tabla de la base de datos en las celdas A1:E1. Asegúrese de que las celdas A13:E13 estén en blanco, excepto la celda D13, que debe contener \">600\" (este criterio de búsqueda coincidirá con los registros de la tabla de la base de datos que tengan un valor superior a 600 en la columna Distancia).", "id": 3362994, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362994/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530987/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T17:49:58.934776Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_DBANZAHL2\">DCONTARA cuenta el número de celdas (campos) de la columna especificada que no están en blanco, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Las celdas en blanco de la columna especificada no se cuentan. Sin embargo, si no se especifica ninguna columna, DCONTARA hace el recuento de todos los registros que coinciden con los criterios de búsqueda especificados, independientemente de su contenido.", "id": 3362990, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362990/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624236/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T17:47:16.436025Z", "action": 4, "target": "<bookmark_value>Función DCONTARA</bookmark_value><bookmark_value>registros; conteo en bases de datos Calc</bookmark_value><bookmark_value>contar filas; con valores numéricos o alfanuméricos</bookmark_value>", "id": 3362989, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362989/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530985/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T17:45:56.478304Z", "action": 4, "target": "Se obtiene el mismo resultado si usa la fórmula <input>=DCONTAR(A1:E10; \"Distancia\"; A12:E13)</input>, porque todas las entradas en la columna distancia son numéricas. Sin embargo, si se usa la fórmula <input>=DCONTAR(A1:E10; \"Nombre\"; A12:E13)</input>, devuelve el valor 0 porque todas las entradas en la columna nombre no son numéricas.", "id": 3362988, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362988/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/35271947/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "author": "https://translations.documentfoundation.org/api/users/DMEV/?format=api", "timestamp": "2022-07-06T17:40:45.798087Z", "action": 4, "target": "LOG (Número [; Base])", "id": 3362979, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362979/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1510642/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Fito/?format=api", "author": "https://translations.documentfoundation.org/api/users/Fito/?format=api", "timestamp": "2022-07-06T15:02:48.712243Z", "action": 2, "target": "Añadir/Modificar", "id": 3362907, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/3362907/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907748/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Fito/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T15:02:15.811663Z", "action": 7, "target": "Orden ascendente", "id": 3362903, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/3362903/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209342/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Fito/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T14:59:28.859135Z", "action": 7, "target": "Vuelve a calcular las celdas de la fórmula.", "id": 3362891, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/3362891/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248911/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Fito/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T14:59:07.297018Z", "action": 7, "target": "Congela la primera columna o la primera fila de la hoja de cálculo actual.", "id": 3362888, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/3362888/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1510804/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:33:54.378351Z", "action": 4, "target": "<ahelp hid=\".\">Utiliza un orden de clasificación personalizado que ha definido en el cuadro de diálogo Opciones en<emph>PRODUCTNAME Calc - Ordenar listas</emph></ahelp>", "id": 3362556, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362556/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907771/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:28:21.012469Z", "action": 4, "target": "Oculta todas las filas que contienen el valor resaltado en el cuadro <emph>Valor</emph> y en el cuadro muestra todas las demás filas.", "id": 3362554, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362554/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907769/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:20:58.959762Z", "action": 4, "target": "Mostrar solo las filas que contienen el valor resaltado en el<emph>Valor</emph>cuadro.", "id": 3362548, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362548/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907767/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:17:38.972993Z", "action": 4, "target": "Pulse una vez para seleccionar y mostrar todas las filas , pulse de nuevo para seleccionar y ocultar todas las filas.", "id": 3362546, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362546/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907765/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:14:06.526512Z", "action": 4, "target": "Busque una entrada específica en la lista de valores que se encuentran en la columna actual. A medida que se escriben caracteres en el cuadro de texto, esta lista se actualiza para mostrar solo las entradas coincidentes.", "id": 3362545, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362545/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907761/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:11:51.885911Z", "action": 4, "target": "Muestra solo las filas del rango de celdas para las que el color de fondo de la celda en la columna actual coincide con el color seleccionado.", "id": 3362544, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362544/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907759/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:11:08.318748Z", "action": 4, "target": "Muestra sólo las filas del rango de celdas para las que el color del texto de la celda en la columna actual coincide con el color seleccionado.", "id": 3362543, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362543/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907753/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:10:03.071347Z", "action": 4, "target": "Muestra las 10 filas del rango de celdas que contienen los valores más grandes en las celdas de la columna actual. Si estos valores son únicos, no se verán más de 10 filas, pero si los valores no son únicos, es posible que se muestren más de 10 filas.", "id": 3362542, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362542/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907751/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:06:52.624898Z", "action": 4, "target": "Muestra las filas del rango de celdas en orden descendente, basándose en los valores de las celdas de la columna actual.", "id": 3362541, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362541/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907750/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:06:01.514690Z", "action": 4, "target": "Orden descendiente", "id": 3362540, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362540/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907749/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:05:11.126325Z", "action": 4, "target": "Muestra las filas del rango de celdas en orden ascendente, basándose en los valores de las celdas de la columna actual.", "id": 3362539, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362539/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907749/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:05:04.604240Z", "action": 26, "target": "\nMuestra las filas del rango de celdas en orden ascendente, basándose en los valores de las celdas de la columna actual.", "id": 3362538, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/3362538/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45907749/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-master/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "user": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "author": "https://translations.documentfoundation.org/api/users/Ade01/?format=api", "timestamp": "2022-07-06T05:04:48.715429Z", "action": 4, "target": "\nMuestra las filas del rango de celdas en orden ascendente, basándose en los valores de las celdas de la columna actual.", "id": 3362537, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/3362537/?format=api" } ] }