Translation status

1,558 Strings 78%
Browse Translate
24,970 Words 74%
198,073 Characters 74%

Strings status

Strings Words Characters
1,558 24,970 198,073
All strings Browse Translate Zen
1,229 18,543 147,605
Translated strings Browse Translate Zen
329 6,427 50,468
Unfinished strings Browse Translate Zen
329 6,427 50,468
Untranslated strings Browse Translate Zen
329 6,427 50,468
Unfinished strings without suggestions Browse Translate Zen
17 382 4,025
Strings with any failing checks Browse Translate Zen
17 382 4,025
Translated strings with any failing checks Browse Translate Zen
4 4 77
Failing check: Unchanged translation Browse Translate Zen
13 378 3,948
Failing check: XML markup Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
text/scalc/02 MPL-2.0 93% 6 38 748 6 0 0 0
text/scalc/01 MPL-2.0 58% 3,543 47,650 410,057 3,543 24 0 0
text/smath/02 MPL-2.0 0 0 0 0 0 0 0
text/sdatabase MPL-2.0 4% 1,664 19,838 145,574 1,664 0 0 0
text/sbasic/shared/01 MPL-2.0 0 0 0 0 0 0 0
text/schart/02 MPL-2.0 0 0 0 0 0 0 0
text/smath/04 MPL-2.0 0 0 0 0 0 0 0
text/simpress/04 MPL-2.0 90% 23 112 1,352 23 17 0 0
text/simpress/01 MPL-2.0 89% 109 1,034 10,445 109 6 0 0
text/sdraw/guide MPL-2.0 99% 2 30 241 2 3 0 0
Browse all components

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 et/helpcontent2/source/text/scalc/guide.po
Last change Feb. 1, 2024, 6:35 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 78% 1,229 74% 18,543 74% 147,605
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 17 1% 382 2% 4,025
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 21% 329 25% 6,427 25% 50,468
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
78%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
File et/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. Estonian
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.
See tähendab, et kui sisestad kuupäeva 1.1.30 (või hilisema), käsitleb programm seda 1.1.1930 või hilisema kuupäevana. Kõik sellest väiksemad kahekohalised aastaarvud seevastu loetakse 20xx-aastateks. Kuupäev 1.1.20 näiteks teisendatakse kuupäevaks 1.1.2020.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
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.
Jaotises <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Eelistused</caseinline><defaultinline>Tööriistad - Sätted</defaultinline></switchinline> - $[officename] - Üldine</emph> saad määrata sajandi, mida tuleks kahekohalise aastaarvu sisestamisel kasutada. Vaikimisi kasutatakse vahemikku 1930-2029.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
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.
Kuupäevakirjes on aastaarv sageli sisestatud kahekohalisena. $[officename] haldab aastaarvu programmisiseselt alati neljakohalisena, et näiteks aastaarvude 1.1.99 ja 1.1.01 vahe arvutamisel oleks tulemus õigesti kaks aastat.
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
<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">Aastad 19xx/20xx</link></variable>
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
<bookmark_value>aastad; kahekohalised</bookmark_value><bookmark_value>kuupäevad; 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. Estonian
19xx/20xx Years
Aastad 19xx/20xx
9 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 24.2
  2. text/scalc/guide
  3. Estonian
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. Estonian
<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. Estonian
<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