Leaderboard

The best way is still to open Excel, then Import data. Because ... Excel has the horrible habit to assume cell format. Half of the Entity handles (assuming you export them) are turned into numbers, "14E6" is seen as 14 million; some are turned into dates, ... Get Data from file has the best chance of this problem not occuring

Overlapping text has been a problem for years, you realign them then they overlap another text that you have Un-overlapped. Any way if you take the text and say make into Mtext with color then it will be stacked automatically, this would be easiest. So confirm that is Ok. Other version would be just to stack the text based on the text height. The only problem is if the text is annotative then it may move depending on Anno scale. So choice is yours but need a sample dwg, looks like the text is in different layers so need that result order, a before and after sample.

Use to check properties of entity's in AutoCAD. ;;----------------------------------------------------------------------------;; ;; Dump All Visual Lisp Methods and Properties for Selected Entity (defun C:VDumpIt (/ ent) (while (setq ent (car (entsel "\nSelect Entity to Dump"))) (vlax-Dump-Object (vlax-Ename->Vla-Object ent) t) ) (princ) ) Most are simple to change as (val-put-"property name" vla-object value) Properties values listed with a (RO) are read only.

I think it's code 67 @marko_ribar This should get all hidden items .. also paperspace viewports too. (ssget "_X" '((67 . 1)))

Select All with : (setq ss (ssget "_X")) Iterate through sel.set... - if object is hidden it has (60 . 1) in (entget) DXF code list - if object is visible (not hidden) it don't have (assoc 60 (entget ent)), or it has (60 . 0) Regards, M.R.

Lol, why do you make it look so easy? And you figured out in a short time... Thanks again Lee

(defun 3dpolar ( bpt ang dis nor ) (trans (polar (trans bpt 0 nor) ang dis) nor 0) )