aboutsummaryrefslogtreecommitdiff
path: root/source/sl/helpcontent2/source/text/scalc/guide.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/sl/helpcontent2/source/text/scalc/guide.po')
-rw-r--r--source/sl/helpcontent2/source/text/scalc/guide.po610
1 files changed, 529 insertions, 81 deletions
diff --git a/source/sl/helpcontent2/source/text/scalc/guide.po b/source/sl/helpcontent2/source/text/scalc/guide.po
index 6d5bdfd3947..a27dee5f78a 100644
--- a/source/sl/helpcontent2/source/text/scalc/guide.po
+++ b/source/sl/helpcontent2/source/text/scalc/guide.po
@@ -1,16 +1,16 @@
#. extracted from helpcontent2/source/text/scalc/guide
msgid ""
msgstr ""
-"Project-Id-Version: LibreOffice 7.2\n"
+"Project-Id-Version: LibreOffice 7.3\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-06-02 12:02+0200\n"
-"PO-Revision-Date: 2021-05-19 23:39+0200\n"
+"POT-Creation-Date: 2021-10-15 12:35+0200\n"
+"PO-Revision-Date: 2021-10-18 18:45+0200\n"
"Last-Translator: Martin Srebotnjak <miles@filmsi.net>\n"
"Language-Team: sl.libreoffice.org\n"
+"Language: sl\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
-"Language: sl\n"
"Plural-Forms: nplurals=4; plural=(n%100==1 ? 0 : n%100==2 ? 1 : n%100==3 || n%100==4 ? 2 : 3);\n"
"X-Generator: Virtaal 0.7.1\n"
"X-Accelerator-Marker: ~\n"
@@ -366,8 +366,8 @@ msgctxt ""
"autoformat.xhp\n"
"bm_id3155132\n"
"help.text"
-msgid "<bookmark_value>tables; AutoFormat function</bookmark_value> <bookmark_value>defining;AutoFormat function for tables</bookmark_value> <bookmark_value>AutoFormat function</bookmark_value> <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>automatic formatting in spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat function</bookmark_value>"
-msgstr "<bookmark_value>tabele; funkcija Samooblikovanje</bookmark_value><bookmark_value>določanje;funkcija Samooblikovanje za tabele</bookmark_value><bookmark_value>funkcija Samooblikovanje</bookmark_value><bookmark_value>oblike; samodejno oblikovanje preglednic</bookmark_value><bookmark_value>samodejno oblikovanje v preglednicah</bookmark_value><bookmark_value>delovni listi;funkcija Samooblikovanje</bookmark_value>"
+msgid "<bookmark_value>tables; AutoFormat</bookmark_value> <bookmark_value>AutoFormat cell ranges</bookmark_value> <bookmark_value>formats; automatically formatting spreadsheets</bookmark_value> <bookmark_value>sheets;AutoFormat</bookmark_value>"
+msgstr "<bookmark_value>tabele;samooblikovanje</bookmark_value><bookmark_value>preglednice;samooblikovanje</bookmark_value><bookmark_value>samooblikovanje obsegov celic</bookmark_value><bookmark_value>oblike;samodejno oblikovanje preglednic</bookmark_value><bookmark_value>delovni listi;samooblikovanje</bookmark_value>"
#: autoformat.xhp
msgctxt ""
@@ -382,104 +382,96 @@ msgctxt ""
"autoformat.xhp\n"
"par_id3149401\n"
"help.text"
-msgid "You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range."
-msgstr "Samooblikovanje lahko uporabite za hitro oblikovanje delovnega lista ali izbranega obsega celic."
+msgid "Use the AutoFormat feature to quickly apply a format to a selected cell range."
+msgstr "Samooblikovanje uporabite za hitro oblikovanje izbranega obsega celic."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_idN10702\n"
"help.text"
-msgid "To Apply an AutoFormat to a Sheet or Selected Cell Range"
-msgstr "Uporaba samooblikovanja za delovni list ali izbran obseg celic"
+msgid "Applying an AutoFormat to a Selected Cell Range"
+msgstr "Uporaba samooblikovanja za izbran obseg celic"
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_idN106CE\n"
"help.text"
-msgid "Select the cells, including the column and row headers, that you want to format."
-msgstr "Izberite celice, vključno z glavami stolpcev in vrstic, ki jih želite oblikovati."
+msgid "Select the range of cells to which the AutoFormat style is to be applied. The range must be at least 3 columns and 3 rows in size."
+msgstr "Izberite obseg celic, v katerem želite uporabiti samooblikovanje. Obsegati mora vsaj tri stolpce in tri vrstice."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_idN106D5\n"
"help.text"
-msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>."
-msgstr "Izberite <item type=\"menuitem\">Oblika – Slogi samooblikovanja</item>."
+msgid "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialog."
+msgstr "V menijski vrstici izberite <menuitem>Oblika – Slogi samooblikovanja</menuitem>, da odprete pogovorno okno Samooblikovanje."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
-"par_id3151242\n"
+"par_id771630333791025\n"
"help.text"
-msgid "Select which properties to include in an AutoFormat."
-msgstr "Izberite lastnosti, ki jih želite vključiti v Samooblikovanje."
+msgid "In the <emph>Format</emph> list choose the AutoFormat style to apply."
+msgstr "Na seznamu <emph>Oblika</emph> izberite slog samooblikovanja, ki ga želite uporabiti."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
-"par_idN10715\n"
+"par_id3151242\n"
"help.text"
-msgid "Click <emph>OK</emph>."
-msgstr "Kliknite <emph>V redu</emph>."
+msgid "In the <emph>Formatting</emph> section choose which properties from the AutoFormat style to apply to the selected cell range."
+msgstr "V razdelku <emph>Oblikovanje</emph> izberite, katere lastnosti iz sloga samooblikovanja želite uporabiti v izbranem obsegu celic."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
-"par_idN1075D\n"
+"par_idN10715\n"
"help.text"
-msgid "The format is applied to the selected range of cells."
-msgstr "Oblika se uporabi za izbran obseg celic."
+msgid "Click <emph>OK</emph> to apply the AutoFormat style and close the dialog."
+msgstr "Kliknite <emph>V redu</emph>, da uveljavite slog samooblikovanja in zaprete pogovorno okno."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_id3149210\n"
"help.text"
-msgid "If you do not see any change in color of the cell contents, choose <item type=\"menuitem\">View - Value Highlighting</item>."
-msgstr "Če vidite, da se barva vsebine celice ni spremenila, izberite <item type=\"menuitem\">Pogled – Poudarjanje vrednosti</item>."
+msgid "In case the color of the cell contents does not change, make sure <menuitem>View - Value Highlighting</menuitem> is disabled."
+msgstr "Če vidite, da se barva vsebine celic ni spremenila, preverite, da možnost <menuitem>Pogled – Poudarjanje vrednosti</menuitem> ni potrjena."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
-"par_id3155379\n"
+"bm_id11630343392868\n"
"help.text"
-msgid "To Define an AutoFormat for Spreadsheets or Ranges"
-msgstr "Določanje samooblikovanja za preglednice in obsege"
+msgid "<bookmark_value>defining;AutoFormat styles</bookmark_value>"
+msgstr "<bookmark_value>določanje;slogi samooblikovanja</bookmark_value>"
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
-"par_id3148868\n"
+"hd_id731630343367098\n"
"help.text"
-msgid "You can define a new AutoFormat that is available to all spreadsheets and ranges."
-msgstr "Določite lahko novo samooblikovanje, ki je na voljo za vse preglednice in obsege."
+msgid "Defining a new AutoFormat style"
+msgstr "Določanje novega sloga samooblikovanja"
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_id3152985\n"
"help.text"
-msgid "Format a sheet or range."
-msgstr "Oblikujte delovni list ali obseg."
+msgid "In a Calc spreadsheet, format a cell range with at least 4 columns and 4 rows to serve as model to create the new AutoFormat style."
+msgstr "V preglednici programa Calc oblikujte obseg celic z najmanj štirimi stolpci in štirimi vrsticami kot model za izdelavo novega sloga samooblikovanja."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_id3145384\n"
"help.text"
-msgid "Choose <item type=\"menuitem\">Edit - Select All</item> or select the formatted range."
-msgstr "Izberite <item type=\"menuitem\">Uredi – Izberi vse</item> ali izberite oblikovani obseg."
-
-#: autoformat.xhp
-msgctxt ""
-"autoformat.xhp\n"
-"par_id3153815\n"
-"help.text"
-msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>."
-msgstr "Izberite <item type=\"menuitem\">Oblika – Slogi samooblikovanja</item>."
+msgid "Select the cell range formatted in the previous step and go to <menuitem>Format - AutoFormat Styles</menuitem>."
+msgstr "Izberite v prejšnjem koraku oblikovani obseg in izberite <menuitem>Oblika – Slogi samooblikovanja</menuitem>."
#: autoformat.xhp
msgctxt ""
@@ -494,16 +486,24 @@ msgctxt ""
"autoformat.xhp\n"
"par_idN10760\n"
"help.text"
-msgid "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the format."
-msgstr "V polje <emph>Ime</emph> pogovornega okna <emph>Dodaj samooblikovanje</emph> vnesite ime za obliko."
+msgid "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the new AutoFormat style."
+msgstr "V polje <emph>Ime</emph> v pogovornem oknu <emph>Dodaj samooblikovanje</emph> vnesite ime za nov slog samooblikovanja."
#: autoformat.xhp
msgctxt ""
"autoformat.xhp\n"
"par_idN107C3\n"
"help.text"
-msgid "Click <emph>OK</emph>."
-msgstr "Kliknite <emph>V redu</emph>."
+msgid "Click <emph>OK</emph> and close the dialog."
+msgstr "Kliknite <emph>V redu</emph>, da zaprete pogovorno okno."
+
+#: autoformat.xhp
+msgctxt ""
+"autoformat.xhp\n"
+"par_id51630343134146\n"
+"help.text"
+msgid "The new AutoFormat styles created using the steps above can be applied to any %PRODUCTNAME Calc file. Hence they are not limited to the file where the style was created."
+msgstr "Z gornjimi koraki novo ustvarjene sloge samooblikovanja lahko uporabite s sleherno datoteko %PRODUCTNAME Calc. Tako niso omejeni na datoteko, v kateri je slog nastal."
#: autoformat.xhp
msgctxt ""
@@ -646,7 +646,7 @@ msgctxt ""
"borders.xhp\n"
"bm_id3457441\n"
"help.text"
-msgid "<bookmark_value>cells;borders</bookmark_value> <bookmark_value>line arrangements with cells</bookmark_value> <bookmark_value>borders;cells</bookmark_value>"
+msgid "<bookmark_value>cells;borders</bookmark_value> <bookmark_value>line arrangements with cells</bookmark_value> <bookmark_value>borders;cells</bookmark_value>"
msgstr "<bookmark_value>celice;obrobe</bookmark_value><bookmark_value>postavitev črt s celicami</bookmark_value><bookmark_value>obrobe;celice</bookmark_value>"
#: borders.xhp
@@ -804,14 +804,6 @@ msgstr "<image id=\"img_id8139591\" src=\"media/helpimg/border_ca_4.png\" width=
#: borders.xhp
msgctxt ""
"borders.xhp\n"
-"par_id5383465\n"
-"help.text"
-msgid "You cannot apply borders to multiple selections."
-msgstr "Obrob ne morete uporabiti za več izbir hkrati."
-
-#: borders.xhp
-msgctxt ""
-"borders.xhp\n"
"hd_id7790154\n"
"help.text"
msgid "Default Settings"
@@ -1105,6 +1097,46 @@ msgctxt ""
msgid "<image id=\"img_id5380718\" src=\"media/helpimg/border_ca_9.png\" width=\"1.2602in\" height=\"1.1252in\"><alt id=\"alt_id5380718\">advanced example for cell borders</alt></image>"
msgstr "<image id=\"img_id5380718\" src=\"media/helpimg/border_ca_9.png\" width=\"1.2602in\" height=\"1.1252in\"><alt id=\"alt_id5380718\">Napredni primer obrob celice</alt></image>"
+#: borders.xhp
+msgctxt ""
+"borders.xhp\n"
+"bm_id151630452717743\n"
+"help.text"
+msgid "<bookmark_value>adjacent cells;remove border</bookmark_value>"
+msgstr "<bookmark_value>soležne celice;odstranjevanje obrob</bookmark_value>"
+
+#: borders.xhp
+msgctxt ""
+"borders.xhp\n"
+"hd_id861630451554176\n"
+"help.text"
+msgid "Adjacent Cells"
+msgstr "Soležne celice"
+
+#: borders.xhp
+msgctxt ""
+"borders.xhp\n"
+"par_id231630451548190\n"
+"help.text"
+msgid "This option becomes available when formatting a range of cells that already have borders and the new format defined for the range involves removing outer borders."
+msgstr "Ta možnost je na voljo, če oblikujete obseg celic, ki že imajo obrobe, in nova oblika, določena za obseg, vključuje odstranitev zunanjih obrob."
+
+#: borders.xhp
+msgctxt ""
+"borders.xhp\n"
+"par_id931630451706604\n"
+"help.text"
+msgid "By default the option <emph>Remove border</emph> is disabled and the borders at the edges of the selected range are left unchanged. Check this option if the borders at the edge of the selection should be removed."
+msgstr "Možnost <emph>Odstrani obrobo</emph> je privzeto onemogočena in obrobe ne robovih izbranega obsega ostanejo nespremenjene. Potrdite to možnost, če želite obrobe na robu izbora odstraniti."
+
+#: borders.xhp
+msgctxt ""
+"borders.xhp\n"
+"par_id641630452272324\n"
+"help.text"
+msgid "If the preset <emph>No Borders</emph> is chosen then the <emph>Remove border</emph> option is enabled."
+msgstr "Če izberete prednastavitev <emph>Brez obrob</emph>, je možnost <emph>Odstrani obrobo</emph> omogočena."
+
#: calc_date.xhp
msgctxt ""
"calc_date.xhp\n"
@@ -9465,6 +9497,110 @@ msgctxt ""
msgid "Aside from when new rows and columns are inserted, references can also change when an existing formula referring to particular cells is copied to another area of the sheet. Assume you entered the formula =SUM(A1:A9) in row 10. If you want to calculate the sum for the adjacent column to the right, simply copy this formula to the cell to the right. The copy of the formula in column B will be automatically adjusted to =SUM(B1:B9)."
msgstr "Sklici se lahko spremenijo ne le takrat, ko vstavite vrstice in stolpce, temveč tudi ko obstoječo formulo, ki se nanaša na določeno celico, kopirate na drugo območje delovnega lista. Recimo, da ste v vrstico 10 vpisali formulo =VSOTA(A1:A9). Če želite izračunati vsoto za sosednji stolpec na desni, enostavno kopirajte to formulo v celico na desni. Kopija formule v stolpcu B se bo samodejno prilagodila v =VSOTA(B1:B9)."
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"tit\n"
+"help.text"
+msgid "Removing Duplicate Values"
+msgstr "Odstranjevanje podvojenih vrednosti"
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"bm_id3153896\n"
+"help.text"
+msgid "<bookmark_value>filters; removing duplicates</bookmark_value> <bookmark_value>filters; finding unique values</bookmark_value>"
+msgstr "<bookmark_value>filtri; odstranjevanje dvojnikov</bookmark_value><bookmark_value>filtri;podvojene vrednosti</bookmark_value><bookmark_value>filtri;iskanje enkratnih vrednosti</bookmark_value>"
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"hd_id501630021281902\n"
+"help.text"
+msgid "<variable id=\"filters\"><link href=\"text/scalc/guide/remove_duplicates.xhp\" name=\"Duplicates_h1\">Removing Duplicate Values</link></variable>"
+msgstr "<variable id=\"filters\"><link href=\"text/scalc/guide/remove_duplicates.xhp\" name=\"Odstranjevanje podvojenih vrednosti\">Odstranjevanje podvojenih vrednosti</link></variable>"
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id3150869\n"
+"help.text"
+msgid "Consider a single column with values where some may be duplicates. To remove duplicate values and obtain only the unique entries in the column:"
+msgstr "Vzemimo za primer en stolpec z vrednostmi, med katerimi so dvojniki. Če želite odstraniti podvojene vrednosti in pridobiti samo enkratne vnose v stolpcu, storite naslednje:"
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id631630021463659\n"
+"help.text"
+msgid "Select the range of values from which duplicate values are to be removed. The values have to be arranged in a single column."
+msgstr "Izberite obseg vrednosti, iz katerega želite odstraniti podvojene vrednosti. Vrednosti se morajo nahajati v enem samem stolpcu."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id31630021517873\n"
+"help.text"
+msgid "Go to <menuitem>Data - More Filters - Standard Filter</menuitem>. This opens the <embedvar href=\"text/shared/02/12090100.xhp#StandardFilter_h1\"/> dialog."
+msgstr "Izberite <menuitem>Podatki – Več filtrov – Standardni filter</menuitem>. S tem se odpre pogovorno okno <embedvar href=\"text/shared/02/12090100.xhp#StandardFilter_h1\"/>.***"
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id801630022108301\n"
+"help.text"
+msgid "In <emph>Field Name</emph> make sure that the selected column is the column where the values are stored. If a single column is selected this field will be set automatically."
+msgstr "Pod <emph>Ime polja</emph> preverite, da je izbrani stolpec ta, v katerem so shranjene vrednosti. Če je izbran en sam stolpec, bo to polje določeno samodejno."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id461630022298515\n"
+"help.text"
+msgid "In <emph>Condition</emph> choose the option <emph>=</emph> (equals sign), which is the default option."
+msgstr "Pod <emph>Pogoj</emph> izberite možnost <emph>=</emph> (enačaj), ki je privzeta izbira."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id261630022372414\n"
+"help.text"
+msgid "In <emph>Value</emph> choose the option <emph>Not Empty</emph>."
+msgstr "Pod <emph>Vrednost</emph> izberite možnost <emph>Ni prazna</emph>."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id441630022436605\n"
+"help.text"
+msgid "Click <emph>Options</emph> and select <emph>No duplications</emph>. If the first value is the column header check <emph>Range contains column labels</emph>."
+msgstr "Kliknite <emph>Možnosti</emph> in izberite <emph>Brez dvojnikov</emph>. Če je prva vrednost glava stolpca, potrdite možnost <emph>Obseg vsebuje oznake stolpcev</emph>."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id841630022924442\n"
+"help.text"
+msgid "Check <emph>Copy results</emph> and use the input box below it to inform a cell address where the unique entries are to be entered."
+msgstr "Potrdite <emph>Kopiraj rezultate</emph> in uporabite polje pod njo, da vnesete naslov celice, kjer bodo vneseni enkratni vnosi."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id61630023053412\n"
+"help.text"
+msgid "Click <emph>OK</emph>. The unique values in the range will be entered starting with the cell selected in the previous step."
+msgstr "Kliknite <emph>V redu</emph>. Enkratni vrednosti v obsegu bodo vnesene začenši s celico, izbrano v prejšnjem koraku."
+
+#: remove_duplicates.xhp
+msgctxt ""
+"remove_duplicates.xhp\n"
+"par_id81630022708336\n"
+"help.text"
+msgid "The <emph>No duplications</emph> option is case sensitive. Therefore, values \"A\" and \"a\" are each considered as unique values."
+msgstr "Možnost <emph>Brez dvojnikov</emph> loči med velikimi in malimi črkami. Tako štejeta vrednosti »A« in »a« za različni, enkratni vrednosti."
+
#: rename_table.xhp
msgctxt ""
"rename_table.xhp\n"
@@ -10166,8 +10302,8 @@ msgctxt ""
"specialfilter.xhp\n"
"tit\n"
"help.text"
-msgid "Filter: Applying Advanced Filters"
-msgstr "Filter: Uveljavljanje naprednih filtrov"
+msgid "Applying Advanced Filters"
+msgstr "Uporaba naprednih filtrov"
#: specialfilter.xhp
msgctxt ""
@@ -10182,8 +10318,8 @@ msgctxt ""
"specialfilter.xhp\n"
"hd_id3148798\n"
"help.text"
-msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link></variable>"
-msgstr "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Filtriranje: uporaba naprednih filtrov\">Filtriranje: uporaba naprednih filtrov</link></variable>"
+msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Applying Advanced Filters\">Applying Advanced Filters</link></variable>"
+msgstr "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Uporaba naprednih filtrov\">Uporaba naprednih filtrov</link></variable>"
#: specialfilter.xhp
msgctxt ""
@@ -10590,32 +10726,32 @@ msgctxt ""
"table_cellmerge.xhp\n"
"tit\n"
"help.text"
-msgid "Merging and Splitting Cells"
-msgstr "Spajanje in deljenje celic"
+msgid "Merge and Unmerge Cells"
+msgstr "Spoji in razdeli spojene celice"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
-"bm_id3147240\n"
+"bm_id501632012952361\n"
"help.text"
-msgid "<bookmark_value>cells; merging/unmerging</bookmark_value> <bookmark_value>tables; merging cells</bookmark_value> <bookmark_value>cell merges</bookmark_value> <bookmark_value>unmerging cells</bookmark_value> <bookmark_value>splitting cells</bookmark_value> <bookmark_value>merging;cells</bookmark_value>"
-msgstr "<bookmark_value>celice; spajanje/deljenje</bookmark_value><bookmark_value>tabele; spajanje celic</bookmark_value><bookmark_value>spoji celic</bookmark_value><bookmark_value>deljenje celic</bookmark_value><bookmark_value>razdeljevanje celic</bookmark_value><bookmark_value>spajanje;celice</bookmark_value>"
+msgid "<bookmark_value>merge/merging cells</bookmark_value> <bookmark_value>unmerge/unmerging cells</bookmark_value> <bookmark_value>split/splitting cells</bookmark_value>"
+msgstr "<bookmark_value>celice;delitev spojenih celic</bookmark_value><bookmark_value>delitev spojenih celic</bookmark_value><bookmark_value>delitev celic</bookmark_value>"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"hd_id8005005\n"
"help.text"
-msgid "<variable id=\"table_cellmerge\"><link href=\"text/scalc/guide/table_cellmerge.xhp\" name=\"Merging and Unmerging Cells\">Merging and Unmerging Cells</link></variable>"
-msgstr "<variable id=\"table_cellmerge\"><link href=\"text/scalc/guide/table_cellmerge.xhp\" name=\"Spajanje in deljenje celic\">Spajanje in deljenje celic</link></variable>"
+msgid "<variable id=\"table_cellmerge\"><link href=\"text/scalc/guide/table_cellmerge.xhp\" name=\"Merging and Unmerging Cells\">Merge and Unmerge Cells</link></variable>"
+msgstr "<variable id=\"table_cellmerge\"><link href=\"text/scalc/guide/table_cellmerge.xhp\" name=\"Spoji in razdeli spojene celice\">Spoji in razdeli spojene celice</link></variable>"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"par_id8049867\n"
"help.text"
-msgid "You can select adjacent cells, then merge them into a single cell. Conversely, you can take a large cell that has been created by merging single cells, and divide it back into individual cells."
-msgstr "Izberete lahko soležne celice in jih spojite v eno celico. V obratni smeri lahko veliko celico, ki je bila ustvarjena s spajanjem celic, razdelite nazaj na posamezne celice."
+msgid "You can select a range of cells, then merge them into a single cell. Conversely, you can take a previously merged cell and divide it back into individual cells."
+msgstr "Izberete lahko obseg celic in jih spojite v eno samo celico. V nasprotni smeri lahko poprej spojeno celico razdelite nazaj na sestavne celice."
#: table_cellmerge.xhp
msgctxt ""
@@ -10630,48 +10766,120 @@ msgctxt ""
"table_cellmerge.xhp\n"
"hd_id235602\n"
"help.text"
-msgid "Merging Cells"
-msgstr "Spajanje celic"
+msgid "Merge Cells"
+msgstr "Spoji celice"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"par_id1272927\n"
"help.text"
-msgid "Select the adjacent cells."
-msgstr "Izberite soležne celice."
+msgid "Click and drag to select the cells to be merged then do one of the following:"
+msgstr "Kliknite in povlecite, da izberete celice, ki jih želite spojiti, nato storite nekaj od naslednjega:"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id221632803290526\n"
+"help.text"
+msgid "In the Formatting toolbar click:"
+msgstr "V vrstici Oblikovanje kliknite:"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id3154351\n"
+"help.text"
+msgid "Or, right click the selection to open the context menu and choose <menuitem>Merge Cells</menuitem>.<br/>If <menuitem>Unmerge Cells</menuitem> is present instead then the cell selection contains merged cells and cannot be merged further."
+msgstr "Lahko tudi desno kliknete izbor, da odprete kontekstni meni, v katerem izberete ukaz <menuitem>Spoji celice</menuitem>.<br/>Če je namesto njega na voljo ukaz <menuitem>Razdeli spojene celice</menuitem>, to pomeni, da izbor celic vsebuje spojene celice in da ga ni mogoče nadalje spajati."
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id931632803442925\n"
+"help.text"
+msgid "Or, in the <emph>Properties</emph> sidebar mark the <emph>Merge Cells</emph> checkbox."
+msgstr "V stranski vrstici na zloženem zavihku <emph>Lastnosti</emph> potrdite polje <emph>Spoji celice</emph>."
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id3154020\n"
+"help.text"
+msgid "Or, choose <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Merge Cells</menuitem>"
+msgstr "Izberite <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Spoji Celice</menuitem>.***"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"par_id6424146\n"
"help.text"
-msgid "Choose <emph>Format - Merge Cells - Merge Cells</emph>. If you choose <emph>Format - Merge Cells - Merge and Center Cells</emph>, the cell content will be centered in the merged cell."
-msgstr "Izberite <emph>Oblika – Spoji celice – Spoji celice</emph>. Če izberete <emph>Oblika – Spoji celice – Spoji celice in jih poravnaj na sredino</emph>, bo vsebina celice v spojeni celici poravnana sredinsko."
+msgid "Or, choose <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Merge and Center Cells</menuitem>"
+msgstr "Izberite <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Spoji celice in poravnaj na sredino</menuitem>.***"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id961632012538771\n"
+"help.text"
+msgid "The cells will be merged and the content will be centered in the merged cell."
+msgstr "Celice se spojijo, vsebina pa je sredinsko poravnana v izbrani celici."
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"hd_id451368\n"
"help.text"
-msgid "Splitting Cells"
-msgstr "Razdeljevanje celic"
+msgid "Unmerge Cells"
+msgstr "Razdeli spojene celice"
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"par_id7116611\n"
"help.text"
-msgid "Place the cursor in the cell to be split."
-msgstr "Postavite kazalko v celico, ki jo želite razdeliti."
+msgid "Select the cell to be unmerged, or a selection that includes the cells to be unmerged then do one of the following:"
+msgstr "Izberite spojeno celico, ki jo želite razdeliti, ali obseg celic, ki vsebuje takšne spojene celice, nato storite nekaj od naslednjega:"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id581632820903635\n"
+"help.text"
+msgid "In the Formatting toolbar, click:"
+msgstr "V vrstici Oblikovanje kliknite:"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id431632277778130\n"
+"help.text"
+msgid "Or, right click the selection to open the context menu and choose <menuitem>Unmerge Cells</menuitem>.<br/>If <menuitem>Merge Cells</menuitem> is present instead then the selection does not contain any merged cells."
+msgstr "Lahko tudi desno kliknete izbor, da odprete kontekstni meni, v katerem izberete <menuitem>Razdeli spojene celice</menuitem>.<br/>Če je namesto njega prisoten ukaz <menuitem>Spoji celice</menuitem>, to pomeni, da izbor ne vsebuje spojenih celic."
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id261632277824041\n"
+"help.text"
+msgid "Or, in the <emph>Properties</emph> sidebar clear the <emph>Merge Cells</emph> checkbox."
+msgstr "V stranski vrstici na zloženem zavihku <emph>Lastnosti</emph> počistite potrditveno polje <emph>Spoji celice</emph>."
#: table_cellmerge.xhp
msgctxt ""
"table_cellmerge.xhp\n"
"par_id9493087\n"
"help.text"
-msgid "Choose <emph>Format - Merge Cells - Split Cells</emph>."
-msgstr "Izberite <emph>Oblika – Spoji celice – Razdeli celice</emph>."
+msgid "Or, choose <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Unmerge Cells</menuitem>."
+msgstr "Izberite <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Razdeli spojene celice</menuitem>.***"
+
+#: table_cellmerge.xhp
+msgctxt ""
+"table_cellmerge.xhp\n"
+"par_id561632820960500\n"
+"help.text"
+msgid "Or, toggle <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Merge and Center Cells</menuitem>"
+msgstr "Ali preklopite možnost <embedvar href=\"text/scalc/01/05060000.xhp#format_mergecells_menu\"/><menuitem>Spoji celice in poravnaj na sredino</menuitem>***"
#: table_rotate.xhp
msgctxt ""
@@ -11809,6 +12017,246 @@ msgctxt ""
msgid "<link href=\"text/scalc/01/04090000.xhp\" name=\"External data dialog\">External data dialog</link>"
msgstr "<link href=\"text/scalc/01/04090000.xhp\" name=\"Pogovorno okno zunanji podatki\">Pogovorno okno zunanji podatki</link>"
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"tit\n"
+"help.text"
+msgid "Using Wildcards in Formulas"
+msgstr "Uporaba nadomestnih znakov v formulah"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"bm_id3152149\n"
+"help.text"
+msgid "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>"
+msgstr "<bookmark_value>nadomestni znaki;v formulah</bookmark_value><bookmark_value>nadomestni znaki;primeri</bookmark_value><bookmark_value>formule;nadomestni znaki</bookmark_value>"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"hd_id941629155075179\n"
+"help.text"
+msgid "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\" name=\"wildcards_link\">Using Wildcards in Formulas</link></variable>"
+msgstr "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\" name=\"Uporaba nadomestnih znakov v formulah\">Uporaba nadomestnih znakov v formulah</link></variable>"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id571629155308959\n"
+"help.text"
+msgid "Wildcards are special characters that can be used in search strings that are passed as arguments to some Calc functions. They can also be used to define search criteria in the <emph>Find & Replace</emph> dialog. The use of wildcards enables the definition of more advanced search parameters with a single search string."
+msgstr "Nadomestni znaki so posebni znaki, ki jih lahko uporabite v iskalnih nizih, ki jih podate kot argumente nekaterim funkcijam programa Calc. Uporabite jih lahko tudi za določanje iskalnih pogojev v pogovornem oknu <emph>Najdi in zamenjaj</emph>. Uporaba nadomestnih znakov omogoča določanje naprednejših iskalnih parametrov z enim samim iskalnim nizom."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id391629156224638\n"
+"help.text"
+msgid "%PRODUCTNAME Calc supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as arguments depending on the current application settings. By default %PRODUCTNAME Calc is set to support wildcards instead of regular expressions."
+msgstr "%PRODUCTNAME Calc kot argumente podpira <emph>nadomestne znake</emph> ali <emph>regularne izraze</emph>, odvisno od trenutnih nastavitev programa. %PRODUCTNAME Calc privzeto podpira nadomestne znake in ne regularnih izrazov."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id551629156504794\n"
+"help.text"
+msgid "To make sure wildcards are supported, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and check if the option <emph>Enable wildcards in formulas</emph> is selected. Note that you can use this dialog to switch to regular expressions by choosing <emph>Enable regular expressions in formulas</emph> or choose to support neither wildcards nor regular expressions."
+msgstr "Da preverite, ali so nadomestni znaki podprti, izberite <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>LibreOffice – Nastavitve – %PRODUCTNAME Calc – Izračuni</menuitem></caseinline><defaultinline><menuitem>Orodja – Možnosti – %PRODUCTNAME Calc – Izračuni</menuitem></defaultinline></switchinline> in preverite, če je možnost <emph>Omogoči nadomestne znake v formulah</emph> potrjena. Upoštevajte, da lahko v tem pogovornem oknu omogočite uporabo regularnih izrazov, tako da potrdite možnost <emph>Omogoči regularne izraze v formulah</emph> ali pa določite, da ne želite podpore niti za nadomestne znake niti za regularne izraze."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id141629156913731\n"
+"help.text"
+msgid "The following wildcards are supported:"
+msgstr "Podprti so naslednji nadomestni znaki:"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id801629209195110\n"
+"help.text"
+msgid "Wildcard"
+msgstr "Nadomestni znak"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id861629209212608\n"
+"help.text"
+msgid "Description"
+msgstr "Opis"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id591629209073388\n"
+"help.text"
+msgid "<emph>? (question mark)</emph>"
+msgstr "<emph>? (vprašaj)</emph>"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id31629209073388\n"
+"help.text"
+msgid "Matches any single character. For example, the search string \"b?g\" matches “bag” and “beg” but will not match \"boog\" or \"mug\"."
+msgstr "Zadetek je vsak posamezen znak. Primer: iskalni niz \"b?g\" najde »bog« in »beg«, ne pa tudi »blag« ali »rog«."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id121629209114452\n"
+"help.text"
+msgid "Note that it will not match \"bg\" as well, since \"?\" must match exactly <emph>one</emph> character. The \"?\" wildcard does not correspond to a zero-character match."
+msgstr "Upoštevajte, da med zadetki prav tako ne bo »bg«, saj se »?« mora ujemati z natanko <emph>enim</emph> znakom. Nadomestni znak »?« kot zadetka ne vrne ničelnega znaka."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id981629209073388\n"
+"help.text"
+msgid "<emph>* (asterisk)</emph>"
+msgstr "<emph>* (zvezdica)</emph>"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id51629209073388\n"
+"help.text"
+msgid "Matches any sequence of characters, including an empty string. For example, the search string \"*cast\" will match “cast”, “forecast”, and “outcast”, but will not match \"forecaster\" using default %PRODUCTNAME settings."
+msgstr "Zadetki so poljubni znakovni nizi, vključno s praznim nizom. Primer: ob privzetih nastavitvah %PRODUCTNAME iskalni niz »*kost« vrne zadetke, kot so »kost«, »enakost« in »krhkost«, ne pa tudi »okostje«."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id351629209153307\n"
+"help.text"
+msgid "If the option <menuitem>Search criteria = and <> must apply to whole cells</menuitem> is disabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then \"forecaster\" will be a match using the \"*cast\" search string."
+msgstr "Če možnost <menuitem>Iskalna pogoja = in <> morata biti uporabljena za cele celice</menuitem> pod <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME – Nastavitve – %PRODUCTNAME Calc – Izračuni</menuitem></caseinline><defaultinline><menuitem>Orodja – Možnosti – %PRODUCTNAME Calc – Izračuni</menuitem></defaultinline></switchinline> ni potrjena, potem bo »okostje« zadetek pri iskanju z iskalnim nizom »*kost«."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id181629209277556\n"
+"help.text"
+msgid "<emph>~ (tilde)</emph>"
+msgstr "<emph>~ (tilda)</emph>"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id881629209280877\n"
+"help.text"
+msgid "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character."
+msgstr "<emph>~</emph> (tilda) predstavlja alternativen pomen vprašaja, zvezdice ali tilde, ki neposredno sledijo znaku tilda"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id861629209431020\n"
+"help.text"
+msgid "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\"."
+msgstr "Primer: iskalni niz »zakaj~?« najde zadetek »zakaj?«, ne pa tudi »zakaji« in »zakaj~i«."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id1001629157561261\n"
+"help.text"
+msgid "Wildcards are supported in %PRODUCTNAME Calc and in Microsoft Excel. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities."
+msgstr "Nadomestni znaki so podprti v programih %PRODUCTNAME Calc in Microsoft Excel. Če želite zagotoviti prenosljivost dokumentov med obema programoma, izberite rabo nadomestnih znakov in ne regularnih izrazov. Če medopravilnost ni potrebna, pa razmislite o uporabi regularnih izrazov, saj nudijo zmogljivejše zmožnosti iskanja."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"hd_id671629158766165\n"
+"help.text"
+msgid "Supported Spreadsheet Functions"
+msgstr "Podprte funkcije preglednice"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id161629158785887\n"
+"help.text"
+msgid "Wildcards are supported by the following spreadsheet functions:"
+msgstr "Nadomestne znake lahko uporabite v naslednjih funkcijah preglednice:"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id441629158810517\n"
+"help.text"
+msgid "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP."
+msgstr "<emph>Funkcije zbirke podatkov:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR in DVARP."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id321629158810916\n"
+"help.text"
+msgid "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS."
+msgstr "<emph>Pogojne funkcije:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF in SUMIFS."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id941629158811325\n"
+"help.text"
+msgid "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP."
+msgstr "<emph>Funkcije iskanja:</emph> HLOOKUP, LOOKUP in VLOOKUP."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id41629158919808\n"
+"help.text"
+msgid "<emph>Other functions:</emph> MATCH and SEARCH."
+msgstr "<emph>Druge funkcije:</emph> MATCH in SEARCH."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"hd_id701629159564269\n"
+"help.text"
+msgid "Examples of Wildcards in Formulas"
+msgstr "Primeri rabe nadomestnih znakov v formulah"
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id121629289062103\n"
+"help.text"
+msgid "The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>."
+msgstr "Pri naslednjih primerih sta možnosti <menuitem>V formulah omogoči nadomestne znake</menuitem> in <menuitem>Iskalna pogoja = in <> morata biti uporabljena za cele celice</menuitem> potrjeni v <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>LibreOffice – Nastavitve – %PRODUCTNAME Calc – Izračuni</menuitem></caseinline><defaultinline><menuitem>Orodja – Možnosti – %PRODUCTNAME Calc – Izračuni</menuitem></defaultinline></switchinline>."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id271629159111490\n"
+"help.text"
+msgid "<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."
+msgstr "<input>=COUNTIF(A1:A10;\"Či*\")</input> vrne število celic v obsegu <emph>A1:A10</emph>, ki vsebujejo nize, ki se začenjajo s »Či«, čemur sledi nič ali več znakov."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id741629159343415\n"
+"help.text"
+msgid "<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."
+msgstr "<input>=SUMIF(A1:A5;\"A??\";B1:B5)</input> sešteje vrednosti v <emph>B1:B5</emph>, katerih ustrezne vrednosti v <emph>A1:A5</emph> se začenjajo z »A«, ki mu sledita natanko dva druga znaka."
+
+#: wildcards.xhp
+msgctxt ""
+"wildcards.xhp\n"
+"par_id141629159465592\n"
+"help.text"
+msgid "Wildcard comparisons are <emph>not</emph> case sensitive, hence \"A?\" will match both \"A1\" and \"a1\"."
+msgstr "Primerjave nadomestnih znakov <emph>ne</emph> razlikujejo med velikimi in malimi črkami, zato se »A?« ujema tako z »A1« kot z »a1«."
+
#: year2000.xhp
msgctxt ""
"year2000.xhp\n"