We are using an embedded Spreadsheet on our drawings.
When we create a PDF file the text in the embedded part shrinks to a nearly unreadable size.
It is only changing the font which is Arial 6 point
If I increase the size to 8 point it prints without problem.
I cant adjust the spacing on the spreadsheet to accomdate the larger font currently.
I tested with v8i and it has the same problem.
Anyone having this problem?
Seems to be related to the relationship between the size of the embedded section and the overall plot size
Same embedded section . First one plotted with a larger fence
"Three" is the 8 point font
It seems to be related to the print size
Creating a smaller print did not shrink the text
One solution is to use FlexiTable™.
FlexiTable creates schedules & tables using only MicroStation graphic elements.
Regards, Jon Summers LA Solutions
There is another option there is a bentley delivered free tool in your macro called table.bas or table.ba
If you save your excel sheet as A CSV file then run the macro it will ask for a text file but you can use the pulldown to see you can use csv as well as txt then a new dialog pops up which you can change colours text height etc it takes a little getting used to using it and maybe a few tries to see its what you want but the text height is from your settings and the fonts is from the active font used in microstation the beauty is its all cad objects.. this is an old tool and we have been using it since v95 you can then leave a note in the file that the data it comes from C:\xyzfolder\abc.csv....
It will however mean you have to rerun everytime you want to update the table if your csv file changes it wont self update like a linked excel file but you do have total control over text sizes and colours etc and as its all ustn elements you can use all the normal tools to modify the final look ...
Lorys
Started msnt work 1990 - Retired Nov 2022 ( oh boy am I old )
But was long time user V8iss10 (8.11.09.919) dabbler CE update 16 (10.16.00.80)
MicroStation user since 1990 Melbourne Australia.click link to PM me
Just saw this thanks I will test it out