Placing table from Excel

Question

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

Carl Myhill · Answer

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.

Carl Myhill · Answer

Having Selected the Place Table tool, In the Tool Settings it is possible to select a predefined Text Style to use, this Text Style will then be used for the text. 
 https://communities.bentley.com/products/microstation/w/microstation__wiki/23888/how-to-control-the-size-of-initial-table-placement 
 If you have a Table Seed defined with all the formatting required this can also be selected in the Tool Settings, note this will override the Text Style setting if used. Thus if placing Tables of a standard format you may want to consider creating Table Seeds. 
 https://communities.bentley.com/products/microstation/w/microstation__wiki/32363/how-to-create-table-seed-that-can-be-placed-as-a-template-into-any-design 
 As you have found you can change the height individually by double clicking in each cell and changing the height in the Text Editor. Alternatively if you right click on the Table itself ( Not a specific cell ) and select Properties, you can set the Text Style to be used.

Placing table from Excel

Top Replies