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
What is the exact version no. (e.g. v10.x.y.z) of MicroStation that you are using? Use key-in VERSION to see the version no. in the MicroStation Message Center, or Help→About MicroStation in the backstage.
VERSION
See this blog that shows you how to obtain MicroStation's version number.
Gaurav Ajay Agrawal said:I am trying to Paste an Excel table in Microstation Connect using Place Table feature
Please attach your Excel file, or a subset of that file, so we can test.
Regards, Jon Summers LA Solutions
Hi Jon,
Please see my reply to Jan for version number. I have attached this dummy table and filled with random data. But essentially the data will be filled with results from a macro after user inputs. But the formatting of this file is same as I want. And I am trying to get only A1 to BI80 cells. Let me know if need any more info for your test. Thank you.
Gaurav test file.xlsx
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...
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:Can you measure the total height of the table
Thank you Jon.