tdf#131563 VBA color constants

- VBA color constants addition
- Aggregation of spreaded constant definitions in this page

Change-Id: I5f4045256e5e03c6b11247c9bb0442e9e63d738d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/124013
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>

7 files changed, 269 insertions, 156 deletions

diff --git a/source/text/sbasic/shared/03010101.xhp b/source/text/sbasic/shared/03010101.xhp
index e74189f00d..3f01c49311 100644
--- a/source/text/sbasic/shared/03010101.xhp
+++ b/source/text/sbasic/shared/03010101.xhp
@@ -37,7 +37,8 @@
 
 <embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
 <bascode>
-<paragraph id="par_id3148664" role="bascode" localize="false">MsgBox prompt As String [,buttons = MB_OK [,title As String]]</paragraph>
+   <paragraph id="par_id3148664" role="bascode" localize="false">MsgBox prompt As String [,buttons = MB_OK [,title As String]]</paragraph>
+   <paragraph role="bascode" id="bas_id551634909184049" localize="false">response = MsgBox( prompt As String [,buttons = MB_OK [,title As String]])</paragraph>
 </bascode>
 
 <section id="MsgBox_statement">
@@ -48,6 +49,7 @@
 <paragraph id="par_id3147228" role="paragraph" xml-lang="en-US"> <emph>buttons</emph>: Any integer expression that specifies the dialog type, as well as the number and type of buttons to display, and the icon type. <emph>buttons</emph> represents a combination of bit patterns, that is, a combination of elements can be defined by adding their respective values:</paragraph>
 </section>
 
+<section id="MsgBox_constants">
 <table id="tbl_051220170220345412">
   <tablerow>
     <tablecell>
@@ -205,6 +207,7 @@
   </tablerow>
 </table>
 </section>
+</section>
 
 <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
 <embed href="text/sbasic/shared/00000003.xhp#err5"/>
diff --git a/source/text/sbasic/shared/03020409.xhp b/source/text/sbasic/shared/03020409.xhp
index cb1bee4d81..0eaf7067b8 100644
--- a/source/text/sbasic/shared/03020409.xhp
+++ b/source/text/sbasic/shared/03020409.xhp
@@ -55,6 +55,7 @@
 
 <paragraph id="hd_id3145364" role="heading" level="2" xml-lang="en-US">Value</paragraph>
 
+<section id="GetAttr_constants">
 <table id="Table1">
   <tablerow>
     <tablecell>
@@ -145,6 +146,7 @@
     </tablecell>
   </tablerow>
 </table>
+</section>
 
 <paragraph id="par_id3156444" role="paragraph" xml-lang="en-US">If you want to know if a bit of the attribute byte is set, use the following query method:</paragraph>
 
diff --git a/source/text/sbasic/shared/03030105.xhp b/source/text/sbasic/shared/03030105.xhp
index c8c5cca159..f2bd1dad4b 100644
--- a/source/text/sbasic/shared/03030105.xhp
+++ b/source/text/sbasic/shared/03030105.xhp
@@ -46,6 +46,7 @@
 <paragraph role="paragraph" id="par_id351619718411921">
 <emph>FirstDayOfWeek:</emph> Integer value indicating which weekday should be considered as the first day of the week. The default value is <emph>0</emph>, meaning that the system locale settings are used to determine the first day of the week.</paragraph>
 <paragraph role="paragraph" id="par_id411619718769819">The parameter <emph>FirstDayOfWeek</emph> accepts values ranging from 0 to 7. The table below describes the meaning of each possible value:</paragraph>
+<section id="WeekDay_constants">
 <table id="tab_id191619718816238">
    <tablerow>
        <tablecell>
@@ -147,6 +148,7 @@
        </tablecell>
    </tablerow>
 </table>
+</section>
 <note id="par_id451619720094202">The VBA constants listed above are only available if VBA support has been enabled. For more information, read the <link href="text/sbasic/shared/03103350.xhp" name="VBASupport_Statement">VBASupport Statement</link> help page.</note>
 
 <embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
diff --git a/source/text/sbasic/shared/03040000.xhp b/source/text/sbasic/shared/03040000.xhp
index 0d1402f6b1..7971edc180 100644
--- a/source/text/sbasic/shared/03040000.xhp
+++ b/source/text/sbasic/shared/03040000.xhp
@@ -56,7 +56,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051620171114567378" role="paragraph" localize="false" xml-lang="en-US">True</paragraph>
+                    <paragraph id="par_id051620171114567378" role="paragraph" localize="false" xml-lang="en-US"><literal>True</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051620171114563299" role="paragraph" localize="false" xml-lang="en-US">Boolean</paragraph>
@@ -67,7 +67,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051620171114564178" role="paragraph" localize="false" xml-lang="en-US">False</paragraph>
+                    <paragraph id="par_id051620171114564178" role="paragraph" localize="false" xml-lang="en-US"><literal>False</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051620171114566455" role="paragraph" localize="false" xml-lang="en-US">Boolean</paragraph>
@@ -108,7 +108,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051620171114574028" role="paragraph" localize="false">Pi</paragraph>
+                    <paragraph id="par_id051620171114574028" role="paragraph" localize="false"><literal>Pi</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051620171114571506" role="paragraph" localize="false">Double</paragraph>
@@ -154,7 +154,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051620171114575052" role="paragraph" localize="false">Empty</paragraph>
+                    <paragraph id="par_id051620171114575052" role="paragraph" localize="false"><literal>Empty</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051620171114576734" role="paragraph" localize="false">Variant</paragraph>
@@ -165,7 +165,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051620171114577892" role="paragraph" localize="false">Null</paragraph>
+                    <paragraph id="par_id051620171114577892" role="paragraph" localize="false"><literal>Null</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051620171114571232" role="paragraph" localize="false">null</paragraph>
@@ -176,7 +176,7 @@
             </tablerow>
             <tablerow>
                 <tablecell>
-                    <paragraph id="par_id051720170824091253" role="paragraph" localize="false">Nothing</paragraph>
+                    <paragraph id="par_id051720170824091253" role="paragraph" localize="false"><literal>Nothing</literal></paragraph>
                 </tablecell>
                 <tablecell>
                     <paragraph id="par_id051720170824091966" role="paragraph" localize="false">Object</paragraph>
@@ -190,23 +190,33 @@
         <embed href="text/sbasic/shared/00000003.xhp#functexample"/>
         <bascode>
             <paragraph id="par_id051620171114575772" role="bascode" localize="false">SubExampleEmpty</paragraph>
-            <paragraph id="par_id051620171114572075" role="bascode" localize="false">Dim sVar As Variant</paragraph>
-            <paragraph id="par_id051620171114579662" role="bascode" localize="false"> sVar = Empty</paragraph>
-            <paragraph id="par_id051620171114577052" role="bascode" localize="false"> Print IsEmpty(sVar) ' Returns True</paragraph>
+            <paragraph id="par_id051620171114572075" role="bascode" localize="false">    Dim sVar As Variant</paragraph>
+            <paragraph id="par_id051620171114579662" role="bascode" localize="false">    sVar = Empty</paragraph>
+            <paragraph id="par_id051620171114577052" role="bascode" xml-lang="en-US">    Print IsEmpty(sVar) ' Returns True</paragraph>
             <paragraph id="par_id051620171114576576" role="bascode" localize="false">End Sub</paragraph>
             <paragraph id="par_id051620171114573781" role="bascode" localize="false">Sub ExampleNull</paragraph>
-            <paragraph id="par_id051620171114584136" role="bascode" localize="false">Dim vVar As Variant</paragraph>
-            <paragraph id="par_id05162017111458231" role="bascode" localize="false"> MsgBox IsNull(vVar)</paragraph>
+            <paragraph id="par_id051620171114584136" role="bascode" localize="false">    Dim vVar As Variant</paragraph>
+            <paragraph id="par_id05162017111458231" role="bascode" localize="false">    MsgBox IsNull(vVar)</paragraph>
             <paragraph id="par_id051620171114581488" role="bascode" localize="false">End Sub</paragraph>
             <paragraph id="par_id051720170824102912" role="bascode" localize="false">Sub ExampleNothing</paragraph>
-            <paragraph id="par_id051720170824104202" role="bascode" localize="false">Dim oDoc As Object</paragraph>
-            <paragraph id="par_id051720170824102971" role="bascode" localize="false"> Set oDoc = ThisComponent</paragraph>
-            <paragraph id="par_id051720170824104997" role="bascode" localize="false"> Print oDoc.Title</paragraph>
-            <paragraph id="par_id051720170824104443" role="bascode" localize="false"> oDoc = Nothing</paragraph>
-            <paragraph id="par_id051720170824106132" role="bascode" localize="false"> Print oDoc ‘ Error</paragraph>
+            <paragraph id="par_id051720170824104202" role="bascode" localize="false">    Dim oDoc As Object</paragraph>
+            <paragraph id="par_id051720170824102971" role="bascode" localize="false">    Set oDoc = ThisComponent</paragraph>
+            <paragraph id="par_id051720170824104997" role="bascode" localize="false">    Print oDoc.Title</paragraph>
+            <paragraph id="par_id051720170824104443" role="bascode" localize="false">    oDoc = Nothing</paragraph>
+            <paragraph id="par_id051720170824106132" role="bascode" xml-lang="en-US">    Print oDoc ‘ Error</paragraph>
             <paragraph id="par_id051720170824103527" role="bascode" localize="false">End Sub</paragraph>
         </bascode>
     </section>
+
+    <h2 id="hd_id31634909394554">MsgBox Named Constants</h2>
+    <embed href="text/sbasic/shared/03010101.xhp#MsgBox_constants"/>
+
+    <h2 id="hd_id881634911199058">GetAttr Named Constants</h2>
+    <embed href="text/sbasic/shared/03020409.xhp#GetAttr_constants"/>
+
+    <h2 id="hd_id611634911996367">VarType Named Constants</h2>
+    <embed href="text/sbasic/shared/03103600.xhp#VarType_constants"/>
+
     <section id="addvbaconstants">
         <bookmark xml-lang="en-US" branch="index" id="bm_id101554201127393">
 <bookmark_value>Visual Basic constants</bookmark_value>
@@ -214,150 +224,94 @@
         </bookmark>
         <h2 id="hd_id661512312593832">Additional VBA constants</h2>
         <paragraph role="paragraph" id="par_id111512312705893" xml-lang="en-US">The following constants are available when VBA compatibility mode is enabled</paragraph>
-
         <embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
-        <table id="tab_id671512313939217">
-            <tablerow>
-                <tablecell>
-                    <paragraph role="tablehead" id="par_id901512312880723" xml-lang="en-US">Named constant</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id891512312916493" role="tablehead" xml-lang="en-US">Hexadecimal (decimal) value</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id991512312965968" role="tablehead" xml-lang="en-US">Description</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id311542196872466" role="paragraph" localize="false">vbTrue</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id151542196872467" role="paragraph" localize="false">-1</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph role="paragraph" id="par_id671542197262160" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id241542196923343" role="paragraph" localize="false">vbFalse</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id611542196923343" role="paragraph" localize="false">0</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph role="paragraph" id="par_id351542197255532" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id551542196949698" role="paragraph" localize="false">vbUseDefault</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id831542196949698" role="paragraph" localize="false">-2</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph role="paragraph" id="par_id251542197274514" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id891512313266496" role="paragraph" localize="false">vbCr</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph role="paragraph" id="par_id241512313723033" localize="false">\x0D (13)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph role="paragraph" id="par_id611512313731233" xml-lang="en-US">CR - Carriage return</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id471512313282257" role="paragraph" localize="false">vbCrLf</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id691512313750520" role="paragraph" localize="false">\x0D\x0A (13 10)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id961512313881937" role="paragraph" xml-lang="en-US">CRLF - Carriage return and line feed</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id11512313289164" role="paragraph" localize="false">vbFormFeed</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id341512313761295" role="paragraph" localize="false">\x0c (12)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id221512313889077" role="paragraph" xml-lang="en-US">FF - Form feed</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id501512313293989" role="paragraph" localize="false">vbLf</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id311512313777558" role="paragraph" localize="false">\x0A (10)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id621512313896169" role="paragraph" xml-lang="en-US">LF - Line feed</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id191512313300610" role="paragraph" localize="false">vbNewLine</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id521512319135830" role="listitem" xml-lang="en-US">\x0D\x0A (13 10) for Windows</paragraph>
-                    <paragraph id="par_id61512319163913" role="listitem" xml-lang="en-US">\x0A (10) for other systems</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id151512313904989" role="paragraph" xml-lang="en-US">LF or CRLF </paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id211512313306932" role="paragraph" xml-lang="en-US" localize="false">vbNullString</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id141512313800110" role="paragraph" localize="false">""</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id741512313911049" role="paragraph" xml-lang="en-US">Null string</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id931512313312621" role="paragraph" localize="false">vbTab</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id241512313810064" role="paragraph" localize="false">\x09 (9)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id951512313918356" role="paragraph" xml-lang="en-US">HT - Horizontal tab</paragraph>
-                </tablecell>
-            </tablerow>
-            <tablerow>
-                <tablecell>
-                    <paragraph id="par_id481512313318983" role="paragraph" localize="false">vbVerticalTab </paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id991512313821414" role="paragraph" localize="false">\x0B (11)</paragraph>
-                </tablecell>
-                <tablecell>
-                    <paragraph id="par_id351512313924593" role="paragraph" xml-lang="en-US">VT - Vertical tab</paragraph>
-                </tablecell>
-            </tablerow>
-        </table>
-    </section>
+
     <section id="vbavartypeconstnts">
         <bookmark xml-lang="en-US" branch="index" id="bm_id391624288823741">
 <bookmark_value>VBA Variable Type Named Constants</bookmark_value>
         </bookmark>
-    <h2 id="hd_id941624288567829">VBA Variable Type Named Constants</h2>
-    <embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
+
+      
+</section>
+
+    <h3 id="hd_id941628842567829">VBA Color Named Constants</h3>
+
+<table id="tab_id691634907471277">
+   <tablerow>
+       <tablecell>
+           <paragraph id="par_id611634907471277" role="tablehead">Named constant</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id861634907471277" role="tablehead">Red, Green, Blue<br/>composition</paragraph>
+       </tablecell>
+   </tablerow>
+   <tablerow>
+       <tablecell>
+           <paragraph id="par_id131634907471277" role="tablecontent" localize="false">vbBlack</paragraph>
+       </tablecell>
+       <tablecell>
+         <paragraph id="par_id561634907471277" role="tablecontent" localize="false">RGB(0, 0, 0)</paragraph>
+       </tablecell>
+   </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id421634907638611" role="tablecontent" localize="false">vbBlue</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id611634907688162" role="tablecontent" localize="false">RGB(0, 0, 255)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id551634907874363" role="tablecontent" localize="false">vbCyan</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id521634907949411" role="tablecontent" localize="false">RGB(0, 255, 255)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id891634907875500" role="tablecontent" localize="false">vbGreen</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id841634907957172" role="tablecontent" localize="false">RGB(0, 255, 0)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id971634907876196" role="tablecontent" localize="false">vbMagenta</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id501634907977490" role="tablecontent" localize="false">RGB(255, 0, 255)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id941634907876844" role="tablecontent" localize="false">vbRed</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id501634907984434" role="tablecontent" localize="false">RGB(255, 0, 0)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id351634907877572" role="tablecontent" localize="false">vbYellow</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id681634907989235" role="tablecontent" localize="false">RGB(255, 255, 0)</paragraph>
+       </tablecell>
+    </tablerow>
+    <tablerow>
+       <tablecell>
+           <paragraph id="par_id431634907878140" role="tablecontent" localize="false">vbWhite</paragraph>
+       </tablecell>
+       <tablecell>
+           <paragraph id="par_id621634907995939" role="tablecontent" localize="false">RGB(255, 255, 255)</paragraph>
+       </tablecell>
+    </tablerow>
+</table>
+
+      <h3 id="hd_id941624288567829">Variable Type Named Constants</h3>
 <table id="tab_id761624288363725">
     <tablerow>
         <tablecell>
@@ -512,6 +466,152 @@
     </tablecell>
 </tablerow>
 </table>
+
+   <h3 id="hd_id881634911195890">FormatDateTime VBA Named Constants</h3>
+   <embed href="text/sbasic/shared/03150000.xhp#FormatDateTime_constants"/>
+
+   <h3 id="hd_id801634912153888">StrConv VBA Named Constants</h3>
+   <embed href="text/sbasic/shared/strconv.xhp#StrConv_constants"/>
+
+   <h3 id="hd_id131634910758620">WeekDayName VBA Named Constants</h3>
+   <embed href="text/sbasic/shared/03030105.xhp#WeekDay_constants"/>
+
+        <h3 id="hd_id531634913323423">Miscellaneous VBA Named Constants</h3>
+        <table id="tab_id671512313939217">
+            <tablerow>
+                <tablecell>
+                    <paragraph role="tablehead" id="par_id901512312880723" xml-lang="en-US">Named constant</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id891512312916493" role="tablehead" xml-lang="en-US">Hexadecimal (decimal) value</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id991512312965968" role="tablehead" xml-lang="en-US">Description</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id311542196872466" role="paragraph" localize="false">vbTrue</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id151542196872467" role="paragraph" localize="false">-1</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph role="paragraph" id="par_id671542197262160" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id241542196923343" role="paragraph" localize="false">vbFalse</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id611542196923343" role="paragraph" localize="false">0</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph role="paragraph" id="par_id351542197255532" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id551542196949698" role="paragraph" localize="false">vbUseDefault</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id831542196949698" role="paragraph" localize="false">-2</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph role="paragraph" id="par_id251542197274514" xml-lang="en-US">Part of vbTriState enumeration.</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id891512313266496" role="paragraph" localize="false">vbCr</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph role="paragraph" id="par_id241512313723033" localize="false">\x0D (13)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph role="paragraph" id="par_id611512313731233" xml-lang="en-US">CR - Carriage return</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id471512313282257" role="paragraph" localize="false">vbCrLf</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id691512313750520" role="paragraph" localize="false">\x0D\x0A (13 10)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id961512313881937" role="paragraph" xml-lang="en-US">CRLF - Carriage return and line feed</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id11512313289164" role="paragraph" localize="false">vbFormFeed</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id341512313761295" role="paragraph" localize="false">\x0c (12)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id221512313889077" role="paragraph" xml-lang="en-US">FF - Form feed</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id501512313293989" role="paragraph" localize="false">vbLf</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id311512313777558" role="paragraph" localize="false">\x0A (10)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id621512313896169" role="paragraph" xml-lang="en-US">LF - Line feed</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id191512313300610" role="paragraph" localize="false">vbNewLine</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id521512319135830" role="listitem" xml-lang="en-US">\x0D\x0A (13 10) for Windows</paragraph>
+                    <paragraph id="par_id61512319163913" role="listitem" xml-lang="en-US">\x0A (10) for other systems</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id151512313904989" role="paragraph" xml-lang="en-US">LF or CRLF </paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id211512313306932" role="paragraph" xml-lang="en-US" localize="false">vbNullString</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id141512313800110" role="paragraph" localize="false">""</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id741512313911049" role="paragraph" xml-lang="en-US">Null string</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id931512313312621" role="paragraph" localize="false">vbTab</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id241512313810064" role="paragraph" localize="false">\x09 (9)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id951512313918356" role="paragraph" xml-lang="en-US">HT - Horizontal tab</paragraph>
+                </tablecell>
+            </tablerow>
+            <tablerow>
+                <tablecell>
+                    <paragraph id="par_id481512313318983" role="paragraph" localize="false">vbVerticalTab </paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id991512313821414" role="paragraph" localize="false">\x0B (11)</paragraph>
+                </tablecell>
+                <tablecell>
+                    <paragraph id="par_id351512313924593" role="paragraph" xml-lang="en-US">VT - Vertical tab</paragraph>
+                </tablecell>
+            </tablerow>
+        </table>
 </section>
 
 </body>
diff --git a/source/text/sbasic/shared/03103600.xhp b/source/text/sbasic/shared/03103600.xhp
index 70b7e017f0..7c2db5905d 100644
--- a/source/text/sbasic/shared/03103600.xhp
+++ b/source/text/sbasic/shared/03103600.xhp
@@ -47,6 +47,7 @@
 <embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
 <paragraph id="par_id3148664" role="paragraph" xml-lang="en-US"> <emph>Variable:</emph> The variable that you want to determine the type of. You can use the following values:</paragraph>
 
+<section id="VarType_constants">
 <table id="tbl_id3153362">
   <tablerow>
     <tablecell>
@@ -244,6 +245,7 @@
     </tablecell>
   </tablerow>
 </table>
+</section>
 
 <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
 <embed href="text/sbasic/shared/00000003.xhp#err5"/>
diff --git a/source/text/sbasic/shared/03150000.xhp b/source/text/sbasic/shared/03150000.xhp
index 6ad2ca1a6a..01ed090735 100644
--- a/source/text/sbasic/shared/03150000.xhp
+++ b/source/text/sbasic/shared/03150000.xhp
@@ -46,6 +46,7 @@
     <paragraph id="par_id240720170117391741" role="paragraph" xml-lang="en-US"><emph>DateExpression</emph>: The date expression to be formatted.</paragraph>
     <paragraph id="par_id24072017011739895" role="paragraph" xml-lang="en-US"><emph>NamedFormat</emph>: An optional <emph>vbDateTimeFormat</emph> enumeration specifying the format that is to be applied to the date and time expression. If omitted, the value <emph>vbGeneralDate</emph> is used.</paragraph>
     <paragraph role="heading" id="hd_id811512136434300" level="3" xml-lang="en-US">Date and Time formats (vbDateTimeFormat enumeration)</paragraph>
+    <section id="FormatDateTime_constants">
     <table id="tab_0001">
         <tablerow>
             <tablecell>
@@ -114,6 +115,7 @@
             </tablecell>
         </tablerow>
     </table>
+    </section>
 
     <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
     <embed href="text/sbasic/shared/00000003.xhp#err13"/>
diff --git a/source/text/sbasic/shared/strconv.xhp b/source/text/sbasic/shared/strconv.xhp
index 81267e1879..f6e80813a8 100644
--- a/source/text/sbasic/shared/strconv.xhp
+++ b/source/text/sbasic/shared/strconv.xhp
@@ -30,6 +30,7 @@
 <embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
 <paragraph role="paragraph" id="par_id421622762822934"><emph>Text</emph>: Any valid string expression.</paragraph>
 <paragraph role="paragraph" id="par_id671622762931475"><emph>Conversion</emph>: The type of conversion to perform, as defined in the table below.</paragraph>
+<section id="StrConv_constants">
 <table id="tab_id91622763145456">
     <tablerow>
         <tablecell>
@@ -142,6 +143,7 @@
         </tablecell>
     </tablerow>
 </table>
+</section>
 <paragraph role="paragraph" id="par_id761622765118156"><emph>LCID</emph> Optional. The Locale ID in decimal number. If this parameter is omitted, it assumes the system Locale ID. Refer to the file <link href="https://opengrok.libreoffice.org/xref/core/l10ntools/source/ulfconv/msi-encodinglist.txt" name="LCID">msi-encodinglist.txt</link> for the available LCID values.</paragraph>
 <embed href="text/sbasic/shared/00000003.xhp#functexample"/>
 <bascode>