source/text/scalc/01/05120100.xhp | 126 ++++++++++++++++++++++++++++++-------- 1 file changed, 100 insertions(+), 26 deletions(-)
New commits: commit 112fa92d3b4c9c643c76afbfe3b04269308a7705 Author: Olivier Hallot <olivier.hal...@libreoffice.org> AuthorDate: Sat Sep 17 07:10:58 2022 -0300 Commit: Olivier Hallot <olivier.hal...@libreoffice.org> CommitDate: Sat Sep 17 22:35:34 2022 +0200 Unclutter table in Conditional Format Help page Change-Id: Ia5b12237e4be3e674701ace0194994faa2a8b69d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/140094 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org> diff --git a/source/text/scalc/01/05120100.xhp b/source/text/scalc/01/05120100.xhp index 3caba2fdc..d31425090 100644 --- a/source/text/scalc/01/05120100.xhp +++ b/source/text/scalc/01/05120100.xhp @@ -24,12 +24,14 @@ <paragraph role="paragraph" id="par_id11662915615351">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.</paragraph> </section> - <paragraph xml-lang="en-US" id="par_id31494135" role="paragraph">Select a condition in the drop down list for the format to be applied to the selected cells and enter the value. Valid conditions are:</paragraph> <table id="tab_id211662913907277"> <tablerow> <tablecell> <paragraph id="par_id181662913907279" role="tablehead" xml-lang="en-US">Condition</paragraph> </tablecell> + <tablecell> + <paragraph id="par_id221663406419144" role="tablehead" xml-lang="en-US" >Applies on</paragraph> + </tablecell> <tablecell> <paragraph id="par_id941662913907280" role="tablehead" xml-lang="en-US">Description</paragraph> </tablecell> @@ -39,7 +41,10 @@ <paragraph id="par_id31662913907282" role="tablecontent" xml-lang="en-US">is equal to</paragraph> </tablecell> <tablecell> - <paragraph id="par_id881662913907284" role="tablecontent" xml-lang="en-US">Applies the selected style to the cell when the cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values.</paragraph> + <paragraph id="par_id321663406539530" role="tablecontent" xml-lang="en-US" ><variable id="numbertext">Numbers and text</variable></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id881662913907284" role="tablecontent" xml-lang="en-US">The cell value equals the user defined value in text box in the right. Use text inside quotes if you compare text values.</paragraph> </tablecell> </tablerow> <tablerow> @@ -47,7 +52,10 @@ <paragraph id="par_id271662914239763" role="tablecontent" xml-lang="en-US" >is less than</paragraph> </tablecell> <tablecell> - <paragraph id="par_id501662914239764" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is strictly less than the user defined value in the text box in the right. Valid only for number values in cells.</paragraph> + <paragraph id="par_id121663406585137" role="tablecontent" xml-lang="en-US" ><variable id="numbers">Numbers</variable></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id501662914239764" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the user defined value in the text box in the right.</paragraph> </tablecell> </tablerow> <tablerow> @@ -55,7 +63,10 @@ <paragraph id="par_id701662914433053" role="tablecontent" xml-lang="en-US" >is greater than</paragraph> </tablecell> <tablecell> - <paragraph id="par_id461662914433054" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is strictly greater than the user defined value in the text box in the right. Valid only for number values in cells.</paragraph> + <paragraph id="par_id201663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id461662914433054" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the user defined value in the text box in the right.</paragraph> </tablecell> </tablerow> <tablerow> @@ -63,7 +74,10 @@ <paragraph id="par_id421662914480517" role="tablecontent" xml-lang="en-US" >is less than or equal to</paragraph> </tablecell> <tablecell> - <paragraph id="par_id631662914480518" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is less than or equal to the user defined value in the text box in the right. Valid only for number values in cells.</paragraph> + <paragraph id="par_id301663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id631662914480518" role="tablecontent" xml-lang="en-US" >The cell value is less than or equal to the user defined value in the text box in the right.</paragraph> </tablecell> </tablerow> <tablerow> @@ -71,7 +85,10 @@ <paragraph id="par_id651662914713102" role="tablecontent" xml-lang="en-US" >is greater than or equal to</paragraph> </tablecell> <tablecell> - <paragraph id="par_id251662914713103" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is greater than or equal to the user defined value in the text box in the right. Valid only for number values in cells.</paragraph> + <paragraph id="par_id401663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id251662914713103" role="tablecontent" xml-lang="en-US" >The cell value is greater than or equal to the user defined value in the text box in the right.</paragraph> </tablecell> </tablerow> <tablerow> @@ -79,7 +96,11 @@ <paragraph id="par_id831662914760085" role="tablecontent" xml-lang="en-US" >is not equal to</paragraph> </tablecell> <tablecell> - <paragraph id="par_id301662914760087" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is not equal (different) to the user defined value in the text box in the right. Valid for number and text values in cells. Use text inside quotes if you compare text values.</paragraph> + <paragraph id="par_id501663406628969" role="tablecontent" xml-lang="en-US" localize="false"> + <embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id301662914760087" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -87,7 +108,10 @@ <paragraph id="par_id81662914901503" role="tablecontent" xml-lang="en-US" >is between</paragraph> </tablecell> <tablecell> - <paragraph id="par_id21662914901504" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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. Valid only for number values in cells.</paragraph> + <paragraph id="par_id601663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id21662914901504" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -95,7 +119,10 @@ <paragraph id="par_id411662915178872" role="tablecontent" xml-lang="en-US" >is not between</paragraph> </tablecell> <tablecell> - <paragraph id="par_id861662915178873" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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. Valid only for number values in cells.</paragraph> + <paragraph id="par_id701663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id861662915178873" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -103,7 +130,10 @@ <paragraph id="par_id731662915275926" role="tablecontent" xml-lang="en-US" >is duplicate</paragraph> </tablecell> <tablecell> - <paragraph id="par_id881662915275927" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when at least one other cell in the range has equal contents. Valid for number and text values in cells.</paragraph> + <paragraph id="par_id801663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id881662915275927" role="tablecontent" xml-lang="en-US" >The cell and at least one other cell in the range have equal contents.</paragraph> </tablecell> </tablerow> <tablerow> @@ -111,7 +141,10 @@ <paragraph id="par_id381662915857686" role="tablecontent" xml-lang="en-US" >is not duplicate</paragraph> </tablecell> <tablecell> - <paragraph id="par_id341662915857687" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell contents is unique in the range. Valid for number and text values in cells.</paragraph> + <paragraph id="par_id901663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id341662915857687" role="tablecontent" xml-lang="en-US" >The cell contents is unique in the range.</paragraph> </tablecell> </tablerow> <tablerow> @@ -119,7 +152,10 @@ <paragraph id="par_id1001662915996409" role="tablecontent" xml-lang="en-US" >is in top N elements</paragraph> </tablecell> <tablecell> - <paragraph id="par_id571662915996410" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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. Valid only for number values in cells.</paragraph> + <paragraph id="par_id101663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id571662915996410" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -127,7 +163,10 @@ <paragraph id="par_id341662916338175" role="tablecontent" xml-lang="en-US" >is in bottom N elements</paragraph> </tablecell> <tablecell> - <paragraph id="par_id11662916338177" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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. Valid only for number values in cells.</paragraph> + <paragraph id="par_id111663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id11662916338177" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -135,7 +174,10 @@ <paragraph id="par_id181662916407095" role="tablecontent" xml-lang="en-US" >is in top N percent</paragraph> </tablecell> <tablecell> - <paragraph id="par_id911662916407097" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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.</paragraph> + <paragraph id="par_id121663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id911662916407097" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -143,7 +185,10 @@ <paragraph id="par_id421662917285432" role="tablecontent" xml-lang="en-US" >is in bottom N percent</paragraph> </tablecell> <tablecell> - <paragraph id="par_id111662917285433" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when 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.</paragraph> + <paragraph id="par_id121663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id111662917285433" role="tablecontent" xml-lang="en-US" >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.</paragraph> </tablecell> </tablerow> <tablerow> @@ -151,7 +196,10 @@ <paragraph id="par_id861662917382735" role="tablecontent" xml-lang="en-US" >is above average</paragraph> </tablecell> <tablecell> - <paragraph id="par_id811662917382736" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is strictly greater than the average of the cell range values.</paragraph> + <paragraph id="par_id131663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id811662917382736" role="tablecontent" xml-lang="en-US" >The cell value is strictly greater than the average of the cell range values.</paragraph> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> </tablecell> </tablerow> @@ -160,7 +208,10 @@ <paragraph id="par_id421662919561954" role="tablecontent" xml-lang="en-US" >is below average</paragraph> </tablecell> <tablecell> - <paragraph id="par_id661662919561956" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is strictly less than the average of the cell range values.</paragraph> + <paragraph id="par_id141663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id661662919561956" role="tablecontent" xml-lang="en-US" >The cell value is strictly less than the average of the cell range values.</paragraph> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> </tablecell> </tablerow> @@ -169,7 +220,10 @@ <paragraph id="par_id831662919693474" role="tablecontent" xml-lang="en-US" >is above or equal average</paragraph> </tablecell> <tablecell> - <paragraph id="par_id71662919693475" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is greater or equal than the average of the cell range values.</paragraph> + <paragraph id="par_id151663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id71662919693475" role="tablecontent" xml-lang="en-US" >The cell value is greater or equal than the average of the cell range values.</paragraph> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> </tablecell> </tablerow> @@ -178,7 +232,10 @@ <paragraph id="par_id521662919771410" role="tablecontent" xml-lang="en-US" >is below or equal average</paragraph> </tablecell> <tablecell> - <paragraph id="par_id131662919771411" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell value is less or equal than the average of the cell range values.</paragraph> + <paragraph id="par_id161663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbers" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id131662919771411" role="tablecontent" xml-lang="en-US" >The cell value is less or equal than the average of the cell range values.</paragraph> <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> </tablecell> </tablerow> @@ -187,7 +244,10 @@ <paragraph id="par_id451662919849856" role="tablecontent" xml-lang="en-US" >is error</paragraph> </tablecell> <tablecell> - <paragraph id="par_id911662919849857" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell is in a error condition defined in the right text box. <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link>.</paragraph> + <paragraph id="par_id171663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id911662919849857" role="tablecontent" xml-lang="en-US" >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>.</paragraph> <tip id="par_id61662920733334">A cell that references another cell with an error condition is not in error itself.</tip> </tablecell> </tablerow> @@ -196,7 +256,10 @@ <paragraph id="par_id961662920774180" role="tablecontent" xml-lang="en-US" >is not error</paragraph> </tablecell> <tablecell> - <paragraph id="par_id381662920774181" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell is not in a error condition defined in the right text box. <link href="text/scalc/05/02140000.xhp" name="calc errors">List of Calc errors</link></paragraph> + <paragraph id="par_id181663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id381662920774181" role="tablecontent" xml-lang="en-US" >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></paragraph> </tablecell> </tablerow> <tablerow> @@ -204,7 +267,10 @@ <paragraph id="par_id151662920861587" role="tablecontent" xml-lang="en-US" >begins with</paragraph> </tablecell> <tablecell> - <paragraph id="par_id341662920861588" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell contents begins with the text or number defined in the right text box.</paragraph> + <paragraph id="par_id191663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id341662920861588" role="tablecontent" xml-lang="en-US" >The cell contents begins with the text or number defined in the text box on the right.</paragraph> <note id="par_id801662922586796"><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></note> </tablecell> </tablerow> @@ -213,7 +279,10 @@ <paragraph id="par_id361662922600585" role="tablecontent" xml-lang="en-US" >ends with</paragraph> </tablecell> <tablecell> - <paragraph id="par_id801662922600586" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell contents ends with the text or number defined in the right text box.</paragraph> + <paragraph id="par_id201663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id801662922600586" role="tablecontent" xml-lang="en-US" >The cell contents ends with the text or number defined in the right text box.</paragraph> <note localize="false" id="par_id221662923585290"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note> </tablecell> </tablerow> @@ -222,7 +291,10 @@ <paragraph id="par_id151662922939292" role="tablecontent" xml-lang="en-US" >contains</paragraph> </tablecell> <tablecell> - <paragraph id="par_id251662922939293" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell contents contains the text or number defined in the right text box.</paragraph> + <paragraph id="par_id211663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id251662922939293" role="tablecontent" xml-lang="en-US" >The cell contents contains the text or number defined in the right text box.</paragraph> <note localize="false" id="par_id221662923585291"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note> </tablecell> </tablerow> @@ -231,11 +303,13 @@ <paragraph id="par_id291662923021542" role="tablecontent" xml-lang="en-US" >does not contain</paragraph> </tablecell> <tablecell> - <paragraph id="par_id541662923021543" role="tablecontent" xml-lang="en-US" >Applies the selected style to the cell when the cell contents does not contains the text or number defined in the right text box.</paragraph> + <paragraph id="par_id221663406628969" role="tablecontent" localize="false" xml-lang="en-US" ><embedvar href="text/scalc/01/05120100.xhp#numbertext" markup="ignore"/></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id541662923021543" role="tablecontent" xml-lang="en-US" >The cell contents does not contains the text or number defined in the text box on the right.</paragraph> <note localize="false" id="par_id221662923585292"><embedvar href="text/scalc/01/05120100.xhp#text_comparison" markup="keep"/></note> </tablecell> </tablerow> </table> - </body> </helpdocument>