LibreOffice Help – 7.6/text/scalc/guide — English (South Africa) @ TDF Weblate

Translation status

1,558	Strings	74%	Browse Translate
24,972	Words	69%
198,077	Characters	69%

Strings status

Strings Words Characters
1,558 24,972 198,077	All strings	Browse Translate Zen
1,167 17,264 138,009	Translated strings	Browse Translate Zen
391 7,708 60,068	Unfinished strings	Browse Translate Zen
391 7,708 60,068	Untranslated strings	Browse Translate Zen
1,558 24,972 198,077	Unfinished strings without suggestions	Browse Translate Zen
14 434 4,755	Strings with any failing checks	Browse Translate Zen
14 434 4,755	Translated strings with any failing checks	Browse Translate Zen
14 434 4,755	Failing check: XML markup	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
Glossary LibreOffice Help – 7.6 MPL-2.0		0	0	0	0	0	0	0

text/shared/04 MPL-2.0	72%	87	1,393	13,113	87	0	0	0

text/smath/guide MPL-2.0	54%	64	476	3,328	64	0	0	0

text/schart/02 MPL-2.0	92%	2	18	274	2	0	0	0

text/simpress/04 MPL-2.0	61%	97	492	5,619	97	0	0	0

text/smath/04 MPL-2.0	96%	1	5	31	1	0	0	0

text/scalc/menu MPL-2.0	0%	8	49	431	8	0	0	0

text/smath/00 MPL-2.0	69%	20	199	2,089	20	0	0	0

text/shared/06 MPL-2.0	0%	58	365	8,815	58	0	0	0

text/shared/optionen MPL-2.0	54%	939	16,086	143,393	939	8	0	0

Browse all components

Overview

Project website	www.libreoffice.org
Instructions for translators	Mailing list for translators: <l10n@global.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	None
Last author	None

4 weeks ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		1,558		24,972		198,077
Translated	74%	1,167	69%	17,264	69%	138,009
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	1%	14	1%	434	2%	4,755
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	25%	391	30%	7,708	30%	60,068

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

24,972

Hosted words

1,558

Hosted strings

74%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+74%

—

Contributors

—

None Resource updated LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	File `en-ZA/helpcontent2/source/text/scalc/guide.po` was added. 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020. English (South Africa) 214 characters edited Current translation Translated This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020. 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English Under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029. English (South Africa) 310 characters edited Current translation Translated Under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029. 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years. English (South Africa) 229 characters edited Current translation Translated The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years. 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English <variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link></variable> English (South Africa) 100 characters edited Current translation Translated <variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link></variable> 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English <bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value> English (South Africa) 97 characters edited Current translation Translated <bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value> 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English 19xx/20xx Years English (South Africa) 15 characters edited Current translation Translated 19xx/20xx Years 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	English Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1". English (South Africa) 0 characters edited Current translation 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	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. English (South Africa) 0 characters edited Current translation 8 months ago
None String updated in the repository LibreOffice Help – 7.6 text/scalc/guide English (South Africa)	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. English (South Africa) 0 characters edited Current translation 8 months ago

Browse all translation changes

Quick downloads

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

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2024-04-16 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:>=2024-04-16 AND state:<=needs-editing`	Add