Forum Discussion

p_d_hodgson's avatar
p_d_hodgson
Copper Contributor
Apr 16, 2025

Excel Table bug - Copy and Paste

OK, let's vote on whether you think this is a bug!

 

Create a spreadsheet

Enter 'Number' in A1, and 'Reverse' in B1

Enter the formula '=IF(A3="",1,B3+1)' in B2

Select A1:B2 and Format as Table (any formatting you like).

 

Enter 1 in D2, 2 in D3, and 4 in D4

Individually, copy D2 to A2, then D3 to A3, the D4 to A4

You end up with a table with 1,2,3 in A2:A4 and 3,2,1 in B2:B4

 

Undo the copy/pastes, then select D2:D4 and copy/paste to A2:A4

 

Do you get a different result???

Do you think this is a bug?

 

 

1 Reply

Resources