diff options
Diffstat (limited to 'source/text/scalc/guide/value_with_name.xhp')
| -rw-r--r-- | source/text/scalc/guide/value_with_name.xhp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/source/text/scalc/guide/value_with_name.xhp b/source/text/scalc/guide/value_with_name.xhp index e7840121b5..2b706ad593 100644 --- a/source/text/scalc/guide/value_with_name.xhp +++ b/source/text/scalc/guide/value_with_name.xhp @@ -43,7 +43,7 @@ </bookmark><comment>mw changed "names;...", "addressing;..." and "references,..." entries.</comment><comment>mw added "renaming;"</comment> <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">Naming Cells</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="hd_id4391918" role="heading" level="2">Allowed names</paragraph> + <h2 id="hd_id4391918">Allowed names</h2> <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"> @@ -54,7 +54,7 @@ <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 sheets and documents.</paragraph> - <paragraph xml-lang="en-US" id="hd_id1226233" role="heading" level="2">Naming cells and formulas</paragraph> + <h2 id="hd_id1226233">Naming cells and formulas</h2> <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> <paragraph xml-lang="en-US" id="par_id4889675" role="paragraph">Use the <emph>Define Names</emph> dialog to define names for formulas or parts of formulas you need more often. In order to specify range names,</paragraph> |