MicroStation Forum - Importing a Spreadsheet as a Table - Text is too Small by a factor of 12, and other issues.
BMPCreated with Sketch.BMPZIPCreated with Sketch.ZIPXLSCreated with Sketch.XLSTXTCreated with Sketch.TXTPPTCreated with Sketch.PPTPNGCreated with Sketch.PNGPDFCreated with Sketch.PDFJPGCreated with Sketch.JPGGIFCreated with Sketch.GIFDOCCreated with Sketch.DOC Error Created with Sketch.
Question

Importing a Spreadsheet as a Table - Text is too Small by a factor of 12, and other issues.

by
Charles (CADDCOP) Rheault
Expert
Created in MicroStation Forum

I tried to bring in a spreadsheet as the source/seed for a table, and the table and its text came in 12 times too small. When pasting from Excel, in the past, we had to scale it up by 12 times the drawing scale. But with Annotation Scale. its only 1/12 too small. I was able to select the table and use the scale element command, but the table settings - lines, fill, fonts were still rather difficult to reset to something useable. And if I refreshed it from the spreadsheet, it reverted back to its original size.

There seems to be no easy way to set text styles for multiple cells (and other settings) as defaults or after the fact when using an Excel source

There has to be more productive ways of using Tables in MicroStation.