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
If it is older CONNECT beta U10 then there are not much options. Only starting from U16 Excel import is almost usable.
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
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
MaryB said:I see myself pasting linked spreadsheets, instead of using MicroStation Tables, for some time to come
I tend to agree. I imported the OP's Excel file using standard tools in MicroStation Update 16.2. It's not an especially complex table and has little text content. The import took around forty seconds and crashed MicroStation at least once. We're now in CONNECT's seventh year of production: how many more years to get this right?
We created FlexiTable for MicroStation V8 many years ago. It can read and write Excel files. It produces a DGN table in seconds. It has worked reliably for MicroStation users for nearly two decades.
Regards, Jon Summers LA Solutions