This is a migrated thread and some comments may be shown as answers.

expand all columns

10 Answers 230 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Juliana
Top achievements
Rank 1
Juliana asked on 04 Aug 2015, 06:41 PM

Hello, I've been testing the PivotGrid using local data binding and have some questions:

Is there any way that I can make a button to expand all rows and columns with local data binding? I tried to do that in the column using

pivotgrid.dataSource.expandColumn("Dimension1&Value", "Dimension2");

but the grid's colspan was all wrong (see image attached). Is there any way to fix this? I tried to do the same thing on the row and it works fine.

10 Answers, 1 is accepted

Sort by
0
Georgi Krustev
Telerik team
answered on 06 Aug 2015, 09:31 AM
Hello Juliana,

In general, the widget allows to expand the first level of every dimension. If you would like to expand all possible tuples, then you will need to do that manually. Here is a demo that demonstrates how to do that: Note that you need to pass the fully qualified path of the tuple. The path actually is all unique names of the parent members plus the unique name of the concrete tuple member which we are about to expand.

Regards,
Georgi Krustev
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Juliana
Top achievements
Rank 1
answered on 07 Aug 2015, 07:26 PM

Hi,

I am using this code to expand the rows:

pivotgrid.dataSource.expandRow(["Submercado"]);
pivotgrid.dataSource.expandRow(["Submercado&Sul", "UF"]);

 which generates the result shown on image 1, which is absolutely correct.

 When I wrote this code to expand the columns:

pivotgrid.dataSource.expandColumn(["Ano"]);
pivotgrid.dataSource.expandColumn(["Ano&2015"]);

you can see the result on image2 attached. As I've wrote in my question, the colspan that generated is all wrong, you can see in the image that the months are not aligned at all with the grid content. How can I fix this?

 

Also, which verson of the jquery.min.all.js is the most recent? I just download the kendo ui and it came with the v2015.2.624, but on a dojo demo I found a v2015.5.805, which corrects some of the bugs that I have had with expanding columns. Which one should I use and is the most recent?

0
Juliana
Top achievements
Rank 1
answered on 07 Aug 2015, 07:30 PM

Also, when I added this code:

pivotgrid.dataSource.expandColumn(["Ano"]);
pivotgrid.dataSource.expandRow(["Submercado"]);
pivotgrid.dataSource.expandRow(["Submercado&Sul", "UF"]);

you can see in the image attached that the rows are correct, but take a look at the columns (again, they are not aligned with the months)‚Äč

0
Juliana
Top achievements
Rank 1
answered on 07 Aug 2015, 07:32 PM
forgot to add the attached file
0
Kiril Nikolov
Telerik team
answered on 11 Aug 2015, 03:21 PM
Hello Julia,

I was not able to reproduce the problem locally, this is why I would like to ask you to send us a runnable project that we can use to reproduce the issue and see what exactly is causing this behavior. Thanks in advance.

Regards,
Kiril Nikolov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Juliana
Top achievements
Rank 1
answered on 11 Aug 2015, 03:45 PM
http://dojo.telerik.com/ElEsa/3
0
Accepted
Kiril Nikolov
Telerik team
answered on 13 Aug 2015, 07:26 AM

Hello Juliana,

 

This looks like an issue with the PivotGrid that I have logged in our internal bug tracker and it will be fixed with an upcoming build.

 

Thanks for bringing this up.

 

Regards,
Kiril Nikolov
Telerik
 
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
 
0
Joey
Top achievements
Rank 1
answered on 26 Jan 2017, 01:11 AM
I am encountering this same issue now.  Is there any update on when this will be resolved?
0
Kiril Nikolov
Telerik team
answered on 30 Jan 2017, 07:31 AM
Hello,

It should be resolved with the latest version.

Can you please provide your setup in a separate ticket that we can look at?

Regards,
Kiril Nikolov
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Joey
Top achievements
Rank 1
answered on 30 Jan 2017, 04:43 PM
One of my coworkers that I am working on my project with has already submitted a ticket for larger issues we are having with the pivot grid.  I think I will use that ticket to resolve this issue one the larger issues are resolved.
Tags
PivotGrid
Asked by
Juliana
Top achievements
Rank 1
Answers by
Georgi Krustev
Telerik team
Juliana
Top achievements
Rank 1
Kiril Nikolov
Telerik team
Joey
Top achievements
Rank 1
Share this question
or