How do I make a Table from a Excel spreadsheet?

Using the "Place Table" tool set to from excel file:

For a detailed description of each tool setting see the following information.

I tried that but all I got was a table that linked to the spreadsheet, which by the way, didn't update when updating the spreadsheet. The table also wasn't editable in CE. I could pick it but do nothing else with it.

How do I just place (copy) the spreadsheet into the file without the link. 

Jose Pinho said:

You don't get to see rows and headers because in your Element Selection you have Disabled Handles (like read only) object turned on.

Wow, did not know about this feature! ... and I have handles displayed on alwyas. Always something new to learn ;-)

Regards,

  Jan

But you shouldn't need to have handles enabled to allowed Tables to work correctly.

Bentley - Any chance you can fix this. Think I will file an ST. 

stuartw said:

But you shouldn't need to have handles enabled to allowed Tables to work correctly.

I do not usually switch off handles, so I had to test how MicroStation behaves when the handles are not visible and it would be valuable to create a list what features are now treated as handles. I found:

• Traditional handles displayed at element vertices
• Table handles
• Tool widgets handles used to modify e.g. cut plane etc.
• 3D element handles used to access parametric modeling features for selected element

Maybe there are some more, displayed in specific situations. Anyway, to use handles to edit table element seems to be consistent with common concept when to display addition tools to modify the selected element.

With regards,

  Jan

stuartw said:

still no rows and headers

I opened your file Floor_Area_Schedule.dgnlib. Here's what I see when I select your table...

Defect 1005408 has been filed to have this addressed. Thanks for reporting.

Defect 1005408 has been filed to have this addressed. Thanks for reporting.