Translation status

8,535 Strings 66%
Browse Translate
92,623 Words 56%
783,367 Characters 55%

Strings status

Strings Words Characters
8,535 92,623 783,367
All strings Browse Translate Zen
5,697 52,389 432,398
Translated strings Browse Translate Zen
2,838 40,234 350,969
Unfinished strings Browse Translate Zen
2,838 40,234 350,969
Untranslated strings Browse Translate Zen
8,535 92,623 783,367
Unfinished strings without suggestions Browse Translate Zen
29 147 1,428
Strings with any failing checks Browse Translate Zen
29 147 1,428
Translated strings with any failing checks Browse Translate Zen
22 24 214
Failing check: Unchanged translation Browse Translate Zen
2 65 469
Failing check: Trailing space Browse Translate Zen
2 6 158
Failing check: XML syntax Browse Translate Zen
3 52 587
Failing check: XML markup Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
auxiliary MPL-2.0 0 0 0 0 1 1 0
text/swriter/menu MPL-2.0 90% 5 66 554 5 0 0 0
Glossary LibreOffice Help - master MPL-2.0 3% 26 49 301 26 0 0 0
text/simpress/guide MPL-2.0 84% 107 2,007 17,597 107 1 0 0
text/swriter/00 MPL-2.0 38% 322 2,359 28,250 322 1 0 0
text/shared/help MPL-2.0 96% 4 42 393 4 0 0 0
text/shared/01 MPL-2.0 63% 2,412 30,938 271,396 2,412 54 1 0
text/shared/menu MPL-2.0 19% 101 730 6,525 101 0 0 0
text/scalc/guide MPL-2.0 86% 210 4,387 33,203 210 12 0 0
text/sbasic/shared/02 MPL-2.0 84% 31 294 4,141 31 4 0 0
Browse all components

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 ca-valencia/helpcontent2/source/text/scalc/01.po
Last change Aug. 10, 2023, 1:17 p.m.
Last author Joan Montané
2 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 8,535 92,623 783,367
Translated 66% 5,697 56% 52,389 55% 432,398
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 29 1% 147 1% 1,428
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 33% 2,838 43% 40,234 44% 350,969
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 454 changes 0 changes 57 changes 193 changes 10 changes 14 changes 110 changes 391 changes 127 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,623
Hosted words
8,535
Hosted strings
66%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
The "ca-valencia/helpcontent2/source/text/scalc/01.po" file was changed. 2 days ago
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
The "ca-valencia/helpcontent2/source/text/scalc/01.po" file was changed. 2 weeks ago
User avatar None

String updated in the repository

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

String updated in the repository

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

String updated in the repository

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

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
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:
 
2 weeks ago
User avatar None

String updated in the repository

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

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
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.
 
2 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
<input>=SUMIF(ProductName,"pen*",Revenue)</input>
 
2 weeks ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Catalan (ca_VALENCIA)
Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters "pen". Returns the value 150 because rows A4:A5 do not meet the criterion.
 
2 weeks ago
Browse all translation changes