How is this even possible. I am working on setting up tables for use on our projects. I have been experimenting with the various options to figure what works & what does not. Using CE 16.3 I was having an issue with the Import from File (Excel). In CE 16.3 I have a seed table created with the appropriate column headers and a title. Then I have several empty rows.
Using the Place Empty table the inserted table looks like this (seed table name is PointList). This seed table contains the correct formatting for the rows, columns & cells.
Placing another table and selecting From File I select the seed table. Then I select the Excel file, which only contains data that should populate the body of the table (no title or column headers).
When I place the table, the first row of data is inserted into the 3rd row of the table overwriting the Northing & Easting column headers.
There is no solution for this but, I did find a forum post describing this same issue.
Talking with a colleague earlier today, they mentioned that the table tool had some updates in CE 17 so I thought I would see if my table would work in there.
WOW! is about all I can say. Unless I am missing something, they broke this tool's limited functionality.
In CE 17 I selected the Place Table tool and selected From File once again. With this version you cannot even pick a table seed. You can only select a Table Style.
Table Style???? What's that? No surprise here, looking at the Help Documentation the only information provided is
The Ribbon tool group they reference does not contain this tool. You need to select a table that was already placed and formatted. Once you select an existing table in the file the Layout tab becomes visible and contains the Save Style tool.
So I placed my PointList tabled seed, selected it and used the Save Style tool. Going back to the Place Table tool & selecting From File the Style I saved (just named it Style1) is in the list of Table Styles. So I set that style, selected my Excel file and placed the table in my file. I had to chuckle in dismay when I saw the result
The table is placed on the correct level but, the color, weight & style are all 0. Notice there are no grid lines and the title row & column header rows are non-existent as well. Ok, select the the new table and check the properties dialog. Looking at the General section the Color Style & weight of the table are not set bylevel, even though the original table was set that way. Attempting to change those settings, only the color attribute changed.
For the Text Styles section the Default Text Color & Weight were set to From Table, even though the original table was set to use Color 0 & Weight 3. Trying to change those settings failed as well. Going to the Layout tab and trying to turn the Borders on fails as well.
Anyone else noticing these issues with Place Tables in CE 17?
Can someone at Bentley tell us when this is going to be fixed? This has been an issue for three versions of Microstation now:17.0, 17.1, & 17.2. It has made it so that we cannot link to an excel file and properly control the formatting... making the tool useless. Really a shame as the tool worked very well in proior versions : (
This is how it works for Bentley. A new "Technology preview" feature is introduced which is almost usable and then it gets abandoned even that lot of issues are reported and then later move to Commercial Release without noticeable changes. Like WMS/WMTS, PDF vector import, Items, Constraints and some more. Critical issues(crashes) are maybe fixed but change requests have to wait for loooong.
Regarding Tables most likely all the previous bugs are lost when moving to new "Technology preview" Support portal. So best is to report it again so it gets new case number.
will do
It's a shame that the Place Table tool is broken. It has a lot of potential. I had a lot of processes worked out for bringing in linked Excel files.
Microstation CONNECT - 10.17.2.61
ORD - 2021 R1 10.10.1.3
ORD 2022 R1.1 - 10.11.3.2
ORD 2022 R3 - 10.12.2.4
Microstation v8i SS 10 - 08.11.09.919
Power InRoads v8i - 08.11.09.615
ProjectWise - 10.0.3.453
Agree... it was working quite well before. The most disappointing part of all is the fact that this has been an issue for THREE versions of microstation now!!! Placing table data linked to an excel file is such a common thing people need to do that affects so many different fields and disciplines. I really hope they fix it soon.
EDIT: if everyone reading this could submit a new ticket on the issue maybe that will help bring it to the top of their to-do list
Same. Not using tables or creating workflows involving tables until this is resolved. When Microstation 2023 will be released(in year 2024?) then would expect to be fixed otherwise the 2023 version milestone is about nothing.