summaryrefslogtreecommitdiff
path: root/source/en-GB/helpcontent2/source/text/scalc/01.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/en-GB/helpcontent2/source/text/scalc/01.po')
-rw-r--r--source/en-GB/helpcontent2/source/text/scalc/01.po340
1 files changed, 143 insertions, 197 deletions
diff --git a/source/en-GB/helpcontent2/source/text/scalc/01.po b/source/en-GB/helpcontent2/source/text/scalc/01.po
index 359a564a509..79a288a9b84 100644
--- a/source/en-GB/helpcontent2/source/text/scalc/01.po
+++ b/source/en-GB/helpcontent2/source/text/scalc/01.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: 2013-11-20 13:02+0100\n"
-"PO-Revision-Date: 2013-12-02 17:35+0000\n"
+"POT-Creation-Date: 2014-05-02 00:10+0200\n"
+"PO-Revision-Date: 2014-05-14 12:19+0000\n"
"Last-Translator: Stuart <stuart.swales.croftnuisk@gmail.com>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"Language: en_GB\n"
@@ -12,9 +12,9 @@ msgstr ""
"Content-Type: text/plain; charset=utf-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"
-"X-Generator: Pootle 2.5.0\n"
+"X-Generator: Pootle 2.5.1\n"
"X-Accelerator-Marker: ~\n"
-"X-POOTLE-MTIME: 1386005754.0\n"
+"X-POOTLE-MTIME: 1400069976.000000\n"
#: 01120000.xhp
msgctxt ""
@@ -1741,8 +1741,8 @@ msgctxt ""
"par_id3154015\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/text\">Deletes text only. Formats, formulas, numbers and dates are not affected.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/text\">Deletes text only. Formats, formulae, numbers and dates are not affected.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/text\">Deletes text only. Formats, formulas, numbers and dates are not affected.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/text\">Deletes text only. Formats, formulae, numbers and dates are not affected.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1759,8 +1759,8 @@ msgctxt ""
"par_id3148405\n"
"10\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/numbers\">Deletes numbers only. Formats and formulas remain unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/numbers\">Deletes numbers only. Formats and formulae remain unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/numbers\">Deletes numbers only. Formats and formulas remain unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/numbers\">Deletes numbers only. Formats and formulae remain unchanged.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1777,8 +1777,8 @@ msgctxt ""
"par_id3149567\n"
"12\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/datetime\">Deletes date and time values. Formats, text, numbers and formulas remain unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/datetime\">Deletes date and time values. Formats, text, numbers and formulae remain unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/datetime\">Deletes date and time values. Formats, text, numbers and formulas remain unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/datetime\">Deletes date and time values. Formats, text, numbers and formulae remain unchanged.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1795,8 +1795,8 @@ msgctxt ""
"par_id3148485\n"
"14\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/formulas\">Deletes formulas. Text, numbers, formats, dates and times remain unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/formulas\">Deletes formulae. Text, numbers, formats, dates and times remain unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/formulas\">Deletes formulas. Text, numbers, formats, dates and times remain unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/formulas\">Deletes formulae. Text, numbers, formats, dates and times remain unchanged.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1813,8 +1813,8 @@ msgctxt ""
"par_id3154658\n"
"16\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/comments\">Deletes comments added to cells. All other elements remain unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/comments\">Deletes comments added to cells. All other elements remain unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/comments\">Deletes comments added to cells. All other elements remain unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/comments\">Deletes comments added to cells. All other elements remain unchanged.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1831,8 +1831,8 @@ msgctxt ""
"par_id3146134\n"
"18\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/formats\">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/formats\">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/formats\">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/formats\">Deletes format attributes applied to cells. All cell content remains unchanged.</ahelp>"
#: 02150000.xhp
msgctxt ""
@@ -1849,8 +1849,8 @@ msgctxt ""
"par_id3152990\n"
"20\n"
"help.text"
-msgid "<ahelp hid=\"/modules/scalc/ui/deletecontents/objects\">Deletes objects. All cell content remains unchanged.</ahelp>"
-msgstr "<ahelp hid=\"/modules/scalc/ui/deletecontents/objects\">Deletes objects. All cell content remains unchanged.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/deletecontents/objects\">Deletes objects. All cell content remains unchanged.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/deletecontents/objects\">Deletes objects. All cell content remains unchanged.</ahelp>"
#: 02160000.xhp
msgctxt ""
@@ -26076,8 +26076,8 @@ msgctxt ""
"par_id3156074\n"
"60\n"
"help.text"
-msgid "<item type=\"input\">=TRIM(\" hello world \")</item> returns hello world without leading and trailing zeros and with single space between words."
-msgstr "<item type=\"input\">=TRIM(\" hello world \")</item> returns hello world without leading and trailing zeros and with single space between words."
+msgid "<item type=\"input\">=TRIM(\" hello world \")</item> returns hello world without leading and trailing spaces and with single space between words."
+msgstr "<item type=\"input\">=TRIM(\" hello world \")</item> returns hello world without leading and trailing spaces and with single space between words."
#: 04060110.xhp
msgctxt ""
@@ -41335,8 +41335,8 @@ msgctxt ""
"par_id3149254\n"
"49\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_KRITBINOM\">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_KRITBINOM\">Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_KRITBINOM\">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp>"
+msgstr "<ahelp hid=\"HID_FUNC_KRITBINOM\">Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.</ahelp>"
#: 04060183.xhp
msgctxt ""
@@ -41566,8 +41566,8 @@ msgctxt ""
"04060183.xhp\n"
"bm_id3158417\n"
"help.text"
-msgid "<bookmark_value>LOGNORMDIST function</bookmark_value><bookmark_value>cumulative lognormal distribution</bookmark_value>"
-msgstr "<bookmark_value>LOGNORMDIST function</bookmark_value><bookmark_value>cumulative log-normal distribution</bookmark_value>"
+msgid "<bookmark_value>LOGNORMDIST function</bookmark_value><bookmark_value>lognormal distribution</bookmark_value>"
+msgstr "<bookmark_value>LOGNORMDIST function</bookmark_value><bookmark_value>lognormal distribution</bookmark_value>"
#: 04060183.xhp
msgctxt ""
@@ -41584,8 +41584,8 @@ msgctxt ""
"par_id3154953\n"
"77\n"
"help.text"
-msgid "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the cumulative lognormal distribution.</ahelp>"
-msgstr "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the cumulative log-normal distribution.</ahelp>"
+msgid "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the values of a lognormal distribution.</ahelp>"
+msgstr "<ahelp hid=\"HID_FUNC_LOGNORMVERT\">Returns the values of a lognormal distribution.</ahelp>"
#: 04060183.xhp
msgctxt ""
@@ -43639,8 +43639,8 @@ msgctxt ""
"par_id3155261\n"
"42\n"
"help.text"
-msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing a sample based on an entire population."
-msgstr "<emph>Number1; Number2; ... Number30</emph> are 1 to 30 numeric values or ranges representing a sample based on an entire population."
+msgid "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population."
+msgstr "<emph>Number 1,Number 2,...Number 30</emph> are numerical values or ranges representing an entire population."
#: 04060185.xhp
msgctxt ""
@@ -43710,8 +43710,8 @@ msgctxt ""
"par_id3153109\n"
"198\n"
"help.text"
-msgid "<emph>Value1,value2,...value30</emph> are values or ranges representing a sample derived from an entire population. Text has the value 0."
-msgstr "<emph>Value1; Value2; ... Value30</emph> are 1 to 30 values or ranges representing a sample derived from an entire population. Text has the value 0."
+msgid "<emph>Value1,value2,...value30</emph> are values or ranges representing an entire population. Text has the value 0."
+msgstr "<emph>Value1,value2,...value30</emph> are values or ranges representing an entire population. Text has the value 0."
#: 04060185.xhp
msgctxt ""
@@ -46964,8 +46964,8 @@ msgctxt ""
"par_id3151044\n"
"4\n"
"help.text"
-msgid "<ahelp hid=\"SC:METRICFIELD:RID_SCDLG_ROW_OPT:ED_VALUE\">Sets additional spacing between the largest character in a row and the cell boundaries.</ahelp>"
-msgstr "<ahelp hid=\"SC:METRICFIELD:RID_SCDLG_ROW_OPT:ED_VALUE\">Sets additional spacing between the largest character in a row and the cell boundaries.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/optimalrowheightdialog/value\">Sets additional spacing between the largest character in a row and the cell boundaries.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/optimalrowheightdialog/value\">Sets additional spacing between the largest character in a row and the cell boundaries.</ahelp>"
#: 05030200.xhp
msgctxt ""
@@ -46982,8 +46982,8 @@ msgctxt ""
"par_id3146984\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_ROW_OPT:BTN_DEFVAL\">Restores the default value for the optimal row height.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_ROW_OPT:BTN_DEFVAL\">Restores the default value for the optimal row height.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/optimalrowheightdialog/default\">Restores the default value for the optimal row height.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/optimalrowheightdialog/default\">Restores the default value for the optimal row height.</ahelp>"
#: 05030300.xhp
msgctxt ""
@@ -47225,8 +47225,8 @@ msgctxt ""
"par_id3150449\n"
"4\n"
"help.text"
-msgid "<ahelp hid=\"SC:METRICFIELD:RID_SCDLG_COL_OPT:ED_VALUE\">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp>"
-msgstr "<ahelp hid=\"SC:METRICFIELD:RID_SCDLG_COL_OPT:ED_VALUE\">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/value\">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/value\">Defines additional spacing between the longest entry in a column and the vertical column borders.</ahelp>"
#: 05040200.xhp
msgctxt ""
@@ -47243,8 +47243,8 @@ msgctxt ""
"par_id3146120\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_COL_OPT:BTN_DEFVAL\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_COL_OPT:BTN_DEFVAL\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
+msgid "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
+msgstr "<ahelp hid=\"modules/scalc/ui/optimalcolwidthdialog/default\">Defines the optimal column width in order to display the entire contents of the column.</ahelp> The additional spacing for the optimal column width is preset to 0.1 in."
#: 05050000.xhp
msgctxt ""
@@ -47441,8 +47441,8 @@ msgctxt ""
"par_id3145273\n"
"4\n"
"help.text"
-msgid "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST\" visibility=\"visible\">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK."
-msgstr "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_SHOW_TAB:LB_ENTRYLIST\" visibility=\"visible\">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK."
+msgid "<ahelp hid=\"modules/scalc/ui/whowsheetdialog/ShowSheetDialog\" visibility=\"visible\">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK."
+msgstr "<ahelp hid=\"modules/scalc/ui/whowsheetdialog/ShowSheetDialog\" visibility=\"visible\">Displays a list of all hidden sheets in your spreadsheet document.</ahelp> To show a certain sheet, click the corresponding entry on the list and confirm with OK."
#: 05060000.xhp
msgctxt ""
@@ -47760,8 +47760,8 @@ msgctxt ""
"par_id3150205\n"
"24\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/radioBTN_TOPDOW\">Prints vertically from the left column to the bottom of the sheet.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/radioBTN_TOPDOW\">Prints vertically from the left column to the bottom of the sheet.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN\">Prints vertically from the left column to the bottom of the sheet.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN\">Prints vertically from the left column to the bottom of the sheet.</ahelp>"
#: 05070500.xhp
msgctxt ""
@@ -48667,8 +48667,8 @@ msgctxt ""
"par_id3145799\n"
"4\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_AUTOFORMAT:LB_FORMAT\">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_AUTOFORMAT:LB_FORMAT\">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/formatlb\">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/formatlb\">Choose a predefined AutoFormat to apply to a selected area in your sheet.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48685,8 +48685,8 @@ msgctxt ""
"par_id3154017\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_AUTOFORMAT:BTN_ADD\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <link href=\"text/shared/01/05150101.xhp\" name=\"Add AutoFormat\">Add AutoFormat</link> dialog then appears."
-msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_AUTOFORMAT:BTN_ADD\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <link href=\"text/shared/01/05150101.xhp\" name=\"Add AutoFormat\">Add AutoFormat</link> dialogue box will then appear."
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/add\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <link href=\"text/shared/01/05150101.xhp\" name=\"Add AutoFormat\">Add AutoFormat</link> dialog then appears."
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/add\">Allows you to add the current formatting of a range of at least 4 x 4 cells to the list of predefined AutoFormats.</ahelp> The <link href=\"text/shared/01/05150101.xhp\" name=\"Add AutoFormat\">Add AutoFormat</link> dialogue box will then appear."
#: 05110000.xhp
msgctxt ""
@@ -48700,24 +48700,6 @@ msgstr "<ahelp hid=\"HID_SC_AUTOFMT_NAME\">Enter a name and click <emph>OK</emph
#: 05110000.xhp
msgctxt ""
"05110000.xhp\n"
-"hd_id3150044\n"
-"7\n"
-"help.text"
-msgid "More"
-msgstr "More"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
-"par_id3146920\n"
-"8\n"
-"help.text"
-msgid "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_AUTOFORMAT:BTN_MORE\">Opens the <emph>Formatting</emph> section, which displays the formatting overrides that can be applied to the spreadsheet. Deselecting an option keeps the format of the current spreadsheet for that format type.</ahelp>"
-msgstr "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_AUTOFORMAT:BTN_MORE\">Opens the <emph>Formatting</emph> section, which displays the formatting overrides that can be applied to the spreadsheet. Deselecting an option keeps the format of the current spreadsheet for that format type.</ahelp>"
-
-#: 05110000.xhp
-msgctxt ""
-"05110000.xhp\n"
"hd_id3155961\n"
"9\n"
"help.text"
@@ -48748,8 +48730,8 @@ msgctxt ""
"par_id3159239\n"
"12\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_NUMFORMAT\">When marked, specifies that you want to retain the number format of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_NUMFORMAT\">When marked, specifies that you want to retain the number format of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/numformatcb\">When marked, specifies that you want to retain the number format of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/numformatcb\">When marked, specifies that you want to retain the number format of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48766,8 +48748,8 @@ msgctxt ""
"par_id3145259\n"
"14\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_BORDER\">When marked, specifies that you want to retain the border of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_BORDER\">When marked, specifies that you want to retain the border of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/bordercb\">When marked, specifies that you want to retain the border of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/bordercb\">When marked, specifies that you want to retain the border of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48784,8 +48766,8 @@ msgctxt ""
"par_id3152990\n"
"16\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_FONT\">When marked, specifies that you want to retain the font of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_FONT\">When marked, specifies that you want to retain the font of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/fontcb\">When marked, specifies that you want to retain the font of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/fontcb\">When marked, specifies that you want to retain the font of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48802,8 +48784,8 @@ msgctxt ""
"par_id3150368\n"
"18\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_PATTERN\">When marked, specifies that you want to retain the pattern of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_PATTERN\">When marked, specifies that you want to retain the pattern of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/patterncb\">When marked, specifies that you want to retain the pattern of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/patterncb\">When marked, specifies that you want to retain the pattern of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48820,8 +48802,8 @@ msgctxt ""
"par_id3156445\n"
"20\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ALIGNMENT\">When marked, specifies that you want to retain the alignment of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ALIGNMENT\">When marked, specifies that you want to retain the alignment of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/alignmentcb\">When marked, specifies that you want to retain the alignment of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/alignmentcb\">When marked, specifies that you want to retain the alignment of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -48838,8 +48820,8 @@ msgctxt ""
"par_id3148703\n"
"22\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ADJUST\">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_AUTOFORMAT:BTN_ADJUST\">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/autoformattable/autofitcb\">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/autoformattable/autofitcb\">When marked, specifies that you want to retain the width and height of the selected cells of the selected format.</ahelp>"
#: 05110000.xhp
msgctxt ""
@@ -50037,8 +50019,8 @@ msgctxt ""
"par_id3151073\n"
"19\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_NEWSCENARIO:LB_COLOR\">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions."
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_NEWSCENARIO:LB_COLOR\">Highlights the scenario in your table with a border. The colour for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions."
+msgid "<ahelp hid=\"modules/scalc/ui/scenariodialog/bordercolor\">Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions."
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariodialog/bordercolor\">Highlights the scenario in your table with a border. The colour for the border is specified in the field to the right of this option.</ahelp> The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions."
#: 06050000.xhp
msgctxt ""
@@ -50055,8 +50037,8 @@ msgctxt ""
"par_id3154942\n"
"21\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY\">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_TWOWAY\">Copies the values of cells that you change into the active scenario. If you do not mark this check box, the scenario is not changed when you change cell values. The behaviour of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/scenariodialog/copyback\">Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariodialog/copyback\">Copies the values of cells that you change into the active scenario. If you do not mark this check box, the scenario is not changed when you change cell values. The behaviour of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
#: 06050000.xhp
msgctxt ""
@@ -50073,8 +50055,8 @@ msgctxt ""
"par_id3146969\n"
"23\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_COPYALL\">Copies the entire sheet into an additional scenario sheet. </ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_NEWSCENARIO:CB_COPYALL\">Copies the entire sheet into an additional scenario sheet. </ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/scenariodialog/copysheet\">Copies the entire sheet into an additional scenario sheet. </ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariodialog/copysheet\">Copies the entire sheet into an additional scenario sheet. </ahelp>"
#: 06050000.xhp
msgctxt ""
@@ -50089,8 +50071,8 @@ msgctxt ""
"06050000.xhp\n"
"par_idN1075E\n"
"help.text"
-msgid "<ahelp hid=\"sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_PROTECT\">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
-msgstr "<ahelp hid=\"sc:CheckBox:RID_SCDLG_NEWSCENARIO:CB_PROTECT\">Prevents changes to the active scenario. The behaviour of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/scenariodialog/preventchanges\">Prevents changes to the active scenario. The behavior of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/scenariodialog/preventchanges\">Prevents changes to the active scenario. The behaviour of the <emph>Copy back</emph> setting depends on the cell protection, the sheet protection, and the <emph>Prevent changes</emph> settings.</ahelp>"
#: 06050000.xhp
msgctxt ""
@@ -51023,8 +51005,8 @@ msgctxt ""
"par_id3151385\n"
"2\n"
"help.text"
-msgid "<ahelp hid=\"modules/scalc/ui/sortcriteria/SortCriteriaPage\">Specify the sorting options for the selected range.</ahelp>"
-msgstr "<ahelp hid=\"modules/scalc/ui/sortcriteria/SortCriteriaPage\">Specify the sorting options for the selected range.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/sortcriteriapage/SortCriteriaPage\">Specify the sorting options for the selected range.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/sortcriteriapage/SortCriteriaPage\">Specify the sorting options for the selected range.</ahelp>"
#: 12030100.xhp
msgctxt ""
@@ -51944,8 +51926,8 @@ msgctxt ""
"par_id3145068\n"
"2\n"
"help.text"
-msgid "<ahelp hid=\"HID_SCPAGE_SUBT_GROUP1\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>"
-msgstr "<ahelp hid=\"HID_SCPAGE_SUBT_GROUP1\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/SubTotalGrpPage\">Specify the settings for up to three subtotal groups. Each tab has the same layout.</ahelp>"
#: 12050100.xhp
msgctxt ""
@@ -52025,8 +52007,8 @@ msgctxt ""
"par_id3154013\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_SUBT_GROUP\">Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_SUBT_GROUP\">Select the column that you want to control the subtotal calculation process. If the contents of the selected column changes, the subtotals are automatically recalculated.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/group_by\">Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/group_by\">Select the column that you want to control the subtotal calculation process. If the contents of the selected column changes, the subtotals are automatically recalculated.</ahelp>"
#: 12050100.xhp
msgctxt ""
@@ -52043,8 +52025,8 @@ msgctxt ""
"par_id3147125\n"
"10\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_SUBT_COLS\">Select the column(s) containing the values that you want to subtotal.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_SUBT_COLS\">Select the column(s) containing the values that you want to subtotal.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/columns\">Select the column(s) containing the values that you want to subtotal.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/columns\">Select the column(s) containing the values that you want to subtotal.</ahelp>"
#: 12050100.xhp
msgctxt ""
@@ -52061,8 +52043,8 @@ msgctxt ""
"par_id3145647\n"
"12\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_SUBT_FUNC\">Select the mathematical function that you want to use to calculate the subtotals.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_SUBT_FUNC\">Select the mathematical function that you want to use to calculate the subtotals.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/functions\">Select the mathematical function that you want to use to calculate the subtotals.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/subtotalgrppage/functions\">Select the mathematical function that you want to use to calculate the subtotals.</ahelp>"
#: 12050200.xhp
msgctxt ""
@@ -52301,8 +52283,8 @@ msgctxt ""
"par_id3151073\n"
"7\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_FORMULARANGE\">Enter the cell references for the cells containing the formulas that you want to use in the multiple operation.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_FORMULARANGE\">Enter the cell references for the cells containing the formulae that you want to use in the multiple operation.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/formulas\">Enter the cell references for the cells containing the formulas that you want to use in the multiple operation.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/formulas\">Enter the cell references for the cells containing the formulae that you want to use in the multiple operation.</ahelp>"
#: 12060000.xhp
msgctxt ""
@@ -52319,8 +52301,8 @@ msgctxt ""
"par_id3148456\n"
"9\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_ROWCELL\">Enter the input cell reference that you want to use as a variable for the rows in the data table.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_ROWCELL\">Enter the input cell reference that you want to use as a variable for the rows in the data table.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/row\">Enter the input cell reference that you want to use as a variable for the rows in the data table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/row\">Enter the input cell reference that you want to use as a variable for the rows in the data table.</ahelp>"
#: 12060000.xhp
msgctxt ""
@@ -52337,8 +52319,8 @@ msgctxt ""
"par_id3150327\n"
"15\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_COLCELL\">Enter the input cell reference that you want to use as a variable for the columns in the data table.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_TABOP:ED_COLCELL\">Enter the input cell reference that you want to use as a variable for the columns in the data table.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/col\">Enter the input cell reference that you want to use as a variable for the columns in the data table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/multipleoperationsdialog/col\">Enter the input cell reference that you want to use as a variable for the columns in the data table.</ahelp>"
#: 12070000.xhp
msgctxt ""
@@ -53359,8 +53341,8 @@ msgctxt ""
"par_id3156424\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_DAPIDATA:LB_DATABASE\">Select the database that contains the data source that you want to use.</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_DAPIDATA:LB_DATABASE\">Select the database that contains the data source that you want to use.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/selectdatasource/database\">Select the database that contains the data source that you want to use.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/selectdatasource/database\">Select the database that contains the data source that you want to use.</ahelp>"
#: 12090101.xhp
msgctxt ""
@@ -53377,8 +53359,8 @@ msgctxt ""
"par_id3149260\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_DAPIDATA:CB_OBJECT\">Select the data source that you want to use.</ahelp>"
-msgstr "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_DAPIDATA:CB_OBJECT\">Select the data source that you want to use.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/selectdatasource/datasource\">Select the data source that you want to use.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/selectdatasource/datasource\">Select the data source that you want to use.</ahelp>"
#: 12090101.xhp
msgctxt ""
@@ -53395,8 +53377,8 @@ msgctxt ""
"par_id3150010\n"
"10\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_DAPIDATA:LB_OBJTYPE\">Click the source type of for the selected data source.</ahelp> You can choose from four source types: \"Table\", \"Query\" and \"SQL\" or SQL (Native)."
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_DAPIDATA:LB_OBJTYPE\">Click the source type for the selected data source.</ahelp> You can choose from four source types: \"Table\", \"Query\" and \"SQL\" or SQL (Native)."
+msgid "<ahelp hid=\"modules/scalc/ui/selectdatasource/type\">Click the source type of for the selected data source.</ahelp> You can choose from four source types: \"Table\", \"Query\" and \"SQL\" or SQL (Native)."
+msgstr "<ahelp hid=\"modules/scalc/ui/selectdatasource/type\">Click the source type for the selected data source.</ahelp> You can choose from four source types: \"Table\", \"Query\" and \"SQL\" or SQL (Native)."
#: 12090101.xhp
msgctxt ""
@@ -53465,8 +53447,8 @@ msgctxt ""
"par_id3150768\n"
"19\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_DPLAY_SELECT\">To define the layout of a pivot table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag and drop to rearrange the data fields on a pivot table."
-msgstr "<ahelp hid=\"HID_SC_DPLAY_SELECT\">To define the layout of a pivot table, drag-and-drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag-and-drop to rearrange the data fields on a pivot table."
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/listbox-fields\">To define the layout of a pivot table, drag and drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag and drop to rearrange the data fields on a pivot table."
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/listbox-fields\">To define the layout of a pivot table, drag-and-drop data field buttons onto the <emph>Page Fields, Row Fields, Column Fields, </emph>and<emph> Data Fields </emph>areas.</ahelp> You can also use drag-and-drop to rearrange the data fields on a pivot table."
#: 12090102.xhp
msgctxt ""
@@ -53489,42 +53471,6 @@ msgstr "To change the function that is used by a data field, double-click a butt
#: 12090102.xhp
msgctxt ""
"12090102.xhp\n"
-"hd_id3149260\n"
-"28\n"
-"help.text"
-msgid "Remove"
-msgstr "Remove"
-
-#: 12090102.xhp
-msgctxt ""
-"12090102.xhp\n"
-"par_id3150010\n"
-"27\n"
-"help.text"
-msgid "<ahelp hid=\"SC_PUSHBUTTON_RID_SCDLG_PIVOT_LAYOUT_BTN_REMOVE\">Removes the selected data field from the table layout.</ahelp>"
-msgstr "<ahelp hid=\"SC_PUSHBUTTON_RID_SCDLG_PIVOT_LAYOUT_BTN_REMOVE\">Removes the selected data field from the table layout.</ahelp>"
-
-#: 12090102.xhp
-msgctxt ""
-"12090102.xhp\n"
-"hd_id3145273\n"
-"26\n"
-"help.text"
-msgid "Options"
-msgstr "Options"
-
-#: 12090102.xhp
-msgctxt ""
-"12090102.xhp\n"
-"par_id3146120\n"
-"25\n"
-"help.text"
-msgid "<ahelp hid=\"SC_PUSHBUTTON_RID_SCDLG_PIVOT_LAYOUT_BTN_OPTIONS\">Opens the <link href=\"text/scalc/01/12090105.xhp\" name=\"Data Field\"><emph>Data Field</emph></link> dialog where you can change the function that is associated with the selected field.</ahelp>"
-msgstr "<ahelp hid=\"SC_PUSHBUTTON_RID_SCDLG_PIVOT_LAYOUT_BTN_OPTIONS\">Opens the <link href=\"text/scalc/01/12090105.xhp\" name=\"Data Field\"><emph>Data Field</emph></link> dialogue box with in you can change the function that is associated with the selected field.</ahelp>"
-
-#: 12090102.xhp
-msgctxt ""
-"12090102.xhp\n"
"hd_id3154944\n"
"22\n"
"help.text"
@@ -53537,8 +53483,8 @@ msgctxt ""
"par_id3145647\n"
"23\n"
"help.text"
-msgid "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE\">Displays or hides additional options for defining the pivot table.</ahelp>"
-msgstr "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_PIVOT_LAYOUT:BTN_MORE\">Displays or hides additional options for defining the pivot table.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/more\">Displays or hides additional options for defining the pivot table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/more\">Displays or hides additional options for defining the pivot table.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53589,8 +53535,8 @@ msgctxt ""
"par_id3153838\n"
"5\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA\">Select the area where you want to display the results of the pivot table.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_PIVOT_LAYOUT:ED_OUTAREA\">Select the area where you want to display the results of the pivot table.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/destination-edit\">Select the area where you want to display the results of the pivot table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/destination-edit\">Select the area where you want to display the results of the pivot table.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53616,8 +53562,8 @@ msgctxt ""
"par_id3154022\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS\">Ignores empty fields in the data source.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_IGNEMPTYROWS\">Ignores empty fields in the data source.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows\">Ignores empty fields in the data source.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-ignore-empty-rows\">Ignores empty fields in the data source.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53634,8 +53580,8 @@ msgctxt ""
"par_id3145257\n"
"10\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_DETECTCAT\">Automatically assigns rows without labels to the category of the row above.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_DETECTCAT\">Automatically assigns rows without labels to the category of the row above.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-identify-categories\">Automatically assigns rows without labels to the category of the row above.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-identify-categories\">Automatically assigns rows without labels to the category of the row above.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53652,8 +53598,8 @@ msgctxt ""
"par_id3166426\n"
"15\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALCOL\">Calculates and displays the grand total of the column calculation.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALCOL\">Calculates and displays the grand total of the column calculation.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-total-columns\">Calculates and displays the grand total of the column calculation.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-total-columns\">Calculates and displays the grand total of the column calculation.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53670,8 +53616,8 @@ msgctxt ""
"par_id3152583\n"
"17\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW\">Calculates and displays the grand total of the row calculation.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOT_LAYOUT:BTN_TOTALROW\">Calculates and displays the grand total of the row calculation.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-total-rows\">Calculates and displays the grand total of the row calculation.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivottablelayoutdialog/check-total-rows\">Calculates and displays the grand total of the row calculation.</ahelp>"
#: 12090102.xhp
msgctxt ""
@@ -53837,8 +53783,8 @@ msgctxt ""
"par_id3153093\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_OP2\" visibility=\"visible\">Select a logical operator for the filter.</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_OP2\" visibility=\"visible\">Select a logical operator for the filter.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/connect2\" visibility=\"visible\">Select a logical operator for the filter.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/connect2\" visibility=\"visible\">Select a logical operator for the filter.</ahelp>"
#: 12090103.xhp
msgctxt ""
@@ -53855,8 +53801,8 @@ msgctxt ""
"par_id3155306\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD3\" visibility=\"visible\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_FIELD3\" visibility=\"visible\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/field3\" visibility=\"visible\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/field3\" visibility=\"visible\">Select the field that you want to use in the filter. If field names are not available, the column labels are listed.</ahelp>"
#: 12090103.xhp
msgctxt ""
@@ -53873,8 +53819,8 @@ msgctxt ""
"par_id3147394\n"
"10\n"
"help.text"
-msgid "<ahelp visibility=\"visible\" hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND3\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
-msgstr "<ahelp visibility=\"visible\" hid=\"SC:LISTBOX:RID_SCDLG_PIVOTFILTER:LB_COND3\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
+msgid "<ahelp visibility=\"visible\" hid=\"modules/scalc/ui/pivotfilterdialog/cond3\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
+msgstr "<ahelp visibility=\"visible\" hid=\"modules/scalc/ui/pivotfilterdialog/cond3\">Select an operator to compare the <emph>Field name</emph> and <emph>Value</emph> entries.</ahelp>"
#: 12090103.xhp
msgctxt ""
@@ -54017,8 +53963,8 @@ msgctxt ""
"par_id3155506\n"
"26\n"
"help.text"
-msgid "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL3\" visibility=\"visible\">Select the value that you want to compare to the selected field.</ahelp>"
-msgstr "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_PIVOTFILTER:ED_VAL3\" visibility=\"visible\">Select the value that you want to compare to the selected field.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/val3\" visibility=\"visible\">Select the value that you want to compare to the selected field.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfilterdialog/val3\" visibility=\"visible\">Select the value that you want to compare to the selected field.</ahelp>"
#: 12090103.xhp
msgctxt ""
@@ -54220,8 +54166,8 @@ msgctxt ""
"par_id3151113\n"
"3\n"
"help.text"
-msgid "<ahelp hid=\"HID_SC_PIVOTSUBT\">Specify the subtotals that you want to calculate.</ahelp>"
-msgstr "<ahelp hid=\"HID_SC_PIVOTSUBT\">Specify the subtotals that you want to calculate.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/PivotFieldDialog\">Specify the subtotals that you want to calculate.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/PivotFieldDialog\">Specify the subtotals that you want to calculate.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -54238,8 +54184,8 @@ msgctxt ""
"par_id3152576\n"
"5\n"
"help.text"
-msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_NONE\">Does not calculate subtotals.</ahelp>"
-msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_NONE\">Does not calculate subtotals.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/none\">Does not calculate subtotals.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/none\">Does not calculate subtotals.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -54256,8 +54202,8 @@ msgctxt ""
"par_id3155856\n"
"7\n"
"help.text"
-msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_AUTO\">Automatically calculates subtotals.</ahelp>"
-msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_AUTO\">Automatically calculates subtotals.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/auto\">Automatically calculates subtotals.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/auto\">Automatically calculates subtotals.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -54274,8 +54220,8 @@ msgctxt ""
"par_id3149581\n"
"9\n"
"help.text"
-msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_USER\">Select this option, and then click the type of subtotal that you want to calculate in the list.</ahelp>"
-msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_PIVOTSUBT:BTN_USER\">Select this option, and then click the type of subtotal that you want to calculate in the list.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/user\">Select this option, and then click the type of subtotal that you want to calculate in the list.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/user\">Select this option, and then click the type of subtotal that you want to calculate in the list.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -54292,8 +54238,8 @@ msgctxt ""
"par_id3154490\n"
"11\n"
"help.text"
-msgid "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_PIVOTSUBT:LB_FUNC\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
-msgstr "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_PIVOTSUBT:LB_FUNC\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/functions\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/functions\">Click the type of subtotal that you want to calculate. This option is only available if the <emph>User-defined</emph> option is selected.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -54310,8 +54256,8 @@ msgctxt ""
"par_id3149403\n"
"15\n"
"help.text"
-msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOTSUBT:CB_SHOWALL\">Includes empty columns and rows in the results table.</ahelp>"
-msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_PIVOTSUBT:CB_SHOWALL\">Includes empty columns and rows in the results table.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/showall\">Includes empty columns and rows in the results table.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/pivotfielddialog/showall\">Includes empty columns and rows in the results table.</ahelp>"
#: 12090105.xhp
msgctxt ""
@@ -55235,8 +55181,8 @@ msgctxt ""
"par_id3156327\n"
"2\n"
"help.text"
-msgid "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_VALUES\">Specify the validation rules for the selected cell(s).</ahelp>"
-msgstr "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_VALUES\">Specify the validation rules for the selected cell(s).</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage\">Specify the validation rules for the selected cell(s).</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage\">Specify the validation rules for the selected cell(s).</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55262,8 +55208,8 @@ msgctxt ""
"par_id3150400\n"
"6\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_VALUES:LB_ALLOW\">Click a validation option for the selected cell(s).</ahelp>"
-msgstr "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_VALUES:LB_ALLOW\">Click a validation option for the selected cell(s).</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/allow\">Click a validation option for the selected cell(s).</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/allow\">Click a validation option for the selected cell(s).</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55447,8 +55393,8 @@ msgctxt ""
"par_id3153967\n"
"8\n"
"help.text"
-msgid "<ahelp hid=\"SC:TRISTATEBOX:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS\">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp>"
-msgstr "<ahelp hid=\"SC:TRISTATEBOX:TP_VALIDATION_VALUES:TSB_ALLOW_BLANKS\">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/allowempty\">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/allowempty\">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55463,8 +55409,8 @@ msgctxt ""
"12120100.xhp\n"
"par_idN1070D\n"
"help.text"
-msgid "<ahelp hid=\"sc:CheckBox:TP_VALIDATION_VALUES:CB_SHOWLIST\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D (Mac: Command+D).</ahelp>"
-msgstr "<ahelp hid=\"sc:CheckBox:TP_VALIDATION_VALUES:CB_SHOWLIST\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D (Mac: Command+D).</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/showlist\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D (Mac: Command+D).</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/showlist\">Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D (Mac: Command+D).</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55479,8 +55425,8 @@ msgctxt ""
"12120100.xhp\n"
"par_idN10728\n"
"help.text"
-msgid "<ahelp hid=\"sc:CheckBox:TP_VALIDATION_VALUES:CB_SORTLIST\">Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken.</ahelp>"
-msgstr "<ahelp hid=\"sc:CheckBox:TP_VALIDATION_VALUES:CB_SORTLIST\">Sorts the selection list in ascending order and filters duplicates from the list. If not marked, the order is taken from the data source.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/sortascend\">Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/sortascend\">Sorts the selection list in ascending order and filters duplicates from the list. If not marked, the order is taken from the data source.</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55495,8 +55441,8 @@ msgctxt ""
"12120100.xhp\n"
"par_idN10743\n"
"help.text"
-msgid "<ahelp hid=\"sc:Edit:TP_VALIDATION_VALUES:EDT_MIN\">Enter the cell range that contains the valid values or text.</ahelp>"
-msgstr "<ahelp hid=\"sc:Edit:TP_VALIDATION_VALUES:EDT_MIN\">Enter the cell range that contains the valid values or text.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/min\">Enter the cell range that contains the valid values or text.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/min\">Enter the cell range that contains the valid values or text.</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55511,8 +55457,8 @@ msgctxt ""
"12120100.xhp\n"
"par_idN1075E\n"
"help.text"
-msgid "<ahelp hid=\"sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST\">Enter the entries that will be valid values or text strings.</ahelp>"
-msgstr "<ahelp hid=\"sc:MultiLineEdit:TP_VALIDATION_VALUES:EDT_LIST\">Enter the entries that will be valid values or text strings.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/minlist\">Enter the entries that will be valid values or text strings.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/minlist\">Enter the entries that will be valid values or text strings.</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55529,8 +55475,8 @@ msgctxt ""
"par_id3144502\n"
"10\n"
"help.text"
-msgid "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_VALUES:LB_VALUE\">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow </emph>box. If you select \"between\" or \"not between\", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum, or the Value</emph> input boxes appear."
-msgstr "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_VALUES:LB_VALUE\">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow</emph> box. If you select \"between\" or \"not between\", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum, or the Value</emph> input boxes appear."
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/data\">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow </emph>box. If you select \"between\" or \"not between\", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum, or the Value</emph> input boxes appear."
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/data\">Select the comparative operator that you want to use.</ahelp> The available operators depend on what you selected in the <emph>Allow</emph> box. If you select \"between\" or \"not between\", the <emph>Minimum</emph> and <emph>Maximum</emph> input boxes appear. Otherwise, only the <emph>Minimum</emph>, the <emph>Maximum, or the Value</emph> input boxes appear."
#: 12120100.xhp
msgctxt ""
@@ -55565,8 +55511,8 @@ msgctxt ""
"par_id3153199\n"
"14\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:TP_VALIDATION_VALUES:EDT_MIN\">Enter the minimum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:TP_VALIDATION_VALUES:EDT_MIN\">Enter the minimum value for the data validation option that you selected in the <emph>Allow</emph> box.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/min\">Enter the minimum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/min\">Enter the minimum value for the data validation option that you selected in the <emph>Allow</emph> box.</ahelp>"
#: 12120100.xhp
msgctxt ""
@@ -55583,8 +55529,8 @@ msgctxt ""
"par_id3150089\n"
"16\n"
"help.text"
-msgid "<ahelp hid=\"SC:EDIT:TP_VALIDATION_VALUES:EDT_MAX\">Enter the maximum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp>"
-msgstr "<ahelp hid=\"SC:EDIT:TP_VALIDATION_VALUES:EDT_MAX\">Enter the maximum value for the data validation option that you selected in the <emph>Allow</emph> box.</ahelp>"
+msgid "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/max\">Enter the maximum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp>"
+msgstr "<ahelp hid=\"modules/scalc/ui/validationcriteriapage/max\">Enter the maximum value for the data validation option that you selected in the <emph>Allow</emph> box.</ahelp>"
#: 12120200.xhp
msgctxt ""
@@ -58798,7 +58744,7 @@ msgctxt ""
"solver_options.xhp\n"
"par_id3806878\n"
"help.text"
-msgid "Select the solver engine to use and to configure from the listbox. The listbox is disabled if onle one solver engine is installed."
+msgid "Select the solver engine to use and to configure from the listbox. The listbox is disabled if only one solver engine is installed."
msgstr "Select the solver engine to use and to configure from the list box. The list box is disabled if only one solver engine is installed."
#: solver_options.xhp