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=150
{ "count": 8388, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=151", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/changes/?format=api&page=149", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/45530916/?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-22T20:54:26.142744Z", "action": 26, "target": "Introduciendo una referencia a una celda de encabezado dentro del área <emph>BaseDeDdatos</emph>. Alternativamente, si a la celda se le ha dado un nombre significativo como intervalo con nombre o intervalo de base de datos, ingrese ese nombre. Si el nombre no coincide con el nombre de un intervalo definido, Calc informa un error #NOMBRE?. Si el nombre es válido pero no corresponde a una sola celda, Calc informa Err:504 (error en la lista de parámetros).", "id": 2820420, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820420/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530915/?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-22T20:54:12.312814Z", "action": 4, "target": "Especifique el argumento <emph>CampoDeBaseDeDatos</emph> de cualquiera de las siguientes maneras:\n", "id": 2820419, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820419/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530915/?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-22T20:54:05.315589Z", "action": 26, "target": "Especifique el argumento <emph>CampoBaseDeDatos</emph> de cualquiera de las siguientes maneras:", "id": 2820418, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820418/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530914/?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-22T20:53:40.295044Z", "action": 4, "target": "<emph>CampoDeBaseDeDatos</emph> especifica la columna que la función utilizará para sus cálculos después de que se hayan aplicado los criterios de búsqueda y se hayan seleccionado las filas de datos. No está relacionado con los criterios de búsqueda.", "id": 2820417, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820417/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530914/?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-22T20:53:31.701737Z", "action": 26, "target": "<emph>CampoBaseDeDatos</emph> especifica la columna que la función utilizará para sus cálculos después de que se hayan aplicado los criterios de búsqueda y se hayan seleccionado las filas de datos. No está relacionado con los criterios de búsqueda.", "id": 2820416, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820416/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530913/?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-22T20:53:11.608308Z", "action": 4, "target": "<emph>Argumento CampoDeBaseDeDatos</emph>", "id": 2820415, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820415/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530913/?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-22T20:52:57.774166Z", "action": 26, "target": "<emph>Argumento CampoBaseDeDatos</emph>", "id": 2820414, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820414/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530908/?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-22T20:48:28.605676Z", "action": 4, "target": "<emph>Argumento de Base de Datos</emph>\n", "id": 2820413, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820413/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530908/?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-22T20:48:14.080767Z", "action": 26, "target": "<emph>Argumento BaseDeDatos</emph>", "id": 2820412, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820412/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530904/?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-22T20:46:15.414458Z", "action": 4, "target": "Todas las funciones tienen el mismo concepto básico de funcionamento. El primer paso lógico es emplear los <emph>CriteriosDeBúsqueda</emph> para identificar el subconjunto de registros de la <emph>BaseDeDatos</emph> que se van utilizar durante los cálculos subsecuentes. El segundo paso consiste en extraer los valores de los datos y realizar los cálculos asociados con la función indicada (media, suma, producto, etc.). Los valores procesados son los de la columna <emph>CampoDeBaseDeDatos</emph>de los registros seleccionados.", "id": 2820411, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820411/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530904/?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-22T20:45:40.551288Z", "action": 26, "target": "Todas las funciones tienen el mismo concepto básico de funcionamento. El primer paso lógico es emplear los <emph>CriteriosDeBusca</emph> para identificar el subconjunto de registros de la <emph>BaseDeDatos</emph> que se van utilizar durante los cálculos subsecuentes. El segundo paso consiste en extraer los valores de los datos y realizar los cálculos asociados con la función indicada (media, suma, producto, etc.). Los valores procesados son los de la columna <emph>CampoDaBaseDeDatos</emph>de los registros seleccionados.", "id": 2820410, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820410/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530901/?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-22T20:44:59.827878Z", "action": 4, "target": "<emph>CampoDeBaseDeDatos</emph>. La columna que contiene los datos para ser usados en los cálculos de función.", "id": 2820409, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820409/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530901/?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-22T20:44:51.404378Z", "action": 26, "target": "<emph>CampoBaseDeDatos</emph>. La columna que contiene los datos para ser usados en los cálculos de función.", "id": 2820408, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820408/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530902/?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-22T20:44:17.751239Z", "action": 4, "target": "<emph>CriteriosDeBúsqueda</emph>. El intervalo de celdas de un área separada de la hoja de cálculo que contiene los critérios de búsqueda.", "id": 2820407, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820407/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530902/?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-22T20:44:02.383388Z", "action": 26, "target": "<emph>CriteriosDeBusca</emph>. El intervalo de celdas de un área separada de la hoja de cálculo que contiene los critérios de búsqueda.", "id": 2820406, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820406/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530900/?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-22T20:43:18.516737Z", "action": 4, "target": "<emph>BaseDeDatos</emph>. El intervalo de celas de la base de datos.", "id": 2820405, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820405/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530900/?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-22T20:43:02.370458Z", "action": 26, "target": "<emph>BaseDeDatos</emph>. El intervalo de celas de la base de datos.", "id": 2820404, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2820404/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530900/?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-22T20:42:29.700454Z", "action": 4, "target": "<emph>BaseDeDatos</emph>. El intervalo de celas de la base de datos.", "id": 2820403, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820403/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530982/?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-22T20:40:59.438802Z", "action": 4, "target": "<ahelp hid=\"HID_FUNC_DBANZAHL\">BDCONTAR cuenta el número de celdas (campos) de la columna especificada que contienen valores numéricos, para todas las filas (registros de la base de datos) que coinciden con los criterios de búsqueda especificados.</ahelp> Sin embargo, si no se especifica ninguna columna,BDCONTAR devuelve el recuento de todos los registros que coinciden con los criterios de búsqueda especificados, independientemente de su contenido.", "id": 2820402, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820402/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45624235/?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-22T20:39:20.513811Z", "action": 4, "target": "<bookmark_value>Función BDCONTAR</bookmark_value><bookmark_value>recuento de filas;con valores numéricos</bookmark_value>", "id": 2820401, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820401/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530972/?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-22T20:00:12.166047Z", "action": 4, "target": "En este ejemplo, el área de criterios de búsqueda contiene dos ocurrencias del mismo encabezado. Como hay dos condiciones en la misma fila, estas están conectadas por Y (AND). Con la tabla de la base de datos de ejemplo anterior y este área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan tienen entre 8 y 10 años (inclusive). Devolverá el valor 6 (Andrés, Beatriz, Carlos, Eva, Henrique e Irene).", "id": 2820147, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820147/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530966/?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-22T19:58:18.620332Z", "action": 4, "target": "En este ejemplo, el área de criterios de búsqueda contiene solo un encabezado. Dado que hay dos condiciones en filas consecutivas, estas están conectadas por O (OR). Con la tabla de la base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;\nB12:B14)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan tienen 9 o 10 años. Devolverá valor 4 (Andrés, Beatriz, Carlos y Henrique).", "id": 2820144, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2820144/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530963/?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-22T13:46:07.017725Z", "action": 4, "target": "En este ejemplo, el área de criterios de búsqueda contiene solo dos encabezados y estos no están alineados verticalmente con los encabezados correspondientes en la tabla de la base de datos del ejemplo. Como hay dos condiciones en la misma fila, estas están conectadas por Y (AND). Con la tabla de base de datos de ejemplo anterior y esta área de criterios de búsqueda, inserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan están en el grado 2 y son mayores de 7 años. Devolverá el valor 2 (Eva e Irene).", "id": 2818488, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2818488/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530957/?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-22T13:43:30.045867Z", "action": 4, "target": "Como en este ejemplo simple, es recomendable (pero no esencial) colocar el área de criterios de búsqueda directamente debajo de la tabla de la base de datos, con las columnas de las dos áreas alineadas verticalmente. Las entradas en blanco en el área de criterios de búsqueda se ignoran. Con la tabla de base de datos de ejemplo anterior y este área de criterios de búsqueda,\ninserte la fórmula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> en una celda vacía en otra parte de la hoja para contar cuántos de los invitados de Juan viajan más de 600 metros a la escuela. Devolverá el valor 5 (contando a Beatriz, Daniel, Eva, Henrique e Irene).", "id": 2818480, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2818480/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1505650/?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-22T07:46:08.746096Z", "action": 2, "target": "Es posible realizar una conversión sin ambigüedades de cronomarcadores en el formato ISO 8601 ampliado con separadores. Si se produjera un error <emph>#¡VALOR!</emph>, desmarque <emph>Generar error #¡VALOR!</emph> en <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferencias</emph></caseinline><defaultinline><emph>Herramientas ▸ Opciones</emph></defaultinline></switchinline><emph> ▸ %PRODUCTNAME Calc ▸ Fórmula</emph>, apartado «Configuración detallada de cálculo», botón <emph>Detalles</emph>, cuadro de lista <emph>Conversión de texto a números</emph>.", "id": 2817768, "action_name": "Translation changed", "url": "https://translations.documentfoundation.org/api/changes/2817768/?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-22T07:46:05.913048Z", "action": 0, "target": "", "id": 2817763, "action_name": "Resource updated", "url": "https://translations.documentfoundation.org/api/changes/2817763/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/1505650/?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-22T07:43:22.145265Z", "action": 7, "target": "Es posible realizar una conversión sin ambigüedades de cronomarcadores en el formato ISO 8601 ampliado con separadores. Si se produjera un error <emph>#¡VALOR!<emph>, desmarque <emph>Generar error #¡VALOR!</emph> en <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME ▸ Preferencias</emph></caseinline><defaultinline><emph>Herramientas ▸ Opciones</emph></defaultinline></switchinline><emph> ▸ %PRODUCTNAME Calc ▸ Fórmula</emph>, apartado «Configuración detallada de cálculo», botón <emph>Detalles</emph>, cuadro de lista <emph>Conversión de texto a números</emph>.", "id": 2817762, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2817762/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530905/?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-22T07:42:21.351508Z", "action": 7, "target": "Calc trata los datos y los valores lógicos (VERDADERO y FALSO) como numéricos al calcular con estas funciones.", "id": 2817757, "action_name": "Suggestion accepted", "url": "https://translations.documentfoundation.org/api/changes/2817757/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530929/?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-21T23:55:30.004372Z", "action": 4, "target": "Si escribe varios criterios en una fila, están conectados por Y (AND). Si escribe varios criterios en diferentes filas, están conectados por O (OR).", "id": 2817697, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817697/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530928/?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-21T23:54:10.781037Z", "action": 4, "target": "Cree criterios en las celdas del área <emph>CriterioBusca</emph> mediante los operadores de comparación <, <=, =, <>, >= y >. = se asume si una celda no está vacía pero no comienza con un operador de comparación.", "id": 2817696, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817696/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530927/?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-21T23:48:42.493622Z", "action": 4, "target": "Los criterios de búsqueda se ingresan en las celdas de la segunda y siguientes filas del área <emph>CriterioBusca</emph>, debajo de la fila que contiene los encabezados. Las celdas en blanco dentro del área <emph>CriterioBusca</emph> se ignoran.", "id": 2817695, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817695/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530926/?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-21T23:38:13.403346Z", "action": 4, "target": "El número de columnas ocupadas por el área <emph>CriterioBusca</emph> no necesita ser igual al ancho del área <emph>BaseDeDatos</emph>. Todos los encabezados que aparecen en la primera fila de <emph>CriterioBusca</emph> deben ser idénticos a los encabezados de la primera fila de <emph>BaseDeDatos</emph>. Sin embargo, no todos los encabezados en emph>BaseDeDatos</emph> deben aparecer en la primera fila de <emph>CriterioBusca</emph>, mientras que un encabezado en <emph>BaseDeDatos</emph> puede aparecer varias veces en la primera fila de < emph>CriterioBusca</emph>.", "id": 2817694, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817694/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530924/?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-21T23:35:06.322818Z", "action": 4, "target": "El contenido del área <emph>CriterioBusca</emph> se describe con más detalle en la siguiente sección.", "id": 2817693, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817693/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530923/?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-21T23:34:32.934355Z", "action": 4, "target": "El Err:504 (error en la lista de parámetros) también puede informarse como resultado de un argumento <emph>CriterioBusca</emph> no válido.", "id": 2817692, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817692/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530922/?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-21T23:33:33.361928Z", "action": 4, "target": "Una forma de definir el intervalo de celdas es ingresar la referencia de celda para la celda superior izquierda, seguida de dos puntos (:), y luego la referencia de celda inferior derecha. Por ejemplo, A13:B14. El intervalo de celdas también se puede especificar pasando el nombre de un intevalo con nombre definido o un intervalo de base de datos. Si el nombre no coincide con el nombre de un intervalo definido, Calc informa de un error #NOMBRE?", "id": 2817691, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817691/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530921/?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-21T23:31:45.849629Z", "action": 4, "target": "<emph>CriterioBusca</emph> especifica el rango de celdas que contienen los criterios de búsqueda. Al igual que <emph>BaseDeDatos</emph>, su primera fila también son nombres de campo y las filas subsiguientes son condiciones para campos relacionados. Las áreas <emph>Base de datos</emph> y <emph>Criterio de búsqueda</emph> no necesitan estar adyacentes, ni siquiera en la misma hoja.", "id": 2817690, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817690/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530920/?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-21T23:27:48.769267Z", "action": 4, "target": "<emph>argumento CriterioBusca</emph>", "id": 2817689, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817689/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530919/?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-21T23:23:45.404830Z", "action": 4, "target": "El argumento <emph>CampoBaseDatos</emph> es opcional para las funciones DCOUNT y DCOUNTA pero es necesario para las otras diez funciones de la base de datos.", "id": 2817688, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817688/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530918/?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-21T23:22:18.597992Z", "action": 4, "target": "Introduciendo el nombre literal del encabezado de la columna desde la primera fila del intervalo de <emph>Base de datos</emph>, entrecomillando el nombre del encabezado. Por ejemplo, \"Distancia a la escuela\". Si la cadena no coincide con uno de los encabezados de columna del área <emph>Base de datos</emph>, Calc informa Err:504 (error en la lista de parámetros).\nTambién puede proporcionar una referencia a una celda arbitraria (fuera de las áreas de <emph>Base de datos</emph> y <emph>Criterio de búsqueda</emph>) que contenga la cadena requerida.", "id": 2817687, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817687/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530917/?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-21T23:19:26.204014Z", "action": 4, "target": "Al ingresar un número para especificar la columna en el área <emph>Base de datos</emph>, comenzando con 1. Por ejemplo, si una <emph>Base de datos</emph> ocupaba el rango de celdas D6: H123, ingrese 3 para indicar la celda de encabezado en F6. Calc espera un valor entero que se encuentre entre 1 y el número de columnas definido en <emph>Base de datos</emph> e ignora cualquier dígito después de un punto decimal. Si el valor es inferior a 1, Calc informa Err:504 (error en la lista de parámetros). Si el valor es mayor que el número de columnas en <emph>Base de datos</emph>, Calc informa un error #¡VALOR!", "id": 2817686, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817686/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530916/?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-21T20:42:11.341660Z", "action": 4, "target": "Introduciendo una referencia a una celda de encabezado dentro del área <emph>BaseDeDdatos</emph>. Alternativamente, si a la celda se le ha dado un nombre significativo como intervalo con nombre o intervalo de base de datos, ingrese ese nombre. Si el nombre no coincide con el nombre de un intervalo definido, Calc informa un error #NOMBRE?. Si el nombre es válido pero no corresponde a una sola celda, Calc informa Err:504 (error en la lista de parámetros).", "id": 2817642, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817642/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530915/?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-21T20:40:17.474200Z", "action": 4, "target": "Especifique el argumento <emph>CampoBaseDeDatos</emph> de cualquiera de las siguientes maneras:", "id": 2817641, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817641/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530914/?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-21T20:39:35.009571Z", "action": 4, "target": "<emph>CampoBaseDeDatos</emph> especifica la columna que la función utilizará para sus cálculos después de que se hayan aplicado los criterios de búsqueda y se hayan seleccionado las filas de datos. No está relacionado con los criterios de búsqueda.", "id": 2817640, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817640/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530913/?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-21T20:38:41.379303Z", "action": 4, "target": "<emph>Argumento CampoBaseDeDatos</emph>", "id": 2817639, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817639/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530912/?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-21T20:38:28.879281Z", "action": 4, "target": "Otros errores que se pueden informar como resultado de un argumento de <emph>BaseDeDatos</emph> no válido son #¡VALOR! y Err:504 (error en la lista de parámetros).", "id": 2817638, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817638/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530910/?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-21T20:37:12.520840Z", "action": 4, "target": "Una forma de definir el intervalo de celdas es ingresar la referencia de celda para la celda superior izquierda, seguida de dos puntos (:), y luego la referencia de celda inferior derecha. Un ejemplo podría ser A1:E10.", "id": 2817637, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817637/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530910/?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-21T20:36:01.165789Z", "action": 26, "target": "Una forma de definir el rango de celdas es ingresar la referencia de celda para la celda superior izquierda, seguida de dos puntos (:), y luego la referencia de celda inferior derecha. Un ejemplo podría ser A1:E10.", "id": 2817636, "action_name": "Suggestion removed", "url": "https://translations.documentfoundation.org/api/changes/2817636/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530911/?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-21T20:35:36.971924Z", "action": 4, "target": "El argumento <emph>BaseDeDatos</emph> también se puede especificar pasando el nombre de un intervalo con nombre o intervalo de base de datos. El uso de un nombre significativo para definir el intervalo de celdas puede mejorar la legibilidad de la fórmula y el mantenimiento del documento. Si el nombre no coincide con el nombre de un intervalo definido, Calc informa un error #NOMBRE?.", "id": 2817635, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817635/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530910/?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-21T20:33:16.466121Z", "action": 4, "target": "Una forma de definir el rango de celdas es ingresar la referencia de celda para la celda superior izquierda, seguida de dos puntos (:), y luego la referencia de celda inferior derecha. Un ejemplo podría ser A1:E10.", "id": 2817634, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817634/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/45530909/?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-21T19:55:06.949371Z", "action": 4, "target": "<emph>BaseDeDatos</emph> indica el intervalo de celdas ocupado por la tabla de la base de datos. La primera fila del intervalo contiene los nombres de los campos e las filas posteriores son registros con sus valores de campo correspondentes.", "id": 2817633, "action_name": "Suggestion added", "url": "https://translations.documentfoundation.org/api/changes/2817633/?format=api" } ] }