freeze pane + copy = visual bug

New Contributor

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 COPYPHOTO 1 - BEFORE COPY

 

 

 

photo 2: right after "copy" .

PHOTO 2 - AFTER COPYPHOTO 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 FREEZWPHOTO 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?

 

 

 

5 Replies

@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)

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?

photo 4.png

@omer_fish_alot 

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

any solutions?

@omer_fish_alot

 

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