Jump to content
  • 0

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



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.

Screenshot 2024-04-19 at 9.01.30 AM.png

Link to comment

14 answers to this question

Recommended Posts

  • 0

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.

Link to comment
  • 0

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.

  • Like 2
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...