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

Source strings

1,604	Strings	100%	Browse Translate
25,729	Words	100%
203,634	Characters	100%

This translation is being used as source strings within this component.

Strings status

Strings Words Characters
1,604 25,729 203,634	All strings	Browse Translate Zen
1,604 25,729 203,634	Read-only strings	Browse Translate Zen
3 11 204	Strings with comments	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 `templates/helpcontent2/source/text/scalc/guide.pot`
Last change	Jan. 1, 2026, 7:34 p.m.
Last change made by	Lars Jødal
Language	English
Language code	en
Text direction	Left to right
Case sensitivity	Case-sensitive
Number of speakers	1,728,900,209
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`

yesterday

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		1,604		25,729		203,634
Translated	100%	1,604	100%	25,729	100%	203,634
Needs editing	0%	0	0%	0	0%	0
Read-only	100%	1,604	100%	25,729	100%	203,634
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


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

Quick numbers

25,729

Hosted words

1,604

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

+1%

Hosted words

+100%

+1%

Hosted strings

+100%

—

Translated

+100%

Contributors

—

lajo Comment added LibreOffice Help - master text/scalc/guide English	It is suggested to add bookmarks for "R1C1 notation" as well as "R1C1 syntax", as the wording "R1C1 notation" is used in other parts of the help. yesterday
None Resource updated LibreOffice Help - master text/scalc/guide English	The “`templates/helpcontent2/source/text/scalc/guide.pot`” file was changed. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Naming conventions apply to named formulas. Absolute and relative references are respected. For example, when the named formula is copied and pasted. English 149 characters edited Current translation Read-only Naming conventions apply to named formulas. Absolute and relative references are respected. For example, when the named formula is copied and pasted. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Enter the name of the named formula in the desired cell. The cell value is the result of the formula expression. For example, enter <input>=HYP()</input> to compute the formula above. Note that you cannot directly pass parameters to named formulas. English 250 characters edited Current translation Read-only Enter the name of the named formula in the desired cell. The cell value is the result of the formula expression. For example, enter <input>=HYP()</input> to compute the formula above. Note that you cannot directly pass parameters to named formulas. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog. English 103 characters edited Current translation Read-only Click <emph>Add</emph>. The newly defined name appears in the list below. Click OK to close the dialog. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Enter the formula expression in the <emph>Range or formula expression</emph> box. For example, if you have named your formula <emph>HYP</emph>, you can enter the expression <input>SQRT(A1A1 + B1B1)</input> to compute the distance between two points on a plane. Do not precede the expression with an equal sign (=). English 317 characters edited Current translation Read-only Enter the formula expression in the <emph>Range or formula expression</emph> box. For example, if you have named your formula <emph>HYP</emph>, you can enter the expression <input>SQRT(A1A1 + B1B1)</input> to compute the distance between two points on a plane. Do not precede the expression with an equal sign (=). a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Enter the name for the formula expression in the <emph>Name</emph> field. English 73 characters edited Current translation Read-only Enter the name for the formula expression in the <emph>Name</emph> field. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English Choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears. English 112 characters edited Current translation Read-only Choose <emph>Sheet - Named Ranges and Expressions - Define</emph>. The <emph>Define Names</emph> dialog appears. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English You can assign a simpler or more familiar name to a long or complex formula expression. English 87 characters edited Current translation Read-only You can assign a simpler or more familiar name to a long or complex formula expression. a month ago
None String added in the repository LibreOffice Help - master text/scalc/guide English	English <variable id="naming_formulas"><link href="text/scalc/guide/value_with_name.xhp#naming formulas">Naming Formulas</link></variable> English 130 characters edited Current translation Read-only <variable id="naming_formulas"><link href="text/scalc/guide/value_with_name.xhp#naming formulas">Naming Formulas</link></variable> a month ago

Browse all translation changes

Quick downloads

1,604	File in original format as translated in the repository	gettext PO file
1,604	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.