Good day
I'm trying to figure out how to use the Place Table tool in MicroStaion/ OpenRoads Designer CONNECT Edition. We have a very standard format for some of our data and would like tables to be created exactly as they are in Excel.
Below is how the data looks in Excel:
Below is what it looks like if MicroStation attempts to preserve the formatting:
You can see that most of the text does not come through and not all of the row heights are preserved. The column widths are preserved.
Below is what it looks like when not preserving the formatting:
Am I missing something?
Kind Regards
Warren
Is there any reason why you wouldn't just use paste special and link the Excel? That will keep the formatting.
if you preview the table in MS (within the reports tool) do you see the populated data!. maybe the formatting isn't correct and its not actually doing anything.
Hi Ian
I'm importing the data directly from an Excel spreadsheet, not from a report.
If I edit the text fields, it looks like there is a placeholder for the text that doesn't display:
I realised that the text height in the text field was incredibly small. Increasing it to a proper size actually worked, but it's going to be a pain if we have to manually edit all the cells. It looks like the Place Table tool doesn't like text below a certain size...
Just a thought.. see if the text is linked to Annotation Scale.. Try using the Annotation scale ie 1:100. If you do not know where this is. Press Cntl C and look for Drawing Scale