Terry:
I can't speak for OO, but it is very often the case that the sequences
are different for Mac OS. They often use the Option or Apple keys as
modifiers, for example. I tried those, but to no avail.
It looks like you are right about the syntax--I just tried it using
Staroffice
on Windows and it used the semicolon to delimit the two pieces of the
range. Which, as you say, is not going to work as a parameter.
Thanks for your help with this.
Josh
On Feb 8, 2007, at 8:18 AM, TerryJ wrote:
AFAIK, that sort of thing does not differ according to platform.
The API (Application Programming Interface) treats disjunctive
ranges as
just that: cell ranges, plural. An array of cell ranges has different
attributes and methods to a single cell range.
I believe you are wasting your time. The only syntax I can think
of shows
two separate ranges: A1:G1;A3:G3 - in other words, it would be
interpreted
as two parameters where only one is possible.
Someone wanted to do something similar once and I tried enclosing
the array
in brackets, to disguise it as one element - that didn't work either.
Cheers.
Joshua Simons wrote:
Terry, you are right--it is only a matter of convenience. But if OO
can handle
non-contiguous ranges (which I see it does from the documentation,
though CTRL-click does not work on Mac OS) then I assume it can
handle
non-contiguous ranges wherever a range specification is required.
That
may be a bad assumption, but I'd like to try and see.
My problem is that I do not know how to specify a non-contiguous
range
on Mac OS. I'd be happy to know either the mouse/keyboard sequence
for graphically creating a non-contiguous range OR the text syntax
for
specifying such a range. I can't find either in the documentation
(except
for the graphical CTRL-click, which as I mentioned doesn't work on
Mac OS.)
Josh
On Feb 8, 2007, at 1:34 AM, TerryJ wrote:
I find the method awkward enough already. I have all the criteria
ranges in
the same part of the document and never need to see them. All
you're trying
to achieve is not repeating the first row of the first criterion
range. I
doubt that the programmers have been so obliging as to enable you
to do
that.
If you want to use range names for the criteria ranges, Insert
>Names
Define seems not to permit naming disjunctive ranges.
Joshua Simons wrote:
My understanding is that a criteria specification containing
multiple
rows will OR together the criteria and that's not what I need. I
have a
set of criteria that I want to evaluate separately against the same
database
using separate DAVERAGEs(). Rather than creating the following
rows:
column headings | this is the criteria specification for my
criteria #1 | first use of DAVERAGE().
column headings | this is the criteria for the 2nd
criteria #2
column headings | and for the 3rd.
criteria #3
(etc)
I'd like to list the headings only once and then specify the
criteria ranges using that heading row paired with each
of the criteria rows. To do that, I need to specify the criteria
range as two non-contiguous rows.
On Feb 7, 2007, at 7:10 PM, TerryJ wrote:
Joshua Simons wrote:
Is it possible to specify non-contiguous cell-ranges in OO under
Mac
OS X?
In particular, I would like to specify a non-contiguous range
for the
3rd
argument to DAVERAGE()...
Josh Simons
The third argument is a range which contains your criteria. It
has to
mirror the range containing the values you wish to average. Here
is an
example of a criteria range I use for DAVERAGE:
DATE HIGH LOW CLOSE OPEN VOL MOVE VALUE
=07/11/2006
The first row contains the column headings of the range containing
values. The second row contains criteria. Subsequent rows
contain sets
of
alternative criteria.
The criteria range is critDateCalcs. Part of a typical formula
using the criteria is
=DAVERAGE(BTVdly;"VALUE";critDateCalcs)
That finds the average of values in the column VALUE in the
table BTVdly
which occur on and after the date 7/11/6 in the DATE column of
the table.
(The date in the criteria range is calculated by a formula.)
Regards.
--
View this message in context: http://www.nabble.com/Entering-non-
contiguous-ranges-in-Calc-tf3190506.html#a8860189
Sent from the openoffice - users mailing list archive at Nabble.com.
--------------------------------------------------------------------
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
View this message in context: http://www.nabble.com/Entering-non-
contiguous-ranges-in-Calc-tf3190506.html#a8865113
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
