expand all columns

11 posts, 1 answers
  1. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 04 Aug 2015 Link to this post

    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.

  2.
  3. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3741 posts

    Posted 06 Aug 2015 Link to this post

    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!
     
  5. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 07 Aug 2015 Link to this post

    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?

  7. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 07 Aug 2015 Link to this post

    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)​

  8.
  9. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 07 Aug 2015 Link to this post

    forgot to add the attached file
  11. Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2598 posts

    Posted 11 Aug 2015 Link to this post

    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!
     
  13. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 11 Aug 2015 Link to this post

    http://dojo.telerik.com/ElEsa/3
  14.
  15. Answer
    Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2598 posts

    Posted 13 Aug 2015 Link to this post

    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!
     
  17. Joey
    Joey avatar
    3 posts
    Member since:
    Sep 2016

    Posted 25 Jan 2017 in reply to Kiril Nikolov Link to this post

    I am encountering this same issue now.  Is there any update on when this will be resolved?
  19. Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2598 posts

    Posted 30 Jan 2017 Link to this post

    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.
  21. Joey
    Joey avatar
    3 posts
    Member since:
    Sep 2016

    Posted 30 Jan 2017 in reply to Kiril Nikolov Link to this post

    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.
Back to Top