Topic: Is it possible to draw TABLE Border with lisp?

[kruuger]

Hello
my question like in subject. is it possible to draw border over some table cells?
for example, we cross window over some cells and outside or inside border are drawn.

thanks,
regards
kruuger

[Lee Mac]

Could you provide an image of what you are looking to achieve?

[Lee Mac]

Out of curiosity I was messing around with the Table methods...

How does one successfully use the GetSubSelection method? 

I either get 'nil' or an error with everything I try...

[kruuger]

Hi Lee
maybe i should asked for table grid not border.

we start on first picture. we "draw" window over table cell.

after that program change grid to outside around two cells.

thanks
kruuger

[T.Willey]

Out of curiosity I was messing around with the Table methods...

How does one successfully use the GetSubSelection method? 

I either get 'nil' or an error with everything I try...

Looks like something has to set the sub selection.  If you set it, then you can get it.  Confused?

Code: [Select]

Command: (vla-setsubselection ob2 0 1 0 1)
nil

Command: (vla-getsubselection ob2 'rmi 'rma 'cmi 'cma)
nil

Command: !rmi
0

Command: !rma
1

Command: !cmi
0

Command: !cma
4

The reason why ' cma ' is 4 is because the top row is a header row, and all the cells are merged.

[Lee Mac]

Looks like something has to set the sub selection.  If you set it, then you can get it.  Confused?

Your example helped a lot Tim -

If you select the cells of a table (as Kruuger describes), then call the GetSubSelection method with output variables as in your example, such variables reflect the user's cell selection:

Code: [Select]

obj = <VLA Table Object>

(vla-getsubselection obj 'r1 'r2 'c1 'c2)

(list (cons r1 r2) (cons c1 c2))

==> ((1 . 2) (1 . 2))

Thanks Tim 

[Lee Mac]

Looking at your diagram Kruuger, I'm thinking a combination of the GetSubSelection method and the SetCellGridColor method. The part that puzzles me is how to pause for the user to make a 'SubSelection'.

[kruuger]

Looking at your diagram Kruuger, I'm thinking a combination of the GetSubSelection method and the SetCellGridColor method. The part that puzzles me is how to pause for the user to make a 'SubSelection'.

i'm not sure if i follow but it should be easier to make subselection when user click over cells. i'm right?
kruuger

[Lee Mac]

Looking at your diagram Kruuger, I'm thinking a combination of the GetSubSelection method and the SetCellGridColor method. The part that puzzles me is how to pause for the user to make a 'SubSelection'.

i'm not sure if i follow but it should be easier to make subselection when user click over cells. i'm right?

But how would the routine pause for such a subselection, or, equally how would the routine be called if the user has made a subselection?

[kruuger]

Looking at your diagram Kruuger, I'm thinking a combination of the GetSubSelection method and the SetCellGridColor method. The part that puzzles me is how to pause for the user to make a 'SubSelection'.

i'm not sure if i follow but it should be easier to make subselection when user click over cells. i'm right?

But how would the routine pause for such a subselection, or, equally how would the routine be called if the user has made a subselection?

back to table border again
finally got subselection the way exactly i want.
now i need to study SetCellGridColor.
i seems to be a lot of work to create a list of "edge cell" and then set correct grid edge 

kruuger

[GDF]

I tried your routine and get the following error:
** Invalid point **

[cmwade77]

Out of curiosity I was messing around with the Table methods...

How does one successfully use the GetSubSelection method? 

I either get 'nil' or an error with everything I try...

I have used vla-selectsubregion successfully, please see the attached LISP routine for an example.

[kruuger]

I tried your routine and get the following error:
** Invalid point **

hmm, tomorrow i will try on 2011 but i don't see any problem on 2012.
table needs to be visible on screen. it is only way to get a table ENAME clicking inside cell (using ssget "_F")
error is when picking first or second corner ?

Out of curiosity I was messing around with the Table methods...

How does one successfully use the GetSubSelection method? 

I either get 'nil' or an error with everything I try...

I have used vla-selectsubregion successfully, please see the attached LISP routine for an example.

but this one only work when doing crossing window over table. sometimes i need to select only one cell.
also there is an error? can't pick any text. only type at command line.
kruuger

[cmwade77]

I can pick text and I will look into what I can come up with, this is something that could be useful here too.

[cmwade77]

Here is my attempt at this. I think it could benefit from some more error handling, but I think this should give the basics of what you are trying to accomplish.

Please note that you can select a single cell, as long as it has content within it. You can also select multiple cells by clicking on any blank area of a cell in the corner.

I think this should give a good start to what you are asking for, I know it will help me with another routine.

Please let me know what you think.