nahekul Posted April 19 Share Posted April 19 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. Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 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? Quote Link to comment
0 nahekul Posted April 19 Author Share Posted April 19 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. Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 Wow. I do that all the time and I've never see that. Can you post a file with the offending worksheet? Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 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) Quote Link to comment
0 nahekul Posted April 19 Author Share Posted April 19 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 Quote Link to comment
0 nahekul Posted April 19 Author Share Posted April 19 Here's a screen recording. test.mov Quote Link to comment
0 drelARCH Posted April 19 Share Posted April 19 it's been like this already for good few years 🙁 ... at least that is our experience Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 This is what I see when I do that. WorksheetDatabaseCopyPaste.mp4 Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 Do any of your database header cells reference other cells? Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 When I copy/paste on your file it works correctly! Quote Link to comment
0 nahekul Posted April 19 Author Share Posted April 19 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. Quote Link to comment
0 nahekul Posted April 19 Author Share Posted April 19 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. Quote Link to comment
0 michaelk Posted April 19 Share Posted April 19 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. 2 Quote Link to comment
Question
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.
Link to comment
14 answers to this question
Recommended Posts
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.