Hi Joe Thanks for your bit of wisdom This is exactly what I needed to know Apologies for the late response Regards Ken Will experiment a bit tonight when I have some time
-----Original Message----- From: news [mailto:[email protected]] On Behalf Of Joe Smith Sent: 10 December 2008 19:39 To: [email protected] Subject: [users] Re: copying a single cell array formula by dragging it down 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]
