Hi!
I'm working on the creation of standard procedures for every body in the office for the insetion of (linked) excel tables in layouts.
After reading a lot of the information available on this and other forums, I feel that the best way to do this is to use the autocad enties method.
What I don't get - and even worst, I can't control - is the sizing of the inserted object. It appears in layout much bigger than I need and with a font size that (from what I can anderstand and test) has no clear relation with the excel font size (which I don't want to change). Of course being a table it can be scaled but with no clear rule - therefor not so suitable for implementing for everybody here.
I treid to use DATALINK when creatting a table and in that approach (good when it comes to size as it uses acad table style) the problem is that merged cells in excel come up divided in acad and bold or normal characteristics (which I need) are lost.
Is there a way to set a text height by default for autocad entities?... that would solve my problem.
Thank you!
Thank you R. K.!
I totally understand that solution. I dove into this just a few days ago and I'm tired already. I would still like to go for linked files because sometimes we have tens of different tables by acad file. It feels it would be too difficult to manage all those pdfs.
On top of that I really just need to adjust size. I am ok with all other features (font, margins, etc.). I think I'd prefer to create a small table to generate scale factor according to the font size of the inserted table that people could easily use.
Anyone?
Datalink(ed) tables - why do cells import as unmerged and can I stop it?
Autocad entity table - what's the logics of the size? Can I set a fixed font size?
Thank you!
Thanks Dean!
Yeah, I have the tablestyle set according to my needs. And it works but, as I posted before, with datalink (that uses tablestyle directly) I lose some precious information (merged cells and bold for exemple). For now I seatled with creating a table with a formula to generate a scale factor.
I'll keep trying to understand this though...
Thanks!