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.
Is it possible to use a load statement in a profile to automatically load/unload a cuix?
View 7 Replies View RelatedIn 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)
how to write vertical text in a table?
View 5 Replies View RelatedI have a structure that I need to wblock but I need to bpoly it first, which is a tedious and time consuming process.Is there a way to wblock it without applying bpoly first?
View 3 Replies View RelatedI am trying to write a macro for a button that when I press, it goes to a certain folder on a server. Normally when you click on the "open" button, it takes you to the last file location. I want that to be ignored an goes to a certain folder.
View 3 Replies View RelatedThere seems to be a glitch in AutoCAD with allowing another user to access a drawing that someone already has open. Most of the time , it will not allow this and will correctly give the message that someone is already in the file and give the option of opening file as read only.
There have been a few times though that someone will not be prevented from accessing the file and the read and write privileges will be transferred to the new user that opened the file last. How do we prevent this from happening??
Write an lisp file that would embed a tif image
View 5 Replies View RelatedI have a brand new workstation and only on certain files it will say FATAL ERROR: Cannot write to undo file (probably disk full) when ever I save. I have tried cleaning out the TEMP file, turning off the Undo function, auditing the file and its xrefs, and recovering the file. It was a file that was on the server, but I have pulled it to my local machine and I have also increased the amount of virtural memory avaiable.
View 3 Replies View RelatedWhat the heck? Brand new machine and new autocad 2012 MEP install.
View 9 Replies View RelatedIs it possible to add an if then statement to the parameters manager in dynamic blocks in Autocad 2014. For example, in the image below is it possible to put in A1... 'IF Dim1= 0, display 0, else (Dim1-79-50)'.
View 1 Replies View RelatedI have the following code to clean up iProperties in idw files.
If ThisDoc.Document.documenttype=12292 Thendoc = ThisDrawing.ModelDocumentiProperties.Value("Project", "Revision Number") = doc.PropertySets.Item(1).Item("Revision Number").ValueiProperties.Value("Project", "Part Number")= ""iProperties.Value("Project", "Description")= ""iProperties.Value("Summary", "Title")=""iProperties.Value("Summary", "Subject")=""iProperties.Value("Summary", "Author")=""iProperties.Value("Project".
[code]....
For some reason, when this code runs, it always trys to execute the doc=ThisDrawing.ModelDocument, regardless of whether or not the IF statement condition is true. I am running Inventor 2012, SP2
I'm trying to write my first VBA program for Inventor with very little programming experience. I would like to create a userform which displays the materials list within a combobox.
The problem I have is that I would like the userform to remain open no matter which type of file is active. I would like the combobox to display the material list and current material when in a Part file and display N/A when in Assembly file.
I created a block, that uses the Y coordinate of the block and returns it's location in a field.
I would like to be able to indicate weather the value is negative or positive. If Y coordinate is less then 0, then the field indicates "-" in front of the value. But if the Y coordinate is positive, I couldn't find a way to place "+"symbol in front.
Is there any way I could introduce a conditional statement saying: if Y>0 then add "+" in front?
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.
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 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 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 RelatedNo 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....
I have linked a table from excel into autocad 2012. I have selected "Start with excel formatting, do not update" in the datalink options. My problem is when I break the table the first table will keep my formatting changes - text height and alignment, but the following table breaks do not stay the same once I close and reopen the drawing
View 1 Replies View RelatedI am trying to insert a table using a data link. I set up the Link through the DataLink manager and then insert the table using a range. I click OK to insert the table and after a few seconds of thinking ACAD sits there with no table on the screen. When I look in XREFs, the DL is there but says it is unrefrenced. Tried multiple ways of entering or setting up information to no avail.
View 6 Replies View RelatedI like the concept of datalinks, it's ingenious working with excel and do what excel does best instead of doing it in acad. I am done with the excel part and want to edit my table in autocad.
My problem is that I have some unused rows and columns that I can't get rid of, erase is greyed out.