LibreOffice Help - master/text/scalc/guide — Spanish @ TDF Weblate

Consulte nuestra guía de estilo antes de enviar sugerencias. Diríjase al foro comunitario si quiere informar de problemas o darnos realimentación.

Translation status

1,615	Strings	100%	Browse Translate
25,852	Words	100%
204,655	Characters	100%

Strings status

Strings Words Characters
1,615 25,852 204,655	All strings	Browse Translate Zen
1,615 25,852 204,655	Translated strings	Browse Translate Zen
2 2 10	Translated strings with dismissed checks	Browse Translate Zen

Overview

Project website	www.libreoffice.org
Translation license	Mozilla Public License 2.0
Translation process	Translations can be made directly. Translation suggestions can be made. Any authenticated user can contribute. The translation uses bilingual files.
File mask	`*/helpcontent2/source/text/scalc/guide.po`
Translation file	Download `es/helpcontent2/source/text/scalc/guide.po`
Last change	May 21, 2026, 9:42 a.m.
Last change made by	Adolfo Jayme Barrientos
Language	Spanish
Language code	es
Text direction	Left to right
Case sensitivity	Case-sensitive
Number of speakers	506,540,366
Number of plurals	2
Plural type	One/other
Plurals	Singular	1
Plurals	Plural	0, 2, 3, 4, 5, 6, 7, 8, 9, 10, …
Plural formula	`n != 1`

2 hours ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		1,615		25,852		204,655
Translated	100%	1,615	100%	25,852	100%	204,655
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	0%	0	0%	0	0%	0

Last 12 months Previous

Activity in last 12 months


May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr

Quick numbers

25,852

Hosted words

1,615

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

+6%

Translated

+93%

+50%

Contributors

+100%

Fito Translation changed LibreOffice Help - master text/scalc/guide Spanish	English You can format numbers as text in $[officename] Calc. Open the context menu of a cell or range of cells and choose <emph>Format Cells - Numbers</emph>, then select "Text" from the <emph>Category</emph> list. Any numbers subsequently entered into the formatted range are interpreted as text. The display of these "numbers" is left-justified, just as with other text. Spanish 24 characters edited Current translation Translated En $[officename] Calc se pueden formatear los números como si fuesen texto. Abra el menú contextual de la celda o ~~área~~intervalo de celdas y elija <emph>Format~~ear~~o de celdas -▸ Números</emph> y, a continuación, seleccione "«Texto"» en la lista <emph>Categoría</emph>. Todos los números que se escriban a partir de ahora en el ~~área~~intervalo formateadao se interpretarán como texto. Estos "«números"» se presentan alineados a la izquierda, como cualquier texto. 2 hours ago
None Changes committed LibreOffice Help - master text/scalc/guide Spanish	Changes committed a week ago
bantoniof Translation completed LibreOffice Help - master text/scalc/guide Spanish	Translation completed 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English <input>=SUMIF(A1:A5;"A??";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with "A" followed by exactly two other characters. Spanish 195 characters edited Current translation Translated <input>=SUMIF(A1:A5;"A??";B1:B5)</input> suma los valores en <emph>B1:B5</emph> cuyos valores correspondientes en <emph>A1:A5</emph> comienzan con "A" seguida exactamente de otros dos caracteres. 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English <input>=COUNTIF(A1:A10;"Chi")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with "Chi" followed by zero or more characters. Spanish 182 characters edited Current translation Translated <input>=COUNTIF(A1:A10;"Chi")</input> cuenta el número de celdas en el intervalo <emph>A1:A10</emph> que contienen cadenas que comienzan con "Chi" seguidas de cero o más caracteres. 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>. Spanish 482 characters edited Current translation Translated Los siguientes ejemplos consideran que las opciones <menuitem>Permitir comodines en fórmulas</menuitem> y <menuitem>Los criterios de búsqueda = y <> deben aplicarse a celdas completas</menuitem> están habilitadas en <switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferencias - %PRODUCTNAME Calc - Calcular</menuitem></caseinline><defaultinline><menuitem>Herramientas - Opciones - %PRODUCTNAME Calc - Calcular</menuitem></defaultinline></switchinline>. 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English <emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS. Spanish 180 characters edited Current translation Translated <emph>Funciones estadísticas condicionales:</emph> PROMEDIO.SI, PROMEDIO.SI.CONJUNTO, CONTAR.SI, CONTAR.SI.CONJUNTO, MAX.SI.CONJUNTO, MIN.SI.CONJUNTO, SUMAR.SI y SUMAR.SI.CONJUNTO. 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English <emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP. Spanish 157 characters edited Current translation Translated <emph>Funciones de base de datos:</emph> DBDPROMEDIO,BDCONTAR, BDCONTARA, BDEXTRAER, BDMAX, BDMIN, BDPRODUCTO, BDDESVEST, BDDESVESTP, BDSUMA, BDVAR y BDVARP. 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English For example, the search string "why~?" matches “why?” but will not match "whys" nor "why~s". Spanish 104 characters edited Current translation Translated Por ejemplo, la cadena de búsqueda "Why~?" coincide con "Why?" pero no coincidirá con "Whys" ni "Why~s". 8 days ago
bantoniof Translation added LibreOffice Help - master text/scalc/guide Spanish	English Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character. Spanish 123 characters edited Current translation Translated Anula el significado especial de un signo de interrogación, asterisco o tilde que siga inmediatamente al carácter de tilde. 8 days ago

Browse all translation changes

Quick downloads

1,615	File in original format as translated in the repository	gettext PO file
1,615	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1

Customize download

File format*

gettext PO XLIFF 1.1 with gettext extensions XLIFF 1.1 TBX TMX gettext MO CSV

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>="1 month ago" AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>="1 month ago" AND state:<=needs-editing`	Add
Strings changed in the past two weeks	`changed:>="2 weeks ago"`	Add

Shortcut	Action
`?`	Open available keyboard shortcuts.
`Alt` + `Home`	Navigate to the first translation in the current search.
`Alt` + `End`	Navigate to the last translation in the current search.
`Alt` + `PageUp` or `Ctrl` + `↑` or `Alt` + `↑` or `Cmd` + `↑` or	Navigate to the last translation in the current search.
`Alt` + `PageDown` or `Ctrl` + `↓` or `Alt` + `↓` or `Cmd` + `↓` or	Navigate to the next translation in the current search.
`Ctrl` + `Enter` or `Cmd` + `Enter`	Submit current form; this works the same as pressing Save and continue while editing translation.
`Ctrl` + `Shift` + `Enter` or `Cmd` + `Shift` +`Enter`	Unmark translation as Needing edit and submit it.
`Alt` + `Enter` or `Option` + `Enter`	Submit the string as a suggestion; this works the same as pressing Suggest while editing translation.
`Ctrl` + `E` or `Cmd` + `E`	Focus on translation editor.
`Ctrl` + `U` or `Cmd` + `U`	Focus on comment editor.
`Ctrl` + `M` or `Cmd` + `M`	Shows Automatic suggestions tab.
`Ctrl` + `1` to `Ctrl` + `9` or `Cmd` + `1` to `Cmd` + `9`	Copies placeable of a given number from source string.
`Ctrl` + `M` followed by `1` to `9` or `Cmd` + `M` followed by `1` to `9`	Copy the machine translation of a given number to current translation.
`Ctrl` + `I` followed by `1` to `9` or `Cmd` + `I` followed by `1` to `9`	Ignore one item in the list of failing checks.
`Ctrl` + `J` or `Cmd` + `J`	Shows the Nearby strings tab.
`Ctrl` + `S` or `Cmd` + `S`	Focus on search field.
`Ctrl` + `O` or `Cmd` + `O`	Copy the source string.
`Ctrl` + `Y` or `Cmd` + `Y`	Toggle the Needs editing checkbox.
`→`	Browse the next translation string.
`←`	Browse the previous translation string.