expand all columns

8 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. Georgi Krustev
    Admin
    Georgi Krustev avatar
    3706 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!
     
  3. Kendo UI is VS 2017 Ready
  4. 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?

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

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

    Posted 07 Aug 2015 Link to this post

    forgot to add the attached file
  7. Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2565 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!
     
  8. Juliana
    Juliana avatar
    8 posts
    Member since:
    Jul 2015

    Posted 11 Aug 2015 Link to this post

    http://dojo.telerik.com/ElEsa/3
  9. Answer
    Kiril Nikolov
    Admin
    Kiril Nikolov avatar
    2565 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!
     
Back to Top
Kendo UI is VS 2017 Ready