Translation status

1,605 Strings
97%
Browse Translate
25,735 Words
97%
203,681 Characters
97%

Strings status

Strings Words Characters
1,605 25,735 203,681
All strings Browse Translate Zen
1,561 25,075 198,950
Translated strings Browse Translate Zen
44 660 4,731
Unfinished strings Browse Translate Zen
43 609 4,239
Untranslated strings Browse Translate Zen
1 51 492
Strings marked for edit Browse Translate Zen

Summary

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-CA/helpcontent2/source/text/scalc/guide.po
Last change Feb. 5, 2026, 3:04 p.m.
Last change made by None
Language English (Canada)
Language code en_CA
Text direction Left to right
Case sensitivity Case-sensitive
Number of speakers 33,751,476
Number of plurals 2
Plural type One/other
Plurals Singular 1
Plural 0, 2, 3, 4, 5, 6, 7, 8, 9, 10, …
Plural formula n != 1
05/21/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,605 25,735 203,681
Translated 97% 1,561 97% 25,075 97% 198,950
Needs editing 1% 1 1% 51 1% 492
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 2% 43 2% 609 2% 4,239
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 1,606 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
JunJulAugSepOctNovDecJanFebMarAprMay

Quick numbers

25,735
Hosted words
1,605
Hosted strings
97%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+97%
—
Contributors
—
User avatar None

Resource updated
File “en-CA/helpcontent2/source/text/scalc/guide.po” was added. 02/05/2026
User avatar None

String added in the repository
This means that if you enter a date of "1/1/30" or higher, it will be treated internally as 1930-01-01 or higher. All lower two-digit years apply to the 20xx century. So, for example, "1/1/20" is converted into 2020-01-01.
This means that if you enter a date of "1/1/30" or higher, it will be treated internally as 1930-01-01 or higher. All lower two-digit years apply to the 20xx century. So, for example, "1/1/20" is converted into 2020-01-01.
02/05/2026
User avatar None

String added in the repository
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.
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.
02/05/2026
User avatar None

String added in the repository
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.
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.
02/05/2026
User avatar None

String added in the repository
<variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link></variable>
<variable id="year2000"><link href="text/scalc/guide/year2000.xhp">19xx/20xx Years</link></variable>
02/05/2026
User avatar None

String added in the repository
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
02/05/2026
User avatar None

String added in the repository
19xx/20xx Years
19xx/20xx Years
02/05/2026
User avatar None

String added in the repository
Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
02/05/2026
User avatar None

String added in the repository
<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.
<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.
02/05/2026
User avatar None

String added in the repository
<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.
<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.
02/05/2026
Browse all translation changes