Hi,
I am trying to Paste an Excel table in Microstation Connect using Place Table feature. I have set all formatting like row height, column width, bordering, etc in excel as I want them to look in Microstation. And I am preserving formatting while placing table in Microstation. The problem here is that when table pastes, the row height automatically increases for every row in Microstation. I tried to reduce the height mt reducing the height of the whole table but it will not go below a certain threshold. I have some 80 rows and 61 columns.
Desired: ( These values are set in Excel)
height of each row = 0.19 inches
Total height of table= 1.48ft
What I am getting: ( In Microstation)
Height of each row = 0.21 inches
Total height of table= 1.671 ft
Does anybody know what is happening here and any help would be appreciated!! The laptop I am using is i7 16GB RAM. Could this be the issue and require higher processor because currently it takes light years to paste and the place table function is quite fickle and breaks the sheet if used multiple times consecutively.
Thank you
Are you using a Seed that you setup for this table? In the settings of the seed you can lock the size of the Rows/Columns so they do not automatically expand. Also, just because you can format something in Excel does not mean it will translate properly in Microstation. There is also an issue with creating stacked fractions in Excel. As far as I can find Excel does not support stacked fraction, but Microstation does. So there may be situations where you want something displayed a certain way that is not supported by Excel.
Using the Place Table tool in Microstation is not that great. It has its uses, but you are limited. For proper use you need to do the upfront work of creating seeds to provide consistent results.
Microstation CONNECT 10.17.00.209
ORD CONNECT 2021 R1 10.10.1.3
Microstation v8i SS 10 08.11.09.919
Power InRoads v8i 08.11.09.615
ProjectWise 10.0.3.453
I am preserving the formatting so it overrides my seed file I am setting in Microstation and taking Excel as a seed file. But I guess it is true that place table has limited functionalities. I will try using a seed file without preserving the formatting.