aboutsummaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2
diff options
context:
space:
mode:
authorChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-12-21 18:00:56 +0100
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2021-12-21 18:06:05 +0100
commitf506a2490665212eeefb5934d6d4346a8a8c1856 (patch)
tree1d46d830bbfd1d144bf730aa29950d8a837587d6 /source/zh-TW/helpcontent2
parent9658a28df4b4c0eb79a9635221bab10ee09fed61 (diff)
update translations for 7.3.0 rc1
and force-fix errors using pocheck Change-Id: Iaf5f970103a9ace669ee6019b2362031e34cbdf0
Diffstat (limited to 'source/zh-TW/helpcontent2')
-rw-r--r--source/zh-TW/helpcontent2/source/text/sbasic/python.po38
-rw-r--r--source/zh-TW/helpcontent2/source/text/sbasic/shared.po539
-rw-r--r--source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po1248
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po6
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/00.po11
-rw-r--r--source/zh-TW/helpcontent2/source/text/shared/guide.po132
-rw-r--r--source/zh-TW/helpcontent2/source/text/swriter/guide.po32
7 files changed, 1345 insertions, 661 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/python.po b/source/zh-TW/helpcontent2/source/text/sbasic/python.po
index 8d2fe90344c..2fd28039424 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/python.po
+++ b/source/zh-TW/helpcontent2/source/text/sbasic/python.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-11-16 12:08+0100\n"
+"POT-Creation-Date: 2021-12-20 13:20+0100\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -274,33 +274,6 @@ msgctxt ""
msgid "Python Syntax"
msgstr ""
-#. GXEC9
-#: python_2_basic.xhp
-msgctxt ""
-"python_2_basic.xhp\n"
-"N0369\n"
-"help.text"
-msgid "<literal>results = script.invoke((prompt,buttons,title), (), ())</literal>"
-msgstr ""
-
-#. 465No
-#: python_2_basic.xhp
-msgctxt ""
-"python_2_basic.xhp\n"
-"N0370\n"
-"help.text"
-msgid "<literal>script.invoke((message,), tuple, ())</literal>"
-msgstr ""
-
-#. wnGWp
-#: python_2_basic.xhp
-msgctxt ""
-"python_2_basic.xhp\n"
-"N0371\n"
-"help.text"
-msgid "<literal>script.invoke((args), (), results)</literal>"
-msgstr ""
-
#. oWBhX
#: python_2_basic.xhp
msgctxt ""
@@ -634,15 +607,6 @@ msgctxt ""
msgid "<literal>OnLoad</literal> and <literal>OnUnload</literal> events can be used to respectively set and unset Python programs path. They are described as <menuitem>Open document</menuitem> and <menuitem>Document closed</menuitem>."
msgstr ""
-#. AdYNb
-#: python_document_events.xhp
-msgctxt ""
-"python_document_events.xhp\n"
-"N0543\n"
-"help.text"
-msgid "class UiDocument(unohelper.Base, AdapterPattern):"
-msgstr ""
-
#. i7waD
#: python_document_events.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/shared.po b/source/zh-TW/helpcontent2/source/text/sbasic/shared.po
index 4e62945f1b1..a97e9e3f540 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/shared.po
+++ b/source/zh-TW/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: 2021-11-24 12:02+0100\n"
+"POT-Creation-Date: 2021-12-20 13:20+0100\n"
"PO-Revision-Date: 2018-10-21 20:41+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -8441,13 +8441,13 @@ msgctxt ""
msgid "sVar = MsgBox( \"Las Vegas\",256 + 16 + 2,\"Dialog title\")"
msgstr "sVar = MsgBox ( \"Las Vegas\",256 + 16 + 2,\"Dialog title\")"
-#. mos4Z
+#. ubeYB
#: 03010102.xhp
msgctxt ""
"03010102.xhp\n"
"par_id051220170242005479\n"
"help.text"
-msgid "sVar = MsgBox(\"Las Vegas\", MB_DEFBUTTON2 + MB_ICONSTOP + MB_ABORTRETRYCANCEL, \"Dialog title\")"
+msgid "sVar = MsgBox(\"Las Vegas\", MB_DEFBUTTON2 + MB_ICONSTOP + MB_ABORTRETRYIGNORE, \"Dialog title\")"
msgstr ""
#. BaStC
@@ -8810,15 +8810,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. qNGaq
-#: 03010301.xhp
-msgctxt ""
-"03010301.xhp\n"
-"par_id3149457\n"
-"help.text"
-msgid "Blue (Color As Long)"
-msgstr "Blue(Color As Long)"
-
#. 6NsAv
#: 03010301.xhp
msgctxt ""
@@ -8945,15 +8936,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. yGCYn
-#: 03010302.xhp
-msgctxt ""
-"03010302.xhp\n"
-"par_id3153969\n"
-"help.text"
-msgid "Green (Color As Long)"
-msgstr "Green(Color As Long)"
-
#. q3DPS
#: 03010302.xhp
msgctxt ""
@@ -9080,15 +9062,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. 3nHCU
-#: 03010303.xhp
-msgctxt ""
-"03010303.xhp\n"
-"par_id3150448\n"
-"help.text"
-msgid "Red (ColorNumber As Long)"
-msgstr "Red(ColorNumber As Long)"
-
#. nbbWR
#: 03010303.xhp
msgctxt ""
@@ -9224,15 +9197,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. scoHN
-#: 03010304.xhp
-msgctxt ""
-"03010304.xhp\n"
-"par_id3151042\n"
-"help.text"
-msgid "QBColor (ColorNumber As Integer)"
-msgstr "QBColor(ColorNumber As Integer)"
-
#. 32yR4
#: 03010304.xhp
msgctxt ""
@@ -9242,15 +9206,6 @@ msgctxt ""
msgid "Return value:"
msgstr "<emph>傳回值類型</emph>:"
-#. MNPy2
-#: 03010304.xhp
-msgctxt ""
-"03010304.xhp\n"
-"par_id3154685\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. Z9k2a
#: 03010304.xhp
msgctxt ""
@@ -9494,15 +9449,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. rd647
-#: 03010305.xhp
-msgctxt ""
-"03010305.xhp\n"
-"par_id3155132\n"
-"help.text"
-msgid "RGB (Red, Green, Blue)"
-msgstr "RGB(Red, Green, Blue)"
-
#. T8jX4
#: 03010305.xhp
msgctxt ""
@@ -9512,15 +9458,6 @@ msgctxt ""
msgid "Return value:"
msgstr "<emph>傳回值類型</emph>:"
-#. MRb5q
-#: 03010305.xhp
-msgctxt ""
-"03010305.xhp\n"
-"par_id3159153\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. FRE8M
#: 03010305.xhp
msgctxt ""
@@ -9710,15 +9647,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/Close_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Close Statement diagram</alt></image>"
msgstr ""
-#. FEDAa
-#: 03020101.xhp
-msgctxt ""
-"03020101.xhp\n"
-"par_id3147265\n"
-"help.text"
-msgid "Close [[#]fileNum [, [#]fileNum2 [,...]]]"
-msgstr ""
-
#. gdqMu
#: 03020101.xhp
msgctxt ""
@@ -10088,15 +10016,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/Get_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Get Statement diagram</alt></image>"
msgstr ""
-#. xBhKA
-#: 03020201.xhp
-msgctxt ""
-"03020201.xhp\n"
-"par_id3150792\n"
-"help.text"
-msgid "Get [#]fileNum, [recordNum|filePos], variable"
-msgstr ""
-
#. UM9CG
#: 03020201.xhp
msgctxt ""
@@ -10520,15 +10439,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/Put_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Put Statement diagram</alt></image>"
msgstr ""
-#. RBpeh
-#: 03020204.xhp
-msgctxt ""
-"03020204.xhp\n"
-"par_id3155132\n"
-"help.text"
-msgid "Put [#]fileNum, [recordNum|filePos], variable"
-msgstr ""
-
#. bSFd2
#: 03020204.xhp
msgctxt ""
@@ -10736,15 +10646,6 @@ msgctxt ""
msgid "Determines if the file pointer has reached the end of a file."
msgstr "確定檔案指標是否到達檔案的結尾。"
-#. KmauZ
-#: 03020301.xhp
-msgctxt ""
-"03020301.xhp\n"
-"par_id3147399\n"
-"help.text"
-msgid "Eof (intexpression As Integer)"
-msgstr "Eof (intexpression As Integer)"
-
#. 4WM7u
#: 03020301.xhp
msgctxt ""
@@ -10817,15 +10718,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. K5Bo8
-#: 03020302.xhp
-msgctxt ""
-"03020302.xhp\n"
-"par_id3150768\n"
-"help.text"
-msgid "Loc(FileNumber)"
-msgstr "Loc (FileNumber)"
-
#. 2TN73
#: 03020302.xhp
msgctxt ""
@@ -10835,15 +10727,6 @@ msgctxt ""
msgid "Return value:"
msgstr "<emph>傳回值類型</emph>:"
-#. bUFYD
-#: 03020302.xhp
-msgctxt ""
-"03020302.xhp\n"
-"par_id3152578\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. CN8kc
#: 03020302.xhp
msgctxt ""
@@ -10916,24 +10799,6 @@ msgctxt ""
msgid "Returns the size of an open file in bytes."
msgstr "傳回開啟檔案的大小,以位元組為單位。"
-#. 43MqD
-#: 03020303.xhp
-msgctxt ""
-"03020303.xhp\n"
-"par_id3150359\n"
-"help.text"
-msgid "Lof (FileNumber)"
-msgstr "Lof (FileNumber)"
-
-#. BwEgF
-#: 03020303.xhp
-msgctxt ""
-"03020303.xhp\n"
-"par_id3147230\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. BBamj
#: 03020303.xhp
msgctxt ""
@@ -11024,15 +10889,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. kDJUc
-#: 03020304.xhp
-msgctxt ""
-"03020304.xhp\n"
-"par_id3145365\n"
-"help.text"
-msgid "Seek (FileNumber)"
-msgstr "Seek(FileNumber)"
-
#. CPK2A
#: 03020304.xhp
msgctxt ""
@@ -11042,15 +10898,6 @@ msgctxt ""
msgid "Return value:"
msgstr "<emph>傳回值類型</emph>:"
-#. MWoFQ
-#: 03020304.xhp
-msgctxt ""
-"03020304.xhp\n"
-"par_id3159156\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. agXgn
#: 03020304.xhp
msgctxt ""
@@ -11132,15 +10979,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/Seek_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Seek Statement diagram</alt></image>"
msgstr ""
-#. PjcAp
-#: 03020305.xhp
-msgctxt ""
-"03020305.xhp\n"
-"par_id3145273\n"
-"help.text"
-msgid "Seek [#]filePos, {filePos|recordNum}"
-msgstr ""
-
#. vwzuK
#: 03020305.xhp
msgctxt ""
@@ -11816,15 +11654,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. LnQdV
-#: 03020406.xhp
-msgctxt ""
-"03020406.xhp\n"
-"par_id3146957\n"
-"help.text"
-msgid "FileCopy TextFrom As String, TextTo As String"
-msgstr "FileCopy TextFrom As String, TextTo As String"
-
#. CjRbT
#: 03020406.xhp
msgctxt ""
@@ -11915,15 +11744,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. CPCBG
-#: 03020407.xhp
-msgctxt ""
-"03020407.xhp\n"
-"par_id3154124\n"
-"help.text"
-msgid "FileDateTime (Text As String)"
-msgstr "FileDateTime (Text As String)"
-
#. meGd2
#: 03020407.xhp
msgctxt ""
@@ -12005,15 +11825,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. MoBSd
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3149656\n"
-"help.text"
-msgid "FileLen (Text As String)"
-msgstr "FileLen (Text As String)"
-
#. LVwBo
#: 03020408.xhp
msgctxt ""
@@ -12023,15 +11834,6 @@ msgctxt ""
msgid "Return value:"
msgstr "<emph>傳回值類型</emph>:"
-#. 7CmL7
-#: 03020408.xhp
-msgctxt ""
-"03020408.xhp\n"
-"par_id3156282\n"
-"help.text"
-msgid "Long"
-msgstr "Long"
-
#. H2KXW
#: 03020408.xhp
msgctxt ""
@@ -12113,15 +11915,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. 45fLv
-#: 03020409.xhp
-msgctxt ""
-"03020409.xhp\n"
-"par_id3150359\n"
-"help.text"
-msgid "GetAttr (Text As String)"
-msgstr "GetAttr (Text As String)"
-
#. mBMu7
#: 03020409.xhp
msgctxt ""
@@ -12608,15 +12401,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. AUhBt
-#: 03020412.xhp
-msgctxt ""
-"03020412.xhp\n"
-"par_id3153381\n"
-"help.text"
-msgid "Name OldName As String As NewName As String"
-msgstr "Name OldName As String As NewName As String"
-
#. 7AwQo
#: 03020412.xhp
msgctxt ""
@@ -12698,15 +12482,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/RmDir_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">RmDir Statement diagram</alt></image>"
msgstr ""
-#. uE7FC
-#: 03020413.xhp
-msgctxt ""
-"03020413.xhp\n"
-"par_id3154367\n"
-"help.text"
-msgid "RmDir Text As String"
-msgstr "RmDir Text As String"
-
#. 2mpBg
#: 03020413.xhp
msgctxt ""
@@ -12770,15 +12545,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. CrLq9
-#: 03020414.xhp
-msgctxt ""
-"03020414.xhp\n"
-"par_id3154365\n"
-"help.text"
-msgid "SetAttr FileName As String, Attribute As Integer"
-msgstr "SetAttr FileName As String, Attribute As Integer"
-
#. 7arWD
#: 03020414.xhp
msgctxt ""
@@ -12941,15 +12707,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. Tvkos
-#: 03020415.xhp
-msgctxt ""
-"03020415.xhp\n"
-"par_id3154685\n"
-"help.text"
-msgid "FileExists(FileName As String | DirectoryName As String)"
-msgstr "FileExists (FileName As String | DirectoryName As String)"
-
#. iTkt5
#: 03020415.xhp
msgctxt ""
@@ -13103,15 +12860,6 @@ msgctxt ""
msgid "Returns a <emph>Date</emph> value for a specified year, month, or day."
msgstr "傳回指定年、月或日的 <emph>Date</emph> 值。"
-#. 5G7kZ
-#: 03030101.xhp
-msgctxt ""
-"03030101.xhp\n"
-"par_id3149670\n"
-"help.text"
-msgid "DateSerial (year, month, day)"
-msgstr "DateSerial(year, month, day)"
-
#. xroUB
#: 03030101.xhp
msgctxt ""
@@ -14561,15 +14309,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. cPRUh
-#: 03030111.xhp
-msgctxt ""
-"03030111.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateToUnoDate(aDate)"
-msgstr ""
-
#. iGwfJ
#: 03030111.xhp
msgctxt ""
@@ -14660,15 +14399,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. snhBW
-#: 03030112.xhp
-msgctxt ""
-"03030112.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateFromUnoDate(aDate)"
-msgstr ""
-
#. B3CDo
#: 03030112.xhp
msgctxt ""
@@ -14759,15 +14489,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. ABYMv
-#: 03030113.xhp
-msgctxt ""
-"03030113.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateToUnoTime(aDate)"
-msgstr ""
-
#. N7qeB
#: 03030113.xhp
msgctxt ""
@@ -14858,15 +14579,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. EQoqi
-#: 03030114.xhp
-msgctxt ""
-"03030114.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateFromUnoTime(aTime)"
-msgstr ""
-
#. QreGF
#: 03030114.xhp
msgctxt ""
@@ -14957,15 +14669,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. TMAGP
-#: 03030115.xhp
-msgctxt ""
-"03030115.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateToUnoDateTime(aDate)"
-msgstr ""
-
#. 9vAhc
#: 03030115.xhp
msgctxt ""
@@ -15056,15 +14759,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. qhgq3
-#: 03030116.xhp
-msgctxt ""
-"03030116.xhp\n"
-"par_id3149497\n"
-"help.text"
-msgid "CDateFromUnoDateTime(aDateTime)"
-msgstr ""
-
#. kjYF8
#: 03030116.xhp
msgctxt ""
@@ -15146,15 +14840,6 @@ msgctxt ""
msgid "Returns the number of date or time intervals between two given date values."
msgstr ""
-#. AzmeS
-#: 03030120.xhp
-msgctxt ""
-"03030120.xhp\n"
-"par_idN10648\n"
-"help.text"
-msgid "DateDiff (interval As String, date1 As Date, date2 As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Double"
-msgstr ""
-
#. BPDH8
#: 03030120.xhp
msgctxt ""
@@ -15497,15 +15182,6 @@ msgctxt ""
msgid "The DatePart function returns a specified part of a date."
msgstr "DatePart 函式會傳回日期的指定部分。"
-#. GWMCJ
-#: 03030130.xhp
-msgctxt ""
-"03030130.xhp\n"
-"par_idN105E8\n"
-"help.text"
-msgid "DatePart (interval As String, date As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Long"
-msgstr ""
-
#. wi5B9
#: 03030130.xhp
msgctxt ""
@@ -15668,15 +15344,6 @@ msgctxt ""
msgid "This function is the opposite of the <emph>TimeSerial</emph> function. It returns an integer value that represents the hour from a time value that is generated by the <emph>TimeSerial</emph> or the <emph>TimeValue </emph>function. For example, the expression"
msgstr "此函式是 <emph>TimeSerial</emph> 函式的逆運算,依 <emph>TimeSerial</emph> 或 <emph>TimeValue</emph> 函式所產生的時間值傳回表示小時的整數值。例如,表示式"
-#. zCCqA
-#: 03030201.xhp
-msgctxt ""
-"03030201.xhp\n"
-"par_id3163798\n"
-"help.text"
-msgid "Print Hour(TimeSerial(12,30,41))"
-msgstr "Print Hour(TimeSerial(12,30,41))"
-
#. n3zH6
#: 03030201.xhp
msgctxt ""
@@ -15695,15 +15362,6 @@ msgctxt ""
msgid "Example:"
msgstr "<emph>示例:</emph>"
-#. iELda
-#: 03030201.xhp
-msgctxt ""
-"03030201.xhp\n"
-"par_id3146985\n"
-"help.text"
-msgid "Sub ExampleHour"
-msgstr "Sub ExampleHour"
-
#. qwk5P
#: 03030201.xhp
msgctxt ""
@@ -15812,15 +15470,6 @@ msgctxt ""
msgid "This function is the opposite of the <emph>TimeSerial </emph>function. It returns the minute of the serial time value that is generated by the <emph>TimeSerial</emph> or the <emph>TimeValue </emph>function. For example, the expression:"
msgstr "此函式是 <emph>TimeSerial</emph> 函式的逆運算,傳回由 <emph>TimeSerial</emph> 或 <emph>TimeValue</emph> 函式產生的順序時間值所對應的分鐘值。例如,表示式:"
-#. Gr7YY
-#: 03030202.xhp
-msgctxt ""
-"03030202.xhp\n"
-"par_id3149262\n"
-"help.text"
-msgid "Print Minute(TimeSerial(12,30,41))"
-msgstr "Print Minute(TimeSerial(12,30,41))"
-
#. 6ZmVp
#: 03030202.xhp
msgctxt ""
@@ -15839,15 +15488,6 @@ msgctxt ""
msgid "Example:"
msgstr "<emph>示例:</emph>"
-#. NEseB
-#: 03030202.xhp
-msgctxt ""
-"03030202.xhp\n"
-"par_id3159154\n"
-"help.text"
-msgid "Sub ExampleMinute"
-msgstr "Sub ExampleMinute"
-
#. uxFus
#: 03030202.xhp
msgctxt ""
@@ -16028,15 +15668,6 @@ msgctxt ""
msgid "This function is the opposite of the <emph>TimeSerial </emph>function. It returns the seconds of a serial time value that is generated by the <emph>TimeSerial</emph> or <emph>TimeValue </emph>functions. For example, the expression:"
msgstr "此函式是 <emph>TimeSerial</emph> 函式的逆運算,傳回由 <emph>TimeSerial</emph> 或 <emph>TimeValue</emph> 函式產生的順序時間值所對應的秒值。例如,表示式:"
-#. Tjkza
-#: 03030204.xhp
-msgctxt ""
-"03030204.xhp\n"
-"par_id3153951\n"
-"help.text"
-msgid "Print Second(TimeSerial(12,30,41))"
-msgstr "Print Second(TimeSerial(12,30,41))"
-
#. AMELh
#: 03030204.xhp
msgctxt ""
@@ -16109,15 +15740,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. rBHrY
-#: 03030205.xhp
-msgctxt ""
-"03030205.xhp\n"
-"par_id3150792\n"
-"help.text"
-msgid "TimeSerial (hour, minute, second)"
-msgstr "TimeSerial(hour, minute, second)"
-
#. mCg7g
#: 03030205.xhp
msgctxt ""
@@ -16316,15 +15938,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. WPuDv
-#: 03030206.xhp
-msgctxt ""
-"03030206.xhp\n"
-"par_id3156282\n"
-"help.text"
-msgid "TimeValue (Text As String)"
-msgstr "TimeValue(Text As String)"
-
#. NQV5A
#: 03030206.xhp
msgctxt ""
@@ -17585,15 +17198,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/sbasic/On-Error_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">On Error Statement diagram</alt></image>"
msgstr ""
-#. CKJJr
-#: 03050500.xhp
-msgctxt ""
-"03050500.xhp\n"
-"par_id3145173\n"
-"help.text"
-msgid "On [Local] Error {GoTo Labelname | GoTo 0 | Resume Next}"
-msgstr ""
-
#. CmqUN
#: 03050500.xhp
msgctxt ""
@@ -17738,15 +17342,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. jairQ
-#: 03060100.xhp
-msgctxt ""
-"03060100.xhp\n"
-"par_id3156344\n"
-"help.text"
-msgid "Result = Expression1 And Expression2"
-msgstr "Result = Expression1 And Expression2"
-
#. Nfu49
#: 03060100.xhp
msgctxt ""
@@ -17900,15 +17495,6 @@ msgctxt ""
msgid "Syntax:"
msgstr "<emph>語法</emph>:"
-#. m9bM6
-#: 03060200.xhp
-msgctxt ""
-"03060200.xhp\n"
-"par_id3154910\n"
-"help.text"
-msgid "Result = Expression1 Eqv Expression2"
-msgstr "Result = Expression1 Eqv Expression2"
-
#. 7fkPv
#: 03060200.xhp
msgctxt ""
@@ -19727,22 +19313,22 @@ msgctxt ""
msgid "To convert degrees to radians, multiply degrees by <literal>Pi</literal>/180, and to convert radians to degrees, multiply radians by 180/<literal>Pi</literal>."
msgstr ""
-#. CCzJK
+#. yescR
#: 03080103.xhp
msgctxt ""
"03080103.xhp\n"
"par_id3149664\n"
"help.text"
-msgid "grad=(radiant*180)/<literal>Pi</literal>"
+msgid "degrees=(radians*180)/<literal>Pi</literal>"
msgstr ""
-#. EED9X
+#. PZTcG
#: 03080103.xhp
msgctxt ""
"03080103.xhp\n"
"par_id3153143\n"
"help.text"
-msgid "radiant=(grad*<literal>Pi</literal>)/180"
+msgid "radians=(degrees*<literal>Pi</literal>)/180"
msgstr ""
#. EFgfE
@@ -19898,22 +19484,22 @@ msgctxt ""
msgid "To convert degrees to radians, multiply by <literal>Pi</literal>/180. To convert radians to degrees, multiply by 180/<literal>Pi</literal>."
msgstr ""
-#. L5KFp
+#. bAYDk
#: 03080104.xhp
msgctxt ""
"03080104.xhp\n"
"par_id3155414\n"
"help.text"
-msgid "degrees=(radiant*180)/<literal>Pi</literal>"
+msgid "degrees=(radians*180)/<literal>Pi</literal>"
msgstr ""
-#. AdvXG
+#. hDLbM
#: 03080104.xhp
msgctxt ""
"03080104.xhp\n"
"par_id3146975\n"
"help.text"
-msgid "radiant=(degrees*<literal>Pi</literal>)/180"
+msgid "radians=(degrees*<literal>Pi</literal>)/180"
msgstr ""
#. AEqBK
@@ -25505,13 +25091,49 @@ msgctxt ""
msgid "If the argument is a number, it is used as numeric value of the expression."
msgstr ""
-#. RD4KV
+#. UnfBB
#: 03100500.xhp
msgctxt ""
"03100500.xhp\n"
"par_id3159416\n"
"help.text"
-msgid "If the argument is string, the function trims the leading whitespace; then it tries to recognize a number in following characters. These syntaxes are recognized: decimal numbers (with optional leading sign) using decimal and group separators of locale configured in $[officename] (group separators are accepted in any position), with optional exponential notation like \"-12e+1\" (where an optionally signed whole decimal number after e or E or d or D defines power of 10); octal numbers like \"&Onnn...\", where \"nnn...\" after \"&O\" or \"&o\" is sequence of characters up to the next non-alphanumeric character, and must be no longer than 11 digits from 0 to 7; hexadecimal numbers like \"&Hnnn...\", where \"nnn...\" after \"&H\" or \"&h\" is sequence of characters up to the next non-alphanumeric character, and must be no longer than 8 digits from 0 to 9, A to F, or a to f. The rest of the string is ignored. If the string is not recognized, e.g. when after trimming leading whitespace it doesn't start with plus, minus, a decimal digit, or \"&\", or when the sequence after \"&O\" is longer than 11 characters or contains an alphabetic character, the numeric value of expression is 0."
+msgid "If the argument is string, the function trims the leading white space; then it tries to recognize a number in following characters. The syntax below are recognized:"
+msgstr ""
+
+#. kj6xg
+#: 03100500.xhp
+msgctxt ""
+"03100500.xhp\n"
+"par_id811638383475418\n"
+"help.text"
+msgid "Decimal numbers (with optional leading sign) using decimal and group separators of locale configured in $[officename] (group separators are accepted in any position), with optional exponential notation like \"-12e+1\" (where an optionally signed whole decimal number after e or E or d or D defines power of 10);"
+msgstr ""
+
+#. GZWV7
+#: 03100500.xhp
+msgctxt ""
+"03100500.xhp\n"
+"par_id361638383494362\n"
+"help.text"
+msgid "Octal numbers like \"&Onnn...\", where \"nnn...\" after \"&O\" or \"&o\" is sequence no longer than 11 digits, from 0 to 7, up to the next non-alphanumeric character;"
+msgstr ""
+
+#. GUVCt
+#: 03100500.xhp
+msgctxt ""
+"03100500.xhp\n"
+"par_id91638383518862\n"
+"help.text"
+msgid "Hexadecimal numbers like \"&Hnnn...\", where \"nnn...\" after \"&H\" or \"&h\" is sequence of characters up to the next non-alphanumeric character, and must be no longer than 8 digits, from 0 to 9, A to F, or a to f."
+msgstr ""
+
+#. ypDkR
+#: 03100500.xhp
+msgctxt ""
+"03100500.xhp\n"
+"par_id61638383582794\n"
+"help.text"
+msgid "The rest of the string is ignored. If the string is not recognized, e.g. when after trimming leading whitespace it doesn't start with plus, minus, a decimal digit, or \"&\", or when the sequence after \"&O\" is longer than 11 characters or contains an alphabetic character, the numeric value of expression is 0."
msgstr ""
#. ioj8X
@@ -30194,15 +29816,6 @@ msgctxt ""
msgid "Asc(string) As Long"
msgstr ""
-#. s239Q
-#: 03120101.xhp
-msgctxt ""
-"03120101.xhp\n"
-"par_id3150669\n"
-"help.text"
-msgid "Long"
-msgstr ""
-
#. DZtGt
#: 03120101.xhp
msgctxt ""
@@ -30293,15 +29906,6 @@ msgctxt ""
msgid "Chr[$](expression As Integer) As String"
msgstr ""
-#. HnFyY
-#: 03120102.xhp
-msgctxt ""
-"03120102.xhp\n"
-"par_id3153824\n"
-"help.text"
-msgid "String"
-msgstr "字串型"
-
#. 4nv5b
#: 03120102.xhp
msgctxt ""
@@ -30707,15 +30311,6 @@ msgctxt ""
msgid "Returns the Unicode value of the first character in a string expression."
msgstr ""
-#. re4di
-#: 03120111.xhp
-msgctxt ""
-"03120111.xhp\n"
-"par_id3150669\n"
-"help.text"
-msgid "Long"
-msgstr ""
-
#. sEFFg
#: 03120111.xhp
msgctxt ""
@@ -42641,24 +42236,6 @@ msgctxt ""
msgid "Converts <emph>Text</emph> characters to Unicode characters using the default code page of the system."
msgstr ""
-#. EhJtA
-#: strconv.xhp
-msgctxt ""
-"strconv.xhp\n"
-"par_id901622764984846\n"
-"help.text"
-msgid "vbFromUnicode"
-msgstr ""
-
-#. mn5xD
-#: strconv.xhp
-msgctxt ""
-"strconv.xhp\n"
-"par_id281622764984846\n"
-"help.text"
-msgid "128"
-msgstr ""
-
#. 4VdbE
#: strconv.xhp
msgctxt ""
@@ -42713,6 +42290,24 @@ msgctxt ""
msgid "REM Converts Katakana characters in string to Hiragana characters"
msgstr ""
+#. 9sG37
+#: strconv.xhp
+msgctxt ""
+"strconv.xhp\n"
+"par_id861622770508875\n"
+"help.text"
+msgid "REM Assumes CP-1252 encoding associated with en-US locale used in unit tests."
+msgstr ""
+
+#. gcaG4
+#: strconv.xhp
+msgctxt ""
+"strconv.xhp\n"
+"par_id841622770962002\n"
+"help.text"
+msgid "Print UBound(x) ' 8 characters"
+msgstr ""
+
#. 4wc9E
#: thisdbdoc.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po b/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
index 57800a767ae..349f6072d3d 100644
--- a/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.po
+++ b/source/zh-TW/helpcontent2/source/text/sbasic/shared/03.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-11-25 19:33+0100\n"
+"POT-Creation-Date: 2021-12-20 13:20+0100\n"
"PO-Revision-Date: 2018-07-12 14:38+0000\n"
"Last-Translator: Anonymous Pootle User\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -2761,13 +2761,13 @@ msgctxt ""
msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
msgstr ""
-#. FX6mM
+#. UxDTL
#: sf_base.xhp
msgctxt ""
"sf_base.xhp\n"
"par_id141635436912146\n"
"help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
msgstr ""
#. gDM4C
@@ -2833,13 +2833,13 @@ msgctxt ""
msgid "Typical example:"
msgstr ""
-#. yrYgm
+#. fBDsN
#: sf_basic.xhp
msgctxt ""
"sf_basic.xhp\n"
"pyc_id971618493778666\n"
"help.text"
-msgid "svc.MsgBox('This has to be displayed in a message box')"
+msgid "bas.MsgBox('Display this text in a message box from a Python script')"
msgstr ""
#. kGyCd
@@ -3706,22 +3706,22 @@ msgctxt ""
msgid "The <literal>SFDocuments</literal> shared library provides a number of methods and properties to facilitate the management and handling of %PRODUCTNAME documents."
msgstr ""
-#. r34Cu
+#. CBPyB
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id351591014177269\n"
"help.text"
-msgid "Some methods are generic for all types of documents and are inherited from the <literal>SF_Document</literal> module, whereas other methods that are specific for Calc documents are defined in the <literal>SF_Calc</literal> module."
+msgid "The <literal>SFDocuments.Calc</literal> service is a subclass of the <link href=\"text/sbasic/shared/03/sf_document.xhp\" name=\"SF_Document_link\"><literal>SFDocuments.Document</literal></link> service. All methods and properties defined for the <literal>Document</literal> service can also be accessed using a <literal>Calc</literal> service instance."
msgstr ""
-#. kTVJM
+#. 4uAEX
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id591589189364267\n"
"help.text"
-msgid "The <literal>SF_Calc</literal> module is focused on:"
+msgid "The <literal>Calc</literal> service is focused on:"
msgstr ""
#. Gy8dD
@@ -3751,6 +3751,15 @@ msgctxt ""
msgid "Copying and importing massive amounts of data"
msgstr ""
+#. UFCyZ
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id851638217526844\n"
+"help.text"
+msgid "This help page describes methods and properties that are applicable only to Calc documents."
+msgstr ""
+
#. A47hJ
#: sf_calc.xhp
msgctxt ""
@@ -4165,13 +4174,13 @@ msgctxt ""
msgid "Argument"
msgstr ""
-#. GkAHr
+#. H9m2q
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id31582885195238\n"
"help.text"
-msgid "Type"
+msgid "Return type"
msgstr ""
#. DDSFu
@@ -4210,13 +4219,94 @@ msgctxt ""
msgid "String or array of strings"
msgstr ""
-#. KUB6n
+#. kAAXc
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id85159240716560\n"
"help.text"
-msgid "The single selected range as a string or the list of selected ranges as an array"
+msgid "The single selected range as a string or the list of selected ranges as an array."
+msgstr ""
+
+#. PFB5D
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407165606\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. 5GeyC
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165545\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. TBHV2
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716828\n"
+"help.text"
+msgid "Returns the first used cell in a given range or sheet."
+msgstr ""
+
+#. BkCoD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407166642\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. ToQBc
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165145\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. boSak
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716225\n"
+"help.text"
+msgid "Returns the leftmost column number in a given range or sheet."
+msgstr ""
+
+#. 3AKqL
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301592407167972\n"
+"help.text"
+msgid "Yes"
+msgstr ""
+
+#. zf3hK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id81592407165695\n"
+"help.text"
+msgid "SheetName or RangeName as String"
+msgstr ""
+
+#. BXscD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id85159240716128\n"
+"help.text"
+msgid "Returns the topmost row number in a given range or sheet."
msgstr ""
#. BHFeu
@@ -4237,13 +4327,13 @@ msgctxt ""
msgid "RangeName As String"
msgstr ""
-#. R8spm
+#. FhLMF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id311593094953330\n"
"help.text"
-msgid "The number of rows (>= 1) in the given range"
+msgid "The number of rows (>= 1) in the given range."
msgstr ""
#. cU3Ah
@@ -4255,22 +4345,22 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. 4bY5E
+#. ALJCP
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id501591018870619\n"
"help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
msgstr ""
-#. XTyXP
+#. SNj7Q
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id881582885195976\n"
"help.text"
-msgid "The last used cell in 'A1' format in the given sheet"
+msgid "Returns the last used cell in a given range or sheet."
msgstr ""
#. 75PEK
@@ -4282,22 +4372,22 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. Cu5Dr
+#. 3h43j
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id831592315106202\n"
"help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
msgstr ""
-#. ZZuih
+#. bU5vD
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id791592315106790\n"
"help.text"
-msgid "The last used column in the given sheet"
+msgid "The last used column in a given range or sheet."
msgstr ""
#. q9Bx7
@@ -4309,22 +4399,22 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. hn9su
+#. r6diM
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id81591025591696\n"
"help.text"
-msgid "SheetName As String"
+msgid "SheetName or RangeName as String"
msgstr ""
-#. NGNDP
+#. SDdEC
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id421591025591509\n"
"help.text"
-msgid "The last used row in the given sheet"
+msgid "The last used row in a given range or sheet."
msgstr ""
#. 4t3He
@@ -4345,13 +4435,13 @@ msgctxt ""
msgid "RangeName As String"
msgstr ""
-#. DSHss
+#. 2tmEj
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id571591025591367\n"
"help.text"
-msgid "A range reference that can be used as argument of methods like <literal>CopyToRange</literal>"
+msgid "A range reference that can be used as argument of methods like <literal>CopyToRange</literal>."
msgstr ""
#. boDiE
@@ -4372,13 +4462,13 @@ msgctxt ""
msgid "RangeName As String"
msgstr ""
-#. kdjWP
+#. ey2LS
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id571591025599937\n"
"help.text"
-msgid "Returns the address of the smallest area that contains the specified range so that the area is surrounded by empty cells or sheet edges. This is equivalent to applying the <keycode>Ctrl + *</keycode> shortcut to the given range."
+msgid "Returns the address of the smallest area that contains the specified range so that the area is surrounded by empty cells or sheet edges. This is equivalent to applying the <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command + *</keycode></caseinline><defaultinline><keycode>Ctrl + *</keycode></defaultinline></switchinline> shortcut to the given range."
msgstr ""
#. 66iAb
@@ -4399,13 +4489,13 @@ msgctxt ""
msgid "SheetName As String"
msgstr ""
-#. JQ3xT
+#. 4KoAw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id731591025591753\n"
"help.text"
-msgid "A sheet reference that can be used as argument of methods like <literal>CopySheet</literal>"
+msgid "A sheet reference that can be used as argument of methods like <literal>CopySheet</literal>."
msgstr ""
#. HLpEQ
@@ -4435,13 +4525,13 @@ msgctxt ""
msgid "Array of strings"
msgstr ""
-#. dpUQH
+#. qGsms
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id491591025591370\n"
"help.text"
-msgid "The list with the names of all existing sheets"
+msgid "The list with the names of all existing sheets."
msgstr ""
#. EaAB2
@@ -4462,13 +4552,13 @@ msgctxt ""
msgid "RangeName As String"
msgstr ""
-#. 2qreU
+#. BKFhE
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id681593095062358\n"
"help.text"
-msgid "The number of columns (>= 1) in the given range"
+msgid "The number of columns (>= 1) in the given range."
msgstr ""
#. cju3B
@@ -4489,22 +4579,13 @@ msgctxt ""
msgid "RangeName As String"
msgstr ""
-#. s6c4j
+#. VaGpB
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321592315404430\n"
"help.text"
-msgid "A <literal>com.sun.star.Table.XCellRange</literal> UNO object"
-msgstr ""
-
-#. DFirg
-#: sf_calc.xhp
-msgctxt ""
-"sf_calc.xhp\n"
-"par_id961592315565332\n"
-"help.text"
-msgid "XSheetCellCursor"
+msgid "A <literal>com.sun.star.Table.XCellRange</literal> UNO object."
msgstr ""
#. nAD2d
@@ -4552,22 +4633,22 @@ msgctxt ""
msgid "SheetName As String"
msgstr ""
-#. 8eX6C
+#. cJAB7
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id41592315560095\n"
"help.text"
-msgid "A <literal>com.sun.star.sheet.XSpreadsheet</literal> UNO object"
+msgid "A <literal>com.sun.star.sheet.XSpreadsheet</literal> UNO object."
msgstr ""
-#. r9Fpc
+#. hwjGf
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id321611613059105\n"
"help.text"
-msgid "Visit LibreOffice API Documentation's website to learn more about <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html\" name=\"XCellRange API\">XCellRange</link>, <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSheetCellCursor.html\" name=\"XSheetCellCursor API\">XSheetCellCursor</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSpreadsheet.html\" name=\"XSpreadsheet API\">XSpreadsheet</link> UNO objects."
+msgid "Visit %PRODUCTNAME API Documentation's website to learn more about <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1table_1_1XCellRange.html\" name=\"XCellRange API\">XCellRange</link>, <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSheetCellCursor.html\" name=\"XSheetCellCursor API\">XSheetCellCursor</link> and <link href=\"https://api.libreoffice.org/docs/idl/ref/interfacecom_1_1sun_1_1star_1_1sheet_1_1XSpreadsheet.html\" name=\"XSpreadsheet API\">XSpreadsheet</link> UNO objects."
msgstr ""
#. V5dF8
@@ -4687,13 +4768,13 @@ msgctxt ""
msgid "Activating a sheet makes sense only if it is performed on a Calc document. To make sure you have a Calc document at hand you can use the <literal>isCalc</literal> property of the document object, which returns <literal>True</literal> if it is a Calc document and <literal>False</literal> otherwise."
msgstr ""
-#. 2EffV
+#. KWFFF
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id93158919969856\n"
"help.text"
-msgid "Returns either the list with the names of all chart objects in a given sheet or a single chart service instance."
+msgid "Returns either the list with the names of all chart objects in a given sheet or a single <literal>Chart</literal> service instance."
msgstr ""
#. sBNho
@@ -4732,13 +4813,13 @@ msgctxt ""
msgid "<emph>chartname</emph>: The user-defined name of the chart object to be returned. If the chart does not have a user-defined name, then the internal object name can be used. If this argument is absent, then the list of chart names in the specified sheet is returned."
msgstr ""
-#. Bdgw9
+#. C7CSH
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id431635438771588\n"
"help.text"
-msgid "Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category."
+msgid "Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category."
msgstr ""
#. zbX9R
@@ -5785,13 +5866,202 @@ msgctxt ""
msgid "'SheetX.$C$3:$H$7 (A1 offset by two rows and columns with width of 5 rows and 6 columns)"
msgstr ""
-#. bNqfB
+#. GwPQh
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id51592233506021\n"
+"help.text"
+msgid "Opens a non-modal dialog that can be used to select a range in the document and returns a string containing the selected range."
+msgstr ""
+
+#. CWn2A
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id301637936295380\n"
+"help.text"
+msgid "This method opens the same dialog that is used by %PRODUCTNAME when the Shrink button is pressed. For example, the <menuitem>Tools - Goal Seek</menuitem> dialog has a Shrink button to the right of the <menuitem>Formula cell</menuitem> field."
+msgstr ""
+
+#. XUoah
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551637936545121\n"
+"help.text"
+msgid "This method does not change the current selection."
+msgstr ""
+
+#. tAHiV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id901592233506001\n"
+"help.text"
+msgid "<emph>title</emph>: The title of the dialog, as a string."
+msgstr ""
+
+#. Yyn74
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id781592234124502\n"
+"help.text"
+msgid "<emph>selection</emph>: An optional range that is initially selected when the dialog is displayed."
+msgstr ""
+
+#. zo7VK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id971592234138989\n"
+"help.text"
+msgid "<emph>singlecell</emph>: When <literal>True</literal> (default) only single-cell selection is allowed. When <literal>False</literal> range selection is allowed."
+msgstr ""
+
+#. SqEWv
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id321592234150345\n"
+"help.text"
+msgid "<emph>closeafterselect</emph>: When <literal>True</literal> (default) the dialog is closed immediately after the selection is made. When <literal>False</literal> the user can change the selection as many times as needed and then manually close the dialog."
+msgstr ""
+
+#. yDiCm
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id51592233503441\n"
+"help.text"
+msgid "Returns the input string after substituting its token characters by their values in a given range."
+msgstr ""
+
+#. Qu4DK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551637936596521\n"
+"help.text"
+msgid "This method does not change the current selection."
+msgstr ""
+
+#. eEqCY
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id171637938442558\n"
+"help.text"
+msgid "This method can be used to quickly extract specific parts of a range name, such as the sheet name or first cell column and row, and use them to compose a new range address."
+msgstr ""
+
+#. RAAVz
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id901592233506232\n"
+"help.text"
+msgid "<emph>inputstr</emph>: The string containing the tokens that will be replaced by the corresponding values in <literal>range</literal>."
+msgstr ""
+
+#. NJdUy
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id781592234161102\n"
+"help.text"
+msgid "<emph>range</emph>: A <literal>RangeName</literal> from which values will be extracted. If it contains a sheet name, the sheet must exist."
+msgstr ""
+
+#. BgCCD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id971592234102889\n"
+"help.text"
+msgid "<emph>tokencharacter</emph>: Character used to identify tokens. By default \"%\" is the token character. The following tokens are accepted:"
+msgstr ""
+
+#. WTDwR
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id261637943912156\n"
+"help.text"
+msgid "<emph>%S</emph> - The sheet name containing the range, including single quotes when necessary."
+msgstr ""
+
+#. YHLeU
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id441637943912380\n"
+"help.text"
+msgid "<emph>%R1</emph> - The row number of the top left cell of the range."
+msgstr ""
+
+#. joJi7
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id521637943912620\n"
+"help.text"
+msgid "<emph>%C1</emph> - The column letter of the top left cell of the range."
+msgstr ""
+
+#. YAfmV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id371637943912860\n"
+"help.text"
+msgid "<emph>%R2</emph> - The row number of the bottom right cell of the range."
+msgstr ""
+
+#. imuBD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id291637943913116\n"
+"help.text"
+msgid "<emph>%C2</emph> - The column letter of the bottom right cell of the range."
+msgstr ""
+
+#. gpmpG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941637943467476\n"
+"help.text"
+msgid "The example below extracts each element of the <literal>RangeName</literal> defined in <literal>sRange</literal> and uses them to compose a message."
+msgstr ""
+
+#. nbJ59
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id241637944350648\n"
+"help.text"
+msgid "The <literal>Printf</literal> method can be combined with <literal>SetFormula</literal> to create formulas over multiple cells. For instance, consider a table with numeric values in the range \"A1:E10\" from which formulas are to be created to sum the values in each row and place the results in the range \"F1:F10\":"
+msgstr ""
+
+#. foAvd
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id371637944971921\n"
+"help.text"
+msgid "' Note the use of the \"$\" character"
+msgstr ""
+
+#. wBpRw
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id156589200121138\n"
"help.text"
-msgid "This method sends the content of the given sheet to a default printer or a printer defined by the <literal>SetPrinter()</literal> method of the <literal>Document</literal> Service."
+msgid "This method sends the contents of the given sheet to the default printer or to the printer defined by the <literal>SetPrinter</literal> method of the <literal>Document</literal> service."
msgstr ""
#. BaDL9
@@ -5821,13 +6091,13 @@ msgctxt ""
msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
msgstr ""
-#. i2Rtx
+#. DBFDA
#: sf_calc.xhp
msgctxt ""
"sf_calc.xhp\n"
"par_id141635436912146\n"
"help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
msgstr ""
#. C8abL
@@ -6181,6 +6451,357 @@ msgctxt ""
msgid "'D2 contains the formula \"=H2\""
msgstr ""
+#. gF7Gb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880373070\n"
+"help.text"
+msgid "Moves a given range of cells downwards by inserting empty rows. The current selection is not affected."
+msgstr ""
+
+#. VTxxB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929435655\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholerows</literal> argument the inserted rows can either span the width of the specified range or span all columns in the row."
+msgstr ""
+
+#. uvH4j
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880370247\n"
+"help.text"
+msgid "This method returns a string representing the new location of the initial range."
+msgstr ""
+
+#. cvqws
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id811637929284110\n"
+"help.text"
+msgid "If the shifted range exceeds the sheet edges, then nothing happens."
+msgstr ""
+
+#. bUdZp
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376123\n"
+"help.text"
+msgid "<emph>range</emph>: The range above which rows will be inserted, as a string."
+msgstr ""
+
+#. fVYpB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880376566\n"
+"help.text"
+msgid "<emph>wholerow</emph>: If set to <literal>False</literal> (default), then the width of the inserted rows will be the same as the width of the specified <literal>range</literal>. Otherwise, the inserted row will span all columns in the sheet."
+msgstr ""
+
+#. rXzZX
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373045\n"
+"help.text"
+msgid "<emph>rows</emph>: The number of rows to be inserted. The default value is the height of the original <literal>range</literal>. The number of rows must be a positive number."
+msgstr ""
+
+#. dacHK
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931053547\n"
+"help.text"
+msgid "' Moves the range \"A3:D3\" down by one row; affects only columns A to D"
+msgstr ""
+
+#. v4w3P
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232893\n"
+"help.text"
+msgid "' The inserted row spans all columns in the sheet"
+msgstr ""
+
+#. vsryg
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931053897\n"
+"help.text"
+msgid "' Moves the range \"A3:D3\" down by five rows"
+msgstr ""
+
+#. pwuUG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id501638218784265\n"
+"help.text"
+msgid "' Moves the range \"A3:D10\" down by two rows and shows the new location of the original range"
+msgstr ""
+
+#. hVfv3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880376255\n"
+"help.text"
+msgid "Deletes the leftmost columns of a given range and moves to the left all cells to the right of the affected range. The current selection is not affected."
+msgstr ""
+
+#. iawBn
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929460261\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholecolumns</literal> argument the deleted columns can either span the height of the specified range or span all rows in the column."
+msgstr ""
+
+#. BXEkG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880371259\n"
+"help.text"
+msgid "This method returns a string representing the location of the remaining portion of the initial range. If all cells in the original range have been deleted, then an empty string is returned."
+msgstr ""
+
+#. CyRpL
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376205\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which cells will be deleted, as a string."
+msgstr ""
+
+#. zWG3Y
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880356026\n"
+"help.text"
+msgid "<emph>wholecolumn</emph>: If set to <literal>False</literal> (default), then the height of the deleted columns will be the same as the height of the specified <literal>range</literal>. Otherwise, the deleted columns will span all rows in the sheet."
+msgstr ""
+
+#. JLdBr
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373306\n"
+"help.text"
+msgid "<emph>columns</emph>: The number of columns to be deleted from the specified <literal>range</literal>. The default value is the width of the original <literal>range</literal>, which is also the maximum value of this argument."
+msgstr ""
+
+#. 8UycD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931064919\n"
+"help.text"
+msgid "' Deletes the range \"B3:B6\"; moves left all cells to the right"
+msgstr ""
+
+#. vM8hB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931056991\n"
+"help.text"
+msgid "' Deletes the first column in the range \"A3:D6\""
+msgstr ""
+
+#. FPVSg
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232569\n"
+"help.text"
+msgid "' The deleted columns (A to D) spans all rows in the sheet"
+msgstr ""
+
+#. TAB2b
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880373529\n"
+"help.text"
+msgid "Deletes the topmost rows of a given range and moves upwards all cells below the affected range. The current selection is not affected."
+msgstr ""
+
+#. kb5h3
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929435361\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholerows</literal> argument the deleted rows can either span the width of the specified range or span all columns in the row."
+msgstr ""
+
+#. s9Nfb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880370299\n"
+"help.text"
+msgid "This method returns a string representing the location of the remaining portion of the initial range. If all cells in the original range have been deleted, then an empty string is returned."
+msgstr ""
+
+#. H5EtV
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880376583\n"
+"help.text"
+msgid "<emph>range</emph>: The range from which cells will be deleted, as a string."
+msgstr ""
+
+#. JQtGb
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880300966\n"
+"help.text"
+msgid "<emph>wholerow</emph>: If set to <literal>False</literal> (default), then the width of the deleted rows will be the same as the width of the specified <literal>range</literal>. Otherwise, the deleted row will span all columns in the sheet."
+msgstr ""
+
+#. ueo8E
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id551593880373265\n"
+"help.text"
+msgid "<emph>rows</emph>: The number of rows to be deleted from the specified <literal>range</literal>. The default value is the height of the original <literal>range</literal>, which is also the maximum value of this argument."
+msgstr ""
+
+#. jHP9x
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931064667\n"
+"help.text"
+msgid "' Deletes the range \"A3:D3\"; moves all cells below it by one row up"
+msgstr ""
+
+#. Make5
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931056647\n"
+"help.text"
+msgid "' Deletes the first row in the range \"A3:D6\""
+msgstr ""
+
+#. APQKA
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232493\n"
+"help.text"
+msgid "' The deleted rows spans all columns in the sheet"
+msgstr ""
+
+#. gKkbB
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id481593880372568\n"
+"help.text"
+msgid "Moves a given range of cells to the right by inserting empty columns. The current selection is not affected."
+msgstr ""
+
+#. RxvcF
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id801637929335255\n"
+"help.text"
+msgid "Depending on the value of the <literal>wholecolumns</literal> argument the inserted columns can either span the height of the specified range or span all rows in the column."
+msgstr ""
+
+#. Fh33o
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id711593880372560\n"
+"help.text"
+msgid "This method returns a string representing the new location of the initial range."
+msgstr ""
+
+#. pLAHD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id811637929283210\n"
+"help.text"
+msgid "If the shifted range exceeds the sheet edges, then nothing happens."
+msgstr ""
+
+#. SeAGD
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id891593880370543\n"
+"help.text"
+msgid "<emph>range</emph>: The range which will have empty columns inserted to its left, as a string."
+msgstr ""
+
+#. KtD6Y
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id941593880373316\n"
+"help.text"
+msgid "<emph>wholecolumn</emph>: If set to <literal>False</literal> (default), then the height of the inserted columns will be the same as the height of the specified <literal>range</literal>. Otherwise, the inserted columns will span all rows in the sheet."
+msgstr ""
+
+#. fBzCG
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"par_id5515938803791960\n"
+"help.text"
+msgid "<emph>columns</emph>: The number of columns to be inserted. The default value is the width of the original <literal>range</literal>."
+msgstr ""
+
+#. nmXTU
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id881637931052587\n"
+"help.text"
+msgid "' Moves the range \"A3:A6\" right by one column; affects only rows 3 to 6"
+msgstr ""
+
+#. 5mWBq
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id291637931053225\n"
+"help.text"
+msgid "' Moves the range \"A3:A6\" right by five columns"
+msgstr ""
+
+#. G53xT
+#: sf_calc.xhp
+msgctxt ""
+"sf_calc.xhp\n"
+"bas_id661637931232548\n"
+"help.text"
+msgid "' The inserted column spans all rows in the sheet"
+msgstr ""
+
#. FrC59
#: sf_calc.xhp
msgctxt ""
@@ -6523,13 +7144,13 @@ msgctxt ""
msgid "Specifies if the chart is displayed with 3D elements. If the value is a string, it must be either \"Bar\", \"Cylinder\", \"Cone\" or \"Pyramid\"."
msgstr ""
-#. aT4GF
+#. HgqhX
#: sf_chart.xhp
msgctxt ""
"sf_chart.xhp\n"
"par_id541600788076141\n"
"help.text"
-msgid "If the boolean <literal>True</literal> value is specified, than the chart is displayed using 3D bars."
+msgid "If the boolean <literal>True</literal> value is specified, then the chart is displayed using 3D bars."
msgstr ""
#. vDs4z
@@ -6559,15 +7180,6 @@ msgctxt ""
msgid "No"
msgstr ""
-#. FVExu
-#: sf_chart.xhp
-msgctxt ""
-"sf_chart.xhp\n"
-"par_id201633021748455\n"
-"help.text"
-msgid "Boolean"
-msgstr ""
-
#. AaBHr
#: sf_chart.xhp
msgctxt ""
@@ -8521,6 +9133,60 @@ msgctxt ""
msgid "This Python code displays <literal>DlgConvert</literal> modal dialog from <literal>Euro</literal> shared Basic library."
msgstr ""
+#. HU6Jv
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id21598187900349\n"
+"help.text"
+msgid "Replaces all fixed text strings in a dialog by their translated versions based on a <literal>L10N</literal> service instance. This method translates the following strings:"
+msgstr ""
+
+#. JixXU
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id641625855723650\n"
+"help.text"
+msgid "The method returns <literal>True</literal> if successful."
+msgstr ""
+
+#. v5Zt5
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id61637871260604\n"
+"help.text"
+msgid "To create a list of translatable strings in a dialog use the <link href=\"text/sbasic/shared/03/sf_l10n.xhp#AddTextsFromDialog\" name=\"AddTextsFromDialog\">AddTextsFromDialog</link> method from the L10N service."
+msgstr ""
+
+#. ECNVg
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id451598185776205\n"
+"help.text"
+msgid "<emph>l10n</emph>: A <literal>L10N</literal> service instance from which translated strings will be retrieved."
+msgstr ""
+
+#. MeJAT
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id951620300689850\n"
+"help.text"
+msgid "The following example loads translated strings and applies them to the dialog \"MyDialog\"."
+msgstr ""
+
+#. p3KMX
+#: sf_dialog.xhp
+msgctxt ""
+"sf_dialog.xhp\n"
+"par_id901637872163895\n"
+"help.text"
+msgid "Read the <link href=\"text/sbasic/shared/03/sf_l10n.xhp\" name=\"L10N\">L10N service</link> help page to learn more about how PO and POT files are handled."
+msgstr ""
+
#. ARCGg
#: sf_dialog.xhp
msgctxt ""
@@ -8953,13 +9619,13 @@ msgctxt ""
msgid "Yes"
msgstr ""
-#. LgGtA
+#. rDJFC
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id151598177605296\n"
"help.text"
-msgid "Specifies the number of rows in a list box or a combo box."
+msgid "Specifies the number of rows in a ListBox, a ComboBox or a TableControl."
msgstr ""
#. kaaLt
@@ -8971,13 +9637,13 @@ msgctxt ""
msgid "No"
msgstr ""
-#. JAmaD
+#. Ey9iG
#: sf_dialogcontrol.xhp
msgctxt ""
"sf_dialogcontrol.xhp\n"
"par_id251588334016874\n"
"help.text"
-msgid "Specifies which item is selected in a list box or combo box."
+msgid "Specifies which item is selected in a ListBox, a ComboBox or a TableControl."
msgstr ""
#. azv7C
@@ -9556,6 +10222,15 @@ msgctxt ""
msgid "Must be within the predefined bounds"
msgstr ""
+#. CVTcE
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id441598543254951\n"
+"help.text"
+msgid "One-dimensional array with the data of the currently selected row."
+msgstr ""
+
#. a9AMF
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -10114,6 +10789,105 @@ msgctxt ""
msgid "This method is often called from a dialog or control event."
msgstr ""
+#. it2QN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id541638553960464\n"
+"help.text"
+msgid "Fills a <literal>TableControl</literal> with the given data. All preexisting data is cleared before inserting the new data passed as argument."
+msgstr ""
+
+#. Vmmag
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id551638554058131\n"
+"help.text"
+msgid "When the <literal>TableControl</literal> is added to the dialog, it is possible to use the Basic IDE to define whether column and row headers will be shown in the table. If the <literal>TableControl</literal> has column and/or row headers, the first column and/or row in the provided data array are used as labels for the table headers."
+msgstr ""
+
+#. qn4UN
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id411638569396108\n"
+"help.text"
+msgid "This method returns <literal>True</literal> when successful."
+msgstr ""
+
+#. LESVB
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257133\n"
+"help.text"
+msgid "<emph>dataarray</emph>: Data to be entered into the table represented as an Array of Arrays in Basic or a tuple of tuples in Python. The data must include column and row headers if they are to be displayed by the <literal>TableControl</literal>."
+msgstr ""
+
+#. 6AKaJ
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257025\n"
+"help.text"
+msgid "<emph>widths</emph>: Array containing the relative widths of each column. In other words, <literal>widths = Array(1, 2)</literal> means that the second column is twice as wide as the first one. If the number of values in the array is smaller than the number of columns in the table, then the last value in the array is used to define the width of the remaining columns."
+msgstr ""
+
+#. AEGq3
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id1001584541257007\n"
+"help.text"
+msgid "<emph>alignments</emph>: Defines the alignment in each column as a string in which each character can be \"L\" (Left), \"C\" (Center), \"R\" (Right) or \" \" (whitespace, default, meaning left for strings and right for numeric values). If the length of the string is shorter than the number of columns in the table, then the last character in the string is used to define the alignment of the remaining columns."
+msgstr ""
+
+#. FCNEg
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id381638569172413\n"
+"help.text"
+msgid "The following example assumes that the dialog <literal>myDialog</literal> has a <literal>TableControl</literal> named <literal>Grid1</literal> with \"Show header row\" and \"Show column row\" properties set to \"Yes\"."
+msgstr ""
+
+#. N9Byz
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"par_id171638650502346\n"
+"help.text"
+msgid "The <literal>Value</literal> property returns the selected row in the table. If no row is selected, an empty Array object is returned. The following code snippet shows how to test if any row is selected in the table."
+msgstr ""
+
+#. C3f3k
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id361638651540588\n"
+"help.text"
+msgid "MsgBox \"No row selected.\""
+msgstr ""
+
+#. iQ94A
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"bas_id781638651541028\n"
+"help.text"
+msgid "MsgBox \"Row \" & oTable.ListIndex & \" is selected.\""
+msgstr ""
+
+#. yyATt
+#: sf_dialogcontrol.xhp
+msgctxt ""
+"sf_dialogcontrol.xhp\n"
+"pyc_id111638569958471\n"
+"help.text"
+msgid "dlg = CreateScriptService(\"Dialog\", \"GlobalScope\", \"Standard\", \"myDialog\")"
+msgstr ""
+
#. HNmmm
#: sf_dialogcontrol.xhp
msgctxt ""
@@ -11311,13 +12085,103 @@ msgctxt ""
msgid "<emph>saveask</emph> : If <literal>True</literal> (default), the user is invited to confirm if the changes should be written on disk. This argument is ignored if the document was not modified."
msgstr ""
-#. wvxcZ
+#. CGKZA
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id156589200123048\n"
+"help.text"
+msgid "Exports the document directly as a PDF file to the specified location. Returns <literal>True</literal> if the PDF file was successfully created."
+msgstr ""
+
+#. PBk4E
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id811638276067119\n"
+"help.text"
+msgid "The export options can be set either manually using the <menuitem>File - Export As - Export as PDF</menuitem> dialog or by calling the methods <literal>GetPDFExportOptions</literal> and <literal>SetPDFExportOptions</literal> from the <link href=\"text/sbasic/shared/03/sf_session.xhp\" name=\"SFSession\">Session</link> service."
+msgstr ""
+
+#. SFwEd
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id211635436910641\n"
+"help.text"
+msgid "<emph>filename</emph>: The full path and file name of the PDF to be created. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation."
+msgstr ""
+
+#. E6KyY
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436912005\n"
+"help.text"
+msgid "<emph>overwrite</emph>: Specifies if the destination file can be overwritten (Default = <literal>False</literal>). An error will occur if <literal>overwrite</literal> is set to <literal>False</literal> and the destination file already exists."
+msgstr ""
+
+#. d9RRn
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436913587\n"
+"help.text"
+msgid "<emph>pages</emph><emph/>: String specifying which pages will be exported. This argument uses the same notation as in the dialog <menuitem>File - Export As - Export as PDF</menuitem>."
+msgstr ""
+
+#. kBDPk
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436919655\n"
+"help.text"
+msgid "<emph>password</emph><emph/>: Specifies a password to open the PDF file."
+msgstr ""
+
+#. joeXi
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id141635436913365\n"
+"help.text"
+msgid "<emph>watermark</emph>: Text to be used as watermark in the PDF file, which will be drawn in every page of the resulting PDF."
+msgstr ""
+
+#. NmChF
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id301638234284727\n"
+"help.text"
+msgid "The following example exports the current document as a PDF file, defines a password and overwrites the destination file if it already exists."
+msgstr ""
+
+#. wEW7B
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"par_id311638276257020\n"
+"help.text"
+msgid "The code snippet below gets the current PDF export options and uses them to create the PDF file."
+msgstr ""
+
+#. 7uUWr
+#: sf_document.xhp
+msgctxt ""
+"sf_document.xhp\n"
+"bas_id851638277174798\n"
+"help.text"
+msgid "' Sets to True the option to export comments as PDF notes"
+msgstr ""
+
+#. HNC9m
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id156589200121138\n"
"help.text"
-msgid "This method sends the content of the document to a default printer or a printer defined by the <literal>SetPrinter</literal> method."
+msgid "This method sends the contents of the document to the default printer or to the printer defined by the <literal>SetPrinter</literal> method."
msgstr ""
#. CJxTR
@@ -11338,13 +12202,13 @@ msgctxt ""
msgid "<emph>pages</emph>: The pages to print as a string, like in the user interface. Example: \"1-4;10;15-18\". Default is all pages."
msgstr ""
-#. eD7LB
+#. EHtFi
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id141635436912146\n"
"help.text"
-msgid "<emph>copies</emph><emph/>: The number of copies. Default is 1."
+msgid "<emph>copies</emph>: The number of copies. Default is 1."
msgstr ""
#. Nmwv9
@@ -11392,13 +12256,13 @@ msgctxt ""
msgid "The following example runs the \"SelectData\" command in a Calc sheet named \"MyFile.ods\", which will result in the selection of the data area based on the currently selected cell."
msgstr ""
-#. pbYAn
+#. avaEg
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id751611153375195\n"
"help.text"
-msgid "The example above actually runs the UNO command <literal>uno:SelectData</literal>. Hence, to use the <literal>RunCommand</literal> method it is necessary to remove the \"uno:\" substring."
+msgid "The example above actually runs the UNO command <literal>.uno:SelectData</literal>. Hence, to use the <literal>RunCommand</literal> method it is necessary to remove the \".uno:\" substring."
msgstr ""
#. JRHRS
@@ -11617,13 +12481,13 @@ msgctxt ""
msgid "<emph>orientation</emph>: Either <literal>PORTRAIT</literal> or <literal>LANDSCAPE</literal>. When absent, left unchanged with respect to the printer settings."
msgstr ""
-#. H2EDf
+#. ENyZH
#: sf_document.xhp
msgctxt ""
"sf_document.xhp\n"
"par_id821985205147330\n"
"help.text"
-msgid "<emph>paperformat</emph>: One of the following string values <literal>A3</literal>, <literal>A4</literal>, <literal>A5</literal>, <literal>LETTER</literal>, <literal>LEGAL</literal>, <literal>TABLOID</literal>. Left unchanged when absent."
+msgid "<emph>paperformat</emph>: Specifies the paper format as a string value that can be either <literal>A3</literal>, <literal>A4</literal>, <literal>A5</literal>, <literal>LETTER</literal>, <literal>LEGAL</literal> or <literal>TABLOID</literal>. Left unchanged when absent."
msgstr ""
#. WCH7E
@@ -16792,13 +17656,13 @@ msgctxt ""
msgid "The first example reads the current value in a ComboBox containing city names and writes it to a FixedTest control in a Form:"
msgstr ""
-#. B5QLA
+#. 3eh6E
#: sf_formcontrol.xhp
msgctxt ""
"sf_formcontrol.xhp\n"
"pyc_id991622562833004\n"
"help.text"
-msgid "ui = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
+msgid "bas = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
msgstr ""
#. 8jneo
@@ -16828,22 +17692,22 @@ msgctxt ""
msgid "MsgBox \"Selected option: \" & optControl.Caption"
msgstr ""
-#. kxKPM
+#. YnBgM
#: sf_formcontrol.xhp
msgctxt ""
"sf_formcontrol.xhp\n"
"pyc_id991622562822004\n"
"help.text"
-msgid "ui = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
+msgid "bas = CreateScriptService('ScriptForge.Basic') # Basic-like methods"
msgstr ""
-#. QBAvs
+#. TNTT9
#: sf_formcontrol.xhp
msgctxt ""
"sf_formcontrol.xhp\n"
"pyc_id441622562080419\n"
"help.text"
-msgid "ui.MsgBox('Selected option: ' + control.Caption)"
+msgid "bas.MsgBox('Selected option: ' + control.Caption)"
msgstr ""
#. czP76
@@ -17467,13 +18331,13 @@ msgctxt ""
msgid "The <literal>L10N</literal> service is based on the GNU implementation of PO (portable object) files. To learn more about this file format, visit <link href=\"https://www.gnu.org/software/gettext/manual/html_node/PO-Files.html\" name=\"GetText\">GNU gettext Utilities: PO Files</link>."
msgstr ""
-#. 4CMir
+#. DGiG9
#: sf_l10n.xhp
msgctxt ""
"sf_l10n.xhp\n"
"par_id91585843652832\n"
"help.text"
-msgid "This service implements the three methods listed below:"
+msgid "This service implements the methods listed below:"
msgstr ""
#. fBXDW
@@ -17485,6 +18349,15 @@ msgctxt ""
msgid "<emph>AddText</emph>: Used by the programmer to build a set of strings that will be translated later."
msgstr ""
+#. BtuQ3
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id81637866601151\n"
+"help.text"
+msgid "<emph>AddTextsFromDialog</emph>: Extracts all strings from a <literal>Dialog</literal> service instance."
+msgstr ""
+
#. cm7fq
#: sf_l10n.xhp
msgctxt ""
@@ -17791,6 +18664,96 @@ msgctxt ""
msgid "The example below creates a set of strings in English:"
msgstr ""
+#. rWt7U
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id1001585843659821\n"
+"help.text"
+msgid "Automatically extracts strings from a dialog and adds them to the list of localizable text strings. The following strings are extracted:"
+msgstr ""
+
+#. bS7ZL
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id621637863440015\n"
+"help.text"
+msgid "The title of the dialog."
+msgstr ""
+
+#. EBFAC
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id61637863440399\n"
+"help.text"
+msgid "The caption of the following control types: Button, CheckBox, FixedLine, FixedText, GroupBox and RadioButton."
+msgstr ""
+
+#. uCL85
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id251637863440626\n"
+"help.text"
+msgid "Static strings in ListBoxes and ComboBoxes."
+msgstr ""
+
+#. HWkAU
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id811637863596791\n"
+"help.text"
+msgid "The tooltip or help text displayed when the mouse hovers over the control."
+msgstr ""
+
+#. gKbEN
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id641625855723650\n"
+"help.text"
+msgid "The method returns <literal>True</literal> if successful."
+msgstr ""
+
+#. Kcowa
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id731637863894577\n"
+"help.text"
+msgid "The dialog from which strings will be extracted must not be open when the method is called."
+msgstr ""
+
+#. 75EGY
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id911637864050221\n"
+"help.text"
+msgid "When a <literal>L10N</literal> service instance is created from an existing PO file, use the <link href=\"text/sbasic/shared/03/sf_dialog.xhp#GetTextsFromL10N\" name=\"GetTextsFromL10N\">GetTextsFromL10N</link> method from the <literal>Dialog</literal> service to automatically load all translated strings into the dialog."
+msgstr ""
+
+#. ejhbN
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id391585843652113\n"
+"help.text"
+msgid "<emph>dialog</emph>: a Dialog service instance corresponding to the dialog from which strings will be extracted."
+msgstr ""
+
+#. QzWzG
+#: sf_l10n.xhp
+msgctxt ""
+"sf_l10n.xhp\n"
+"par_id461614364298983\n"
+"help.text"
+msgid "The following example extracts all strings from the dialog \"MyDialog\" stored in the \"Standard\" library and exports them to a POT file:"
+msgstr ""
+
#. DqFBf
#: sf_l10n.xhp
msgctxt ""
@@ -18952,15 +19915,6 @@ msgctxt ""
msgid "The example below uses the icon \"sc_newdoc.svg\" that is located inside the \"cmd\" folder. The forward slash \"/\" character is used as the path separator regardless of the operating system."
msgstr ""
-#. HReGj
-#: sf_popupmenu.xhp
-msgctxt ""
-"sf_popupmenu.xhp\n"
-"bas_id121636725026678\n"
-"help.text"
-msgid "myPopup.AddItem(\"Item A\", Icon := \"cmd/sc_newdoc.svg\")"
-msgstr ""
-
#. 2QW4m
#: sf_popupmenu.xhp
msgctxt ""
@@ -19834,6 +20788,42 @@ msgctxt ""
msgid "The following examples show how to call the function <literal>odd_integers</literal> from within Basic and Python scripts."
msgstr ""
+#. pbmij
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id111582816585087\n"
+"help.text"
+msgid "Returns the current PDF export settings defined in the <menuitem>PDF Options</menuitem> dialog, which can be accessed by choosing <menuitem>File - Export as - Export as PDF</menuitem>."
+msgstr ""
+
+#. K7j2q
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id931638383270026\n"
+"help.text"
+msgid "Export options set with the <menuitem>PDF Options</menuitem> dialog are kept for future use. Hence <literal>GetPDFExportOptions</literal> returns the settings currently defined. In addition, use <literal>SetPDFExportOptions</literal> to change current PDF export options."
+msgstr ""
+
+#. uFCEq
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id801638383659558\n"
+"help.text"
+msgid "This method returns a <literal>Dictionary</literal> object wherein each key represent export options and the corresponding values are the current PDF export settings."
+msgstr ""
+
+#. 6kXBe
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id751638383457198\n"
+"help.text"
+msgid "Read the <link href=\"https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export\" name=\"PDFExport_Wiki\">PDF Export wiki page</link> to learn more about all available options."
+msgstr ""
+
#. Lv4iA
#: sf_session.xhp
msgctxt ""
@@ -20005,6 +20995,60 @@ msgctxt ""
msgid "<emph>editmessage</emph>: When <literal>True</literal> (default), the message is edited before being sent."
msgstr ""
+#. g7zLC
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id111582816583005\n"
+"help.text"
+msgid "Modifies the PDF export settings defined in the <menuitem>PDF Options</menuitem> dialog, which can be accessed by choosing <menuitem>File - Export as - Export as PDF</menuitem>."
+msgstr ""
+
+#. T2DkW
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id181638385131806\n"
+"help.text"
+msgid "Calling this method changes the actual values set in the <menuitem>PDF Options</menuitem> dialog, which are used by the <literal>ExportAsPDF</literal> method from the <literal>Document</literal> service."
+msgstr ""
+
+#. FBrKg
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id391638385313847\n"
+"help.text"
+msgid "This method returns <literal>True</literal> when successful."
+msgstr ""
+
+#. 9BqH3
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id751638383457321\n"
+"help.text"
+msgid "Read the <link href=\"https://wiki.openoffice.org/wiki/API/Tutorials/PDF_export\" name=\"PDFExport_Wiki\">PDF Export wiki page</link> to learn more about all available options."
+msgstr ""
+
+#. JhhXU
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id771582816585233\n"
+"help.text"
+msgid "<emph>pdfoptions</emph>: <literal>Dictionary</literal> object that defines the PDF export settings to be changed. Each key-value pair represents an export option and the value that will be set in the dialog."
+msgstr ""
+
+#. 8DKZK
+#: sf_session.xhp
+msgctxt ""
+"sf_session.xhp\n"
+"par_id141638386087986\n"
+"help.text"
+msgid "The following example changes the maximum image resolution to 150 dpi and exports the current document as a PDF file."
+msgstr ""
+
#. HtzHP
#: sf_session.xhp
msgctxt ""
@@ -24352,13 +25396,13 @@ msgctxt ""
msgid "In the following examples, the first line gets the names of all forms in the document and the second line retrieves the <literal>Form</literal> object of the form named \"Form_A\"."
msgstr ""
-#. S5MwC
+#. y684J
#: sf_writer.xhp
msgctxt ""
"sf_writer.xhp\n"
"par_id31592919577984\n"
"help.text"
-msgid "Send the content of the document to the printer. The printer might be defined previously by default, by the user or by the <link href=\"text/sbasic/03/sf_document.xhp#SetPrinter\" name=\"SetPrinter method\"><literal>SetPrinter()</literal></link> method of the <link href=\"text/sbasic/03/sf_document.xhp\" name=\"Document service\">Document</link> service. Returns <literal>True</literal> when successful."
+msgid "Send the contents of the document to the printer. The printer may be previously defined by default, by the user or by the <link href=\"text/sbasic/03/sf_document.xhp#SetPrinter\" name=\"SetPrinter method\"><literal>SetPrinter</literal></link> method of the <link href=\"text/sbasic/03/sf_document.xhp\" name=\"Document service\">Document</link> service. Returns <literal>True</literal> when successful."
msgstr ""
#. CKDb5
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index b0132d8dd2c..01b0c0319d9 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-11-25 19:33+0100\n"
+"POT-Creation-Date: 2021-12-20 13:20+0100\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"
@@ -14848,13 +14848,13 @@ msgctxt ""
msgid "CONVERT_OOO"
msgstr ""
-#. rE3zF
+#. Dx7ki
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id0908200902131122\n"
"help.text"
-msgid "<ahelp hid=\".\">Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the European Union, and vice versa.</ahelp> The conversion uses the fixed exchange rates at which the legacy currencies entered the euro."
+msgid "<ahelp hid=\".\">Converts to euros a currency value expressed in one of the legacy currencies of 19 member states of the Eurozone, and vice versa.</ahelp> The conversion uses the fixed exchange rates at which the legacy currencies entered the euro."
msgstr ""
#. de7Xa
diff --git a/source/zh-TW/helpcontent2/source/text/shared/00.po b/source/zh-TW/helpcontent2/source/text/shared/00.po
index 6b8d24acba5..f57f148facb 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/00.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/00.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-10-20 13:08+0200\n"
+"POT-Creation-Date: 2021-12-21 12:38+0100\n"
"PO-Revision-Date: 2020-07-28 14:35+0000\n"
"Last-Translator: sophie <gautier.sophie@gmail.com>\n"
"Language-Team: Chinese (Traditional) <https://weblate.documentfoundation.org/projects/libo_help-master/textshared00/zh_Hant/>\n"
@@ -10645,6 +10645,15 @@ msgctxt ""
msgid "Choose <menuitem>View - Styles</menuitem> <switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>(Command+T)</keycode></caseinline><defaultinline><keycode>(F11)</keycode></defaultinline></switchinline> - open context menu of a page style entry and choose <emph>Modify/New - Page</emph> tab."
msgstr ""
+#. iCz7o
+#: 00040500.xhp
+msgctxt ""
+"00040500.xhp\n"
+"par_id3133357\n"
+"help.text"
+msgid "Choose <menuitem>Format - Page Style - Page</menuitem> tab (Writer)."
+msgstr ""
+
#. w3yEG
#: 00040500.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/shared/guide.po b/source/zh-TW/helpcontent2/source/text/shared/guide.po
index f215f37dd40..9ade985593d 100644
--- a/source/zh-TW/helpcontent2/source/text/shared/guide.po
+++ b/source/zh-TW/helpcontent2/source/text/shared/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-11-24 12:02+0100\n"
+"POT-Creation-Date: 2021-12-20 13:21+0100\n"
"PO-Revision-Date: 2019-08-09 08:03+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -5965,13 +5965,13 @@ msgctxt ""
msgid "CSV Filter parameters"
msgstr ""
-#. cvtJM
+#. KyLbg
#: csv_params.xhp
msgctxt ""
"csv_params.xhp\n"
"bm_id181634740978601\n"
"help.text"
-msgid "<bookmark_value>CSV;filter options</bookmark_value> <bookmark_value>CSV;import options</bookmark_value> <bookmark_value>CSV;export options</bookmark_value> <bookmark_value>CSV;command line filter options</bookmark_value>"
+msgid "<bookmark_value>CSV;filter options</bookmark_value> <bookmark_value>CSV;separator specification line</bookmark_value> <bookmark_value>CSV;import options</bookmark_value> <bookmark_value>CSV;export options</bookmark_value> <bookmark_value>CSV;command line filter options</bookmark_value>"
msgstr ""
#. szBoK
@@ -6325,6 +6325,87 @@ msgctxt ""
msgid "String, either <literal>false</literal> or <literal>true</literal>. Default value: <literal>false</literal>. Determines whether formula expressions starting with a = equal sign character are to be evaluated as formulas or imported as textual data. If <literal>true</literal> evaluate formulas on input. If <literal>false</literal> formulas are input as text. If omitted (not present at all), the default value is <literal>true</literal> to keep the behaviour of old versions' options string that didn't have this token at all. If present and empty (or any other value than <literal>true</literal>) the default value is <literal>false</literal>."
msgstr ""
+#. DAriB
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"hd_id591638374883162\n"
+"help.text"
+msgid "Special case of CSV files with separator defined in the first line"
+msgstr ""
+
+#. gpBdg
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id781638374952502\n"
+"help.text"
+msgid "CSV import and export support a <literal>sep=</literal> and <literal>\"sep=\"</literal> field separator setting. When reading a CSV document, the separator is taken from the initial <literal>sep=</literal> or <literal>\"sep=\"</literal> single field, if that is the only line content."
+msgstr ""
+
+#. q8D8y
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id561638377619263\n"
+"help.text"
+msgid "When reading a CSV file, the quoted form is preserved as (unquoted) cell content. You see <literal>sep=|</literal> when | is the separator in the first line. In the unquoted form, the separator is discarded because it is a real field separator in the context. You see <literal>sep=</literal> in the first line."
+msgstr ""
+
+#. j5dBK
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id761638377626465\n"
+"help.text"
+msgid "When writing a CSV file, the existing single top left cell's content such as <literal>sep=|</literal> is adapted to the current separator with the quoted form of <literal>\"sep=|\"</literal> (if quotes / text delimiters aren't set empty and | is the separator) and always uses the ASCII \" double quote character."
+msgstr ""
+
+#. uBq4B
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id61638377631743\n"
+"help.text"
+msgid "If the line containing the <literal>sep=|</literal> is not to be imported as data, remember to set the <emph>From row</emph> number in the dialog to 2. Note that this line will not be preserved when re-saving."
+msgstr ""
+
+#. oGd5z
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id731638374814029\n"
+"help.text"
+msgid "\"LETTER\"|\"ANIMAL\""
+msgstr ""
+
+#. CsfKB
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id801638374818291\n"
+"help.text"
+msgid "\"a\"|\"aardvark\""
+msgstr ""
+
+#. t62e9
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id621638374822275\n"
+"help.text"
+msgid "\"b\"|\"bear\""
+msgstr ""
+
+#. G2aQG
+#: csv_params.xhp
+msgctxt ""
+"csv_params.xhp\n"
+"par_id851638374831208\n"
+"help.text"
+msgid "\"c\"|\"cow\""
+msgstr ""
+
#. EFwn3
#: csv_params.xhp
msgctxt ""
@@ -22282,76 +22363,76 @@ msgctxt ""
msgid "Choose <emph>Format - Object - Position and Size </emph>- <emph>Position and Size</emph> tab. Unmark the <emph>Position</emph> or <emph>Size</emph> check box."
msgstr "選擇 <emph>[格式] - [物件] - [位置和大小]</emph> - <emph>[位置和大小]</emph> 標籤。取消標記 <emph>[位置]</emph> 或 <emph>[大小]</emph> 核取方塊。"
-#. CnLjj
+#. dwefM
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"tit\n"
"help.text"
-msgid "QR Code"
+msgid "QR and Barcode"
msgstr ""
-#. Yuk2B
+#. 3tty9
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"bm_id901566317201860\n"
"help.text"
-msgid "<bookmark_value>QR Code</bookmark_value>"
+msgid "<bookmark_value>QR code;barcode</bookmark_value>"
msgstr ""
-#. FqKRN
+#. 82bgJ
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"hd_id461566315781439\n"
"help.text"
-msgid "<link href=\"text/shared/guide/qrcode.xhp\" name=\"QR Code\">QR Code</link>"
+msgid "<link href=\"text/shared/guide/qrcode.xhp\" name=\"QR and Barcode\">QR and Barcode</link>"
msgstr ""
-#. YdWKF
+#. ztYka
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id381566315781439\n"
"help.text"
-msgid "Generate QR Code for any text or URL."
+msgid "Generate linear and matrix codes for any text or URL."
msgstr ""
-#. SzeNM
+#. UCs5m
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id411566316109551\n"
"help.text"
-msgid "The QR Code Generation feature helps to create QR codes for any text or URL. The QR code is produced as an image or shape and has all the properties associated with an image."
+msgid "The QR and Barcode generation feature allows you to encode any text string or URL as a barcode or a QR code and insert it as a graphical object in a document for scanning."
msgstr ""
-#. JFjy3
+#. N32UF
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id761566316165430\n"
"help.text"
-msgid "Choose <menuitem>Insert - Object - QR Code</menuitem>."
+msgid "Choose <menuitem>Insert - Object - QR and Barcode</menuitem>."
msgstr ""
-#. vF7bp
+#. UCeXG
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"hd_id611566316506278\n"
"help.text"
-msgid "URL or Text"
+msgid "URL or text"
msgstr ""
-#. ikC8E
+#. q98jw
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id251566316519649\n"
"help.text"
-msgid "The text from which to generate the QR code."
+msgid "The text from which to generate the code."
msgstr ""
#. 6mj5K
@@ -22426,13 +22507,13 @@ msgctxt ""
msgid "Margin"
msgstr ""
-#. MUEWe
+#. PuMhx
#: qrcode.xhp
msgctxt ""
"qrcode.xhp\n"
"par_id981566316947064\n"
"help.text"
-msgid "The width of the margin surrounding the QR code."
+msgid "The width of the margin surrounding the code."
msgstr ""
#. kZPNW
@@ -22462,15 +22543,6 @@ msgctxt ""
msgid "<image src=\"media/helpimg/qrcode_example.svg\" id=\"img_id991566321218295\" width=\"4cm\" height=\"4cm\"><alt id=\"alt_id401566321218295\">QR code example</alt></image>"
msgstr ""
-#. zkgFS
-#: qrcode.xhp
-msgctxt ""
-"qrcode.xhp\n"
-"par_id441566317415844\n"
-"help.text"
-msgid "QR code in the <link href=\"https://en.wikipedia.org/wiki/QR_code\" name=\"wikipedia\">Wikipedia</link>"
-msgstr ""
-
#. FuBFK
#: redaction.xhp
msgctxt ""
diff --git a/source/zh-TW/helpcontent2/source/text/swriter/guide.po b/source/zh-TW/helpcontent2/source/text/swriter/guide.po
index 7559bb69819..aa10d5492e1 100644
--- a/source/zh-TW/helpcontent2/source/text/swriter/guide.po
+++ b/source/zh-TW/helpcontent2/source/text/swriter/guide.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-11-25 19:34+0100\n"
+"POT-Creation-Date: 2021-12-20 13:21+0100\n"
"PO-Revision-Date: 2020-01-12 06:57+0000\n"
"Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n"
"Language-Team: Chinese (Traditional) <https://weblate.documentfoundation.org/projects/libo_help-master/textswriterguide/zh_Hant/>\n"
@@ -7765,15 +7765,6 @@ msgctxt ""
msgid "Some words contain special characters that %PRODUCTNAME treats as a hyphen. If you do not want such words to be hyphenated, you can insert a special code that prevents hyphenation at the position where the special code is inserted. Proceed as follows:"
msgstr "某些字詞包含 %PRODUCTNAME 視為連字符的特殊字元。若不想以連字符連接這類字詞,可以在插入特殊代碼的位置插入不要以連字符連接的特殊代碼。請繼續進行以下步驟:"
-#. 2aXji
-#: hyphen_prevent.xhp
-msgctxt ""
-"hyphen_prevent.xhp\n"
-"par_id0302200910262850\n"
-"help.text"
-msgid "Enable the special features of complex text layout (CTL) languages: Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - Language Settings - Languages</item> and check <emph>Enabled for complex text layout (CTL)</emph>. Click OK."
-msgstr "啟用複合文字版面配置 (CTL) 語言的特殊功能:選擇 <item type=\"menuitem\"><switchinline select=\"sys\"><caseinline select=\"MAC\">[%PRODUCTNAME] - [喜好設定]</caseinline><defaultinline>[工具] - [選項]</defaultinline></switchinline> - [語言設定] - [語言]</item>,然後核取 <emph>[啟用複合文字版面配置 (CTL)]</emph>。按一下 [確定]。"
-
#. CiY92
#: hyphen_prevent.xhp
msgctxt ""
@@ -7792,14 +7783,14 @@ msgctxt ""
msgid "Choose <menuitem>Insert - Formatting Mark - Word Joiner</menuitem>."
msgstr ""
-#. 6u4r9
+#. 4qRmW
#: hyphen_prevent.xhp
msgctxt ""
"hyphen_prevent.xhp\n"
-"par_id0302200910572128\n"
+"par_id501639661322712\n"
"help.text"
-msgid "Once the special character is inserted, you might disable CTL again. Support of CTL was only necessary to insert the special character."
-msgstr "插入特殊字元之後,可以再停用 CTL。只有在插入特殊字元時,才需要 CTL 的支援。"
+msgid "The inserted formatting mark will be shown in gray. To remove it, simply place the cursor over the formatting mark and press the <keycode>Del</keycode> key."
+msgstr ""
#. skDHA
#: hyphen_prevent.xhp
@@ -15865,6 +15856,15 @@ msgctxt ""
msgid "Press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+P to make the text superscript, and <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+B to make the text subscript."
msgstr "按下 <switchinline select=\"sys\"><caseinline select=\"MAC\">命令鍵</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+P 來讓文字變為上標,以及 <switchinline select=\"sys\"><caseinline select=\"MAC\">命令鍵</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+B 讓文字變成下標。"
+#. ALJRV
+#: subscript.xhp
+msgctxt ""
+"subscript.xhp\n"
+"par_id3149205\n"
+"help.text"
+msgid "In the <menuitem>Properties</menuitem> deck of the sidebar, go to the <menuitem>Character</menuitem> area and click the <menuitem>Superscript</menuitem> or <menuitem>Subscript</menuitem> buttons."
+msgstr ""
+
#. VwZA6
#: subscript.xhp
msgctxt ""
@@ -17261,13 +17261,13 @@ msgctxt ""
msgid "To set the behavior of the direct cursor, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Writer - Formatting Aids</emph>."
msgstr ""
-#. gJUFG
+#. 4MoxW
#: text_direct_cursor.xhp
msgctxt ""
"text_direct_cursor.xhp\n"
"par_idN106A3\n"
"help.text"
-msgid "On the <menuitem>Tools</menuitem> bar, click the <menuitem>Direct Cursor</menuitem> icon <image id=\"img_id3149846\" src=\"cmd/sc_shadowcursor.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149846\">Icon</alt></image>. Alternativelly, enable <emph>Direct Cursor</emph> by going to <menuitem>Edit - Direct Cursor Mode</menuitem>."
+msgid "On the <menuitem>Tools</menuitem> bar, click the <menuitem>Direct Cursor</menuitem> icon <image id=\"img_id3149846\" src=\"cmd/sc_shadowcursor.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149846\">Icon</alt></image>. Alternatively, enable <emph>Direct Cursor</emph> by going to <menuitem>Edit - Direct Cursor Mode</menuitem>."
msgstr ""
#. AmitQ