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.blanco@youmail.dk>

1 files changed, 24 insertions, 26 deletions

diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp
index 94e9e1b9bc..f5fff7d7b4 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>