diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2019-11-20 11:43:35 +0200 |
|---|---|---|
| committer | Mike Kaganski <mike.kaganski@collabora.com> | 2019-11-25 07:37:20 +0100 |
| commit | 1863cde98ab2b08df16c0185808dc95d75e5b29f (patch) | |
| tree | 5c33b0d5f2c63441fcfc53e5f1d9afc1600e61b2 /source/text | |
| parent | 759f363668485dab912dafa684934dbc152e7b8d (diff) | |
Clarify some unmentioned disallowed naming cases
Change-Id: Idaf82835d571500d62a8a7cf5ad0d7f5335be524
Reviewed-on: https://gerrit.libreoffice.org/83269
Tested-by: Jenkins
Reviewed-by: Mike Kaganski <mike.kaganski@collabora.com>
Diffstat (limited to 'source/text')
| -rw-r--r-- | source/text/scalc/guide/value_with_name.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index 1d4d6221d7..2864725f48 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> |