source/text/scalc/01/12120100.xhp | 50 ++++++++++++++++++-------------------- 1 file changed, 24 insertions(+), 26 deletions(-)
New commits: commit be7cb5f81c4d389fd6ff8ab1d6cb9338ccd5c61c Author: Seth Chaiklin <sdc.bla...@youmail.dk> AuthorDate: Wed Oct 28 20:56:33 2020 +0200 Commit: Seth Chaiklin <sdc.bla...@youmail.dk> CommitDate: Thu Oct 29 15:10:53 2020 +0100 tdf#137277 add note about truncated lists in Excel export - remove all colspan="" rowspan="" in <tablecell> + <h1>,some <h2> Change-Id: I07430cde51ed1d4faeac2569b9e4066dcf290865 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104952 Tested-by: Jenkins Reviewed-by: Seth Chaiklin <sdc.bla...@youmail.dk> diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp index 94e9e1b9b..f5fff7d7b 100644 --- a/source/text/scalc/01/12120100.xhp +++ b/source/text/scalc/01/12120100.xhp @@ -1,6 +1,5 @@ <?xml version="1.0" encoding="UTF-8"?> - - +<helpdocument version="1.0"> <!-- * This file is part of the LibreOffice project. * @@ -19,7 +18,6 @@ * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> -<helpdocument version="1.0"> <meta> <topic id="textscalc0112120100xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Criteria</title> @@ -35,7 +33,7 @@ </bookmark><comment>UFI added index entry for new list feature. Guide needed. MW changed index entry</comment> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage" id="bm_id3145673" localize="false"/> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/@@nowidget@@" id="bm_id3145673" localize="false"/> -<paragraph role="heading" id="hd_id3153032" xml-lang="en-US" level="1"><link href="text/scalc/01/12120100.xhp" name="Criteria">Criteria</link></paragraph> +<h1 id="hd_id3153032" xml-lang="en-US"><link href="text/scalc/01/12120100.xhp" name="Criteria">Criteria</link></h1> <paragraph role="paragraph" id="par_id3156327" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage">Specify the validation rules for the selected cell(s).</ahelp></paragraph> </section> <section id="howtoget"> @@ -43,86 +41,86 @@ </section> <paragraph role="paragraph" id="par_id3155923" xml-lang="en-US">For example, you can define criteria such as: "Numbers between 1 and 10" or "Texts that are no more than 20 characters".</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/allow" id="bm_id3148663" localize="false"/> -<paragraph role="heading" id="hd_id3153896" xml-lang="en-US" level="2">Allow</paragraph> +<h2 id="hd_id3153896" xml-lang="en-US">Allow</h2> <paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/allow">Click a validation option for the selected cell(s).</ahelp></paragraph> <paragraph role="paragraph" id="par_id3148797" xml-lang="en-US">The following conditions are available:</paragraph> <table id="tbl_id3150870"> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3150447" xml-lang="en-US">Condition</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablehead" id="par_id3155854" xml-lang="en-US">Effect</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153092" xml-lang="en-US">All values</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3155411" xml-lang="en-US">No limitation.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3147434" xml-lang="en-US">Whole number</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154319" xml-lang="en-US">Only whole numbers corresponding to the condition.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3145802" xml-lang="en-US">Decimal</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3153160" xml-lang="en-US">All numbers corresponding to the condition.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3149377" xml-lang="en-US">Date</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3150718" xml-lang="en-US">All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US">Time</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3155066" xml-lang="en-US">All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_idN106A0" xml-lang="en-US">Cell range</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_idN106A5" xml-lang="en-US">Allow only values that are given in a cell range. The cell range can be specified explicitly, or as a named database range, or as a named range. The range may consist of one column or one row of cells. If you specify a range of columns and rows, only the first column is used.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_idN106AB" xml-lang="en-US">List</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> -<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">Allow only values or strings specified in a list. Strings and values can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid.</paragraph> +<tablecell> +<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">Allow only values or strings specified in a list. Strings and values can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid.</paragraph> <paragraph role="note" id="par_id221603980244052">Only up to 255 characters are saved, when using Excel format.</paragraph> </tablecell> </tablerow> <tablerow> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3154756" xml-lang="en-US">Text length</paragraph> </tablecell> -<tablecell colspan="" rowspan=""> +<tablecell> <paragraph role="tablecontent" id="par_id3147339" xml-lang="en-US">Entries whose length corresponds to the condition.</paragraph> </tablecell> </tablerow> </table> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/allowempty" id="bm_id263985" localize="false"/> -<paragraph role="heading" id="hd_id3154704" xml-lang="en-US" level="2">Allow blank cells</paragraph> +<h2 id="hd_id3154704" xml-lang="en-US">Allow blank cells</h2> <paragraph role="paragraph" id="par_id3153967" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/allowempty">In conjunction with <emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank cells are shown as invalid data (disabled) or not (enabled).</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/showlist" id="bm_id5339518" localize="false"/> <paragraph role="heading" id="par_idN10709" xml-lang="en-US" level="2">Show selection list</paragraph> @@ -141,7 +139,7 @@ <paragraph role="heading" id="hd_id3153782" xml-lang="en-US" level="2">Value</paragraph> <paragraph role="paragraph" id="par_id3153266" xml-lang="en-US">Enter the value for the data validation option that you selected in the <emph>Allow </emph>box.</paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/min" id="bm_id3149528" localize="false"/> -<paragraph role="heading" id="hd_id3149814" xml-lang="en-US" level="2">Minimum</paragraph> +<h2 id="hd_id3149814" xml-lang="en-US">Minimum</h2> <paragraph role="paragraph" id="par_id3153199" xml-lang="en-US"><ahelp hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for the data validation option that you selected in the <emph>Allow </emph>box.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/validationcriteriapage/max" id="bm_id3150206" localize="false"/> <paragraph role="heading" id="hd_id3149035" xml-lang="en-US" level="2">Maximum</paragraph> _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits