LibreOffice Help - master/text/scalc/guide — English (South Africa) @ TDF Weblate

Translation status

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

Strings status

Strings Words Characters
1,615 25,852 204,655	All strings	Browse Translate Zen
1,139 16,882 133,910	Translated strings	Browse Translate Zen
476 8,970 70,745	Unfinished strings	Browse Translate Zen
476 8,970 70,745	Untranslated strings	Browse Translate Zen
476 8,970 70,745	Unfinished strings without suggestions	Browse Translate Zen
13 376 4,064	Strings with any failing checks	Browse Translate Zen
13 376 4,064	Translated strings with any failing checks	Browse Translate Zen
13 376 4,064	Failing check: XML markup	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 `en-ZA/helpcontent2/source/text/scalc/guide.po`
Last change	Feb. 9, 2026, 11:39 a.m.
Last change made by	None
Language	English (South Africa)
Language code	en_ZA
Text direction	Left to right
Case sensitivity	Case-sensitive
Number of speakers	18,737,206
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`

11 days ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		1,615		25,852		204,655
Translated	70%	1,139	65%	16,882	65%	133,910
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	1%	13	1%	376	1%	4,064
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	29%	476	34%	8,970	34%	70,745

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

25,852

Hosted words

1,615

Hosted strings

70%

Translated

Contributors

and previous 30 days

Trends of last 30 days

+1%

Hosted words

+100%

+1%

Hosted strings

+100%

−1%

Translated

+71%

—

Contributors

—

None Resource updated LibreOffice Help - master text/scalc/guide English (South Africa)	The “`en-ZA/helpcontent2/source/text/scalc/guide.po`” file was changed. 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English <bookmark_value>references;R1C1 syntax</bookmark_value><bookmark_value>R1C1 syntax;references</bookmark_value><bookmark_value>references;R1C1 notation</bookmark_value><bookmark_value>R1C1 notation;references</bookmark_value> English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English The structure of the original data in the source document is not restricted, as it is automatically analyzed and mapped to the sheet. However, this process is performed on a best-effort basis and may not work in all cases. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English Click <menuitem>Open</menuitem>. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English Locate the JSON or XML file that you want to open. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English Choose <menuitem>File - Open</menuitem>. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English Opening a JSON or XML file with linkable range English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English A linkable range is a section of a document containing tabular records. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English %PRODUCTNAME Calc automatically maps generic XML and JSON documents with linkable ranges to individual sheets. If a document contains multiple linkable ranges, each range is assigned to a separate sheet. English (South Africa) 0 characters edited Current translation Empty 2 weeks ago
None String added in the repository LibreOffice Help - master text/scalc/guide English (South Africa)	English <variable id="h1"><link href="text/scalc/guide/json.xhp">Reading JSON and XML files in %PRODUCTNAME Calc</link></variable> English (South Africa) 0 characters edited Current translation Empty 2 weeks 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
476	Unfinished 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.