diff options
| author | Eike Rathke <erack@redhat.com> | 2022-09-10 14:31:48 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2022-09-10 14:33:39 +0200 |
| commit | e4e464b0c58a1b2dfc6a97b87c9b75e3cac572b0 (patch) | |
| tree | 5f78065e774a66a80e538d380a683579c04b13d4 /source/text/scalc/guide | |
| parent | 18621b8577dda9415f471809c53db623059f8b51 (diff) | |
Remove blank and period nonsense in defined names
Change-Id: I759474b9cfae8a02519108cad98863c5caac7507
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139752
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Jenkins
Diffstat (limited to 'source/text/scalc/guide')
| -rw-r--r-- | source/text/scalc/guide/value_with_name.xhp | 10 |
1 files changed, 2 insertions, 8 deletions
diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index 5a82195f76..1822b2f668 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -44,22 +44,16 @@ <paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1"><variable id="value_with_name"><link href="text/scalc/guide/value_with_name.xhp" name="Naming Cells">Naming Cells</link> </variable></paragraph> <paragraph xml-lang="en-US" id="hd_id4391918" role="heading" level="2">Allowed names</paragraph> - <paragraph xml-lang="en-US" id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and some special characters. Names must start with a letter or an underline character.</paragraph> + <paragraph xml-lang="en-US" id="par_id2129581" role="paragraph">Names in Calc can contain letters, numeric characters, and the underline character. Names must start with a letter or an underline character.</paragraph> <paragraph xml-lang="en-US" id="par_id1120029" role="paragraph">Allowed special characters:</paragraph> <list type="unordered"> <listitem> <paragraph xml-lang="en-US" id="par_id3362224" role="paragraph">underline (_) </paragraph> </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id4891506" role="paragraph">period (.) - allowed within a name, but not as first or last character</paragraph> - </listitem> - <listitem> - <paragraph xml-lang="en-US" id="par_id2816553" role="paragraph">blank ( ) - allowed within a name, but not as first or last character, and not for a cell range</paragraph> - </listitem> </list> <paragraph xml-lang="en-US" id="par_id328989" role="paragraph">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph> <paragraph xml-lang="en-US" id="par_id32898987" role="paragraph">Names must not start with the letters C or R followed by a number; also single characters C and R are not allowed as names. See the ADDRESS function for more information.</paragraph> - <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph">Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents.</paragraph> + <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph">Names for cell ranges must not include blanks. Blanks are allowed within names for sheets and documents.</paragraph> <paragraph xml-lang="en-US" id="hd_id1226233" role="heading" level="2">Naming cells and formulas</paragraph> <paragraph xml-lang="en-US" id="par_id5489364" role="paragraph">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph> <paragraph xml-lang="en-US" id="par_id953398" role="paragraph">For example, it is much easier to read a formula for sales tax if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate."</paragraph> |