highlight table cell speed

[brian005]

hi all

i'd like to highlight some cells in a table using method

"Active Cell:Cell Background Color Property", but it takes about 12 seconds to highlight 1000*2 cells(1000 lines, 2 column). it is not acceptable.

any idea to improve it? thanks.

testing vi attached.

[JÞB]

I don't think you can use background color on multiple active cells without changing every cell (buggy behavior)  In fact try changinging the second property node to ActiveCell.BackgroundColor and prepare for a surprise

You can highlight 1000 rows by 2 columns running the VI as is but, you change the border color of the selected cells.  This might be enough to set off these cells from the rest for your purposes

[altenbach]

you need to disable front panel updates.

[brian005]

disable panel update does't help, i tried this before.

[brian005]

hi jeff Bohrer

thank you for your reply.

"In fact try changinging the second property node to ActiveCell.BackgroundColor and prepare for a surprise", what do you mean?

and the selection function which table control provides, in terms of function, it is ok, but seems strange. i'd like to implement the effect like excel, change 

background color to indicate the selection.

any idea? 

[JÞB]

---

@brian005 wrote:

hi jeff Bohrer

thank you for your reply.

"In fact try changinging the second property node to ActiveCell.BackgroundColor and prepare for a surprise", what do you mean?

---

Did you try? 

---

i'd like to implement the effect like excel,

---

Me Too,  looks buggy to me

[brian005]

hi Jeff Bohrer

sorry, i tried changing the second property node to ActiveCell.BackgroundColor in my code, and also change the node to ActiveCell.BackgroundColor in your code, but i cannot figure out what is the surprise.

i am using labview 8.2

may be you can attached your code? thanks.

[Priyadarsini]

Hi Brian,

I am assuming that you are specifying the row# as -1 to select the entire row. If the no. of cells to be highlighted is much greater than the non-highlighted cells in a column, it is better to highlight the entire column using -1 row# and remove the highlight for the required cells.

Thanks,

Priyadarsini S

[brian005]

hi Priyadarsini

thanks for reply

you mean highlight all first, then remove those not required cells?

but this is a table control with horizontal and vertical scrollbar, seems like the no of cells to be highlighted is always less than the non-highlighted cells, since you can scroll down forever.

[Priyadarsini]

"you mean highlight all first, then remove those not required cells?"   Yes, that's what I meant.

Also for your other point, you can always restrict the scrolling within some limits - either with the same scrollbar or with the custom scrollbar(under numeric palette).

Thanks,

Priyadarsini S