diff options
Diffstat (limited to 'source/is/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/is/helpcontent2/source/text/scalc/01.po | 1469 |
1 files changed, 1243 insertions, 226 deletions
diff --git a/source/is/helpcontent2/source/text/scalc/01.po b/source/is/helpcontent2/source/text/scalc/01.po index 3b01f66f015..405558a4997 100644 --- a/source/is/helpcontent2/source/text/scalc/01.po +++ b/source/is/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2022-07-04 18:04+0200\n" +"POT-Creation-Date: 2022-10-10 13:35+0200\n" "PO-Revision-Date: 2020-02-05 20:05+0000\n" "Last-Translator: Sveinn í Felli <sv1@fellsnet.is>\n" "Language-Team: Icelandic <https://weblate.documentfoundation.org/projects/libo_help-master/textscalc01/is/>\n" @@ -2842,22 +2842,22 @@ msgctxt "" msgid "Go to Sheet" msgstr "" -#. W6vyo +#. 88YoD #: 02220000.xhp msgctxt "" "02220000.xhp\n" "bm_id781654171314500\n" "help.text" -msgid "<bookmark_value>Go to sheet</bookmark_value><bookmark_value>jump; to given sheet</bookmark_value><bookmark_value>sheet; go to directly</bookmark_value><bookmark_value>sheet; search and go to</bookmark_value>" +msgid "<bookmark_value>Go to sheet</bookmark_value> <bookmark_value>jump; to given sheet</bookmark_value> <bookmark_value>sheet; go to directly</bookmark_value> <bookmark_value>sheet; search and go to</bookmark_value>" msgstr "" -#. Af3Da +#. svg9x #: 02220000.xhp msgctxt "" "02220000.xhp\n" "hd_id3156025\n" "help.text" -msgid "Go to Sheet" +msgid "<variable id=\"GotoSheeth1\"><link href=\"text/scalc/01/02220000.xhp\" name=\"Go to Sheet\">Go to Sheet</link></variable>" msgstr "" #. UmffC @@ -2869,6 +2869,15 @@ msgctxt "" msgid "<variable id=\"gototable\"><ahelp hid=\".uno:JumpToTable\" visibility=\"visible\">Go to a specified sheet.</ahelp></variable>" msgstr "" +#. ghXGk +#: 02220000.xhp +msgctxt "" +"02220000.xhp\n" +"par_id231655657630178\n" +"help.text" +msgid "Choose <menuitem>Sheet - Navigate - Go To Sheet</menuitem>." +msgstr "" + #. dPFgf #: 02220000.xhp msgctxt "" @@ -2878,13 +2887,13 @@ msgctxt "" msgid "Type a sheet name" msgstr "" -#. hyRiU +#. guUL9 #: 02220000.xhp msgctxt "" "02220000.xhp\n" "par_id3153975\n" "help.text" -msgid "<ahelp hid=\"SC_HID_GOTOTABLEMASK\">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters.</ahelp>" +msgid "<ahelp hid=\"SC_HID_GOTOTABLEMASK\">Type some characters contained in the searched sheet name. List of sheets will be limited to the sheet names containing these characters. Search is case-sensitive. If empty, all visible sheets are listed.</ahelp>" msgstr "" #. aCw4F @@ -2896,13 +2905,13 @@ msgctxt "" msgid "Sheets" msgstr "" -#. XJVcD +#. JEuum #: 02220000.xhp msgctxt "" "02220000.xhp\n" "par_id3153971\n" "help.text" -msgid "<ahelp hid=\"SC_HID_GOTOTABLE\">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double click on a name will directly jump to this sheet.</ahelp>" +msgid "<ahelp hid=\"SC_HID_GOTOTABLE\">Lists the sheets in the current document. Hidden sheets are not listed. To select a sheet, press the up or down arrow keys to move to a sheet in the list. Double-clicking on a name will directly jump to this sheet.</ahelp>" msgstr "" #. eomCF @@ -6298,13 +6307,13 @@ msgctxt "" msgid "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units." msgstr "" -#. AvpDv +#. aG2TT #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id851616615176815\n" "help.text" -msgid "Beware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel." +msgid "Be aware that Basis 2 is not supported by Microsoft Excel. Hence, if you use Basis 2 and export your document to XLSX format, it will return an error when opened in Excel." msgstr "" #. UCPgp @@ -10546,14 +10555,14 @@ msgctxt "" msgid "<item type=\"input\">=AND(12<13;14>12;7<6)</item> returns FALSE." msgstr "<item type=\"input\">=AND(12<13;14>12;7<6)</item> skilar ÓSATT." -#. EuCHs +#. 3MAQE #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3149946\n" "help.text" -msgid "<item type=\"input\">=AND (FALSE;TRUE)</item> returns FALSE." -msgstr "<item type=\"input\">=AND (FALSE;TRUE)</item> skilar ÓSATT." +msgid "<item type=\"input\">=AND(FALSE();TRUE())</item> returns FALSE." +msgstr "" #. XXJC8 #: 04060105.xhp @@ -10816,14 +10825,14 @@ msgctxt "" msgid "<item type=\"input\">=OR(12<11;13>22;45=45)</item> returns TRUE." msgstr "<item type=\"input\">=OR(12<11;13>22;45=45)</item> skilar SATT." -#. ExAZa +#. sqF5J #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3158412\n" "help.text" -msgid "<item type=\"input\">=OR(FALSE;TRUE)</item> returns TRUE." -msgstr "<item type=\"input\">=OR(FALSE;TRUE)</item> skilar SATT." +msgid "<item type=\"input\">=OR(FALSE();TRUE())</item> returns TRUE." +msgstr "" #. B2UcY #: 04060105.xhp @@ -10942,32 +10951,32 @@ msgctxt "" msgid "XOR(<embedvar href=\"text/scalc/01/ful_func.xhp#logical255_1\" markup=\"keep\"/>)" msgstr "" -#. qpsgo +#. 2QMxz #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3083286\n" "help.text" -msgid "<item type=\"input\">=XOR(TRUE;TRUE)</item> returns FALSE" -msgstr "<item type=\"input\">=XOR(TRUE;TRUE)</item> skilar ÓSATT" +msgid "<item type=\"input\">=XOR(TRUE();TRUE())</item> returns FALSE" +msgstr "" -#. dcNVj +#. sACsD #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3083445\n" "help.text" -msgid "<item type=\"input\">=XOR(TRUE;TRUE;TRUE)</item> returns TRUE" -msgstr "<item type=\"input\">=XOR(TRUE;TRUE;TRUE)</item> skilar SATT" +msgid "<item type=\"input\">=XOR(TRUE();TRUE();TRUE())</item> returns TRUE" +msgstr "" -#. ewhWG +#. Uhsea #: 04060105.xhp msgctxt "" "04060105.xhp\n" "par_id3154315\n" "help.text" -msgid "<item type=\"input\">=XOR(FALSE;TRUE)</item> returns TRUE" -msgstr "<item type=\"input\">=XOR(FALSE;TRUE)</item> skilar SATT" +msgid "<item type=\"input\">=XOR(FALSE();TRUE())</item> returns TRUE" +msgstr "" #. 3Ed6j #: 04060106.xhp @@ -20077,13 +20086,13 @@ msgctxt "" msgid "You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) & \"The Catcher in the Rye\" & UNICHAR(34) & \" is a famous book by J. D. Salinger.\"</input> displays the string <literal>\"The Catcher in the Rye\" is a famous book by J. D. Salinger.</literal>" msgstr "" -#. cpK3Z +#. wDvCT #: 04060110.xhp msgctxt "" "04060110.xhp\n" "par_id401624454547945\n" "help.text" -msgid "Beware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature." +msgid "Be aware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature." msgstr "" #. rdzbS @@ -45059,13 +45068,13 @@ msgctxt "" msgid "You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If <emph>Condition 1</emph> is true based on the current cell contents, the corresponding cell style is applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format." msgstr "" -#. GNdvU +#. 9vjYD #: 05120000.xhp msgctxt "" "05120000.xhp\n" "par_id431642031216368\n" "help.text" -msgid "Conditional formats do no overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats." +msgid "Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats." msgstr "" #. AMXCn @@ -45077,6 +45086,33 @@ msgctxt "" msgid "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled)." msgstr "" +#. Kp2g2 +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"hd_id961662926287139\n" +"help.text" +msgid "Cell range" +msgstr "" + +#. Gv4oU +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"hd_id431662926282555\n" +"help.text" +msgid "Range" +msgstr "" + +#. BoUXF +#: 05120000.xhp +msgctxt "" +"05120000.xhp\n" +"par_id31494138\n" +"help.text" +msgid "Defines 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 "" + #. NvgCF #: 05120000.xhp msgctxt "" @@ -45140,415 +45176,1396 @@ msgctxt "" msgid "<ahelp hid=\".\">Decrease priority of the selected condition.</ahelp>" msgstr "" -#. FZJa2 +#. niBsF #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"hd_id31531891\n" +"hd_id71662926011736\n" "help.text" -msgid "Condition list entry" +msgid "Add" msgstr "" -#. YLwyA +#. NiRqU #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494132\n" +"par_id721662926016039\n" "help.text" -msgid "Specify if conditional formatting is dependent on one of the entry listed on the drop down box:" +msgid "Adds the condition to the condition list." msgstr "" -#. ApsPx +#. EXu3U #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494133\n" +"hd_id401662926020291\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." +msgid "Delete" msgstr "" -#. gtbEv +#. njCNL #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494134\n" +"par_id301662926026944\n" "help.text" -msgid "If you select <emph>Cell value is</emph>:" +msgid "Deletes the condition from the condition list." msgstr "" -#. XgjY5 +#. ZSEod #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494135\n" +"hd_id31531891\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." +msgid "Condition list entries" msgstr "" -#. VeDFA +#. udAbc #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494136\n" +"par_id31494132\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." +msgid "Specify if conditional formatting is dependent on one of the entry listed on the drop down box." msgstr "" -#. FVRBc +#. WsjTp #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494137\n" +"hd_id431662938949798\n" "help.text" -msgid "<ahelp hid=\".\">Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition.</ahelp>" +msgid "Apply Style" msgstr "" -#. NV9Lr +#. 8WfD4 #: 05120000.xhp msgctxt "" "05120000.xhp\n" -"par_id31494138\n" +"par_id971662939043786\n" "help.text" -msgid "<ahelp hid=\".\">In the <emph>Range</emph> field, define the range of cells concerned by the conditional formatting.</ahelp> 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." +msgid "Select the cell style to apply when the condition is verified. Select <emph>New Style</emph> to open the <link href=\"text/scalc/01/cell_styles.xhp\" name=\"cellstyledialog\">Cell Style dialog</link> and define the style properties." msgstr "" -#. 3noEQ -#: 05120000.xhp +#. CHbab +#: 05120100.xhp msgctxt "" -"05120000.xhp\n" +"05120100.xhp\n" +"tit\n" +"help.text" +msgid "Conditional Formatting - Cell value is" +msgstr "" + +#. XZ4AV +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"hd_id431662935550205\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120100.xhp\" name=\"Cell Value\">Condition - Cell value is</link></variable>" +msgstr "" + +#. RtY8f +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id11662915615351\n" +"help.text" +msgid "Applies a cell style on the cell or cell range controlled by the condition set in the drop down list. The formatting is applied to each cell individually and the condition may depend on other cells values of the selected range." +msgstr "" + +#. fkuaH +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id181662913907279\n" +"help.text" +msgid "Condition" +msgstr "" + +#. gJBMQ +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id221663406419144\n" +"help.text" +msgid "Applies on" +msgstr "" + +#. Yd3xQ +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id941662913907280\n" +"help.text" +msgid "Description" +msgstr "" + +#. nP5Ym +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id31662913907282\n" +"help.text" +msgid "is equal to" +msgstr "" + +#. rWJoB +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id321663406539530\n" +"help.text" +msgid "<variable id=\"numbertext\">Numbers and text</variable>" +msgstr "" + +#. bYfTW +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id881662913907284\n" +"help.text" +msgid "The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values." +msgstr "" + +#. ziYCE +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id271662914239763\n" +"help.text" +msgid "is less than" +msgstr "" + +#. bS8eG +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id121663406585137\n" +"help.text" +msgid "<variable id=\"numbers\">Numbers</variable>" +msgstr "" + +#. BdnvW +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id501662914239764\n" +"help.text" +msgid "The cell value is strictly less than the user defined value in the text box in the right." +msgstr "" + +#. Zyiqi +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id701662914433053\n" +"help.text" +msgid "is greater than" +msgstr "" + +#. PCZug +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id461662914433054\n" +"help.text" +msgid "The cell value is strictly greater than the user defined value in the text box in the right." +msgstr "" + +#. zTBff +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id421662914480517\n" +"help.text" +msgid "is less than or equal to" +msgstr "" + +#. Cy2T9 +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id631662914480518\n" +"help.text" +msgid "The cell value is less than or equal to the user defined value in the text box in the right." +msgstr "" + +#. cFMZa +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id651662914713102\n" +"help.text" +msgid "is greater than or equal to" +msgstr "" + +#. YG9FG +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id251662914713103\n" +"help.text" +msgid "The cell value is greater than or equal to the user defined value in the text box in the right." +msgstr "" + +#. Pbje6 +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id831662914760085\n" +"help.text" +msgid "is not equal to" +msgstr "" + +#. T8x2N +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id301662914760087\n" +"help.text" +msgid "The cell value is not equal (different) to the user defined value in the text box in the right. Use text inside quotes if you compare text values." +msgstr "" + +#. B6eGh +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id81662914901503\n" +"help.text" +msgid "is between" +msgstr "" + +#. ZmHDH +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id21662914901504\n" +"help.text" +msgid "The cell value is between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves." +msgstr "" + +#. PGH34 +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id411662915178872\n" +"help.text" +msgid "is not between" +msgstr "" + +#. dECpd +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id861662915178873\n" +"help.text" +msgid "The cell value is not between the two values defined in the text boxes on the right - lower and upper values - including the boundary values themselves." +msgstr "" + +#. zqVSC +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id731662915275926\n" +"help.text" +msgid "is duplicate" +msgstr "" + +#. 4DKbK +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id881662915275927\n" +"help.text" +msgid "The cell and at least one other cell in the range have equal contents." +msgstr "" + +#. UC2gL +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id381662915857686\n" +"help.text" +msgid "is not duplicate" +msgstr "" + +#. ZBUgm +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id341662915857687\n" +"help.text" +msgid "The cell contents is unique in the range." +msgstr "" + +#. c8Bkp +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id1001662915996409\n" +"help.text" +msgid "is in top N elements" +msgstr "" + +#. pDAGV +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id571662915996410\n" +"help.text" +msgid "The cell value is between the maximum value in the range and the N<sup>th</sup> greater element of the same. Enter the value of N in the text box on the right." +msgstr "" + +#. V4FnF +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id341662916338175\n" +"help.text" +msgid "is in bottom N elements" +msgstr "" + +#. UDdhD +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id11662916338177\n" +"help.text" +msgid "The cell value is between the minimum value in the range and the N<sup>th</sup> lower element of the same. Enter the value of N in the text box on the right." +msgstr "" + +#. a9GoR +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id181662916407095\n" +"help.text" +msgid "is in top N percent" +msgstr "" + +#. rgUnx +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id911662916407097\n" +"help.text" +msgid "The <emph>cell range index value is in the top N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 last cells of the range. Enter the value of N in the text box on the right." +msgstr "" + +#. kfDTU +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id421662917285432\n" +"help.text" +msgid "is in bottom N percent" +msgstr "" + +#. pphGh +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id111662917285433\n" +"help.text" +msgid "The <emph>cell range index value is in the bottom N percent</emph> of the number of cells in the range. For example, in a 20 cells range and N equals 20, the style is applied to the 4 first cells of the range. Enter the value of N in the text box on the right." +msgstr "" + +#. W6QVL +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id861662917382735\n" +"help.text" +msgid "is above average" +msgstr "" + +#. YM3iz +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id811662917382736\n" +"help.text" +msgid "The cell value is strictly greater than the average of the cell range values." +msgstr "" + +#. AAKPP +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id421662919561954\n" +"help.text" +msgid "is below average" +msgstr "" + +#. DAPwV +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id661662919561956\n" +"help.text" +msgid "The cell value is strictly less than the average of the cell range values." +msgstr "" + +#. 5cN4q +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id831662919693474\n" +"help.text" +msgid "is above or equal average" +msgstr "" + +#. dk8XB +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id71662919693475\n" +"help.text" +msgid "The cell value is greater or equal than the average of the cell range values." +msgstr "" + +#. HuZ9i +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id521662919771410\n" +"help.text" +msgid "is below or equal average" +msgstr "" + +#. GRFFh +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id131662919771411\n" +"help.text" +msgid "The cell value is less or equal than the average of the cell range values." +msgstr "" + +#. vFFDn +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id451662919849856\n" +"help.text" +msgid "is error" +msgstr "" + +#. d8WFb +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id911662919849857\n" +"help.text" +msgid "The cell is in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>." +msgstr "" + +#. DAG5B +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id61662920733334\n" +"help.text" +msgid "A cell that references another cell with an error condition is not in error itself." +msgstr "" + +#. uUxWk +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id961662920774180\n" +"help.text" +msgid "is not error" +msgstr "" + +#. BzFfB +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id381662920774181\n" +"help.text" +msgid "The cell is not in the error condition defined in the text box on the right. <link href=\"text/scalc/05/02140000.xhp\" name=\"calc errors\">List of Calc errors</link>" +msgstr "" + +#. uEArp +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id151662920861587\n" +"help.text" +msgid "begins with" +msgstr "" + +#. SrP9B +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id341662920861588\n" +"help.text" +msgid "The cell contents begins with the text or number defined in the text box on the right." +msgstr "" + +#. yF6EV +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id801662922586796\n" +"help.text" +msgid "<variable id=\"text_comparison\">The condition applies to the internal text conversion of the cell contents. Numeric values are compared with their equivalent text representation. Numeric cell formats (currency, scientific, user-defined ... ) are not considered for comparisons.</variable>" +msgstr "" + +#. v76zE +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id361662922600585\n" +"help.text" +msgid "ends with" +msgstr "" + +#. Ag7VY +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id801662922600586\n" +"help.text" +msgid "The cell contents ends with the text or number defined in the right text box." +msgstr "" + +#. kDJVK +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id151662922939292\n" +"help.text" +msgid "contains" +msgstr "" + +#. b4MWb +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id251662922939293\n" +"help.text" +msgid "The cell contents contains the text or number defined in the right text box." +msgstr "" + +#. ugaZe +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id291662923021542\n" +"help.text" +msgid "does not contain" +msgstr "" + +#. CyQm8 +#: 05120100.xhp +msgctxt "" +"05120100.xhp\n" +"par_id541662923021543\n" +"help.text" +msgid "The cell contents does not contains the text or number defined in the text box on the right." +msgstr "" + +#. 4zHYR +#: 05120200.xhp +msgctxt "" +"05120200.xhp\n" +"tit\n" +"help.text" +msgid "Conditional Formatting - Formula is" +msgstr "" + +#. pRBn3 +#: 05120200.xhp +msgctxt "" +"05120200.xhp\n" +"hd_id471662936567369\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120200.xhp\" name=\"Formula is\">Condition - Formula is</link></variable>" +msgstr "" + +#. WwqGv +#: 05120200.xhp +msgctxt "" +"05120200.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." +msgid "Applies the selected style to the cell when the formula expression in the text box in the right is <emph>not</emph> zero." msgstr "" -#. bErXu -#: 05120000.xhp +#. S3dcs +#: 05120200.xhp msgctxt "" -"05120000.xhp\n" -"par_id3149413a\n" +"05120200.xhp\n" +"par_id1001662932287796\n" "help.text" -msgid "If you select <emph>Date is</emph>, see below explanations for Date." +msgid "The formula is expressed similar to a test condition evaluating to <literal>TRUE</literal> or <literal>FALSE</literal>." msgstr "" -#. GFxCV -#: 05120000.xhp +#. dAQYf +#: 05120200.xhp msgctxt "" -"05120000.xhp\n" +"05120200.xhp\n" +"par_id111662936728630\n" +"help.text" +msgid "For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents." +msgstr "" + +#. PJRcV +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"tit\n" +"help.text" +msgid "Conditional Formatting - Date is" +msgstr "" + +#. 9mjQT +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"hd_id321662936831682\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120300.xhp\" name=\"Date is\">Condition - Date is</link></variable>" +msgstr "" + +#. eZ8g9 +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id31662934883939\n" +"help.text" +msgid "Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the dropdown list." +msgstr "" + +#. FuPW5 +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id231662933568615\n" +"help.text" +msgid "<emph>Today</emph>: applies the cell style if the cell date contents is today." +msgstr "" + +#. Jp3xf +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id891662933647849\n" +"help.text" +msgid "<emph>Yesterday</emph>: applies the cell style if the cell date contents is yesterday." +msgstr "" + +#. kGKdd +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id701662933702962\n" +"help.text" +msgid "<emph>Tomorrow</emph>: applies the cell style if the cell date contents is tomorrow." +msgstr "" + +#. qiPQc +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id291662933755624\n" +"help.text" +msgid "<emph>Last 7 days</emph>: applies the cell style if the cell date contents is in the last 7 calendar days." +msgstr "" + +#. ReAps +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id151662933849611\n" +"help.text" +msgid "<emph>This week, Last week and Next week</emph>: applies the cell style if the cell date contents is in this week, last week and next week respectively. The start and end of the week is locale dependent." +msgstr "" + +#. 6bfmv +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id421662934429482\n" +"help.text" +msgid "<emph>This month, Last month and Next month</emph>: applies the cell style if the cell date contents is in this month, last month and next month respectively." +msgstr "" + +#. xduEr +#: 05120300.xhp +msgctxt "" +"05120300.xhp\n" +"par_id461662934605639\n" +"help.text" +msgid "<emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively." +msgstr "" + +#. ZANZR +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"tit\n" +"help.text" +msgid "Conditional Formatting - All cells" +msgstr "" + +#. EcBzD +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"hd_id861662937013389\n" +"help.text" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120400.xhp\" name=\"All cells\">Condition - All cells</link></variable>" +msgstr "" + +#. Bstud +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id31662915586650\n" +"help.text" +msgid "Applies the conditional formatting to the set of cells defined in the selected range. The formatting is applied based on the contents of the whole range." +msgstr "" + +#. UrbTk +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "hd_id3147394\n" "help.text" -msgid "Color Scale" +msgid "<link href=\"text/scalc/01/05120400.xhp#colorscale\" name=\"Color Scale\">Color Scale</link>" msgstr "" -#. mbqvS -#: 05120000.xhp +#. VvAiE +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" "par_id3155602\n" "help.text" -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." +msgid "Applies a color scale to a range consisting of displaying a bicolor or tricolor gradient on this range depending on the value of each cell." msgstr "" -#. DuNBp -#: 05120000.xhp +#. S9Btk +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3155603\n" +"05120400.xhp\n" +"hd_id541663598275609\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." +msgid "Conditions" msgstr "" -#. 6Ggqk -#: 05120000.xhp +#. zip59 +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3155604\n" +"05120400.xhp\n" +"par_id231663598294535\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)." +msgid "The calculation of the color scale depends on 2 or 3 conditions, defined as follows:" msgstr "" -#. 9jo8a -#: 05120000.xhp +#. XKMSV +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3155605\n" +"05120400.xhp\n" +"par_id701864449697771\n" "help.text" -msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki." +msgid "<emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range." msgstr "" -#. dACxH -#: 05120000.xhp +#. eGYev +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id321663440728295\n" +"help.text" +msgid "<emph>Value</emph>: a fixed value. Enter the value in the text box." +msgstr "" + +#. DZxAs +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id611663440697270\n" +"help.text" +msgid "<emph>Percentile</emph>: A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For P = 25, the percentile means the first quartile. P = 50 is also the MEDIAN of the data set. Enter the percentile value in the text box. Valid values are from 0 to 100." +msgstr "" + +#. zwwLa +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id211663440834104\n" +"help.text" +msgid "<emph>Percent</emph>: a fixed value representing the percentage of the minimum (maximum) of the length defined by minimum and maximum values in the range. A minimum of 10% selects the values below 10% of the segment [Min,Max]. A maximum of 80% select values above 80% of the segment [Min,Max]. Valid values are from 0 (zero) to 100. Do not enter a percent (%) sign." +msgstr "" + +#. nF8iD +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id961663440848168\n" +"help.text" +msgid "<emph>Formula</emph>: A formula expression starting with the equal sign (=) that calculates a numeric value. Values can be numbers, dates or time. Enter the formula expression in the text box." +msgstr "" + +#. rDuW2 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id991609782427459\n" "help.text" -msgid "Data Bar" +msgid "<link href=\"text/scalc/01/05120400.xhp#databar\" name=\"Data Bar\">Data Bar</link>" msgstr "" -#. xapwr -#: 05120000.xhp +#. ZEyNr +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" "par_id41609780964157\n" "help.text" -msgid "Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell. Default is blue for positive and red for negative." +msgid "Data bar option will fill the cell with solid or gradient color corresponding to the numeric value in the cell." msgstr "" -#. AKYoW -#: 05120000.xhp +#. WHWWc +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"hd_id631663449553346\n" +"help.text" +msgid "Conditions" +msgstr "" + +#. CENjM +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id931609781970981\n" "help.text" -msgid "The calculation of the area of fill is based on Min - Max - Percentile - Value - Percent - Formula." +msgid "The calculation of the bar area fill is based on the conditions below:" msgstr "" -#. smxFL -#: 05120000.xhp +#. DzwrN +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id981609782003841\n" +"05120400.xhp\n" +"par_id281663449673792\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)." +msgid "<emph>Automatic</emph>: calculates using the minimum and maximum values in the range." msgstr "" -#. qBVjM -#: 05120000.xhp +#. 9aPGW +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id701663449697771\n" +"help.text" +msgid "<emph>Min (Max)</emph>: calculates using the minimum (maximum) values in the range." +msgstr "" + +#. Yst5U +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id281609781729359\n" "help.text" -msgid "<emph>More Options...</emph> opens a dialog to:" +msgid "More Options" msgstr "" -#. saDJA -#: 05120000.xhp +#. wB7B5 +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id271609781812913\n" +"05120400.xhp\n" +"par_id501663454998977\n" "help.text" -msgid "change colors" +msgid "The Data Bar dialog opens to add details on the display of data bars." msgstr "" -#. uncF8 -#: 05120000.xhp +#. Xi84x +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id921609781838551\n" +"05120400.xhp\n" +"hd_id221663453502042\n" "help.text" -msgid "change position of vertical axis within the cell" +msgid "Entry values" msgstr "" -#. wJNxE -#: 05120000.xhp +#. j4CZx +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id631609781859971\n" +"05120400.xhp\n" +"par_id891663453681870\n" "help.text" -msgid "the bar's minimum and maximum length in percentage" +msgid "Same as the conditions above." msgstr "" -#. de4nk -#: 05120000.xhp +#. qYC9D +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"hd_id511663453530293\n" +"help.text" +msgid "Bar Colors" +msgstr "" + +#. 3WvU9 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id371663453564807\n" +"help.text" +msgid "Choose the color for positive and negative values." +msgstr "" + +#. F7ADR +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"hd_id891663453607961\n" +"help.text" +msgid "Fill" +msgstr "" + +#. NK7yv +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id671663453639829\n" +"help.text" +msgid "<emph>Gradient</emph>: set a color scale between the color of positive (negative) values and white." +msgstr "" + +#. UsHFm +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id551663453647462\n" +"help.text" +msgid "<emph>Color</emph>: use the positive (negative) color for the entire data bar, no fade out gradient." +msgstr "" + +#. 3XDGX +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"hd_id701663453750779\n" +"help.text" +msgid "Axis" +msgstr "" + +#. SCFQf +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id691663453763746\n" +"help.text" +msgid "Set the position of the vertical axis for the data bar. Values are" +msgstr "" + +#. 7mCxG +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id381663453792294\n" +"help.text" +msgid "<emph>Automatic:</emph> position the vertical axis in the middle of the maximum and minimum values." +msgstr "" + +#. u9oCp +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id791663453800602\n" +"help.text" +msgid "<emph>Middle:</emph> set the vertical axis in the middle of the column." +msgstr "" + +#. NGqHG +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id461663453808288\n" +"help.text" +msgid "<emph>None:</emph> do not display a vertical axis." +msgstr "" + +#. MbcW9 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"hd_id511663453851599\n" +"help.text" +msgid "Bar Lengths" +msgstr "" + +#. EcZWp +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id601663453865023\n" +"help.text" +msgid "Sets the minimum (maximum) length of the data bars, as a percentage of the column width." +msgstr "" + +#. 6iAs7 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"hd_id211663453914830\n" +"help.text" +msgid "Display bars only" +msgstr "" + +#. zAE3C +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id561663453936590\n" +"help.text" +msgid "Do not display values in the cell, only the data bars." +msgstr "" + +#. EjewA +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "hd_id3153709\n" "help.text" -msgid "Icon Set" +msgid "<link href=\"text/scalc/01/05120400.xhp#iconset\" name=\"Icon Set\">Icon Set</link>" msgstr "" -#. 76M6e -#: 05120000.xhp +#. RjnfG +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" "par_id3153764\n" "help.text" -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:" +msgid "Add an icon to the cell based on the value relative to the specified thresholds. Several icon sets are available." msgstr "" -#. cv4WG -#: 05120000.xhp +#. 5EFt7 +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"hd_id191663440362309\n" +"help.text" +msgid "Available Icon Sets" +msgstr "" + +#. 8cgd9 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494140\n" "help.text" msgid "3, 4 or 5 - arrows" msgstr "" -#. EmC6A -#: 05120000.xhp +#. Aoquj +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id91663429174806\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-colorarrows-up.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663429174808\">Color arrow up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-slightly-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663529174808\">Color arrow slightly up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663529174808\">Color arrow same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-slightly-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663729174808\">Color arrow slightly down</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-colorarrows-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id81663329174808\">Color arrow down</alt></image>" +msgstr "" + +#. PxAE7 +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494141\n" "help.text" msgid "3, 4 or 5 - gray arrows" msgstr "" -#. AtmUL -#: 05120000.xhp +#. 2Fk3v +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id91661429174806\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-grayarrows-up.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Gray arrow up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-slightly-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Gray arrow slightly up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Gray arrow same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-slightly-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663729174808\">Gray arrow slightly down</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-grayarrows-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663329174808\">Gray arrow down</alt></image>" +msgstr "" + +#. jA8Sa +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494142\n" "help.text" msgid "3 - flags" msgstr "" -#. 4zJUW -#: 05120000.xhp +#. Bi9Tr +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id101663433624185\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-flags-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow flag</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-flags-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red flag</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-flags-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green flag</alt></image>" +msgstr "" + +#. FCb5V +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494143\n" "help.text" msgid "3 - traffic lights 1 and 2 (two different designs)" msgstr "" -#. HEF2o -#: 05120000.xhp +#. LugGg +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id721663433917655\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-circles1-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow traffic light 1</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles1-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red traffic light 1</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles1-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green traffic light 1</alt></image>" +msgstr "" + +#. EBREt +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id501663433925207\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-trafficlights-yellow.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow traffic light 2</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-trafficlights-red.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red traffic light 2</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-trafficlights-green.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Green traffic light 2</alt></image>" +msgstr "" + +#. itKqQ +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id701663438522480\n" +"help.text" +msgid "3 - Smileys 1 and 2" +msgstr "" + +#. GoDfk +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id991663438568052\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-positive-yellow-smilie.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Yellow positive smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow neutral smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-negative-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow negative smiley</alt></image>" +msgstr "" + +#. ABksa +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id991663438966721\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-positive-green-smilie.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Green positive smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-neutral-yellow-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Yellow neutral smiley</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-negative-red-smilie.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Red negative smiley</alt></image>" +msgstr "" + +#. QdJxa +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494144\n" "help.text" -msgid "3 - symbols (square, triangle, circle)" +msgid "3 - symbols" msgstr "" -#. V2vKf -#: 05120000.xhp +#. 3DDFG +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id421663434453517\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-shapes-triangle.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape triangle</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-shapes-diamond.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape diamond</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-shapes-circle.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Shape circle</alt></image>" +msgstr "" + +#. ndFCp +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id961663439450424\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-symbols1-exclamation-mark.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Exclamation mark</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-symbols1-cross.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Cross</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-symbols1-check.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Check mark</alt></image>" +msgstr "" + +#. BQAHC +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id1001663439805133\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-stars-empty.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Empty star</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-stars-half.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Half star</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-stars-full.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Full star</alt></image>" +msgstr "" + +#. dEQvx +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" +"par_id171663440020964\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-triangles-up.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Triangle up</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-triangles-same.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Same</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-triangles-down.svg\" id=\"img_id261663429176807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663529174808\">Triangle down</alt></image>" +msgstr "" + +#. MtGvd +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494145\n" "help.text" msgid "4 - circles from red to black" msgstr "" -#. GVUj9 -#: 05120000.xhp +#. C9BEU +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id481663434995022\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-circles2-dark-red.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Dark red</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-light-red.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Light red</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-light-gray.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Light gray</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-circles2-dark-gray.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Dark gray</alt></image>" +msgstr "" + +#. AuYQx +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494146\n" "help.text" msgid "4 or 5 - ratings" msgstr "" -#. BBEC7 -#: 05120000.xhp +#. 8WLQP +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" +"05120400.xhp\n" +"par_id631663435728155\n" +"help.text" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-bars-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarters bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters bars</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-bars-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full bars</alt></image>" +msgstr "" + +#. FdJYa +#: 05120400.xhp +msgctxt "" +"05120400.xhp\n" "par_id31494147\n" "help.text" msgid "5 - quarters" msgstr "" -#. ToNq8 -#: 05120000.xhp +#. Db9xw +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3153765\n" +"05120400.xhp\n" +"par_id741663436015689\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)." +msgid "<image src=\"media/icon-themes/sc/res/icon-set-pies-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarter</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-pies-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full</alt></image>" msgstr "" -#. xD5yq -#: 05120000.xhp +#. 4Gyqu +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3155606\n" +"05120400.xhp\n" +"par_id821663436639070\n" "help.text" -msgid "For a detailed explanation and examples, please visit <link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formatting page</link> in TDF Wiki." +msgid "5 - boxes" msgstr "" -#. GJTU3 -#: 05120000.xhp +#. QqwRQ +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"hd_id3156384\n" +"05120400.xhp\n" +"par_id811663438472751\n" "help.text" -msgid "Dates" -msgstr "Date" +msgid "<image src=\"media/icon-themes/sc/res/icon-set-squares-empty.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Empty</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-one-quarter.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">One quarter</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-half.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Half</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-three-quarters.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Three quarters</alt></image> <image src=\"media/icon-themes/sc/res/icon-set-squares-full.svg\" id=\"img_id261663429174807\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id91663429174808\">Full</alt></image>" +msgstr "" -#. WYB6t -#: 05120000.xhp +#. pB8zZ +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id3145228\n" +"05120400.xhp\n" +"hd_id621663440395987\n" "help.text" -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." +msgid "Conditions for thresholds" msgstr "" -#. WGPEW -#: 05120000.xhp +#. 7BkCL +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id31494157\n" +"05120400.xhp\n" +"par_id3153765\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." +msgid "Conditions to set the thresholds for each icon can be specified as follows" msgstr "" -#. XCEeu -#: 05120000.xhp +#. DdaUm +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id31494167\n" +"05120400.xhp\n" +"par_id3155606\n" "help.text" -msgid "Click the <emph>Add</emph> button to add another condition, click the <emph>Remove</emph> button to remove a condition." +msgid "<link href=\"https://wiki.documentfoundation.org/Faq/Calc/141\">How to use Icon Set Conditional Formatting page</link> in TDF Wiki." msgstr "" -#. 5bcGZ -#: 05120000.xhp +#. s9tpC +#: 05120400.xhp msgctxt "" -"05120000.xhp\n" -"par_id31494177\n" +"05120400.xhp\n" +"par_id651663598549283\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." +msgid "<link href=\"https://wiki.documentfoundation.org/Faq/Calc/142\">How to apply a Color Scale Conditional Formatting page</link> in TDF Wiki." msgstr "" -#. XrHd6 -#: 05120000.xhp +#. AiUSf +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" -"hd_id3153384\n" +"05120500.xhp\n" +"tit\n" "help.text" -msgid "Manage Conditional Formatting" -msgstr "Skilyrt forsníðing" +msgid "Conditional Formatting - Manage Conditions" +msgstr "" -#. KaFUh -#: 05120000.xhp +#. EJnPj +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" -"par_id3155906\n" +"05120500.xhp\n" +"hd_id391662937414401\n" "help.text" -msgid "<ahelp hid=\".\">This dialog allows you to see all the conditional formatting defined in the spreadsheet.</ahelp>" +msgid "<variable id=\"h1\"><link href=\"text/scalc/01/05120500.xhp\" name=\"Manage Conditions\">Manage Conditions</link></variable>" msgstr "" -#. oGo9V -#: 05120000.xhp +#. SdPis +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" -"par_id31546818\n" +"05120500.xhp\n" +"par_id3155906\n" "help.text" -msgid "Choose <emph>Format - Conditional Formatting - Manage</emph>." +msgid "Manage all the conditional formatting defined in the spreadsheet." msgstr "" -#. PCf7v -#: 05120000.xhp +#. rMivF +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" +"05120500.xhp\n" "par_id3155907\n" "help.text" -msgid "The <emph>Manage Conditional Formatting</emph> dialog box opens. <ahelp hid=\".\">Here you can add, edit or remove one or several conditional formattings.</ahelp>" +msgid "The <emph>Manage Conditional Formatting</emph> dialog is where you can add, edit or delete one or several conditional formattings." msgstr "" -#. Q7xPu -#: 05120000.xhp +#. rFGM7 +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" +"05120500.xhp\n" "par_id3155909\n" "help.text" -msgid "<ahelp hid=\".\">The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet.</ahelp> Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range." +msgid "The <emph>Conditional Formats</emph> list displays the active conditional formatting rules set in the current spreadsheet. Only the first rule for each cell range is listed, even if there are multiple rules defined for a given range." msgstr "" -#. dTXQV -#: 05120000.xhp +#. dEeLT +#: 05120500.xhp msgctxt "" -"05120000.xhp\n" +"05120500.xhp\n" "par_id3155908\n" "help.text" 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)." @@ -56930,13 +57947,13 @@ msgctxt "" msgid "Units of measurement" msgstr "" -#. oxx8A +#. A7feF #: func_convert.xhp msgctxt "" "func_convert.xhp\n" "par_id481620428685029\n" "help.text" -msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Beware that conversions can only happen between units that belong to the same group." +msgid "Below are the unit measurement groups supported by the <literal>CONVERT</literal> function. Be aware that conversions can only happen between units that belong to the same group." msgstr "" #. Rd9Fp @@ -68041,13 +69058,13 @@ msgctxt "" msgid "Bounds are specified by selecting one or more variables (as range) on the left side and entering a numerical value (not a cell or a formula) on the right side. That way you can also choose one or more variables to be <emph>Integer</emph> or <emph>Binary</emph> only." msgstr "" -#. ZUeCC +#. RDcmq #: solver.xhp msgctxt "" "solver.xhp\n" "par_id271589981559367\n" "help.text" -msgid "<link href=\"https://wiki.documentfoundation.org/\" name=\"wikipage\">Wiki page on solvers and theirs algorithms</link>" +msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on solvers and their algorithms</link>" msgstr "" #. akxrP @@ -68176,13 +69193,13 @@ msgctxt "" msgid "<ahelp hid=\".\">Enter or change the value of the selected setting.</ahelp>" msgstr "" -#. cYCVf +#. FGS6a #: solver_options.xhp msgctxt "" "solver_options.xhp\n" "par_id271589981559367\n" "help.text" -msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>" +msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and their algorithms</link>" msgstr "" #. A843R @@ -68752,13 +69769,13 @@ msgctxt "" msgid "Set the swarm algorithm. 0 for differential evolution and 1 for particle swarm optimization. Default is 0." msgstr "" -#. ugAZb +#. wBxK6 #: solver_options_algo.xhp msgctxt "" "solver_options_algo.xhp\n" "par_id271589981559367\n" "help.text" -msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and theirs algorithms</link>" +msgid "<link href=\"https://wiki.documentfoundation.org/NLPSolver\" name=\"wikipage\">Wiki page on non-linear solvers and their algorithms</link>" msgstr "" #. D2nCR |