source/text/scalc/01/database_table_reference.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 8cdedc9880681f9c51c0d54f7d1109c173ddb75d
Author: Andrea Gelmini <andrea.gelm...@gelma.net>
AuthorDate: Fri Sep 27 19:09:59 2024 +0200
Commit: Julien Nabet <serval2...@yahoo.fr>
CommitDate: Fri Sep 27 23:33:35 2024 +0200
Fix typo
Change-Id: I3084421a7390178d8b6cecf8752b3223994e41fa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174056
Tested-by: Jenkins
Reviewed-by: Julien Nabet <serval2...@yahoo.fr>
diff --git a/source/text/scalc/01/database_table_reference.xhp
b/source/text/scalc/01/database_table_reference.xhp
index cf7531ada5..ab1ce1a3f5 100644
--- a/source/text/scalc/01/database_table_reference.xhp
+++ b/source/text/scalc/01/database_table_reference.xhp
@@ -349,7 +349,7 @@
<note id="par_id141727208910739">In Microsoft Excel, if the formula cell
belongs to the table, then the name of the table may be omitted. For example,
the formula <input>=SUM(myData[Sales]</input>) in cell <input>C11</input> could
be written as <input>=SUM([Sales]</input>). Omission of the table name is not
yet possible in Calc.</note>
<section id="sectionidentifier">
<h2 id="hd_id11727208935686"><variable
id="combinations_hd">Combinations</variable></h2>
- <h3 id="hd_id911727368734633"><variable id="colums_and_data_hd">Columns
and data records</variable></h3>
+ <h3 id="hd_id911727368734633"><variable id="columns_and_data_hd">Columns
and data records</variable></h3>
<paragraph role="paragraph" id="par_id621727211351391">To reference a
combination of the column labels and data records, use the format
<input>[#Headers];[#Data]</input> or <input>[#Headers],[#Data]</input>, where
the separator is the same separator as for function parameters that is defined
in <menuitem>Tools - Options - Calc - Formula - </menuitem><link
href="text/shared/optionen/01060900.xhp#separators"><menuitem>Separators</menuitem></link>.</paragraph>
<h3 id="hd_id111727368792150"><variable id="data_and_totals_hd">Data
records and total row</variable></h3>
<paragraph role="paragraph" id="par_id191727211364444">To reference a
combination of data records and totals row, use
<input>[#Data];[#Totals]</input>. For example,
<input>myData[[#Data];[#Totals]]</input> references the cells
<input>A2:D11</input>.</paragraph>
