Grids

BLarry1T · Post by **BLarry1T** » Tue Aug 16, 2011 11:37 am

I seem to recall a demo at one of the conferences where a grid was displayed similar to green bar paper.

Does anyone recall which conference?

Gabriel · Post by **Gabriel** » Tue Aug 16, 2011 12:29 pm

Its been shown at a few conferences, from what I recall.

To do this, you want to display your grid and populate it with data. Then after its populated, you use the ATTR specification to apply colors to the displayed records. You specify a color mask that makes the grid colored with greenbar.

The only problem is, if someone resorts the Grid by clicking on the column headers. You can deal with this by checking to see if the user sorted the column and reapplying the color mask (advanced) or by disabling column sorting by using the "^NOSORT" in one of your column form specs when applying the grid headers (easier).

http://brwiki.ads.net/index.php?title=G ... s_in_Cells
http://brwiki.ads.net/index.php?title=Grids#unsorted

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 8:04 am

What does the attrib look like? And for which versions.

I would like to print the grid light blue on dark blue.
I would like to use the 6 digit hex specificaiton (ie #FF0000)

i have limited control using r/g:b for example.

using codes doesn't work, for me.

gtisdale · Post by **gtisdale** » Wed Aug 17, 2011 9:38 am

31270 PRINT #LISTWIN, FIELDS LISTSPEC$&",attr": (MAT RS,MAT RE,MAT RA$)

Where RS is the start array, RE is the end array and RA$ is the attribute array

The attribute$ array can carry substitutions like [SELECTED] if it is set

config attribute [SELECTED]N/#0000FF:#FFFFFF,font=Arial:medium:slant" ! medium blue letters on white background

If you are coloring a LIST RS and RE are row numbers if you are coloring a GRID RS an RE are cell numbers

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 9:59 am

only the spec before the colon seems to be working.

I need a spec, a / and speca:specb ?

as in N/#0000FF:#FF0000

gtisdale · Post by **gtisdale** » Wed Aug 17, 2011 10:34 am

What BR version are you using?
Are you using a substitution or putting the spec into mat RA$?

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 2:33 pm

I am trying to accomplish this with 4.18, but I could use 4.2

I am trying to use the RA$

gtisdale · Post by **gtisdale** » Wed Aug 17, 2011 2:36 pm

Use 4.2 I'm not sure when cell coloration arrived, but the ability to change fonts and substitute using [ATTRIB] substitutions I'm pretty sure was 4.2, not 4.18.

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 2:44 pm

I think I am getting about the same response in either, but I will stick to 4.2.

Should I be using ATTRIB substitions, or can I use #:#

gtisdale · Post by **gtisdale** » Wed Aug 17, 2011 2:45 pm

Use attribute substitutions

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 2:56 pm

What is the role of the / in the specification statement?

Gabriel · Post by **Gabriel** » Wed Aug 17, 2011 3:00 pm

The syntax for specifying HTML coloring in a substitute statement is "/#COLOR:#COLOR" where COLOR is a 6 digit hex code representing the HTML color.

The "/" is part of the specification. Its purpose it to let BR know that you're specifying an html color, and to seperate the color specification from any other specifications that are in that particular substitute statement.

In the example "N/#0000FF:#FFFFFF", the "/" separates the color from the N.

Gabriel

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 3:12 pm

When I use the spec N/#:#, i can get a color for the first part, but just black for the second.

R:G works fine

I guess the answer is just use the substitute process

BLarry1T · Post by **BLarry1T** » Wed Aug 17, 2011 3:20 pm

Where is the reference for setting the colors using the config/attribute commands?

CONFIG ATTRIBUTE[BLUE] #COLOR ?

gtisdale · Post by **gtisdale** » Wed Aug 17, 2011 3:37 pm

At some point when we became able to change font sizes, colors, boldness, slant and use HTML colors as well as RGB etc. all of the colon, comma, slash etc. parsing became a real burden for BR. SO, at that point, which I believe was in early 4.2, but not the first 4.2, the routine to set the attributes was condensed to the section of BR that dealth with CONFIG SUBSTITUTE statements and the BR table lookup to do the conversion started residing there rather than being re-done each time a FIELDS sttement was encountered.

So going forward make all of your attribute sttements happen in CONFIG ATTRIBUTE sections. You can do this by putting them into your BRCONFIG.SYS file, doing an EXECUTE CONFIG in your program or PRODing in an external statement that contains the CONFIG ATTRIBUTE sttement.

I personally like using the PROC becasue I can set stndard attributes in an external file and then if I decide I want to change the look of things I change that one file and all programs respect the changed presentation.

The N/ at the start of the attrribute is actually a legacy section that tells BR what to use on a monochrome monitor. N/ was "NORMAL". The sections following the / are the color specs for FOREGROUNG and : BACKGROUND. These can be either RGB codes or #000000 HTML color specs that you can get from an HTML color wheel. These can also be sub-specs like [LTBLUE] if you have configured the [LTBLUE] spec before using it in your [ATTRIB] spec

BR Forum

Grids

Grids

FORM GRID

Grid

Grids

Grids

ATTRIB

Color