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
2 days 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