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
Thank you Jon.
MaryB said:I see myself pasting linked spreadsheets, instead of using MicroStation Tables, for some time to come.
Me too. It took 10 years to get OLE working nice, guess we'll wait that long to use Tables.
Connect r17 10.17.2.61 self-employed-Unpaid Beta tester for Bentley
Gaurav Ajay Agrawal said:Can you measure the total height of the table
Regards, Jon Summers LA Solutions
Hi Jon,
Can you measure the total height of the table and individual row height and let me know. If you are getting what I want, then its problem with my version only then and then I can proceed getting a higher update.
Gaurav Ajay Agrawal said:I have attached this dummy table and filled with random data
Using MicroStation CONNECT Update 16.2 created this in about 40 seconds...