freeze pane + copy = visual bug

[omer_fish_alot]

hello all,

This problem started in Office 2016 and continues now in Office 2021:

Issue A:

When a sheet has "freeze panes" and I copy (either using mouse or Ctrl+C) a cell - 

It "jumps" to a different part of the sheet, part I haven't used at all before.

Attached photo 1: freeze panes, before "copy".

PHOTO 1 - BEFORE COPY

photo 2: right after "copy" .

PHOTO 2 - AFTER COPY

Issue B:

After disabling "freeze pane", copying causes the sheet to turn gray.

photo 3: after disabling freeze and using copy.

PHOTO 3 - COPY W/O FREEZW

In both issues, when pressing Ctrl+C, or moving the cells with arrows or zooming in\out returns the view to the original place I was at.

It is arduous and becoming frustrating just working like that.

Plus, I no longer have the "disable graphic acceleration" option.

Any thoughts?

[#2]

@omer_fish_alot 

Weird - I also have Excel 2021 but I cannot reproduce either issue.

(I switched the sheet to display right-to-left to see if that had anything to do with it)

[#3]

well,
I switched to LEFT-TO-RIGHT and the problems were gone.

Why is that?

Note:
The original Excel is in Hebrew (Right-to-Left), I downloaded English pack so everything will be Left-to-Right.
Could this have contributed to the issue?

[#4]

@omer_fish_alot 

Yes - recent versions of Excel have some bugs relating to right-to-left sheets. Scrolling is often irregular.

[#5]

any solutions?

[#6]

@omer_fish_alot

Not that I know of. You can report it to Microsoft by selecting File > Feedback > Send a Frown in Excel.