Calc: Cannot copy/cut/delete/insert one specific row

I have a sheet in which I’m able to copy/paste rows generally without issue. Except there is one row that is different. The right-click option to cut/copy the row is grey’ed out and the options to insert to delete row are missing completely. There’s no protection on the sheet.

I can workaround this by selecting the the row along with the rows before and after it. Calc will let me copy/copy & paste all three rows then.

But what is going on with that one row??

See: rows 103 and 105 have normal right-click options:

image description       
image description

But row 104 is different, cannot copy, cut, insert, delete, clear:

image description

No protection enabled:

Version: 6.3.6.2 (x64)

Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497

CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win;

Locale: en-US (en_US); UI-Language: en-US

Calc: CL

Update Apr22:
Per request I’ve uploaded a doc showing this bug.
The original doc is 50 sheets and boatloads of data.
I’ve reduced it down to a single sheet and single column with an array formula causing the problem. This is what it looks like in my view when I was creating it from the larger doc:

image description

Reduced sheet showing bug on row 4:
copy_row_bug.ods

However, this is how it looks if I d/l the version from here and open it, or close and re-open my local copy:
image description

The bug is still present on row4, but now also on rows 8 and beyond.

Also, I’ll note that I just noticed that this problematic column does not have a right-click option to copy, cut, delete, or insert… just like the problematic row. That I can make some sense of, but not why the row issue is present on some rows but not others.

Can you delete the content to remove sensitive data and upload the file showing that?

Original post updated with testcase uploaded.

It is an array. Place the cursor in A4 or any other cell below that one and hit Ctrl+/ (division from numpad), it will select the whole column but 3 first lines.

I don’t use arrays at all, thus I’m of no help. Try to check the help file until a Calc guru comes in.

Sorry, but how does Ctrl+/ help me? What I’m looking for is that row 4 behaves just like all the other rows where it can be cut, copied, inserted, deleted, etc…

It is related to a single array formula being in cells A4, A8 and below, and separate single-cell array formulas in cells A1, A2, A3, A5, A6 and A7.

I have a suspicion that this mess was produced by sorting an array formula range at some stage; but maybe @erAck knows better?

Interesting thing is that if you delete from A5:A7, save and reload, these cells become filled with the same array formula - so they become part of the big array block.

That may indeed have happened with a sort including array formulas in versions 6.4.3 or earlier, see tdf#131442; later versions don’t allow that anymore.

OMG - I have reported that myself! I forgot that completely, and only had a vague idea that I saw Eike doing something on a similar problem :smiley: Thanks Eike!

When you say “don’t allow that” do you mean don’t allow rows to be sorted, or don’t allow the Array formula to be fractured?

Sorting is not allowed if array formulas (other than 1x1 arrays) are contained in the range to be sorted.

You can only copy rows when the selection does not contain only part of an array formula. Rows 4 to 547 of the attached sample contain one array formula in column A; and additionally there are single-cell array formulas in A1, A2, A3, A5, A6, and A7 (the three last ones are very interesting, because they overlap the big array formula range).

It looks like a problem that could be introduced by sorting an array formula range, which was possible in versions prior to 6.4.3 (thanks @erAck for fixing tdf#131442!). So for instance in this sample, you may do this:

  1. Remove data from A5:A7;
  2. Save and reload;
  3. put cursor to A4 (or any cell below), and press Ctrl+/ to select the whole array formula

Now right-clicking the row numbers would bring you normal menu.