ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: queensgambit9 on April 10, 2019, 08:21:26 pm

Title: Export with grouped columns
Post by: queensgambit9 on April 10, 2019, 08:21:26 pm

Do grouped columns work with local export?

https://paramquery.com/pro/demos/export_local

Title: Re: Export with grouped columns
Post by: paramvir on April 10, 2019, 10:17:51 pm

Yes

Title: Re: Export with grouped columns
Post by: queensgambit9 on April 11, 2019, 02:33:21 am

Can't get it to work...do I need to modify anything compared when using no grouped columns?
Looks fine in grid but do not work in export to Excel.

Title: Re: Export with grouped columns
Post by: paramvir on April 11, 2019, 10:02:39 am

It doesn't need any modification. Do you get any error?

Title: Re: Export with grouped columns
Post by: queensgambit9 on April 11, 2019, 12:59:33 pm

Parent column has hidden: false...

Seems like this:

Code: [Select]

beforeExport: function( event, ui ) {

var Cols = grid.Columns();

Cols.alter(function(){
Cols.each(function(column){
        column.copy = !column.hidden;
})
})}
Causes the parent column not be written out to excel, (although the extra line is there).

Title: Re: Export with grouped columns
Post by: paramvir on April 11, 2019, 04:40:17 pm

column.copy is not supported for grouped columns

https://paramquery.com/pro/api#option-column-copy