I copied a piece of an Excel file into AutoCAD as a table. It comes in with the truetype font even though it is assigned to a table style that utilizes an shx font and the correct text style is assigned when I double click in the cell. If I click into the cell and change the text style it will change the font but this will be very time consuming.In the end, I need an AutoCAD table with this information.
View 8 RepliesThere is a font and table style called "Legend" that is automatically generating and can not be purged.
I have looked through all the start up files, all the lisp files and can't find anything that would be creating them!
They appear in any file I open, new or old and even if I open a template file.
I have attached a file that should be empty but you will (or should) see both a font and table style called "Legend".
(FYI I am running AutoCAD Civil 3D 2010 as AutoCAD 2010)
I am using Autocad Electrical and I have an attribute name INST for the installation code in multiple blocks in my drawings. Is there a command out there that can change the font of just that attribute to Arial through out the drawing. I do not want to change any of the other attributes and they all use the same style.
View 7 Replies View RelatedI would like to know if there is a way to change the colour of the font of the file name at the top of the autocad window. It is currently white. The problem is our company standard desktop background colouris fixed as shown a light blue, and so I cannot read the file name of the autocad drawing.
View 1 Replies View RelatedIf it is possible to change the default font used when inserting a symbol in mtext. e.g. the centerline symbol.
At the moment the font used is isocpeur and I would like it to be Romans.
In our company, we put Excel tables in our drawings. The reason we've chosen for Excel-tables is that we can adjust the layout of the table quite easily. These tables consist of grouped cells in a particular company-specific layout. We select the range of the desired cells, copy and paste them in our AutoCAD drawing. This drawing is sent to our customers. The disadvantage of this method is, that when our customers (who use CAD-software of other brands) open the dwg, they don't see the table, but some kind of picture of the table.
Is there a way to 'explode' the excel-table, but keep the specific layout of the table? For attributes in blocks there's the 'Explode Attributes'-command in the Express-tools, but is there something similar for Excel-tables?
Product Design Suite 2014
Inventor 2012 SP2, Vault 2014
HP Workstation Z220
Intel Xeon 3.4GHz
16GB RAM
Nvidia Quadro 4000
Windows 7 Professional (64bit)
Is there a correlation between the font size I use in an Excel spread sheet & the font size on the imported table on the drawing? My spread sheet font size is 8 point. I seem to recall that a point is 1/72" so my 8 point text should be 0.111" high on the drawing. When I import the table I get text that is 0.0556" high - looks like half the height of my spread sheet text. I tried doubling the spread sheet text to 16 point hoping it would end up half size on my drawing (0.111") but this time it is 0.125" high. The scaling of imported table text is inconsistent. I know I can change the properties of the drawing table to get what I want but it would be easier if there was a fixed relationship between Excel & AutoCAD table text height.
View 9 Replies View RelatedI want to create a table with all characters inside a font.I used "%%" to change a number to it's character.but "%%" limited to 999 and for numbers bigger than 999 it doesn't work.
also, CHR command limited to 255 and for numbers bigger than 255 it change to (number-255). so I used "%%" to create this table:[Please change default font in your AutoCAD to ARIAL]
(Defun c:charmap ()
(setvar "cmdecho" 0)
(setq cnt 1.0)
(setq r_cnt 0.0)
(setq ts 32)
(setq x 0.0)
(setq y 0.0)
[code]...
I want to know:
1- what can I do for numbers more than 999?
2- How can I know the number of characters inside a font?
3-how can improve my LISP program to have complete characters inside the fonts?
When I make a text, and if I like to change the font style how can I do this with out having to click on the new font,
every time I choose a different font I have to click on that font, and if I don't like I have to click on a different one
I like to do it like in Flash MX I move the pointer over the list of fonts and may text change the font style with out click on it
Currently I am converting old type tables (text type) to real table using lisp. In this I have facing one issue, once converted to table, every time I must align the table like text height, test alignment, row height, margin and each column size (different size).
View 0 Replies View RelatedI'm trying to change all the texts to my table to yellow.Match Cell command didn't work.
How Can I do that?
I have imported an Excel 2003 spreadsheet into an AutoCAD 2010 Table, all came in fine except the following formula =ROUNDUP(((SUM(E27:E33))/24),0)
Does 2010 not support ROUNDUP ? The formula is used to calculate the number (whole) of driver boards required to drive the number of LED's calculated by the SUM function. Each driver board can drive 24 LED's, so if i have 23 LED's I need 1 driver or if I have 25 LED's I need 2 drivers
Also is there a list or table that shows what Excel functions are or are not supported in AutoCAD? I can't seem to find one.
Is it possible to write “If statement” in the table?
For example, I wanted to have the following if statement:
If b3>180º, d3 = b3-180º
If b3<180º, d3 = b3 +180º
Is this possible in the AutoCAD the same way we do it in excel?
Software: AutoCAD 2014, AutoCAD C3D, AutoCAD M3D, Revit
Windows 7 (Ultimate 64 bits),
Firefox 20.0,
Kaspersky 2013.
I'm attempting to create a table within autocad that I can update as I add new things to my drawing.
I have a ton of dblocks that carry attributes with them, and I want to be able to have the table in autocad populate with the information from each insertion.
The table in autocad will be linked to an excel spreadsheet that should also be updated (either as a separate action or automatically... not sure what would be better).
The table in excel will go through a system of formula that will divide it up into useable groups for me. How do I update a table within Autocad, instead of having to create a new table every time I want to add data to the extraction information?
We use a table with an inserted jpeg image (company logo) as our title block. Everything works fine when you start a new drawing, however, when one tries to insert the template into an existing drawing or thru a new layout, the table that is our title block comes in mirrored with the rows and columns all out of whack.
View 6 Replies View RelatedI have a table imported into autocad from excel, however despite the table (excel) being formatted, border lines appropriately placed and hidden througout the sheet, all off the border lines of the cells appear when imported into autocad.
is there anything i can do to hide back some border lines for selected cells?
I've linked a table to an Excel file. It comes in with twice the number of rows that are needed. There are 35 rows of data and it comes in with 70 rows. The print area in Excel is set to only the 35 rows. Can I truncate the table?
View 2 Replies View Relatedi Have the dwg drawing in which a table is made by simling joining the lines & putting the text in those line.Can that data in actual be converted into the table?
View 1 Replies View RelatedI am currently using 2008. I have data linked an excel sheet to a table in my drawing. That part works fine.I am trying to link cell values in that table to block attributes using fields-object-formula-cell.Numeric values transfer to my field OK but values containing letters or full words transfer as #####.This appears to be the 'way it is' in 2008.
View 7 Replies View RelatedI use an embedded excel file I a lot of my drawings. 90% of the time a double click opens excel for editing with no problem. But every so often I get a stubborn one that just will not open. It will select and the quick properties box will appear and then the properties box, but nor firing up of Excel. Usually if I am persistent I can get it to work, but I have one right now that is more stubborn than I am.
View 2 Replies View RelatedWe own Civil 3d 2010 and are using the Map workspaces.
It seems Map is hard-coded to use the table style 'Legend' when inserting a legend table, yet you can modify the table style of the legend table after it has been inserted.
Is there a way to change the default table style from 'Legend' to something else?
I create Table using Autocad .net api C#.
var table = new Table();
In single text(class DBText), change text width of the property - WidthFactor.
How change text width in table cell using autocad .net api C#?
How can I change the minimum radius table if Autocad Civil 3D only have as a minimum 4%?
And I need to use as a minimum 2%. see attached picture.
The hole table has a column named description, but in that column i want to change the defaults for the thread, i don't need the thread class, for example.
I can add or remove thread properties to the table, but i don't want to, i want to use the general Description column, which describes not only threads.
I am creating a custom table in a .idw through VB. I was looking for the code that would tell it to make a column have units formattng. For example, instead of my thickness to be 0.5, I want it to show 1/2 in. I know you can do this manually in the table editor, but I cannot find any bits of code that will do it in VB automatically.
View 1 Replies View RelatedI need to change many drawings from our old Plot Style to a new version.
I was going to use a script to also purge and complete a few other house cleaning items...
what is the best way to change the plot table from old.ctb to new.ctb (they are not named that BTW.)
Civil 2013
No documentation : remove all property overrides
If I insert a table with our standard table style is is to big, so made a smaller text style, made a new table style with the new text style in it.
And if I insert a new table with the new style its still big...
But... select the table, right click, Remove All Property Overrides... And the text style is OK, only the row height is wrong, so in the table bar - unlocked, select the table again and move the right little triangle up until the rows don't get smaller.
I have created a dynamic block and have applied some lookup tables to it but its not working just the way I want it. I think its to do with the custom entry on the lookup tables. If I delete the custom entry when i select the block in model space the drop down select box to allow me choose a selection is no longer available. How can I remove the custom entry and still have the block working normally. I've attached the block.
View 9 Replies View RelatedHere's my problem: I have a customized plot style table "SK.ctb". I have it saved both in the appropriate folders on my computer and in a shared folder on the network. Usually when I am working in a file and open the plot window, my plot table is available in the list at the upper right "Plot style table (pen assignments)".
Right now I am working in a drawing that was sent to me by another firm. They of course didn't send me their pen assignment tables, not that I really care as I would rather edit the layer colors if necessary, but use my own. The problem is that in the plot window it is only showing their plot styles - none of mine! Theirs are all listed as missing, but I can't get it to even look for the plot tables I usually use.
I am trying to add a table that I can edit like an attribute but have it in a block, Basically I am trying to put information for all the poles in an electrical panel, but im not using MV parts just a block is there anything that can be recommended in this instance.
Just another note I need to reference 72 poles and 5 colums for each of these.
Can't drag it, copy it...anything. I guess you're just never supposed to want your table on some other sheet than the one you created it on.
Oh wait; I know...I could just swap everything *else* on the two sheets....