update translations for master

and force-fix errors using pocheck

Change-Id: I3c00491e0ea0ac65e61a006108fd80d6188b16d0

1 files changed, 585 insertions, 171 deletions

diff --git a/source/zh-TW/sc/messages.po b/source/zh-TW/sc/messages.po
index 10b39a8626e..a673831dec8 100644
--- a/source/zh-TW/sc/messages.po
+++ b/source/zh-TW/sc/messages.po
@@ -3,8 +3,8 @@ 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-07-21 11:19+0200\n"
-"PO-Revision-Date: 2020-03-21 22:16+0000\n"
+"POT-Creation-Date: 2020-08-21 17:59+0200\n"
+"PO-Revision-Date: 2020-08-19 14:35+0000\n"
 "Last-Translator: Cheng-Chia Tseng <pswo10680@gmail.com>\n"
 "Language-Team: Chinese (Traditional) <https://weblate.documentfoundation.org/projects/libo_ui-master/scmessages/zh_Hant/>\n"
 "Language: zh-TW\n"
@@ -1467,13 +1467,13 @@ msgstr "DIF 匯入"
 #: sc/inc/globstr.hrc:272
 msgctxt "STR_STYLENAME_STANDARD"
 msgid "Default Cell Style"
-msgstr ""
+msgstr "預設儲存格樣式"
 
 #. xnqdA
 #: sc/inc/globstr.hrc:273
 msgctxt "STR_STYLENAME_STANDARD"
 msgid "Default Page Style"
-msgstr ""
+msgstr "預設頁面樣式"
 
 #. GATGM
 #: sc/inc/globstr.hrc:274
@@ -2521,7 +2521,7 @@ msgstr "此文件被其他文件作為參照但尚未儲存。若不儲存就關
 #: sc/inc/globstr.hrc:436
 msgctxt "STR_COND_CONDITION"
 msgid "Cell value"
-msgstr ""
+msgstr "儲存格的值"
 
 #. E8yxG
 #: sc/inc/globstr.hrc:437
@@ -2545,13 +2545,13 @@ msgstr "圖示集"
 #: sc/inc/globstr.hrc:440
 msgctxt "STR_COND_BETWEEN"
 msgid "is between"
-msgstr ""
+msgstr "介於"
 
 #. VwraP
 #: sc/inc/globstr.hrc:441
 msgctxt "STR_COND_NOTBETWEEN"
 msgid "is not between"
-msgstr ""
+msgstr "不介於"
 
 #. 35tDp
 #: sc/inc/globstr.hrc:442
@@ -2563,7 +2563,7 @@ msgstr ""
 #: sc/inc/globstr.hrc:443
 msgctxt "STR_COND_DUPLICATE"
 msgid "is duplicate"
-msgstr ""
+msgstr "與其他重複"
 
 #. owhPn
 #: sc/inc/globstr.hrc:444
@@ -2605,61 +2605,61 @@ msgstr ""
 #: sc/inc/globstr.hrc:450
 msgctxt "STR_COND_ABOVE_AVERAGE"
 msgid "is above average"
-msgstr ""
+msgstr "大於平均值"
 
 #. 4QM7C
 #: sc/inc/globstr.hrc:451
 msgctxt "STR_COND_BELOW_AVERAGE"
 msgid "is below average"
-msgstr ""
+msgstr "小於平均值"
 
 #. CZfTg
 #: sc/inc/globstr.hrc:452
 msgctxt "STR_COND_ABOVE_EQUAL_AVERAGE"
 msgid "is above or equal average"
-msgstr ""
+msgstr "大於或等於平均值"
 
 #. GmUGP
 #: sc/inc/globstr.hrc:453
 msgctxt "STR_COND_BELOW_EQUAL_AVERAGE"
 msgid "is below or equal average"
-msgstr ""
+msgstr "小於或等於平均值"
 
 #. 8DgQ9
 #: sc/inc/globstr.hrc:454
 msgctxt "STR_COND_ERROR"
 msgid "is an error code"
-msgstr ""
+msgstr "是錯誤碼"
 
 #. ifj7i
 #: sc/inc/globstr.hrc:455
 msgctxt "STR_COND_NOERROR"
 msgid "is not an error code"
-msgstr ""
+msgstr "不是錯誤碼"
 
 #. pqqqU
 #: sc/inc/globstr.hrc:456
 msgctxt "STR_COND_BEGINS_WITH"
 msgid "begins with"
-msgstr ""
+msgstr "開頭是"
 
 #. atMkM
 #: sc/inc/globstr.hrc:457
 msgctxt "STR_COND_ENDS_WITH"
 msgid "ends with"
-msgstr ""
+msgstr "結尾是"
 
 #. 96Aos
 #: sc/inc/globstr.hrc:458
 msgctxt "STR_COND_CONTAINS"
 msgid "contains"
-msgstr ""
+msgstr "包含"
 
 #. X5K9F
 #: sc/inc/globstr.hrc:459
 msgctxt "STR_COND_NOT_CONTAINS"
 msgid "does not contain"
-msgstr ""
+msgstr "不包含"
 
 #. GvCEB
 #: sc/inc/globstr.hrc:460
@@ -18892,23 +18892,41 @@ msgid "Copy List"
 msgstr "複製清單"
 
 #. P7PZo
-#: sc/uiconfig/scalc/ui/colorrowdialog.ui:100
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:97
 msgctxt "colorrowdialog|columns"
 msgid "_Columns"
 msgstr "欄(_C)"
 
+#. orYEB
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:107
+msgctxt "extended_tip|columns"
+msgid "Select the Columns option to summarize the contents of the selected columns in a list."
+msgstr "選取 [欄] 選項，將所選欄的內容匯總成一個清單。"
+
 #. 8qbkD
-#: sc/uiconfig/scalc/ui/colorrowdialog.ui:117
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:119
 msgctxt "colorrowdialog|rows"
 msgid "_Rows"
 msgstr "列(_R)"
 
+#. CCfoS
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:129
+msgctxt "extended_tip|rows"
+msgid "Select the Rows option to summarize the contents of the selected rows in a list."
+msgstr "選取 [列] 選項，將所選列的內容匯總成一個清單。"
+
 #. UiR8k
-#: sc/uiconfig/scalc/ui/colorrowdialog.ui:140
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:147
 msgctxt "colorrowdialog|label"
 msgid "List From"
 msgstr "清單取自"
 
+#. BSSuE
+#: sc/uiconfig/scalc/ui/colorrowdialog.ui:172
+msgctxt "extended_tip|ColOrRowDialog"
+msgid "Allows you to copy marked cells to a sort list."
+msgstr "允許您將標記的儲存格複製到排序清單中。"
+
 #. ZnGGB
 #: sc/uiconfig/scalc/ui/colwidthdialog.ui:8
 msgctxt "colwidthdialog|ColWidthDialog"
@@ -19141,61 +19159,61 @@ msgstr "範例"
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:374
 msgctxt "conditionalentry|typeis"
 msgid "is equal to"
-msgstr ""
+msgstr "等於"
 
 #. bnDkp
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:375
 msgctxt "conditionalentry|typeis"
 msgid "is less than"
-msgstr ""
+msgstr "小於"
 
 #. ok3Hq
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:376
 msgctxt "conditionalentry|typeis"
 msgid "is greater than"
-msgstr ""
+msgstr "大於"
 
 #. yMvDB
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:377
 msgctxt "conditionalentry|typeis"
 msgid "is less than or equal to"
-msgstr ""
+msgstr "小於或等於"
 
 #. XoEDQ
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:378
 msgctxt "conditionalentry|typeis"
 msgid "is greater than or equal to"
-msgstr ""
+msgstr "大於或等於"
 
 #. Kyf5x
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:379
 msgctxt "conditionalentry|typeis"
 msgid "is not equal to"
-msgstr ""
+msgstr "不等於"
 
 #. HcfU9
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:380
 msgctxt "conditionalentry|typeis"
 msgid "is between"
-msgstr ""
+msgstr "介於"
 
 #. 2A2DA
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:381
 msgctxt "conditionalentry|typeis"
 msgid "is not between"
-msgstr ""
+msgstr "不介於"
 
 #. 5HFGX
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:382
 msgctxt "conditionalentry|typeis"
 msgid "is duplicate"
-msgstr ""
+msgstr "與其他重複"
 
 #. 8ZUSC
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:383
 msgctxt "conditionalentry|typeis"
 msgid "is not duplicate"
-msgstr ""
+msgstr "不與其他重複"
 
 #. E7mG8
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:384
@@ -19249,37 +19267,37 @@ msgstr ""
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:392
 msgctxt "conditionalentry|typeis"
 msgid "is error"
-msgstr ""
+msgstr "是錯誤"
 
 #. CaKU9
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:393
 msgctxt "conditionalentry|typeis"
 msgid "is not error"
-msgstr ""
+msgstr "不是錯誤"
 
 #. 4dd5c
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:394
 msgctxt "conditionalentry|typeis"
 msgid "begins with"
-msgstr ""
+msgstr "開頭是"
 
 #. BxBTB
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:395
 msgctxt "conditionalentry|typeis"
 msgid "ends with"
-msgstr ""
+msgstr "結尾是"
 
 #. bkWSj
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:396
 msgctxt "conditionalentry|typeis"
 msgid "contains"
-msgstr ""
+msgstr "包含"
 
 #. UwtTu
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:397
 msgctxt "conditionalentry|typeis"
 msgid "does not contain"
-msgstr ""
+msgstr "不包含"
 
 #. 5WkbA
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:409
@@ -19393,7 +19411,7 @@ msgstr "所有儲存格"
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:462
 msgctxt "conditionalentry|type"
 msgid "Cell value"
-msgstr ""
+msgstr "儲存格的值"
 
 #. ZqmeM
 #: sc/uiconfig/scalc/ui/conditionalentry.ui:463
@@ -21043,43 +21061,43 @@ msgstr ""
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:43
 msgctxt "erroralerttabpage-mobile|action_label"
 msgid "_Action:"
-msgstr ""
+msgstr "動作(_A)："
 
 #. 2sruM
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:57
 msgctxt "erroralerttabpage-mobile|title_label"
 msgid "_Title:"
-msgstr ""
+msgstr "標題(_T)："
 
 #. DALxA
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:104
 msgctxt "erroralerttabpage-mobile|errormsg_label"
 msgid "_Error message:"
-msgstr ""
+msgstr "錯誤訊息(_E)："
 
 #. ZzEdw
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:117
 msgctxt "erroralerttabpage-mobile|browseBtn"
 msgid "_Browse..."
-msgstr ""
+msgstr "瀏覽(_B)..."
 
 #. hsbzw
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:133
 msgctxt "erroralerttabpage-mobile|actionCB"
 msgid "Stop"
-msgstr ""
+msgstr "停止"
 
 #. fcLJh
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:134
 msgctxt "erroralerttabpage-mobile|actionCB"
 msgid "Warning"
-msgstr ""
+msgstr "警告"
 
 #. trGJe
 #: sc/uiconfig/scalc/ui/erroralerttabpage-mobile.ui:135
 msgctxt "erroralerttabpage-mobile|actionCB"
 msgid "Information"
-msgstr ""
+msgstr "資訊"
 
 #. PL8Bz
 #: sc/uiconfig/scalc/ui/erroralerttabpage.ui:15
@@ -21356,25 +21374,25 @@ msgstr "遞增值(_C)："
 #: sc/uiconfig/scalc/ui/filterdropdown.ui:109
 msgctxt "filterdropdown|STR_EDIT_SEARCH_ITEMS"
 msgid "Search items..."
-msgstr ""
+msgstr "搜尋項目..."
 
 #. zKwWE
 #: sc/uiconfig/scalc/ui/filterdropdown.ui:143
 msgctxt "filterdropdown|STR_BTN_TOGGLE_ALL"
 msgid "All"
-msgstr ""
+msgstr "全部"
 
 #. JsSz6
 #: sc/uiconfig/scalc/ui/filterdropdown.ui:163
 msgctxt "filterdropdown|STR_BTN_SELECT_CURRENT"
 msgid "Show only the current item."
-msgstr ""
+msgstr "僅顯示目前項目。"
 
 #. vBQYB
 #: sc/uiconfig/scalc/ui/filterdropdown.ui:178
 msgctxt "filterdropdown|STR_BTN_UNSELECT_CURRENT"
 msgid "Hide only the current item."
-msgstr ""
+msgstr "僅隱藏目前項目。"
 
 #. AfnFz
 #: sc/uiconfig/scalc/ui/floatingborderstyle.ui:33
@@ -21616,6 +21634,12 @@ msgctxt "formulacalculationoptions|label3"
 msgid "Contents to Numbers"
 msgstr "內容轉數字"
 
+#. FY66D
+#: sc/uiconfig/scalc/ui/formulacalculationoptions.ui:219
+msgctxt "extended_tip|FormulaCalculationOptions"
+msgid "Sets the rules for conversion from strings values to numeric values, string values to cell references, and strings values to date and time values. This affects built-in functions such as INDIRECT that takes a reference as a string value or date and time functions that takes arguments as string values in local or ISO 8601 formats."
+msgstr ""
+
 #. qUwp9
 #: sc/uiconfig/scalc/ui/fourieranalysisdialog.ui:15
 msgctxt "fourieranalysisdialog|FourierAnalysisDialog"
@@ -22850,7 +22874,7 @@ msgstr "常用(_H)"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:4919
 msgctxt "CalcNotebookbar|HomeLabel"
 msgid "~Home"
-msgstr ""
+msgstr "常用(~H)"
 
 #. bBEGh
 #: sc/uiconfig/scalc/ui/notebookbar.ui:5478
@@ -22882,7 +22906,7 @@ msgstr "物件對齊"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:7207
 msgctxt "CalcNotebookbar|LayoutMenuButton"
 msgid "_Layout"
-msgstr ""
+msgstr "版面配置(_L)"
 
 #. eWinY
 #: sc/uiconfig/scalc/ui/notebookbar.ui:7292
@@ -22894,7 +22918,7 @@ msgstr "版面配置(~L)"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:8398
 msgctxt "CalcNotebookbar|StatisticsMenuButton"
 msgid "_Statistics"
-msgstr ""
+msgstr "統計(_S)"
 
 #. BiHBE
 #: sc/uiconfig/scalc/ui/notebookbar.ui:8449
@@ -22936,7 +22960,7 @@ msgstr "檢視(~V)"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:11512
 msgctxt "CalcNotebookbar|ImageMenuButton"
 msgid "Ima_ge"
-msgstr ""
+msgstr "影像(_G)"
 
 #. rwprK
 #: sc/uiconfig/scalc/ui/notebookbar.ui:11637
@@ -22966,7 +22990,7 @@ msgstr "轉換"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:13738
 msgctxt "CalcNotebookbar|ObjectMenuButton"
 msgid "_Object"
-msgstr ""
+msgstr "物件(_O)"
 
 #. xTKVv
 #: sc/uiconfig/scalc/ui/notebookbar.ui:13848
@@ -23014,13 +23038,13 @@ msgstr "表單(~R)"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:15993
 msgctxt "CalcNotebookbar|ExtensionMenuButton"
 msgid "E_xtension"
-msgstr ""
+msgstr "擴充套件(_X)"
 
 #. 4ZDL7
 #: sc/uiconfig/scalc/ui/notebookbar.ui:16067
 msgctxt "CalcNotebookbar|ExtensionLabel"
 msgid "E~xtension"
-msgstr ""
+msgstr "擴充套件(~X)"
 
 #. 3Ec6T
 #: sc/uiconfig/scalc/ui/notebookbar.ui:17295
@@ -23032,7 +23056,7 @@ msgstr "工具(_T)"
 #: sc/uiconfig/scalc/ui/notebookbar.ui:17380
 msgctxt "CalcNotebookbar|ToolsLabel"
 msgid "~Tools"
-msgstr ""
+msgstr "工具(~T)"
 
 #. AJr3Y
 #: sc/uiconfig/scalc/ui/notebookbar_compact.ui:3039
@@ -24192,174 +24216,294 @@ msgctxt "optcalculatepage|case|tooltip_text"
 msgid "Disable case sensitivity for interoperability with Microsoft Excel"
 msgstr "停用大小寫區分以與 Microsoft Excel 相容"
 
+#. fGMgy
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:110
+msgctxt "extended_tip|case"
+msgid "Specifies whether to distinguish between upper and lower case in texts when comparing cell contents."
+msgstr "指定在比較儲存格內容時是否區分文字中字母的大小寫。"
+
 #. 9W56L
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:116
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:121
 msgctxt "optcalculatepage|calc"
 msgid "_Precision as shown"
 msgstr "顯示的精確度(_P)"
 
+#. YGAFd
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:130
+msgctxt "extended_tip|calc"
+msgid "Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If the Precision as shown option is not marked, the displayed numbers are rounded, but they are calculated internally using the non-rounded number."
+msgstr "指定是否使用試算表中所顯示的四捨五入值進行計算。顯示圖表時將採用顯示的數值。如果未標記 [顯示的精確度] 選項，則以四捨五入的數值顯示數字，但在進行內部計算時會使用未經四捨五入的數字。"
+
 #. BiDg6
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:131
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:141
 msgctxt "optcalculatepage|match"
 msgid "Search criteria = and <> must apply to _whole cells"
 msgstr "搜尋條件 = 和 <> 必須套用至全部的儲存格(_W)"
 
 #. d3ZgB
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:135
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:145
 msgctxt "optcalculatepage|match|tooltip_text"
 msgid "Enable this for interoperability with Microsoft Excel"
 msgstr "啟用此選項以與 Microsoft Excel 相容"
 
+#. APEQn
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:151
+msgctxt "extended_tip|match"
+msgid "Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When both, the Search criteria = and <> must apply to whole cells box and the Enable wildcards in formulas box are marked, %PRODUCTNAME Calc behaves exactly as Microsoft Excel when searching cells in the database functions."
+msgstr "指定您為 Calc 資料庫功能所設定的搜尋條件必須完全符合整個儲存格。若標記了 [搜尋範圍 = 和 <> 必須適用全部的儲存格] 方塊，%PRODUCTNAME Calc 在資料庫功能中搜尋儲存格時的運作方式會與 MS Excel 完全相同。"
+
 #. 5Wn8V
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:147
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:162
 msgctxt "optcalculatepage|lookup"
 msgid "_Automatically find column and row labels"
 msgstr "自動尋找欄標籤與列標籤(_A)"
 
+#. XVS3t
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:171
+msgctxt "extended_tip|lookup"
+msgid "Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators."
+msgstr "指定您可以使用任意儲存格中的文字作為該文字下方的欄或文字右側列的標籤。該文字至少要含有一個字，並且不能包含任何運算子。"
+
 #. DwExc
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:162
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:182
 msgctxt "optcalculatepage|generalprec"
 msgid "_Limit decimals for general number format"
 msgstr "限制一般數字格式的小數點(_L)"
 
+#. hufmT
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:191
+msgctxt "extended_tip|generalprec"
+msgid "You can specify the maximum number of decimal places that are shown by default for cells with General number format. If not enabled, cells with General number format show as many decimal places as the column width allows."
+msgstr ""
+
 #. buc6F
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:189
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:214
 msgctxt "optcalculatepage|precft"
 msgid "_Decimal places:"
 msgstr "小數點位數(_D)："
 
+#. riZoc
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:232
+msgctxt "extended_tip|prec"
+msgid "Defines the number of decimals to be displayed for numbers with the General number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers."
+msgstr ""
+
 #. tnj5y
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:228
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:258
 msgctxt "optcalculatepage|label1"
 msgid "General Calculations"
 msgstr "一般計算"
 
 #. p2vT9
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:261
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:291
 msgctxt "optcalculatepage|iterate"
 msgid "_Iterations"
 msgstr "迭代(_I)"
 
+#. pBKcn
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:300
+msgctxt "extended_tip|iterate"
+msgid "Specifies whether formulas with iterative references (formulas that are continuously repeated until the problem is solved) are calculated after a specific number of repetitions."
+msgstr "指定帶有反覆式參照的公式 (即需要不斷重複計算才能得到結果的公式)，在進行了特定次數的重複計算後是否繼續。"
+
 #. S6iwg
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:290
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:325
 msgctxt "optcalculatepage|stepsft"
 msgid "_Steps:"
 msgstr "步數(_S)："
 
 #. aJT9u
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:304
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:339
 msgctxt "optcalculatepage|minchangeft"
 msgid "_Minimum change:"
 msgstr "最小變動(_M)："
 
+#. GmKgv
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:357
+msgctxt "extended_tip|steps"
+msgid "Sets the maximum number of iteration steps."
+msgstr "設定最大迭代步數。"
+
+#. ZekEF
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:374
+msgctxt "extended_tip|minchange"
+msgid "Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop."
+msgstr "指定兩個連續循環步驟結果的差值。如果循環的結果小於最小變更值，則循環將停止。"
+
 #. UoUqA
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:355
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:400
 msgctxt "optcalculatepage|label2"
 msgid "Iterative References"
 msgstr "迭代式參照"
 
 #. BA74j
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:386
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:431
 msgctxt "optcalculatepage|datestd"
 msgid "12/30/1899 (defa_ult)"
 msgstr "12/30/1899 (預設)(_U)"
 
 #. ApqYV
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:390
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:435
 msgctxt "optcalculatepage|datestd|tooltip_text"
 msgid "Value 0 corresponds to 12/30/1899"
 msgstr "值 0 對應至 12/30/1899"
 
+#. SCewx
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:442
+msgctxt "extended_tip|datestd"
+msgid "Sets 12/30/1899 as day zero."
+msgstr "將 12/30/1899 設定為初始日期。"
+
 #. mznb9
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:403
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:453
 msgctxt "optcalculatepage|datesc10"
 msgid "01/01/1900 (Star_Calc 1.0)"
 msgstr "01/01/1900 (Star_Calc 1.0)"
 
 #. etLCb
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:407
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:457
 msgctxt "optcalculatepage|datesc10|tooltip_text"
 msgid "Value 0 corresponds to 01/01/1900"
 msgstr "值 0 對應至 01/01/1900"
 
+#. LEunE
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:464
+msgctxt "extended_tip|datesc10"
+msgid "Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries."
+msgstr "將 1/1/1900 設定為初始日期。對於含有日期條目的 StarCalc 1.0 試算表，請使用此設定。"
+
 #. J9ECM
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:420
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:475
 msgctxt "optcalculatepage|date1904"
 msgid "_01/01/1904"
 msgstr "_01/01/1904"
 
 #. aBzk5
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:424
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:479
 msgctxt "optcalculatepage|date1904|tooltip_text"
 msgid "0 corresponds to 01/01/1904"
 msgstr "0 對應至 01/01/1904"
 
+#. EkAYW
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:486
+msgctxt "extended_tip|date1904"
+msgid "Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format."
+msgstr "將 1/1/1904 設定為初始日期。對於以外來格式匯入的試算表，請使用此設定。"
+
 #. ggkEL
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:443
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:503
 msgctxt "optcalculatepage|label3"
 msgid "Date"
 msgstr "日期"
 
 #. Hd6CV
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:473
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:533
 msgctxt "optcalculatepage|formulawildcards"
 msgid "Enable w_ildcards in formulas"
 msgstr "公式中啟用萬用字元(_I)"
 
 #. BKAzW
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:477
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:537
 msgctxt "optcalculatepage|formulawildcards|tooltip_text"
 msgid "Enable wildcards for interoperability with Microsoft Excel"
 msgstr "啟用萬用字元以與 Microsoft Excel 相容"
 
+#. KXxjQ
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:544
+msgctxt "extended_tip|formulawildcards"
+msgid "Specifies that wildcards are enabled when searching and also for character string comparisons."
+msgstr ""
+
 #. Gghyb
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:490
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:555
 msgctxt "optcalculatepage|formularegex"
 msgid "Enable r_egular expressions in formulas"
 msgstr "公式中啟用常規表達式(_E)"
 
+#. D9B3G
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:565
+msgctxt "extended_tip|formularegex"
+msgid "Specifies that regular expressions instead of simple wildcards are enabled when searching and also for character string comparisons."
+msgstr ""
+
 #. gg3Am
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:506
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:576
 msgctxt "optcalculatepage|formulaliteral"
 msgid "No wildcards or regular expressions in formulas"
 msgstr "公式中沒有萬用字元或常規表述式"
 
+#. BwEWx
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:586
+msgctxt "extended_tip|formulaliteral"
+msgid "Specifies that only literal strings are used when searching and also for character string comparisons."
+msgstr ""
+
 #. 7QXFg
-#: sc/uiconfig/scalc/ui/optcalculatepage.ui:528
+#: sc/uiconfig/scalc/ui/optcalculatepage.ui:603
 msgctxt "optcalculatepage|label5"
 msgid "Formulas wildcards"
 msgstr "公式萬用字元"
 
 #. Umdv5
-#: sc/uiconfig/scalc/ui/optchangespage.ui:37
+#: sc/uiconfig/scalc/ui/optchangespage.ui:36
 msgctxt "optchangespage|label2"
 msgid "Chan_ges:"
 msgstr "變動(_G)："
 
 #. yrmgC
-#: sc/uiconfig/scalc/ui/optchangespage.ui:51
+#: sc/uiconfig/scalc/ui/optchangespage.ui:50
 msgctxt "optchangespage|label3"
 msgid "_Deletions:"
 msgstr "刪除(_D)："
 
 #. bJb2E
-#: sc/uiconfig/scalc/ui/optchangespage.ui:65
+#: sc/uiconfig/scalc/ui/optchangespage.ui:64
 msgctxt "optchangespage|label4"
 msgid "_Insertions:"
 msgstr "插入(_I)："
 
 #. ikfvj
-#: sc/uiconfig/scalc/ui/optchangespage.ui:79
+#: sc/uiconfig/scalc/ui/optchangespage.ui:78
 msgctxt "optchangespage|label5"
 msgid "_Moved entries:"
 msgstr "移動的條目(_M)："
 
+#. BiCsr
+#: sc/uiconfig/scalc/ui/optchangespage.ui:101
+msgctxt "extended_tip|changes"
+msgid "Specifies the color for changes of cell contents."
+msgstr ""
+
+#. NGpxf
+#: sc/uiconfig/scalc/ui/optchangespage.ui:123
+msgctxt "extended_tip|deletions"
+msgid "Specifies the color to highlight deletions in a document."
+msgstr ""
+
+#. XXK7D
+#: sc/uiconfig/scalc/ui/optchangespage.ui:145
+msgctxt "extended_tip|entries"
+msgid "Specifies the color to highlight moved cell contents."
+msgstr ""
+
+#. 67CPn
+#: sc/uiconfig/scalc/ui/optchangespage.ui:167
+msgctxt "extended_tip|insertions"
+msgid "Specifies the color to highlight insertions in a document."
+msgstr ""
+
 #. AYxhD
-#: sc/uiconfig/scalc/ui/optchangespage.ui:152
+#: sc/uiconfig/scalc/ui/optchangespage.ui:184
 msgctxt "optchangespage|label1"
 msgid "Colors for Changes"
 msgstr "變更處以彩色顯示"
 
+#. GyGpz
+#: sc/uiconfig/scalc/ui/optchangespage.ui:199
+msgctxt "extended_tip|OptChangesPage"
+msgid "The Changes dialog specifies various options for highlighting recorded changes in documents."
+msgstr ""
+
 #. CrAWh
 #: sc/uiconfig/scalc/ui/optcompatibilitypage.ui:41
 msgctxt "optcompatibilitypage|label2"
@@ -24384,6 +24528,12 @@ msgctxt "optcompatibilitypage|label1"
 msgid "Key Bindings"
 msgstr "組合鍵"
 
+#. Z7mEE
+#: sc/uiconfig/scalc/ui/optcompatibilitypage.ui:93
+msgctxt "extended_tip|OptCompatibilityPage"
+msgid "Defines compatibility options for %PRODUCTNAME Calc."
+msgstr ""
+
 #. Jcvih
 #: sc/uiconfig/scalc/ui/optdefaultpage.ui:39
 msgctxt "optdefaultpage|textsheetsnumber"
@@ -24408,36 +24558,60 @@ msgctxt "optdefaultpage|label1"
 msgid "New Spreadsheet"
 msgstr "新試算表"
 
-#. gbrKD
-#: sc/uiconfig/scalc/ui/optdlg.ui:30
-msgctxt "optdlg|suppressCB"
-msgid "_Suppress output of empty pages"
-msgstr "不列印空白頁面(_S)"
+#. Ap57D
+#: sc/uiconfig/scalc/ui/optdefaultpage.ui:126
+msgctxt "extended_tip|OptDefaultPage"
+msgid "Defines default settings for new spreadsheet documents."
+msgstr ""
 
 #. TueVT
-#: sc/uiconfig/scalc/ui/optdlg.ui:46
+#: sc/uiconfig/scalc/ui/optdlg.ui:31
 msgctxt "optdlg|forceBreaksCB"
 msgid "_Always apply manual breaks"
 msgstr "總是套用手動分隔處(_A)"
 
+#. gbrKD
+#: sc/uiconfig/scalc/ui/optdlg.ui:47
+msgctxt "optdlg|suppressCB"
+msgid "_Suppress output of empty pages"
+msgstr "不列印空白頁面(_S)"
+
+#. 6chh5
+#: sc/uiconfig/scalc/ui/optdlg.ui:56
+msgctxt "extended_tip|suppressCB"
+msgid "Specifies that empty pages that have no cell contents or draw objects are not printed."
+msgstr ""
+
 #. udgBk
-#: sc/uiconfig/scalc/ui/optdlg.ui:68
+#: sc/uiconfig/scalc/ui/optdlg.ui:74
 msgctxt "optdlg|label1"
 msgid "Pages"
 msgstr "頁面"
 
 #. nfmkw
-#: sc/uiconfig/scalc/ui/optdlg.ui:101
+#: sc/uiconfig/scalc/ui/optdlg.ui:107
 msgctxt "optdlg|printCB"
 msgid "_Print only selected sheets"
 msgstr "僅列印選取的工作表(_P)"
 
+#. Cqsrk
+#: sc/uiconfig/scalc/ui/optdlg.ui:116
+msgctxt "extended_tip|printCB"
+msgid "Specifies that only contents from selected sheets are printed, even if you specify a wider range in the File - Print dialog or in the Format - Print Ranges dialog. Contents from sheets that are not selected will not be printed."
+msgstr ""
+
 #. wT6PN
-#: sc/uiconfig/scalc/ui/optdlg.ui:124
+#: sc/uiconfig/scalc/ui/optdlg.ui:134
 msgctxt "optdlg|label2"
 msgid "Sheets"
 msgstr "工作表"
 
+#. JptgQ
+#: sc/uiconfig/scalc/ui/optdlg.ui:150
+msgctxt "extended_tip|optCalcPrintPage"
+msgid "Determines the printer settings for spreadsheets."
+msgstr "確定試算表的印表機設定。"
+
 #. nQBpo
 #: sc/uiconfig/scalc/ui/optformula.ui:30
 msgctxt "optformula|englishfuncname"
@@ -24564,6 +24738,12 @@ msgctxt "optformula|label3"
 msgid "Separators"
 msgstr "分隔符"
 
+#. Pk6nr
+#: sc/uiconfig/scalc/ui/optformula.ui:440
+msgctxt "extended_tip|OptFormula"
+msgid "Defines formula syntax options and loading options for %PRODUCTNAME Calc."
+msgstr ""
+
 #. cCfAk
 #: sc/uiconfig/scalc/ui/optimalcolwidthdialog.ui:8
 msgctxt "optimalcolwidthdialog|OptimalColWidthDialog"
@@ -24606,54 +24786,96 @@ msgctxt "optsortlists|copy"
 msgid "_Copy"
 msgstr "複製(_C)"
 
+#. FprUE
+#: sc/uiconfig/scalc/ui/optsortlists.ui:37
+msgctxt "extended_tip|copy"
+msgid "Copies the contents of the cells in the Copy list from box. If you select a reference to related rows and columns, the Copy List dialog appears after clicking the button. You can use this dialog to define if the reference is converted to sort lists by row or by column."
+msgstr ""
+
 #. jG3HS
-#: sc/uiconfig/scalc/ui/optsortlists.ui:51
+#: sc/uiconfig/scalc/ui/optsortlists.ui:56
 msgctxt "optsortlists|copyfromlabel"
 msgid "Copy list _from:"
 msgstr "複製清單自(_F)："
 
+#. QEyMs
+#: sc/uiconfig/scalc/ui/optsortlists.ui:75
+msgctxt "extended_tip|copyfrom"
+msgid "Defines the spreadsheet and the cells to copy, in order to include them in the Lists box. The currently selected range in the spreadsheet is the default."
+msgstr ""
+
 #. iCaLd
-#: sc/uiconfig/scalc/ui/optsortlists.ui:94
+#: sc/uiconfig/scalc/ui/optsortlists.ui:104
 msgctxt "optsortlists|listslabel"
 msgid "_Lists"
 msgstr "清單(_L)"
 
 #. EBMmZ
-#: sc/uiconfig/scalc/ui/optsortlists.ui:108
+#: sc/uiconfig/scalc/ui/optsortlists.ui:118
 msgctxt "optsortlists|entrieslabel"
 msgid "_Entries"
 msgstr "條目(_E)"
 
+#. qqKLe
+#: sc/uiconfig/scalc/ui/optsortlists.ui:160
+msgctxt "extended_tip|lists"
+msgid "Displays all the available lists. These lists can be selected for editing."
+msgstr ""
+
+#. esSFN
+#: sc/uiconfig/scalc/ui/optsortlists.ui:184
+msgctxt "extended_tip|entries"
+msgid "Displays the content of the currently selected list. This content can be edited."
+msgstr ""
+
 #. GcE5C
-#: sc/uiconfig/scalc/ui/optsortlists.ui:190
+#: sc/uiconfig/scalc/ui/optsortlists.ui:210
 msgctxt "optsortlists|new"
 msgid "_New"
 msgstr "新增(_N)"
 
+#. uH79F
+#: sc/uiconfig/scalc/ui/optsortlists.ui:217
+msgctxt "extended_tip|new"
+msgid "Enters the contents of a new list into the Entries box."
+msgstr ""
+
 #. wETY5
-#: sc/uiconfig/scalc/ui/optsortlists.ui:204
+#: sc/uiconfig/scalc/ui/optsortlists.ui:229
 msgctxt "optsortlists|discard"
 msgid "_Discard"
 msgstr "丟棄(_D)"
 
 #. KiBRx
-#: sc/uiconfig/scalc/ui/optsortlists.ui:218
+#: sc/uiconfig/scalc/ui/optsortlists.ui:243
 msgctxt "optsortlists|add"
 msgid "_Add"
 msgstr "新增(_A)"
 
+#. pZWBh
+#: sc/uiconfig/scalc/ui/optsortlists.ui:250
+msgctxt "extended_tip|add"
+msgid "Adds a new list into the Lists box."
+msgstr ""
+
 #. yADBm
-#: sc/uiconfig/scalc/ui/optsortlists.ui:232
+#: sc/uiconfig/scalc/ui/optsortlists.ui:262
 msgctxt "optsortlists|modify"
 msgid "Modif_y"
 msgstr "修改(_Y)"
 
 #. yN2Fo
-#: sc/uiconfig/scalc/ui/optsortlists.ui:246
+#: sc/uiconfig/scalc/ui/optsortlists.ui:276
 msgctxt "optsortlists|delete"
 msgid "_Delete"
 msgstr "刪除(_D)"
 
+#. L7EBD
+#: sc/uiconfig/scalc/ui/optsortlists.ui:303
+msgctxt "extended_tip|OptSortLists"
+msgid "All user-defined lists are displayed in the Sort Lists dialog. You can also define and edit your own lists. Only text can be used as sort lists, no numbers."
+msgstr ""
+
 #. U2gkF
 #: sc/uiconfig/scalc/ui/pagetemplatedialog.ui:8
 msgctxt "pagetemplatedialog|PageTemplateDialog"
@@ -25920,116 +26142,182 @@ msgctxt "scgeneralpage|label5"
 msgid "_Tab stops:"
 msgstr "定位落點(_T)："
 
+#. akEMb
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:72
+msgctxt "extended_tip|tabmf"
+msgid "Defines the tab stops distance."
+msgstr ""
+
+#. iwwhu
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:87
+msgctxt "extended_tip|unitlb"
+msgid "Defines the unit of measure in spreadsheets."
+msgstr ""
+
 #. zzQpA
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:94
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:104
 msgctxt "scgeneralpage|label1"
 msgid "Metrics"
 msgstr "字型尺度"
 
 #. ZbcRD
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:127
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:137
 msgctxt "scgeneralpage|alwaysrb"
 msgid "_Always (from trusted locations)"
 msgstr "總是 (取自信任的位置)(_A)"
 
 #. 3baZU
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:144
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:154
 msgctxt "scgeneralpage|requestrb"
 msgid "_On request"
 msgstr "根據要求(_O)"
 
 #. AESok
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:162
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:172
 msgctxt "scgeneralpage|neverrb"
 msgid "_Never"
 msgstr "永不(_N)"
 
 #. GDxLR
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:186
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:196
 msgctxt "scgeneralpage|label6"
 msgid "Update links when opening"
 msgstr "開啟檔案時更新連結"
 
 #. GGhDQ
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:220
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:230
 msgctxt "scgeneralpage|editmodecb"
 msgid "Press Enter to switch to _edit mode"
 msgstr "按下 Enter 鍵切換至編輯模式(_E)"
 
+#. qVJpA
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:239
+msgctxt "extended_tip|editmodecb"
+msgid "Allows you to immediately edit the selected cell after pressing the Enter key."
+msgstr ""
+
 #. zzFGH
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:236
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:251
 msgctxt "scgeneralpage|formatcb"
 msgid "Expand _formatting"
 msgstr "擴展格式設定(_F)"
 
+#. 8fqgH
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:260
+msgctxt "extended_tip|formatcb"
+msgid "Specifies whether to automatically apply the formatting attributes of the selected cell to the empty adjacent cells."
+msgstr ""
+
 #. AzkVC
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:252
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:272
 msgctxt "scgeneralpage|exprefcb"
 msgid "Expand _references when new columns/rows are inserted"
 msgstr "當插入欄/列時擴展參照(_R)"
 
+#. yybGX
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:281
+msgctxt "extended_tip|exprefcb"
+msgid "Specifies whether to expand references when inserting columns or rows adjacent to the reference range. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction."
+msgstr ""
+
 #. 6oRpB
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:273
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:298
 msgctxt "scgeneralpage|alignlb"
 msgid "Down"
 msgstr "下"
 
 #. tC8Do
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:274
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:299
 msgctxt "scgeneralpage|alignlb"
 msgid "Right"
 msgstr "右"
 
 #. AAUJ2
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:275
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:300
 msgctxt "scgeneralpage|alignlb"
 msgid "Up"
 msgstr "上"
 
 #. p9JAq
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:276
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:301
 msgctxt "scgeneralpage|alignlb"
 msgid "Left"
 msgstr "左"
 
+#. 2dTCJ
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:305
+msgctxt "extended_tip|alignlb"
+msgid "Determines the direction that the cursor in the spreadsheet will move after you press the Enter key."
+msgstr ""
+
 #. dnDdz
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:286
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:316
 msgctxt "scgeneralpage|aligncb"
 msgid "Press Enter to _move selection"
 msgstr "按下 Enter 鍵移動選取項(_M)"
 
 #. UStnu
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:301
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:331
 msgctxt "scgeneralpage|legacy_cell_selection_cb"
 msgid "Position cell reference with selection"
 msgstr "以選取區域作儲存格參照定位"
 
+#. zwsR4
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:340
+msgctxt "extended_tip|legacy_cell_selection_cb"
+msgid ""
+"With the option set, expanding a selection (with Command\n"
+"  Ctrl  +Shift+Down/Up) jumps to the end of the range in the column that was added as last to the initial selection.\n"
+" When the option is not set, expanding a selection (with CommandCtrl+Shift\n"
+"  +Down/Up) jumps to the end of the range in the column where selecting the cell range was started.\n"
+" The same of course applies when extending a selection on rows, with CommandCtrl+\n"
+"  Shift+Left/Right."
+msgstr ""
+
 #. S2fGF
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:317
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:357
 msgctxt "scgeneralpage|replwarncb"
 msgid "Show overwrite _warning when pasting data"
 msgstr "貼上資料時顯示覆寫警告(_W)"
 
+#. yDGPC
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:366
+msgctxt "extended_tip|replwarncb"
+msgid "Specifies that, when you paste cells from the clipboard to a cell range that is not empty, a warning appears."
+msgstr ""
+
 #. LFenu
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:333
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:378
 msgctxt "scgeneralpage|textfmtcb"
 msgid "Use printer metrics for text formatting"
 msgstr "文字格式設定使用印表機字型尺度"
 
+#. ECUd7
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:386
+msgctxt "extended_tip|textfmtcb"
+msgid "Specifies that printer metrics are applied for printing and also for formatting the display on the screen."
+msgstr "指定列印以及格式化螢幕上的顯示所套用的印表機字型尺度。"
+
 #. zW9SZ
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:348
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:398
 msgctxt "scgeneralpage|markhdrcb"
 msgid "Highlight sele_ction in column/row headers"
 msgstr "色彩標明欄標列號中的選取項(_C)"
 
+#. payBv
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:407
+msgctxt "extended_tip|markhdrcb"
+msgid "Specifies whether to highlight column and row headers in the selected columns or rows."
+msgstr ""
+
 #. KGWyE
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:364
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:419
 msgctxt "scgeneralpage|sortrefupdatecb"
 msgid "Update references when sorting range of cells"
 msgstr "排序儲存格的範圍時更新參照"
 
 #. M9G8o
-#: sc/uiconfig/scalc/ui/scgeneralpage.ui:385
+#: sc/uiconfig/scalc/ui/scgeneralpage.ui:440
 msgctxt "scgeneralpage|label3"
 msgid "Input Settings"
 msgstr "輸入設定"
@@ -26614,73 +26902,73 @@ msgstr "邊框線條樣式"
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:73
 msgctxt "sidebarnumberformat|numberformatcombobox|tooltip_text"
 msgid "Select a category of contents."
-msgstr ""
+msgstr "選取內容的類別。"
 
 #. EeECn
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:77
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "General"
-msgstr ""
+msgstr "一般"
 
 #. SmpsG
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:78
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Number"
-msgstr ""
+msgstr "數字"
 
 #. 8FGeM
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:79
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Percent"
-msgstr ""
+msgstr "百分比"
 
 #. bHC79
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:80
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Currency"
-msgstr ""
+msgstr "貨幣"
 
 #. Lh2G6
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:81
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Date "
-msgstr ""
+msgstr "日期 "
 
 #. EUCxB
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:82
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Time"
-msgstr ""
+msgstr "時間"
 
 #. EukSF
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:83
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Scientific"
-msgstr ""
+msgstr "科學"
 
 #. AQV5y
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:84
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Fraction"
-msgstr ""
+msgstr "分數"
 
 #. kQGBu
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:85
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Boolean Value"
-msgstr ""
+msgstr "布林值"
 
 #. Gv2sX
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:86
 msgctxt "sidebarnumberformat|numberformatcombobox"
 msgid "Text"
-msgstr ""
+msgstr "文字"
 
 #. ypKG8
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:90
 msgctxt "sidebarnumberformat|numberformatcombobox-atkobject"
 msgid "Category"
-msgstr ""
+msgstr "類別"
 
 #. FqFzG
 #: sc/uiconfig/scalc/ui/sidebarnumberformat.ui:122
@@ -28236,210 +28524,336 @@ msgctxt "tpviewpage|formula"
 msgid "_Formulas"
 msgstr "公式(_F)"
 
+#. NZfqW
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:42
+msgctxt "extended_tip|formula"
+msgid "Specifies whether to show formulas instead of results in the cells."
+msgstr ""
+
 #. a9dGg
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:48
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:53
 msgctxt "tpviewpage|nil"
 msgid "Zero val_ues"
 msgstr "零值(_U)"
 
+#. p3GbC
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:62
+msgctxt "extended_tip|nil"
+msgid "Specifies whether to show numbers with the value of 0."
+msgstr ""
+
 #. CVAZD
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:63
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:73
 msgctxt "tpviewpage|annot"
 msgid "_Comment indicator"
 msgstr "評註指示標記(_C)"
 
+#. gbz6Y
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:82
+msgctxt "extended_tip|annot"
+msgid "Specifies that a small rectangle in the top right corner of the cell indicates that a comment exists. The comment will be shown only when you enable tips under %PRODUCTNAME - General in the Options dialog box."
+msgstr ""
+
 #. G6GjE
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:78
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:93
 msgctxt "tpviewpage|value"
 msgid "Value h_ighlighting"
 msgstr "數值色彩標明(_I)"
 
+#. Ve6Bg
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:102
+msgctxt "extended_tip|value"
+msgid "Mark the Value highlighting box to show the cell contents in different colors, depending on type. Text cells are formatted in black, formulas in green, number cells in blue, and protected cells are shown with light grey background, no matter how their display is formatted."
+msgstr ""
+
 #. ah84V
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:93
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:113
 msgctxt "tpviewpage|anchor"
 msgid "_Anchor"
 msgstr "錨定(_A)"
 
+#. B5SJi
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:122
+msgctxt "extended_tip|anchor"
+msgid "Specifies whether the anchor icon is displayed when an inserted object, such as a graphic, is selected."
+msgstr ""
+
 #. XBGqd
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:108
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:133
 msgctxt "tpviewpage|clipmark"
 msgid "Te_xt overflow"
 msgstr "文字溢位(_X)"
 
+#. qSy8Z
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:142
+msgctxt "extended_tip|clipmark"
+msgid "If a cell contains text that is wider than the width of the cell, the text is displayed over empty neighboring cells in the same row. If there is no empty neighboring cell, a small triangle at the cell border indicates that the text continues."
+msgstr ""
+
 #. aqEWS
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:123
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:153
 msgctxt "tpviewpage|rangefind"
 msgid "_Show references in color"
 msgstr "用彩色顯示參照(_S)"
 
+#. hSxKG
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:162
+msgctxt "extended_tip|rangefind"
+msgid "Specifies that each reference is highlighted in color in the formula. The cell range is also enclosed by a colored border as soon as the cell containing the reference is selected for editing."
+msgstr ""
+
 #. qtccR
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:144
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:179
 msgctxt "tpviewpage|label4"
 msgid "Display"
 msgstr "顯示"
 
 #. oCEpm
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:174
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:209
 msgctxt "tpviewpage|rowcolheader"
 msgid "Colu_mn/row headers"
 msgstr "欄標列號(_M)"
 
+#. sF7Bk
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:218
+msgctxt "extended_tip|rowcolheader"
+msgid "Specifies whether to display row and column headers."
+msgstr ""
+
 #. WAwjG
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:189
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:229
 msgctxt "tpviewpage|hscroll"
 msgid "Hori_zontal scroll bar"
 msgstr "水平捲軸列(_Z)"
 
+#. EpixW
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:238
+msgctxt "extended_tip|hscroll"
+msgid "Specifies whether to display a horizontal scrollbar at the bottom of the document window."
+msgstr ""
+
 #. PZvCk
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:204
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:249
 msgctxt "tpviewpage|vscroll"
 msgid "_Vertical scroll bar"
 msgstr "垂直捲軸列(_V)"
 
+#. yhyGB
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:258
+msgctxt "extended_tip|vscroll"
+msgid "Specifies whether to display a vertical scrollbar at the right of the document window."
+msgstr ""
+
 #. rPmMd
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:219
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:269
 msgctxt "tpviewpage|tblreg"
 msgid "Sh_eet tabs"
 msgstr "工作表標籤(_E)"
 
+#. aBrX6
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:278
+msgctxt "extended_tip|tblreg"
+msgid "Specifies whether to display the sheet tabs at the bottom of the spreadsheet document."
+msgstr ""
+
 #. WJSnC
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:234
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:289
 msgctxt "tpviewpage|outline"
 msgid "_Outline symbols"
 msgstr "大綱符號(_O)"
 
+#. hhB5n
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:298
+msgctxt "extended_tip|outline"
+msgid "If you have defined an outline, the Outline symbols option specifies whether to view the outline symbols at the border of the sheet."
+msgstr ""
+
 #. jJ4uB
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:249
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:309
 msgctxt "tpviewpage|summary"
 msgid "Summary o_n search"
 msgstr "搜尋摘要(_N)"
 
 #. Ws4Ev
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:271
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:331
 msgctxt "tpviewpage|label5"
 msgid "Window"
 msgstr "視窗"
 
 #. g4FQY
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:297
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:357
 msgctxt "tpviewpage|synczoom"
 msgid "S_ynchronize sheets"
 msgstr "同步工作表(_Y)"
 
+#. C5GAq
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:366
+msgctxt "extended_tip|synczoom"
+msgid "If checked, all sheets are shown with the same zoom factor. If not checked, each sheet can have its own zoom factor."
+msgstr "若核取此選項，則所有試算表將以相同的縮放係數顯示。若未核取，則每個試算表有各自的縮放係數。"
+
 #. pEFjC
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:312
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:377
 msgctxt "tpviewpage|label3"
 msgid "Zoom"
 msgstr "遠近調整"
 
+#. yajBD
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:424
+msgctxt "extended_tip|color"
+msgid "Specifies a color for the grid lines in the current document."
+msgstr ""
+
 #. bF3Yr
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:368
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:437
 msgctxt "tpviewpage|grid_label"
 msgid "_Grid lines:"
 msgstr "格線(_G)："
 
 #. E2U6D
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:382
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:451
 msgctxt "tpviewpage|color_label"
 msgid "_Color:"
 msgstr "色彩(_C)："
 
 #. BUibB
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:397
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:466
 msgctxt "tpviewpage|grid"
 msgid "Show"
 msgstr "顯示"
 
 #. GXPYd
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:398
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:467
 msgctxt "tpviewpage|grid"
 msgid "Show on colored cells"
 msgstr "顯示於上色的儲存格"
 
 #. ucTDZ
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:399
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:468
 msgctxt "tpviewpage|grid"
 msgid "Hide"
 msgstr "隱藏"
 
+#. vFtNT
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:472
+msgctxt "extended_tip|grid"
+msgid "Specifies when grid lines will be displayed. Default is to display grid lines only on cells that do not have a background color. You can choose to also display grid lines on cells with background color, or to hide them."
+msgstr ""
+
 #. ShHLd
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:415
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:489
 msgctxt "tpviewpage|break"
 msgid "_Page breaks"
 msgstr "分頁(_P)"
 
+#. Vc5tW
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:498
+msgctxt "extended_tip|break"
+msgid "Specifies whether to view the page breaks within a defined print area."
+msgstr ""
+
 #. xkuBL
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:430
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:509
 msgctxt "tpviewpage|guideline"
 msgid "Helplines _while moving"
 msgstr "移動時採用輔助線(_W)"
 
+#. KGEQG
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:518
+msgctxt "extended_tip|guideline"
+msgid "Specifies whether to view guides when moving drawings, frames, graphics and other objects."
+msgstr ""
+
 #. Cb4AM
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:451
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:535
 msgctxt "tpviewpage|label1"
 msgid "Visual Aids"
 msgstr "視覺輔助"
 
 #. Qd5Rp
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:485
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:569
 msgctxt "tpviewpage|objgrf_label"
 msgid "Ob_jects/Images:"
 msgstr "物件/影像(_J)："
 
 #. BCaDn
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:499
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:583
 msgctxt "tpviewpage|diagram_label"
 msgid "Cha_rts:"
 msgstr "圖表(_R)："
 
 #. q544D
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:513
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:597
 msgctxt "tpviewpage|draw_label"
 msgid "_Drawing objects:"
 msgstr "繪圖物件(_D)："
 
 #. mpELg
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:528
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:612
 msgctxt "tpviewpage|objgrf"
 msgid "Show"
 msgstr "顯示"
 
 #. Kx6yJ
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:529
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:613
 msgctxt "tpviewpage|objgrf"
 msgid "Hide"
 msgstr "隱藏"
 
+#. oKpbX
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:617
+msgctxt "extended_tip|objgrf"
+msgid "Defines if objects and graphics are shown or hidden."
+msgstr ""
+
 #. wFBeZ
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:542
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:631
 msgctxt "tpviewpage|diagram"
 msgid "Show"
 msgstr "顯示"
 
 #. H7MAB
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:543
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:632
 msgctxt "tpviewpage|diagram"
 msgid "Hide"
 msgstr "隱藏"
 
+#. oVE9C
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:636
+msgctxt "extended_tip|diagram"
+msgid "Defines if charts in your document are shown or hidden."
+msgstr ""
+
 #. YaiTQ
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:556
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:650
 msgctxt "tpviewpage|draw"
 msgid "Show"
 msgstr "顯示"
 
 #. DST5a
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:557
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:651
 msgctxt "tpviewpage|draw"
 msgid "Hide"
 msgstr "隱藏"
 
+#. FDGKD
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:655
+msgctxt "extended_tip|draw"
+msgid "Defines if drawing objects in your document are shown or hidden."
+msgstr ""
+
 #. E6GxC
-#: sc/uiconfig/scalc/ui/tpviewpage.ui:573
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:672
 msgctxt "tpviewpage|label2"
 msgid "Objects"
 msgstr "物件"
 
+#. aFAnX
+#: sc/uiconfig/scalc/ui/tpviewpage.ui:696
+msgctxt "extended_tip|TpViewPage"
+msgid "Defines which elements of the %PRODUCTNAME Calc main window are displayed. You can also show or hide highlighting of values in tables."
+msgstr ""
+
 #. AnLEa
 #: sc/uiconfig/scalc/ui/ttestdialog.ui:102
 msgctxt "ttestdialog|variable1-range-label"
@@ -28684,19 +29098,19 @@ msgstr "錯誤警告"
 #: sc/uiconfig/scalc/ui/validationhelptabpage-mobile.ui:15
 msgctxt "validationhelptabpage-mobile|tsbhelp"
 msgid "_Show input help when cell is selected"
-msgstr ""
+msgstr "當選取儲存格時顯示輸入說明(_S)"
 
 #. ZJEXj
 #: sc/uiconfig/scalc/ui/validationhelptabpage-mobile.ui:55
 msgctxt "validationhelptabpage-mobile|title_label"
 msgid "_Title:"
-msgstr ""
+msgstr "標題(_T)："
 
 #. yDRCK
 #: sc/uiconfig/scalc/ui/validationhelptabpage-mobile.ui:69
 msgctxt "validationhelptabpage-mobile|inputhelp_label"
 msgid "_Input help:"
-msgstr ""
+msgstr "輸入說明(_I)："
 
 #. 4etq8
 #: sc/uiconfig/scalc/ui/validationhelptabpage.ui:15
@@ -28708,7 +29122,7 @@ msgstr "在選取儲存格時顯示輸入說明(_S)"
 #: sc/uiconfig/scalc/ui/validationhelptabpage.ui:71
 msgctxt "validationhelptabpage|title_label"
 msgid "_Title:"
-msgstr "題名(_T)："
+msgstr "標題(_T)："
 
 #. EHf6R
 #: sc/uiconfig/scalc/ui/validationhelptabpage.ui:85