diff options
Diffstat (limited to 'source/zh-CN/helpcontent2/source/text/scalc/guide.po')
| -rw-r--r-- | source/zh-CN/helpcontent2/source/text/scalc/guide.po | 565 |
1 files changed, 494 insertions, 71 deletions
diff --git a/source/zh-CN/helpcontent2/source/text/scalc/guide.po b/source/zh-CN/helpcontent2/source/text/scalc/guide.po index 02a41205f63..4d3a5929d1d 100644 --- a/source/zh-CN/helpcontent2/source/text/scalc/guide.po +++ b/source/zh-CN/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: 2019-07-10 02:32+0000\n" "Last-Translator: Dian LI <xslidian@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -403,14 +403,14 @@ msgctxt "" msgid "Using AutoFormat for Tables" msgstr "表格的自动格式" -#. 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>表格; 自动套用格式功能</bookmark_value> <bookmark_value>定义; 用于表格的自动套用格式功能</bookmark_value> <bookmark_value>自动套用格式功能</bookmark_value> <bookmark_value>格式; 自动格式化电子表格</bookmark_value> <bookmark_value>在电子表格中自动格式化</bookmark_value> <bookmark_value>工作表; 自动套用格式功能</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,121 +421,112 @@ 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\">对选中单元格区域应用自动套用格式功能</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 "您可以使用「自动套用格式」功能将格式快速应用到工作表或选中的单元格区域中。" +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 "将「自动套用格式」应用到工作表或选中的单元格范围" +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 "选择要格式化的单元格，包括表头行和表头列对应的单元格。" +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>." +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." +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 "点击「<emph>确定</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 "该格式即会被应用到选中的单元格范围。" +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 "如果单元格内容的颜色没有任何变化，请选择「<item type=\"menuitem\">视图 - 值高亮显示</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" +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." +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." +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 "" - -#. VuwGM -#: autoformat.xhp -msgctxt "" -"autoformat.xhp\n" -"par_id3153815\n" -"help.text" -msgid "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 @@ -547,23 +538,32 @@ msgctxt "" msgid "Click <emph>Add</emph>." msgstr "点击「<emph>添加</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 "在「<emph>添加自动套用格式</emph>对话框的<emph>名称</emph>」框中，输入格式的名称。" +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 "点击「<emph>确定</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 "单元格中自定义的边框" -#. 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>单元格; 边框</bookmark_value><bookmark_value>线条排列; 单元格</bookmark_value><bookmark_value>边框; 单元格</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\">一个选中块周围的边框</alt></image>" -#. j9iat -#: borders.xhp -msgctxt "" -"borders.xhp\n" -"par_id5383465\n" -"help.text" -msgid "You cannot apply borders to multiple selections." -msgstr "无法将边框应用于多个选择。" - #. 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\">单元格边框的高级示例</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 "除了插入新的行或列，将引用了特定单元格的现有公式复制到同一工作表的另一个区域中时，也会更改引用的单元格。假定您在第 10 行中输入了公式 =SUM(A1:A9)。如果要计算右边相邻列的总和，只需将此公式复制到右边的单元格中。复制到列 B 中的公式将自动改为 =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=\"排序列表\">排序列表</link>" -#. atsHK +#. 6GdiT #: specialfilter.xhp msgctxt "" "specialfilter.xhp\n" "tit\n" "help.text" -msgid "Filter: Applying Advanced Filters" -msgstr "筛选: 应用高级筛选" +msgid "Applying Advanced Filters" +msgstr "" #. Gy5TZ #: specialfilter.xhp @@ -11446,13 +11599,13 @@ 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>筛选; 定义高级筛选</bookmark_value><bookmark_value>高级筛选</bookmark_value><bookmark_value>定义; 高级筛选</bookmark_value><bookmark_value>数据库范围; 高级筛选</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>" +msgid "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\" name=\"Applying Advanced Filters\">Applying Advanced Filters</link></variable>" msgstr "" #. tYuAi @@ -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=\"外部数据对话框\">外部数据对话框</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 "" |