diff options
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/guide.po')
| -rw-r--r-- | source/en-GB/helpcontent2/source/text/scalc/guide.po | 579 |
1 files changed, 501 insertions, 78 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/guide.po b/source/en-GB/helpcontent2/source/text/scalc/guide.po index faea39ef9c3..a27e35e696b 100644 --- a/source/en-GB/helpcontent2/source/text/scalc/guide.po +++ b/source/en-GB/helpcontent2/source/text/scalc/guide.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE 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-05-31 15:15+0200\n" +"POT-Creation-Date: 2021-09-10 23:11+0200\n" "PO-Revision-Date: 2020-09-10 05:35+0000\n" "Last-Translator: Stuart Swales <stuart.swales.croftnuisk@gmail.com>\n" "Language-Team: English (United Kingdom) <https://weblate.documentfoundation.org/projects/libo_help-master/textscalcguide/en_GB/>\n" @@ -403,14 +403,14 @@ msgctxt "" msgid "Using AutoFormat for Tables" msgstr "Using AutoFormat for Tables" -#. 33hwy +#. V4grY #: autoformat.xhp 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>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>" +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 "" #. EiEMB #: autoformat.xhp @@ -421,122 +421,113 @@ msgctxt "" msgid "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\" name=\"Using AutoFormat for Tables\">Applying Automatic Formatting to a Selected Cell Range</link></variable>" msgstr "<variable id=\"autoformat\"><link href=\"text/scalc/guide/autoformat.xhp\" name=\"Using AutoFormat for Tables\">Applying Automatic Formatting to a Selected Cell Range</link></variable>" -#. CC2ie +#. 7xexA #: autoformat.xhp 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 "You can use the AutoFormat feature to quickly apply a format to a sheet or a selected cell range." +msgid "Use the AutoFormat feature to quickly apply a format to a selected cell range." +msgstr "" -#. FGf7G +#. rA9iM #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN10702\n" "help.text" -msgid "To Apply an AutoFormat to a Sheet or Selected Cell Range" -msgstr "To Apply an AutoFormat to a Sheet or Selected Cell Range" +msgid "Applying an AutoFormat to a Selected Cell Range" +msgstr "" -#. XEBko +#. jDKjA #: 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 "Select the cells, including the column and row headers, that you want to format." +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 "" -#. PMa8H +#. 6GCsB #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN106D5\n" "help.text" -msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." -msgstr "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." +msgid "Go to <menuitem>Format - AutoFormat Styles</menuitem> to open the AutoFormat dialog." +msgstr "" -#. YT4xh +#. CXiex #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_id3151242\n" +"par_id771630333791025\n" "help.text" -msgid "Select which properties to include in an AutoFormat." -msgstr "Select which properties to include in an AutoFormat." +msgid "In the <emph>Format</emph> list choose the AutoFormat style to apply." +msgstr "" -#. dhKwA +#. tCZL9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_idN10715\n" +"par_id3151242\n" "help.text" -msgid "Click <emph>OK</emph>." -msgstr "Click <emph>OK</emph>." +msgid "In the <emph>Formatting</emph> section choose which properties from the AutoFormat style to apply to the selected cell range." +msgstr "" -#. 5rFWK +#. rgXQa #: 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 "The format is applied to the selected range of cells." +msgid "Click <emph>OK</emph> to apply the AutoFormat style and close the dialog." +msgstr "" -#. gG5Fm +#. EAyCv #: 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 "If you do not see any change in colour of the cell content, choose <item type=\"menuitem\">View - Value Highlighting</item>." +msgid "In case the color of the cell contents does not change, make sure <menuitem>View - Value Highlighting</menuitem> is disabled." +msgstr "" -#. WuFW6 +#. ovMm9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" -"par_id3155379\n" +"bm_id11630343392868\n" "help.text" -msgid "To Define an AutoFormat for Spreadsheets or Ranges" -msgstr "To Define an AutoFormat for Spreadsheets or Ranges" +msgid "<bookmark_value>defining;AutoFormat styles</bookmark_value>" +msgstr "" -#. kMXDR +#. 5DZHa #: 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 "You can define a new AutoFormat that is available to all spreadsheets and ranges." +msgid "Defining a new AutoFormat style" +msgstr "" -#. LBQQi +#. 2QDCM #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_id3152985\n" "help.text" -msgid "Format a sheet or range." -msgstr "Format a sheet or range." +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 "" -#. JVW7G +#. 3GsCL #: 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 "Choose <item type=\"menuitem\">Edit - Select All</item> or select the formatted range." - -#. VuwGM -#: autoformat.xhp -msgctxt "" -"autoformat.xhp\n" -"par_id3153815\n" -"help.text" -msgid "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." -msgstr "Choose <item type=\"menuitem\">Format - AutoFormat Styles</item>." +msgid "Select the cell range formatted in the previous step and go to <menuitem>Format - AutoFormat Styles</menuitem>." +msgstr "" #. CzaoG #: autoformat.xhp @@ -547,23 +538,32 @@ msgctxt "" msgid "Click <emph>Add</emph>." msgstr "Click <emph>Add</emph>." -#. FDB4v +#. GxXmX #: autoformat.xhp 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 "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialogue box, enter a name for the format." +msgid "In the <emph>Name</emph> box of the <emph>Add AutoFormat</emph> dialog, enter a name for the new AutoFormat style." +msgstr "" -#. YWSGG +#. pMxn9 #: autoformat.xhp msgctxt "" "autoformat.xhp\n" "par_idN107C3\n" "help.text" -msgid "Click <emph>OK</emph>." -msgstr "Click <emph>OK</emph>." +msgid "Click <emph>OK</emph> and close the dialog." +msgstr "" + +#. HJiDi +#: 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 "" #. hpPvo #: autoformat.xhp @@ -718,14 +718,14 @@ msgctxt "" msgid "User Defined Borders in Cells" msgstr "User-Defined Borders in Cells" -#. GxTZ8 +#. RRraV #: borders.xhp 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>" -msgstr "<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 "" #. ajMCN #: borders.xhp @@ -898,15 +898,6 @@ msgctxt "" msgid "<image id=\"img_id8139591\" src=\"media/helpimg/border_ca_4.png\" width=\"1.2602in\" height=\"1.5937in\"><alt id=\"alt_id8139591\">borders with a block selected</alt></image>" msgstr "<image id=\"img_id8139591\" src=\"media/helpimg/border_ca_4.png\" width=\"1.2602in\" height=\"1.5937in\"><alt id=\"alt_id8139591\">borders with a block selected</alt></image>" -#. j9iat -#: borders.xhp -msgctxt "" -"borders.xhp\n" -"par_id5383465\n" -"help.text" -msgid "You cannot apply borders to multiple selections." -msgstr "You cannot apply borders to multiple selections." - #. 2gKsC #: borders.xhp msgctxt "" @@ -1240,6 +1231,51 @@ 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\">advanced example for cell borders</alt></image>" +#. KKHLH +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"bm_id151630452717743\n" +"help.text" +msgid "<bookmark_value>adjacent cells;remove border</bookmark_value>" +msgstr "" + +#. eEE4F +#: borders.xhp +msgctxt "" +"borders.xhp\n" +"hd_id861630451554176\n" +"help.text" +msgid "Adjacent Cells" +msgstr "" + +#. k8s2o +#: 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 "" + +#. xADD4 +#: 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 "" + +#. V8sNd +#: 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 "" + #. kCAyU #: calc_date.xhp msgctxt "" @@ -10645,6 +10681,123 @@ 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 "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 that 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)." +#. kAFBF +#: remove_duplicates.xhp +msgctxt "" +"remove_duplicates.xhp\n" +"tit\n" +"help.text" +msgid "Removing Duplicate Values" +msgstr "" + +#. hGQvA +#: 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 "" + +#. Q5494 +#: 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 "" + +#. ocizx +#: 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 "" + +#. omVUk +#: 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 "" + +#. XvTTj +#: 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 "" + +#. EVEzq +#: 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 "" + +#. TesFn +#: 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 "" + +#. nWrGh +#: 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 "" + +#. fFZRM +#: 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 "" + +#. sdBSD +#: 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 "" + +#. DJcXh +#: 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 "" + +#. 3qh4V +#: 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 "" + #. cPpmr #: rename_table.xhp msgctxt "" @@ -11428,14 +11581,14 @@ msgctxt "" msgid "<link href=\"text/shared/optionen/01060400.xhp\" name=\"Sort lists\">Sort lists</link>" msgstr "<link href=\"text/shared/optionen/01060400.xhp\" name=\"Sort lists\">Sort lists</link>" -#. atsHK +#. 6GdiT #: specialfilter.xhp msgctxt "" "specialfilter.xhp\n" "tit\n" "help.text" -msgid "Filter: Applying Advanced Filters" -msgstr "Filter: Applying Advanced Filters" +msgid "Applying Advanced Filters" +msgstr "" #. Gy5TZ #: specialfilter.xhp @@ -11446,14 +11599,14 @@ msgctxt "" msgid "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" msgstr "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" -#. GS4TQ +#. cjgod #: specialfilter.xhp 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=\"Filter: Applying Advanced Filters\">Filter: Applying Advanced Filters</link></variable>" +msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Applying Advanced Filters\">Applying Advanced Filters</link></variable>" +msgstr "" #. tYuAi #: specialfilter.xhp @@ -13282,6 +13435,276 @@ 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=\"External data dialogue box\">External data dialogue box</link>" +#. GnXq4 +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"tit\n" +"help.text" +msgid "Using Wildcards in Formulas" +msgstr "" + +#. EvMSm +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"bm_id3152149\n" +"help.text" +msgid "<bookmark_value>wildcards in calc formulas</bookmark_value> <bookmark_value>wildcards, examples</bookmark_value>" +msgstr "" + +#. 98C5v +#: 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 "" + +#. yqMKw +#: 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 "" + +#. vQrdp +#: 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 "" + +#. DyzLn +#: 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>LibreOffice - 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 "" + +#. BHJzs +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id141629156913731\n" +"help.text" +msgid "The following wildcards are supported:" +msgstr "" + +#. tbbPM +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id801629209195110\n" +"help.text" +msgid "Wildcard" +msgstr "" + +#. 7PmfG +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id861629209212608\n" +"help.text" +msgid "Description" +msgstr "" + +#. DfkJA +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id591629209073388\n" +"help.text" +msgid "<emph>? (question mark)</emph>" +msgstr "" + +#. F2wmk +#: 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 "" + +#. pi9ik +#: 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 "" + +#. PmsQL +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id981629209073388\n" +"help.text" +msgid "<emph>* (asterisk)</emph>" +msgstr "" + +#. 6V7SE +#: 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 "" + +#. 3gkp8 +#: 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>LibreOffice - 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 "" + +#. ek6t7 +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id181629209277556\n" +"help.text" +msgid "<emph>~ (tilde)</emph>" +msgstr "" + +#. F3Tuy +#: 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 "" + +#. P35Fo +#: 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 "" + +#. aCtpj +#: 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 "" + +#. Dwt2G +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"hd_id671629158766165\n" +"help.text" +msgid "Supported Spreadsheet Functions" +msgstr "" + +#. YF9FB +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id161629158785887\n" +"help.text" +msgid "Wildcards are supported by the following spreadsheet functions:" +msgstr "" + +#. rRPbf +#: 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 "" + +#. gfUGT +#: 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 "" + +#. oUwuB +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id941629158811325\n" +"help.text" +msgid "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP." +msgstr "" + +#. Ka6SK +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"par_id41629158919808\n" +"help.text" +msgid "<emph>Other functions:</emph> MATCH and SEARCH." +msgstr "" + +#. 2ZGuQ +#: wildcards.xhp +msgctxt "" +"wildcards.xhp\n" +"hd_id701629159564269\n" +"help.text" +msgid "Examples of Wildcards in Formulas" +msgstr "" + +#. GnADR +#: 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>LibreOffice - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>." +msgstr "" + +#. znKay +#: 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 "" + +#. TPRuA +#: 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 "" + +#. 7GqMs +#: 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 "" + #. ysgCC #: year2000.xhp msgctxt "" |