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
If it is older CONNECT beta U10 then there are not much options. Only starting from U16 Excel import is almost usable.
Hi Jan,
Sorry about that. I am using Open Bridge Designer and then Open Bridge Modeler. I thought it was called Microstation Connect. But here is the version number. I will also submit a service request very soon.
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
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.
And if this is OpenBridge from the beginning of last year...I forget what "power platform" build that was, but It may be an older build with a lot of table bugs.
I see myself pasting linked spreadsheets, instead of using MicroStation Tables, for some time to come.
MaryB
Power GeoPak 08.11.09.918Power InRoads 08.11.09.918OpenRoads Designer 2021 R2