aboutsummaryrefslogtreecommitdiff
path: root/source/fi/helpcontent2/source/text/scalc/guide.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/fi/helpcontent2/source/text/scalc/guide.po')
-rw-r--r--source/fi/helpcontent2/source/text/scalc/guide.po371
1 files changed, 64 insertions, 307 deletions
diff --git a/source/fi/helpcontent2/source/text/scalc/guide.po b/source/fi/helpcontent2/source/text/scalc/guide.po
index b8cf896d518..d080922a3bb 100644
--- a/source/fi/helpcontent2/source/text/scalc/guide.po
+++ b/source/fi/helpcontent2/source/text/scalc/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: \n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-01-14 18:09+0100\n"
+"POT-Creation-Date: 2021-01-25 14:55+0100\n"
"PO-Revision-Date: 2020-10-13 15:35+0000\n"
"Last-Translator: Tuomas Hietala <tuomas.hietala@iki.fi>\n"
"Language-Team: Finnish <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/fi/>\n"
@@ -2815,14 +2815,14 @@ msgctxt ""
msgid "<variable id=\"cellstyle_conditional\"><link href=\"text/scalc/guide/cellstyle_conditional.xhp\" name=\"Applying Conditional Formatting\">Applying Conditional Formatting</link></variable>"
msgstr "<variable id=\"cellstyle_conditional\"><link href=\"text/scalc/guide/cellstyle_conditional.xhp\" name=\"Applying Conditional Formatting\">Ehdollisen muotoilun käyttäminen</link></variable>"
-#. pHN5U
+#. 3Feon
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3159156\n"
"help.text"
-msgid "Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format."
-msgstr "Käytettäessä valikkokomentoa <emph>Muotoilu - Ehdollinen muotoilu</emph> valintaikkunassa voi asettaa ehtoja, joiden on täytyttävä, jotta valituissa soluissa olisi tietty muotoilu."
+msgid "Using the menu command <emph>Format - Conditional - Condition</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format."
+msgstr ""
#. SbhJy
#: cellstyle_conditional.xhp
@@ -2860,14 +2860,14 @@ msgctxt ""
msgid "Select the cells to which you want to apply a conditional style."
msgstr "Valitse solut, joissa käytät ehdollista tyyliä."
-#. fRMFM
+#. oEDHp
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3155603\n"
"help.text"
-msgid "Choose <emph>Format - Conditional Formatting</emph>."
-msgstr "Valitse <emph>Muotoilu - Ehdollinen muotoilu</emph>"
+msgid "Choose <emph>Format - Conditional - Condition</emph>."
+msgstr ""
#. nFqJG
#: cellstyle_conditional.xhp
@@ -2905,14 +2905,14 @@ msgctxt ""
msgid "You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting."
msgstr "Taulukon tietyille arvoille halutaan antaa erityinen korostus. Esimerkiksi liikevaihdon taulukossa voidaan kaikki yli keskitason olevat arvot esittää vihreinä ja alle keskiarvon olevat punaisella. Tämä voidaan tehdä ehdollisella muotoilulla."
-#. 64yKT
+#. 9zJa4
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3155337\n"
"help.text"
-msgid "First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers:"
-msgstr "Aivan aluksi kirjoita taulukko, jossa on muutamia erilaisia arvoja. Koekäyttöön taulukon voi luoda satunnaisluvuillakin:"
+msgid "First of all, create a table in which a few different values occur. For your test you can create tables with any random numbers:"
+msgstr ""
#. A66qh
#: cellstyle_conditional.xhp
@@ -2968,22 +2968,22 @@ msgctxt ""
msgid "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu."
msgstr "Napsauta tyhjää solua ja valitse komento <emph>Muotoile solut</emph> kohdevalikosta."
-#. pzTvA
+#. JZ7gV
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3155529\n"
"help.text"
-msgid "In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, select a background color. Click <emph>OK</emph>."
-msgstr "Valitse <emph>Solun määritteet</emph> -valintaikkunan <emph>Tausta</emph>-välilehdeltä taustan väri. Hyväksy <emph>OK</emph>:lla."
+msgid "In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, click the <emph>Color</emph> button and then select a background color. Click <emph>OK</emph>."
+msgstr ""
-#. BMczi
+#. AwUDA
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3154484\n"
"help.text"
-msgid "In the Styles window, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style \"Above\"."
+msgid "In the Styles deck of the Sidebar, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style \"Above\"."
msgstr ""
#. 4bRZa
@@ -3022,14 +3022,14 @@ msgctxt ""
msgid "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>."
msgstr "Sijoita kohdistin tyhjään soluun, esimerkiksi soluun J14, ja valitse <emph>Lisää - Funktio</emph>."
-#. QA6oP
+#. JF5VP
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3156016\n"
"help.text"
-msgid "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#eingabesymbol\" name=\"Shrink or Maximize\"><item type=\"menuitem\">Shrink / Maximize</item></link> icon."
-msgstr "Valitse AVERAGE-funktio. Käytä hiirtä kaikkien satunnaislukujen valitsemiseen. Jos koko alue ei ole nähtävissä, koska Ohjattu funktion luonti -ikkuna on tiellä, valintaikkuna voidaan tilapäisesti kutistaa <link href=\"text/shared/00/00000001.xhp#eingabesymbol\" name=\"Kutista tai Suurenna\"><item type=\"menuitem\">Kutista/Suurenna</item></link> -kuvakkeella."
+msgid "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#eingabesymbol\" name=\"Shrink or Maximize\"><item type=\"menuitem\">Shrink</item></link> icon."
+msgstr ""
#. YEqsh
#: cellstyle_conditional.xhp
@@ -3067,14 +3067,14 @@ msgctxt ""
msgid "Select all cells with the random numbers."
msgstr "Valitse kaikki solut, joissa on satunnaislukuja."
-#. vxDRC
+#. p7dEG
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3153801\n"
"help.text"
-msgid "Choose the <emph>Format - Conditional Formatting</emph> command to open the corresponding dialog."
-msgstr "Valitse <emph>Muotoilu - Ehdollinen muotoilu</emph> -komento vastaavan valintaikkunan avaamiseksi."
+msgid "Choose the <emph>Format - Conditional - Condition</emph> command to open the corresponding dialog."
+msgstr ""
#. oaUQo
#: cellstyle_conditional.xhp
@@ -3130,32 +3130,32 @@ msgctxt ""
msgid "Select the cells that are to receive this same formatting."
msgstr "Valitse solut, joille tulee tämä sama muotoilu."
-#. iGbDq
+#. zDCnK
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3147298\n"
"help.text"
-msgid "Choose <emph>Edit - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears."
-msgstr "Valitse <emph>Muokkaa - Liitä määräten</emph>. Esille saadaan <emph>Liitä määräten</emph> -valintaikkuna."
+msgid "Choose <emph>Edit - Paste Special - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears."
+msgstr ""
-#. PFnj2
+#. KEnNM
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3166465\n"
"help.text"
-msgid "In the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>."
-msgstr "Merkitse <emph>Valinta</emph>-alueelta vain <emph>Muotoilu</emph>-ruutu. Kaikkien muiden ruutujen pitää olla merkitsemättömiä. Hyväksy <emph>OK</emph>:lla."
+msgid "In the <emph>Paste</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>. Or you can click the <emph>Formats only</emph> button instead."
+msgstr ""
-#. duFEp
+#. YMDKA
#: cellstyle_conditional.xhp
msgctxt ""
"cellstyle_conditional.xhp\n"
"par_id3159123\n"
"help.text"
-msgid "<link href=\"text/scalc/01/05120000.xhp\" name=\"Format - Conditional formatting\">Format - Conditional formatting</link>"
-msgstr "<link href=\"text/scalc/01/05120000.xhp\" name=\"Muotoilu - Ehdollinen muotoilu\">Muotoilu - Ehdollinen muotoilu</link>"
+msgid "<link href=\"text/scalc/01/05120000.xhp\" name=\"Format - Conditional formatting\">Format - Conditional - Condition</link>"
+msgstr ""
#. HFoKB
#: cellstyle_minusvalue.xhp
@@ -3220,76 +3220,76 @@ msgctxt ""
msgid "The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type=\"menuitem\">Format code</item>. For example, instead of RED, enter <item type=\"literal\">YELLOW</item>. If the new code appears in the list after clicking the <item type=\"menuitem\">Add</item> icon, this is a valid entry."
msgstr "Solun lukumuoto määritetään kahdessa osassa. Positiivisten lukujen ja nollan lukumuoto määritetään puolipisteen edessä; puolipisteen jälkeen tulee negatiivisten lukujen määrityskoodi. Koodia (RED) voidaan vaihtaa <item type=\"menuitem\">Muotoilukoodi</item>-kentässä. Esimerkiksi koodin RED (punainen) sijaan voidaan syöttää <item type=\"literal\">YELLOW</item> (keltainen). Jos uusi koodi ilmestyy luetteloon <item type=\"menuitem\">Lisää</item>-kuvakkeen napsautuksella, koodi on kelvollinen."
-#. C6AnT
+#. 5vG69
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"image_anc\n"
"help.text"
-msgid "Change Image Anchor in Calc"
+msgid "Changing Image Anchor in Calc"
msgstr ""
-#. hrTCt
+#. Vwqvb
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"bm_id471607970579914\n"
"help.text"
-msgid "<bookmark_value>anchor;image</bookmark_value>"
+msgid "<bookmark_value>anchor;image</bookmark_value><bookmark_value>image anchor;in Calc</bookmark_value><bookmark_value>image anchor in Calc;changing</bookmark_value>"
msgstr ""
-#. UsH3R
+#. t3pgZ
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id851607971999527\n"
"help.text"
-msgid "<variable id=\"anchor_image\"><link href=\"text/scalc/guide/change_image_anchor.xhp\" name=\"Changing Anchor of Image\">Change Anchor of Image</link> </variable>"
+msgid "<variable id=\"anchor_image\"><link href=\"text/scalc/guide/change_image_anchor.xhp\" name=\"Changing Anchor of Image\">Changing the Anchor of an Image</link> </variable>"
msgstr ""
-#. 4jY2o
+#. BoMUp
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id881607972030094\n"
"help.text"
-msgid "When you insert an image in Calc, it gets anchored to the cell by default and does not resize when moved."
+msgid "Images are inserted in a Calc spreadsheet anchored to cells by default and do not resize when the cell is moved."
msgstr ""
-#. F6G6d
+#. gFthU
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id741607810664944\n"
"help.text"
-msgid "The image could be anchored in three different ways:"
+msgid "Images can be anchored in three different ways:"
msgstr ""
-#. 6Zda2
+#. PEh9n
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id351607809926451\n"
"help.text"
-msgid "<emph>To Cell:</emph> When the image is anchored to cell, the image will move along with the cell( while copying, sorting or inserting cells)."
+msgid "<emph>To Cell:</emph> the image will move along with the cell, when copying, sorting or inserting and deleting cells before."
msgstr ""
-#. BCZtC
+#. 99BBj
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id871607809971823\n"
"help.text"
-msgid "<emph>To Cell(resize with cell):</emph> When resize with cell option is selected, the image would move along with the cell. Also the size of the image will be altered according to the size of the destination cell. The aspect ratio of original image is maintained as long as the image fits into the cell."
+msgid "<emph>To Cell(resize with cell):</emph> the image will move along with the cell. In addition, the image height and width will be resized if the cell holding the anchor is later resized. The aspect ratio of the image follows the later aspect ratio of the cell holding the anchor."
msgstr ""
-#. LvEkh
+#. DGAiK
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id551607810008215\n"
"help.text"
-msgid "<emph>To Page:</emph> When the image is anchored to page, ordering of cells or pasting in other cells do not affect the image position in the page."
+msgid "<emph>To Page:</emph> the image position in the page is not affected by cells ordering or cells movements."
msgstr ""
#. 97qEg
@@ -3301,22 +3301,22 @@ msgctxt ""
msgid "To Change the anchor of an image"
msgstr ""
-#. bZBwm
+#. t5B8m
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id41607978764613\n"
"help.text"
-msgid "<emph>Insert Image Dialog - Anchor.</emph> Or, on the context menu of the image choose -<emph> Anchor</emph>"
+msgid "Select the image and choose <menuitem>Format - Anchor</menuitem>, or, on the context menu of the image choose <menuitem>Anchor</menuitem>"
msgstr ""
-#. ZjUUv
+#. pSQWf
#: change_image_anchor.xhp
msgctxt ""
"change_image_anchor.xhp\n"
"par_id761607809520625\n"
"help.text"
-msgid "The original size of the image and cell is preserved while pasting the entire row or entire column for both \"To Cell\" and \"To Cell(resize with cell)\" option."
+msgid "The original size of the image and cell is preserved while pasting the entire row or entire column for both <emph>To Cell</emph> and <emph>To Cell(resize with cell)</emph> options."
msgstr ""
#. G5Dfz
@@ -11464,32 +11464,32 @@ msgctxt ""
msgid "Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR."
msgstr "Kopioi suodatettavan taulukkoalueen sarakeotsikot taulukon tyhjälle alueelle ja kirjoita sitten suodatusehdot otsikoiden alapuolella oleville riveille. Vaakasuunnassa samalla rivillä olevat ehdot yhdistetään rajaavasti loogisella JA-operaatiolla (AND) ja pystysuunnassa erilleen järjestetyt ehdot yhdistetään laajentavasti loogisella TAI-operaatiolla (OR)."
-#. fhdVY
+#. 73DhZ
#: specialfilter.xhp
msgctxt ""
"specialfilter.xhp\n"
"par_id3153142\n"
"help.text"
-msgid "Once you have created a filter matrix, select the sheet ranges to be filtered. Open the <emph>Advanced Filter</emph> dialog by choosing <emph>Data - Filter - Advanced Filter</emph>, and define the filter conditions."
-msgstr "Kun olet saanut luotua suodatusehtojen taulukon, valitse suodatettava taulukkoalue. Avaa <emph>Erityissuodatus</emph>-valintaikkuna valitsemalla <emph>Tiedot - Suodatus - Erityissuodatus</emph> ja syötä suodatusehtojen viite."
+msgid "Once you have created a filter matrix, select the sheet ranges to be filtered. Open the <emph>Advanced Filter</emph> dialog by choosing <menuitem>Data - More Filters - Advanced Filter</menuitem>, and define the filter conditions."
+msgstr ""
-#. oDxfb
+#. 2F7wd
#: specialfilter.xhp
msgctxt ""
"specialfilter.xhp\n"
"par_id3153726\n"
"help.text"
-msgid "Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the <emph>Format - Rows - Show </emph>command."
+msgid "Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the <menuitem>Format - Rows - Show</menuitem> command."
msgstr ""
-#. CC9mL
+#. Sn4mJ
#: specialfilter.xhp
msgctxt ""
"specialfilter.xhp\n"
"par_id3149664\n"
"help.text"
-msgid "<emph>Example</emph>"
-msgstr "<emph>Esimerkki</emph>"
+msgid "Example"
+msgstr ""
#. UFqRd
#: specialfilter.xhp
@@ -11500,60 +11500,6 @@ msgctxt ""
msgid "Load a spreadsheet with a large number of records. We are using a fictional <emph>Turnover</emph> document, but you can just as easily use any other document. The document has the following layout:"
msgstr "Ladataan laskentataulukko, jossa on suuri määrä tietueita. Käytämme kuvitteellista <emph>Liikevaihto</emph>-asiakirjaa, mutta muutakin asiakirjaa voi käyttää yhtä hyvin. Asiakirja on aseteltu seuraavasti:"
-#. eEx5X
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3154510\n"
-"help.text"
-msgid "<emph>A</emph>"
-msgstr "<emph>A</emph>"
-
-#. 9cuXW
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3150327\n"
-"help.text"
-msgid "<emph>B</emph>"
-msgstr "<emph>B</emph>"
-
-#. YfiAi
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3154756\n"
-"help.text"
-msgid "<emph>C</emph>"
-msgstr "<emph>C</emph>"
-
-#. JX8aJ
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3155335\n"
-"help.text"
-msgid "<emph>D</emph>"
-msgstr "<emph>D</emph>"
-
-#. QVEDv
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3146315\n"
-"help.text"
-msgid "<emph>E</emph>"
-msgstr "<emph>E</emph>"
-
-#. Zok2N
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3145790\n"
-"help.text"
-msgid "<emph>1</emph>"
-msgstr "<emph>1</emph>"
-
#. KiEAY
#: specialfilter.xhp
msgctxt ""
@@ -11599,15 +11545,6 @@ msgctxt ""
msgid "Suite"
msgstr "Sviitti"
-#. YJ2wP
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3154486\n"
-"help.text"
-msgid "<emph>2</emph>"
-msgstr "<emph>2</emph>"
-
#. KT7sj
#: specialfilter.xhp
msgctxt ""
@@ -11617,51 +11554,6 @@ msgctxt ""
msgid "January"
msgstr "Tammikuu"
-#. rJZcC
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3153816\n"
-"help.text"
-msgid "125600"
-msgstr "125600"
-
-#. 6ZN6M
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3157978\n"
-"help.text"
-msgid "200500"
-msgstr "200500"
-
-#. Gcbqo
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3155268\n"
-"help.text"
-msgid "240000"
-msgstr "240000"
-
-#. y6CMq
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3153286\n"
-"help.text"
-msgid "170000"
-msgstr "170000"
-
-#. fCMUp
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3146782\n"
-"help.text"
-msgid "<emph>3</emph>"
-msgstr "<emph>3</emph>"
-
#. USDDe
#: specialfilter.xhp
msgctxt ""
@@ -11671,51 +11563,6 @@ msgctxt ""
msgid "February"
msgstr "Helmikuu"
-#. SKG3B
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3154763\n"
-"help.text"
-msgid "160000"
-msgstr "160000"
-
-#. cGXHP
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3150050\n"
-"help.text"
-msgid "180300"
-msgstr "180300"
-
-#. EiYAr
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3153801\n"
-"help.text"
-msgid "362000"
-msgstr "362000"
-
-#. cUKzF
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3154708\n"
-"help.text"
-msgid "220000"
-msgstr "220000"
-
-#. AwELk
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3151191\n"
-"help.text"
-msgid "<emph>4</emph>"
-msgstr "<emph>4</emph>"
-
#. 88qLX
#: specialfilter.xhp
msgctxt ""
@@ -11725,15 +11572,6 @@ msgctxt ""
msgid "March"
msgstr "Maaliskuu"
-#. onQTV
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3153334\n"
-"help.text"
-msgid "170000"
-msgstr "170000"
-
#. sbbpY
#: specialfilter.xhp
msgctxt ""
@@ -11752,60 +11590,6 @@ msgctxt ""
msgid "Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on."
msgstr "Kopioidaan rivi 1, jossa on sarakeotsikot (kentän nimet), esimerkiksi tyhjälle riville 20. Syötetään laajentavat TAI(OR)-kytkeytyvät suodatusehdot riveille 21, 22 ja niin edelleen."
-#. fqCcM
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3159115\n"
-"help.text"
-msgid "<emph>A</emph>"
-msgstr "<emph>A</emph>"
-
-#. h5B4m
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3146886\n"
-"help.text"
-msgid "<emph>B</emph>"
-msgstr "<emph>B</emph>"
-
-#. 33sFp
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3153124\n"
-"help.text"
-msgid "<emph>C</emph>"
-msgstr "<emph>C</emph>"
-
-#. EiMtC
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3152979\n"
-"help.text"
-msgid "<emph>D</emph>"
-msgstr "<emph>D</emph>"
-
-#. inUjS
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3145827\n"
-"help.text"
-msgid "<emph>E</emph>"
-msgstr "<emph>E</emph>"
-
-#. ubV5L
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3149892\n"
-"help.text"
-msgid "<emph>20</emph>"
-msgstr "<emph>20</emph>"
-
#. VHUHq
#: specialfilter.xhp
msgctxt ""
@@ -11851,15 +11635,6 @@ msgctxt ""
msgid "Suite"
msgstr "Sviitti"
-#. Xg68i
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3149188\n"
-"help.text"
-msgid "<emph>21</emph>"
-msgstr "<emph>21</emph>"
-
#. CAjJZ
#: specialfilter.xhp
msgctxt ""
@@ -11869,41 +11644,23 @@ msgctxt ""
msgid "January"
msgstr "Tammikuu"
-#. FTwUG
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3150865\n"
-"help.text"
-msgid "<emph>22</emph>"
-msgstr "<emph>22</emph>"
-
-#. 7xDwi
-#: specialfilter.xhp
-msgctxt ""
-"specialfilter.xhp\n"
-"par_id3155957\n"
-"help.text"
-msgid "<160000"
-msgstr "<160001"
-
-#. cCG3M
+#. GTvgG
#: specialfilter.xhp
msgctxt ""
"specialfilter.xhp\n"
"par_id3153566\n"
"help.text"
-msgid "Specify that only rows which either have the value <item type=\"literal\">January</item> in the <emph>Month</emph> cells OR a value of under 160000 in the <emph>Standard</emph> cells will be displayed."
-msgstr "Määritetään, että esitetään vain ne rivit, joilla on joko <item type=\"literal\">Tammikuu</item> arvona <emph>Kuukausi</emph>-soluissa TAI arvo alle 160001 <emph>Vakio</emph>-soluissa."
+msgid "Specify that only rows which either have the value <literal>January</literal> in the <emph>Month</emph> cells OR a value of under 160000 in the <emph>Standard</emph> cells will be displayed."
+msgstr ""
-#. RGEFR
+#. ApUpg
#: specialfilter.xhp
msgctxt ""
"specialfilter.xhp\n"
"par_id3147372\n"
"help.text"
-msgid "Choose <emph>Data - Filter - Advanced Filter</emph>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view."
-msgstr "Valitaan <emph>Tiedot - Suodatus - Erityissuodatus</emph> ja valitaan alue A20:E22. Kun napsautetaan OK:ta, vain suodatetut rivit jäävät näkyviin suodatettavalta alueelta. Muut rivit piilotetaan näkymästä."
+msgid "Choose <menuitem>Data - More Filters - Advanced Filter</menuitem>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view."
+msgstr ""
#. jQ6bn
#: subtotaltool.xhp