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
Sorry for the delay in responding further, I have been able to reproduce and Defect 937783 has been filed, it should respect the selected Table seeds formatting.
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.
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.
I've tested this out with a table seed I created for the same data in OpenRoads Designer Update 4. This is the result - the table on the left is the table seed placed normally, the table on the right is the table seed placed with Excel data:
Hi Carl
Thanks for the response. I've created a different query about this in the past:
https://communities.bentley.com/products/microstation/f/microstation-forum/138252/using-table-seeds-with-excel-data
The problem that I found is that the table seeds work brilliantly, but not when importing Excel data to populate the table seed. The screenshots in the above post show what happens. Could it be because I have several different text styles in the same Excel data/ table seed?