HyperPics: Beyond the UI

What APIs and Developer Documentation are Available for AutoCAD?

There are a wide range of APIs (Application Programming Interfaces) that are available for creating custom applications in AutoCAD.  Which API is right for you depends greatly on your experience and the time you can commit to learning, but for many the first API that they are ever exposed to is AutoLISP because of its ease of use and the sheer number of programs that are available for download from the Internet.

AutoLISP allows you to channel your knowledge of AutoCAD commands, and begin to combine them in ways that you might have never thought possible or maybe you have and that is what kick started your interest in programming.  Where you go from there is often different for many.  Many simply learn AutoLISP and that is enough for them to improve the tasks that they perform on a daily basis. For others, AutoLISP is simply a stepping stone towards Managed .NET or even ObjectARX.

The available AutoCAD APIs are:

• AutoLISP
• ActiveX/COM
  • AutoCAD
  • Transmittal (eTransmit/Archive)
  • Sheet Set Object (Sheet Set Manager)
  • CAD Standards Plug-in (CAD Standards and Batch Standards Checker)
  • Connectivity Automation Object (dbConnect)
• JavaScript
• ObjectARX
• Managed .NET

The JavaScript API is the newest of all the AutoCAD APIs; it was introduced with AutoCAD 2014.

The documentation for all of the available AutoCAD APIs can be located under the AutoCAD Developer Center. Based on which API you want to work with, you might find that some of the documentation is available through the product's help, installed locally with the product, or available with the ObjectARX SDK.

Sincerely,
  Lee

Working with Raw Input from a User with AutoLISP

AutoLISP is one of the most used programming languages for creating custom AutoCAD applications. Many custom commands that are created with AutoLISP, request input from the user.  Input requests are commongly made with the GetXXX functions.  While these functions are great for getting basic input such as points, numbers, strings, and keywords; they are also limited as well.

The GetInt function while it limits the return value to an integer value, it allows the user to enter any character they want.  Once the user presses Enter or Space, the text entered is then validated to see if it is an integer.  The GetString function allows you to enter a text string, but does not provide a way to mask the characters as they are entered.

This is where the Grread function comes in; an often over looked function by many AutoLISP programmers. This function can be helpful in creating your own custom Get behavior as it works with keyboard, mouse, and digitizer input. For example, you could create functionality that only allows numbers to be entered or masks the text being entered for a password like feature.

Syntax for the Grread function is:

(grread [cursor_tracking] [input_filters [cursor_type]])

For information on the arguments and values that the Grread function supports, see GRREAD (AutoLISP) in the AutoCAD online help.

The following example code, allows the user to enter a numeric value and masks the entered text as it is displayed at the Command prompt. While it does not show all the possible error handling that is needed, it does show how you can prompt the user for input and then determine if the value supplied is what is desired.

(defun c:MyPINCode ( / number code ch)
  (setq number "")
  (prompt "\nEnter a whole number [backspace to clear]: ")
  (setq code (grread))

  (while (and (= 2 (car code))
              (and (/= 13 (cadr code))
                      (/= 32 (cadr code))))
    (if (and (>= (cadr code) 48)
                (<= (cadr code) 57))
      (progn
        (setq ch (chr (cadr code)))
        (setq number (strcat number ch))
        (princ "*")
      )
    )

    ;; Support backspace
    (if (= (cadr code) 8)
      (progn
        (repeat (strlen number)
          (princ (chr 8))
        )
        (setq number "")
      )
    )

    ;; Ask for more input if the user did not press Enter or Space
    (if (or (/= 13 (cadr code))(/= 32 (cadr code)))
      (setq code (grread))
    )
  )

  (prompt (strcat "\nPIN entered was: " number))
 (princ)
)

Once the code is loaded into AutoCAD, you will see the following prompt after the command MyPINCode is executed:

Enter a whole number [Backspace to clear]:

As you type values on the keyboard, only whole numbers 0 - 9 are accepted. Pressing keys such as 'A', 'c', or ';' are ignored by the program. When a valid number is entered, an asterick appears at the Command prompt in its place. Pressing Spacebar or Enter ends input and displays the entered value, while pressing Backspace clears all the numbers that the has user entered.

Example of input and return value at the Command prompt:

Enter a whole number [Backspace to clear]: *****
PIN entered was: 63537

Sincerely,
   Lee

CAD Management Documentation

CAD management does not mean the same to everyone, and the role it plays is different from company to company.  The same can be said about the CAD Manager title.  I personally, never held the title but performed many CAD management related tasks over the years.  Where I worked, the CAD Manager was the individual that managed the CAD drafters, but never actually customized, programmed, or installed software.  IT performed the installs and the senior drafters in each CAD department kind of did their own thing when it came to CAD standards.

Sound a bit familiar maybe? Maybe it doesn't.

After many years, two things always stood out around CAD management for me:

• What is CAD management and what things do I need to consider?
• How do I make the transition from my current release to the latest release as smooth as possible?

To help answer both questions, a set of documentation was created.  This documentation was added to the AutoCAD 2014 release and it covers:

• Basics of CAD management
• Customization and program compatibility
• What is new or changed in the product
• Where to find information on installing the product
• Much more...

The CAD Management documentation can be accessed from the AutoCAD 2014 help landing page.

If you have any comments on or additions you would like to see added to the CAD Management documentation, please post a comment on this posting.  Comments are not posted automatically on this blog.

Sincerely,
  Lee

AutoCAD 2014 API and Developer Documentation Changes

By now, there has been lots of information circulating about what is new in AutoCAD 2014 from an end user perspective but what about the API side of things. AutoCAD 2014 offers a number of API changes, updates to the documentation, and a new API.

First and foremost, AutoCAD 2014 is binary compatible with AutoCAD 2013; programs developed for AutoCAD 2013 should run in AutoCAD 2014 without needing to be recompiled.

JavaScript API

This new API is used to provide the core functionality of the DesignFeed and Live Maps features. What can be done with this new API at the moment is limited, but does open up many new possibilities though. For additional information see:

• JavaScript Reference Guide
• Zooming to an AutoCAD entity using JavaScript - Through the Interface (Kean Walmsley)
• Getting Started with JavaScript API on AutoCAD 2014 - AutoCAD DevBlog (Philippe Leefsma)
• Enabling AutoCAD 2014 JavaScript Debugging - AutoCAD DevBlog (Fenton Webb)

Trusted File Paths

Not just an API change but a security change to which files are automatically loaded and from where they can be loaded from. This change impacts all program file types. There are a few API level changes that you should be aware of, but if your programs are not trusted they do not matter much. So the first things you need to be aware of are the SECURELOAD system variable and the Trusted Locations node on the Files tab of the Options dialog box. For additional information see:

• AutoCAD 2014 and Security - AutoCAD DevBlog (Gopinath Taget)
• AutoCAD 2014 for developers - Through the Interface (Kean Walmsley)

VBA 7.1

Microsoft has recently given new life to the once deprecated VBA technology. VBA 6.3 was the last supported release, which was still being used in AutoCAD 2013 as long as you downloaded the separate installer. VBA 6.3 was 32-bit only and is why there was performance issues when using it with AutoCAD 64-bit. VBA 7.1 resolves this issue by supporting both 32-bit and 64-bit platforms. If you have VBA programs from AutoCAD 2013 or earlier, and you are using Windows 64-bit you might encounter issues if you are using third-party libraries or form controls that do not support 64-bit.  Check with the third-party vendor and see if they offer a 64-bit version for you to use, if not you will need to rework your code and/or forms.

The ActiveX/VBA document has also been updated as well and can be found installed on your local drive at:

• %ProgramFiles%\Common Files\Autodesk Shared\acad_aag.chm - Developer's Guide
• %ProgramFiles%\Common Files\Autodesk Shared\acadauto.chm - Reference Guide

AutoLISP

There were no real notable changes to the API this release or the Visual LISP IDE, with the exception of two new functions.

• showHTMLModalWindow - Displays a modal window with a HTML document; use in conjunction with the new JavaScript API.
• findtrustedfile - Searches the AutoCAD trusted file paths for the specified file.

ObjectARX

Changes to the ObjectARX API are limited to new classes and functions.

• AcDb
  • AcDbExtents2d - New class
  • AcDbGeoDataReactor - New class
  • AcDbModelDocViewStyle - New methods added; existing class
  • AcDbXrecord - New method added; existing class
  • AcDbXrecordIterator - New methods added; existing class
• AcAp
  • AcApDocument - New method added; existing class
• Global functions
  • acedAddHTMLPalette - New
  • acedFindTrustedFile - New
  • acedLoadJSScript - New
  • acedShowHTMLModalWindow - New
  • acedShowHTMLModelessWindow - New
• Miscellaneous class
  • IPointCloudFilter2 - New

Managed .NET

Changes to the Managed .NET API are limited to new classes and functions.

• Autodesk.AutoCAD.ApplicationServices
  • Application.ShowModalWindow Method
  • Application.ShowModelessWindow Method
  • Document.IsNamedDrawing Property
• Autodesk.AutoCAD.DatabaseServices
  • MLeader.Scale Property
  • Region.AreaProperties Method
  • RegionAreaProperties Structure 
  • RegionAreaProperties.Area Property
  • RegionAreaProperties.Centroid Property
  • RegionAreaProperties.Extents Property
  • RegionAreaProperties.MomentsOfInertia Property
  • RegionAreaProperties.Perimeter Property
  • RegionAreaProperties.PrincipalMoments Property
  • RegionAreaProperties.ProductOfInertia Property
  • RegionAreaProperties.RadiiOfGyration Property
  • Xrecord.Append Method
  • XrecordEnumerator.Current Property
  • XrecordEnumerator.InsertAtCurrent Method
  • XrecordEnumerator.RemoveCurrent Method
• Autodesk.AutoCAD.EditorInput
  • Editor.ApplyCurDwgLayerTableChanges Method
  • Editor.PostCommandPrompt Method
• Autodesk.AutoCAD.GraphicsInterface
  • TextStyle.FromTextStyleTableRecord Method
  • TextStyle.ToTextStyleTableRecord Method
• Autodesk.AutoCAD.Windows
  • Window.Focus Method
• Autodesk.AutoCAD.ApplicationServices.Core
  • Application.LoadJSScript Method

The Developer's Guide was updated in the following areas were changed:

• Viewports and layouts
• Plotting and publishing
• Document events
• Disposal of objects
• Plot styles
• Visual styles and render presets
• Raster images and xrefs
• Clipping blocks, xrefs, and raster images
• Defining and inserting blocks, and working with attributes

The .NET Developer's Guide is part of the product help.

Hope this helps give you an understanding of the changes that you might or might not need to make with your custom programs.

Sincerely,
  Lee

AutoCAD Developer Documentation Survey

Do you create AutoLISP, VBA, .NET, or ObjectARX applications to automate tasks for your company or to solve problems for a client?  If so, chances are you might have used the AutoCAD developer documentation. The Learning Experience team would like some input on the developer documentation via the AutoCAD Developer Documentation Survey. The survey will take 5-10 minutes of your time.

Here is the link to the survey -
https://www.surveymonkey.com/s/H72RWJC

Sincerely,
  Lee

My Time with Microsoft's Surface RT

I purchased a Microsoft Surface RT back on Day One, pre-ordered actually before the Oct. 26th release, and have enjoyed it ever since. For the most part, my Surface RT has replaced my iPad except for one app and that is for the use of RSA SecurID which I can now access from my Windows Phone. Things I have done with the Surface RT can be done with an iPad, but in many cases tasks that require lots of typing are much easier on the Surface with the use of the touch cover.

My iPad 3 64GB version cost $699 without a cover and no external keyboard or stand. If you want a keyboard, you can buy covers that have a keyboard in them starting at aboput $89 which typically do not have a trackpad area. No MicroSD card support.

My Surface RT 64GB version cost $699 with a touch cover that has a trackpad area and has a built in stand. The Surface RT 64GB without a cover is $599. Support for MicroSD cards up to 64GB.

With my Surface RT, I have

• Started writing a book that is being authored in MS Word
• Played a number of Xbox Live games (Taptiles and Where's My Water can be addicting at times)
• Listened to my music collection as well as free streaming of music via Xbox Music for hours
• Watched hours of TV shows and movies from the Netflix and Hulu Plus apps while on my treadmill
• Experienced full Flash websites such as Webkinz just to see how well those sites worked

When it was first announced and even to this day, many have balked at the Surface RT as simply another device and did not take the time to understand exactly what Microsoft was attempting to do. Out of the gate, it did not have the apps that devices running Android or iOS had so many gave it little to no chance at all but those devices did not have stellar libraries of apps near the start of their life either. Anyways, Microsoft was not just releasing another device, but a device that was part of an ecosystem that they were beginning to lay the ground work for.

In my honest opinion, Microsoft has failed to explain what the difference is between their Surface products and the versions of Windows to their customers. They have not tried enough to show how they align against Apple's product family, nor what their devices can do. Singing and dancing is eye catching, but it does not focus on the things people need to use a computer or mobile device for. Here is how I see things as they align with Apple's products:

Apple's product compared to Microsoft's product

• iPad (runs iOS) = Surface RT (runs Windows 8 RT)
• AirBook (runs Mac OS X) = Surface Pro (runs Windows 8 Professional) 

Microsoft Windows RT is similar to Apple iOS, which both are designed for mobile devices. The devices that run these operating systems are often used to read books, compose emails, take notes while in a meeting, watch videos, listen to music, and play games. A mobile device commonly does not replace the functionality of a desktop or laptop because of their processing limitations and lack of business software, one can of course argue this fact with cloud computing but not everyone can stay connected 24/7 yet.

Many in the industry have unfairly compared the Surface RT to what it is not, and that is a laptop such as an AirBook or MacBook. Windows RT runs a mobile OS, in which the AirBook and MacBooks run a desktop OS. To be fair, you have to really compare the Surface RT to an iPad which cannot run applications designed for a desktop OS, thereby you cannot run legacy applications such as Adobe Photoshop or AutoCAD on your iPad. Sure there are apps on the iPad that give you some of the functionality of legacy applications such as AutoCAD WS, Pages, Adobe Photoshop Express, but you cannot simply pull out your install DVDs and install the software you might have invested hundreds or thousands of dollars in.

At the end of the day, consumers are confused as to what Microsoft is trying to do by offer two different Windows platforms and what advantage each offers over the other. This was evident by a trip last week to my local Best Buy when I was on the search for a Windows Surface Pro with 128GB of RAM. Employees almost seemed overwhelmed by the number of people interested in the devices and not really sure how to explain things to the customer.

Here are points of interest based on my experience with the Surface RT:

• Battery life is around 8 hours or more based on what you are doing.
• If you are primarily using it as a tablet, you will not need the type or touch cover but they are excellent accessories if you plan to use the MS Office applications though.
• Comes with an installed version of MS Office that is designed for Windows RT which contains Word, Excel, PowerPoint, and OneNote. This version does support most of the functionality that you will find in the full MS Office suite with the exception of Outlook, Access, and creating VBA macros.
• Does have a Desktop mode so you can manage your files just like in Windows 8.
• Does not support DRM for videos because it does not have Windows Media Player, which I feel is a mistake on Microsoft's part. However, I can display play my MP4 video files without any problem.
• Offers a USB port which you can use to plug-in an external DVD player or hard drive/thumb drive to transfer data files, plu in a full size keyboard or mouse, or even an Xbox controller for games that support it, and other USB devices.
• MicroSD card slot allows you to expand the amount of storage available.
• Utilizes your Windows single login, so your settings move from desktop to Surface and so on.
• SkyDrive is an integral part of the Surface experience as it is installed by default and helps you extend the available drive space.
• Snapped states do make it possible to have two applications open at a time.
• 16x9 screen is nice for watching your videos, Netflix, and Hulu Plus.
• Does support video out using a dedicated port, you can buy a HDMI or VGA connector for your Surface. I have used both and they seem to work just fine based on the limited video resolution options that are available. Netflix on my 42" HDTV from the Surface seemed to worked well for what I think was non-HD source to begin with. I have also used the VGA with my 27" computer monitor and had no problems.
• While the size is a plus for watching videos and playing games, it does take a bit of getting used to though for reading eBooks. Holding the device in portrait mode seems a bit awkward because of its size, but horizontal works just fine. The Kindle app does allow you to compress the margins so you are not reading across the whole screen which is very nice.
• Browsing the Internet can be done via Internet Explorer from the Start Screen which seems to have some compatibility issues with older websites, but the desktop Internet Explorer seems to have much better support for older sites and sites that require Adobe Flash. So unlike iOS, Windows RT can display Flash content which is a huge plus for sites that still rely on that technology.
• Wireless printing is supported, my HP Printer that was connected to the WiFi was found and installed will little to no effort at all.
• Connects to your Xbox via the Surface application so you can navigate your Xbox dashboard and play media.

As I have used the device and others saw it in action, I began to form an opinion as to who might be the best user for a Surface RT. Here is what I came up with:

• High school and college students that need to access the Internet and write term papers, but also want something smaller and have a longer battery life than a laptop.
• Users who already have a desktop or laptop, and want something smaller when traveling or commuting from home to the office. It is also great as a secondary machine for the family since the IE browser is compatible with sites that have Flash unlike an iPad, and it offers most of the functionality in MS Office that many will use.
• Gamers that want to increase their Gamerscore on the go can play Xbox Live games from the Windows Store and enhance their experience with the Surface integration with their Xbox.

The Surface RT is not ideal for those that

• Are looking to replace their current desktop or laptop.
• Need to run legacy applications such as AutoCAD or Adobe Photoshop.

In the end, you need to choose what device is best for you and your family's needs. If you are in the market for a new and fresh experience, be sure to check out the Microsoft Surface. Very early on, it was available only through Microsoft's online and retail stores. This was an excellent way to bring it to the market, but not to the masses. Recently, Microsoft has partnered up with Best Buy and Staples to get the products in the hands of more potential buyers.

I hope this article was of interest to you.

Sincerely,
  Lee 

Tis Be the Season of Gadgets - Microsoft

You can always tell when Fall in the US has arrived; the leaves begin to fall, the smell of pumpkin pie fills the air, and the beeps and flashing of new gadgets come to life in the stores. This year is no different with huge releases by Microsoft, Apple, Amazon, Barnes & Nobles, Nokia, Nintendo, and a number of other manufacturers.  In years past, the holiday season never seemed to be so packed full of gadgets trying to fight for your attention and more importantly your dollars.

Microsoft has been very busy this Fall with releasing a number of different products: from software to new hardware.  While Microsoft is typically known for their software, they have been slowly investing in a complete ecosystem that stretches from the office to the home; prodictivity and entertainment.  You most likely utilize Windows and Office at the work and even at home, but that is not where the stretch of Microsoft ends.

Over the years, Microsoft has been working on expanding its ecosystem to go beyond just productivity and that means focusing on entertainment. While it has not always spelled success for Microsoft, it has laid the foundation for improvements to Windows and even the introduction of the Xbox over 10 years ago.

This Fall, Microsoft has rolled out a number of services and new products that expand its portfolio.  While all might not be an instant or as successful as those on the market before, they provide a foundation for what is possible in the future.

• Windows 8 - Introduces a single platform that allows developers to create cross-platform applications and be able to exchange information seamlessly between devices. Windows 8 runs on desktops utilizing Intel and AMD 32- and 64-bit processors, phones and tablets running 32-bit ARM processors. (http://windows.microsoft.com/en-US/windows/home)
• Microsoft Surface - The first interation of the hardware is designed for Windows RT, which is based on Windows 8 but for ARM processors. The target audience for this device, is those that want a mix of productivity and entertainment, and do not need to worry about running "legacy" software that was designed for x86/x64 processors. Similar to an Apple iPad or Samsung Galaxy, the Surface utilizes a marketplace to purchase and download Windows Store apps. Unlike the iPad and Galaxy though, the same apps can be ran on a laptop or desktop running Windows 8. (http://windows.microsoft.com/en-US/windows/microsoft-surface)
• Xbox Music - An application/service that works across the entire Microsoft ecosystem. Buy misic from one device, lets say a desktop and then access it from your Xbox or Surface. The service also allows you to stream music as well in a similar fashion to Spotify. Xbox Music is a standard feature of Windows 8. (http://www.xbox.com/en-US/entertainment/music)
• MS Office 2013 - Next version of MS Office and is currently available as a preview. As some might not know, Surface comes with a version of MS Office 2013 that includes Word, Excel, PowerPoint and OneNote. While not a complete version of Office on Surface, it provides most of the creation and editing tools taht you are already familiar with in MS Office 2010. (http://www.microsoft.com/office/preview/en/)
• Visual Studio 2012 - Latest version of Visual Studio that allows you to develop applications that take advantage of .NET Framework 4.5 and create applications for Windows Phone 8 and Windows Store apps. (http://www.microsoft.com/visualstudio/eng/)
• Skype - An improved service along with applications that are on virtually every device on the market; from smart/Internet-enabled TVs to phones and computers. (http://www.skype.com/intl/en-us/home)

As I get time, I will share more detailed thoughts and comments on some of the products and services that Microsoft has recently released. From what I can tell, Microsoft is focused on creating a connected and complete ecosystem across all its software and hardware platforms. This unifiied platform and all encompassing ecosystem is for the most part a one of a kind, and will be interesting to see if it is what people are looking for or if it is simply ahead of its time.

Let me know what your thoughts are on Microsoft's direction.  It is a bit early to tell since new OSs and ecosystems take time to unfold at times especially when people might want to participate in the ecosystem but cannot because of phone contracts, fear that it will not run on their current hardware, or simply disruptions in daily habits and workflow.

Sincerely,
  Lee 

Updated AutoCAD 2013 ActiveX Developer Documentation

A new update to the AutoCAD 2013 ActiveX Developer Documentation has recently been made available through the AutoCAD Developer Center. The updated documentation set can be found at the bottom of the page under the Documentation section.

The updates that were made to the documentation are:

• Corrections to the existing VBA samples
• VBA samples ported to show the use of AutoLISP/Visual LISP
• Reference documentation updated to include all the latest and previously missing classes/properties/methods
• Full list of changes to the API from AutoCAD 2000 through AutoCAD 2013
• Corrections to and the inclusion of the ActiveX Developer's Guide

To utilize the documentation with the VBA IDE or Visual LISP IDE, download and extract the contents of the ZIP file to the following location:

C:\Program Files\Common Files\Autodesk Shared

Sincerely,
  Lee

Hooking Up Custom Help for Your Commands

Help is commonly one of the last things that many new developers think about or never think about, but it should be one of the first things you work on as it is your first line of support for your custom utilities.  AutoCAD provides ways for you to call a help topic or file, and hook up F1 support for your custom commands that you define with AutoLISP, .NET, or ObjectARX.

In this article, I focus on calling help and hooking up F1 support for commands defined using AutoLISP.  To accomplish these tasks, you use the HELP and SETFUNHELP functions.

Both the HELP and SETFUNHELP functions support the use of HyperText Markup Language (HTM/HTML), Microsoft Help (CHM), and WinHelp (HLP) files.  When you make a call to a HTM/HTML file, the file is loaded into the AutoCAD Help browser.  CHM and HLP files are displayed in their respective application windows.

The syntax for the HELP function is:

(help [help_file [chm_hlp_topic [chm_help_window_command]]])

The following examples demonstrate how to directly call help from AutoCAD:

;; Displays the topic for the LINE command from the default AutoCAD help
(help "" "LINE")

;; Displays a Web page
(help "http://www.hyperpics.com/")

;; Displays a local HTML file
(help "C:\\Program Files\\Autodesk\\AutoCAD 2013 Help\\English\\Help\\index.html")

;; Displays a CHM file
(help "acet.chm" "html/BLOCKREPLACE")

Now that you have seen how to call help with the HELP function, the SETFUNHELP function is very similar with the exception of needing to provide the name of the function.  The function name must include the 'c:' (command) prefix.

The syntax for the SETFUNHELP function is:

(setfunhelp c:function_name [help_file [chm_hlp_topic [chm_help_window_command]]])

The following examples demonstrate how to set up contextual/F1 help for custom commands:

;; Displays the topic for the LINE command from the default AutoCAD help
(defun c:CMD1 () (getstring "\nEnter some text: "))
(setfunhelp "c:CMD1" "" "LINE")

;; Displays a Web page
(defun c:CMD2 () (getstring "\nEnter some text: "))
(setfunhelp "c:CMD2" "http://www.hyperpics.com/")

;; Displays a local HTML file
(defun c:CMD3 () (getstring "\nEnter some text: "))
(setfunhelp "c:CMD3" "C:\\Program Files\\Autodesk\\AutoCAD 2013 Help\\English\\Help\\index.html")

;; Displays a CHM file
(defun c:CMD4 () (getstring "\nEnter some text: "))
(setfunhelp "c:CMD4" "acet.chm" "html/BLOCKREPLACE")

Once the command is defined and the Help topic is associated with the command, you can display the topic by pressing F1 under the following situations:

• When AutoComplete is enabled and the full name of the command is displayed, but the command is not started yet.
• When the command is active.

For more information on these two functions, see the following:

• help (AutoLISP)
• setfunhelp (AutoLISP)

Sincerely,
  Lee

Create a Table and Select a Cell to Change with AutoLISP and ActiveX

Tables are one of the most complex objects, after dimensions, to create and edit through the APIs that AutoCAD offers.  The appearance of a table is controlled by its properties and methods, along with the table style that it is assigned.  Tables are made up of individual cells which can contain text, blocks, and formulas along with additional formatting.

In the previous posting, Creating a Table Style with AutoLISP and the ActiveX API, I showed an exmple of how to create a custom table style.

In this article, I show for to create a table and then edit the value of a cell by picking a point within a table cell.

(vl-load-com)

;; Example adds a table to model space that is 5 rows by 3 columns
;; with a row height of 10 units and column width of 30 units
(defun c:AddTable( / acadObj curDoc insPt mSpaceObj tableObj)
    (setq acadObj (vlax-get-acad-object))
    (setq curDoc (vla-get-ActiveDocument acadObj))

    (setq insPt (vlax-3d-point 0 0 0))

    (setq mSpaceObj (vla-get-ModelSpace curDoc))
    (setq tableObj (vla-Addtable mSpaceObj insPt 5 3 10 30))

    (vla-put-StyleName tableObj "MyTableStyle")
)

;; Example shows how to pick a single table cell on screen and change its value.
;; This example demonstrates the ActiveX properties/methods HitTest,
;; GetCellType, GetText and SetText.
(defun c:SelectTableCell ( / pick vHeight vWidth lwrLeft uprRight vector
                                           SS_TABLES cnt eMax tableObj row col cellValueOrg)
 
  ;; Ask the user for a point on screen
  (if (/= (setq pick (vlax-3d-point (getpoint "\nSelect Cell to edit: "))) nil)
    (progn

      ;; Get the corners of the screen display to build our selection set
      (setq vHeight (getvar "viewsize"))
      (setq vWidth (* (/ (nth 0 (getvar "screensize")) (nth 1 (getvar "screensize"))) vHeight))

      (setq lwrLeft (list (- (nth 0 (getvar "viewctr")) (/ vWidth 2)) (- (nth 1 (getvar "viewctr")) (/ vHeight  2)) 0))
      (setq uprRight (list (+ (nth 0 (getvar "viewctr")) (/ vWidth 2)) (+ (nth 1 (getvar "viewctr")) (/ vHeight  2)) 0))

      ;; Get the current display orientation
      (setq vector (vlax-make-safearray vlax-vbDouble '(0 . 2)))
      (vlax-safearray-fill vector '(1 1 1))
      (setq vector (vlax-make-variant vector))
     
      ;; Select all the table objects visible on screen
      (if (setq SS_TABLES (ssget "C" lwrleft uprright (list (cons 0 "ACAD_TABLE"))))
        (progn
  
          (setq cnt 0
                eMax (sslength SS_TABLES)
          )

          ;; Step through all the items in the selection set
          (while (> eMax cnt)
            ;; Geta table object from the selection set
            (setq tableObj (vlax-ename->vla-object (ssname SS_TABLES cnt)))
 
            ;; Return values for what cell was picked in
            (setq row 0
                  col 0)

            ;; Below is also a sample to see if a valid cell is picked
            ;; (vla-select table pick vector vector 5 5 :vlax-false 'row 'col)
    
            ;; Check to see if a valid cell was picked
            (if (= (vla-hittest tableObj pick vector 'row 'col) :vlax-true)
              (progn

                ;; Get out of the loop
                (setq cnt (1+ eMax))
  
                ;; Check to see what the Cell Type is (Text or Block)
                (if (= (vla-GetCellType tableObj row col) acTextCell)
                  (progn
                    ;; Let's get the value out
                    (setq cellValueOrg (vla-GetText tableObj row col))

                    ;; Change the current value
                    (vla-SetText tableObj row col "Revised Text")
                    (vla-Update tableObj)
                    (alert "Cell text was changed.")
         
                    ;; Restore the original value
                    (vla-SetText tableObj row col cellValueOrg)
                    (vla-Update tableObj)
                    (alert "Cell text was changed back to the original value.")
                    (setq cnt eMax)
                  )
                )
              )
            )
            (setq cnt (1+ cnt))
          )
        )
      )
    )
  )
 (princ)
)

Sincerely,
  Lee