summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/scalc/01.po219
1 files changed, 186 insertions, 33 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/scalc/01.po b/source/zh-TW/helpcontent2/source/text/scalc/01.po
index 65fa2df6614..0511a8d299c 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: 2022-02-18 12:17+0100\n"
+"POT-Creation-Date: 2022-04-01 00:19+0200\n"
"PO-Revision-Date: 2020-12-31 12:36+0000\n"
"Last-Translator: serval2412 <serval2412@yahoo.fr>\n"
"Language-Team: Chinese (Traditional) <https://translations.documentfoundation.org/projects/libo_help-master/textscalc01/zh_Hant/>\n"
@@ -15235,13 +15235,13 @@ msgctxt ""
msgid "RANDBETWEEN.NV(Bottom; Top)"
msgstr ""
-#. q82vw
+#. Cwb6C
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id91590242400917\n"
"help.text"
-msgid "Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated."
+msgid "Returns an non-volatile integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive). A non-volatile function is not recalculated at new input events or pressing <keycode>F9</keycode>. However, the function is recalculated when pressing <keycode>F9</keycode> with the cursor on the cell containing the function, when opening the file, when using the <link href=\"text/scalc/01/recalculate_hard.xhp\" name=\"recalculate hard\"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>) and when <emph>Top</emph> or <emph>Bottom</emph> are recalculated."
msgstr ""
#. AngvN
@@ -15388,13 +15388,13 @@ msgctxt ""
msgid "RAND.NV()"
msgstr ""
-#. QARNV
+#. G5FWM
#: 04060106.xhp
msgctxt ""
"04060106.xhp\n"
"par_id271590239748534\n"
"help.text"
-msgid "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function. The function is recalculated when opening the file."
+msgid "This function produces a non-volatile random number on input. A non-volatile function is not recalculated at new input events. The function does not recalculate when pressing <keycode>F9</keycode>, except when the cursor is on the cell containing the function or using the <link href=\"text/scalc/01/recalculate_hard.xhp\" name=\"recalculate hard\"><menuitem>Recalculate Hard</menuitem></link> command (<keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode>). The function is recalculated when opening the file."
msgstr ""
#. sCwno
@@ -46852,49 +46852,31 @@ msgctxt ""
msgid "<ahelp hid=\".uno:Calculate\">In either mode, with formula cell(s) selected pressing F9 recalculates the currently selected cells and formula cells that depend on them. This can be useful after reading documents with recalculation disabled and individual cells need recalculation.</ahelp>"
msgstr ""
-#. jVUni
+#. g7GEo
#: 06080000.xhp
msgctxt ""
"06080000.xhp\n"
"par_id315475899\n"
"help.text"
-msgid "Press F9 to recalculate. Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document."
-msgstr "按 F9 鍵即可重新計算。按 Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 組合鍵,即可重新計算文件中的所有公式。"
-
-#. wosFk
-#: 06080000.xhp
-msgctxt ""
-"06080000.xhp\n"
-"par_id3150793\n"
-"help.text"
-msgid "Recalculation options are, Recalculation on File Load, with values:"
+msgid "Press <keycode>F9</keycode> to recalculate. Press <keycode>Shift</keycode>+<switchinline select=\"sys\"><caseinline select=\"MAC\"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline>+<keycode>F9</keycode> to recalculate all formulas in the document, including Add-In functions and non-volatile functions."
msgstr ""
-#. Cr8g8
-#: 06080000.xhp
-msgctxt ""
-"06080000.xhp\n"
-"par_id3150795\n"
-"help.text"
-msgid "Always recalculate, Never recalculate (default option), Prompt user."
-msgstr ""
-
-#. TCBFm
+#. qyZ6P
#: 06080000.xhp
msgctxt ""
"06080000.xhp\n"
-"par_id315475855\n"
+"par_id3150799\n"
"help.text"
-msgid "Press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9 to recalculate all formulas in the document, including Add-In functions. The hard recalculation correctly recalculates all formula cells."
+msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
msgstr ""
-#. qyZ6P
+#. a9keX
#: 06080000.xhp
msgctxt ""
"06080000.xhp\n"
-"par_id3150799\n"
+"par_id641645233417894\n"
"help.text"
-msgid "After the document has been recalculated, the display is refreshed. All charts are also refreshed."
+msgid "<link href=\"text/shared/optionen/01060900.xhp\" name=\"recalculationoptions\">Recalculation options</link>"
msgstr ""
#. CWRgk
@@ -52666,13 +52648,22 @@ msgctxt ""
msgid "<link href=\"text/scalc/01/calculate.xhp\" name=\"Calculate\">Calculate</link>"
msgstr ""
-#. CFB7A
+#. 8YGcD
#: calculate.xhp
msgctxt ""
"calculate.xhp\n"
"par_id241584668179318\n"
"help.text"
-msgid "<ahelp hid=\".\">Commands to calculate formula cells.</ahelp>"
+msgid "Commands to calculate formula cells."
+msgstr ""
+
+#. f2aRJ
+#: calculate.xhp
+msgctxt ""
+"calculate.xhp\n"
+"par_id251645222672072\n"
+"help.text"
+msgid "Choose <menuitem>Data - Calculate</menuitem>"
msgstr ""
#. 9AbDs
@@ -54430,6 +54421,51 @@ msgctxt ""
msgid "<ahelp hid=\".\">Switches <emph>Edit Points</emph> mode for an inserted freeform line on and off.</ahelp>"
msgstr "<ahelp hid=\".\">開啟和關閉所插入自由形曲線的 <emph>[編輯點]</emph> 模式。</ahelp>"
+#. 363bk
+#: formula2value.xhp
+msgctxt ""
+"formula2value.xhp\n"
+"tit\n"
+"help.text"
+msgid "Formula to values"
+msgstr ""
+
+#. tthof
+#: formula2value.xhp
+msgctxt ""
+"formula2value.xhp\n"
+"bm_id321645231251889\n"
+"help.text"
+msgid "<bookmark_value>convert;formula to values</bookmark_value><bookmark_value>replace formula with values</bookmark_value><bookmark_value>recalculate;formula to values</bookmark_value><bookmark_value>formula to values;convert</bookmark_value><bookmark_value>formula to values;recalculate</bookmark_value>"
+msgstr ""
+
+#. u3A5z
+#: formula2value.xhp
+msgctxt ""
+"formula2value.xhp\n"
+"hd_id701645222861113\n"
+"help.text"
+msgid "<variable id=\"formula2valueh1\"><link href=\"text/scalc/01/formula2value.xhp\" name=\"formula to values\">Formula to value</link></variable>"
+msgstr ""
+
+#. CATpt
+#: formula2value.xhp
+msgctxt ""
+"formula2value.xhp\n"
+"par_id501645222861116\n"
+"help.text"
+msgid "Replaces the formula cell with value calculated by the formula. The formula is lost."
+msgstr ""
+
+#. AKrcm
+#: formula2value.xhp
+msgctxt ""
+"formula2value.xhp\n"
+"par_id51645230882532\n"
+"help.text"
+msgid "Use this command to convert formula cells into data cells. The converted cells contents becomes static and will not be recalculated."
+msgstr ""
+
#. ebLBc
#: ful_func.xhp
msgctxt ""
@@ -67444,6 +67480,123 @@ msgctxt ""
msgid "Limit the maximum numbers of rows to a specified value or leave undefined, but limited to the %PRODUCTNAME Calc row limit."
msgstr ""
+#. AWPkL
+#: recalculate_hard.xhp
+msgctxt ""
+"recalculate_hard.xhp\n"
+"tit\n"
+"help.text"
+msgid "Recalculate hard"
+msgstr ""
+
+#. EB6vW
+#: recalculate_hard.xhp
+msgctxt ""
+"recalculate_hard.xhp\n"
+"bm_id351645231629404\n"
+"help.text"
+msgid "<bookmark_value>calculate;recalculate hard</bookmark_value> <bookmark_value>formulas;recalculate hard</bookmark_value> <bookmark_value>calculate;force recalculation</bookmark_value> <bookmark_value>formulas;force recalculation</bookmark_value> <bookmark_value>non volatile functions;force recalculation</bookmark_value> <bookmark_value>cell contents;force recalculation</bookmark_value>"
+msgstr ""
+
+#. WXR6C
+#: recalculate_hard.xhp
+msgctxt ""
+"recalculate_hard.xhp\n"
+"hd_id611645217532285\n"
+"help.text"
+msgid "<variable id=\"recalculatehardh1\"><link href=\"text/scalc/01/recalculate_hard.xhp\" name=\"recalculate hard\">Recalculate Hard</link></variable>"
+msgstr ""
+
+#. gCAFM
+#: recalculate_hard.xhp
+msgctxt ""
+"recalculate_hard.xhp\n"
+"par_id631645217532291\n"
+"help.text"
+msgid "Recalculates all formulas in the document, including Add-In functions and non-volatile functions."
+msgstr ""
+
+#. uDfgm
+#: recalculate_hard.xhp
+msgctxt ""
+"recalculate_hard.xhp\n"
+"par_id361645227084327\n"
+"help.text"
+msgid "The <menuitem>Recalculate Hard</menuitem> command forces recalculation of all formula cells of the spreadsheet document, including explicit non-volatile functions, even if no new input event exist. Examples of explicit non-volatile functions are <link href=\"text/scalc/01/04060106.xhp#rand_nv\" name=\"RAND.NV\">RAND.NV</link> and <link href=\"text/scalc/01/04060106.xhp#randbetween_nv\" name=\"RANDBETWEEN.NV\">RANDBETWEEN.NV</link>."
+msgstr ""
+
+#. t5LiZ
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"tit\n"
+"help.text"
+msgid "Sharing Spreadsheets"
+msgstr ""
+
+#. nGSyy
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"bm_id671647274159909\n"
+"help.text"
+msgid "<bookmark_value>share spreadsheet</bookmark_value> <bookmark_value>spreadsheet;collaboration</bookmark_value> <bookmark_value>spreadsheet;share</bookmark_value>"
+msgstr ""
+
+#. 3vzpA
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"hd_id461647272004705\n"
+"help.text"
+msgid "<variable id=\"h1\"><link href=\"text/scalc/01/shared_spreadsheet.xhp\" name=\"Share spreadsheet\">Share Spreadsheet</link></variable>"
+msgstr ""
+
+#. KZGLG
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"par_id551647272004709\n"
+"help.text"
+msgid "Sharing a spreadsheet allows several users to open the same file for editing at the same time."
+msgstr ""
+
+#. 9BuYS
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"par_id211647275285230\n"
+"help.text"
+msgid "The spreadsheet needs to be on a shared drive, server, website, or similar. Some conditions must be met on operating systems with user permission management:"
+msgstr ""
+
+#. 7Cbn3
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"par_id621647275321672\n"
+"help.text"
+msgid "The shared file needs to reside in a location which is accessible by all collaborators."
+msgstr ""
+
+#. 6hGDF
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"par_id731647275360618\n"
+"help.text"
+msgid "The file permissions for both the document and the corresponding lock file need to be set so that all collaborators can create, delete, and change the files."
+msgstr ""
+
+#. UhRSD
+#: shared_spreadsheet.xhp
+msgctxt ""
+"shared_spreadsheet.xhp\n"
+"par_id631647275500217\n"
+"help.text"
+msgid "In order to correctly identify the changes, each collaborator should enter their name in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - User Data</menuitem> on the Menu bar."
+msgstr ""
+
#. k7H5Y
#: solver.xhp
msgctxt ""