diff options
Diffstat (limited to 'source/mk/helpcontent2/source/text/scalc/01.po')
-rw-r--r-- | source/mk/helpcontent2/source/text/scalc/01.po | 745 |
1 files changed, 484 insertions, 261 deletions
diff --git a/source/mk/helpcontent2/source/text/scalc/01.po b/source/mk/helpcontent2/source/text/scalc/01.po index c0a5098e0fc..72319cfeabb 100644 --- a/source/mk/helpcontent2/source/text/scalc/01.po +++ b/source/mk/helpcontent2/source/text/scalc/01.po @@ -2,8 +2,8 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" -"Report-Msgid-Bugs-To: https://bugs.freedesktop.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2013-05-23 12:06+0200\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: 2012-12-10 12:55+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -1329,8 +1329,8 @@ msgctxt "" "par_id3155418\n" "7\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_BOTTOM\">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_BOTTOM\">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/down\">Creates a downward series in the selected cell range for the column using the defined increment to the end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1347,8 +1347,8 @@ msgctxt "" "par_id3149402\n" "9\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT\">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_RIGHT\">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/right\">Creates a series running from left to right within the selected cell range using the defined increment to the end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1365,8 +1365,8 @@ msgctxt "" "par_id3153711\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_TOP\">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_TOP\">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/up\">Creates an upward series in the cell range of the column using the defined increment to the end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1383,8 +1383,8 @@ msgctxt "" "par_id3156382\n" "13\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT\">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_LEFT\">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/left\">Creates a series running from right to left in the selected cell range using the defined increment to the end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1419,8 +1419,8 @@ msgctxt "" "par_id3159238\n" "17\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC\">Creates a linear number series using the defined increment and end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_ARITHMETIC\">Creates a linear number series using the defined increment and end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/linear\">Creates a linear number series using the defined increment and end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1437,8 +1437,8 @@ msgctxt "" "par_id3150364\n" "19\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC\">Creates a growth series using the defined increment and end value.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_GEOMETRIC\">Creates a growth series using the defined increment and end value.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/growth\">Creates a growth series using the defined increment and end value.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1455,8 +1455,8 @@ msgctxt "" "par_id3150887\n" "21\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE\">Creates a date series using the defined increment and end date.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DATE\">Creates a date series using the defined increment and end date.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/date\">Creates a date series using the defined increment and end date.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1473,8 +1473,8 @@ msgctxt "" "par_id3156288\n" "23\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL\">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</emph>." -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_AUTOFILL\">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph>Tools - Options - %PRODUCTNAME Calc - Sort Lists</emph>." +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/autofill\">Forms a series directly in the sheet.</ahelp> The AutoFill function takes account of customized lists. For example, by entering <emph>January</emph> in the first cell, the series is completed using the list defined under <emph><switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists</emph>." +msgstr "" #: 02140600.xhp msgctxt "" @@ -1518,8 +1518,8 @@ msgctxt "" "par_id3148605\n" "28\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY\">Use the <emph>Date</emph> series type and this option to create a series using seven days.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY\">Use the <emph>Date</emph> series type and this option to create a series using seven days.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/day\">Use the <emph>Date</emph> series type and this option to create a series using seven days.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1536,8 +1536,8 @@ msgctxt "" "par_id3150108\n" "30\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK\">Use the <emph>Date</emph> series type and this option to create a series of five day sets.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_DAY_OF_WEEK\">Use the <emph>Date</emph> series type and this option to create a series of five day sets.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/week\">Use the <emph>Date</emph> series type and this option to create a series of five day sets.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1554,8 +1554,8 @@ msgctxt "" "par_id3149126\n" "32\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_MONTH\">Use the <emph>Date</emph> series type and this option to form a series from the names or abbreviations of the months.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_MONTH\">Use the <emph>Date</emph> series type and this option to form a series from the names or abbreviations of the months.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/month\">Use the <emph>Date</emph> series type and this option to form a series from the names or abbreviations of the months.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1572,8 +1572,8 @@ msgctxt "" "par_id3151300\n" "34\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_YEAR\">Use the <emph>Date</emph> series type and this option to create a series of years.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_FILLSERIES:BTN_YEAR\">Use the <emph>Date</emph> series type and this option to create a series of years.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/year\">Use the <emph>Date</emph> series type and this option to create a series of years.</ahelp>" +msgstr "" #: 02140600.xhp msgctxt "" @@ -1590,8 +1590,8 @@ msgctxt "" "par_id3149381\n" "36\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES\">Determines the start value for the series.</ahelp> Use numbers, dates or times." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_START_VALUES\">Determines the start value for the series.</ahelp> Use numbers, dates or times." +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/startValue\">Determines the start value for the series.</ahelp> Use numbers, dates or times." +msgstr "" #: 02140600.xhp msgctxt "" @@ -1608,8 +1608,8 @@ msgctxt "" "par_id3153487\n" "38\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES\">Determines the end value for the series.</ahelp> Use numbers, dates or times." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_END_VALUES\">Determines the end value for the series.</ahelp> Use numbers, dates or times." +msgid "<ahelp hid=\"modules/scalc/ui/filldlg/endValue\">Determines the end value for the series.</ahelp> Use numbers, dates or times." +msgstr "" #: 02140600.xhp msgctxt "" @@ -1626,8 +1626,8 @@ msgctxt "" "par_id3154739\n" "40\n" "help.text" -msgid "The term \"increment\" denotes the amount by which a given value increases.<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_INCREMENT\"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected." -msgstr "The term \"increment\" denotes the amount by which a given value increases.<ahelp hid=\"SC:EDIT:RID_SCDLG_FILLSERIES:ED_INCREMENT\"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected." +msgid "The term \"increment\" denotes the amount by which a given value increases.<ahelp hid=\"modules/scalc/ui/filldlg/increment\"> Determines the value by which the series of the selected type increases by each step.</ahelp> Entries can only be made if the linear, growth or date series types have been selected." +msgstr "" #: 02150000.xhp msgctxt "" @@ -2120,8 +2120,8 @@ msgctxt "" "par_id3148645\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_DEST\">Indicates where the current sheet is to be moved or copied to.</ahelp> Select <emph>- new document -</emph> if you want to create a new location for the sheet to be moved or copied." -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_DEST\">Indicates where the current sheet is to be moved or copied to.</ahelp> Select <emph>new document</emph> if you want to create a new location for the sheet to be moved or copied." +msgid "<ahelp hid=\"modules/scalc/ui/movecopysheet/toDocument\">Indicates where the current sheet is to be moved or copied to.</ahelp> Select <emph>- new document -</emph> if you want to create a new location for the sheet to be moved or copied." +msgstr "" #: 02180000.xhp msgctxt "" @@ -2138,8 +2138,8 @@ msgctxt "" "par_id3145366\n" "6\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_INSERT\">The current sheet is moved or copied in front of the selected sheet.</ahelp> The <emph>- move to end position -</emph> option places the current sheet at the end." -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_MOVETAB:LB_INSERT\">The current sheet is moved or copied in front of the selected sheet.</ahelp> The <emph>move to end position</emph> option places the current sheet at the end." +msgid "<ahelp hid=\"modules/scalc/ui/movecopysheet/insertBefore\">The current sheet is moved or copied in front of the selected sheet.</ahelp> The <emph>- move to end position -</emph> option places the current sheet at the end." +msgstr "" #: 02180000.xhp msgctxt "" @@ -2156,8 +2156,8 @@ msgctxt "" "par_id3144764\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_MOVETAB:BTN_COPY\">Specifies that the sheet is to be copied. If the option is unmarked, the sheet is moved.</ahelp> Moving sheets is the default." -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_MOVETAB:BTN_COPY\">Specifies that the sheet is to be copied. If the option is unmarked, the sheet is moved.</ahelp> Moving sheets is the default." +msgid "<ahelp hid=\"modules/scalc/ui/movecopysheet/copy\">Specifies that the sheet is to be copied. If the option is unmarked, the sheet is moved.</ahelp> Moving sheets is the default." +msgstr "" #: 02190000.xhp msgctxt "" @@ -2473,8 +2473,8 @@ msgctxt "" "03080000.xhp\n" "par_id3145785\n" "help.text" -msgid "Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted." -msgstr "Text cells are formatted in black, number cells in blue, and all other types of cells, such as formulas, logical values, and dates, are formatted in green." +msgid "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 "" #: 03080000.xhp msgctxt "" @@ -2803,8 +2803,8 @@ msgctxt "" "par_id3152596\n" "6\n" "help.text" -msgid "<variable id=\"zellenuntentext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSDOWN\">Moves the contents of the selected range downward when cells are inserted.</ahelp></variable>" -msgstr "<variable id=\"zellenuntentext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSDOWN\">Moves the contents of the selected range downward when cells are inserted.</ahelp></variable>" +msgid "<variable id=\"zellenuntentext\"><ahelp hid=\"modules/scalc/ui/insertcells/down\">Moves the contents of the selected range downward when cells are inserted.</ahelp></variable>" +msgstr "" #: 04020000.xhp msgctxt "" @@ -2821,8 +2821,8 @@ msgctxt "" "par_id3144764\n" "8\n" "help.text" -msgid "<variable id=\"zellenrechtstext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSRIGHT\">Moves the contents of the selected range to the right when cells are inserted.</ahelp></variable>" -msgstr "<variable id=\"zellenrechtstext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_CELLSRIGHT\">Moves the contents of the selected range to the right when cells are inserted.</ahelp></variable>" +msgid "<variable id=\"zellenrechtstext\"><ahelp hid=\"modules/scalc/ui/insertcells/right\">Moves the contents of the selected range to the right when cells are inserted.</ahelp></variable>" +msgstr "" #: 04020000.xhp msgctxt "" @@ -2839,8 +2839,8 @@ msgctxt "" "par_id3155417\n" "10\n" "help.text" -msgid "<variable id=\"zeilenganzetext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSROWS\">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp></variable> The number of rows inserted depends on how many rows are selected. The contents of the original rows are moved downward." -msgstr "<variable id=\"zeilenganzetext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSROWS\">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp></variable> The number of rows inserted depends on how many rows are selected. The contents of the original rows are moved downward." +msgid "<variable id=\"zeilenganzetext\"><ahelp hid=\"modules/scalc/ui/insertcells/rows\">Inserts an entire row. The position of the row is determined by the selection on the sheet.</ahelp></variable> The number of rows inserted depends on how many rows are selected. The contents of the original rows are moved downward." +msgstr "" #: 04020000.xhp msgctxt "" @@ -2857,8 +2857,8 @@ msgctxt "" "par_id3155068\n" "12\n" "help.text" -msgid "<variable id=\"spaltenganzetext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSCOLS\">Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.</ahelp></variable> The contents of the original columns are shifted to the right." -msgstr "<variable id=\"spaltenganzetext\"><ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_INSCELL:BTN_INSCOLS\">Inserts an entire column. The number of the columns to be inserted is determined by the selected number of columns.</ahelp></variable> The contents of the original columns are shifted to right." +msgid "<variable id=\"spaltenganzetext\"><ahelp hid=\"modules/scalc/ui/insertcells/cols\">Inserts an entire column. The number of columns to be inserted is determined by the selected number of columns.</ahelp></variable> The contents of the original columns are shifted to the right." +msgstr "" #: 04030000.xhp msgctxt "" @@ -10757,24 +10757,6 @@ msgstr "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3= #: 04060105.xhp msgctxt "" "04060105.xhp\n" -"par_id3150538\n" -"67\n" -"help.text" -msgid "When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula." -msgstr "When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula." - -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3149128\n" -"68\n" -"help.text" -msgid "If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!" -msgstr "If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE" - -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" "hd_id3150374\n" "31\n" "help.text" @@ -11112,24 +11094,6 @@ msgstr "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3= #: 04060105.xhp msgctxt "" "04060105.xhp\n" -"par_id3153546\n" -"63\n" -"help.text" -msgid "When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula." -msgstr "When a function expects a single value, but you entered a cell range, then the value from the cell range is taken that is in the same column or row as the formula." - -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" -"par_id3149027\n" -"64\n" -"help.text" -msgid "If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE!" -msgstr "If the entered range is outside of the current column or row of the formula, the function returns the error value #VALUE" - -#: 04060105.xhp -msgctxt "" -"04060105.xhp\n" "hd_id3155517\n" "22\n" "help.text" @@ -11279,6 +11243,86 @@ msgctxt "" msgid "<item type=\"input\">=NOT(AND(A;B))</item> returns TRUE" msgstr "=NOT(AND(A;B)) returns TRUE" +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"bm_id3156257\n" +"help.text" +msgid "<bookmark_value>XOR function</bookmark_value>" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"hd_id3156257\n" +"help.text" +msgid "XOR" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3155987\n" +"help.text" +msgid "<ahelp hid=\"HID_FUNC_XOR\">Returns true if an odd number of arguments evaluates to TRUE.</ahelp>" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3148772\n" +"help.text" +msgid "The arguments are either logical expressions themselves (TRUE, 1<5, 2+3=7, B8<10) that return logical values, or arrays (A1:C3) containing logical values." +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"hd_id3153718\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3150469\n" +"help.text" +msgid "XOR(LogicalValue1; LogicalValue2 ...LogicalValue30)" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"hd_id3147176\n" +"help.text" +msgid "Example" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3083286\n" +"help.text" +msgid "<item type=\"input\">=XOR(TRUE;TRUE)</item> returns FALSE" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3083445\n" +"help.text" +msgid "<item type=\"input\">=XOR(TRUE;TRUE;TRUE)</item> returns TRUE" +msgstr "" + +#: 04060105.xhp +msgctxt "" +"04060105.xhp\n" +"par_id3154315\n" +"help.text" +msgid "<item type=\"input\">=XOR(FALSE;TRUE)</item> returns TRUE" +msgstr "" + #: 04060106.xhp msgctxt "" "04060106.xhp\n" @@ -17234,7 +17278,7 @@ msgctxt "" "04060106.xhp\n" "par_id5092318\n" "help.text" -msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select=\"sys\"><caseinline select=\"MAC\">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9." +msgid "This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9." msgstr "" #: 04060106.xhp @@ -21529,8 +21573,8 @@ msgctxt "" "par_id3154842\n" "32\n" "help.text" -msgid "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item>applications have the server name \"Soffice\"." -msgstr "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"Soffice\"." +msgid "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item>applications have the server name \"soffice\"." +msgstr "" #: 04060109.xhp msgctxt "" @@ -26014,8 +26058,8 @@ msgctxt "" "par_id3151362\n" "58\n" "help.text" -msgid "<emph>Text</emph> refers to text in which spaces are removed." -msgstr "<emph>Text</emph> refers to text in which spaces are removed." +msgid "<emph>Text</emph> refers to text in which spaces are to be removed." +msgstr "" #: 04060110.xhp msgctxt "" @@ -26032,8 +26076,8 @@ msgctxt "" "par_id3156074\n" "60\n" "help.text" -msgid "<item type=\"input\">=TRIM(\"hello\")</item> returns hello." -msgstr "TRIM(\" hello\") returns \"hello\"." +msgid "<item type=\"input\">=TRIM(\" hello world \")</item> returns hello world without leading and trailing zeros and with single space between words." +msgstr "" #: 04060110.xhp msgctxt "" @@ -30400,8 +30444,8 @@ msgctxt "" "par_id3147245\n" "59\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_IMPOWER\">The result is the integer power of a complex number.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_IMPOWER\">The result is the integer power of a complex number.</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_IMPOWER\">The result is the <emph>ComplexNumber</emph> raised to the power of <emph>Number</emph>.</ahelp>" +msgstr "" #: 04060116.xhp msgctxt "" @@ -46381,8 +46425,8 @@ msgctxt "" "par_id3154731\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_AREA\">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_AREA\">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>." +msgid "<ahelp hid=\"modules/scalc/ui/namerangesdialog/edassign\">Displays the cell reference of each label range.</ahelp> In order to remove a label range from the list box, select it and then click <emph>Delete</emph>." +msgstr "" #: 04070400.xhp msgctxt "" @@ -46399,8 +46443,8 @@ msgctxt "" "par_id3150330\n" "6\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_COLHEAD\">Includes column labels in the current label range.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_COLHEAD\">Includes column labels in the current label range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/namerangesdialog/colhead\">Includes column labels in the current label range.</ahelp>" +msgstr "" #: 04070400.xhp msgctxt "" @@ -46417,8 +46461,8 @@ msgctxt "" "par_id3154754\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ROWHEAD\">Includes row labels in the current label range.</ahelp>" -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ROWHEAD\">Includes row labels in the current label range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/namerangesdialog/rowhead\">Includes row labels in the current label range.</ahelp>" +msgstr "" #: 04070400.xhp msgctxt "" @@ -46435,8 +46479,8 @@ msgctxt "" "par_id3154703\n" "12\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_DATA\">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_COLROWNAMERANGES:ED_DATA\">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/namerangesdialog/edassign2\">Sets the data range for which the selected label range is valid. To modify it, click in the sheet and select another range with the mouse.</ahelp>" +msgstr "" #: 04070400.xhp msgctxt "" @@ -46453,8 +46497,8 @@ msgctxt "" "par_id3147005\n" "10\n" "help.text" -msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ADD\">Adds the current label range to the list.</ahelp>" -msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_COLROWNAMERANGES:BTN_ADD\">Adds the current label range to the list.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/namerangesdialog/add\">Adds the current label range to the list.</ahelp>" +msgstr "" #: 04080000.xhp msgctxt "" @@ -47073,11 +47117,20 @@ msgstr "To show a column or row, select the range of rows or columns containing #: 05030400.xhp msgctxt "" "05030400.xhp\n" -"par_id3145748\n" +"par_id3155132\n" "4\n" "help.text" +msgid "For example, to show the column B, click on the header of the column A, expand the selection to the column C, then chose <emph>Format - Column - Show</emph>. To show the column A previously hidden, click on the header of the column B, keep the mouse button pressed and drag on the left. The selected range displayed in the name area changes from B1:B1048576 to A1:B1048576. Choose <emph>Format - Column - Show</emph>. Proceed the same way with rows." +msgstr "" + +#: 05030400.xhp +msgctxt "" +"05030400.xhp\n" +"par_id3145748\n" +"5\n" +"help.text" msgid "To show all hidden cells, first click in the field in the upper left corner. This selects all cells of the table." -msgstr "To show all hidden cells, first click in the field in the upper left corner. This selects all cells of the table." +msgstr "" #: 05040000.xhp msgctxt "" @@ -48076,8 +48129,8 @@ msgctxt "" "par_id3147228\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_PRINTAREA\">Allows you to modify a defined print range.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_PRINTAREA\">Allows you to modify a defined print range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/printareasdialog/edprintarea\">Allows you to modify a defined print range.</ahelp>" +msgstr "" #: 05080300.xhp msgctxt "" @@ -48112,8 +48165,8 @@ msgctxt "" "par_id3147426\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_REPEATROW\">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, \"1\" or \"$1\" or \"$2:$3\".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_REPEATROW\">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, \"1\" or $1\" or \"$2:$3\".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row." +msgid "<ahelp hid=\"modules/scalc/ui/printareasdialog/edrepeatrow\">Choose one or more rows to print on every page. In the right text box enter the row reference, for example, \"1\" or \"$1\" or \"$2:$3\".</ahelp> The list box displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating row." +msgstr "" #: 05080300.xhp msgctxt "" @@ -48139,8 +48192,8 @@ msgctxt "" "par_id3155602\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_REPEATCOL\">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, \"A\" or \"AB\" or \"$C:$E\".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_AREAS:ED_REPEATCOL\">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, \"A\" or \"AB\" or \"$C:$E\".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column." +msgid "<ahelp hid=\"modules/scalc/ui/printareasdialog/edrepeatcol\">Choose one or more columns to print on every page. In the right text box enter the column reference, for example, \"A\" or \"AB\" or \"$C:$E\".</ahelp> The list box then displays <emph>-user defined-</emph>. You can also select <emph>-none-</emph> to remove a defined repeating column." +msgstr "" #: 05080300.xhp msgctxt "" @@ -48856,8 +48909,16 @@ msgctxt "" "par_id3163710\n" "2\n" "help.text" -msgid "<variable id=\"bedingtetext\"><ahelp hid=\".uno:ConditionalFormatDialog\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated." -msgstr "<variable id=\"bedingtetext\"><ahelp hid=\".uno:ConditionalFormatDialog\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated." +msgid "<variable id=\"bedingtetext\"><ahelp hid=\".uno:ConditionalFormatDialog\">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp></variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3163711\n" +"help.text" +msgid "You can enter several conditions that query the contents of cell values or formulas. The conditions are evaluated from the first to the last. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style is used. If this style does not match, then the next condition is evaluated and so on." +msgstr "" #: 05120000.xhp msgctxt "" @@ -48878,144 +48939,306 @@ msgstr "<bookmark_value>conditional formatting; conditions</bookmark_value>" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"hd_id3153189\n" -"18\n" +"hd_id31531891\n" "help.text" -msgid "Condition 1/2/3" -msgstr "Condition 1/2/3" +msgid "Condition" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3149413\n" -"4\n" +"par_id31494131\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3\">Mark the boxes corresponding to each condition and enter the corresponding condition.</ahelp> To close the dialog, click <emph>OK</emph>." -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3\">Mark the boxes corresponding to each condition and enter the corresponding condition.</ahelp> To close the dialog, click <emph>OK</emph>." +msgid "You can define as many conditions as you want." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494132\n" +"help.text" +msgid "Specify if conditional formatting is dependent on one of the entry listed on the drop down box:" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494133\n" +"help.text" +msgid "If you select <emph>All cells</emph>, see Color Scale, Data Bar or Icon Set explanations below, depending on which visual representation the conditional formatting should be represented." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494134\n" +"help.text" +msgid "If you select <emph>Cell value is</emph>:" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494135\n" +"help.text" +msgid "Select a condition in the drop down list for the format to be applied to the selected cells and enter the value." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494136\n" +"help.text" +msgid "In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494137\n" +"help.text" +msgid "Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494138\n" +"help.text" +msgid "In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494139\n" +"help.text" +msgid "If you select <emph>Formula is</emph> as a reference, enter a cell reference. If the cell reference is a value other than zero, the condition matches." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3149413a\n" +"help.text" +msgid "If you select <emph>Date is</emph>, see below explanations for Date." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "hd_id3147394\n" -"5\n" "help.text" -msgid "Cell Value / Formula" -msgstr "Cell Value / Formula" +msgid "Color Scale" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id3155602\n" -"6\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1\">Specifies if conditional formatting is dependent on a cell value or a formula.</ahelp> If you select a formula as a reference, the <emph>Cell Value Condition</emph> box is displayed to the right of the <emph>Cell value/Formula</emph> field. If the condition is \"Formula is\", enter a cell reference. If the cell reference is a value other than zero, the condition matches." -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1\">Specifies if conditional formatting is dependent on a cell value or a formula.</ahelp> If you select a formula as a reference, the <emph>Cell Value Condition</emph> box is displayed to the right of the <emph>Cell value/Formula</emph> field. If the condition is \"Formula is\", enter a cell reference. If the cell reference is a value other than zero, the condition matches." +msgid "This is the same dialog box as if you select <emph>All cells</emph> in the first sub menu entry <emph>Condition</emph>.Apply a color scale to a range consist of displaying a bicolor or tricolor gradient on this range depending on the value of each cell. A typical example might be an array of temperatures, lower blue colored, warmer red with a gradient nuances to the intermediate values." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3155603\n" +"help.text" +msgid "You must choose the two \"extreme\" colors indicate the method of calculation. The calculation of the color applied will be made in relation to: Min - Max - Percentile - Value - Percent - Formula." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3155604\n" +"help.text" +msgid "The choices Min and Max are sufficient to themselves as found in the range. Other options need to be specified by a value (Percentile, Value, Percentage) or a cell reference or formula (Formula)." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3155605\n" +"help.text" +msgid "For a detailed explanation and examples, please visit <link href=\"http://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page in TDF Wiki</link>." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "hd_id3153709\n" -"7\n" "help.text" -msgid "Cell Value Condition" -msgstr "Cell Value Condition" +msgid "Icon Set" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id3153764\n" -"8\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2\">Choose a condition for the format to be applied to the selected cells.</ahelp>" -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2\">Choose a condition for the format to be applied to the selected cells.</ahelp>" +msgid "It is desired to plot the position of a value relative to the thresholds. The set of icons will help to indicate the thresholds and choose the type of icons. Available icon sets are:" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494140\n" +"help.text" +msgid "3, 4 or 5 - arrows" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494141\n" +"help.text" +msgid "3, 4 or 5 - gray arrows" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494142\n" +"help.text" +msgid "3 - flags" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494143\n" +"help.text" +msgid "3 - traffic lights 1 and 2 (two different designs)" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494144\n" +"help.text" +msgid "3 - symbols (square, triangle, circle)" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494145\n" +"help.text" +msgid "4 - circles from red to black" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494146\n" +"help.text" +msgid "4 or 5 - ratings" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494147\n" +"help.text" +msgid "5 - quarters" +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3153765\n" +"help.text" +msgid "Conditions to display each icon can be specified relative to a value (Value), a percentage of the number of values in the range (Percentage) as a percentage of range values (Percentile) or formula (Formula)." +msgstr "" + +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id3155606\n" +"help.text" +msgid "For a detailed explanation and examples, please visit <link href=\"http://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formating page in TDF Wiki</link>." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "hd_id3156384\n" -"9\n" "help.text" -msgid "Cell Style" -msgstr "Стил на ќелија" +msgid "Dates" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id3145228\n" -"10\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE\">Choose the style to be applied if the specified condition matches.</ahelp>" -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE\">Choose the style to be applied if the specified condition matches.</ahelp>" +msgid "This option will apply a defined style depending on a date that you choose in the drop down box: Today - Yesterday - Tomorrow - Last 7 days - This week - Last week." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"hd_id0509200913175331\n" +"par_id31494157\n" "help.text" -msgid "New Style" +msgid "In front of <emph>Apply Styles</emph>, select the desired style in the list or chose <emph>New Style</emph> to create one." msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id0509200913175368\n" +"par_id31494167\n" "help.text" -msgid "<ahelp hid=\".\">If you haven't already defined a style to be used, you can click New Style to open the Organizer tab page of the Cell Style dialog. Define a new style there and click OK.</ahelp>" +msgid "Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition." msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"hd_id3146316\n" -"11\n" +"par_id31494177\n" "help.text" -msgid "Parameter field" -msgstr "Parameter field" +msgid "In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3155114\n" -"12\n" +"hd_id3153384\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2\" visibility=\"hidden\">Enter a reference, value or formula.</ahelp> Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2\" visibility=\"hidden\">Enter a reference, value or formula.</ahelp> Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references." +msgid "Manage Conditional Formatting" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3145257\n" -"13\n" +"par_id3155906\n" "help.text" -msgid "Once the parameters have been defined, the condition is complete. It may appear as:" -msgstr "Once the parameters have been defined, the condition is complete. It may appear as:" +msgid "This dialog allows you to see all the conditional formatting defined in the spreadsheet." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3150784\n" -"14\n" +"par_id31546818\n" "help.text" -msgid "Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition)." -msgstr "Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition)." +msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>" +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3150365\n" -"15\n" +"par_id3155907\n" "help.text" -msgid "Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21)." -msgstr "Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21)" +msgid "The <emph>Manage Conditional Formatting</emph> dialog box opens. Here you can add, edit or remove one or several conditional formattings." +msgstr "" #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id3152992\n" -"16\n" +"par_id3155908\n" "help.text" -msgid "Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10)." -msgstr "Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10." +msgid "If you have defined a conditional formatting on a cell range and you try now to define a new conditional formatting on a part of this range, a warning message will be displayed, asking if you want to edit the existing conditional formatting (on the whole range) or define a new conditional formatting overlapping it (on the selected range)." +msgstr "" #: 05120000.xhp msgctxt "" @@ -50500,8 +50723,8 @@ msgctxt "" "par_id3150770\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_DBNAMES:ED_NAME\">Enter a name for the database range that you want to define, or select an existing name from the list.</ahelp>" -msgstr "<ahelp hid=\"SC:COMBOBOX:RID_SCDLG_DBNAMES:ED_NAME\">Enter a name for the database range that you want to define, or select an existing name from the list.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/entry\">Enter a name for the database range that you want to define, or select an existing name from the list.</ahelp>" +msgstr "" #: 12010000.xhp msgctxt "" @@ -50518,8 +50741,8 @@ msgctxt "" "par_id3150441\n" "7\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_DBNAMES:ED_DBAREA\">Displays the selected cell range.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_DBNAMES:ED_DBAREA\">Displays the selected cell range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/assign\">Displays the selected cell range.</ahelp>" +msgstr "" #: 12010000.xhp msgctxt "" @@ -50536,8 +50759,8 @@ msgctxt "" "par_id3153726\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_DBNAMES:BTN_ADD\">Adds the selected cell range to the database range list, or modifies an existing database range.</ahelp>" -msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_DBNAMES:BTN_ADD\">Adds the selected cell range to the database range list, or modifies an existing database range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/add\">Adds the selected cell range to the database range list, or modifies an existing database range.</ahelp>" +msgstr "" #: 12010000.xhp msgctxt "" @@ -50554,8 +50777,8 @@ msgctxt "" "par_id3153144\n" "13\n" "help.text" -msgid "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_DBNAMES:BTN_MORE\">Shows additional <link href=\"text/scalc/01/12010100.xhp\" name=\"options\">options</link>.</ahelp>" -msgstr "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_DBNAMES:BTN_MORE\">Shows additional <link href=\"text/scalc/01/12010100.xhp\" name=\"options\">options</link>.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/more\">Shows additional <link href=\"text/scalc/01/12010100.xhp\" name=\"options\">options</link>.</ahelp>" +msgstr "" #: 12010100.xhp msgctxt "" @@ -50589,8 +50812,8 @@ msgctxt "" "par_id3148798\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_HEADER\" visibility=\"visible\">Selected cell ranges contains labels.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_HEADER\" visibility=\"visible\">Selected cell ranges contains labels.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/ContainsColumnLabels\" visibility=\"visible\">Selected cell ranges contains labels.</ahelp>" +msgstr "" #: 12010100.xhp msgctxt "" @@ -50607,8 +50830,8 @@ msgctxt "" "par_id3154684\n" "6\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_SIZE\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>." -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_SIZE\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>." +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/InsertOrDeleteCells\" visibility=\"visible\">Automatically inserts new rows and columns into the database range in your document when new records are added to the database.</ahelp> To manually update the database range, choose <emph>Data - Refresh</emph> <emph>Range</emph>." +msgstr "" #: 12010100.xhp msgctxt "" @@ -50625,8 +50848,8 @@ msgctxt "" "par_id3147435\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_FORMAT\" visibility=\"visible\">Applies the existing cell format of headers and first data row to the whole database range.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_FORMAT\" visibility=\"visible\">Applies the existing cell format of headers and first data row to the whole database range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/KeepFormatting\" visibility=\"visible\">Applies the existing cell format of headers and first data row to the whole database range.</ahelp>" +msgstr "" #: 12010100.xhp msgctxt "" @@ -50643,8 +50866,8 @@ msgctxt "" "par_id3153363\n" "10\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_STRIPDATA\" visibility=\"visible\">Only saves a reference to the database, and not the contents of the cells.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_DBNAMES:BTN_STRIPDATA\" visibility=\"visible\">Only saves a reference to the database, and not the contents of the cells.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/definedatabaserangedialog/DontSaveImportedData\" visibility=\"visible\">Only saves a reference to the database, and not the contents of the cells.</ahelp>" +msgstr "" #: 12010100.xhp msgctxt "" @@ -51377,8 +51600,8 @@ msgctxt "" "par_id3159400\n" "2\n" "help.text" -msgid "<variable id=\"zusaetzetext\"><ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_SPEC_FILTER:BTN_MORE\">Shows additional filter options.</ahelp></variable>" -msgstr "<variable id=\"zusaetzetext\"><ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_SPEC_FILTER:BTN_MORE\">Shows additional filter options.</ahelp></variable>" +msgid "<variable id=\"zusaetzetext\"><ahelp hid=\"modules/scalc/ui/advancedfilterdialog/more\">Shows additional filter options.</ahelp></variable>" +msgstr "" #: 12040201.xhp msgctxt "" @@ -51404,8 +51627,8 @@ msgctxt "" "par_id3147228\n" "6\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_CASE\">Distinguishes between uppercase and lowercase letters when filtering the data.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_CASE\">Distinguishes between uppercase and lowercase letters when filtering the data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/case\">Distinguishes between uppercase and lowercase letters when filtering the data.</ahelp>" +msgstr "" #: 12040201.xhp msgctxt "" @@ -51422,8 +51645,8 @@ msgctxt "" "par_id3153768\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_HEADER\">Includes the column labels in the first row of a cell range.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_HEADER\">Includes the column labels in the first row of a cell range.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/header\">Includes the column labels in the first row of a cell range.</ahelp>" +msgstr "" #: 12040201.xhp msgctxt "" @@ -51440,8 +51663,8 @@ msgctxt "" "par_id3154319\n" "10\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_COPY_AREA\">Select the check box, and then select the cell range where you want to display the filter results.</ahelp> You can also select a named range from the list." -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_COPY_AREA\">Select the check box, and then select the cell range where you want to display the filter results.</ahelp> You can also select a named range from the list." +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/edcopyarea\">Select the check box, and then select the cell range where you want to display the filter results.</ahelp> You can also select a named range from the list." +msgstr "" #: 12040201.xhp msgctxt "" @@ -51458,8 +51681,8 @@ msgctxt "" "par_id3152576\n" "12\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_REGEXP\">Allows you to use wildcards in the filter definition.</ahelp> For a list of the regular expressions that $[officename] supports, click <link href=\"text/shared/01/02100001.xhp\" name=\"here\">here</link>." -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_REGEXP\">Allows you to use wildcards in the filter definition.</ahelp> For a list of the regular expressions that $[officename] supports, click <link href=\"text/shared/01/02100001.xhp\" name=\"here\">here</link>." +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/regexp\">Allows you to use wildcards in the filter definition.</ahelp> For a list of the regular expressions that $[officename] supports, click <link href=\"text/shared/01/02100001.xhp\" name=\"here\">here</link>." +msgstr "" #: 12040201.xhp msgctxt "" @@ -51485,8 +51708,8 @@ msgctxt "" "par_id3153876\n" "35\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_UNIQUE\">Excludes duplicate rows in the list of filtered data.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_SPEC_FILTER:BTN_UNIQUE\">Excludes duplicate rows in the list of filtered data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/unique\">Excludes duplicate rows in the list of filtered data.</ahelp>" +msgstr "" #: 12040201.xhp msgctxt "" @@ -51503,8 +51726,8 @@ msgctxt "" "par_id3149123\n" "41\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_FILTER:BTN_DEST_PERS\">Select the <emph>Copy results to</emph> check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under <emph>Data - Define range</emph> as a database range.</ahelp> Following this, you can reapply the defined filter at any time as follows: click into the source range, then choose <emph>Data - Refresh Range</emph>." -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_FILTER:BTN_DEST_PERS\">Select the <emph>Copy results to</emph> check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under <emph>Data - Define range</emph> as a database range.</ahelp> Following this, you can reapply the defined filter at any time as follows: click into the source range, then choose <emph>Data - Refresh Range</emph>." +msgid "<ahelp hid=\"modules/scalc/ui/standardfilterdialog/destpers\">Select the <emph>Copy results to</emph> check box, and then specify the destination range where you want to display the filtered data. If this box is checked, the destination range remains linked to the source range. You must have defined the source range under <emph>Data - Define range</emph> as a database range.</ahelp> Following this, you can reapply the defined filter at any time as follows: click into the source range, then choose <emph>Data - Refresh Range</emph>." +msgstr "" #: 12040201.xhp msgctxt "" @@ -51573,8 +51796,8 @@ msgctxt "" "par_id3147426\n" "26\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_CRITERIA_AREA\">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_SPEC_FILTER:ED_CRITERIA_AREA\">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/advancedfilterdialog/edfilterarea\">Select the named range, or enter the cell range that contains the filter criteria that you want to use.</ahelp>" +msgstr "" #: 12040300.xhp msgctxt "" @@ -51590,8 +51813,8 @@ msgctxt "" "12040400.xhp\n" "tit\n" "help.text" -msgid "Remove Filter" -msgstr "Отстрани филтер" +msgid "Reset Filter" +msgstr "" #: 12040400.xhp msgctxt "" @@ -51599,8 +51822,8 @@ msgctxt "" "hd_id3153087\n" "1\n" "help.text" -msgid "<link href=\"text/scalc/01/12040400.xhp\" name=\"Remove Filter\">Remove Filter</link>" -msgstr "<link href=\"text/scalc/01/12040400.xhp\" name=\"Remove Filter\">Remove Filter</link>" +msgid "<link href=\"text/scalc/01/12040400.xhp\" name=\"Remove Filter\">Reset Filter</link>" +msgstr "" #: 12040400.xhp msgctxt "" @@ -51890,8 +52113,8 @@ msgctxt "" "par_id3147317\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_PAGEBREAK\">Inserts a new page after each group of subtotaled data.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_PAGEBREAK\">Inserts a new page after each group of subtotaled data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/pagebreak\">Inserts a new page after each group of subtotaled data.</ahelp>" +msgstr "" #: 12050200.xhp msgctxt "" @@ -51908,8 +52131,8 @@ msgctxt "" "par_id3153190\n" "6\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_CASE\">Recalculates subtotals when you change the case of a data label.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_CASE\">Recalculates subtotals when you change the case of a data label.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/case\">Recalculates subtotals when you change the case of a data label.</ahelp>" +msgstr "" #: 12050200.xhp msgctxt "" @@ -51926,8 +52149,8 @@ msgctxt "" "par_id3149664\n" "8\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_SORT\">Sorts the area that you selected in the <emph>Group by</emph> box of the Group tabs according to the columns that you selected.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_SORT\">Sorts the area that you selected in the <emph>Group by</emph> box of the Group tabs according to the columns that you selected.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/sort\">Sorts the area that you selected in the <emph>Group by</emph> box of the Group tabs according to the columns that you selected.</ahelp>" +msgstr "" #: 12050200.xhp msgctxt "" @@ -51953,8 +52176,8 @@ msgctxt "" "par_id3147125\n" "12\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_FORMATS\">Considers formatting attributes when sorting.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCPAGE_SUBT_OPTIONS:BTN_FORMATS\">Considers formatting attributes when sorting.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/formats\">Considers formatting attributes when sorting.</ahelp>" +msgstr "" #: 12050200.xhp msgctxt "" @@ -51971,8 +52194,8 @@ msgctxt "" "par_id3149400\n" "14\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCPAGE_SUBT_OPTIONS:LB_USERDEF\">Uses a custom sorting order that you defined in the Options dialog box at <emph>%PRODUCTNAME Calc - Sort Lists</emph>.</ahelp>" -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCPAGE_SUBT_OPTIONS:LB_USERDEF\">Uses a custom sorting order that you defined under <emph>Tools - Options - %PRODUCTNAME Calc - Sort Lists</emph>.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/lbuserdef\">Uses a custom sorting order that you defined in the Options dialog box at <emph>%PRODUCTNAME Calc - Sort Lists</emph>.</ahelp>" +msgstr "" #: 12050200.xhp msgctxt "" @@ -51989,8 +52212,8 @@ msgctxt "" "par_id3155068\n" "16\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_ASCENDING\">Sorts beginning with the lowest value. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on Tools - Options - Language settings - Languages." -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_ASCENDING\">Sorts beginning with the lowest value, for example, from A to Z or 0 to 9.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/ascending\">Sorts beginning with the lowest value. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on Tools - Options - Language settings - Languages." +msgstr "" #: 12050200.xhp msgctxt "" @@ -52007,8 +52230,8 @@ msgctxt "" "par_id3153766\n" "18\n" "help.text" -msgid "<ahelp hid=\"SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_DESCENDING\">Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on Tools - Options - Language settings - Languages." -msgstr "<ahelp hid=\"SC:RADIOBUTTON:RID_SCPAGE_SUBT_OPTIONS:BTN_DESCENDING\">Sorts beginning with the highest value, for example, from Z to A or 9 to 0.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/subtotaloptionspage/descending\">Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options.</ahelp> You define the default on Tools - Options - Language settings - Languages." +msgstr "" #: 12060000.xhp msgctxt "" @@ -52158,8 +52381,8 @@ msgctxt "" "par_id3149377\n" "9\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONSOLIDATE:LB_FUNC\">Select the function that you want to use to consolidate the data.</ahelp>" -msgstr "<ahelp hid=\"SC:LISTBOX:RID_SCDLG_CONSOLIDATE:LB_FUNC\">Select the function that you want to use to consolidate the data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/func\">Select the function that you want to use to consolidate the data.</ahelp>" +msgstr "" #: 12070000.xhp msgctxt "" @@ -52176,8 +52399,8 @@ msgctxt "" "par_id3151075\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS\">Displays the cell ranges that you want to consolidate.</ahelp>" -msgstr "<ahelp hid=\"SC:MULTILISTBOX:RID_SCDLG_CONSOLIDATE:LB_CONSAREAS\">Displays the cell ranges that you want to consolidate.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/consareas\">Displays the cell ranges that you want to consolidate.</ahelp>" +msgstr "" #: 12070000.xhp msgctxt "" @@ -52194,8 +52417,8 @@ msgctxt "" "par_id3153836\n" "13\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA\">Specifies the cell range that you want to consolidate with the cell ranges listed in the <emph>Consolidation ranges </emph>box. Select a cell range in a sheet, and then click <emph>Add</emph>. You can also select a the name of a predefined cell from the <emph>Source data range </emph>list.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DATA_AREA\">Specifies the cell range that you want to consolidate with the cell ranges listed in the <emph>Consolidation ranges </emph>box. Select a cell range in a sheet, and then click <emph>Add</emph>. You can also select a the name of a predefined cell from the <emph>Source data range </emph>list.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/eddataarea\">Specifies the cell range that you want to consolidate with the cell ranges listed in the <emph>Consolidation ranges </emph>box. Select a cell range in a sheet, and then click <emph>Add</emph>. You can also select a the name of a predefined cell from the <emph>Source data range </emph>list.</ahelp>" +msgstr "" #: 12070000.xhp msgctxt "" @@ -52212,8 +52435,8 @@ msgctxt "" "par_id3147341\n" "16\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA\">Displays the first cell in the range where the consolidation results will be displayed.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:RID_SCDLG_CONSOLIDATE:ED_DEST_AREA\">Displays the first cell in the range where the consolidation results will be displayed.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/eddestarea\">Displays the first cell in the range where the consolidation results will be displayed.</ahelp>" +msgstr "" #: 12070000.xhp msgctxt "" @@ -52230,8 +52453,8 @@ msgctxt "" "par_id3155335\n" "18\n" "help.text" -msgid "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_ADD\">Adds the cell range specified in the <emph>Source data range</emph> box to the <emph>Consolidation ranges </emph>box.</ahelp>" -msgstr "<ahelp hid=\"SC:PUSHBUTTON:RID_SCDLG_CONSOLIDATE:BTN_ADD\">Adds the cell range specified in the <emph>Source data range</emph> box to the <emph>Consolidation ranges </emph>box.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/add\">Adds the cell range specified in the <emph>Source data range</emph> box to the <emph>Consolidation ranges </emph>box.</ahelp>" +msgstr "" #: 12070000.xhp msgctxt "" @@ -52248,8 +52471,8 @@ msgctxt "" "par_id3159239\n" "20\n" "help.text" -msgid "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_CONSOLIDATE:BTN_MORE\">Shows additional <link href=\"text/scalc/01/12070100.xhp\" name=\"options\">options</link>.</ahelp>" -msgstr "<ahelp hid=\"SC:MOREBUTTON:RID_SCDLG_CONSOLIDATE:BTN_MORE\">Shows additional <link href=\"text/scalc/01/12070100.xhp\" name=\"options\">options</link>.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/more\">Shows additional <link href=\"text/scalc/01/12070100.xhp\" name=\"options\">options</link>.</ahelp>" +msgstr "" #: 12070100.xhp msgctxt "" @@ -52301,8 +52524,8 @@ msgctxt "" "par_id3150441\n" "5\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYROW\" visibility=\"visible\">Uses the row labels to arrange the consolidated data.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYROW\" visibility=\"visible\">Uses the row labels to arrange the consolidated data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/byrow\" visibility=\"visible\">Uses the row labels to arrange the consolidated data.</ahelp>" +msgstr "" #: 12070100.xhp msgctxt "" @@ -52319,8 +52542,8 @@ msgctxt "" "par_id3155411\n" "7\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYCOL\" visibility=\"visible\">Uses the column labels to arrange the consolidated data.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_BYCOL\" visibility=\"visible\">Uses the column labels to arrange the consolidated data.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/bycol\" visibility=\"visible\">Uses the column labels to arrange the consolidated data.</ahelp>" +msgstr "" #: 12070100.xhp msgctxt "" @@ -52346,8 +52569,8 @@ msgctxt "" "par_id3146986\n" "9\n" "help.text" -msgid "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_REFS\" visibility=\"visible\">Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed.</ahelp>" -msgstr "<ahelp hid=\"SC:CHECKBOX:RID_SCDLG_CONSOLIDATE:BTN_REFS\" visibility=\"visible\">Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/consolidatedialog/refs\" visibility=\"visible\">Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed.</ahelp>" +msgstr "" #: 12070100.xhp msgctxt "" @@ -55386,8 +55609,8 @@ msgctxt "" "par_id3147229\n" "2\n" "help.text" -msgid "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_INPUTHELP\">Enter the message that you want to display when the cell or cell range is selected in the sheet.</ahelp>" -msgstr "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_INPUTHELP\">Enter the message that you want to display when the cell or cell range is selected in the sheet.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/ValidationHelpTabPage\">Enter the message that you want to display when the cell or cell range is selected in the sheet.</ahelp>" +msgstr "" #: 12120200.xhp msgctxt "" @@ -55404,8 +55627,8 @@ msgctxt "" "par_id3153363\n" "4\n" "help.text" -msgid "<ahelp hid=\"SC:TRISTATEBOX:TP_VALIDATION_INPUTHELP:TSB_HELP\">Displays the message that you enter in the <emph>Contents</emph> box when the cell or cell range is selected in the sheet.</ahelp>" -msgstr "<ahelp hid=\"SC:TRISTATEBOX:TP_VALIDATION_INPUTHELP:TSB_HELP\">Displays the message that you enter in the <emph>Contents</emph> box when the cell or cell range is selected in the sheet.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/tsbhelp\">Displays the message that you enter in the <emph>Contents</emph> box when the cell or cell range is selected in the sheet.</ahelp>" +msgstr "" #: 12120200.xhp msgctxt "" @@ -55440,8 +55663,8 @@ msgctxt "" "par_id3149400\n" "9\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:TP_VALIDATION_INPUTHELP:EDT_TITLE\">Enter the title that you want to display when the cell or cell range is selected.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:TP_VALIDATION_INPUTHELP:EDT_TITLE\">Enter the title that you want to display when the cell or cell range is selected.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/title\">Enter the title that you want to display when the cell or cell range is selected.</ahelp>" +msgstr "" #: 12120200.xhp msgctxt "" @@ -55458,8 +55681,8 @@ msgctxt "" "par_id3150752\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:MULTILINEEDIT:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP\">Enter the message that you want to display when the cell or cell range is selected.</ahelp>" -msgstr "<ahelp hid=\"SC:MULTILINEEDIT:TP_VALIDATION_INPUTHELP:EDT_INPUTHELP\">Enter the message that you want to display when the cell or cell range is selected.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/validationhelptabpage/inputhelp\">Enter the message that you want to display when the cell or cell range is selected.</ahelp>" +msgstr "" #: 12120300.xhp msgctxt "" @@ -55484,8 +55707,8 @@ msgctxt "" "par_id3153379\n" "2\n" "help.text" -msgid "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_ERROR\">Define the error message that is displayed when invalid data is entered in a cell.</ahelp>" -msgstr "<ahelp hid=\"SC:TABPAGE:TP_VALIDATION_ERROR\">Define the error message that is displayed when invalid data is entered in a cell.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/ErrorAlertTabPage\">Define the error message that is displayed when invalid data is entered in a cell.</ahelp>" +msgstr "" #: 12120300.xhp msgctxt "" @@ -55547,8 +55770,8 @@ msgctxt "" "par_id3151115\n" "9\n" "help.text" -msgid "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_ERROR:LB_ACTION\">Select the action that you want to occur when invalid data is entered in a cell.</ahelp> The \"Stop\" action rejects the invalid entry and displays a dialog that you have to close by clicking <emph>OK</emph>. The \"Warning\" and \"Information\" actions display a dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>. The invalid entry is only rejected when you click <emph>Cancel</emph>." -msgstr "<ahelp hid=\"SC:LISTBOX:TP_VALIDATION_ERROR:LB_ACTION\">Select the action that you want to occur when invalid data is entered in a cell.</ahelp> The \"Stop\" action rejects the invalid entry and displays a dialog that you have to close by clicking <emph>OK</emph>. The \"Warning\" and \"Information\" actions display a dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>. The invalid entry is only rejected when you click <emph>Cancel</emph>." +msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/actionCB\">Select the action that you want to occur when invalid data is entered in a cell.</ahelp> The \"Stop\" action rejects the invalid entry and displays a dialog that you have to close by clicking <emph>OK</emph>. The \"Warning\" and \"Information\" actions display a dialog that can be closed by clicking <emph>OK</emph> or <emph>Cancel</emph>. The invalid entry is only rejected when you click <emph>Cancel</emph>." +msgstr "" #: 12120300.xhp msgctxt "" @@ -55565,8 +55788,8 @@ msgctxt "" "par_id3153160\n" "11\n" "help.text" -msgid "<ahelp hid=\"SC:PUSHBUTTON:TP_VALIDATION_ERROR:BTN_SEARCH\">Opens the <link href=\"text/shared/01/06130000.xhp\" name=\"Macro\">Macro</link> dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.</ahelp>" -msgstr "<ahelp hid=\"SC:PUSHBUTTON:TP_VALIDATION_ERROR:BTN_SEARCH\">Opens the <link href=\"text/shared/01/06130000.xhp\" name=\"Macro\">Macro</link> dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/browseBtn\">Opens the <link href=\"text/shared/01/06130000.xhp\" name=\"Macro\">Macro</link> dialog where you can select the macro that is executed when invalid data is entered in a cell. The macro is executed after the error message is displayed.</ahelp>" +msgstr "" #: 12120300.xhp msgctxt "" @@ -55583,8 +55806,8 @@ msgctxt "" "par_id3149410\n" "13\n" "help.text" -msgid "<ahelp hid=\"SC:EDIT:TP_VALIDATION_ERROR:EDT_TITLE\">Enter the title of the macro or the error message that you want to display when invalid data is entered in a cell.</ahelp>" -msgstr "<ahelp hid=\"SC:EDIT:TP_VALIDATION_ERROR:EDT_TITLE\">Enter the title of the macro or the error message that you want to display when invalid data is entered in a cell.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/title\">Enter the title of the macro or the error message that you want to display when invalid data is entered in a cell.</ahelp>" +msgstr "" #: 12120300.xhp msgctxt "" @@ -55601,8 +55824,8 @@ msgctxt "" "par_id3149122\n" "15\n" "help.text" -msgid "<ahelp hid=\"SC:MULTILINEEDIT:TP_VALIDATION_ERROR:EDT_ERROR\">Enter the message that you want to display when invalid data is entered in a cell.</ahelp>" -msgstr "<ahelp hid=\"SC:MULTILINEEDIT:TP_VALIDATION_ERROR:EDT_ERROR\">Enter the message that you want to display when invalid data is entered in a cell.</ahelp>" +msgid "<ahelp hid=\"modules/scalc/ui/erroralerttabpage/errorMsg\">Enter the message that you want to display when invalid data is entered in a cell.</ahelp>" +msgstr "" #: 12120300.xhp msgctxt "" @@ -56537,8 +56760,8 @@ msgctxt "" "par_id3150880\n" "214\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_EDATE\">The result is a date which is a number of m<emph>onths</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_EDATE\">The result is a date which is a number of <emph>Months</emph> away from the <emph>Start date</emph>. Only months are considered; days are not used for calculation.</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_EDATE\">The result is a date which is a number of <emph>months</emph> away from the <emph>start date</emph>. Only months are considered; days are not used for calculation.</ahelp>" +msgstr "" #: func_edate.xhp msgctxt "" @@ -56591,8 +56814,8 @@ msgctxt "" "par_id3155845\n" "220\n" "help.text" -msgid "What date is one month prior to 3.31.2001?" -msgstr "What date is one month prior to 3.31.2001?" +msgid "What date is one month prior to 2001-03-31?" +msgstr "" #: func_edate.xhp msgctxt "" @@ -56600,8 +56823,8 @@ msgctxt "" "par_id3155999\n" "221\n" "help.text" -msgid "<item type=\"input\">=EDATE(3.31.2001;-1)</item> returns 2.28.2001." -msgstr "=EDATE(\"3.31.2001\";-1) returns 2.28.2001." +msgid "<item type=\"input\">=EDATE(\"2001-03-31\";-1)</item> returns the serial number 36950. Formatted as a date, this is 2001-02-28." +msgstr "" #: func_eomonth.xhp msgctxt "" @@ -58148,8 +58371,8 @@ msgctxt "" "par_id3150899\n" "197\n" "help.text" -msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\"> The result is a number between 0 and 1, representing the fraction of a year between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>" -msgstr "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\"> The result is a number between 0 and 1, representing the fraction of a year between <emph>Start date</emph> and <emph>End date</emph>.</ahelp>" +msgid "<ahelp hid=\"HID_AAI_FUNC_YEARFRAC\">The result is the number of the years (including fractional part) between <emph>StartDate</emph> and <emph>EndDate</emph>.</ahelp>" +msgstr "" #: func_yearfrac.xhp msgctxt "" |