Topic: Slow Table Cell Population

[Rabbit]

I've got a snippet of code that I use to put in a default "0" into cells in a table.  The code works great, but, in larger tables with many rows, it takes for freakin' ever.  Any idea of how to speed it up any?

Code: [Select]

(setq *LE*ClearTAbleRowCount (- (vlax-get-property *LE*TableObject 'Rows) 2))
  (while (> *LE*ClearTAbleRowCount 2)
    (vla-SetCellTextStyle *LE*TableObject *LE*ClearTAbleRowCount *LE*TAbleColumnInsertCount "Hall_Table")
    (vla-SetCellAlignment *LE*TableObject *LE*ClearTAbleRowCount *LE*TAbleColumnInsertCount acMiddleCenter)
    (vla-SetText *LE*TableObject *LE*ClearTAbleRowCount *LE*TAbleColumnInsertCount 0)
    (vla-SetCellTextHeight *LE*TableObject *LE*ClearTAbleRowCount *LE*TAbleColumnInsertCount (/ (getvar "dimscale") 12))
    (setq *LE*ClearTAbleRowCount (1- *LE*ClearTAbleRowCount))
  );while
Sincerely,
Rabbit

[jvillarreal]

Look into vla-put-regeneratetablesuppressed

[Rabbit]

OH WOW!!!  I think I just had an orgasm.

Routine took from going about a minute and a half to about 5 seconds.

I have several routines that will have this in it now.

THANK YOU!!!!!!  It's amazing what's hard to find and yet so simple to implement.

Rabbit

[Lee Mac]

OH WOW!!!  I think I just had an orgasm.

[cough] OOC thread [/cough]

[mjfarrell]

might I suggest that instead of Zeros that input a know bad value?  then you know the data is wrong.

something like ?___?, then everyone knows the information is missing