Leading Blank Cells being omitted when Pasting Spreadsheet from Excel as Table...only on some machines.

Leading Blank Cells being omitted when Pasting Spreadsheet from Excel as Table...only on some machines.

DWS44
Contributor Contributor
657 Views
2 Replies
Message 1 of 3

Leading Blank Cells being omitted when Pasting Spreadsheet from Excel as Table...only on some machines.

DWS44
Contributor
Contributor

Run into an odd issue copying a spreadsheet from Excel and Pasting as a table in CAD (C3D 2020). Doing so via Paste Special -> AutoCAD Entities as we typically do. This particular spreadsheet is formatted with a column of blank cells on far left for spacing.

DWS44_0-1622821579670.png

 

The spreadsheet has worked fine for us for a few years now. User highlights all of the area with white background, including the blank cells on far left and right, copies to clipboard, then paste special to insert. No linking or anything like that. On the older machines, the table pastes perfectly as below:

 

DWS44_1-1622821766946.png

 

Now...we recently rolled out several new laptops across the company, loaded with what I thought was the same profiles as the older machines. All are opening the same drawing template. Problem is that when someone pastes from this same Excel spreadsheet on the newer machines, you get this odd looking mess below. All of the columns are inserted at the right column width, but the the text is all being shifted one column to the left...basically omitting the column of blank cells:

 

DWS44_2-1622821985349.png

 

This one has me stumped. I've tried comparing variables between machines and installations, and between drawings created between both machines where this had been inserted, and I can't find any anomalies or variables that are different. I assume I'm missing a variable of some sort that would control this, but I'm at a loss as to what it would be. Any thoughts? 

 

0 Likes
658 Views
2 Replies
Replies (2)
Message 2 of 3

tcorey
Mentor
Mentor

Versions of Excel and Windows are the same across all platforms?



Tim Corey
MicroCAD Training and Consulting, Inc.
Redding, CA
Autodesk Platinum Reseller

New knowledge is the most valuable commodity on earth. -- Kurt Vonnegut
0 Likes
Message 3 of 3

DWS44
Contributor
Contributor

Yes to both. I thought perhaps it was an Excel version issue, so I made sure I had the same build on the older machine as the new ones.

0 Likes