LAVA Forums Buy cool LAVA gear Forums RSS Feed

Welcome Guest ( Log In | Register )

> Related links

Check out our User Interface Code Repository Files or visit the LabVIEW Wiki User Interface Portal


Tags
(This content has not been tagged yet)
 
Reply to this topic Start new topic
> Table cell Coloring, Table Formatting
Rick M
post Jul 1 2004, 11:55 AM
Post #1


One hit wonder!


Member
Posts: 1
Joined: 1-July 04
From: Upstate NY
Member No.: 495
LV:7.1.1
United States Ireland Nothing Selected


wire wizards;
I need to figure out how to apply conditional formatting to a table of measurement
results. In Excel,(am I allow to swear like that in here ;->) conditional formatting
can be applied to table columns or rows such that if the contents of a particular
cell is greater than a value, I can apply one condition (i.e. color the cell GREEN
to indicate a 'PASS' condition), and if the contents of that cell are less than the
same value, I can apply a different condition (i.e. color the same cell RED).

This allows in a quick glance through *alot* of values to find any failing data.

Is this something easily accomplished in LV? (BTW Win2K, LV7.0 PDS)
Thanks in advance
Rick


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
Ad
post Jul 1 2004, 11:55 AM
Post #















Tags
(This content has not been tagged yet)
Go to the top of the page
Quote Post
David Boyd
post Jul 1 2004, 03:45 PM
Post #2


Very Active
***

Premium Member
Posts: 148
Joined: 13-November 03
From: Kennesaw, GA USA
Member No.: 195
Using LabVIEW Since:1997
LV:8.5 ,8.2.1 ,.
United States us_georgia us_pennsylvania


Rick,

Tables in LabVIEW are always an array of strings. There's no 'conditional formatting' as such, but the attached VI gives a trivial example of using property nodes on the table to recolor the cells at runtime.

Hope This Helps.

Dave
Attached File(s)
Attached File  Color_code_table_cells_example.vi ( 35.3K ) Number of downloads: 244
 

--------------------
David Boyd
Sr. Test Engineer
Respironics


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
lucas_dili
post Aug 17 2004, 12:39 PM
Post #3


One hit wonder!


Member
Posts: 1
Joined: 17-August 04
Member No.: 601
LV:7.1


Dave:
Do you know if there is a way to hide the column and rows separation in a table???
thank you
Lucas


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
nightdweller
post Aug 17 2004, 06:12 PM
Post #4


Very Active
***

Member
Posts: 61
Joined: 30-March 04
From: California
Member No.: 333
LV:7.1
United States


QUOTE (lucas_dili @ Aug 17 2004, 07:39 AM)
Dave:
Do you know if there is a way to hide the column and rows separation in a table???
thank you
Lucas
*


Lucas,

By blending your table, and seperator with the same color( ie white) you can hide the seperator.

Vince

--------------------
Best Regards,
Vince


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
David Boyd
post Aug 23 2004, 04:41 PM
Post #5


Very Active
***

Premium Member
Posts: 148
Joined: 13-November 03
From: Kennesaw, GA USA
Member No.: 195
Using LabVIEW Since:1997
LV:8.5 ,8.2.1 ,.
United States us_georgia us_pennsylvania


QUOTE (lucas_dili @ Aug 17 2004, 07:39 AM)
Dave:
Do you know if there is a way to hide the column and rows separation in a table???
thank you
Lucas
*

Lucas,

If I understand what you want, I don't think it's quite possible. The 'grid' of lines can be repainted any color you like (through the control editor), but if you've set background colors of cells (using the example I gave you), there will always be a perceptible line between adjacent cells painted different colors. If you change the FOREground colors of cells (meaning the text), and leave all the BACKgrounds the same, and paint the grid the same color as the background, then the grid lines will 'appear to disappear'.

Did that make sense to anyone but me?? blink.gif

Dave

--------------------
David Boyd
Sr. Test Engineer
Respironics


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
Jack Kelledes
post Sep 22 2004, 06:11 PM
Post #6


More Active
**

Member
Posts: 25
Joined: 25-June 04
From: Pawcatuck, CT
Member No.: 483
Using LabVIEW Since:2002
LV:7.1.1 ,6.1 ,.
United States Nothing Selected Nothing Selected


I'm fairly new at creating nice interfaces so forgive me if this is too elementary.
I was just trying something like this in LabVIEW 6.1 in a table.
The Active Cell cluster in the Property Node uses a cluster that is the Row number and Column number.
Make a property node that has Active Cell and Cell Background Color in it.
Once you know the row of the data that is out of range put that number in for the row and -2 in for the column in the Active Cell cluster and put the new color in the Cell Background Color (I use color box constants because they're easier for me).
To color a column instead of a row, reverse the numbers.
To color a whole table, use -2 in both numbers.

This post has been edited by Jack Kelledes: Sep 22 2004, 06:11 PM


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post
Mike Ashe
post Dec 30 2004, 06:39 PM
Post #7


Instant Human, just add coffee
****

Premium Member
Posts: 889
Joined: 31-January 03
From: Waterford, CT USA
Member No.: 45
Using LabVIEW Since:1992
LV:8.2.1 ,7.1 ,8.0.1
United States us_connecticut us_washington


Hmm, I should have scrolled down to the bottom of this topic before I coded up this example oops.gif .

Oh well, here is a simple example of using -2 to color alternating rows. Any more is an exercise left to the student... book.gif

Cheers beer_mug.gif
Attached File(s)
Attached File  ColorTable_by_Row_Example_LV70.vi ( 27.27K ) Number of downloads: 182
 

--------------------
*************************************************************
"Always listen to the experts, they'll tell you what can't be done, and why.
Then go do it."
~The Notebooks of Lazarus Long (by Robert Heinlein)
*************************************************************


Tags
(This content has not been tagged yet)
Go to the top of the page
+Quote Post

Reply to this topicStart new topic

 




Time is now: 8th January 2009 - 08:08 PM