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/01.po
Translation file Download en-ZA/helpcontent2/source/text/scalc/01.po
Last change Dec. 24, 2023, 5:18 p.m.
Last author serval2412
4 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 8,535 92,624 783,396
Translated 51% 4,379 43% 39,886 42% 330,900
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 10 1% 258 1% 2,562
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 48% 4,156 56% 52,738 57% 452,496
Last 12 months Previous

Activity in last 12 months

3 changes 25 changes 0 changes 29 changes 52 changes 51 changes 58 changes 1 change 0 changes 0 changes 0 changes 57 changes 193 changes 10 changes 14 changes 110 changes 391 changes 134 changes 0 changes 0 changes 0 changes 119 changes 202 changes 8 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

92,624
Hosted words
8,535
Hosted strings
51%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

+1%
Hosted words
+100%
+1%
Hosted strings
+100%
−1%
Translated
+52%
—
Contributors
+100%
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
The "en-ZA/helpcontent2/source/text/scalc/01.po" file was changed. 4 days ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
<variable id="h1"><link href="text/scalc/01/04070400.xhp">Define Label Range</link></variable>
 
4 days ago
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
The "en-ZA/helpcontent2/source/text/scalc/01.po" file was changed. 11 days ago
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
The "en-ZA/helpcontent2/source/text/scalc/01.po" file was changed. 3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
<link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF">SUMIF wiki page</link>.
 
3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents.
 
3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
<input>=SUMIF(A2:A6,E2,C2:C6)</input>
 
3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example:
 
3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
Reference to a cell as a criterion
 
3 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. English (South Africa)
A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named "ProductName", "Sales", and "Revenue", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href="text/scalc/01/04070100.xhp#definenames)">Define Names</link> dialog.
 
3 weeks ago
Browse all translation changes