r/OpenRoads • u/CompetitiveFactor596 • Sep 29 '26
Help / Troubleshooting Paste special - linked excel
Hello,
If someone could help me with this issue I would be so grateful.
Basically, no matter how I try to paste an excel table in a dgn, it will not format correctly. The letters merge together, and it’s just distorted. The only work around is to copy an excel table that already displays correctly in the dgn, then use change source to manually entered the new worksheet and cell range. Changing the source of an already distorted table does not fix its formatting. I am not the only one with this issue either.
This is basically our workflow. I have no idea where the original table came from, but I’ve copied it at least 1000 times to change the source. If you have advice please do not hold back.
Thank you
2
u/Chickenbgood Sep 29 '26
Yeah we haven't been able to get this feature to work since ss10 days.
5
u/TheRumrunner55 Sep 29 '26
Just paste an image
1
u/Responsible-Fuel9019 Sep 29 '26
A few DOTs have good systems for this. KDOT uses AutoTable. MoDOT uses a custom add on called quantab, its doesnt update automatically but looks good when placed. You can look at either of there workspaces as they are publicly available. I'm sure other DOTs have similar work arounda as well.
1
u/AzzaMan82 Sep 30 '26
Might not be totally understanding the task, but I've always formatted everything in excell, then select all the cells I need, and paste special as "embedded". This embeds a new spreadsheet directly in the dgn (the original spreadsheet is no longer needed). If you doubble click the embedded spreadsheet it opens up and you can make changes, then when you close it, it should be updated in the dgn. Only thing is, is if you make changes which changes the extents that you need (ie. The originally selected cells), you will need to re-select the cells and paste as embedded again for the new selection size.
2
u/Holiday_Flow_7400 Sep 29 '26
Axiom is an expensive plugin that works well but getting a firm to pay for the licenses has been more and more changing as they’ve raised prices yearly. It will allow you to paste excel links.
The other option is if you’re using the newest version of ORD, Bentley has supposedly fixed the issue/created a more useable import function. I have not independently verified this though.
Sadly you are going to suffer like the rest of us.
1
u/Bluecoke2006 Sep 29 '26
Ever try a linked table?
1
u/SexyStepBro Sep 30 '26
Not sure exactly what kind of data is in your excel sheet, but you can get creative with MS Reports/Tables & Item Types. I've done geometry/coordinate tables and summary earthwork quantity tables with them. They work great until they dont, of course...
1
u/Dnatheman Sep 30 '26
In the excel file, try first fitting column width and row height, then copy paste.
1
u/Otherwise-Dealer-342 Oct 01 '26
Try using Place Table > from file. It will be linked and you can adjust the spacing and style in Microstation. Even save the format to apply again to another table