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=144
{ "count": 8388, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=145", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=143", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/66852536/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:44:11.525561Z", "action": 4, "target": "HIPERVINCULO(\"URL\" [; \"TextodeCelda\"])", "id": 2824604, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824604/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852536/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:44:00.452239Z", "action": 26, "target": "HIPERVINCULO(\"URL\" [; \"Texto de la celda\"])", "id": 2824603, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824603/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852536/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:43:22.177654Z", "action": 4, "target": "HIPERVINCULO(\"URL\" [; \"Texto de la celda\"])", "id": 2824602, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824602/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852535/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:42:23.268046Z", "action": 4, "target": "Si utiliza el parámetro <emph>Texto de la celda</emph> opcional, la fórmula localiza el URL y muestra el texto o número.", "id": 2824600, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824600/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852535/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:41:47.230373Z", "action": 26, "target": "Si usa el parámetro opcional <emph>ValorCelda</emph>, la fórmula ubica la URL y luego muestra el texto o el número.", "id": 2824599, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2824599/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/66852535/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:41:03.991923Z", "action": 4, "target": "Si usa el parámetro opcional <emph>ValorCelda</emph>, la fórmula ubica la URL y luego muestra el texto o el número.", "id": 2824598, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824598/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624255/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:37:01.602545Z", "action": 4, "target": "BUSCARH(CriteriodeBúsqueda; Intervalo; Índice [; IntervalodeBúsquedaOrdenado])", "id": 2824596, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824596/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/35272147/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:33:34.857027Z", "action": 4, "target": "<emph>Valor 1, Valor 2, ..., Valor 30</emph> es la lista de valores introducidos como referencia a una celda o como valores individuales.", "id": 2824595, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824595/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/35272144/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:33:02.183510Z", "action": 4, "target": "ELEGIR(Ínice; Valor 1 [; Valor 2 [; ... [; Valor 30]]])", "id": 2824594, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824594/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624254/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T20:30:50.788158Z", "action": 4, "target": "<emph>CriteriodeBúsqueda</emph> es el valor de cualquier tipo a buscar; introducido directamente o como referencia.", "id": 2824592, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824592/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624253/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T19:56:37.698292Z", "action": 4, "target": "BUSCAR(CriteriodeBúsqueda; VectordeBúsqueda [; VectordeResultado])", "id": 2824588, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824588/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459482/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T19:52:59.738770Z", "action": 4, "target": "DESREF(Referencia; Filas; Columnas [; Altura [; Anchura]])", "id": 2824587, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824587/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56543315/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T19:51:36.761296Z", "action": 4, "target": "Si Tipo = 1 o falta el tercer parámetro, se devuelve el índice del último valor que es menor o igual al criterio de búsqueda. Para Tipo = -1, se devuelve el índice del último valor que es mayor o igual.\n\n", "id": 2824586, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2824586/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25245438/?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/bantoniof/?format=api", "timestamp": "2022-02-24T18:59:54.880983Z", "action": 7, "target": "<emph>Matriz 2</emph> representa la segunda matriz con el mismo número de filas.", "id": 2824575, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2824575/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56218811/?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/bantoniof/?format=api", "timestamp": "2022-02-24T17:30:24.738754Z", "action": 7, "target": "<bookmark_value>matrices; funciones</bookmark_value><bookmark_value>Asistente de funciones; matrices</bookmark_value><bookmark_value>fórmulas matriciales</bookmark_value><bookmark_value>constantes de matrices en línea</bookmark_value><bookmark_value>fórmulas; matrices</bookmark_value><bookmark_value>funciones; funciones matriciales</bookmark_value><bookmark_value>edición; fórmulas matriciales</bookmark_value><bookmark_value>copiar; fórmulas matriciales</bookmark_value><bookmark_value>borrar; fórmulas matriciales</bookmark_value><bookmark_value>ajustar un intervalo matricial</bookmark_value><bookmark_value>cálculo; cálculos condicionales</bookmark_value><bookmark_value>matrices; cálculos</bookmark_value><bookmark_value>cálculos de matriz condicional</bookmark_value><bookmark_value>manejo implícito de matrices</bookmark_value><bookmark_value>manejo forzado de matrices</bookmark_value>", "id": 2823955, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823955/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624243/?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-02-24T09:29:51.401833Z", "action": 2, "target": "<bookmark_value>función BDDESVESTP</bookmark_value><bookmark_value>desviaciones estándar en bases de datos;basadas en poblaciones</bookmark_value>", "id": 2823440, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/2823440/?format=api" }, { "unit": null, "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": null, "author": null, "timestamp": "2022-02-24T09:29:48.981161Z", "action": 0, "target": "", "id": 2823437, "action_name": "Resource updated", "url": "https://translations.documentfoundation.org/api/changes/2823437/?format=api" }, { "unit": null, "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": null, "author": null, "timestamp": "2022-02-24T09:29:27.259960Z", "action": 0, "target": "", "id": 2823436, "action_name": "Resource updated", "url": "https://translations.documentfoundation.org/api/changes/2823436/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624243/?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/bantoniof/?format=api", "timestamp": "2022-02-24T09:26:37.418492Z", "action": 7, "target": "<bookmark_value>Función BDESVESTP</bookmark_value><bookmark_value>desviaciones estándar en bases de datos;basadas en poblaciones</bookmark_value>", "id": 2823435, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823435/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459449/?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/bantoniof/?format=api", "timestamp": "2022-02-24T09:17:22.494418Z", "action": 7, "target": "INDIRECTO(Ref [; A1])", "id": 2823432, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823432/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/56218814/?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/bantoniof/?format=api", "timestamp": "2022-02-24T09:09:09.409118Z", "action": 7, "target": "Borrar fórmulas matriciales", "id": 2823427, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823427/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459434/?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/bantoniof/?format=api", "timestamp": "2022-02-24T08:58:10.627943Z", "action": 7, "target": "DDE(\"Servidor\"; \"Archivo\"; \"Intervalo\" [; Modo])", "id": 2823417, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823417/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459453/?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/bantoniof/?format=api", "timestamp": "2022-02-24T08:57:55.953579Z", "action": 7, "target": "COLUMNA([Referencia])", "id": 2823412, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823412/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459468/?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/bantoniof/?format=api", "timestamp": "2022-02-24T08:57:21.039471Z", "action": 7, "target": "HOJA([Referencia])", "id": 2823407, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823407/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248861/?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/bantoniof/?format=api", "timestamp": "2022-02-24T08:57:15.873076Z", "action": 7, "target": "<input>=HOJA(Hoja2.A1)</input> devuelve 2 si la Hoja2 es la segunda hoja en el documento de hoja de cálculo.", "id": 2823402, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823402/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248862/?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/bantoniof/?format=api", "timestamp": "2022-02-24T08:57:00.621113Z", "action": 7, "target": "<input>=HOJA(\"Hoja3\")</input> devuelve 3 si la Hoja3 es la tercera hoja en el documento de hoja de cálculo.", "id": 2823399, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2823399/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624252/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:47:17.780366Z", "action": 4, "target": "<emph>CriterioBúsqueda</emph> es el valor que se buscará en la matriz de una sola fila o de una sola columna.", "id": 2823386, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823386/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624251/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:46:48.975493Z", "action": 4, "target": "COINCIDIR(CriterioBúsqueda; BuscarMatriz [; Tipo])", "id": 2823385, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823385/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248862/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:44:58.845154Z", "action": 4, "target": "<input>=HOJA(\"Hoja3\")</input> devuelve 3 si la Hoja3 es la tercera hoja en el documento de hoja de cálculo.", "id": 2823384, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823384/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248861/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:44:26.487642Z", "action": 4, "target": "<input>=HOJA(Hoja2.A1)</input> devuelve 2 si la Hoja2 es la segunda hoja en el documento de hoja de cálculo.", "id": 2823383, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823383/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459468/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:43:28.618573Z", "action": 4, "target": "HOJA([Referencia])", "id": 2823382, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823382/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45248860/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:42:27.099830Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_TABELLE\">Devuelve el número de hoja de una referencia o una cadena que representa el nombre de una hoja.</ahelp> Si no ingresa ningún parámetro, el resultado es el número de hoja de la hoja de cálculo que contiene la fórmula.", "id": 2823381, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823381/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624250/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:41:58.273599Z", "action": 4, "target": "<emph>BúsquedaIntervaloOrdenado</emph> es un parámetro opcional que indica si la primera columna de la matriz contiene límites de intervalo en lugar de valores simples. En este modo, la búsqueda devuelve el valor de la fila con la primera columna que tiene un valor igual o menor que <emph>CriterioBúsqueda</emph>. P.ej., podría contener fechas en las que se haya cambiado algún valor fiscal, por lo que los valores representan las fechas de inicio de un período en el que un valor fiscal específico estaba en vigor. Por lo tanto, la búsqueda de una fecha que está ausente en la primera columna de la matriz, pero que se encuentra entre algunas fechas límite existentes, daría la menor de ellas, permitiendo averiguar los datos siendo efectivos a la fecha buscada. Ingrese el valor booleano FALSO o cero si la primera columna no es una lista de límite de intervalo. Cuando este parámetro es VERDADERO o no se proporciona, la primera columna de la matriz <emph>debe ordenarse en orden ascendente</emph>. Las columnas ordenadas se pueden buscar mucho más rápido y la función siempre devuelve un valor, incluso si el valor de búsqueda no coincide exactamente, si es mayor que el valor más bajo de la lista ordenada. En listas desordenadas, el valor de búsqueda debe coincidir exactamente. De lo contrario, la función devolverá #N/A con el mensaje: <emph>Error: Valor no disponible</emph>.", "id": 2823380, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823380/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624249/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:39:10.416728Z", "action": 4, "target": "<emph>CriterioBúsqueda</emph> es el valor de cualquier tipo buscado en la primera columna de la matriz.", "id": 2823379, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823379/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624248/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:37:39.922841Z", "action": 4, "target": "=BUSCARV(CriterioBúsqueda; Matriz; Índice [; BúsquedaIntervaloOrdenado])", "id": 2823378, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823378/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624247/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:36:30.384299Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función verifica si un valor específico está contenido en la primera columna de una matriz. La función luego devuelve el valor en la misma fila de la columna nombrada por <emph>Índice</emph>. Si el parámetro <emph>BúsquedaIntervaloOrdenado</emph> se omite o se establece en VERDADERO o uno, se supone que los datos se ordenan en orden ascendente. En este caso, si no se encuentra el <emph>CriterioBúsqueda</emph> exacto, se devolverá el último valor que sea menor que el criterio. Si <emph>BúsquedaIntervaloOrdenado</emph> se establece en FALSO o cero, se debe encontrar una coincidencia exacta, de lo contrario, el resultado será el error <emph>Error: Valor no disponible</emph>. Por lo tanto, con un valor de cero, los datos no necesitan ordenarse en orden ascendente.", "id": 2823377, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624247/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:35:32.988672Z", "action": 26, "target": "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función verifica si un valor específico está contenido en la primera columna de una matriz. La función luego devuelve el valor en la misma fila de la columna nombrada por <emph>Índice</emph>. Si el parámetro <emph>Ordenado</emph> se omite o se establece en VERDADERO o uno, se supone que los datos se ordenan en orden ascendente. En este caso, si no se encuentra el <emph>CriterioBúsqueda</emph> exacto, se devolverá el último valor que sea menor que el criterio. Si <emph>BúsquedaIntervaloOrdenado</emph> se establece en FALSO o cero, se debe encontrar una coincidencia exacta, de lo contrario, el resultado será el error <emph>Error: Valor no disponible</emph>. Por lo tanto, con un valor de cero, los datos no necesitan ordenarse en orden ascendente.", "id": 2823376, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2823376/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624247/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:34:16.440880Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función verifica si un valor específico está contenido en la primera columna de una matriz. La función luego devuelve el valor en la misma fila de la columna nombrada por <emph>Índice</emph>. Si el parámetro <emph>Ordenado</emph> se omite o se establece en VERDADERO o uno, se supone que los datos se ordenan en orden ascendente. En este caso, si no se encuentra el <emph>CriterioBúsqueda</emph> exacto, se devolverá el último valor que sea menor que el criterio. Si <emph>BúsquedaIntervaloOrdenado</emph> se establece en FALSO o cero, se debe encontrar una coincidencia exacta, de lo contrario, el resultado será el error <emph>Error: Valor no disponible</emph>. Por lo tanto, con un valor de cero, los datos no necesitan ordenarse en orden ascendente.", "id": 2823375, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823375/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459453/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:29:19.631996Z", "action": 4, "target": "COLUMNA([Referencia])", "id": 2823374, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459449/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:24:49.219507Z", "action": 4, "target": "INDIRECTO(Ref [; A1])", "id": 2823372, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459434/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:23:23.348613Z", "action": 4, "target": "DDE(\"Servidor\"; \"Archivo\"; \"Intervalo\" [; Modo])", "id": 2823370, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823370/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459429/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:22:48.861799Z", "action": 4, "target": "ADDRESS(Fila; Columna [; Abs [; A1 [; \"Hoja\"]]])\n", "id": 2823369, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/24754724/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:21:21.599775Z", "action": 4, "target": "<variable id=\"statistiktext\">Esta categoría contiene las funciones de <emph>Estadísticas</emph>.</variable>", "id": 2823368, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/35272098/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:20:34.558696Z", "action": 4, "target": "CRECIMIENTO(DatosY [; [ DatosX ] [; [ NuevosDatosX ] [; TipoDeFunction] ] ])", "id": 2823367, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459419/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:19:21.622276Z", "action": 4, "target": "TENDENCIA(DatosY [; DatosX [; NuevosDatosX [; TipoLinear]]])", "id": 2823366, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209269/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:18:36.517165Z", "action": 4, "target": "Al menos una matriz debe ser parte de la lista de argumentos. Si solo se proporciona una matriz, se suman todos los elementos de la matriz. Si se proporciona más de una matriz, todas deben tener el mismo tamaño.", "id": 2823365, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209268/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:18:09.965110Z", "action": 4, "target": "<emph>Matriz 1[; Matriz 2;][...;[Matriz 255]]</emph> representan los arrays cuyos elementos correspondientes se van a multiplicar.", "id": 2823364, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25209267/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:17:34.521821Z", "action": 4, "target": "SUMA.PRODUCTO(Matriz 1[; Matriz 2;][...;[Matriz 255]])", "id": 2823363, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459408/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:16:18.618804Z", "action": 4, "target": "ESTIMACION.LOGARITMICA(DatosY [; DatosX [; TipodeFunction [; Estacística]]])", "id": 2823362, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/25459386/?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/bantoniof/?format=api", "author": "https://translations.documentfoundation.org/api/users/bantoniof/?format=api", "timestamp": "2022-02-24T08:14:56.250801Z", "action": 4, "target": "LINEST(Datos_Y [; Datos_X [; tipo_lineal [; estadísticas]]])", "id": 2823361, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2823361/?format=api" } ] }