Is it possible to add PivotPanel in FlexSheet?

Is it possible to add PivotPanel in FlexSheet?

Posted by: chayankar209 on 20 April 2018, 1:10 am EST

• 

  chayankar209

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 April 2018, 1:10 am EST

  Hello,

  I have to design a system where user will select the columns they want to view in report.
  
  This is acheived by using PivotTable.

  Now I have to export the selected output view(after applying filter & sorting rules) in a flex sheet.

  Is this a feasible requirement ? If yes, I want to know the steps.

  Thank you,
  
  Chayan Kar

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 23 April 2018, 8:25 pm EST

  Hi,

  If we understand correctly you have a PivotPanel bounded to a PivotGrid, now you are doing changes in PivotGrid(sorting/filtering) and would like the final view to be exported in a FlexSheet.

  You may do that by first converting the PivotGrid to workbook using wijmo.grid.xlsx module and then loading the workbook into FlexSheet using load() method.

  Refer to the following example implementing the same:- https://stackblitz.com/edit/angular-yny649?file=app%2Fapp.component.ts

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 24 April 2018, 6:08 pm EST - Updated 3 October 2022, 11:30 am EST

  THANKS A LOT !!! This is exactly what I wanted !!

  But there is a bug in the system which I would like to point you out. After exporting to FlexSheet, when I am trying to add new column, then added column’s name is duplicate.

  Because of this duplication i am unable to perform formula calculation using cell reference.

  =Sum(4,3) is producing 7 but Sum(A2,B2) is producing 0.

  I am unable to alter column name as well.

  Refer to attached screenshot.

  

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 12:31 am EST

  Hi,

  We are sorry indded, we are unable to replicate the issue at our end with the following demo sample:
  
  https://stackblitz.com/edit/angular-9injxh?file=app%2Fapp.component.ts

  Here are our implementation steps:-

  Initialize a flexsheet by loading worbook data from a PivotGrid.
  
  Add a new column to the flexsheet

  Please let us know if there are any additional steps to reproduce the problem, also feel free to update the above example to reflect your problem.

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 12:53 am EST - Updated 3 October 2022, 11:30 am EST

  Hello,

  Attached is the screenshot of the reproduced bug on https://stackblitz.com/edit/angular-9injxh?file=app%2Fapp.component.ts

  After exporting the grid to excel => Add new column => New column with duplicate name created => No arithmatic operation possible.

  

  1366×768 106 KB

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 6:29 pm EST

  Hi,
  
  We tried again to replicate the issue at our end with sample shared previously. But unfortunately, we are unable to replicate the issue at our end. Please see the screencast:
  
  https://www.screencast.com/t/FNIYRtc55 (IE Preferable)

  ~Manish