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]
