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=129
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=128", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100430393/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254791Z", "action": 59, "target": "<bookmark_value>DESREF</bookmark_value>", "id": 37824170, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824170/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430388/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254760Z", "action": 59, "target": "<item type=\"input\">=COINCIDIR(200;D1:D100)</item> busca el área D1:D100, que se ordena por la columna D, para el valor 200. Tan pronto como se alcanza este valor, el devuelve el número de la fila en que se encontró. Si se encuentra un valor mayor durante la búsqueda en la columna, se devuelve el número de la fila anterior.", "id": 37824169, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824169/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430384/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254733Z", "action": 59, "target": "Si Tipo = 1 o falta el tercer parámetro, nos devuelve el índice del último valor que sea menor o igual al criterio de búsqueda. Para Tipo = -1, nos devuelve el índice del último valor que sea mayor o igual.", "id": 37824168, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824168/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430380/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254705Z", "action": 59, "target": "Si el Tipo equivale a 0, solo se encuentran resultados exactos. Si el criterio de búsqueda se encuentra más de una vez, la función devuelve el índice del primer valor encontrado. Solo si Tipo = 0 es posible buscar expresiones regulares (si están activadas en las opciones de cálculo) o comodines (si están activados en las opciones de cálculo).", "id": 37824167, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824167/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430375/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254679Z", "action": 59, "target": "<emph>Tipo</emph> puede tomar los valores 1, 0 o -1. Si Tipo = 1 o si falta este parámetro opcional, se asume que la primera columna de la matriz de búsqueda se ordena en orden ascendente. Si Tipo = -1, se asume que la columna se ordena en orden descendente. Esto se corresponde con la misma función en Microsoft Excel.", "id": 37824166, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824166/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430369/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254652Z", "action": 59, "target": "<emph>Matriz de búsqueda</emph> es la referencia buscada. Una matriz de búsqueda puede ser una sola fila o columna, o parte de una sola fila o columna.", "id": 37824165, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824165/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430364/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254626Z", "action": 59, "target": "<emph>Búsqueda</emph> es el valor que se buscará en la matriz de una sola fila o de una sola columna.", "id": 37824164, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824164/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430360/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254599Z", "action": 59, "target": "COINCIDIR(Búsqueda; Matriz de búsqueda [; Tipo])", "id": 37824163, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824163/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430354/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254572Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_VERGLEICH\">Devuelve la posición relativa de un elemento de una matriz que coincide con el valor especificado.</ahelp> La función devuelve, en forma de número, la posición del valor encontrado en Matriz de búsqueda.", "id": 37824162, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824162/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430351/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254545Z", "action": 59, "target": "COINCIDIR", "id": 37824161, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824161/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430347/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254519Z", "action": 59, "target": "<bookmark_value>COINCIDIR</bookmark_value>", "id": 37824160, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824160/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430342/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254493Z", "action": 59, "target": "<item type=\"input\">=HOJAS(Hoja1.A1:Hoja3.G12)</item> devuelve 3 si Hoja1, Hoja2 y Hoja3 existen en la secuencia indicada.", "id": 37824159, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824159/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430337/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254466Z", "action": 59, "target": "<emph>Referencia</emph> es la referencia a una hoja o área. Este parámetro es opcional.", "id": 37824158, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824158/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430334/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254438Z", "action": 59, "target": "HOJAS([Referencia])", "id": 37824157, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824157/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430328/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254411Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_TABELLEN\">Determina el número de hojas de una referencia.</ahelp> Si no especifica ningún parámetro, devuelve el número de hojas del documento actual.", "id": 37824156, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824156/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430324/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254382Z", "action": 59, "target": "HOJAS", "id": 37824155, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824155/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430319/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254346Z", "action": 59, "target": "<bookmark_value>número de hojas; función</bookmark_value> <bookmark_value>HOJAS</bookmark_value>", "id": 37824154, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824154/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430313/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254303Z", "action": 59, "target": "<input>=HOJA(\"Hoja3\")</input> devuelve 3 si la Hoja3 es la tercera hoja en el documento de hoja de cálculo.", "id": 37824153, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824153/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430308/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254260Z", "action": 59, "target": "<input>=HOJA(Hoja2.A1)</input> devuelve 2 si la Hoja2 es la segunda hoja en el documento de hoja de cálculo.", "id": 37824152, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824152/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430302/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254217Z", "action": 59, "target": "<emph>Referencia</emph> es opcional; es la referencia a una celda, un área o una cadena de nombre de hoja.", "id": 37824151, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824151/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430296/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254173Z", "action": 59, "target": "HOJA([Referencia])", "id": 37824150, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824150/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430291/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254130Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_TABELLE\">Nos devuelve el número de hoja de una referencia o una cadena que representa el nombre de una hoja.</ahelp> Si no se 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": 37824149, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824149/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430286/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254092Z", "action": 59, "target": "SHEET", "id": 37824148, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824148/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430280/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254064Z", "action": 59, "target": "<bookmark_value>números de hojas;buscar</bookmark_value> <bookmark_value>HOJAS</bookmark_value>", "id": 37824147, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824147/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430273/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254037Z", "action": 59, "target": "Al introducir un número en A1, en B1 aparece rápidamente el texto contenido en la segunda columna de la referencia D1:E100. Si se introduce un número inexistente, el texto que aparece es el correspondiente al número inferior más cercano. A fin de que esto no ocurra, hay que introducir un último parámetro FALSO en la fórmula de forma que en caso de introducir un número inexistente la función produzca como resultado un mensaje de error.", "id": 37824146, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824146/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430267/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.254009Z", "action": 59, "target": "<item type=\"input\">=BUSCARV(A1;D1:E100;2)</item>", "id": 37824145, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824145/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430262/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253982Z", "action": 59, "target": "Digite la fórmula siguiente en B1:", "id": 37824144, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824144/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430257/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253954Z", "action": 59, "target": "Desea escribir el número de un plato en el menú en la celda A1, de modo que el nombre del plato aparezca como texto en la celda vecina (B1). La asignación entre números y nombres está en la matriz D1:E100. D1 contiene <item type=\"input\">100</item>, E1 contiene el nombre <item type=\"input\">Sopa de vegetales</item>, y así sucesivamente para 100 elementos del menú. Los números en la columna D son ordenados de manera ascendente; por lo tanto, el parámetro opcional <item type=\"literal\">Orden</item> no es necesario.", "id": 37824143, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824143/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430250/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253923Z", "action": 59, "target": "<emph>Búsqueda por intervalos ordenados</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 cuya primera columna tiene un valor igual o menor que <emph>Búsqueda</emph>. Por ejemplo, podría contener fechas en las que se ha modificado algún valor fiscal, por lo que los valores representan fechas de inicio de un período en el que un valor fiscal específico estuvo vigente. Así, la búsqueda de una fecha ausente en la primera columna de la matriz, pero que cae entre algunas fechas límite existentes, daría la más baja de ellas, permitiendo encontrar los datos vigentes a la fecha buscada. Introduzca el valor booleano FALSO o cero si la primera columna no es una lista de límites del intervalo. Cuando este parámetro es VERDADERO o no se indica, la primera columna de la matriz <emph>debe estar ordenada de forma ascendente</emph>. Las columnas ordenadas se pueden buscar mucho más rápido y la función siempre devuelve un valor, aunque el valor de búsqueda no haya coincidido exactamente, si es mayor que el valor más bajo de la lista ordenada. En las listas no ordenadas, el valor de búsqueda debe coincidir exactamente. En caso contrario, la función devolverá #N/A con el mensaje <emph>Error: Valor no disponible</emph>.", "id": 37824142, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824142/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430245/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253895Z", "action": 59, "target": "<emph>Índice</emph> es el número de la columna en la matriz que contiene el valor que se va a devolver. La primera columna tiene el número 1.", "id": 37824141, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824141/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430240/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253869Z", "action": 59, "target": "<emph>Matriz</emph> es la referencia, la cual debe contener como mínimo la cantidad de columnas correspondiente al número pasado en el argumento Índice.", "id": 37824140, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824140/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430236/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253842Z", "action": 59, "target": "<emph>Buscar</emph> es el valor de cualquier tipo buscado en la primera columna de la matriz.", "id": 37824139, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824139/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430233/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253815Z", "action": 59, "target": "=BUSCARV(Búsqueda; Matriz; Índice [; Búsqueda por intervalos ordenados])", "id": 37824138, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824138/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430226/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253786Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función comprueba si un valor específico está contenido en la primera columna de una matriz. La función devuelve entonces el valor en la misma fila de la columna nombrada por <emph>Indice</emph>. Si el parámetro <emph>Ordenado</emph> se omite o se pone a VERDADERO o a uno, se supone que los datos están ordenados de forma ascendente. En este caso, si no se encuentra la <emph>Búsqueda</emph> exacta, se devolverá el último valor que sea menor que el criterio. Si <emph>Ordenado</emph> se establece en FALSO o en cero, se debe encontrar una coincidencia exacta, de lo contrario se producirá el error <emph>Error: Valor no disponible</emph> será el resultado. Por lo tanto, con un valor de cero no es necesario ordenar los datos en orden ascendente.", "id": 37824137, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824137/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430223/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253759Z", "action": 59, "target": "BUSCARV", "id": 37824136, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824136/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430219/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253732Z", "action": 59, "target": "<bookmark_value>función de búsqueda vertical</bookmark_value> <bookmark_value>BUSCARV</bookmark_value>", "id": 37824135, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824135/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430216/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253705Z", "action": 59, "target": "<item type=\"input\">=COLUMNAS(Conejo)</item> devuelve 2 si <item type=\"literal\">Conejo</item> es el área con nombre (C1:D3).", "id": 37824134, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824134/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430214/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253679Z", "action": 59, "target": "<item type=\"input\">=COLUMNAS(A1:C5)</item> es igual a 3. La referencia incluye tres columnas.", "id": 37824133, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824133/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430210/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253652Z", "action": 59, "target": "<item type=\"input\">=COLUMNAS(B5)</item> devuelve 1 porque una celda contiene solamente una columna.", "id": 37824132, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824132/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430206/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253626Z", "action": 59, "target": "<emph>Matriz</emph> es la referencia a un intervalo de celdas cuyo número total de columnas se va a buscar. El argumento también puede ser una única celda.", "id": 37824131, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824131/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430202/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253599Z", "action": 59, "target": "COLUMNAS(Matriz)", "id": 37824130, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824130/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430197/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253570Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SPALTEN\">Devuelve el número de columnas en la referencia especificada.</ahelp>", "id": 37824128, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824128/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430194/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253544Z", "action": 59, "target": "COLUMNAS", "id": 37824127, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824127/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430190/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253517Z", "action": 59, "target": "<bookmark_value>Función COLUMNAS</bookmark_value>", "id": 37824126, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824126/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430186/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253490Z", "action": 59, "target": "<item type=\"input\">{=COLUMNA(Conejo)}</item> devuelve la matriz de una fila (3, 4) si \"Conejo\" es el área con nombre (C1:D3).", "id": 37824125, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824125/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430180/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253464Z", "action": 59, "target": "<item type=\"input\">=COLUMNA()</item> devuelve 3 si la fórmula se especificó en la columna C.", "id": 37824124, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824124/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430174/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253436Z", "action": 59, "target": "<item type=\"input\">{=COLUMNA(B2:B7)}</item> y <item type=\"input\">=COLUMNA(B2:B7)</item> devuelven 2 porque la referencia solo contiene la columna B como la primera columna de la tabla. Debido a que las áreas de una sola columna solo tienen un número de columna, no hay ninguna diferencia si la fórmula se utiliza como fórmula matricial o no.", "id": 37824123, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824123/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430168/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253410Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(D3:G10)</item> devuelve 4 porque la columna D es la cuarta columna de la tabla y la función COLUMNA no se utiliza como una fórmula matricial. En este caso, el primer valor de la matriz se utiliza siempre como el resultado.", "id": 37824122, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824122/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430164/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253382Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(C3:E3)</item> es igual a 3. La columna C es la tercera de la tabla.", "id": 37824121, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824121/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100430158/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T23:26:37.253356Z", "action": 59, "target": "<item type=\"input\">=COLUMNA(A1)</item> es igual a 1. La columna A es la primera de la tabla.", "id": 37824120, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37824120/?format=api" } ] }