Importing Excel in Microstation Connect

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

Parents
  • I have a similar issue with MicroStation tables

    In sheet space I made a table with no seed using a text style set for a height of 0.07 inches (L070)
    I copied the table from my excel sheet and pasted (ctrl+v) it into the table
    Everything looks good but the cell height is too big, there is too much space around the text
    I select the cell (or even the table) and try to change the cell height from 0.2331 to 0.2 to see if that will tighten it up but it will not get any smaller

    Another issue.....
    I created a row above the table for my header and typed in my text
    i wanted it to be a little bigger (no problem there), wanted it to be underlined (no problem there), I wanted the underline to be offset a little more but no mater what i set it to it does not move

    Service Request number 7001406938

       4428.TABLE TEST.dgn7142.TEST TABLE.xlsx

Reply
  • I have a similar issue with MicroStation tables

    In sheet space I made a table with no seed using a text style set for a height of 0.07 inches (L070)
    I copied the table from my excel sheet and pasted (ctrl+v) it into the table
    Everything looks good but the cell height is too big, there is too much space around the text
    I select the cell (or even the table) and try to change the cell height from 0.2331 to 0.2 to see if that will tighten it up but it will not get any smaller

    Another issue.....
    I created a row above the table for my header and typed in my text
    i wanted it to be a little bigger (no problem there), wanted it to be underlined (no problem there), I wanted the underline to be offset a little more but no mater what i set it to it does not move

    Service Request number 7001406938

       4428.TABLE TEST.dgn7142.TEST TABLE.xlsx

Children