Wijmo Grid Transponse: convert columns to rows and rows into columns wijmo grid

Wijmo Grid Transponse: convert columns to rows and rows into columns wijmo grid

Posted by: siddushar on 17 December 2018, 10:41 pm EST

• 

  siddushar

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 December 2018, 10:41 pm EST

  Hello all,
  
  I am using wijmo grid in my angular2 application.

  How can i transpose grid? im facing problem while converting rows into columns and columns into rows.
  
  i tried following : https://stackblitz.com/edit/angular-fozjd2?file=src%2Fapp%2Fapp.component.html

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 18 December 2018, 4:43 pm EST

  Hi,

  FlexGrid doesn’t support the transposed view so the only option left is to transpose the source data and assign it to the grid just like in the sample you shared.
  
  However this approach also has its shortcomings such as features like sorting, filtering won’t be supported since they would work on columns and in transposed view that won’t make much sense(since sorting, filtering would be required to work on rows in case of transposed view).
  
  You may use the approach if it only for viewing purposes and doesn’t require support for advanced grid features.
  
  We have updated the sample to display row headers as well, you may find the sample here: https://stackblitz.com/edit/angular-fqiphw?file=src%2Fapp%2Fapp.component.ts

  ~Sharad

• 

  eveverad3

  • Post Options:
  • Link
    Copy

  Posted 3 May 2019, 1:57 am EST

  Hi Team,

  Is this answer up to date or there is something new that we can use for the colum-row transpose?
  
  We are using Angular 7

  Thanks,

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 5 May 2019, 6:05 pm EST

  Hi,

  You may use the solution for Angular 7 as well. Let us know if you face any issues.

• 

  eveverad3

  • Post Options:
  • Link
    Copy

  Posted 5 May 2019, 6:37 pm EST

  Hello Abhishek,

  Thanks for your reply. Do you mean the above solution or is there any other newer solution available for Angular 7?

  Thanks

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 7 May 2019, 6:27 pm EST

  Hi,

  We have an updated sample to transpose grid. Please refer to the following updated sample and let us know if you face any issues:
  
  https://jsfiddle.net/Wijmo5/tce6ro57/

  Regards

• 

  edekoven

  • Post Options:
  • Link
    Copy

  Posted 9 December 2019, 6:15 am EST

  Would using a TransposedGrid do the same thing but with a lot less code?

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 9 December 2019, 2:38 pm EST

  Hi Elyon,

  Yes, you can use the TransposedGrid control to create a transposed grid. Refer to the sample link below:

  https://www.grapecity.com/wijmo/demos/Grid/TransposedGrid/ProductSheet/purejs

  Regards,
  
  Ashwin