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]
