Good day
I'm trying to figure out how to use the Place Table tool in MicroStaion/ OpenRoads Designer CONNECT Edition. We have a very standard format for some of our data and would like tables to be created exactly as they are in Excel.
Below is how the data looks in Excel:
Below is what it looks like if MicroStation attempts to preserve the formatting:
You can see that most of the text does not come through and not all of the row heights are preserved. The column widths are preserved.
Below is what it looks like when not preserving the formatting:
Am I missing something?
Kind Regards
Warren
Is there any reason why you wouldn't just use paste special and link the Excel? That will keep the formatting.
Hi Duncan
There are a few reasons we don't want to use paste special:
- The plotted output (PDF/ Paper) doesn't always come out looking exactly as it should - particularly the outer borders which are not always symmetrical in thickness. It's almost like the standard plotter drivers don't handle these objects well - especially at larger scales.
- The Excel line weights don't line up well with any standard plotted line weight, so the tables always look out of place on a drawing - we'd prefer to have the various borders assigned a Microstation colour so that we have more control.
- There's a Place Table tool that should be able to do this. If this feedback can help improve the tool, it'll be good for posterity.
That makes sense. I've always used that functionality for door & room schedules where that is the only thing on the sheet so it's not been a problem.