Hi Arnold Joe has correctly understood my problem Thanks for your input though All responses gratefully received and studied Regards Ken
-----Original Message----- From: Arnold Huzen [mailto:[email protected]] Sent: 10 December 2008 21:21 To: [email protected] Subject: Re: [users] Re: copying a single cell array formula by dragging it down It's not the reference to the array that Ken is asking about, it's the reference to the single cell (A12). This should change as he drags the formula. Which in his case it doesn't. Arnold Huzen Joe Smith schreef: > Ken Jolliffe wrote: > >> I have written a simple single cell array formula but when I drag it >> down to copy to the cells below the relative reference does not change >> ... > > Calc handles drag-fills of array formulas differently than normal > formulas. It expands the area covered by the original array formula > rather than making new copies of it with the references adjusted. > > You can see this if you drag-fill your array formula, then type Ctrl+/ > to select all cells belonging to the formula. You'll see that all the > cells that you dragged into now belong to the one, original array > formula. The references are not adjusted because there is only one > formula. > > Instead of using a drag-fill, just copy the array formula cell and > then paste it into the other cells where you want it. This will give > you separate copies of the single-cell array formula, with the > references adjusted as usual. > > You should be careful to understand what you're doing here: > drag-filling an array formula often means that the user is confused: > array formulas do their own reference adjusting without needing > separate copies like normal formulas. > > <Joe > > > --------------------------------------------------------------------- > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
