Translation

04060101.xhp par_id241615842810077 help.text
English ykxDt
Context English Spanish Actions
04060100.xhp
hd_id3150208
help.text
<link href="text/scalc/01/04060108.xhp" name="Statistical">Statistical</link> <link href="text/scalc/01/04060108.xhp" name="Statistical">Estadística</link>
04060100.xhp
hd_id3166428
help.text
<link href="text/scalc/01/04060109.xhp" name="Spreadsheet">Spreadsheet</link> <link href="text/scalc/01/04060109.xhp" name="Spreadsheet">Hoja de cálculo</link>
04060100.xhp
hd_id3145585
help.text
<link href="text/scalc/01/04060110.xhp" name="Text">Text</link> <link href="text/scalc/01/04060110.xhp" name="Text">Texto</link>
04060100.xhp
hd_id3156449
help.text
<link href="text/scalc/01/04060111.xhp" name="Add-in">Add-in</link> <link href="text/scalc/01/04060111.xhp" name="Add In">Complemento</link>
04060100.xhp
par_id3150715
help.text
<link href="text/scalc/01/04060199.xhp" name="Operators">Operators</link> <link href="text/scalc/01/04060199.xhp" name="Operadores">Operadores</link>
04060101.xhp
tit
help.text
Database Functions Funciones de bases de datos
04060101.xhp
bm_id3148946
help.text
<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value> <bookmark_value>Asistente para funciones;bases de datos</bookmark_value><bookmark_value>funciones;funciones de bases de datos</bookmark_value><bookmark_value>bases de datos;funciones en $[officename] Calc</bookmark_value>
04060101.xhp
hd_id3148946
help.text
Database Functions Funciones de bases de datos
04060101.xhp
hd_id721616440441374
help.text
Overview Información general
04060101.xhp
par_id3145173
help.text
<variable id="datenbanktext">The twelve functions in the Database category help you to analyze a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.</variable> The header cell of each column displays the name of the column and that name usually reflects the contents of each cell in that column. <variable id="datenbanktext">Las doce funciones de la categoría Base de datos le ayudan a analizar una base de datos sencilla que ocupa un área rectangular en una hoja de cálculo, compuesta de columnas y de filas, con los registros individuales organizados en filas.</variable> La celda de cabecera de cada columna muestra el nombre de esta y este nombre normalmente refleja el contenido de cada celda de esa columna en particular.
04060101.xhp
par_id631615842419413
help.text
The functions in the Database category take three arguments as follows: Las funciones de la categoría Base de datos aceptan estos tres argumentos:
04060101.xhp
par_id761615842549780
help.text
<emph>Database</emph>. The cell range of the database. <emph>BaseDeDatos</emph>. El intervalo de celdas de la base de datos.
04060101.xhp
par_id601615842657372
help.text
<emph>DatabaseField</emph>. The column containing the data to be used in the function’s calculations. <emph>CampoDeBaseDeDatos</emph>. La columna que contiene los datos que se utilizarán en los cálculos de la función.
04060101.xhp
par_id471615842721059
help.text
<emph>SearchCriteria</emph>. The cell range of a separate area of the spreadsheet containing search criteria. <emph>CriteriosDeBúsqueda</emph>. El intervalo de celdas de un área separada de la hoja de cálculo que contiene los criterios de búsqueda.
04060101.xhp
par_id101615842794525
help.text
These arguments are described more fully below. Estos argumentos se describen a detalle más abajo.
04060101.xhp
par_id241615842810077
help.text
All functions have the same outline concept of operation. The first logical step is to use the specified <emph>SearchCriteria</emph> to identify the subset of records in the <emph>Database</emph> that are to be used during subsequent calculations. The second step is to extract the data values and perform the calculations associated with the specific function (average, sum, product, and so on). The values processed are those in the <emph>DatabaseField</emph> column of the selected records.
04060101.xhp
par_id981615978852310
help.text
Calc treats dates and logical values (TRUE and FALSE) as numeric when calculating with these functions. Calc trata los datos y los valores lógicos (VERDADERO y FALSO) como numéricos al calcular con estas funciones.
04060101.xhp
hd_id911615888814785
help.text
Database Function Arguments Argumentos de las funciones de base de datos
04060101.xhp
par_id911615888833104
help.text
The following argument definitions apply for all functions in the Database category: Las definiciones de argumentos siguientes se aplican a todas las funciones de la categoría Base de datos:
04060101.xhp
par_id21615889071992
help.text
<emph>Database argument</emph> <emph>Argumento BaseDeDatos</emph>
04060101.xhp
par_id31615889105463
help.text
<emph>Database</emph> specifies the range of cells occupied by the database table. The first row of the range contains the field names, and subsequent rows are records with corresponding field values. <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.
04060101.xhp
par_id521615889152497
help.text
One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. An example might be A1:E10. 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.
04060101.xhp
par_id761615889163416
help.text
The <emph>Database</emph> argument may also be specified by passing the name of a named range or database range. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. If the name does not match the name of a defined range, Calc reports a #NAME? error. 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 emite un error #¿NOMBRE?
04060101.xhp
par_id601615889176137
help.text
Other errors that might be reported as a result of an invalid <emph>Database</emph> argument are #VALUE! and Err:504 (error in parameter list). 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).
04060101.xhp
par_id201615889390777
help.text
<emph>DatabaseField argument</emph> <emph>Argumento CampoDeBaseDeDatos</emph>
04060101.xhp
par_id431615889426480
help.text
<emph>DatabaseField</emph> specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. It is not related to the search criteria. <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.
04060101.xhp
par_id661615889458032
help.text
Specify the <emph>DatabaseField</emph> argument in any of the following ways: Especifique el argumento <emph>CampoDeBaseDeDatos</emph> de cualquiera de las siguientes maneras:
04060101.xhp
par_id981615889517841
help.text
By entering a reference to a header cell within the <emph>Database</emph> area. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. If the name does not match the name of a defined range, Calc reports a #NAME? error. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list).
04060101.xhp
par_id551615889661457
help.text
By entering a number to specify the column within the <emph>Database</emph> area, starting with 1. For example, if a <emph>Database</emph> occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. Calc expects an integer value that lies between 1 and the number of columns defined within <emph>Database</emph> and ignores any digits after a decimal point. If the value is less than 1, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in <emph>Database</emph>, Calc reports a #VALUE! error.
04060101.xhp
par_id561615889738472
help.text
By entering the literal column header name from the first row of the <emph>Database</emph> range, placing quotation marks around the header name. For example, “Distance to School”. If the string does not match one of the <emph>Database</emph> area’s column headings, Calc reports Err:504 (error in parameter list). You can also provide a reference to an arbitrary cell (not within the <emph>Database</emph> and <emph>SearchCriteria</emph> areas) that contains the required string.
04060101.xhp
par_id181615889841279
help.text
The <emph>DatabaseField</emph> argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions.
User avatar bantoniof

Suggestion added

Suggested change:

4 months ago

Loading…

User avatar bantoniof

Suggestion added

LibreOffice Help - master / text/scalc/01Spanish

4 months ago
User avatar bantoniof

Suggestion removed

LibreOffice Help - master / text/scalc/01Spanish

4 months ago
User avatar bantoniof

Suggestion added

LibreOffice Help - master / text/scalc/01Spanish

4 months ago
Browse all component changes

Things to check

Suggestions

There is 1 suggestion for this string.

View

Glossary

English Spanish
No related strings found in the glossary.

String information

Context
04060101.xhp
par_id241615842810077
help.text
Source string description
ykxDt
Source string location
04060101.xhp
String age
a year ago
Source string age
a year ago
Translation file
es/helpcontent2/source/text/scalc/01.po, string 505