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
Thank you for giving this creating seed file idea. While creating the table for seed file using Place Table and customizing the created table as I want, I found out minimum row height in Connect edition is 0.228" and we want 0.19" so that is why I was getting row height increase when I was placing table. I understand the reason for the problem I was facing. Place table has its limitations.