cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Improvement of Tablebox

I've got a couple of wants for the table box() functionality.  

  1) make cells colorable natively without <<Get As Report so tables don't have to be remade

  2) give custom table boxes similar meta information so the user can use the native Make into combined data table functionality and if multiple tables have the same information, it can extract other infomation

            For instance: allow all of these to somehow have the ages attached to them without having to hide columns and make custom "make into combined data table" functionalities

Names Default to Here(1);
dt = Open("$SAMPLE_DATA\Big Class.jmp");
Summarize(ages = by(:age));
 
hlb = hlistbox();
for(i=1, i<=nitems(ages), i++, 
       rows = dt << Get Rows Where(char(Column(dt, "age")[]) == ages[i]);
       
       tblbox = Tablebox(
              StringColBox("Sex", 
                     dt:sex[rows]
              ), 
              StringColBox("Name", 
                     dt:name[rows]
              )
       );
       hlb << append(
              OutlineBox(ages[i], 
                     tblbox
              )
       )
);
 
new window("Test", 
       hlb
);

3) Allow row specific borders, for instance if I were to make a data table of big class I might want to put a line between each age set

4) Allow tables to be stacked upon each other more easily.  Right now if I want to make a row at the bottom of a table that has sums columns, I have to do a whole bunch of preprocessing to figure out column withs then effectively make two tables. 

5) have "Make into data table" take ColSpanBox() into consideration when naming columns from a tablebox, currently it just names it the final column header 

 

A lot of this might be more easily solved using something like tabulate but I've had different problems when Trying to use that.  

3 Comments
Jeff_Perkinson
Community Manager
Status changed to: Needs Info

These wishes need to be split out into individual ideas in order to gauge votes and track progress. Thanks!

vince_faller
Super User (Alumni)

On it. 

Jeff_Perkinson
Community Manager
Status changed to: Not Planned For Now

Closing this. As this wish has been broken into:

 

make tablebox cells colorable 

and

Allow custom tableboxes to "make into combined data table"