Unfortunately, I am so ignorant of spreadsheet concepts, I am having
difficulty understanding either the Help or Andreas' explanation.
Here is the exact situation that brought up my question:
In Chapter 9 of the Calc Guide (Data Analysis) is a section discussing
Data > Consolidate. This section includes this sentence about the
Consolidate dialog:
"The Source data range list contains any existing named ranges
(created using Data > Define Range) ..."
And in another sentence, "If you are continually working with the same
range, then you probably want to use Data > Define Range to give it a
name."
A "database range" (described by Andreas as "one particular rectangle
of cells by means of an absolute reference $SheetName.$A$1:$X$99")
seems to fit in the context of the chapter, because the Consolidate
dialog shows ranges defined in that format.
But one reviewer said about both these sentences, "Surely this should
be "created using Insert > Names > Define..." instead of "created
using Data > Define Range".
So which is correct in this situation? Thank you.
--Jean
Cor Nouws wrote:
Ah, I see that Andreas has given a much more extensive answer already in
the other list.
Cor
Cor Nouws wrote (30-01-10 12:38)
Hi Jean,
Jean Hollis Weber wrote (30-01-10 05:31)
I am thoroughly confused about the choices for naming ranges in Calc.
Can someone clarify for me the difference between Insert > Names >
Define and Data > Define Ranges? When should one or the other be
used? Are the results different in functionality?
The Data|Define Ranges is for database ranges. The window title is
also different. And if you choose Help in the two windows, you'll see
different contents.
Regards,
Cor
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org
For additional commands, e-mail: dev-h...@documentation.openoffice.org
