Translation status

8,535 Strings 40%
Browse Translate
92,623 Words 28%
783,367 Characters 27%

Strings status

Strings Words Characters
8,535 92,623 783,367
All strings Browse Translate Zen
3,483 26,828 218,273
Translated strings Browse Translate Zen
5,052 65,795 565,094
Unfinished strings Browse Translate Zen
5,052 65,795 565,094
Untranslated strings Browse Translate Zen
8,535 92,623 783,367
Unfinished strings without suggestions Browse Translate Zen
2,594 24,054 198,722
Strings with any failing checks Browse Translate Zen
2,594 24,054 198,722
Translated strings with any failing checks Browse Translate Zen
874 7,870 46,106
Failing check: Unchanged translation Browse Translate Zen
1,087 9,829 99,695
Failing check: XML syntax Browse Translate Zen
633 6,355 52,921
Failing check: XML markup Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
text/swriter/menu MPL-2.0 16% 46 337 3,720 46 0 1 0
Glossary LibreOffice Help - master MPL-2.0 7% 25 47 288 25 0 0 0
text/shared/01 MPL-2.0 28% 4,657 58,765 507,714 4,657 1,292 0 0
text/simpress/guide MPL-2.0 47% 353 5,945 51,315 353 320 1 0
text/swriter/00 MPL-2.0 7% 483 3,853 42,618 483 26 0 0
text/shared/menu MPL-2.0 0% 125 965 9,492 125 0 0 0
text/shared/help MPL-2.0 1% 99 300 4,563 99 0 0 0
text/scalc/guide MPL-2.0 58% 648 10,688 94,040 648 804 0 0
text/sbasic/shared/02 MPL-2.0 32% 138 1,581 16,478 138 54 0 0
auxiliary MPL-2.0 72% 34 113 854 34 0 3 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 he/helpcontent2/source/text/scalc/01.po
Last change June 9, 2020, 2:30 p.m.
Last author Yaron Shahrabani
13 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 8,535 92,623 783,367
Translated 40% 3,483 28% 26,828 27% 218,273
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 30% 2,594 25% 24,054 25% 198,722
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 59% 5,052 71% 65,795 72% 565,094
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 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,640
Hosted words
8,540
Hosted strings
40%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
The "he/helpcontent2/source/text/scalc/01.po" file was changed. 14 hours ago
User avatar None

Resource updated

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
The "he/helpcontent2/source/text/scalc/01.po" file was changed. 13 days ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
<link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIF">SUMIF wiki page</link>.
 
13 days ago
User avatar None

String updated in the repository

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

String updated in the repository

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

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
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:
 
13 days ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
Reference to a cell as a criterion
 
13 days ago
User avatar None

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
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.
 
13 days ago
User avatar None

String updated in the repository

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

String updated in the repository

  1. LibreOffice Help - master
  2. text/scalc/01
  3. Hebrew
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.
 
13 days ago
Browse all translation changes