Worksheet database - header row shifts to the right by one column when copied and pasted to another row

[nahekul]

When copying one database header row to another row, the data in the columns are shifted to the right by one row.

 

See the image:

- Row 2 is copied/pasted to row 5 using cmd+c and cmd+v

- Data from column A is shifted to B, B -> C, etc...

 

However, if the row is copied by option dragging, then the columns stay in place.

[michaelk]

That's a new one!

 

Are you clicking on the row header to select the row or selecting all the cells?

 

Are there any merged cells in the worksheet?

[nahekul]

I'm clicking on the "2", which auto-selects the entire row. (Not by selecting all the cells.)

 

There are no merged cells in the worksheet. 

 

This is done with a new worksheet and converting row 2 and row 5 to a database row.

[michaelk]

Wow.  I do that all the time and I've never see that.

 

Can you post a file with the offending worksheet?

[michaelk]

Are you coping and pasting both rows 1 & 2 together into rows 4 & 5 in one action?  (The label didn't advance one column over, but the database headers did)

[nahekul]

Here's the file.

 

I am just copying the one database header row and pasting it into another (blank) database header row that's already created. 

test 1.vwx

[nahekul]

Here's a screen recording.

[drelARCH]

it's been like this already for good few years 🙁 ... at least that is our experience

[michaelk]

This is what I see when I do that.  

 

 

[michaelk]

Do any of your database header cells reference other cells?

[michaelk]

When I copy/paste on your file it works correctly!

[michaelk]

 

 

[nahekul]

It works correctly if you copy it to a new empty cell.

 

It doesn't work if you copy it to an existing database header cell.

[nahekul]

If you clear the content of those new database header rows, and now try to copy the first row into those empty database header rows, it will start offsetting. 

[michaelk]

Now I see it!

 

I didn't realize you were copying to an already existing database row.

 

I'll write up a bug report.  

 

Until it gets fixed (no guarantee when that will be) you'll have to first right click on the row header, choose spreadsheet, then paste.