More Table Woes

[john.uhden]

I created a base table with a few data rows and wblocked it out to its own dwg file.

When required by my "OpenChannelFlow.lsp" routine, it inserts it expoded to get just the table.

When I add another row to take another depth and resulting hydraulic data, and then set the cell values, the new row is created but the cells do not get populated.  I even added vla-updates after each row addition and each row population.

Must the table have sufficient rows before filling it with data?  Or is there some other prerequisite?

I mean that I could create the base table with plenty of rows and then remove the rows not used, if that would solve my problem.

[john.uhden]

@komondormrex ,

I'll have to look into that approach,  but for the time being the centered cells look fine.

After all, it's just accounting data for the consulting review engineer to bill his time to.

[Sea-Haven]

Hi John post code or email it to me, look at my post about insert rows, have made like 200 in one go. Are you turning suppress on/off maybe so makes a row but suppresses setcell.

[john.uhden]

@Sea-Haven ,

I am unaware of that suppression gizmo.

if you turn on the suppression before you add any cells, does that speed up populating them later?  But maybe that makes no difference to me since I have switched gears to having a base table with lotsa rows that I can delete excess ones near the end.

[Sea-Haven · Accepted solution]

Making and filling in 200 rows can be slow like minutes, inserting rows 200+ and filling cells as it goes is a few seconds using surpress regen, then after done just turn back on.

Again table has only the required number of rows no need to delete empty ones.

Send me your code you have my email.

[john.uhden]

@Sea-Haven ,

You release a little more each time.  You must be a good angler because you're keeping me on the hook.

Anyway, if I've decided to delete any excess rows at the end (cause it's very quick), is there any point in whatever this suppression thing is?

Or, maybe rather than populating each row as each is calculated, should I store the data in a list and then shotgun it into the cells?

[komondormrex · Accepted solution]

John,

what the heck? are you that lazy to find out what that gizmo is about.

you need to put that right before a populating of rows or whatever starts.

(vla-put-regeneratetablesuppressed table_object :vlax-true)

 and that right after all table manipulations are done.

(vla-put-regeneratetablesuppressed table_object :vlax-false)

  it will times speed up everything.

[john.uhden]

@komondormrex ,

Ya know, I think I have become lazy at certains times (not allowed).  I'll try it some time today.

Many thanks.

[john.uhden]

@Sea-Haven & @komondormrex ,

Holy smokes!!  Warp speed.  Extreme thanks!

[Sea-Haven]

"should I store the data in a list and then shotgun it into the cells?" Thats what I do but using "INSERTROWS". 

This was instant counted and sorted 2980 items table made.