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:
But row 104 is different, cannot copy, cut, insert, delete, clear:
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:
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:
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.