summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po3550
1 files changed, 2522 insertions, 1028 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index 19ddc19ea93..ef921615596 100644
--- a/source/zh-TW/helpcontent2/source/text/scalc/01.po
+++ b/source/zh-TW/helpcontent2/source/text/scalc/01.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-04-06 14:45+0200\n"
+"POT-Creation-Date: 2021-06-11 17:08+0200\n"
"PO-Revision-Date: 2020-12-31 12:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: Chinese (Traditional) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/zh_Hant/>\n"
@@ -4948,15 +4948,6 @@ msgctxt ""
msgid "<emph>Weight</emph>"
msgstr ""
-#. BdjTH
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id41616246075884\n"
-"help.text"
-msgid ">600"
-msgstr ""
-
#. 4SkNQ
#: 04060101.xhp
msgctxt ""
@@ -5002,15 +4993,6 @@ msgctxt ""
msgid "<emph>Grade</emph>"
msgstr ""
-#. FsLvK
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id71616250414319\n"
-"help.text"
-msgid ">7"
-msgstr ""
-
#. hfPeb
#: 04060101.xhp
msgctxt ""
@@ -5074,24 +5056,6 @@ msgctxt ""
msgid "<emph>Age</emph>"
msgstr ""
-#. 5zWEA
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id411616252568693\n"
-"help.text"
-msgid ">=8"
-msgstr ""
-
-#. ceFqk
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id441616252573495\n"
-"help.text"
-msgid "<=10"
-msgstr ""
-
#. 6Dk9D
#: 04060101.xhp
msgctxt ""
@@ -5119,15 +5083,6 @@ msgctxt ""
msgid "<emph>Name</emph>"
msgstr ""
-#. uDvpq
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id251616253264022\n"
-"help.text"
-msgid "F*"
-msgstr ""
-
#. qBB4C
#: 04060101.xhp
msgctxt ""
@@ -5155,15 +5110,6 @@ msgctxt ""
msgid "<emph>Name</emph>"
msgstr ""
-#. PJCE2
-#: 04060101.xhp
-msgctxt ""
-"04060101.xhp\n"
-"par_id761616253649791\n"
-"help.text"
-msgid "[ABC].*"
-msgstr ""
-
#. NyqFV
#: 04060101.xhp
msgctxt ""
@@ -5173,13 +5119,13 @@ msgctxt ""
msgid "This simple example shows the use of regular expressions. For this example to work as intended, select to enable regular expressions at <link href=\"text/shared/optionen/01060500.xhp\" name=\"Spreadsheet - Calculate\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link>. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:A13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests have names that begin with the letters “A”, “B”, or “C”. The value 3 is returned (counting Andy, Betty, and Charles)."
msgstr ""
-#. jLLao
+#. KBZPC
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3150882\n"
"help.text"
-msgid "<bookmark_value>DCOUNT function</bookmark_value> <bookmark_value>counting rows;with numeric values</bookmark_value>"
+msgid "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>"
msgstr ""
#. DLGGD
@@ -5236,13 +5182,13 @@ msgctxt ""
msgid "The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; \"Distance\"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; \"Name\"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric."
msgstr ""
-#. m4a6A
+#. tGFyD
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3156123\n"
"help.text"
-msgid "<bookmark_value>DCOUNTA function</bookmark_value> <bookmark_value>records;counting in Calc databases</bookmark_value> <bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>"
+msgid "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>"
msgstr ""
#. aJdyL
@@ -5299,13 +5245,13 @@ msgctxt ""
msgid "The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; \"Distance\"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; \"Name\"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument."
msgstr ""
-#. ZFJzE
+#. GasLC
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3147256\n"
"help.text"
-msgid "<bookmark_value>DGET function</bookmark_value> <bookmark_value>cell contents;searching in Calc databases</bookmark_value> <bookmark_value>searching;cell contents in Calc databases</bookmark_value>"
+msgid "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>"
msgstr ""
#. wj7ck
@@ -5371,13 +5317,13 @@ msgctxt ""
msgid "If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; \"Name\"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10)."
msgstr ""
-#. umeGw
+#. rB9Ek
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3149766\n"
"help.text"
-msgid "<bookmark_value>DMAX function</bookmark_value> <bookmark_value>maximum values in Calc databases</bookmark_value> <bookmark_value>searching;maximum values in columns</bookmark_value>"
+msgid "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>"
msgstr ""
#. MDBf2
@@ -5434,13 +5380,13 @@ msgctxt ""
msgid "Insert the formula <input>=DMAX(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned."
msgstr ""
-#. 5cyyS
+#. CnaXx
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3159141\n"
"help.text"
-msgid "<bookmark_value>DMIN function</bookmark_value> <bookmark_value>minimum values in Calc databases</bookmark_value> <bookmark_value>searching;minimum values in columns</bookmark_value>"
+msgid "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>"
msgstr ""
#. iGV4a
@@ -5497,13 +5443,13 @@ msgctxt ""
msgid "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned."
msgstr ""
-#. WppQu
+#. XEu9j
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3154274\n"
"help.text"
-msgid "<bookmark_value>DAVERAGE function</bookmark_value> <bookmark_value>averages; in Calc databases</bookmark_value> <bookmark_value>calculating;averages in Calc databases</bookmark_value>"
+msgid "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>"
msgstr ""
#. dQciw
@@ -5560,13 +5506,13 @@ msgctxt ""
msgid "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned."
msgstr ""
-#. B6fYC
+#. 6fcFr
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3159269\n"
"help.text"
-msgid "<bookmark_value>DPRODUCT function</bookmark_value> <bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>"
+msgid "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>"
msgstr ""
#. gvW9Q
@@ -5623,13 +5569,13 @@ msgctxt ""
msgid "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned."
msgstr ""
-#. QGMit
+#. KsVCV
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3148462\n"
"help.text"
-msgid "<bookmark_value>DSTDEV function</bookmark_value> <bookmark_value>standard deviations in databases;based on a sample</bookmark_value>"
+msgid "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>"
msgstr ""
#. EvGNP
@@ -5695,13 +5641,13 @@ msgctxt ""
msgid "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned."
msgstr ""
-#. A72yR
+#. VRXXy
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3150429\n"
"help.text"
-msgid "<bookmark_value>DSTDEVP function</bookmark_value> <bookmark_value>standard deviations in databases;based on populations</bookmark_value>"
+msgid "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>"
msgstr ""
#. FpESx
@@ -5758,13 +5704,13 @@ msgctxt ""
msgid "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned."
msgstr ""
-#. gXoTJ
+#. Z2CTY
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3154794\n"
"help.text"
-msgid "<bookmark_value>DSUM function</bookmark_value> <bookmark_value>calculating;sums in Calc databases</bookmark_value> <bookmark_value>sums;cells in Calc databases</bookmark_value>"
+msgid "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>"
msgstr ""
#. ybMg9
@@ -5821,13 +5767,13 @@ msgctxt ""
msgid "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned."
msgstr ""
-#. fbsJf
+#. YBFb7
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3155614\n"
"help.text"
-msgid "<bookmark_value>DVAR function</bookmark_value> <bookmark_value>variances;based on samples</bookmark_value>"
+msgid "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>"
msgstr ""
#. G6ZBW
@@ -5893,13 +5839,13 @@ msgctxt ""
msgid "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned."
msgstr ""
-#. sGiDz
+#. 7FWS4
#: 04060101.xhp
msgctxt ""
"04060101.xhp\n"
"bm_id3153880\n"
"help.text"
-msgid "<bookmark_value>DVARP function</bookmark_value> <bookmark_value>variances;based on populations</bookmark_value>"
+msgid "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>"
msgstr ""
#. XpcPC
@@ -8242,23 +8188,23 @@ msgctxt ""
msgid "The data in the following table serves as the basis for some of the examples in the function descriptions:"
msgstr "在函式描述中,有些範例使用了下表中的資料:"
-#. AGubr
+#. amFAz
#: 04060104.xhp
msgctxt ""
"04060104.xhp\n"
"par_id3150024\n"
"help.text"
-msgid "x <item type=\"input\">value</item>"
-msgstr "x <item type=\"input\">值</item>"
+msgid "<item type=\"input\">x value</item>"
+msgstr ""
-#. foDao
+#. AGBFY
#: 04060104.xhp
msgctxt ""
"04060104.xhp\n"
"par_id3148725\n"
"help.text"
-msgid "y <item type=\"input\">value</item>"
-msgstr "y <item type=\"input\">值</item>"
+msgid "<item type=\"input\">y value</item>"
+msgstr ""
#. uEBVE
#: 04060104.xhp
@@ -14398,15 +14344,6 @@ msgctxt ""
msgid "<emph>Range</emph> is the range to which the criterion is to be applied."
msgstr ""
-#. 7FPaC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3152062\n"
-"help.text"
-msgid "<emph>Criterion</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criterion is written into the formula, it has to be surrounded by double quotes."
-msgstr ""
-
#. FCxrw
#: 04060106.xhp
msgctxt ""
@@ -18790,32 +18727,32 @@ msgctxt ""
msgid "VLOOKUP"
msgstr "VLOOKUP"
-#. E5F2D
+#. qFEgu
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149984\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <item type=\"literal\">Index</item>. If the <item type=\"literal\">Sorted</item> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <item type=\"literal\">SearchCriterion</item> is not found, the last value that is smaller than the criterion will be returned. If <item type=\"literal\">Sorted</item> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order."
+msgid "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order."
msgstr ""
-#. 8FhyJ
+#. j8RoY
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3150156\n"
"help.text"
-msgid "=VLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])"
+msgid "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])"
msgstr ""
-#. 7FsgG
+#. LDrCq
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149289\n"
"help.text"
-msgid "<emph>SearchCriterion</emph> is the value searched for in the first column of the array."
-msgstr "<emph>SearchCriterion</emph> 是指在陣列第一欄中搜尋的值。"
+msgid "<emph>Lookup</emph> is the value of any type looked for in the first column of the array."
+msgstr ""
#. WFj5E
#: 04060109.xhp
@@ -18835,13 +18772,13 @@ msgctxt ""
msgid "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1."
msgstr "<emph>Index</emph> 是陣列中的欄號,該陣列包含要傳回的值。第一欄的編號為 1。"
-#. QV6iE
+#. qKRbD
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3151208\n"
"help.text"
-msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than SearchCriterion. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>."
+msgid "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>."
msgstr ""
#. fJQRf
@@ -19024,23 +18961,23 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number."
msgstr "<ahelp hid=\"HID_FUNC_VERGLEICH\">傳回陣列中符合指定值的項目相關位置。</ahelp> 函式傳回 lookup_array 中找到為數字的值位置。"
-#. FsB8G
+#. AKi9E
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3159152\n"
"help.text"
-msgid "MATCH(SearchCriterion; LookupArray [; Type])"
+msgid "MATCH(Search; LookupArray [; Type])"
msgstr ""
-#. BmVBr
+#. KZU4F
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3149336\n"
"help.text"
-msgid "<emph>SearchCriterion</emph> is the value which is to be searched for in the single-row or single-column array."
-msgstr "<emph>SearchCriterion</emph> 是指在單列或單欄陣列中搜尋的值。"
+msgid "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array."
+msgstr ""
#. 9j4xw
#: 04060109.xhp
@@ -19285,23 +19222,23 @@ msgctxt ""
msgid "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion."
msgstr "若 LOOKUP 找不到搜尋條件,則會於搜尋向量中搜尋小於或等於搜尋條件的最大值。"
-#. 4nBA6
+#. sLcHB
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3154104\n"
"help.text"
-msgid "LOOKUP(SearchCriterion; SearchVector [; ResultVector])"
+msgid "LOOKUP(Lookup; SearchVector [; ResultVector])"
msgstr ""
-#. QdiFz
+#. yGLLE
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3150646\n"
"help.text"
-msgid "<emph>SearchCriterion</emph> is the value to be searched for; entered either directly or as a reference."
-msgstr "<emph>SearchCriterion</emph> 是指要搜尋的數值 (直接輸入或輸入為參照)。"
+msgid "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference."
+msgstr ""
#. tFDBC
#: 04060109.xhp
@@ -19519,13 +19456,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column."
msgstr "<ahelp hid=\"HID_FUNC_WVERWEIS\">在選取的區域以下搜尋值與儲存格的參照。</ahelp> 此函式驗證陣列的第一列是否包含特定值。然後此函式傳回同一欄中由 <emph>Index</emph> 指定的陣列列中的數值。"
-#. y6is6
+#. NWzFA
#: 04060109.xhp
msgctxt ""
"04060109.xhp\n"
"par_id3146070\n"
"help.text"
-msgid "HLOOKUP(SearchCriterion; Array; Index [; SortedRangeLookup])"
+msgid "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])"
msgstr ""
#. nhwwF
@@ -20608,6 +20545,15 @@ msgctxt ""
msgid "<emph>Text</emph> refers to the text from which to remove all non-printable characters."
msgstr "<emph>Text</emph> 是指要移除所有不可列印的字元之文字。"
+#. h3UXC
+#: 04060110.xhp
+msgctxt ""
+"04060110.xhp\n"
+"par_id581621538151600\n"
+"help.text"
+msgid "<input>=LEN(CLEAN(CHAR(7) & \"LibreOffice Calc\" & CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 (\"BEL\") and U+0008 (\"BS\") characters at the beginning and end of the string argument. CLEAN does not remove spaces."
+msgstr ""
+
#. zdGBJ
#: 04060110.xhp
msgctxt ""
@@ -20878,14 +20824,14 @@ msgctxt ""
msgid "<emph>Decimals</emph> is the optional number of decimal places."
msgstr "<emph>Decimals</emph> 是選用的小數點位數。"
-#. JFmwv
+#. ezXhx
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id3153546\n"
"help.text"
-msgid "<item type=\"input\">=DOLLAR(255)</item> returns $255.00."
-msgstr "<item type=\"input\">=DOLLAR(255)</item> 傳回 $255.00。"
+msgid "<item type=\"input\">=DOLLAR(255)</item> returns $255.00 for the English (USA) locale and USD (dollar) currency; ¥255.00 for the Japanese locale and JPY (yen) currency; or 255,00 € for the German (Germany) locale and EUR (euro) currency."
+msgstr ""
#. 2beTG
#: 04060110.xhp
@@ -21139,13 +21085,13 @@ msgctxt ""
msgid "<item type=\"input\">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string."
msgstr ""
-#. wHPtQ
+#. CB5nt
#: 04060110.xhp
msgctxt ""
"04060110.xhp\n"
"par_id371617286698199\n"
"help.text"
-msgid "<item type=\"input\">=FIXED(12345.789,8/5)</item> returns 12,345.8 as a text string."
+msgid "<item type=\"input\">=FIXED(12345.789;8/5)</item> returns 12,345.8 as a text string."
msgstr ""
#. zxsGX
@@ -23767,6 +23713,15 @@ msgctxt ""
msgid "<emph>Input</emph>: Any number of types (double&, char*, double*, char**, Cell area), where the <link href=\"text/scalc/01/04060112.xhp\" name=\"Cell area\">Cell area</link> is an array of types double array, string array, or cell array."
msgstr ""
+#. BJLCP
+#: 04060112.xhp
+msgctxt ""
+"04060112.xhp\n"
+"hd_id3150653\n"
+"help.text"
+msgid "GetFunctionCount()"
+msgstr "GetFunctionCount()"
+
#. Hs7Du
#: 04060112.xhp
msgctxt ""
@@ -23803,6 +23758,15 @@ msgctxt ""
msgid "<emph>Output</emph>: Reference to a variable, which is supposed to contain the number of Add-In functions. For example: If the Add-In provides 5 functions for $[officename] Calc, then nCount=5."
msgstr ""
+#. GFJes
+#: 04060112.xhp
+msgctxt ""
+"04060112.xhp\n"
+"hd_id3147476\n"
+"help.text"
+msgid "GetFunctionData()"
+msgstr "GetFunctionData()"
+
#. MMvZL
#: 04060112.xhp
msgctxt ""
@@ -23884,6 +23848,15 @@ msgctxt ""
msgid "The pFuncName and pInternalName parameters are char arrays, which are implemented with size 256 in $[officename] Calc."
msgstr "參數 pFuncName 和 pInternalName 是在 $[officename] Calc 中以 256 大小執行的 char Array。"
+#. BDeUC
+#: 04060112.xhp
+msgctxt ""
+"04060112.xhp\n"
+"hd_id3148567\n"
+"help.text"
+msgid "GetParameterDescription()"
+msgstr "GetParameterDescription()"
+
#. sF27k
#: 04060112.xhp
msgctxt ""
@@ -24919,14 +24892,14 @@ msgctxt ""
msgid "The Add-in functions are supplied by the <link href=\"text/sbasic/shared/calc_functions.xhp\" name=\"addinanalysis\">UNO <literal>com.sun.star.sheet.addin.Analysis</literal> service</link>."
msgstr ""
-#. fCaeG
+#. zKa2G
#: 04060115.xhp
msgctxt ""
"04060115.xhp\n"
"bm_id3153074\n"
"help.text"
-msgid "<bookmark_value>Bessel functions</bookmark_value>"
-msgstr "<bookmark_value>Bessel 函式</bookmark_value>"
+msgid "<bookmark_value>Bessel functions</bookmark_value> <bookmark_value>BESSELI function</bookmark_value>"
+msgstr ""
#. YpfCj
#: 04060115.xhp
@@ -25000,6 +24973,15 @@ msgctxt ""
msgid "=BESSELI(-1, 3), returns -0.022168424924332"
msgstr ""
+#. eDJhC
+#: 04060115.xhp
+msgctxt ""
+"04060115.xhp\n"
+"bm_id161618267677640\n"
+"help.text"
+msgid "<bookmark_value>BESSELJ function</bookmark_value>"
+msgstr ""
+
#. Cccmx
#: 04060115.xhp
msgctxt ""
@@ -25072,6 +25054,15 @@ msgctxt ""
msgid "=BESSELJ(-1, 3), returns -0.019563353982668"
msgstr ""
+#. xVEFS
+#: 04060115.xhp
+msgctxt ""
+"04060115.xhp\n"
+"bm_id151618267791726\n"
+"help.text"
+msgid "<bookmark_value>BESSELK function</bookmark_value>"
+msgstr ""
+
#. jb2FF
#: 04060115.xhp
msgctxt ""
@@ -25144,6 +25135,15 @@ msgctxt ""
msgid "=BESSELK(0, 3), returns Err:502 – invalid argument (X=0)"
msgstr ""
+#. PndsN
+#: 04060115.xhp
+msgctxt ""
+"04060115.xhp\n"
+"bm_id201618267836525\n"
+"help.text"
+msgid "<bookmark_value>BESSELY function</bookmark_value>"
+msgstr ""
+
#. 9PCdq
#: 04060115.xhp
msgctxt ""
@@ -27160,807 +27160,6 @@ msgctxt ""
msgid "<item type=\"input\">=OCT2HEX(144;4)</item> returns 0064."
msgstr "<item type=\"input\">=OCT2HEX(144;4)</item> 傳回 0064。"
-#. JBzHD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"bm_id3148446\n"
-"help.text"
-msgid "<bookmark_value>CONVERT function</bookmark_value>"
-msgstr ""
-
-#. NNzM9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"hd_id3148446\n"
-"help.text"
-msgid "CONVERT"
-msgstr ""
-
-#. AZ8gE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154902\n"
-"help.text"
-msgid "<ahelp hid=\"HID_AAI_FUNC_CONVERT\">Converts a value from one unit of measure to the corresponding value in another unit of measure.</ahelp> Enter the units of measures directly as text in quotation marks or as a reference. If you enter the units of measure in cells, they must correspond exactly with the following list which is case sensitive: For example, in order to enter a lower case l (for liter) in a cell, enter the apostrophe ' immediately followed by l."
-msgstr "<ahelp hid=\"HID_AAI_FUNC_CONVERT\">將一種定量單位的值轉換為另一定量單位中的對應值。</ahelp> 將定量單位直接以引號中的文字或以參照輸入。如果在儲存格中輸入定量單位,則必須與以下清單保持一致,且區分大小寫:例如,要在儲存格中輸入一個小寫字母 l (表示公升),可在 l 前直接輸入撇號 '。"
-
-#. BWERF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153055\n"
-"help.text"
-msgid "Property"
-msgstr "<emph>屬性</emph>"
-
-#. XTUci
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147234\n"
-"help.text"
-msgid "Units"
-msgstr "<emph>單位</emph>"
-
-#. cMJxt
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147512\n"
-"help.text"
-msgid "Weight"
-msgstr "線寬"
-
-#. iBfK5
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148476\n"
-"help.text"
-msgid "<emph>g</emph>, sg, lbm, <emph>u</emph>, ozm, stone, ton, grain, pweight, hweight, shweight, brton"
-msgstr "<emph>g</emph>, sg, lbm, <emph>u</emph>, ozm, stone, ton, grain, pweight, hweight, shweight, brton"
-
-#. GaiAA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3155361\n"
-"help.text"
-msgid "Length"
-msgstr "長度"
-
-#. AYaEj
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148925\n"
-"help.text"
-msgid "<emph>m</emph>, mi, Nmi, in, ft, yd, ang, Pica, ell, <emph>parsec</emph>, <emph>lightyear</emph>, survey_mi"
-msgstr "<emph>m</emph>, mi, Nmi, in, ft, yd, ang, Pica, ell, <emph>parsec</emph>, <emph>lightyear</emph>, survey_mi"
-
-#. CSY6D
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3158429\n"
-"help.text"
-msgid "Time"
-msgstr "時間"
-
-#. CRKWs
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150707\n"
-"help.text"
-msgid "yr, day, hr, mn, <emph>sec</emph>, <emph>s</emph>"
-msgstr "yr, day, hr, mn, <emph>sec</emph>, <emph>s</emph>"
-
-#. jRyCG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153238\n"
-"help.text"
-msgid "Pressure"
-msgstr "氣壓"
-
-#. 2Bw2Y
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3166437\n"
-"help.text"
-msgid "<emph>Pa</emph>, <emph>atm</emph>, <emph>at</emph>, <emph>mmHg</emph>, Torr, psi"
-msgstr "<emph>Pa</emph>, <emph>atm</emph>, <emph>at</emph>, <emph>mmHg</emph>, Torr, psi"
-
-#. eDDQG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3152944\n"
-"help.text"
-msgid "Force"
-msgstr "動力"
-
-#. UfKga
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3155582\n"
-"help.text"
-msgid "<emph>N</emph>, <emph>dyn</emph>, <emph>dy</emph>, lbf, <emph>pond</emph>"
-msgstr "<emph>N</emph>, <emph>dyn</emph>, <emph>dy</emph>, lbf, <emph>pond</emph>"
-
-#. nDfkL
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153686\n"
-"help.text"
-msgid "Energy"
-msgstr "能源"
-
-#. T8CAw
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153386\n"
-"help.text"
-msgid "<emph>J</emph>, <emph>e</emph>, <emph>c</emph>, <emph>cal</emph>, <emph>eV</emph>, <emph>ev</emph>, HPh, <emph>Wh</emph>, <emph>wh</emph>, flb, BTU, btu"
-msgstr "<emph>J</emph>, <emph>e</emph>, <emph>c</emph>, <emph>cal</emph>, <emph>eV</emph>, <emph>ev</emph>, HPh, <emph>Wh</emph>, <emph>wh</emph>, flb, BTU, btu"
-
-#. RkeAo
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154100\n"
-"help.text"
-msgid "Power"
-msgstr "功率"
-
-#. RAPGk
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149915\n"
-"help.text"
-msgid "<emph>W</emph>, <emph>w</emph>, HP, PS"
-msgstr "<emph>W</emph>, <emph>w</emph>, HP, PS"
-
-#. FRDaq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148988\n"
-"help.text"
-msgid "Field strength"
-msgstr "磁場力度"
-
-#. YKEEF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148616\n"
-"help.text"
-msgid "<emph>T</emph>, <emph>ga</emph>"
-msgstr "<emph>T</emph>, <emph>ga</emph>"
-
-#. rxAYG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3151120\n"
-"help.text"
-msgid "Temperature"
-msgstr "溫度"
-
-#. V3XFM
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148659\n"
-"help.text"
-msgid "C, F, <emph>K</emph>, <emph>kel</emph>, Reau, Rank"
-msgstr "C, F, <emph>K</emph>, <emph>kel</emph>, Reau, Rank"
-
-#. AF455
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154610\n"
-"help.text"
-msgid "Volume"
-msgstr "容量"
-
-#. zv7qN
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149423\n"
-"help.text"
-msgid "<emph>l</emph>, <emph>L</emph>, <emph>lt</emph>, tsp, tbs, oz, cup, pt, us_pt, qt, gal, <emph>m3</emph>, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass"
-msgstr "<emph>l</emph>, <emph>L</emph>, <emph>lt</emph>, tsp, tbs, oz, cup, pt, us_pt, qt, gal, <emph>m3</emph>, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner, Middy, Glass"
-
-#. YpiAY
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149244\n"
-"help.text"
-msgid "Area"
-msgstr "面積"
-
-#. 6EDBv
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150425\n"
-"help.text"
-msgid "<emph>m2</emph>, mi2, Nmi2, in2, ft2, yd2, <emph>ang2</emph>, Pica2, Morgen, <emph>ar</emph>, acre, ha"
-msgstr "<emph>m2</emph>, mi2, Nmi2, in2, ft2, yd2, <emph>ang2</emph>, Pica2, Morgen, <emph>ar</emph>, acre, ha"
-
-#. MdUET
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150629\n"
-"help.text"
-msgid "Speed"
-msgstr "速度"
-
-#. oUP4X
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3159246\n"
-"help.text"
-msgid "<emph>m/s</emph>, <emph>m/sec</emph>, m/h, mph, kn, admkn"
-msgstr "<emph>m/s</emph>, <emph>m/sec</emph>, m/h, mph, kn, admkn"
-
-#. fSWsq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3150789\n"
-"help.text"
-msgid "Information"
-msgstr "資訊"
-
-#. UTUhA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3159899\n"
-"help.text"
-msgid "<emph>bit</emph>, <emph>byte</emph>"
-msgstr "<emph>bit</emph>, <emph>byte</emph>"
-
-#. 8WZyq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3143277\n"
-"help.text"
-msgid "Units of measure in <emph>bold</emph> can be preceded by a prefix character from the following list:"
-msgstr "<emph>粗體</emph> 的度量單位前可添加下列清單中的前綴字元:"
-
-#. YBQYC
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148422\n"
-"help.text"
-msgid "Prefix"
-msgstr "前綴"
-
-#. vzHyG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3148423\n"
-"help.text"
-msgid "Multiplier"
-msgstr "乘數"
-
-#. y8Bch
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149490\n"
-"help.text"
-msgid "Y (yotta)"
-msgstr ""
-
-#. YE3Bo
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149931\n"
-"help.text"
-msgid "10^24"
-msgstr "10^24"
-
-#. Vst48
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149491\n"
-"help.text"
-msgid "Z (zetta)"
-msgstr ""
-
-#. cBpwF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149932\n"
-"help.text"
-msgid "10^21"
-msgstr "10^21"
-
-#. sVmhZ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149492\n"
-"help.text"
-msgid "E (exa)"
-msgstr ""
-
-#. DCgjD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149933\n"
-"help.text"
-msgid "10^18"
-msgstr "10^18"
-
-#. odrAJ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149493\n"
-"help.text"
-msgid "P (peta)"
-msgstr ""
-
-#. HnJBh
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149934\n"
-"help.text"
-msgid "10^15"
-msgstr "10^15"
-
-#. 6SoPA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149494\n"
-"help.text"
-msgid "T (tera)"
-msgstr ""
-
-#. cgqVx
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149935\n"
-"help.text"
-msgid "10^12"
-msgstr "10^12"
-
-#. Ki9Ca
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149495\n"
-"help.text"
-msgid "G (giga)"
-msgstr ""
-
-#. jMqL9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149936\n"
-"help.text"
-msgid "10^9"
-msgstr "10^9"
-
-#. YD6i5
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149496\n"
-"help.text"
-msgid "M (mega)"
-msgstr ""
-
-#. 4vqCG
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149937\n"
-"help.text"
-msgid "10^6"
-msgstr "10^6"
-
-#. 6WGVB
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "k (kilo)"
-msgstr ""
-
-#. wBWRS
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149938\n"
-"help.text"
-msgid "10^3"
-msgstr "10^3"
-
-#. G2FDE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149498\n"
-"help.text"
-msgid "h (hecto)"
-msgstr ""
-
-#. 9UYSz
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149939\n"
-"help.text"
-msgid "10^2"
-msgstr "10^2"
-
-#. woVg4
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149499\n"
-"help.text"
-msgid "e (deca)"
-msgstr ""
-
-#. iiAPq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149940\n"
-"help.text"
-msgid "10^1"
-msgstr "10^1"
-
-#. C7sNq
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149500\n"
-"help.text"
-msgid "d (deci)"
-msgstr ""
-
-#. eQehn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3143940\n"
-"help.text"
-msgid "10^-1"
-msgstr "10^-1"
-
-#. EUm9F
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149501\n"
-"help.text"
-msgid "c (centi)"
-msgstr ""
-
-#. FDbBr
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149941\n"
-"help.text"
-msgid "10^-2"
-msgstr "10^-2"
-
-#. G48jP
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149502\n"
-"help.text"
-msgid "m (milli)"
-msgstr ""
-
-#. uUT75
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149942\n"
-"help.text"
-msgid "10^-3"
-msgstr "10^-3"
-
-#. LTWEh
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149503\n"
-"help.text"
-msgid "u (micro)"
-msgstr ""
-
-#. cvaeu
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149943\n"
-"help.text"
-msgid "10^-6"
-msgstr "10^-6"
-
-#. GD6Gw
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149504\n"
-"help.text"
-msgid "n (nano)"
-msgstr ""
-
-#. 38rEb
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149944\n"
-"help.text"
-msgid "10^-9"
-msgstr "10^-9"
-
-#. FiDAM
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149505\n"
-"help.text"
-msgid "p (pico)"
-msgstr ""
-
-#. 9sGcA
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149945\n"
-"help.text"
-msgid "10^-12"
-msgstr "10^-12"
-
-#. SMnpF
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149506\n"
-"help.text"
-msgid "f (femto)"
-msgstr ""
-
-#. cqsCH
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149946\n"
-"help.text"
-msgid "10^-15"
-msgstr "10^-15"
-
-#. Fj46E
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149507\n"
-"help.text"
-msgid "a (atto)"
-msgstr ""
-
-#. qtV59
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149947\n"
-"help.text"
-msgid "10^-18"
-msgstr "10^-18"
-
-#. ZxxnU
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149508\n"
-"help.text"
-msgid "z (zepto)"
-msgstr ""
-
-#. GWC7A
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149948\n"
-"help.text"
-msgid "10^-21"
-msgstr "10^-21"
-
-#. cTLp9
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149509\n"
-"help.text"
-msgid "y (yocto)"
-msgstr ""
-
-#. KAARJ
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3149949\n"
-"help.text"
-msgid "10^-24"
-msgstr "10^-24"
-
-#. UVavE
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903061174\n"
-"help.text"
-msgid "Information units \"bit\" and \"byte\" may also be prefixed by one of the following IEC 60027-2 / IEEE 1541 prefixes:"
-msgstr "資訊單元「位元」和「位元組」也可以以下列其中一個 IEC 60027-2 / IEEE 1541 字首為字首:"
-
-#. DZhKD
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090966\n"
-"help.text"
-msgid "ki kibi 1024"
-msgstr "ki kibi 1024"
-
-#. K3qEd
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090958\n"
-"help.text"
-msgid "Mi mebi 1048576"
-msgstr "Mi mebi 1048576"
-
-#. dBFMg
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090936\n"
-"help.text"
-msgid "Gi gibi 1073741824"
-msgstr "Gi gibi 1073741824"
-
-#. 9RnhS
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090975\n"
-"help.text"
-msgid "Ti tebi 1099511627776"
-msgstr "Ti tebi 1099511627776"
-
-#. 39Jpn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903090930\n"
-"help.text"
-msgid "Pi pebi 1125899906842620"
-msgstr "Pi pebi 1125899906842620"
-
-#. GkAoP
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091070\n"
-"help.text"
-msgid "Ei exbi 1152921504606850000"
-msgstr "Ei exbi 1152921504606850000"
-
-#. GTGuN
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091097\n"
-"help.text"
-msgid "Zi zebi 1180591620717410000000"
-msgstr "Zi zebi 1180591620717410000000"
-
-#. QbEGb
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id0908200903091010\n"
-"help.text"
-msgid "Yi yobi 1208925819614630000000000"
-msgstr "Yi yobi 1208925819614630000000000"
-
-#. RpFzc
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153695\n"
-"help.text"
-msgid "CONVERT(Number; \"FromUnit\"; \"ToUnit\")"
-msgstr ""
-
-#. f822K
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3147522\n"
-"help.text"
-msgid "<emph>Number</emph> is the number to be converted."
-msgstr "<emph>Number</emph> 是指要轉換的數字。"
-
-#. m8taC
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154472\n"
-"help.text"
-msgid "<emph>FromUnit</emph> is the unit from which conversion is taking place."
-msgstr "<emph>FromUnit</emph> 是指轉換的來源單位。"
-
-#. TAaks
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3153790\n"
-"help.text"
-msgid "<emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type."
-msgstr "<emph>ToUnit</emph> 是要進行轉換的單位。兩個單位的類型必須相同。"
-
-#. pbZjW
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3156336\n"
-"help.text"
-msgid "<item type=\"input\">=CONVERT(10;\"HP\";\"PS\") </item>returns, rounded to two decimal places, 10.14. 10 HP equal 10.14 PS."
-msgstr ""
-
-#. R3Ucn
-#: 04060116.xhp
-msgctxt ""
-"04060116.xhp\n"
-"par_id3154834\n"
-"help.text"
-msgid "<item type=\"input\">=CONVERT(10;\"km\";\"mi\") </item>returns, rounded to two decimal places, 6.21. 10 kilometers equal 6.21 miles. The k is the permitted prefix character for the factor 10^3."
-msgstr ""
-
#. G7UNe
#: 04060116.xhp
msgctxt ""
@@ -32947,14 +32146,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">Returns the number of cells that meet with certain criteria within a cell range.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_ZAEHLENWENN\">傳回某一儲存格範圍中符合一定條件的儲存格數。</ahelp>"
-#. GxU5g
+#. ZS8Ej
#: 04060181.xhp
msgctxt ""
"04060181.xhp\n"
"par_id3164967\n"
"help.text"
-msgid "COUNTIF(Range; Criteria)"
-msgstr "COUNTIF(Range; Criteria)"
+msgid "COUNTIF(Range; Criterion)"
+msgstr ""
#. sxGvB
#: 04060181.xhp
@@ -32965,15 +32164,6 @@ msgctxt ""
msgid "<emph>Range</emph> is the range to which the criteria are to be applied."
msgstr "<emph>Range</emph> 是要套用條件的範圍。"
-#. HvRLc
-#: 04060181.xhp
-msgctxt ""
-"04060181.xhp\n"
-"par_id3165000\n"
-"help.text"
-msgid "<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted."
-msgstr ""
-
#. ZpDRv
#: 04060181.xhp
msgctxt ""
@@ -44494,14 +43684,14 @@ msgctxt ""
msgid "Optimal Row Heights"
msgstr "最適列高"
-#. CTV6j
+#. 2YhvB
#: 05030200.xhp
msgctxt ""
"05030200.xhp\n"
"par_id3154758\n"
"help.text"
-msgid "<variable id=\"optitext\"><ahelp hid=\".uno:SetOptimalRowHeight\">Determines the optimal row height for the selected rows.</ahelp></variable> The optimal row height depends on the font size of the largest character in the row. You can use various <link href=\"text/shared/00/00000003.xhp#metrik\" name=\"units of measure\">units of measure</link>."
-msgstr "<variable id=\"optitext\"><ahelp hid=\".uno:SetOptimalRowHeight\">決定所選列的最適列高。</ahelp></variable> 最適列高取決於列中最大字元的字型大小。您可以使用各種<link href=\"text/shared/00/00000003.xhp#metrik\" name=\"定量單位\">定量單位</link>。"
+msgid "<variable id=\"optitext\"><ahelp hid=\".uno:SetOptimalRowHeight\">Determines the optimal row height for the selected rows.</ahelp></variable> The optimal row height depends on the font size of the largest character in the row. You can use various <link href=\"text/shared/00/00000003.xhp#measurement_units\" name=\"units of measure\">units of measure</link>."
+msgstr ""
#. hCkvc
#: 05030200.xhp
@@ -47941,22 +47131,40 @@ msgctxt ""
msgid "Protecting Sheet"
msgstr "保護試算表"
-#. z8zCf
+#. du7pC
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"bm_id141619439455954\n"
+"help.text"
+msgid "<bookmark_value>insert rows;protected sheet</bookmark_value><bookmark_value>insert columns;protected sheet</bookmark_value><bookmark_value>delete columns;protected sheet</bookmark_value><bookmark_value>delete rows;protected sheet</bookmark_value><bookmark_value>protected sheet;insert columns</bookmark_value><bookmark_value>protected sheet;insert rows</bookmark_value><bookmark_value>protected sheet;delete rows</bookmark_value><bookmark_value>protected sheet;delete columns</bookmark_value><bookmark_value>protect;sheet</bookmark_value><bookmark_value>selection;in protected cells</bookmark_value>"
+msgstr ""
+
+#. ZFcP8
#: 06060100.xhp
msgctxt ""
"06060100.xhp\n"
"hd_id3153087\n"
"help.text"
-msgid "Protecting Sheet"
-msgstr "保護試算表"
+msgid "<variable id=\"ProtectingSheeth1\"><link href=\"text/scalc/01/06060100.xhp\" name=\"Protecting Sheet\">Protecting Sheet</link></variable>"
+msgstr ""
-#. HUFRu
+#. LcpD8
#: 06060100.xhp
msgctxt ""
"06060100.xhp\n"
"par_id3148664\n"
"help.text"
-msgid "<variable id=\"tabelletext\"><ahelp hid=\".uno:Protect\">Protects the cells in the current sheet from being modified.</ahelp></variable> Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password."
+msgid "<variable id=\"tabelletext\"><ahelp hid=\".uno:Protect\">Protects the cells in the current sheet from being modified.</ahelp></variable>"
+msgstr ""
+
+#. YZ3HB
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id701619429750616\n"
+"help.text"
+msgid "Choose <emph>Tools - Protect Sheet</emph> to open the <emph>Protect Sheet</emph> dialog in which you then specify sheet protection with or without a password, and select the elements of the sheet to protect."
msgstr ""
#. vFHpY
@@ -47968,6 +47176,114 @@ msgctxt ""
msgid "To protect cells from further editing, the <emph>Protected</emph> check box must be checked on the <link href=\"text/scalc/01/05020600.xhp\" name=\"Format - Cells - Cell Protection\"><emph>Format - Cells - Cell Protection</emph></link> tab page or on the <emph>Format Cells</emph> context menu."
msgstr "若要保護儲存格不被編輯,必須核取 <link href=\"text/scalc/01/05020600.xhp\" name=\"[格式] - [儲存格] - [儲存格保護]\"><emph>[格式] - [儲存格] - [儲存格保護]</emph></link> 標籤頁或 <emph>[儲存格格式化]</emph> 右鍵功能表上的 <emph>[受保護]</emph> 核取方塊。"
+#. eUvfv
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"hd_id901619431276995\n"
+"help.text"
+msgid "Protect this sheet and contents of the protected cells"
+msgstr ""
+
+#. G5UKV
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id381619431285815\n"
+"help.text"
+msgid "Mark this checkbox to activate protection of sheet and cell contents."
+msgstr ""
+
+#. SFevC
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"hd_id31619431291108\n"
+"help.text"
+msgid "Password / Confirm"
+msgstr ""
+
+#. AaZQG
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id851619431300487\n"
+"help.text"
+msgid "Allows you to enter a password to protect the sheet from unauthorized changes. Confirm the password entered in the first box."
+msgstr ""
+
+#. WX7Gh
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"hd_id711619431316966\n"
+"help.text"
+msgid "Allow users of this sheet to"
+msgstr ""
+
+#. skcWB
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id41619431361278\n"
+"help.text"
+msgid "Select the elements to protect from user actions:"
+msgstr ""
+
+#. 9Mc4m
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id661619430257262\n"
+"help.text"
+msgid "<emph>Select protected cells</emph>: mark this checkbox to allow you to select protected cells. When the checkbox is unmarked, you cannot select protected cells, the cursor cannot enter in a protected range."
+msgstr ""
+
+#. UqBRQ
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id921619430295947\n"
+"help.text"
+msgid "<emph>Select unprotected cells</emph>: mark this checkbox to allow user to select unprotected cells. When the checkbox is unmarked, user cannot select unprotected cells, the cursor cannot enter in a unprotected cell or range."
+msgstr ""
+
+#. R6DuD
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id101619430333784\n"
+"help.text"
+msgid "<emph>Insert columns</emph>: Allow column insertions even when the sheet is protected. Note that when column insertions is enabled, you can insert columns even when the range to insert the new columns into contains protected cells which will get shifted after the insertion. Cells of the newly inserted columns inherit the Protection property of the range it belongs: when the new cell is inside a protected range, the cell is protected, and when it is in an unprotected range, the cell is unprotected."
+msgstr ""
+
+#. 36hCi
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id891619430338809\n"
+"help.text"
+msgid "<emph>Insert rows</emph>: Allow row insertions even when the sheet is protected. Note that when row insertions is enabled, you can insert rows even when the range to insert the new rows into contains protected cells which will get shifted after the insertion. Cells of the newly inserted rows inherit the Protection property of the range it belongs: when the new cell is inside a protected range it is protected, and when it is in an unprotected range, the cell is unprotected."
+msgstr ""
+
+#. hGXEq
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id311619430374686\n"
+"help.text"
+msgid "<emph>Delete columns</emph>: Allow column deletions. Note that column deletions are only allowed on unprotected cells."
+msgstr ""
+
+#. ebwLU
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id561619430376854\n"
+"help.text"
+msgid "<emph>Delete rows</emph>: Allow row deletions. Note that row deletions are only allowed on unprotected cells."
+msgstr ""
+
#. cE3Ff
#: 06060100.xhp
msgctxt ""
@@ -48004,13 +47320,40 @@ msgctxt ""
msgid "On the <emph>Tools - Protect Sheet</emph> menu, activate protection for the sheet. Effective immediately, only the cell range you selected in step 1 can be edited."
msgstr ""
-#. VfJA6
+#. JQWv7
#: 06060100.xhp
msgctxt ""
"06060100.xhp\n"
"par_id3149566\n"
"help.text"
-msgid "To later change an unprotected area to a protected area, select the range. Next, on the <emph>Format - Cells - Cell Protection</emph> tab page, check the <emph>Protected</emph> box. Finally, choose the <emph>Tools - Protect Sheet</emph> menu. The previously editable range is now protected."
+msgid "To later change an unprotected area to a protected area:"
+msgstr ""
+
+#. TzTnE
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id101619439013221\n"
+"help.text"
+msgid "Select the range of cells that will be protected."
+msgstr ""
+
+#. Cc2Tb
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id601619439028536\n"
+"help.text"
+msgid "On the <menuitem>Format - Cells - Cell Protection</menuitem> tab page, check the <emph>Protected</emph> box."
+msgstr ""
+
+#. EeKFF
+#: 06060100.xhp
+msgctxt ""
+"06060100.xhp\n"
+"par_id641619439061892\n"
+"help.text"
+msgid "Choose the <menuitem>Tools - Protect Sheet</menuitem> menu. The previously editable range is now protected."
msgstr ""
#. JaC9W
@@ -48031,13 +47374,13 @@ msgctxt ""
msgid "If a sheet is protected, you will not be able to modify or delete any Cell Styles."
msgstr "如果試算表受保護,則您將無法修改或刪除任何儲存格樣式。"
-#. d39My
+#. WEsxm
#: 06060100.xhp
msgctxt ""
"06060100.xhp\n"
"par_id3154656\n"
"help.text"
-msgid "A protected sheet or cell range can no longer be modified until this protection is disabled. To disable the protection, choose the <emph>Tools - Protect Sheet</emph> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password."
+msgid "A protected sheet or cell range can no longer be modified until this protection is disabled, with the exceptions of the settings for columns and row of the <menuitem>Tools - Protect Sheet</menuitem> dialog. To disable the protection, choose the <menuitem>Tools - Protect Sheet</menuitem> command. If no password was set, the sheet protection is immediately disabled. If the sheet was password protected, the <emph>Remove Protection</emph> dialog opens, where you must enter the password."
msgstr ""
#. scXrG
@@ -48049,24 +47392,6 @@ msgctxt ""
msgid "Once saved, protected sheets can only be saved again by using the <emph>File - Save As</emph> command."
msgstr "儲存後,受保護的試算表僅可以透過 <emph>[檔案] - [另存新檔]</emph> 指令再次儲存。"
-#. A4TcK
-#: 06060100.xhp
-msgctxt ""
-"06060100.xhp\n"
-"hd_id3150206\n"
-"help.text"
-msgid "<link href=\"text/shared/01/password_dlg.xhp\" name=\"Password\">Password (optional)</link>"
-msgstr ""
-
-#. hBPMK
-#: 06060100.xhp
-msgctxt ""
-"06060100.xhp\n"
-"par_id3152990\n"
-"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/protectsheetdlg/password1\">Allows you to enter a password to protect the sheet from unauthorized changes.</ahelp>"
-msgstr ""
-
#. Gr24z
#: 06060100.xhp
msgctxt ""
@@ -49426,14 +48751,14 @@ msgctxt ""
msgid "AutoFilter"
msgstr "自動篩選"
-#. ZGJfP
+#. pGfbC
#: 12040100.xhp
msgctxt ""
"12040100.xhp\n"
"hd_id3153541\n"
"help.text"
-msgid "<link href=\"text/scalc/01/12040100.xhp\" name=\"AutoFilter\">AutoFilter</link>"
-msgstr "<link href=\"text/scalc/01/12040100.xhp\" name=\"自動篩選\">自動篩選</link>"
+msgid "<variable id=\"autofilterh1\"><link href=\"text/scalc/01/12040100.xhp\" name=\"AutoFilter\">AutoFilter</link></variable>"
+msgstr ""
#. cTu3x
#: 12040100.xhp
@@ -49444,6 +48769,240 @@ msgctxt ""
msgid "<ahelp hid=\".uno:DataFilterAutoFilter\">Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.</ahelp>"
msgstr "<ahelp hid=\".uno:DataFilterAutoFilter\">自動篩選選取的儲存格範圍,並建立單列清單方塊 (從中可選擇要顯示的項目)。</ahelp>"
+#. c9BGE
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id101621534096986\n"
+"help.text"
+msgid "Sort Ascending"
+msgstr ""
+
+#. u7XHt
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id31621544435954\n"
+"help.text"
+msgid "Displays the rows of the cell range in ascending order, based on the values in the cells of the current column."
+msgstr ""
+
+#. 6Q8nn
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id561621534101425\n"
+"help.text"
+msgid "Sort Descending"
+msgstr ""
+
+#. CbVJm
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id861621544431393\n"
+"help.text"
+msgid "Displays the rows of the cell range in descending order, based on the values in the cells of the current column."
+msgstr ""
+
+#. sHhH3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id401621534105620\n"
+"help.text"
+msgid "Top 10"
+msgstr ""
+
+#. onMjn
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id341621544426925\n"
+"help.text"
+msgid "Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown."
+msgstr ""
+
+#. 4oiCy
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id541621534109912\n"
+"help.text"
+msgid "Empty"
+msgstr ""
+
+#. i3DFZ
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id941621544422352\n"
+"help.text"
+msgid "Displays only the rows of the cell range that have an empty cell in the current column."
+msgstr ""
+
+#. s26iT
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id821621534116893\n"
+"help.text"
+msgid "Not Empty"
+msgstr ""
+
+#. GCBF5
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id71621544418559\n"
+"help.text"
+msgid "Displays only the rows of the cell range that have a non-empty cell in the current column."
+msgstr ""
+
+#. s5KFC
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id271621534120995\n"
+"help.text"
+msgid "Text color"
+msgstr ""
+
+#. CCGqV
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id691621544414646\n"
+"help.text"
+msgid "Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected."
+msgstr ""
+
+#. pdme8
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id151621534125831\n"
+"help.text"
+msgid "Background color"
+msgstr ""
+
+#. dzEhB
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id491621544410605\n"
+"help.text"
+msgid "Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected."
+msgstr ""
+
+#. wCDB5
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id851621534131430\n"
+"help.text"
+msgid "Standard Filter"
+msgstr ""
+
+#. kqqrX
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id171621544405886\n"
+"help.text"
+msgid "Opens the <link href=\"text/shared/02/12090000.xhp\" name=\"standard filter\">Standard Filter</link> dialog."
+msgstr ""
+
+#. bbVTh
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id551621534136181\n"
+"help.text"
+msgid "Search text box"
+msgstr ""
+
+#. XeGD3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id421621544399700\n"
+"help.text"
+msgid "Search for a specific entry in the list of values found in the current column. As characters are typed in the text box, this list is updated to show only matching entries."
+msgstr ""
+
+#. igezW
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id581621534140892\n"
+"help.text"
+msgid "All"
+msgstr ""
+
+#. F52s3
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id641621544394836\n"
+"help.text"
+msgid "Click once to select to show all rows and click again to select to hide all rows."
+msgstr ""
+
+#. EADGt
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id731621534146408\n"
+"help.text"
+msgid "Show only current"
+msgstr ""
+
+#. FURWe
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id71621544390147\n"
+"help.text"
+msgid "Display only rows containing the value highlighted in the <emph>Value</emph> box."
+msgstr ""
+
+#. ovQAm
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id11621534151081\n"
+"help.text"
+msgid "Hide only current"
+msgstr ""
+
+#. EJgvW
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id491621544384770\n"
+"help.text"
+msgid "Hide all rows containing the value highlighted in the <emph>Value</emph> box and display all other rows."
+msgstr ""
+
+#. kVCCi
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"hd_id621621534155662\n"
+"help.text"
+msgid "Values"
+msgstr ""
+
+#. AzWUy
+#: 12040100.xhp
+msgctxt ""
+"12040100.xhp\n"
+"par_id331621544378745\n"
+"help.text"
+msgid "List of unique values found in the current column."
+msgstr ""
+
#. 4DAJx
#: 12040100.xhp
msgctxt ""
@@ -54835,13 +54394,13 @@ msgctxt ""
msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text."
msgstr ""
-#. 5DDEz
+#. YXQmf
#: ex_data_stat_func.xhp
msgctxt ""
"ex_data_stat_func.xhp\n"
"par_id961527953004850\n"
"help.text"
-msgid "<variable id=\"args\">Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable>"
+msgid "<variable id=\"args\">Func_Range; Range1; Criterion[; Range2; Criterion2][; … ; [Range127; Criterion127]]</variable>"
msgstr ""
#. d8gmy
@@ -54871,13 +54430,103 @@ msgctxt ""
msgid "<emph>Range1</emph> – required argument. It is a range of cells, a name of a named range, or a label of a column or a row, to which the corresponding criterion is to be applied."
msgstr ""
-#. 3wJSR
+#. 45WHz
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id621619279022341\n"
+"help.text"
+msgid "<emph>Criterion</emph>: A criterion is a single cell Reference, Number or Text. It is used in comparisons with cell contents."
+msgstr ""
+
+#. m9EAG
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id731619279029255\n"
+"help.text"
+msgid "A reference to an empty cell is interpreted as the numeric value 0."
+msgstr ""
+
+#. iYNFV
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id31619279035359\n"
+"help.text"
+msgid "A matching expression can be:"
+msgstr ""
+
+#. fSoyL
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id171619279059462\n"
+"help.text"
+msgid "A Number or Logical value. A matching cell content equals the Number or Logical value."
+msgstr ""
+
+#. 7Hfq9
#: ex_data_stat_func.xhp
msgctxt ""
"ex_data_stat_func.xhp\n"
-"par_id23526994221948\n"
+"par_id511619279076504\n"
"help.text"
-msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)."
+msgid "A value beginning with a comparator (<, <=, =, >, >=, <>)."
+msgstr ""
+
+#. YEjSD
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id11619279168512\n"
+"help.text"
+msgid "For =, if the value is empty it matches empty cells."
+msgstr ""
+
+#. 39AJR
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id161619279207350\n"
+"help.text"
+msgid "For <>, if the value is empty it matches non-empty cells."
+msgstr ""
+
+#. 9xDer
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id271619279215695\n"
+"help.text"
+msgid "For <>, if the value is not empty it matches any cell content except the value, including empty cells."
+msgstr ""
+
+#. y2EGU
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id861619279223855\n"
+"help.text"
+msgid "<emph>Note:</emph> \"=0\" does not match empty cells."
+msgstr ""
+
+#. 2nrnV
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id51619279363954\n"
+"help.text"
+msgid "For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes and the property <link href=\"text/shared/optionen/01060500.xhp\" name=\"s\">Search criteria = and <> must apply to whole cells</link> is checked, comparison is against the entire cell contents, if unchecked, comparison is against any subpart of the field that matches the criteria. For = and <>, if the value is not empty and can not be interpreted as a Number type or one of its subtypes applies."
+msgstr ""
+
+#. VG8wZ
+#: ex_data_stat_func.xhp
+msgctxt ""
+"ex_data_stat_func.xhp\n"
+"par_id801619279323556\n"
+"help.text"
+msgid "Other Text value. If the property <link href=\"text/shared/optionen/01060500.xhp\" name=\"s\">Search criteria = and <> must apply to whole cells</link> is true, the comparison is against the entire cell contents, if false, comparison is against any subpart of the field that matches the criteria. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)."
msgstr ""
#. sACAB
@@ -54889,13 +54538,13 @@ msgctxt ""
msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1."
msgstr ""
-#. NygMb
+#. FyA7p
#: ex_data_stat_func.xhp
msgctxt ""
"ex_data_stat_func.xhp\n"
"par_id317001803813193\n"
"help.text"
-msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1."
+msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion."
msgstr ""
#. tzFDE
@@ -55384,6 +55033,33 @@ msgctxt ""
msgid "Examples"
msgstr "範例"
+#. jug32
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"hd_id980889808897165\n"
+"help.text"
+msgid "Returns"
+msgstr ""
+
+#. 5MoDd
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id631556228511025\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. qKsBn
+#: ful_func.xhp
+msgctxt ""
+"ful_func.xhp\n"
+"par_id631556228544875\n"
+"help.text"
+msgid "No"
+msgstr ""
+
#. RGGDw
#: ful_func.xhp
msgctxt ""
@@ -56176,15 +55852,6 @@ msgctxt ""
msgid "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition."
msgstr ""
-#. tSkGD
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id24499731228013\n"
-"help.text"
-msgid "<emph>Criterion</emph> – required argument. A condition in the form of expression or a cell reference with expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)."
-msgstr ""
-
#. sDeiD
#: func_averageif.xhp
msgctxt ""
@@ -57328,6 +56995,1752 @@ msgctxt ""
msgid "<link href=\"text/scalc/01/04060110.xhp#concatenate\" name=\"concatenate\">CONCATENATE</link>"
msgstr ""
+#. A2RFP
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"tit\n"
+"help.text"
+msgid "CONVERT function"
+msgstr ""
+
+#. wHx2Y
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"bm_id3148446\n"
+"help.text"
+msgid "<bookmark_value>CONVERT function</bookmark_value>"
+msgstr ""
+
+#. XE5M9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id9522389625800\n"
+"help.text"
+msgid "<variable id=\"convert_head\"> <link href=\"text/scalc/01/func_convert.xhp\">CONVERT</link> </variable> function"
+msgstr ""
+
+#. fmXAR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154902\n"
+"help.text"
+msgid "<ahelp hid=\"HID_AAI_FUNC_CONVERT\"><variable id=\"convert_desc\">Converts a value from one unit of measurement to the corresponding value in another unit of measurement.</variable></ahelp> Enter the units of measurement directly as text in quotation marks or as a reference. The units of measurement specified through the arguments must match the supported unit symbols, which are case-sensitive. For example, the symbol for the unit \"newton\" is the uppercase \"N\"."
+msgstr ""
+
+#. fUwa3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id761620414839890\n"
+"help.text"
+msgid "The measurement units recognized by <literal>CONVERT</literal> fall into 13 groups, which are listed <link href=\"text/scalc/01/func_convert.xhp#Unit_Groups\" name=\"Unit_Groups_Section\">below</link>. CONVERT will perform conversions between any two units within one group but reject any request to convert between units in different groups."
+msgstr ""
+
+#. x6USE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id861620428840333\n"
+"help.text"
+msgid "You can also add binary and decimal prefixes to units of measurement that support them. The list of all prefixes and their corresponding multipliers are shown <link href=\"text/scalc/01/func_convert.xhp#Prefixes\" name=\"Prefixes_Section\">below</link>."
+msgstr ""
+
+#. GvB7m
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id601621101375988\n"
+"help.text"
+msgid "This function may not be compatible with other spreadsheet software."
+msgstr ""
+
+#. wfq9t
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id23219159944266\n"
+"help.text"
+msgid "<input>CONVERT(Number; FromUnit; ToUnit)</input>"
+msgstr ""
+
+#. RiLFj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3147522\n"
+"help.text"
+msgid "<emph>Number</emph> is the number to be converted."
+msgstr ""
+
+#. GErYL
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154472\n"
+"help.text"
+msgid "<emph>FromUnit</emph> is the unit from which conversion is taking place."
+msgstr ""
+
+#. d2Hrk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3153790\n"
+"help.text"
+msgid "<emph>ToUnit</emph> is the unit to which conversion is taking place. Both units must be of the same type."
+msgstr ""
+
+#. 7D2db
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id541620414925560\n"
+"help.text"
+msgid "If <literal>FromUnit</literal> and <literal>ToUnit</literal> are not valid units from the same group, then <literal>CONVERT</literal> reports an invalid argument error (Err:502)."
+msgstr ""
+
+#. gq5EJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3156336\n"
+"help.text"
+msgid "<input>=CONVERT(-10; \"C\"; \"F\")</input>"
+msgstr ""
+
+#. NacDF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id951620413562988\n"
+"help.text"
+msgid "Here the function converts -10 degrees Celsius to degrees Fahrenheit, returning the value 14. There is not a simple multiplicative relationship between temperature units, as different reference points are used. Hence, as in this case, an input negative number may be converted to a positive value."
+msgstr ""
+
+#. CQPne
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id3154834\n"
+"help.text"
+msgid "<input>=CONVERT(3.5; \"mi\"; \"yd\")</input>"
+msgstr ""
+
+#. xaEX2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id971620413678102\n"
+"help.text"
+msgid "Here the function converts 3.5 international miles to yards, returning the value 6160. Both units are in the Length and distance group."
+msgstr ""
+
+#. 3GMEy
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id741620413834726\n"
+"help.text"
+msgid "<input>=CONVERT(256; \"Gibit\"; \"Mibyte\")</input>"
+msgstr ""
+
+#. pdEtf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id261620413900652\n"
+"help.text"
+msgid "Here the function converts 256 gigibits to mebibytes, returning the value 32768. Both units (bit and byte) are in the Information group and support binary prefixes."
+msgstr ""
+
+#. cdqCp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id761620413966496\n"
+"help.text"
+msgid "<input>=CONVERT(1; \"dyn\"; \"e\")</input>"
+msgstr ""
+
+#. vDR5q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id531620414005955\n"
+"help.text"
+msgid "Here the function returns an invalid argument error (Err:502) because the two units (dyne and erg) are in different groups (Force and Energy respectively)."
+msgstr ""
+
+#. DGVq5
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id261620415240175\n"
+"help.text"
+msgid "Units of measurement"
+msgstr ""
+
+#. oxx8A
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id481620428685029\n"
+"help.text"
+msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Beware that conversions can only happen between units that belong to the same group."
+msgstr ""
+
+#. Rd9Fp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id461620429183259\n"
+"help.text"
+msgid "The column Prefix indicates whether or not a given unit of measurement supports <link href=\"text/scalc/01/func_convert.xhp#Prefixes\" name=\"Prefixes_Section\">prefixes</link>."
+msgstr ""
+
+#. ELyFm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id301620415514760\n"
+"help.text"
+msgid "Area"
+msgstr ""
+
+#. JFG6V
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id121620479750266\n"
+"help.text"
+msgid "Some measurement units have more than one accepted symbol. The accepted unit symbols are separated by semicolons in the <emph>Unit symbol</emph> column."
+msgstr ""
+
+#. ngLDk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id831620415562967\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. HMAmG
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id251620415562967\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. tpUMy
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id151620415562967\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. GfiJV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id61620415562967\n"
+"help.text"
+msgid "Square angstrom"
+msgstr ""
+
+#. GoABk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620415903987\n"
+"help.text"
+msgid "Are"
+msgstr ""
+
+#. kahhN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id631620415904448\n"
+"help.text"
+msgid "Square foot"
+msgstr ""
+
+#. MFjkC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id651620415904891\n"
+"help.text"
+msgid "Hectare"
+msgstr ""
+
+#. EohjY
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id561620415905331\n"
+"help.text"
+msgid "Square inch"
+msgstr ""
+
+#. XZ9X3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id561620415905004\n"
+"help.text"
+msgid "Square light-year"
+msgstr ""
+
+#. kwEMV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id781620416024343\n"
+"help.text"
+msgid "Square meter"
+msgstr ""
+
+#. T9BaY
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id731620416024782\n"
+"help.text"
+msgid "Square international mile"
+msgstr ""
+
+#. 4i4iC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id621620416250948\n"
+"help.text"
+msgid "Morgen"
+msgstr ""
+
+#. HF5iU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id661620416251507\n"
+"help.text"
+msgid "Square nautical mile"
+msgstr ""
+
+#. hCiCS
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id791620416251948\n"
+"help.text"
+msgid "Square pica point"
+msgstr ""
+
+#. ZfeRr
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id771620416417874\n"
+"help.text"
+msgid "Square pica"
+msgstr ""
+
+#. cHh2s
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id621620416418311\n"
+"help.text"
+msgid "International acre"
+msgstr ""
+
+#. AsFDV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620416418768\n"
+"help.text"
+msgid "US survey acre"
+msgstr ""
+
+#. vFpVJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id71620416418025\n"
+"help.text"
+msgid "Square yard"
+msgstr ""
+
+#. Y8KWb
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id661620418842010\n"
+"help.text"
+msgid "Energy"
+msgstr ""
+
+#. MVxwP
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id133389281727763\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. 2YCm2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id215779983443756\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. wERLT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id986783687128923\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. GLvVT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id797688281572156\n"
+"help.text"
+msgid "British thermal unit"
+msgstr ""
+
+#. nu34E
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id844417659281393\n"
+"help.text"
+msgid "Thermochemical calorie"
+msgstr ""
+
+#. DBTz9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id672765982649722\n"
+"help.text"
+msgid "International Steam Table calorie"
+msgstr ""
+
+#. uw6BK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id798492531882282\n"
+"help.text"
+msgid "erg"
+msgstr ""
+
+#. i9qGV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id547247548598782\n"
+"help.text"
+msgid "Electron volt"
+msgstr ""
+
+#. sLtDD
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id587393171297892\n"
+"help.text"
+msgid "Foot-pound"
+msgstr ""
+
+#. 2GjCu
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id695171299238861\n"
+"help.text"
+msgid "Horsepower-hour"
+msgstr ""
+
+#. ZPZRc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id498448587944728\n"
+"help.text"
+msgid "Joule"
+msgstr ""
+
+#. PUrZh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id324829753758823\n"
+"help.text"
+msgid "Watt-hour"
+msgstr ""
+
+#. kPnGq
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id281620418969165\n"
+"help.text"
+msgid "Flux density"
+msgstr ""
+
+#. 4o3NF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id474271648545953\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. DCC5e
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id747764511138273\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. dvVVc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id689379352231556\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. nHMaJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id114822916257326\n"
+"help.text"
+msgid "Gauss"
+msgstr ""
+
+#. 2he9q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id626213287964265\n"
+"help.text"
+msgid "Tesla"
+msgstr ""
+
+#. GFyeu
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id511620419033332\n"
+"help.text"
+msgid "Force"
+msgstr ""
+
+#. CcWkm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id786326578562174\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. MAju2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613697367784781\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 3ZxxK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id338735929142246\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. uaZZL
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id332679599387353\n"
+"help.text"
+msgid "Dyne"
+msgstr ""
+
+#. qkEeo
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id297688664469184\n"
+"help.text"
+msgid "Newton"
+msgstr ""
+
+#. EEy3q
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id413835658896999\n"
+"help.text"
+msgid "Pound-force"
+msgstr ""
+
+#. UmY6Y
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id472715992174398\n"
+"help.text"
+msgid "Pond"
+msgstr ""
+
+#. Z8snf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id61620419155285\n"
+"help.text"
+msgid "Information"
+msgstr ""
+
+#. A3brF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id426724696915849\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. ABpR9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id612374956817974\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. kNxR2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id538681812985912\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. uXtLh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id287396172896473\n"
+"help.text"
+msgid "Bit"
+msgstr ""
+
+#. CQcQ9
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id288619461492324\n"
+"help.text"
+msgid "Byte"
+msgstr ""
+
+#. B3c96
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id21620419214852\n"
+"help.text"
+msgid "Length and distance"
+msgstr ""
+
+#. rfDue
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id939442657661828\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. t8B7a
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385965635167839\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. qBet6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id783715738435884\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. ED5CD
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id871414798381246\n"
+"help.text"
+msgid "Angstrom"
+msgstr ""
+
+#. pZ2tZ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id667871614381886\n"
+"help.text"
+msgid "Ell"
+msgstr ""
+
+#. FxCjJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id116286449743311\n"
+"help.text"
+msgid "Foot"
+msgstr ""
+
+#. VswTE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id174995614358222\n"
+"help.text"
+msgid "Inch"
+msgstr ""
+
+#. YFTAf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id597477613742668\n"
+"help.text"
+msgid "Light-year"
+msgstr ""
+
+#. aqqG6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id414782652978666\n"
+"help.text"
+msgid "Meter"
+msgstr ""
+
+#. kREck
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id246972715165395\n"
+"help.text"
+msgid "International mile"
+msgstr ""
+
+#. 6TCBR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id664674443288268\n"
+"help.text"
+msgid "Nautical mile"
+msgstr ""
+
+#. rUVPA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id139127915416429\n"
+"help.text"
+msgid "Parsec"
+msgstr ""
+
+#. E8DiA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id343241931577938\n"
+"help.text"
+msgid "Pica point"
+msgstr ""
+
+#. J45F6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id314567699952918\n"
+"help.text"
+msgid "Pica"
+msgstr ""
+
+#. jo6cR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id579641593251685\n"
+"help.text"
+msgid "US survey mile"
+msgstr ""
+
+#. bHo6X
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id247251727323315\n"
+"help.text"
+msgid "Yard"
+msgstr ""
+
+#. EVKqC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id101620426269258\n"
+"help.text"
+msgid "Mass and weight"
+msgstr ""
+
+#. sshNo
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id662733781297324\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. 23Fz6
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id314237495552874\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. YXvAc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id543131496247122\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. yS2GB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id163896825569756\n"
+"help.text"
+msgid "Short hundredweight"
+msgstr ""
+
+#. AymnT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id219736221925573\n"
+"help.text"
+msgid "Gram"
+msgstr ""
+
+#. Pcwzj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613363919875679\n"
+"help.text"
+msgid "Grain"
+msgstr ""
+
+#. HfoFq
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id961199633533431\n"
+"help.text"
+msgid "Pound"
+msgstr ""
+
+#. TtiGk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id655456352143671\n"
+"help.text"
+msgid "Ounce"
+msgstr ""
+
+#. pmsEB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id613492674545171\n"
+"help.text"
+msgid "Pennyweight"
+msgstr ""
+
+#. BE88d
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id566783887997575\n"
+"help.text"
+msgid "Slug"
+msgstr ""
+
+#. VmfEH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id731498557457276\n"
+"help.text"
+msgid "Stone"
+msgstr ""
+
+#. ZLyGB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id618416327957968\n"
+"help.text"
+msgid "Short ton"
+msgstr ""
+
+#. 4nGTC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id556166667325333\n"
+"help.text"
+msgid "Unified atomic mass unit"
+msgstr ""
+
+#. nA8vE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id161338688697922\n"
+"help.text"
+msgid "Long hundredweight"
+msgstr ""
+
+#. 23HRX
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id616379569614142\n"
+"help.text"
+msgid "Long ton"
+msgstr ""
+
+#. BPqQG
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id1001620426284123\n"
+"help.text"
+msgid "Power"
+msgstr ""
+
+#. HvGBm
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id765457372987543\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. DGPtJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id222988613874967\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 6DsPs
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id954629589584711\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. 7PLLh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id578436173796358\n"
+"help.text"
+msgid "Mechanical horsepower"
+msgstr ""
+
+#. M6req
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id418898833841613\n"
+"help.text"
+msgid "Pferdestärke or metric horsepower"
+msgstr ""
+
+#. qyteT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id239893771814786\n"
+"help.text"
+msgid "Watt"
+msgstr ""
+
+#. PGKCa
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id541620426359069\n"
+"help.text"
+msgid "Pressure"
+msgstr ""
+
+#. tnByU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id843387541961981\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. Gsj88
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385992865555923\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. geMDd
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id513642579177244\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. tZH3f
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id888153229712212\n"
+"help.text"
+msgid "Standard atmosphere"
+msgstr ""
+
+#. EBaTw
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id849582553771429\n"
+"help.text"
+msgid "Millimeter of mercury"
+msgstr ""
+
+#. AsDNh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id477235647442515\n"
+"help.text"
+msgid "Pascal"
+msgstr ""
+
+#. yyvEQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id453587511744492\n"
+"help.text"
+msgid "Pound per square inch"
+msgstr ""
+
+#. a9ogt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id385442861685423\n"
+"help.text"
+msgid "Torr"
+msgstr ""
+
+#. vWzBh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id61620426438099\n"
+"help.text"
+msgid "Speed"
+msgstr ""
+
+#. AXQxd
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id589222947765948\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. HvMee
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id886677898259849\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. PWNGi
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id439227432319741\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. QLETi
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id391572877557741\n"
+"help.text"
+msgid "Admiralty knot"
+msgstr ""
+
+#. X3yym
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id152721538362456\n"
+"help.text"
+msgid "International knot"
+msgstr ""
+
+#. KAWp4
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id117898736774311\n"
+"help.text"
+msgid "Meters per hour"
+msgstr ""
+
+#. pctXg
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id145334267535329\n"
+"help.text"
+msgid "Meters per second"
+msgstr ""
+
+#. 6yYRz
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id233825548718154\n"
+"help.text"
+msgid "Miles per hour"
+msgstr ""
+
+#. FyEd2
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id351620426496272\n"
+"help.text"
+msgid "Temperature"
+msgstr ""
+
+#. C5MHQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id916682468647914\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. kqAGM
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id828222863857386\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. sGE7h
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id131675777393493\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. do3zs
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id611894272236225\n"
+"help.text"
+msgid "Degree Celsius"
+msgstr ""
+
+#. 3Ng23
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id446899599712639\n"
+"help.text"
+msgid "Degree Fahrenheit"
+msgstr ""
+
+#. JQDwV
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id452842161272274\n"
+"help.text"
+msgid "Kelvin"
+msgstr ""
+
+#. kDHfB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id946395673872875\n"
+"help.text"
+msgid "Degree Rankine"
+msgstr ""
+
+#. mUNBn
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id718454351326149\n"
+"help.text"
+msgid "Degree Réaumur"
+msgstr ""
+
+#. BfAJv
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id291620426558219\n"
+"help.text"
+msgid "Time"
+msgstr ""
+
+#. kFeSN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id935221689591996\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. U8RGh
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id664526138752768\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. 8X7qR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id889226439751962\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. iXcGB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id246817386878489\n"
+"help.text"
+msgid "Day"
+msgstr ""
+
+#. KCEUt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id464925665919665\n"
+"help.text"
+msgid "Hour"
+msgstr ""
+
+#. Bf2jf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id134873473826283\n"
+"help.text"
+msgid "Minute"
+msgstr ""
+
+#. RB2UJ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id424852859961766\n"
+"help.text"
+msgid "Second"
+msgstr ""
+
+#. CKQZz
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id546198897664738\n"
+"help.text"
+msgid "Year"
+msgstr ""
+
+#. CCupk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id151620426617693\n"
+"help.text"
+msgid "Volume"
+msgstr ""
+
+#. YGVzt
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id245659124219512\n"
+"help.text"
+msgid "Unit symbol"
+msgstr ""
+
+#. jvV7i
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id954441838321316\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. QnLHF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id487448753979859\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. oFBFc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id254311578719497\n"
+"help.text"
+msgid "Cubic angstrom"
+msgstr ""
+
+#. Ccm2G
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id545825775819166\n"
+"help.text"
+msgid "Oil barrel"
+msgstr ""
+
+#. a3nDk
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id976829653577442\n"
+"help.text"
+msgid "US bushel"
+msgstr ""
+
+#. Fb3dj
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id184258429676826\n"
+"help.text"
+msgid "US cup"
+msgstr ""
+
+#. z98AU
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id278184952564879\n"
+"help.text"
+msgid "Cubic foot"
+msgstr ""
+
+#. Be5Nc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id466397614396366\n"
+"help.text"
+msgid "US gallon"
+msgstr ""
+
+#. 6dJSb
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id938562498562468\n"
+"help.text"
+msgid "Australian glass (200 milliliters)"
+msgstr ""
+
+#. vFvu4
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id471177863127144\n"
+"help.text"
+msgid "Gross register tonnage"
+msgstr ""
+
+#. tM2GH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id347175644673122\n"
+"help.text"
+msgid "Humpen (500 milliliters)"
+msgstr ""
+
+#. 3jCKA
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id995576717914988\n"
+"help.text"
+msgid "Cubic inch"
+msgstr ""
+
+#. t8skx
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id842329689485738\n"
+"help.text"
+msgid "Liter"
+msgstr ""
+
+#. ZgERp
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id236636296681258\n"
+"help.text"
+msgid "Cubic light-year"
+msgstr ""
+
+#. xbjLF
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id538319527687728\n"
+"help.text"
+msgid "Cubic meter"
+msgstr ""
+
+#. GG8ep
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id463843338576911\n"
+"help.text"
+msgid "Cubic international mile"
+msgstr ""
+
+#. apJka
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id995778363641811\n"
+"help.text"
+msgid "Australian middy (285 milliliters)"
+msgstr ""
+
+#. 5vKXB
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id894695318848125\n"
+"help.text"
+msgid "Measurement ton"
+msgstr ""
+
+#. gAxRC
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id392284181269245\n"
+"help.text"
+msgid "Cubic nautical mile"
+msgstr ""
+
+#. GLMFQ
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id371262895179554\n"
+"help.text"
+msgid "US fluid ounce"
+msgstr ""
+
+#. KdjB5
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id956867693183654\n"
+"help.text"
+msgid "Cubic pica"
+msgstr ""
+
+#. wPWak
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id698697624265559\n"
+"help.text"
+msgid "US pint"
+msgstr ""
+
+#. oaVnc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id615917164511264\n"
+"help.text"
+msgid "US quart"
+msgstr ""
+
+#. nFgfR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id653481929342877\n"
+"help.text"
+msgid "Australian schooner (425 milliliters)"
+msgstr ""
+
+#. yumuN
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id912821548196546\n"
+"help.text"
+msgid "Six pack (2 liters)"
+msgstr ""
+
+#. GNQxR
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id248216629889251\n"
+"help.text"
+msgid "US tablespoon"
+msgstr ""
+
+#. Bs5pc
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id745625921159327\n"
+"help.text"
+msgid "US teaspoon"
+msgstr ""
+
+#. oFoZf
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id864223151994899\n"
+"help.text"
+msgid "Metric teaspoon"
+msgstr ""
+
+#. 6eLBT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id311759289592485\n"
+"help.text"
+msgid "Imperial gallon"
+msgstr ""
+
+#. zJyLT
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id673293916128784\n"
+"help.text"
+msgid "Imperial pint"
+msgstr ""
+
+#. f9zhg
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id213353742979736\n"
+"help.text"
+msgid "Imperial quart"
+msgstr ""
+
+#. TGDmn
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id817884513513347\n"
+"help.text"
+msgid "Cubic yard"
+msgstr ""
+
+#. ej2DE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id21620415408286\n"
+"help.text"
+msgid "Prefixes"
+msgstr ""
+
+#. TSaMK
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id731620426688645\n"
+"help.text"
+msgid "Decimal prefixes"
+msgstr ""
+
+#. cjDA7
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id772395422122114\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. yHdoH
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id448471762246791\n"
+"help.text"
+msgid "Multiplier"
+msgstr ""
+
+#. zByEE
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"hd_id91620427193950\n"
+"help.text"
+msgid "Binary prefixes"
+msgstr ""
+
+#. X7TD3
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id422991712375461\n"
+"help.text"
+msgid "Prefix"
+msgstr ""
+
+#. mAcRr
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id553637738674151\n"
+"help.text"
+msgid "Multiplier"
+msgstr ""
+
+#. gc56z
+#: func_convert.xhp
+msgctxt ""
+"func_convert.xhp\n"
+"par_id871621424421294\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CONVERT\">CONVERT Wiki page</link>"
+msgstr ""
+
#. JEUej
#: func_countifs.xhp
msgctxt ""
@@ -57346,14 +58759,14 @@ msgctxt ""
msgid "<bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value>"
msgstr ""
-#. NRDey
+#. wMH8u
#: func_countifs.xhp
msgctxt ""
"func_countifs.xhp\n"
"hd_id456845684568\n"
"help.text"
-msgid "<variable id=\"countifs_head\"><link href=\"text/scalc/01/func_countifs.xhp\">COUNTIFS</link></variable> function"
-msgstr "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SECOND</link></variable>"
+msgid "<variable id=\"countifs_head\"><link href=\"text/scalc/01/func_countifs.xhp\">COUNTIFS</link></variable>"
+msgstr ""
#. pGTzr
#: func_countifs.xhp
@@ -57364,22 +58777,22 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>"
msgstr ""
-#. xRjyE
+#. jbwVT
#: func_countifs.xhp
msgctxt ""
"func_countifs.xhp\n"
"par_id27421466710275\n"
"help.text"
-msgid "COUNTIFS(Range1; Criterion1[; Range2; Criterion2][; ... ; [Range127; Criterion127]])"
+msgid "COUNTIFS(Range; Criterion[; Range2; Criterion2][; ... ; [Range127; Criterion127]])"
msgstr ""
-#. 2BB8K
+#. KTAXW
#: func_countifs.xhp
msgctxt ""
"func_countifs.xhp\n"
"par_id14734320631377\n"
"help.text"
-msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
+msgid "<emph>Range, Range2, ...</emph> and <emph>Criterion, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument."
msgstr ""
#. ZuFZj
@@ -58426,14 +59839,23 @@ msgctxt ""
msgid "<item type=\"input\">=EOMONTH(DATE(2001;9;14);6)</item> returns the serial number 37346. Formatted as a date, this is 2002-03-31."
msgstr "<item type=\"input\">=EOMONTH(DATE(2001;9;14);6)</item> 會傳回序號 37346。格式化為日期,即為 2002-03-31。"
-#. naTtB
+#. 7eUrP
#: func_eomonth.xhp
msgctxt ""
"func_eomonth.xhp\n"
"par_id3156144\n"
"help.text"
-msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If the date is given as string, it has to be in ISO format."
-msgstr "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> 也有效。若該日期指定為字串,則其必須為 ISO 格式。"
+msgid "<item type=\"input\">=EOMONTH(\"2001-09-14\";6)</item> works as well. If you specify the date directly, we recommend using the standard ISO 8601 format because this should be independent of your selected locale settings."
+msgstr ""
+
+#. Lu8Ng
+#: func_eomonth.xhp
+msgctxt ""
+"func_eomonth.xhp\n"
+"par_id681621540307527\n"
+"help.text"
+msgid "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/EOMONTH\">EOMONTH wiki page</link>"
+msgstr ""
#. BNTm6
#: func_error_type.xhp
@@ -60442,13 +61864,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imcot_des\">Returns the cotangent of a complex number.</variable> The cotangent of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. cdma2
+#. fCe4Y
#: func_imcot.xhp
msgctxt ""
"func_imcot.xhp\n"
"par_id311713256011430\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imcot.svg\" id=\"img_id211575078735993\" width=\"258.56943px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>"
msgstr ""
#. z7EtV
@@ -60523,13 +61945,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imcsc_des\">Returns the cosecant of a complex number. </variable> The cosecant of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. 9P8Xq
+#. FV9Gz
#: func_imcsc.xhp
msgctxt ""
"func_imcsc.xhp\n"
"par_id13510198901485\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imcsc.svg\" id=\"img_id211575078735993\" width=\"594.60278px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>"
msgstr ""
#. jBzZA
@@ -60604,13 +62026,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imcsch_des\">Returns the hyperbolic cosecant of a complex number.</variable> The hyperbolic cosecant of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. VWFPK
+#. FFqZK
#: func_imcsch.xhp
msgctxt ""
"func_imcsch.xhp\n"
"par_id195151657917534\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imcsch.svg\" id=\"img_id211575078735993\" width=\"619.60278px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>"
msgstr ""
#. ndjhY
@@ -60685,13 +62107,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imsec_des\">Returns the secant of a complex number. </variable> The secant of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. gbjYF
+#. y62eA
#: func_imsec.xhp
msgctxt ""
"func_imsec.xhp\n"
"par_id17543461310594\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imsec.svg\" id=\"img_id211575078735993\" width=\"599.10275px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>"
msgstr ""
#. CEucF
@@ -60766,13 +62188,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imsech_des\">Returns the hyperbolic secant of a complex number. </variable> The hyperbolic secant of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. ymrxb
+#. CVDgc
#: func_imsech.xhp
msgctxt ""
"func_imsech.xhp\n"
"par_id74572850718840\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imsech.svg\" id=\"img_id211575078735993\" width=\"624.10275px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>"
msgstr ""
#. Rqker
@@ -61009,13 +62431,13 @@ msgctxt ""
msgid "<ahelp hid=\".\"><variable id=\"imtan_des\">Returns the tangent of a complex number.</variable> The tangent of a complex number can be expressed by:</ahelp>"
msgstr ""
-#. mdUUP
+#. ujidB
#: func_imtan.xhp
msgctxt ""
"func_imtan.xhp\n"
"par_id25021317131239\n"
"help.text"
-msgid "<image src=\"media/helpimg/sc_func_imtan.svg\" id=\"img_id211575078735993\" width=\"597.80275px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>"
+msgid "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>"
msgstr ""
#. 7QtEG
@@ -63331,14 +64753,14 @@ msgctxt ""
msgid "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>"
msgstr "<bookmark_value>COMBIN 函式</bookmark_value><bookmark_value>組合數</bookmark_value>"
-#. b5txh
+#. MpUwQ
#: func_sumifs.xhp
msgctxt ""
"func_sumifs.xhp\n"
"hd_id658866588665886\n"
"help.text"
-msgid "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable> function"
-msgstr "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SECOND</link></variable>"
+msgid "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable>"
+msgstr ""
#. ZEdvF
#: func_sumifs.xhp
@@ -63664,13 +65086,13 @@ msgctxt ""
msgid "<emph>delimiter</emph> is a text string and can be a range."
msgstr ""
-#. CsnD3
+#. 6vMaP
#: func_textjoin.xhp
msgctxt ""
"func_textjoin.xhp\n"
"par_id621556228397269\n"
"help.text"
-msgid "<emph>skip_empty</emph> is a logical (TRUE or FALSE, 1 or 0) argument. When TRUE, empty strings will be ignored."
+msgid "<emph>skip_empty</emph> is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored."
msgstr ""
#. JoYks
@@ -64717,13 +66139,13 @@ msgctxt ""
msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);1)</item> returns 1"
msgstr ""
-#. NHnKC
+#. ADL9J
#: func_weeknum.xhp
msgctxt ""
"func_weeknum.xhp\n"
"par_id3149792\n"
"help.text"
-msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);2)</item> returns 52. If the week starts on Monday, Sunday belongs to the last week of the previous year."
+msgid "<item type=\"input\">=WEEKNUM(DATE(1995;1;1);2)</item> returns 1. Using System 1, the week containing January 1 is the first week of the year."
msgstr ""
#. yBDGQ
@@ -68326,13 +69748,13 @@ msgctxt ""
msgid "<variable id=\"sam01\">Choose <menuitem>Data - Statistics - Sampling</menuitem></variable>"
msgstr ""
-#. MDjEn
+#. bdELn
#: statistics_sampling.xhp
msgctxt ""
"statistics_sampling.xhp\n"
"par_id1000050\n"
"help.text"
-msgid "Sampling allows you to pick data from a <emph>source</emph> table to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis."
+msgid "Sampling allows you to pick data from a <emph>source</emph> table (population) to fill a <emph>target</emph> table. The sampling can be random or in a periodic basis, as well as with or without sample replacement in the source table."
msgstr ""
#. GRbRi
@@ -68353,40 +69775,112 @@ msgctxt ""
msgid "Sampling Method"
msgstr ""
-#. zDwkD
+#. XsLMx
#: statistics_sampling.xhp
msgctxt ""
"statistics_sampling.xhp\n"
-"par_id1000070\n"
+"hd_id611623249550632\n"
"help.text"
-msgid "<emph>Random</emph>: Picks exactly <emph>Sample Size</emph> lines of the source table in a random way."
+msgid "Random"
msgstr ""
-#. AAvrF
+#. fnhdR
#: statistics_sampling.xhp
msgctxt ""
"statistics_sampling.xhp\n"
-"par_id1000080\n"
+"par_id711623249563655\n"
"help.text"
-msgid "<emph>Sample size</emph>: Number of lines sampled from the source table."
+msgid "Picks exactly <emph>Sample Size</emph> lines of the source table in a random way."
msgstr ""
-#. hy48Z
+#. ePB4n
#: statistics_sampling.xhp
msgctxt ""
"statistics_sampling.xhp\n"
-"par_id1000090\n"
+"hd_id431623249579089\n"
"help.text"
-msgid "<emph>Periodic</emph>: Picks lines in a pace defined by <emph>Period</emph>."
+msgid "Sample size"
msgstr ""
-#. i8TDF
+#. LtFAr
#: statistics_sampling.xhp
msgctxt ""
"statistics_sampling.xhp\n"
-"par_id1000100\n"
+"par_id461623249594879\n"
+"help.text"
+msgid "Number of lines sampled from the source table. The Sample size is limited to the population size for all sampling methods without replacement."
+msgstr ""
+
+#. S4cc4
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"hd_id931623249610097\n"
+"help.text"
+msgid "With replacement"
+msgstr ""
+
+#. ArJPP
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"par_id191623249619384\n"
+"help.text"
+msgid "When checked, put back samples in population (source table) after draw. A sample can be drawn more than once and therefore a larger sample size than population is possible. This option is mutually exclusive with <emph>Keep order</emph>. When unchecked, a sample drawn is not put back to the population and sample size is limited to population size."
+msgstr ""
+
+#. QG5Yo
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"hd_id791623249632175\n"
+"help.text"
+msgid "Keep order"
+msgstr ""
+
+#. KBoyr
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"par_id741623249641180\n"
+"help.text"
+msgid "When checked, samples are drawn in order of population data. Samples are not put back to the population (exclusive with <emph>With replacement</emph>). This option is automatically checked for <emph>Periodic</emph> sampling. When unchecked, samples are drawn in random order."
+msgstr ""
+
+#. 73nDr
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"hd_id461623249656476\n"
+"help.text"
+msgid "Periodic"
+msgstr ""
+
+#. MFSpi
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"par_id481623249667345\n"
+"help.text"
+msgid "Picks lines in a pace defined by <emph>Period</emph>."
+msgstr ""
+
+#. jM46a
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"hd_id101623249682605\n"
+"help.text"
+msgid "Period"
+msgstr ""
+
+#. NVGau
+#: statistics_sampling.xhp
+msgctxt ""
+"statistics_sampling.xhp\n"
+"par_id621623249692296\n"
"help.text"
-msgid "<emph>Period</emph>: the number of lines to skip periodically when sampling."
+msgid "The number of lines to skip periodically when sampling. The <emph>Period</emph> is limited to the population size."
msgstr ""
#. NjytZ