source/text/scalc/guide/value_with_name.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 1863cde98ab2b08df16c0185808dc95d75e5b29f
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Wed Nov 20 11:43:35 2019 +0200
Commit: Mike Kaganski <mike.kagan...@collabora.com>
CommitDate: Mon Nov 25 07:37:20 2019 +0100
Clarify some unmentioned disallowed naming cases
Change-Id: Idaf82835d571500d62a8a7cf5ad0d7f5335be524
Reviewed-on: https://gerrit.libreoffice.org/83269
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kagan...@collabora.com>
diff --git a/source/text/scalc/guide/value_with_name.xhp
b/source/text/scalc/guide/value_with_name.xhp
index 1d4d6221d..2864725f4 100644
--- a/source/text/scalc/guide/value_with_name.xhp
+++ b/source/text/scalc/guide/value_with_name.xhp
@@ -58,7 +58,7 @@
</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 letter R followed by a number. See the ADDRESS function
for more information.</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="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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
