Created attachment 8598 [details]
Try to edit Z7 cell

Hi Alexander,

this is not a bug. 

If you have created an array formula, you can't delete just one cell
but only the whole array itself.

So just select the whole array, in your case I think it's y7:z7 and
press del. The array formula is gone.

Normally this is a support question and therefore is answered on the
users@ mailing list.

Best regards

Frank

closed invalid

Created attachment 8629 [details]
derivative file - try to delete/edit J9 cell

Sorry, but I disagree.

Even if it was "as designed", it cannot be found elsewhere - to delete
2 cells in order only to clear one cell. So if 2 or more cells have
the same array function they must be deleted at once only? It sounds
no sence for me, sorry. And moreover, it isn't clear for a user or
documented.

Hi,

this is an extract of the help system on Editing Array formulas :

Editing Array Formulas
1.Select the cell range or array containing the array formula. To
select the whole array, position the cell cursor inside the array
range, then press Ctrl+/, where / is the Division key on the numeric
keypad.
2.Either press F2 or position the cursor in the input line. Both of
these actions let you edit the formula.
3.After you have made changes, press Ctrl+Shift+Enter.

-----

For your second example, an array formula for just one cell, just edit
it by using F2, a double click on the cell or the icon for the
function autopilot.

As I said before, this is a support question and not a bug !

So I close it again as invalid !

Frank

again closed invalid

closed invalid