source/text/scalc/guide/value_with_name.xhp | 10 ++--------
1 file changed, 2 insertions(+), 8 deletions(-)
New commits:
commit e4e464b0c58a1b2dfc6a97b87c9b75e3cac572b0
Author: Eike Rathke <er...@redhat.com>
AuthorDate: Sat Sep 10 14:31:48 2022 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Sat Sep 10 14:33:39 2022 +0200
Remove blank and period nonsense in defined names
Change-Id: I759474b9cfae8a02519108cad98863c5caac7507
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/139752
Reviewed-by: Eike Rathke <er...@redhat.com>
Tested-by: Jenkins
diff --git a/source/text/scalc/guide/value_with_name.xhp
b/source/text/scalc/guide/value_with_name.xhp
index 5a82195f7..1822b2f66 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>
