diff options
Diffstat (limited to 'source/text/sbasic/guide/calc_borders.xhp')
-rw-r--r-- | source/text/sbasic/guide/calc_borders.xhp | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/source/text/sbasic/guide/calc_borders.xhp b/source/text/sbasic/guide/calc_borders.xhp index 23fa7b885a..8295c0ad98 100644 --- a/source/text/sbasic/guide/calc_borders.xhp +++ b/source/text/sbasic/guide/calc_borders.xhp @@ -20,7 +20,7 @@ <bookmark localize="false" branch="index" id="bm_id41582391760114"> <bookmark_value>macros;format borders</bookmark_value> </bookmark> - <h1 id="hd_id461623364876507"><variable id="title"><link href="text/sbasic/guide/calc_borders.xhp" name="Calc_Borders_h1">Formatting Borders in Calc with Macros</link></variable></h1> + <h1 id="hd_id461623364876507"><variable id="title"><link href="text/sbasic/guide/calc_borders.xhp">Formatting Borders in Calc with Macros</link></variable></h1> <paragraph role="paragraph" id="par_id461630536347127">By using Basic or Python programming languages it is possible to write macros that apply formats to ranges of cells in Calc.</paragraph> <h2 id="hd_id81630536486560">Formatting Borders in Ranges of Cells</h2> @@ -48,13 +48,13 @@ <paragraph id="par_id841630538209958" role="listitem"><emph>cellAddress</emph> is a string denoting the range to be formatted in the format "A1".</paragraph> </listitem> <listitem> - <paragraph id="par_id821630538210271" role="listitem"><emph>newStyle</emph> is an integer value that corresponds to the border line style (see <link href="text/sbasic/guide/calc_borders.xhp#LineStyles_h2" name="LineStyles_link">Line Styles</link> below).</paragraph> + <paragraph id="par_id821630538210271" role="listitem"><emph>newStyle</emph> is an integer value that corresponds to the border line style (see <link href="text/sbasic/guide/calc_borders.xhp#LineStyles_h2">Line Styles</link> below).</paragraph> </listitem> <listitem> <paragraph id="par_id191630538210607" role="listitem"><emph>newWidth</emph> is an integer value that defines the line width.</paragraph> </listitem> <listitem> - <paragraph id="par_id71630538211142" role="listitem"><emph>newColor</emph> is an integer value corresponding to a color defined using the <link href="text/sbasic/shared/03010305.xhp" name="RGB_link">RGB</link> function.</paragraph> + <paragraph id="par_id71630538211142" role="listitem"><emph>newColor</emph> is an integer value corresponding to a color defined using the <link href="text/sbasic/shared/03010305.xhp">RGB</link> function.</paragraph> </listitem> </list> <paragraph role="paragraph" id="par_id201630538522838">To call <literal>FormatCellBorder</literal> create a new macro and pass the desired arguments, as shown below:</paragraph> @@ -97,7 +97,7 @@ <paragraph role="pycode" localize="false" id="pyc_id531630541792043"> formatCellBorder("B5", cStyle.SOLID, 20, bas.RGB(0, 0, 255))</paragraph> <paragraph role="pycode" localize="false" id="pyc_id601630541792230"> formatCellBorder("D2:F6", cStyle.DOTTED, 20, bas.RGB(255, 0, 0))</paragraph> </pycode> - <note id="par_id261630541889040">The Python code presented above uses the <link href="text/sbasic/shared/03/lib_ScriptForge.xhp" name="SF_link">ScriptForge library</link> that is available since %PRODUCTNAME 7.2.</note> + <note id="par_id261630541889040">The Python code presented above uses the <link href="text/sbasic/shared/03/lib_ScriptForge.xhp">ScriptForge library</link> that is available since %PRODUCTNAME 7.2.</note> <section id="LineStyles_h2"> <h2 id="hd_id361630539136798">Line Styles</h2> @@ -193,7 +193,7 @@ </tablecell> </tablerow> </table> - <tip id="par_id751630539680866">Refer to the <link href="https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1table_1_1BorderLineStyle.html" name="BorderLineStyle_link">BorderLineStyle Constant Reference</link> in the LibreOffice API documentation to learn more about line style constants.</tip> + <tip id="par_id751630539680866">Refer to the <link href="https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1table_1_1BorderLineStyle.html">BorderLineStyle Constant Reference</link> in the LibreOffice API documentation to learn more about line style constants.</tip> <h2 id="hd_id31630542361666">Formatting Borders Using TableBorder2</h2> <paragraph role="paragraph" id="par_id11630542436346">Range objects have a property named <literal>TableBorder2</literal> that can be used to format range borders as it is done in the <menuitem>Format - Cells - Borders</menuitem> dialog in the <emph>Line Arrangement</emph> section.</paragraph> @@ -239,7 +239,7 @@ <paragraph role="pycode" localize="false" id="pyc_id341630544115915"> cell = doc.XCellRange("B2:E5")</paragraph> <paragraph role="pycode" localize="false" id="pyc_id841630544116128"> cell.TableBorder2 = table_format</paragraph> </pycode> - <tip id="par_id751630539680102">Refer to the <link href="https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1table_1_1TableBorder2.html" name="BorderLineStyle_link">TableBorder2 Struct Reference</link> in the LibreOffice API documentation to learn more about its attributes.</tip> + <tip id="par_id751630539680102">Refer to the <link href="https://api.libreoffice.org/docs/idl/ref/structcom_1_1sun_1_1star_1_1table_1_1TableBorder2.html">TableBorder2 Struct Reference</link> in the LibreOffice API documentation to learn more about its attributes.</tip> <section id="relatedtopics"> <embed href="text/sbasic/shared/03/lib_ScriptForge.xhp#ScriptForge_lib"/> |