Translation status

1,558 Strings 78%
Browse Translate
24,972 Words 73%
198,077 Characters 74%

Strings status

Strings Words Characters
1,558 24,972 198,077
All strings Browse Translate Zen
1,219 18,396 146,998
Translated strings Browse Translate Zen
339 6,576 51,079
Unfinished strings Browse Translate Zen
335 6,411 50,006
Untranslated strings Browse Translate Zen
4 165 1,073
Strings marked for edit Browse Translate Zen
1,558 24,972 198,077
Unfinished strings without suggestions Browse Translate Zen
17 418 4,610
Strings with any failing checks Browse Translate Zen
17 418 4,610
Translated strings with any failing checks Browse Translate Zen
4 4 77
Failing check: Unchanged translation Browse Translate Zen
13 414 4,533
Failing check: XML markup Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
Glossary LibreOffice Help – 7.6 MPL-2.0 0 0 0 0 0 0 0
text/shared/04 MPL-2.0 74% 81 1,365 12,916 80 0 0 0
text/smath/guide MPL-2.0 95% 6 155 978 6 0 0 0
text/sbasic/python MPL-2.0 1% 404 4,670 45,007 404 0 0 0
text/schart/02 MPL-2.0 92% 2 18 274 2 0 0 0
text/simpress/04 MPL-2.0 66% 84 414 5,169 84 0 0 0
text/smath/04 MPL-2.0 96% 1 5 31 1 0 0 0
text/scalc/menu MPL-2.0 0% 8 49 431 8 0 0 0
text/smath/00 MPL-2.0 69% 20 199 2,089 20 0 0 0
text/shared/06 MPL-2.0 0% 58 365 8,815 58 0 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 fi/helpcontent2/source/text/scalc/guide.po
Last change None
Last author None
3 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 1,558 24,972 198,077
Translated 78% 1,219 73% 18,396 74% 146,998
Needs editing 1% 4 1% 165 1% 1,073
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 17 1% 418 2% 4,610
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 21% 335 25% 6,411 25% 50,006
Last 12 months Previous

Activity in last 12 months

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

Quick numbers

24,972
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 – 7.6
  2. text/scalc/guide
  3. Finnish
File fi/helpcontent2/source/text/scalc/guide.po was added. 8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
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.
Tämä tarkoittaa, että jos syötetty päivämäärä on 1.1.30 tai myöhempi, se käsitellään sisäisesti päivämääränä 1.1.1930 ja vastaavasti tehdään myöhemmissä päivämäärissä. Kaikki pienemmät kaksinumeroiset vuodet tarkoittavat vuosia 20xx. Esimerkiksi 1.1.20 muuntuu päivämääräksi 1.1.2020.
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
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.
Lehdellä <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Asetukset</caseinline><defaultinline>Työkalut - Asetukset</defaultinline></switchinline> - $[officename] - Yleistä</emph> käyttäjä voi määrittää sadan vuoden ajanjakson, jota käytetään syötettäessä vuosilukuja kaksinumeroisesti. Oletuksena on 1930 ... 2029.
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
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.
Päivämäärän vuosiluvut kirjoitetaan usein kahdella numerolla. $[officename]ssa vuosi käsitellään sisäisesti nelinumeroisena. Niinpä laskettaessa päivämäärien 1/1/99 ja 1/1/01 eroa tulos on oikea eli kaksi vuotta.
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
<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">Vuodet 19xx/20xx</link></variable>
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
<bookmark_value>vuodet; 2-numeroisina</bookmark_value><bookmark_value>päivämäärät; 19xx/20xx</bookmark_value>
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
19xx/20xx Years
Vuodet 19xx/20xx
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
Wildcard comparisons are <emph>not</emph> case sensitive, hence "A?" will match both "A1" and "a1".
 
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
<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.
 
8 months ago
User avatar None

String updated in the repository

  1. LibreOffice Help – 7.6
  2. text/scalc/guide
  3. Finnish
<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.
 
8 months ago
Browse all translation changes