source/text/scalc/01/database_table_reference.xhp | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-)
New commits: commit 5489e7d8233df879abbc6ecde9b091e56dea89fd Author: Stanislav Horacek <[email protected]> AuthorDate: Thu Jan 22 17:06:21 2026 +0100 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Jan 23 13:58:17 2026 +0100 adjust database table reference page some parts are not localizable and also keywords can be localized fixed option to include column labels removed duplicated info about square brackets Change-Id: Ifcf9e58aa7e9645bee0c04dcae5eb4e9d0ebc83e Reviewed-on: https://gerrit.libreoffice.org/c/help/+/197857 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/database_table_reference.xhp b/source/text/scalc/01/database_table_reference.xhp index e902e107f8..7e66a85020 100644 --- a/source/text/scalc/01/database_table_reference.xhp +++ b/source/text/scalc/01/database_table_reference.xhp @@ -264,7 +264,7 @@ <paragraph role="paragraph" id="par_id831727204582132">The cell range <input>A1:D11</input> was defined as the <link href="text/scalc/01/12010000.xhp">database range</link> "<input>myData</input> ". The options <link href="text/scalc/01/12010000.xhp#contains_column_labels"><menuitem>Contains column labels</menuitem></link> and <link href="text/scalc/01/12010000.xhp#contains_totals_row"><menuitem>Contains totals row</menuitem></link> were checked when defining the <link href="text/scalc/01/12010000.xhp">database range</link>.</paragraph> <section id="referencing_data"> <h2 id="hd_id121727204707941"><variable id="referencing_data_hd">Referencing data in tables</variable></h2> - <paragraph role="paragraph" id="par_id331727204750507">A database table reference has the form name of <input>database_range[…]</input>. The part inside the square brackets can be a <link href="text/scalc/01/database_table_reference.xhp#reserved_reference_keywords">reserved reference keyword</link>, a field name in square brackets, or a combination of the two.</paragraph> + <paragraph role="paragraph" id="par_id331727204750507">A database table reference has the form name of <input>database_range[…]</input>. The part inside the square brackets can be a <link href="text/scalc/01/database_table_reference.xhp#reserved_reference_keywords">reserved reference keyword</link>, a field name, or a combination of the two.</paragraph> <paragraph role="paragraph" id="par_id871727204795355">In cases where a single keyword or a single field name is used, use single brackets instead of double brackets.</paragraph> <h4 id="hd_id721727375856048">Example</h4> <paragraph role="paragraph" id="par_id861727375863992"><input>myData[#Headers]</input> instead of <input>myData[[#Headers]]</input> or <input>myData[Region]</input> instead of <input>myData[[Region]]</input>.</paragraph> @@ -285,11 +285,11 @@ </tablerow> <tablerow> <tablecell> - <paragraph role="tablecontent" id="par_id221727205404469" localize="false"><literal>[#Headers]</literal> </paragraph> + <paragraph role="tablecontent" id="par_id221727205404469"><literal>[#Headers]</literal></paragraph> </tablecell> <tablecell> <paragraph role="tablecontent" id="par_id741727205444930">The keyword <literal>[#Headers]</literal> references the row of field names (column labels). It is the first row of the database range.</paragraph> - <paragraph role="tablecontent" id="par_id701727205544887"> If the database range has no labels row defined (Contains columns row), a #REF! error is generated.</paragraph> + <paragraph role="tablecontent" id="par_id701727205544887"> If the database range has no labels row defined (Contains column labels), a #REF! error is generated.</paragraph> </tablecell> <tablecell> <paragraph role="tablecontent" id="par_id161727205452550">The expression <literal>myData[#Headers]</literal> references the cells <literal>A1:D1</literal>.</paragraph> @@ -297,10 +297,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph role="tablecontent" id="par_id451727205608044" localize="false"><literal>[#Data]</literal> </paragraph> + <paragraph role="tablecontent" id="par_id451727205608044"><literal>[#Data]</literal></paragraph> </tablecell> <tablecell> - <paragraph role="tablecontent" id="par_id741727205622598" localize="false">The keyword <literal>[#Data]</literal> references the data records of the database range, excluding the column label row and the totals row.</paragraph> + <paragraph role="tablecontent" id="par_id741727205622598">The keyword <literal>[#Data]</literal> references the data records of the database range, excluding the column label row and the totals row.</paragraph> <paragraph role="tablecontent" id="par_id601727205675886">The short form <input>myData[]</input> can be used as well.</paragraph> </tablecell> <tablecell> @@ -309,10 +309,10 @@ </tablerow> <tablerow> <tablecell> - <paragraph role="tablecontent" id="par_id801727205770281" localize="false"><literal>[#Totals]</literal> </paragraph> + <paragraph role="tablecontent" id="par_id801727205770281"><literal>[#Totals]</literal></paragraph> </tablecell> <tablecell> - <paragraph role="tablecontent" id="par_id181727205788642" localize="false">The keyword <literal>[#Totals]</literal> references the row of totals. It is the last row of the database range.</paragraph> + <paragraph role="tablecontent" id="par_id181727205788642">The keyword <literal>[#Totals]</literal> references the row of totals. It is the last row of the database range.</paragraph> <paragraph role="tablecontent" id="par_id211727205840457">If the database range has no line of totals defined (<link href="text/scalc/01/12010000.xhp#contains_totals_row"><menuitem>Contains totals row</menuitem></link>), a #REF! error is generated.</paragraph> </tablecell> <tablecell> @@ -321,7 +321,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph role="tablecontent" id="par_id311727205884492" localize="false"><literal>[#All]</literal> </paragraph> + <paragraph role="tablecontent" id="par_id311727205884492"><literal>[#All]</literal></paragraph> </tablecell> <tablecell> <paragraph role="tablecontent" id="par_id151727205893803">The keyword <literal>[#All]</literal> references the entire database range including column labels and totals.</paragraph> @@ -332,7 +332,7 @@ </tablerow> <tablerow> <tablecell> - <paragraph role="tablecontent" id="par_id771727205927812" localize="false"><literal>[#This Row]</literal> </paragraph> + <paragraph role="tablecontent" id="par_id771727205927812"><literal>[#This Row]</literal></paragraph> </tablecell> <tablecell> <paragraph role="tablecontent" id="par_id221727205934899">This keyword describes an <link href="text/scalc/01/04060107.xhp#implicit_intersection">implicit intersection</link>.</paragraph>
