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 Feb. 1, 2024, 6:34 p.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,558 24,970 198,073
Translated 74% 1,162 68% 17,161 68% 136,545
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 13 1% 376 2% 4,064
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 25% 396 31% 7,809 31% 61,528
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 1,559 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
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

24,970
Hosted words
1,558
Hosted strings
74%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
File en-ZA/helpcontent2/source/text/scalc/guide.po was added. 9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
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.
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.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
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 <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.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
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.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
<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>
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
<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>
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
19xx/20xx Years
19xx/20xx Years
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
 
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
<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.
 
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. English (South Africa)
<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.
 
9 months ago
Browse all translation changes