aboutsummaryrefslogtreecommitdiff
path: root/source/ja/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2020-04-15 14:08:14 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2020-04-15 14:12:29 +0200
commit1cf550347fdb87391903b533dd1c47135875a9d7 (patch)
tree42aeb67f0d164abb01f73d6ddc7c1d8927a253a3 /source/ja/helpcontent2
parent0a73e51795ef412006c59d3723f265fed445dea1 (diff)
update translations for master
and force-fix errors using pocheck Change-Id: I9f37f1bad2c1005d8b63991fb1a66cd2f14e259b
Diffstat (limited to 'source/ja/helpcontent2')
-rw-r--r--source/ja/helpcontent2/source/text/sbasic/shared.po670
-rw-r--r--source/ja/helpcontent2/source/text/scalc/01.po1615
-rw-r--r--source/ja/helpcontent2/source/text/swriter/01.po6
3 files changed, 1384 insertions, 907 deletions
diff --git a/source/ja/helpcontent2/source/text/sbasic/shared.po b/source/ja/helpcontent2/source/text/sbasic/shared.po
index f5547866942..e0d141ab590 100644
--- a/source/ja/helpcontent2/source/text/sbasic/shared.po
+++ b/source/ja/helpcontent2/source/text/sbasic/shared.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: 2020-04-03 11:46+0200\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
"PO-Revision-Date: 2020-01-24 14:53+0000\n"
"Last-Translator: aefgh39622 <aefgh39622@gmail.com>\n"
"Language-Team: Japanese <https://weblate.documentfoundation.org/projects/libo_help-master/textsbasicshared/ja/>\n"
@@ -2788,15 +2788,6 @@ msgctxt ""
msgid "The <literal>Function</literal> is called using the following syntax:"
msgstr ""
-#. yBxwK
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3146914\n"
-"help.text"
-msgid "Variable=FunctionName(Parameter1, Parameter2,...)"
-msgstr "Variable=FunctionName(Parameter1, Parameter2,...)"
-
#. 33Sss
#: 01020300.xhp
msgctxt ""
@@ -2869,15 +2860,6 @@ msgctxt ""
msgid "If you want to pass a parameter by value insert the key word <literal>ByVal</literal> in front of the parameter when you call a <literal>Sub</literal>, a <literal>Function</literal> or a <literal>Property</literal>, for example:"
msgstr ""
-#. Vzu4F
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150042\n"
-"help.text"
-msgid "Function ReadOnlyParms(ByVal p2, ByVal p2)"
-msgstr ""
-
#. pojXe
#: 01020300.xhp
msgctxt ""
@@ -2887,24 +2869,6 @@ msgctxt ""
msgid "' your code goes here"
msgstr ""
-#. MGPNc
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id131584367516784\n"
-"help.text"
-msgid "End Function"
-msgstr ""
-
-#. bz6EJ
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id801584367475787\n"
-"help.text"
-msgid "result = ReadOnlyParms(parm1, parm2)"
-msgstr ""
-
#. WF4ND
#: 01020300.xhp
msgctxt ""
@@ -2932,15 +2896,6 @@ msgctxt ""
msgid "Functions, procedures or properties can be defined with optional parameters, for example:"
msgstr ""
-#. qBTxH
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id761584366669997\n"
-"help.text"
-msgid "Sub Rounding(number, Optional decimals, Optional format)"
-msgstr ""
-
#. JKj8y
#: 01020300.xhp
msgctxt ""
@@ -2950,15 +2905,6 @@ msgctxt ""
msgid "' your code goes here"
msgstr ""
-#. NtvTc
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"bas_id251584366745722\n"
-"help.text"
-msgid "End Sub"
-msgstr ""
-
#. EHCCS
#: 01020300.xhp
msgctxt ""
@@ -2986,15 +2932,6 @@ msgctxt ""
msgid "Declaring Variables Outside a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>"
msgstr ""
-#. Q3jEW
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150208\n"
-"help.text"
-msgid "Global VarName As TYPENAME"
-msgstr "GLOBAL VarName As TYPENAME"
-
#. 5JwAY
#: 01020300.xhp
msgctxt ""
@@ -3004,15 +2941,6 @@ msgctxt ""
msgid "The variable is valid as long as the %PRODUCTNAME session lasts."
msgstr ""
-#. CSDs2
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3153198\n"
-"help.text"
-msgid "Public VarName As TYPENAME"
-msgstr "PUBLIC VarName As TYPENAME"
-
#. 9akEs
#: 01020300.xhp
msgctxt ""
@@ -3022,15 +2950,6 @@ msgctxt ""
msgid "The variable is valid in all modules."
msgstr "こうして宣言した変数は、すべてのモジュールで有効となります。"
-#. ADEKE
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3158212\n"
-"help.text"
-msgid "Private VarName As TYPENAME"
-msgstr "Private VarName As TYPENAME"
-
#. qeJQx
#: 01020300.xhp
msgctxt ""
@@ -3040,15 +2959,6 @@ msgctxt ""
msgid "The variable is only valid in this module."
msgstr "こうして宣言した変数は、該当モジュールの内部だけで有効となります。"
-#. WQdbC
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3150886\n"
-"help.text"
-msgid "Dim VarName As TYPENAME"
-msgstr "Dim VarName As TYPENAME"
-
#. 85TYe
#: 01020300.xhp
msgctxt ""
@@ -3130,15 +3040,6 @@ msgctxt ""
msgid "Saving Variable Content after Exiting a <literal>Sub</literal> a <literal>Function</literal> or a <literal>Property</literal>"
msgstr ""
-#. qV9Bm
-#: 01020300.xhp
-msgctxt ""
-"01020300.xhp\n"
-"par_id3156288\n"
-"help.text"
-msgid "Static VarName As TYPENAME"
-msgstr "STATIC VarName As TYPENAME"
-
#. hAB34
#: 01020300.xhp
msgctxt ""
@@ -17512,32 +17413,32 @@ msgctxt ""
msgid "Error-Handling Functions"
msgstr "エラーを制御するための関数"
-#. zqvGA
+#. yMyAz
#: 03050000.xhp
msgctxt ""
"03050000.xhp\n"
"hd_id3143271\n"
"help.text"
-msgid "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link>"
-msgstr "<link href=\"text/sbasic/shared/03050000.xhp\" name=\"エラー処理関数\">エラー処理関数</link>"
+msgid "<variable id=\"ErrHandlingh1\"><link href=\"text/sbasic/shared/03050000.xhp\" name=\"Error-Handling Functions\">Error-Handling Functions</link></variable>"
+msgstr ""
-#. BfMGz
+#. KsiEx
#: 03050000.xhp
msgctxt ""
"03050000.xhp\n"
"par_id3145068\n"
"help.text"
-msgid "Use the following statements and functions to define the way $[officename] Basic reacts to run-time errors."
-msgstr "下記のステートメントおよび関数は、$[officename] Basic による実行時エラーの処理法を指定するものです、"
+msgid "Use the following statements and functions to define the way %PRODUCTNAME Basic reacts to run-time errors."
+msgstr ""
-#. acGyE
+#. 9XGsZ
#: 03050000.xhp
msgctxt ""
"03050000.xhp\n"
"par_id3148946\n"
"help.text"
-msgid "$[officename] Basic offers several methods to prevent the termination of a program when a run-time error occurs."
-msgstr "$[officename] Basic には、実行時エラー発生時のプログラム中断を防止するための機能が各種用意されています。"
+msgid "%PRODUCTNAME Basic offers several methods to prevent the termination of a program when a run-time error occurs."
+msgstr ""
#. C2vFE
#: 03050100.xhp
@@ -17944,6 +17845,15 @@ msgctxt ""
msgid "Syntax:"
msgstr "構文:"
+#. fGsdv
+#: 03050500.xhp
+msgctxt ""
+"03050500.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/On-Error_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">On Error Statement diagram</alt></image>"
+msgstr ""
+
#. 7FXhq
#: 03050500.xhp
msgctxt ""
@@ -22993,14 +22903,14 @@ msgctxt ""
msgid "For...Next Statement"
msgstr ""
-#. YGeU7
+#. Byex6
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"bm_id3149205\n"
"help.text"
-msgid "<bookmark_value>For statement</bookmark_value> <bookmark_value>To statement</bookmark_value> <bookmark_value>Step statement</bookmark_value> <bookmark_value>Next statement</bookmark_value>"
-msgstr "<bookmark_value>For; ステートメント</bookmark_value><bookmark_value>To; ステートメント</bookmark_value><bookmark_value>Step; ステートメント</bookmark_value><bookmark_value>Next; ステートメント</bookmark_value>"
+msgid "<bookmark_value>For statement</bookmark_value> <bookmark_value>For Each statement</bookmark_value> <bookmark_value>In keyword</bookmark_value> <bookmark_value>Next keyword</bookmark_value> <bookmark_value>Step keyword</bookmark_value> <bookmark_value>To keyword</bookmark_value> <bookmark_value>Step keyword</bookmark_value>"
+msgstr ""
#. LVP76
#: 03090202.xhp
@@ -23011,14 +22921,14 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03090202.xhp\" name=\"For...Next Statement\">For...Next Statement</link>"
msgstr ""
-#. P6gje
+#. AFEvH
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3143267\n"
"help.text"
-msgid "Repeats the statements between the For...Next block a specified number of times."
-msgstr "For...Next ブロックの間にあるステートメントを、指定回数分だけ繰り返し実行させます。"
+msgid "Repeats the statements between the <literal>For...Next</literal> block a specified number of times."
+msgstr ""
#. h79GC
#: 03090202.xhp
@@ -23029,50 +22939,59 @@ msgctxt ""
msgid "Syntax:"
msgstr "構文:"
-#. 7GuT6
+#. UqJyC
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3148473\n"
+"par_id491585753339474\n"
"help.text"
-msgid "For counter=start To end [Step step]"
-msgstr "For counter=start To end [Step step]"
+msgid "<image src=\"media/helpimg/sbasic/For-Next_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">For Statement diagram</alt></image>"
+msgstr ""
-#. Qn7bF
+#. SuZFA
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3156024\n"
"help.text"
-msgid "statement block"
-msgstr "ステートメントブロック"
+msgid "statement-block"
+msgstr ""
-#. 5H2nw
+#. CCuTr
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3146796\n"
+"par_id3159414\n"
"help.text"
-msgid "[Exit For]"
-msgstr "[Exit For]"
+msgid "statement-block"
+msgstr ""
-#. oPL7W
+#. bcKDQ
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3159414\n"
+"par_id491585653339474\n"
"help.text"
-msgid "statement block"
-msgstr "ステートメントブロック"
+msgid "<image src=\"media/helpimg/sbasic/For-Each_statement.svg\" id=\"img_id4156297484514\"><alt id=\"alt_id15152797484514\">For Each Statement diagram</alt></image>"
+msgstr ""
-#. 7DuFn
+#. YbrKJ
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3153897\n"
+"bas_id821586521234861\n"
"help.text"
-msgid "Next [counter]"
-msgstr "Next [counter]"
+msgid "statement-block"
+msgstr ""
+
+#. 75jXr
+#: 03090202.xhp
+msgctxt ""
+"03090202.xhp\n"
+"bas_id501586521235517\n"
+"help.text"
+msgid "statement-block"
+msgstr ""
#. hE24y
#: 03090202.xhp
@@ -23083,41 +23002,41 @@ msgctxt ""
msgid "Variables:"
msgstr "変数:"
-#. H4t3c
+#. iPLzw
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3150358\n"
"help.text"
-msgid "<emph>Counter:</emph> Loop counter initially assigned the value to the right of the equal sign (start). Only numeric variables are valid. The loop counter increases or decreases according to the variable Step until End is passed."
-msgstr "<emph>Counter:</emph> ループカウンターとして用いる変数で、イコール記号の右側の値 (start) が初期値として割り当てられます。使用可能なものは、数値変数だけです。ループカウンターの値は、Step の指定値に応じて加算ないし減算が行われ、End の指定値に到達するかがチェックされます。"
+msgid "<emph>counter:</emph> Loop <literal>counter</literal> initially assigned the value to the right of the equal sign (<literal>start</literal>). Only numeric variables are valid. The loop counter increases or decreases according to the variable <literal>step</literal> until <literal>end</literal> is passed."
+msgstr ""
-#. PBGU7
+#. crpJL
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3152455\n"
"help.text"
-msgid "<emph>Start:</emph> Numeric variable that defines the initial value at the beginning of the loop."
-msgstr "<emph>Start:</emph> ループ開始時における初期値を指定する数値変数。"
+msgid "<emph>start:</emph> Numeric variable that defines the initial value at the beginning of the loop."
+msgstr ""
-#. B53Sh
+#. u8ZEL
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3151043\n"
"help.text"
-msgid "<emph>End:</emph> Numeric variable that defines the final value at the end of the loop."
-msgstr "<emph>End:</emph> ループ終了時における終了値を指定する数値変数。"
+msgid "<emph>end:</emph> Numeric variable that defines the final value at the end of the loop."
+msgstr ""
-#. RN6Cp
+#. TmxSC
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3156281\n"
"help.text"
-msgid "<emph>Step:</emph> Sets the value by which to increase or decrease the loop counter. If Step is not specified, the loop counter is incremented by 1. In this case, End must be greater than Start. If you want to decrease Counter, End must be less than Start, and Step must be assigned a negative value."
-msgstr "<emph>Step:</emph> ループカウンターの加算幅ないし減算幅を指定する増分値。Step に値を指定しないと、ループカウンターの増分値は 1 とされます。この場合は、Start の指定値よりも大きな値を、End に指定する必要があります。ループカウンターの値を減算させる場合は、Step に負の値を指定して、Start の指定値よりも小さな値を End に指定する必要があります。"
+msgid "<emph>step:</emph> Sets the value by which to increase or decrease the loop counter. If <literal>step</literal> is not specified, the loop counter is incremented by 1. In this case, <literal>end</literal> must be greater than <literal>start</literal>. If you want to decrease <literal>counter</literal>, <literal>end</literal> must be less than <literal>start</literal>, and <literal>step</literal> must be assigned a negative value."
+msgstr ""
#. VMWd9
#: 03090202.xhp
@@ -23128,14 +23047,14 @@ msgctxt ""
msgid "The <emph>For...Next</emph> loop repeats all of the statements in the loop for the number of times that is specified by the parameters."
msgstr "<emph>For...Next</emph> ループでは、パラメーター群で指定する回数分だけ、ステートメントブロックの全コードが繰り返されます。"
-#. MzbXT
+#. 6pQ2G
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3147287\n"
"help.text"
-msgid "As the counter variable is decreased, $[officename] Basic checks if the end value has been reached. As soon as the counter passes the end value, the loop automatically ends."
-msgstr "ループカウンターの値が変化すると、終了値に到達したかを $[officename] Basic がチェックします。カウンター値が終了値に到達すると、ループは終了します。"
+msgid "As the <literal>counter</literal> variable is decreased, %PRODUCTNAME Basic checks if the <literal>end</literal> value has been reached. As soon as the <literal>counter</literal> passes the <literal>end</literal> value, the loop automatically terminates."
+msgstr ""
#. hFEyc
#: 03090202.xhp
@@ -23155,14 +23074,14 @@ msgctxt ""
msgid "If you specify an increment of 0, the statements between <emph>For</emph> and <emph>Next</emph> are repeated continuously."
msgstr "増分値を0とすると、<emph>For</emph> から <emph>Next</emph> までの間にあるステートメントブロックが永続的に繰り返し実行され続けます。"
-#. wMUFA
+#. Xxfcy
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3155854\n"
"help.text"
-msgid "When counting down the counter variable, $[officename] Basic checks for overflow or underflow. The loop ends when Counter exceeds End (positive Step value) or is less than End (negative Step value)."
-msgstr "カウンタ変数値の増減に対しては、オーバーフローまたはアンダーフローの発生を $[officename] Basic がチェックします。 カウンター変数の値が End の指定値を超過するか (Step に正の値を指定した場合)、End の指定値を下回った (Step に負の値を指定した場合) 段階で、ループは終了します。"
+msgid "When counting down the counter variable, %PRODUCTNAME Basic checks for overflow or underflow. The loop ends when <literal>counter</literal> exceeds <literal>end</literal> (positive Step value) or is less than <literal>end</literal> (negative Step value)."
+msgstr ""
#. DNpBx
#: 03090202.xhp
@@ -23173,167 +23092,113 @@ msgctxt ""
msgid "Use the <emph>Exit For</emph> statement to exit the loop unconditionally. This statement must be within a <emph>For...Next</emph> loop. Use the <emph>If...Then</emph> statement to test the exit condition as follows:"
msgstr "<emph>Exit For</emph> ステートメントを指定すると、ループは無条件に終了させられます。このステートメントは、<emph>For...Next</emph> ループの内部に記述する必要があります。この場合も、下記の例のように <emph>If...Then</emph> ステートメントを使って、終了条件を満たしているかの判定が行えます。"
-#. vYTyG
+#. M36BA
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3153190\n"
+"bas_id621586522583437\n"
"help.text"
-msgid "For..."
-msgstr "For..."
-
-#. AeEhE
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3149482\n"
-"help.text"
-msgid "statements"
-msgstr "ステートメント群"
-
-#. qvVwR
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3147124\n"
-"help.text"
-msgid "If condition = True Then Exit For"
-msgstr "If 終了条件 = True Then Exit For"
-
-#. FuKCd
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3153159\n"
-"help.text"
-msgid "statements"
-msgstr "ステートメント群"
+msgid "statement-block"
+msgstr ""
-#. LoD97
+#. k56rG
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3154096\n"
+"bas_id711586522584013\n"
"help.text"
-msgid "Next"
-msgstr "Next"
+msgid "statement-block"
+msgstr ""
-#. KfKRR
+#. C2e3R
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3156286\n"
"help.text"
-msgid "Note: In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited."
-msgstr "注意:複数の <emph>For...Next</emph> ループをネストしている場合、1 つの <emph>Exit For</emph> ステートメントで無条件に終了できるループは 1 つだけです。"
+msgid "In nested <emph>For...Next</emph> loops, if you exit a loop unconditionally with <emph>Exit For</emph>, only one loop is exited."
+msgstr ""
-#. McR4Z
+#. Xo6Nj
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"hd_id3148457\n"
"help.text"
-msgid "Example"
-msgstr "例"
+msgid "Examples"
+msgstr ""
-#. 3hXfC
+#. mdCY2
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
"par_id3151074\n"
"help.text"
-msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that are first filled with various contents:"
-msgstr "下記の例では、初期設定として各種の名前を代入した要素数 10 の配列 ( sEntry( )) を用意しておき、二重にネストしたループを使って要素の並べ替えを行っています。"
-
-#. k2qGE
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3155767\n"
-"help.text"
-msgid "sEntry(0) = \"Jerry\""
-msgstr "sEntry(0) = \"Jerry\""
-
-#. jfGrU
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3153711\n"
-"help.text"
-msgid "sEntry(1) = \"Patty\""
-msgstr "sEntry(1) = \"Patty\""
-
-#. LBHzA
-#: 03090202.xhp
-msgctxt ""
-"03090202.xhp\n"
-"par_id3148993\n"
-"help.text"
-msgid "sEntry(2) = \"Kurt\""
-msgstr "sEntry(2) = \"Kurt\""
+msgid "The following example uses two nested loops to sort a string array with 10 elements ( sEntry() ), that is filled with various contents:"
+msgstr ""
-#. hBFon
+#. uEoLD
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3156382\n"
+"par_id561586524231943\n"
"help.text"
-msgid "sEntry(3) = \"Thomas\""
-msgstr "sEntry(3) = \"Thomas\""
+msgid "This explores the content of an array to display each item it contains."
+msgstr ""
-#. 2Afje
+#. TGDLQ
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3155174\n"
+"bas_id511586523090639\n"
"help.text"
-msgid "sEntry(4) = \"Michael\""
-msgstr "sEntry(4) = \"Michael\""
+msgid "Sub list_iteration"
+msgstr ""
-#. SGKJB
+#. biVQS
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3166448\n"
+"bas_id391586523091799\n"
"help.text"
-msgid "sEntry(5) = \"David\""
-msgstr "sEntry(5) = \"David\""
+msgid "cutlery = Array(\"fork\", \"knife\", \"spoon\")"
+msgstr ""
-#. 856Y8
+#. AupdW
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3149255\n"
+"bas_id811586523092655\n"
"help.text"
-msgid "sEntry(6) = \"Cathy\""
-msgstr "sEntry(6) = \"Cathy\""
+msgid "For Each item in cutlery"
+msgstr ""
-#. qAQBw
+#. BdxhG
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3149565\n"
+"bas_id271586523092911\n"
"help.text"
-msgid "sEntry(7) = \"Susie\""
-msgstr "sEntry(7) = \"Susie\""
+msgid "Print item"
+msgstr ""
-#. zUTiM
+#. Pjkxm
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3145148\n"
+"bas_id941586523093415\n"
"help.text"
-msgid "sEntry(8) = \"Edward\""
-msgstr "sEntry(8) = \"Edward\""
+msgid "Next ' item"
+msgstr ""
-#. AsMRN
+#. ArG25
#: 03090202.xhp
msgctxt ""
"03090202.xhp\n"
-"par_id3145229\n"
+"bas_id301586523093607\n"
"help.text"
-msgid "sEntry(9) = \"Christine\""
-msgstr "sEntry(9) = \"Christine\""
+msgid "End Sub"
+msgstr ""
#. GD68h
#: 03090203.xhp
@@ -24118,14 +23983,14 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03090401.xhp\" name=\"Call Statement\">Call Statement</link>"
msgstr ""
-#. wneEE
+#. nPKzF
#: 03090401.xhp
msgctxt ""
"03090401.xhp\n"
"par_id3153394\n"
"help.text"
-msgid "Transfers the control of the program to a subroutine, a function, or a DLL procedure."
-msgstr "プログラムの制御を、サブルーチン、関数、DLL プロシージャーなどに渡します。"
+msgid "Transfers the control of the program to a subroutine, a function, or a procedure of a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">Dynamic Link Library (DLL)</link>. The keyword, type and number of parameters is dependent on the routine that is being called."
+msgstr ""
#. MdeJS
#: 03090401.xhp
@@ -24163,32 +24028,50 @@ msgctxt ""
msgid "Parameters:"
msgstr "パラメーター:"
-#. dbwfN
+#. C2MXB
#: 03090401.xhp
msgctxt ""
"03090401.xhp\n"
"par_id3148473\n"
"help.text"
-msgid "<emph>name:</emph> Name of the subroutine, the function, or the DLL that you want to call"
+msgid "<emph>name:</emph> Name of the subroutine, the function, or the <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Dynamic Link Library\">DLL</link> that you want to call"
msgstr ""
-#. iFYrJ
+#. 23rrr
#: 03090401.xhp
msgctxt ""
"03090401.xhp\n"
"par_id3148946\n"
"help.text"
-msgid "<emph>param:</emph> Parameters to pass to the procedure. The keyword, type and number of parameters is dependent on the routine that is being called."
+msgid "<emph>param:</emph> Keyword parameter name to pass to the routine, followed by its <emph>value</emph>. The name must match the routine declaration. Keywords are optional and can be used in any order."
msgstr ""
-#. 4LVmZ
+#. r9JSP
+#: 03090401.xhp
+msgctxt ""
+"03090401.xhp\n"
+"par_id871586190690812\n"
+"help.text"
+msgid "<emph>value:</emph> Positional parameter value. The type is dependent on the routine that is being called"
+msgstr ""
+
+#. gANH7
+#: 03090401.xhp
+msgctxt ""
+"03090401.xhp\n"
+"par_id421586006407428\n"
+"help.text"
+msgid "When mixing positional and keyword parameters, make sure positional parameters are following the routine declaration order."
+msgstr ""
+
+#. xFXk8
#: 03090401.xhp
msgctxt ""
"03090401.xhp\n"
"par_id3154216\n"
"help.text"
-msgid "A keyword is optional when you call a procedure. If a function is executed as an expression, the parameters must be enclosed by brackets in the statement. If a DLL is called, it must first be specified in the <emph>Declare-Statement</emph>."
-msgstr "プロシージャー呼び出し時のキーワードは省略可能です。関数を表式の一部として実行する場合、ステートメント中に記述するパラメーターはかっこで囲む必要があります。DLL を呼び出す場合は、最初に <emph>Declare ステートメント</emph> による宣言をしておく必要があります。"
+msgid "When a function is used as an expression, enclosing parameters with brackets becomes necessary. Using a <link href=\"text/sbasic/shared/03090403.xhp\" name=\"Declare Statement\">Declare statement</link> is compulsory prior to call a DLL."
+msgstr ""
#. QZZ8c
#: 03090401.xhp
@@ -25900,13 +25783,13 @@ msgctxt ""
msgid "<bookmark_value>CVErr function</bookmark_value>"
msgstr "<bookmark_value>CVErr 関数</bookmark_value>"
-#. hpChf
+#. zHAeD
#: 03100080.xhp
msgctxt ""
"03100080.xhp\n"
"par_idN1054B\n"
"help.text"
-msgid "<link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link>"
+msgid "<variable id=\"CvErrh1\"><link href=\"text/sbasic/shared/03100080.xhp\">CVErr Function</link></variable>"
msgstr ""
#. 3B8u2
@@ -28681,13 +28564,13 @@ msgctxt ""
msgid "<bookmark_value>IsError function</bookmark_value>"
msgstr "<bookmark_value>IsError 関数</bookmark_value>"
-#. CG3nf
+#. FDXnr
#: 03102450.xhp
msgctxt ""
"03102450.xhp\n"
"par_idN1054E\n"
"help.text"
-msgid "<link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link>"
+msgid "<variable id=\"IsErrorh1\"><link href=\"text/sbasic/shared/03102450.xhp\">IsError Function</link></variable>"
msgstr ""
#. yQg58
@@ -29374,14 +29257,14 @@ msgctxt ""
msgid "Syntax:"
msgstr "構文:"
-#. 6bD7g
+#. ZR3gW
#: 03103100.xhp
msgctxt ""
"03103100.xhp\n"
-"par_id3154285\n"
+"par_id41586012988213\n"
"help.text"
-msgid "[Let] VarName=Expression"
-msgstr "[Let] VarName=Expression"
+msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Let Statement diagram</alt></image>"
+msgstr ""
#. X4WmE
#: 03103100.xhp
@@ -29392,14 +29275,14 @@ msgctxt ""
msgid "Parameters:"
msgstr "パラメーター:"
-#. GDfsk
+#. DpLuj
#: 03103100.xhp
msgctxt ""
"03103100.xhp\n"
"par_id3147560\n"
"help.text"
-msgid "<emph>VarName:</emph> Variable that you want to assign a value to. Value and variable type must be compatible."
-msgstr "<emph>VarName:</emph> 値を代入する変数。変数と代入する値は、データ型が一致している必要があります。"
+msgid "<emph>variable:</emph> Variable that you want to assign a value to. Value and variable type must be compatible."
+msgstr ""
#. ZCswn
#: 03103100.xhp
@@ -30103,14 +29986,14 @@ msgctxt ""
msgid "Set Statement"
msgstr ""
-#. zHGh5
+#. GzHJQ
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"bm_id3154422\n"
"help.text"
-msgid "<bookmark_value>Set statement</bookmark_value> <bookmark_value>Nothing object</bookmark_value>"
-msgstr "<bookmark_value>Set ステートメント</bookmark_value><bookmark_value>Nothing オブジェクト</bookmark_value>"
+msgid "<bookmark_value>Set statement</bookmark_value> <bookmark_value>New keyword</bookmark_value> <bookmark_value>Nothing object</bookmark_value>"
+msgstr ""
#. eramH
#: 03103700.xhp
@@ -30121,14 +30004,14 @@ msgctxt ""
msgid "<link href=\"text/sbasic/shared/03103700.xhp\" name=\"Set Statement\">Set Statement</link>"
msgstr ""
-#. EZQ7H
+#. qNuUW
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"par_id3159149\n"
"help.text"
-msgid "Sets an object reference on a variable or a Property."
-msgstr "変数や属性へのオブジェクト参照を設定します。"
+msgid "Sets an object reference on a variable."
+msgstr ""
#. MkkED
#: 03103700.xhp
@@ -30139,14 +30022,23 @@ msgctxt ""
msgid "Syntax:"
msgstr "構文:"
-#. VNH9y
+#. DiSYW
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/LetSet_statement.svg\" id=\"img_id4156306484514\"><alt id=\"alt_id15152796484514\">Set Statement diagram</alt></image>"
+msgstr ""
+
+#. P5Xm2
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"par_id3154217\n"
"help.text"
-msgid "Set ObjectVar = Object"
-msgstr "Set ObjectVar = Object"
+msgid "Set variable = object"
+msgstr ""
#. r4fJx
#: 03103700.xhp
@@ -30157,32 +30049,41 @@ msgctxt ""
msgid "Parameters:"
msgstr "パラメーター:"
-#. CMGdW
+#. K6c5D
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"par_id3156281\n"
"help.text"
-msgid "<emph>ObjectVar:</emph> a variable or a property that requires an object reference."
-msgstr "<emph>ObjectVar:</emph> オブジェクト参照を設定する変数ないし属性。"
+msgid "<emph>variable:</emph> a variable or a property that requires an object reference."
+msgstr ""
-#. F7X5E
+#. kSZDp
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"par_id3159252\n"
"help.text"
-msgid "<emph>Object:</emph> Object that the variable or the property refers to."
-msgstr "<emph>Object: </emph> 変数や属性への参照を設定するオブジェクト。"
+msgid "<emph>object:</emph> Object that the variable refers to."
+msgstr ""
-#. 27u9f
+#. goUzz
#: 03103700.xhp
msgctxt ""
"03103700.xhp\n"
"par_idN10623\n"
"help.text"
-msgid "<emph>Nothing</emph> - Assign the <emph>Nothing</emph> object to a variable to remove a previous assignment."
-msgstr "<emph>Nothing</emph> - 変数に <emph>Nothing</emph> オブジェクトを割り当て、以前の割り当てを削除します。"
+msgid "<emph>Nothing</emph> - Assign <emph>Nothing</emph> to a variable to remove a previous assignment."
+msgstr ""
+
+#. PUiZf
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id101586014505785\n"
+"help.text"
+msgid "The keyword <emph>Set</emph> is optional."
+msgstr ""
#. SGsRz
#: 03103700.xhp
@@ -30193,6 +30094,15 @@ msgctxt ""
msgid "Example:"
msgstr "例:"
+#. dt2A8
+#: 03103700.xhp
+msgctxt ""
+"03103700.xhp\n"
+"par_id841586014507226\n"
+"help.text"
+msgid "Use <emph>New</emph> only to assign a <link href=\"text/sbasic/shared/classmodule\" name=\"ClassModule\">class module</link> instance to a variable."
+msgstr ""
+
#. ukqdX
#: 03103800.xhp
msgctxt ""
@@ -40174,6 +40084,186 @@ msgctxt ""
msgid "See also <link href=\"text/sbasic/shared/00000002.xhp\" name=\"external\">URL Notation</link>"
msgstr ""
+#. PRG9t
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"tit\n"
+"help.text"
+msgid "Resume Statement"
+msgstr ""
+
+#. sMcg4
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0001\n"
+"help.text"
+msgid "<bookmark_value>Resume statement</bookmark_value>"
+msgstr ""
+
+#. LTupm
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0002\n"
+"help.text"
+msgid "<variable id=\"resumeh1\"><link href=\"text/sbasic/shared/Resume.xhp\" name=\"Resume statement\">Resume Statement</link></variable>"
+msgstr ""
+
+#. AVhyb
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"N0003\n"
+"help.text"
+msgid "Resets error information and indicates what to execute next."
+msgstr ""
+
+#. FhZm3
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id491585753339474\n"
+"help.text"
+msgid "<image src=\"media/helpimg/sbasic/Resume_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Resume Statement diagram</alt></image>"
+msgstr ""
+
+#. KAJEM
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id481586090298901\n"
+"help.text"
+msgid "<emph>0: </emph>Resets error information and re-executes the instruction that caused the error. <emph>0</emph> is optional."
+msgstr ""
+
+#. RTTux
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id331586090532804\n"
+"help.text"
+msgid "<emph>label: </emph>Resets error information and executes the instruction at the given label."
+msgstr ""
+
+#. 7RP8z
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id331586090432804\n"
+"help.text"
+msgid "<emph>Next: </emph>Resets error information and executes the instruction following the one that caused the error."
+msgstr ""
+
+#. 3Jge7
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id441586333320983\n"
+"help.text"
+msgid "Error information is built with <literal>Erl</literal>, <literal>Err</literal> and <literal>Error$</literal> functions."
+msgstr ""
+
+#. PoXod
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id741586333516110\n"
+"help.text"
+msgid "<literal>Erl</literal>: Module line number where error occurs."
+msgstr ""
+
+#. aX9ZN
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id81586333580520\n"
+"help.text"
+msgid "<literal>Err</literal>: Error number."
+msgstr ""
+
+#. ctA2t
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id721586333586263\n"
+"help.text"
+msgid "<literal>Error[$]</literal>: Error description."
+msgstr ""
+
+#. fDJgb
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id941586091561618\n"
+"help.text"
+msgid "Using <emph>Resume</emph> to reset error information prevents the propagation of the handled condition to calling routines."
+msgstr ""
+
+#. coy5D
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"hd_id441586092960246\n"
+"help.text"
+msgid "Examples:"
+msgstr ""
+
+#. 4dyMX
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id961586248539108\n"
+"help.text"
+msgid "Typical error handling routines are: alerting the user, fixing the error, logging error information or re-throwing custom errors that provide explanations with resolution instructions. Use <literal>Resume label</literal> when requiring such mechanisms."
+msgstr ""
+
+#. VCDS3
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id451586093122848\n"
+"help.text"
+msgid "' routine code goes here"
+msgstr ""
+
+#. BFzfG
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id515860931234846\n"
+"help.text"
+msgid "Error 91 ' example error"
+msgstr ""
+
+#. uFVnv
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"bas_id361586093126654\n"
+"help.text"
+msgid "' routine cleanup code goes here"
+msgstr ""
+
+#. UNbMJ
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id61586095819168\n"
+"help.text"
+msgid "Use <literal>Resume Next</literal>, for example, when reporting anomalies encountered for an iterating process that must not be interrupted. In which case multiple handling routines may be required."
+msgstr ""
+
+#. AeVfB
+#: Resume.xhp
+msgctxt ""
+"Resume.xhp\n"
+"par_id461586091018138\n"
+"help.text"
+msgid "Using <literal>Resume</literal> without parameters to re-execute the faulty instruction can fit certain situations. However that may cause a never ending loop."
+msgstr ""
+
#. MqMrx
#: classmodule.xhp
msgctxt ""
diff --git a/source/ja/helpcontent2/source/text/scalc/01.po b/source/ja/helpcontent2/source/text/scalc/01.po
index 430cc532c0d..da6c9f483ea 100644
--- a/source/ja/helpcontent2/source/text/scalc/01.po
+++ b/source/ja/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: 2020-04-03 11:46+0200\n"
+"POT-Creation-Date: 2020-04-15 12:52+0200\n"
"PO-Revision-Date: 2019-08-09 07:40+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -6199,14 +6199,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">Calculates the amount received that is paid for a fixed-interest security at a given point in time.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_RECEIVED\">固定金利証券に対してある時点で支払われる金額を計算します。</ahelp>"
-#. XhTVX
+#. BiDCz
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3145362\n"
"help.text"
-msgid "RECEIVED(\"Settlement\"; \"Maturity\"; Investment; Discount; Basis)"
-msgstr "RECEIVED(\"Settlement\"; \"Maturity\"; 投資; 割引率; 基準)"
+msgid "RECEIVED(Settlement; Maturity; Investment; Discount[; Basis])"
+msgstr ""
#. oHAVz
#: 04060103.xhp
@@ -6991,14 +6991,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_DISC\">Calculates the allowance (discount) of a security as a percentage.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_DISC\">証券に対する割引率を計算します。</ahelp>"
-#. tusey
+#. fBGBA
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3149756\n"
"help.text"
-msgid "DISC(\"Settlement\"; \"Maturity\"; Price; Redemption; Basis)"
-msgstr "DISC(\"Settlement\"; \"Maturity\"; 取得価額; 償還価額; 基準)"
+msgid "DISC(Settlement; Maturity; Price; Redemption[; Basis])"
+msgstr ""
#. Uyj29
#: 04060103.xhp
@@ -7081,13 +7081,13 @@ msgctxt ""
msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>"
msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\" visibility=\"visible\">固定金利証券の期間の年数を計算します。</ahelp>"
-#. bJZPP
+#. 7ixum
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3153373\n"
"help.text"
-msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)"
+msgid "DURATION(Settlement; Maturity; Coupon; Yield; Frequency[; Basis])"
msgstr ""
#. JeeVp
@@ -7144,13 +7144,13 @@ msgctxt ""
msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?"
msgstr "証券を 2001 年 1 月 1 日に購入し、満期日は 2006 年 1 月 1 日です。名目利率は 8% です。利回りは 9.0% です。利息は半年に一度支払われます (年間の利息支払回数は 2 回)。1 日単位の未払い利息計算 (基準 3) を使用して、修正された期間を求めます。"
-#. ggYzf
+#. ADc8t
#: 04060103.xhp
msgctxt ""
"04060103.xhp\n"
"par_id3154902\n"
"help.text"
-msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>"
+msgid "<input>=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</input> returns 4.2 years."
msgstr ""
#. TjeEJ
@@ -12661,420 +12661,6 @@ msgctxt ""
msgid "<item type=\"input\">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897)."
msgstr "<item type=\"input\">=LOG10(5)</item> は、底が 10 の場合の 5 の対数 (約 0.69897) を返します。"
-#. fnS8m
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3152518\n"
-"help.text"
-msgid "<bookmark_value>CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>CEILING 関数</bookmark_value><bookmark_value>丸め;基準値の倍数に切り上げる</bookmark_value>"
-
-#. FtjnD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3152518\n"
-"help.text"
-msgid "CEILING"
-msgstr "CEILING"
-
-#. BDPUw
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_OBERGRENZE\">数値を挟む基準値の倍数のうち、大きい方の値を返します。</ahelp>"
-
-#. fhdEu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153454\n"
-"help.text"
-msgid "CEILING(Number; Significance; Mode)"
-msgstr "CEILING(数値; 基準値; モード)"
-
-#. PyYGM
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3153467\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr "<emph>数値</emph> は、切り上げの対象となる数値です。"
-
-#. GQVYD
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155000\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>基準値</emph> は、切り上げられる値がその倍数となる値です。"
-
-#. dEi4T
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3155020\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr ""
-
-#. MUqdA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163792\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
-msgstr ""
-
-#. B5jSx
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING(-11;-2)</item> は、-10 を返します。"
-
-#. H6Ai9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145725\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;0)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING(-11;-2;0)</item> は、-10 を返します。"
-
-#. X8Ebc
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3145740\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING(-11;-2;1)</item> returns -12"
-msgstr "<item type=\"input\">=CEILING(-11;-2;1)</item> は、-12 を返します。"
-
-#. NWAdq
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2952518\n"
-"help.text"
-msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>CEILING 関数</bookmark_value><bookmark_value>丸め;基準値の倍数に切り上げる</bookmark_value>"
-
-#. TL2Mo
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2952518\n"
-"help.text"
-msgid "CEILING.PRECISE"
-msgstr "CEILING.PRECISE関数"
-
-#. uP3ef
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr ""
-
-#. af8Jy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953454\n"
-"help.text"
-msgid "CEILING.PRECISE(Number; Significance)"
-msgstr ""
-
-#. c2S3Q
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>数値</emph> は、切り上げの対象となる数値です。"
-
-#. De3wj
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>基準値</emph> は、切り上げられる値がその倍数となる値です。"
-
-#. ATzN5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2945710\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING.PRECISE(-11;-2)</item> は、-10 を返します。"
-
-#. CyR3Z
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id911516997198644\n"
-"help.text"
-msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
-msgstr ""
-
-#. 47WTb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id91516997330445\n"
-"help.text"
-msgid "CEILING.MATH"
-msgstr ""
-
-#. fj22A
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id81516997342088\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number up to the nearest multiple of Significance.</ahelp>"
-msgstr ""
-
-#. dEs2U
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id841516997669932\n"
-"help.text"
-msgid "CEILING.MATH(Number; Significance; Mode)"
-msgstr ""
-
-#. mVrcG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id651516997706287\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded up."
-msgstr ""
-
-#. eWEoz
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id491516997725772\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded up."
-msgstr ""
-
-#. DhhJP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id451516997742909\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero."
-msgstr ""
-
-#. pNkWd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id291516998575663\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
-msgstr ""
-
-#. AWN7C
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id111516997803684\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3)</item> returns -9"
-msgstr ""
-
-#. VRy7N
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id1001516997821483\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.MATH(-10;-3;0)</item> returns -9"
-msgstr ""
-
-#. Cqx7f
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id641516997837754\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.MATH(-10;-3;1)</item> returns -12"
-msgstr ""
-
-#. 5eFKb
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id921516998608939\n"
-"help.text"
-msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
-msgstr ""
-
-#. 7CEZC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id411516998838823\n"
-"help.text"
-msgid "CEILING.XCL"
-msgstr ""
-
-#. vYMF6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id811516998845826\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number away from zero to the nearest multiple of Significance.</ahelp>"
-msgstr ""
-
-#. hh5aZ
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id251516998856873\n"
-"help.text"
-msgid "CEILING.XCL(Number; Significance)"
-msgstr ""
-
-#. cwEnK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998874263\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded."
-msgstr ""
-
-#. RLTcE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id151516998882622\n"
-"help.text"
-msgid "<emph>Significance</emph> is the number to whose multiple the value is to be rounded."
-msgstr ""
-
-#. FZWHB
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id341516998889754\n"
-"help.text"
-msgid "This function exists for interoperability with Microsoft Excel 2007 or older versions."
-msgstr ""
-
-#. UuVCG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id91516998917254\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(1;3)</item> returns 3"
-msgstr ""
-
-#. mD3Gy
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id761516998929693\n"
-"help.text"
-msgid "<item type=\"input\">=CEILING.XCL(7;4)</item> returns 8"
-msgstr ""
-
-#. C59zA
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id671516998958873\n"
-"help.text"
-msgid "<item type=\"item_type\">=CEILING.XCL(-10;-3)</item> returns -12"
-msgstr ""
-
-#. VwPyC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id8952518\n"
-"help.text"
-msgid "<bookmark_value>ISO.CEILING function</bookmark_value> <bookmark_value>rounding;up to multiples of significance</bookmark_value>"
-msgstr "<bookmark_value>CEILING 関数</bookmark_value><bookmark_value>丸め;基準値の倍数に切り上げる</bookmark_value>"
-
-#. DhoD5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id8952518\n"
-"help.text"
-msgid "ISO.CEILING"
-msgstr "ISO.CEILING 関数"
-
-#. a8Z2B
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953422\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr ""
-
-#. iGoz8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953454\n"
-"help.text"
-msgid "ISO.CEILING(Number; Significance)"
-msgstr ""
-
-#. p7ssP
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8953467\n"
-"help.text"
-msgid "<emph>Number</emph> (required) is the number that is to be rounded up."
-msgstr "<emph>数値</emph> は、切り上げの対象となる数値です。"
-
-#. FBHry
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8955000\n"
-"help.text"
-msgid "<emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up."
-msgstr "<emph>基準値</emph> は、切り上げられる値がその倍数となる値です。"
-
-#. M8dYu
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id8945710\n"
-"help.text"
-msgid "<item type=\"input\">=ISO.CEILING(-11;-2)</item> returns -10"
-msgstr "<item type=\"input\">=CEILING(-11;-2)</item> は、-10 を返します。"
-
#. tQjUA
#: 04060106.xhp
msgctxt ""
@@ -15037,168 +14623,6 @@ msgctxt ""
msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5."
msgstr "<item type=\"input\">=ODD(-3.1)</item> は、5 を返します。"
-#. CR7gG
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id2957404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>FLOOR.XCL function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr ""
-
-#. ticPN
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id2957404\n"
-"help.text"
-msgid "FLOOR.PRECISE"
-msgstr ""
-
-#. eZWE9
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp>"
-msgstr ""
-
-#. BKB8E
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957464\n"
-"help.text"
-msgid "FLOOR.PRECISE(Number; Significance)"
-msgstr ""
-
-#. Mt3KY
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>数値</emph> は、切り下げられる値です。"
-
-#. oe3sn
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2957497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>基準値</emph> は、切り下げられる値がその倍数となる値です。"
-
-#. FCZhS
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id2963945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR( -11;-2)</item> は、-12 を返します。"
-
-#. aDgE5
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"bm_id3157404\n"
-"help.text"
-msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>FLOOR.MATH function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
-msgstr ""
-
-#. BAZE3
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"hd_id3157404\n"
-"help.text"
-msgid "FLOOR"
-msgstr "FLOOR"
-
-#. WHyYX
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157432\n"
-"help.text"
-msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number down to the nearest multiple of Significance.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">最も近い基準値の倍数に切り下げた数を返します。</ahelp>"
-
-#. DDbJ6
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157464\n"
-"help.text"
-msgid "FLOOR(Number; Significance; Mode)"
-msgstr "FLOOR(数値; 基準値; モード)"
-
-#. cEAXh
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157478\n"
-"help.text"
-msgid "<emph>Number</emph> is the number that is to be rounded down."
-msgstr "<emph>数値</emph> は、切り下げられる値です。"
-
-#. zEGez
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157497\n"
-"help.text"
-msgid "<emph>Significance</emph> is the value to whose multiple the number is to be rounded down."
-msgstr "<emph>基準値</emph> は、切り下げられる値がその倍数となる値です。"
-
-#. dDExC
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3157517\n"
-"help.text"
-msgid "<emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero."
-msgstr ""
-
-#. Z6Cnd
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163894\n"
-"help.text"
-msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero."
-msgstr ""
-
-#. 4FuF8
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163945\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR( -11;-2)</item> は、-12 を返します。"
-
-#. R4ppE
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163966\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;0)</item> returns -12"
-msgstr "<item type=\"input\">=FLOOR( -11;-2;0)</item> は、-12 を返します。"
-
-#. aWzUK
-#: 04060106.xhp
-msgctxt ""
-"04060106.xhp\n"
-"par_id3163988\n"
-"help.text"
-msgid "<item type=\"input\">=FLOOR( -11;-2;1)</item> returns -10"
-msgstr "<item type=\"input\">=FLOOR( -11;-2;1)</item> は、-10 を返します。"
-
#. itiAQ
#: 04060106.xhp
msgctxt ""
@@ -16585,41 +16009,41 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_MMULT\">Calculates the array product of two arrays.</ahelp> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns."
msgstr "<ahelp hid=\"HID_FUNC_MMULT\">2 つの行列の行列積を計算します。</ahelp>行列 1 の列数は、行列 2 の行数と一致しなければなりません。平方行列は、同数の行と列を持ちます。"
-#. dEKAU
+#. JUTAD
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3150798\n"
"help.text"
-msgid "MMULT(Array; Array)"
-msgstr "MMULT(行列; 行列)"
+msgid "MMULT(Array 1; Array 2)"
+msgstr ""
-#. noXqv
+#. DqghH
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3150812\n"
"help.text"
-msgid "<emph>Array</emph> at first place represents the first array used in the array product."
-msgstr "最初の位置にある <emph>行列</emph> は、行列積で使用される最初の行列です。"
+msgid "<emph>Array 1</emph> represents the first array used in the array product."
+msgstr ""
-#. 5qGeT
+#. FDfwg
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3152553\n"
"help.text"
-msgid "<emph>Array</emph> at second place represents the second array with the same number of rows."
-msgstr "2 つめの <emph>行列</emph> とは、行数が同じの 2 つめの行列です。"
+msgid "<emph>Array 2</emph> represents the second array with the same number of rows."
+msgstr ""
-#. RoWHa
+#. CuGxm
#: 04060107.xhp
msgctxt ""
"04060107.xhp\n"
"par_id3146826\n"
"help.text"
-msgid "Select a square range. Choose the MMULT function. Select the first <emph>Array</emph>, then select the second <emph>Array</emph>. Using <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
-msgstr "範囲を選択します。MMULT 関数を選びます。最初の <emph>行列</emph> を選択し、次に 2 つめの <emph>行列</emph> を選択します。<emph>関数ウィザード</emph> を使用し、<emph>行列</emph> チェックボックスをオンにし、<emph>OK</emph> をクリックします。出力行列が、最初に選択された範囲に表示されます。"
+msgid "Select a square range. Choose the MMULT function. Select <emph>Array 1</emph>, then select <emph>Array 2</emph>. Using the <emph>Function Wizard</emph>, mark the <emph>Array</emph> check box. Click <emph>OK</emph>. The output array will appear in the first selected range."
+msgstr ""
#. vPBWq
#: 04060107.xhp
@@ -18313,15 +17737,6 @@ msgctxt ""
msgid "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518."
msgstr "セル A1 が Err:518 を表示する場合、関数 <item type=\"input\">=ERRORTYPE(A1)</item> は数字 518 を返します。"
-#. FWJTB
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
-"hd_id275141466817507\n"
-"help.text"
-msgid "<embedvar href=\"text/scalc/01/func_error_type.xhp#error_type_head\"/>"
-msgstr ""
-
#. mtLKD
#: 04060109.xhp
msgctxt ""
@@ -33784,6 +33199,15 @@ msgctxt ""
msgid "<ahelp hid=\".\">Returns the inverse of CHISQDIST.</ahelp>"
msgstr "<ahelp hid=\".\">CHISQDISTの逆を返します。</ahelp>"
+#. ELVTS
+#: 04060181.xhp
+msgctxt ""
+"04060181.xhp\n"
+"par_id21585771564740\n"
+"help.text"
+msgid "CHISQINV(Probability; Degrees of Freedom)"
+msgstr ""
+
#. KibGe
#: 04060181.xhp
msgctxt ""
@@ -35764,6 +35188,15 @@ msgctxt ""
msgid "<ahelp hid=\".\">Returns the Gamma function value.</ahelp> Note that GAMMAINV is not the inverse of GAMMA, but of GAMMADIST."
msgstr "<ahelp hid=\".\">ガンマ関数値を返します。</ahelp>GAMMAINV が GAMMA の逆関数ではなく、GAMMADIST の逆関数であることに注意してください。"
+#. WT29Z
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id211585771824267\n"
+"help.text"
+msgid "GAMMA(Number)"
+msgstr ""
+
#. 2DdQa
#: 04060182.xhp
msgctxt ""
@@ -36637,14 +36070,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">Returns the hypergeometric distribution.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_HYPGEOMVERT\">超幾何分布を返します。</ahelp>"
-#. fNMzN
+#. 5uQ3c
#: 04060182.xhp
msgctxt ""
"04060182.xhp\n"
"par_id3155388\n"
"help.text"
-msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation)"
-msgstr "HYPGEOMDIST(X; 標本数; 成功回数; 母集団数)"
+msgid "HYPGEOMDIST(X; NSample; Successes; NPopulation[; Cumulative])"
+msgstr ""
#. ingyW
#: 04060182.xhp
@@ -36682,6 +36115,15 @@ msgctxt ""
msgid "<emph>NPopulation </emph>is the size of the total population."
msgstr "<emph>母集合数</emph> は、母集合全体の大きさです。"
+#. oDuYV
+#: 04060182.xhp
+msgctxt ""
+"04060182.xhp\n"
+"par_id231585952506847\n"
+"help.text"
+msgid "<emph>Cumulative </emph> (optional) specifies whether to calculate the probability density function (FALSE or 0) or the cumulative distribution function (any other value). The cumulative distribution function is the default if no value is specified for this parameter."
+msgstr ""
+
#. WUiB6
#: 04060182.xhp
msgctxt ""
@@ -55987,6 +55429,528 @@ msgctxt ""
msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
msgstr ""
+#. s6GFW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"tit\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. EWCte
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id971586216771519\n"
+"help.text"
+msgid "Ceiling functions"
+msgstr ""
+
+#. M92qb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id3152518\n"
+"help.text"
+msgid "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. XR3RK
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id3152518\n"
+"help.text"
+msgid "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\" name=\"CEILING\">CEILING</link></variable>"
+msgstr ""
+
+#. E9m3Y
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number up to the nearest multiple of s significance value.</ahelp>"
+msgstr ""
+
+#. PfT3s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id601586207136514\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. s9tRF
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3163792\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero."
+msgstr ""
+
+#. mZwNV
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153454\n"
+"help.text"
+msgid "CEILING(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. XHjhc
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. XEqxw
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. AosjB
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id3155020\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)."
+msgstr ""
+
+#. Ka9pC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id281586208138400\n"
+"help.text"
+msgid "<input>=CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ztdNi
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208142416\n"
+"help.text"
+msgid "<input>=CEILING(3.45, 3)</input> returns 6."
+msgstr ""
+
+#. XGfA3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id921586208146984\n"
+"help.text"
+msgid "<input>=CEILING(-1.234)</input> returns -1."
+msgstr ""
+
+#. ss5WP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491586208152183\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 0)</input> returns -44."
+msgstr ""
+
+#. FY9XN
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291586208158119\n"
+"help.text"
+msgid "<input>=CEILING(-45.67, -2, 1)</input> returns -46."
+msgstr ""
+
+#. rZ78k
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id2952518\n"
+"help.text"
+msgid "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. 5DWRd
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id2952518\n"
+"help.text"
+msgid "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\" name=\"CEILING.PRECISE\">CEILING.PRECISE</link></variable>"
+msgstr ""
+
+#. aTD6P
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. BjuBa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586642494759\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. EErBR
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id631586642933797\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section312\" name=\"isoceiling\">ISO.CEILING</link> function."
+msgstr ""
+
+#. yYT7X
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2953454\n"
+"help.text"
+msgid "CEILING.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. FaYeD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id2955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. 6Vtow
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id461586211894475\n"
+"help.text"
+msgid "This function calculates identical results to the ISO.CEILING function"
+msgstr ""
+
+#. 8WiRx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id201586213398634\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(3.45)</input> returns 4."
+msgstr ""
+
+#. kkosx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586213406243\n"
+"help.text"
+msgid "<input>=CEILING.PRECISE(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. WV9bx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id911516997198644\n"
+"help.text"
+msgid "<bookmark_value>CEILING.MATH function</bookmark_value>"
+msgstr ""
+
+#. 7xeKu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id91516997330445\n"
+"help.text"
+msgid "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\" name=\"CEILING.MATH\">CEILING.MATH</link></variable>"
+msgstr ""
+
+#. AzJvD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id81516997342088\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. QLGe7
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id911586642319078\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. Km7yb
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id841516997669932\n"
+"help.text"
+msgid "CEILING.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. EAezJ
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id491516997725772\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. EiWLa
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id451516997742909\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)."
+msgstr ""
+
+#. aYczG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id291516998575663\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. je22s
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id331586208590009\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45)</input> returns 4."
+msgstr ""
+
+#. 6BkMe
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id481586208595809\n"
+"help.text"
+msgid "<input>=CEILING.MATH(3.45,-3)</input> returns 6."
+msgstr ""
+
+#. Eby7i
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id641586208600665\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-1.234)</input> returns -1."
+msgstr ""
+
+#. fH4Yt
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151586208604536\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,-2,0)</input> returns -44."
+msgstr ""
+
+#. MGVBD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id971586208611345\n"
+"help.text"
+msgid "<input>=CEILING.MATH(-45.67,+2, 1)</input> returns -46."
+msgstr ""
+
+#. EzE9t
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id921516998608939\n"
+"help.text"
+msgid "<bookmark_value>CEILING.XCL function</bookmark_value>"
+msgstr ""
+
+#. CRMmT
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id411516998838823\n"
+"help.text"
+msgid "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\" name=\"CEILING.XCL\">CEILING.XCL</link></variable>"
+msgstr ""
+
+#. 2tuD3
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811516998845826\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. tAyJj
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id361586213828675\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. 2CKjm
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id881586213934118\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function."
+msgstr ""
+
+#. GspBr
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id251516998856873\n"
+"help.text"
+msgid "CEILING.XCL(Number; Significance)"
+msgstr ""
+
+#. eTSgx
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id151516998882622\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. 6n7qn
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id421586214128242\n"
+"help.text"
+msgid "<input>=CEILING.XCL(3.45,2)</input> returns 4."
+msgstr ""
+
+#. SZYUC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id651586214132234\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,2)</input> returns -44."
+msgstr ""
+
+#. pz8Go
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id811586214136666\n"
+"help.text"
+msgid "<input>=CEILING.XCL(-45.67,-2)</input> returns -46."
+msgstr ""
+
+#. GMzhD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"bm_id8952518\n"
+"help.text"
+msgid "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>"
+msgstr ""
+
+#. q22aC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"hd_id8952518\n"
+"help.text"
+msgid "<variable id=\"ISO.CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\" name=\"ISO.CEILING\">ISO.CEILING</link></variable>"
+msgstr ""
+
+#. 5beBC
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953422\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. SFZNu
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id101586214229587\n"
+"help.text"
+msgid "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. qu8FG
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id821586214265060\n"
+"help.text"
+msgid "This function calculates identical results to the <link href=\"#Section311\" name=\"ceilingprecise\">CEILING.PRECISE</link> function."
+msgstr ""
+
+#. LZzHU
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8953454\n"
+"help.text"
+msgid "ISO.CEILING(Number[; Significance])"
+msgstr ""
+
+#. hwhCW
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id8955000\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. FSFdP
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id801586214431463\n"
+"help.text"
+msgid "<input>=ISO.CEILING(3.45)</input> returns 4."
+msgstr ""
+
+#. ENMYD
+#: func_ceiling.xhp
+msgctxt ""
+"func_ceiling.xhp\n"
+"par_id181586214438808\n"
+"help.text"
+msgid "<input>=ISO.CEILING(-45.67,2)</input> returns 44."
+msgstr ""
+
#. GuEcB
#: func_color.xhp
msgctxt ""
@@ -56950,14 +56914,14 @@ msgctxt ""
msgid "<ahelp hid=\"HID_FUNC_TAGE360\">Returns the difference between two dates based on the 360 day year used in interest calculations.</ahelp>"
msgstr "<ahelp hid=\"HID_FUNC_TAGE360\">1 年 360 日の単位 (利息計算に使用する) をベースに、2 つの日付の間の日数を返します。</ahelp>"
-#. ow4Jg
+#. Vndiw
#: func_days360.xhp
msgctxt ""
"func_days360.xhp\n"
"par_id3155313\n"
"help.text"
-msgid "DAYS360(\"Date1\"; \"Date2\"; Type)"
-msgstr "DAYS360(\"日付 1\"; \"日付 2\"; タイプ)"
+msgid "DAYS360(Date1; Date2[; Type])"
+msgstr ""
#. 5qfGz
#: func_days360.xhp
@@ -57607,6 +57571,429 @@ msgctxt ""
msgid "<input>=FINDB(\"ᄫᄬ\";\"ᄩᄔᄕᄜᄝᄞᄠgᄢᄣᄫᄬᄭᄮᄯᄲᄶ\";17)</input> returns 19."
msgstr ""
+#. aACGP
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"tit\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. RuCRw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id391586285373874\n"
+"help.text"
+msgid "FLOOR Functions"
+msgstr ""
+
+#. hkrkw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id3157404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. KoqGL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id3157404\n"
+"help.text"
+msgid "<variable id=\"FLOORh1\"><link href=\"text/scalc/01/func_floor.xhp#floor\" name=\"FLOOR\">FLOOR</link></variable>"
+msgstr ""
+
+#. VSV8H
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. 345Fr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586285977707\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs."
+msgstr ""
+
+#. 2haGU
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157464\n"
+"help.text"
+msgid "FLOOR(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. ERf3D
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3153467\n"
+"help.text"
+msgid "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number."
+msgstr ""
+
+#. 8w8tL
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>."
+msgstr ""
+
+#. qCpHR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3157517\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)."
+msgstr ""
+
+#. 5kHtR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id3163894\n"
+"help.text"
+msgid "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions."
+msgstr ""
+
+#. EU85r
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586287595376\n"
+"help.text"
+msgid "<input>=FLOOR(3.45)</input> returns 3."
+msgstr ""
+
+#. vuJc5
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287600048\n"
+"help.text"
+msgid "<input>=FLOOR(3.45, 3)</input> returns 3."
+msgstr ""
+
+#. uTWTb
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id661586287604519\n"
+"help.text"
+msgid "<input>=FLOOR(-1.234)</input> returns -2."
+msgstr ""
+
+#. 8ZGDc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id741586287608968\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 0)</input> returns -46."
+msgstr ""
+
+#. gXsTm
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id431586287616089\n"
+"help.text"
+msgid "<input>=FLOOR(-45.67, -2, 1)</input> returns -44."
+msgstr ""
+
+#. zzTLr
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id811586290952465\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.MATH function</bookmark_value>"
+msgstr ""
+
+#. rEELD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id1001586287279297\n"
+"help.text"
+msgid "<variable id=\"FLOOR.MATHh1\"><link href=\"text/scalc/01/func_floor.xhp#floormath\" name=\"FLOOR.MATH\">FLOOR.MATH</link></variable>"
+msgstr ""
+
+#. BBjwd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id721586287302689\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. UJLZc
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id311586287323417\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored."
+msgstr ""
+
+#. 4weAd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id851586287535879\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2013 or newer."
+msgstr ""
+
+#. 4DFyG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id161586287421523\n"
+"help.text"
+msgid "FLOOR.MATH(Number[; Significance[; Mode]])"
+msgstr ""
+
+#. Un6FB
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586287448716\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. L9MKT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586287494401\n"
+"help.text"
+msgid "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero)."
+msgstr ""
+
+#. wCd8C
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id101586287621816\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45)</input> returns 3."
+msgstr ""
+
+#. p27MD
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id771586287627784\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(3.45,-3)</input> returns 3."
+msgstr ""
+
+#. Fehfx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586287632392\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-1.234)</input> returns -2."
+msgstr ""
+
+#. eQfea
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id631586287637256\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46."
+msgstr ""
+
+#. XXqpS
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id371586287641888\n"
+"help.text"
+msgid "<input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44."
+msgstr ""
+
+#. 9MJem
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id2957404\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>"
+msgstr ""
+
+#. niyQj
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id2957404\n"
+"help.text"
+msgid "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\" name=\"FLOOR.PRECISE\">FLOOR.PRECISE</link></variable>"
+msgstr ""
+
+#. DgQBx
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957432\n"
+"help.text"
+msgid "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>"
+msgstr ""
+
+#. NHMnz
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id261586641501175\n"
+"help.text"
+msgid "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored."
+msgstr ""
+
+#. ni9y2
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957464\n"
+"help.text"
+msgid "FLOOR.PRECISE(Number[; Significance])"
+msgstr ""
+
+#. pirHp
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id2957497\n"
+"help.text"
+msgid "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1."
+msgstr ""
+
+#. smFCw
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id981586291388900\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(3.45)</input> returns 3."
+msgstr ""
+
+#. Q9vnd
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id831586291395477\n"
+"help.text"
+msgid "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. HnS5F
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"bm_id171586291849333\n"
+"help.text"
+msgid "<bookmark_value>FLOOR.XCL function</bookmark_value>"
+msgstr ""
+
+#. LMEET
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"hd_id791586291468176\n"
+"help.text"
+msgid "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\" name=\"FLOOR.XCL\">FLOOR.XCL</link></variable>"
+msgstr ""
+
+#. WMsAT
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id521586291476023\n"
+"help.text"
+msgid "Rounds a number to the nearest multiple of a significance value."
+msgstr ""
+
+#. jrymG
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id401586291488768\n"
+"help.text"
+msgid "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative."
+msgstr ""
+
+#. BFXRR
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id231586291503319\n"
+"help.text"
+msgid "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function."
+msgstr ""
+
+#. WA7uC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id491586291532177\n"
+"help.text"
+msgid "FLOOR.XCL(Number; Significance)"
+msgstr ""
+
+#. aRww7
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id761586291578755\n"
+"help.text"
+msgid "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded."
+msgstr ""
+
+#. HXuMo
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id531586291622306\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(3.45,2)</input> returns 2."
+msgstr ""
+
+#. gFyGC
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id361586291628003\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,2)</input> returns -46."
+msgstr ""
+
+#. EU7xy
+#: func_floor.xhp
+msgctxt ""
+"func_floor.xhp\n"
+"par_id801586291641099\n"
+"help.text"
+msgid "<input>=FLOOR.XCL(-45.67,-2)</input> returns -44."
+msgstr ""
+
#. 2YcR7
#: func_forecastetsadd.xhp
msgctxt ""
diff --git a/source/ja/helpcontent2/source/text/swriter/01.po b/source/ja/helpcontent2/source/text/swriter/01.po
index 9ff483c2ebc..0c270485106 100644
--- a/source/ja/helpcontent2/source/text/swriter/01.po
+++ b/source/ja/helpcontent2/source/text/swriter/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: 2020-04-03 11:47+0200\n"
+"POT-Creation-Date: 2020-04-08 14:22+0200\n"
"PO-Revision-Date: 2018-10-21 20:22+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -7306,13 +7306,13 @@ msgctxt ""
msgid "Name"
msgstr "名前"
-#. Zjnxw
+#. kDDEs
#: 04090002.xhp
msgctxt ""
"04090002.xhp\n"
"par_id3156259\n"
"help.text"
-msgid "<variable id=\"FieldValue\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list."
+msgid "<variable id=\"FieldName\"><ahelp hid=\"modules/swriter/ui/fldrefpage/name\">Type the name of the user-defined field that you want to create.</ahelp></variable> To set a target, click \"Set Reference\" in the <emph>Type</emph> list, type a name in this box, and then click <emph>Insert</emph>. To reference the new target, click the target name in the <emph>Selection</emph> list."
msgstr ""
#. DRRLC