Apache OpenOffice (AOO) Bugzilla – Issue 67047
The 'Recognizing Names as Addressing' topic is incorrect.
Last modified: 2006-07-07 10:14:23 UTC
Under the help topic "Recognizing Names as Addressing", which describes the use of automatically recognized labels in Calc, the following text does not appear to be completely correct: "If you enter the name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must enter a backslash in front of the quotation mark, for example, 'Harry\'s Bar'." I can have labels automatically recognized with Calc under Windows 2000 and Linux with or without the single quotes. Others have told me that they receive the "#NAME?" error when using single quotes. This situation should be investigated and the help topic made more accurate...please.
The help text is correct. As you cited: "If you enter the name in the formula yourself," ...
closed