Vizlib Home Try Vizlib
Welcome
Login

VizLib Table - Allow to group columns in header or allow to freeze panes in row

 

The main request is: allow to group columns, making it look wise a pivot table but with all-powerfulness of a table.

 

An alternative, that is not perfect but is an acceptable workaround and it’s probably much easier to implement is: allow to freeze panes in row x (like we can in Excel).

Having this, we can setup a table where first 2 rows are used as a “fake” header and then freeze 2nd row and it looks like an header.

please find attached usercase.


This is a VizLib Table with full custom formatting on font colour, font background and css styling, row by row.

Because it's not possible to group columns in a straight table, is not possible to use real header. So, in this table, rows 1 and 2 (shaded dark blue and light blue) does the workaround but because are fake header. The only problem is that when scrolling, we lose from screen that first 2 rows. A “freeze at row x” option it would solve the problem.


PFA image 2

Pivot Table is not an option because formatting options are limited (html can’t be used because export to Excel doesn’t work – goes with the tags!), width of column can’t be controlled individually, performance is worst than straight table, etc. 

Business considers this table critical factor of success.


Thanks,

Image 2.png
(579 KB)

1 person likes this idea
  • Hi Reshma,

    Hope you are well.

    Can I ask, is this feature request asking for 'FREEZE ROWS' as an option for the Vizlib Table? 

    If I am mistaken, please let me know.

    Please note your unique ticket reference (#36056) and URL https://community.vizlib.com/helpdesk/tickets/36056

    Kind regards,
    Luke T
    Vizlib | Product Manager
  •  Just to chime in with a bit of support, grouping columns in a table (as per the first image) is something that we've had requested by our users as well. We currently work around this by color-coding the columns to create an artificial grouping, but it's not an ideal approach.

  • Hi Reshma/Joao,

    Okay, thank you.

    So the feature would work something like this seen in the image below where you can Freeze the column on the table


    Please note your unique ticket reference (#36056) and URL https://community.vizlib.com/helpdesk/tickets/36056

    Kind regards,
    Luke T
    Vizlib | Product Manager
  • The grouping of columns like in Vizlib Finance would be nice with the Vizlib Table. We currently work with the border width of the right border - this helps to group columns together. 

Login to post a comment