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=160
{ "count": 8506, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=161", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/changes/?format=api&page=159", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/100424455/?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:34.731125Z", "action": 59, "target": "<emph>Grado</emph>", "id": 37822617, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822617/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424452/?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:34.731075Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822616, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822616/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424449/?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:34.731026Z", "action": 59, "target": "Ejemplo 2", "id": 37822615, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822615/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424445/?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:34.730974Z", "action": 59, "target": "Observe también que la fórmula <item type=\"input\">=BDCONTAR(A1:E10;;D12:D13)</item> devuelve el mismo valor exacto, lo que demuestra que solo es necesario que el área de criterios de búsqueda contenga los títulos de columnas pertinentes.", "id": 37822614, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822614/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424442/?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:34.730921Z", "action": 59, "target": "Como en este sencillo ejemplo, a veces 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 del ejemplo anterior y esta área de criterios de búsqueda, inserte 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 huéspedes de Joe viajan más de 600 metros a la escuela. Se devuelve el valor 5 (contando a Betty, Daniel, Eva, Harry e Irene).", "id": 37822613, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822613/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424439/?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:34.730871Z", "action": 59, "target": "<emph>Peso</emph>", "id": 37822612, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822612/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424437/?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:34.730821Z", "action": 59, "target": "<emph>Distancia</emph>", "id": 37822611, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822611/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424435/?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:34.730770Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822610, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822610/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424433/?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:34.730720Z", "action": 59, "target": "<emph>Grado</emph>", "id": 37822609, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822609/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424431/?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:34.730671Z", "action": 59, "target": "<emph>Nombre</emph>", "id": 37822608, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822608/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424429/?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:34.730634Z", "action": 59, "target": "Ejemplo 1", "id": 37822607, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822607/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424427/?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:34.730609Z", "action": 59, "target": "Los seis ejemplos siguientes utilizan la tabla de la base de datos anterior en combinación con distintas áreas de criterios de búsqueda.", "id": 37822606, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822606/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424425/?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:34.730577Z", "action": 59, "target": "Irene", "id": 37822605, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822605/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424422/?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:34.730551Z", "action": 59, "target": "Henrique", "id": 37822604, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822604/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424420/?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:34.730525Z", "action": 59, "target": "Greta", "id": 37822603, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822603/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424418/?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:34.730495Z", "action": 59, "target": "Franco", "id": 37822602, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822602/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424415/?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:34.730453Z", "action": 59, "target": "Eva", "id": 37822601, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822601/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424412/?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:34.730404Z", "action": 59, "target": "Daniel", "id": 37822600, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822600/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424410/?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:34.730355Z", "action": 59, "target": "Carlos", "id": 37822599, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822599/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424408/?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:34.730304Z", "action": 59, "target": "Beatriz", "id": 37822598, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822598/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424406/?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:34.730253Z", "action": 59, "target": "Andrés", "id": 37822597, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822597/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424404/?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:34.730204Z", "action": 59, "target": "<emph>Peso</emph>", "id": 37822596, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822596/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424401/?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:34.730154Z", "action": 59, "target": "<emph>Distancia</emph>", "id": 37822595, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822595/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424399/?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:34.730104Z", "action": 59, "target": "<emph>Edad</emph>", "id": 37822594, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822594/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424397/?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:34.730053Z", "action": 59, "target": "<emph>Grado</emph>", "id": 37822593, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822593/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424395/?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:34.730005Z", "action": 59, "target": "<emph>Nombre</emph>", "id": 37822592, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822592/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424393/?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:34.729954Z", "action": 59, "target": "La tabla de base de datos siguiente es un ejemplo que demuestra cómo puede aprovechar las funciones de la categoría Base de datos. El intervalo de celdas A1:E10 contiene datos ficticios sobre las personas invitadas a la fiesta de cumpleaños de Juan. Se proporciona la información siguiente sobre cada invitado: nombre, grado escolar, edad en años, distancia a la escuela en metros y peso en kilogramos.", "id": 37822591, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822591/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424392/?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:34.729904Z", "action": 59, "target": "Ejemplos de uso de las funciones de base de datos", "id": 37822590, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822590/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424389/?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:34.729851Z", "action": 59, "target": "Otra configuración que afecta la forma en que se manejan los criterios de búsqueda es la opción <menuitem>Los criterios de búsqueda = y <> deben aplicarse a celdas enteras</menuitem> en el <link href=\"text/shared/optionen/01060500.xhp\" name= \"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME -\nPreferencias</menuitem></caseinline><defaultinline><menuitem>Herramientas - Opciones</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - cuadro de dialogo</menuitem></link>. Esta opción controla si los criterios de búsqueda que establece para las funciones de la base de datos deben hacer coincidir exactamente con toda la celda.\nCuando la interoperatividad con Microsoft Excel es importante para su hoja de cálculo, esta opción debe estar habilitada.", "id": 37822589, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822589/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424386/?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:34.729799Z", "action": 59, "target": "Es posible crear criterios aun más sofisticados utilizando las expresiones regulares, siempre y cuando esté activada la opción <menuitem>Permitir expresiones regulares en las fórmulas</menuitem> en el cuadro de diálogo <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME ▸ Preferencias</menuitem></caseinline><defaultinline><menuitem>Herramientas ▸ Opciones</menuitem></defaultinline></switchinline><menuitem> ▸ %PRODUCTNAME Calc ▸ Calcular</menuitem></link>.", "id": 37822588, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822588/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424376/?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:34.729738Z", "action": 59, "target": "Es posible crear criterios utilizando comodines; para ello, asegúrese de que esté activada la opción <menuitem>Permitir comodines en fórmulas</menuitem> del cuadro de diálogo <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME ▸ Preferencias</menuitem></caseinline><defaultinline><menuitem>Herramientas ▸ Opciones</menuitem></defaultinline></switchinline><menuitem> ▸ %PRODUCTNAME Calc ▸ Calcular</menuitem></link>. Si la interoperatividad con Microsoft Excel es importante para su libro, esta opción debe estar activada.", "id": 37822587, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822587/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424374/?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:34.729688Z", "action": 59, "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": 37822586, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822586/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424372/?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:34.729638Z", "action": 59, "target": "Cree criterios en las celdas del área <emph>CriteriosDeBúsqueda</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": 37822585, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822585/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424369/?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:34.729601Z", "action": 59, "target": "Los criterios de búsqueda se ingresan en las celdas de la segunda y siguientes filas del área <emph>Criterios de búsqueda</emph>, debajo de la fila que contiene a los encabezados. Las celdas en blanco dentro del área <emph>Criterios de búsqueda</emph> deben ser ignorados.", "id": 37822584, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822584/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424366/?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:34.729573Z", "action": 59, "target": "El número de columnas ocupadas por el área <emph>Criterios de búsqueda</emph> no necesita ser el mismo ancho del área <emph>Base de datos</emph>. Todos los encabezados que aparecen en la primera fila de<emph>Criterios de búsqueda</emph> deben ser idénticos a los encabezados de la primera fila en la <emph>Base de datos</emph>. Sin embargo, no todos los encabezados en la <emph>Base de datos</emph> deben aparecer en la primera fila de <emph>Criterios de búsqueda</emph>, mientras que un encabezado en la <emph>Base de datos</emph> puede aparecer varias veces en la primera fila de <emph>Criterios de búsqueda</emph>.", "id": 37822583, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822583/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424364/?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:34.729546Z", "action": 59, "target": "Definir criterios de búsqueda", "id": 37822582, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822582/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424362/?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:34.729519Z", "action": 59, "target": "El contenido del área <emph>Criterios de búsqueda</emph> se describe con más detalle en la siguiente sección.", "id": 37822581, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822581/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424360/?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:34.729491Z", "action": 59, "target": "El Err:504 (error en la lista de parámetros) también puede informarse como resultado de un argumento <emph>Criterio de búsqueda</emph> no válido", "id": 37822580, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822580/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424357/?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:34.729461Z", "action": 59, "target": "Una forma de definir el intervalo de celdas es introducir la referencia de la celda superior izquierda, seguida de dos puntos (:), y luego la referencia de la celda inferior derecha. Por ejemplo, A13:B14. El intervalo de celdas también puede especificarse pasando el nombre de un intervalo con nombre definido o un intervalo de base de datos. Si el nombre no coincide con el de un intervalo definido, Calc emite un error #¿NOMBRE?", "id": 37822579, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822579/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424354/?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:34.729421Z", "action": 59, "target": "<emph>Criterios de búsqueda</emph> especifica el rango de celdas que contienen los criterios de búsqueda. Al igual que <emph>Base de datos</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>Criterios de búsqueda</emph> no necesitan estar adyacentes, ni siquiera en la misma hoja.", "id": 37822578, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822578/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424352/?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:34.729372Z", "action": 59, "target": "<emph>argumento CriteriosDeBúsqueda</emph>", "id": 37822577, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822577/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424350/?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:34.729323Z", "action": 59, "target": "El argumento <emph>Campo de base de datos</emph> es opcional para las funciones DCONTAR y DCONTARA pero es necesario para las otras diez funciones de la base de datos.", "id": 37822576, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822576/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424347/?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:34.729269Z", "action": 59, "target": "Al introducir el nombre literal de la cabecera de la columna desde la primera fila del intervalo <emph>Base de datos</emph>, entrecomillando el nombre de la cabecera. Por ejemplo, \"Distancia a la escuela\". Si la cadena no coincide con una de las cabeceras de columna del apartado <emph>Base de datos</emph>, Calc devuelve Err:504 (error en la lista de parámetros). También puede proporcionar una referencia a una celda arbitraria (fuera de los apartados <emph>Base de datos</emph> y <emph>Criterios de búsqueda</emph>) que contenga la cadena requerida.", "id": 37822575, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822575/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424344/?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:34.729217Z", "action": 59, "target": "Ingresando 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 intervalo 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": 37822574, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822574/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424341/?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:34.729165Z", "action": 59, "target": "Al introducir una referencia a una celda de cabecera dentro del área <emph>Base de datos</emph> Alternativamente, si la celda ha recibido un nombre representativo como intervalo con nombre o intervalo de base de datos, introduzca ese nombre. Si el nombre no coincide con el nombre de un intervalo definido, Calc emite el error #¿NOMBRE? Si el nombre es válido pero no corresponde a una sola celda, Calc emite el Err:504 (error en la lista de parámetros).", "id": 37822573, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822573/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424339/?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:34.729115Z", "action": 59, "target": "Especifique el argumento <emph>CampoDeBaseDeDatos</emph> de cualquiera de las siguientes maneras:", "id": 37822572, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822572/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424337/?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:34.729064Z", "action": 59, "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": 37822571, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822571/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424334/?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:34.729014Z", "action": 59, "target": "<emph>Argumento CampoDeBaseDeDatos</emph>", "id": 37822570, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822570/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424332/?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:34.728965Z", "action": 59, "target": "Otros errores que se pueden devolver como resultado de un argumento no válido en <emph>BaseDeDatos</emph> son #¡VALOR! y Err:504 (error en la lista de parámetros).", "id": 37822569, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822569/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/100424330/?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:34.728914Z", "action": 59, "target": "El argumento <emph>Base de datos</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 expresivo para definir el intervalo de celdas puede mejorar la comprensibilidad de la fórmula y el mantenimiento del documento. Si el nombre no coincide con el nombre de un intervalo definido, Calc emite un error #¿NOMBRE?", "id": 37822568, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/37822568/?format=api" } ] }