diff options
| author | Andrea Gelmini <andrea.gelmini@gelma.net> | 2024-09-27 19:09:59 +0200 |
|---|---|---|
| committer | Julien Nabet <serval2412@yahoo.fr> | 2024-09-27 23:33:35 +0200 |
| commit | 8cdedc9880681f9c51c0d54f7d1109c173ddb75d (patch) | |
| tree | 88f4bc203d715ea2adf65e3e63689cacb34e43b4 /source | |
| parent | d91ca5cb94128baa047ee0187ead1f99c70544b2 (diff) | |
Fix typo
Change-Id: I3084421a7390178d8b6cecf8752b3223994e41fa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/174056
Tested-by: Jenkins
Reviewed-by: Julien Nabet <serval2412@yahoo.fr>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/scalc/01/database_table_reference.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
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> |