Table Widget Maximum Number of Columns

Answered

Follow

David Wit

February 09, 2017 23:30

Is there a maximum number of columns in a Table Widget?

Seems the Pivot Widget has a maximum number of rows set at 20 because after added the 20th row the add button no longer appears for rows.

I have to build a column report that has 35 columns and want to know any limitation before running through the work.

Thanks

 

0

• 

  John van der Kleij February 17, 2017 16:41

  I have run into the same problem. We need to have maybe a couple more columns (rows) beyond the 20 apparent limit. Is there a way to change some global/local parameter to increase this row limit?

  Thanks

  0

  Comment actions Permalink
• 

  Yoni Lerner February 21, 2017 21:21

  Hi David,
  
  It can be changed using the script below. Keep in mind though that you should use it with caution. Increasing the value too far can result in performance issues.

   

  widget.manifest.data.panels.forEach(function(p){
  
  p.metadata.maxitems = 25; //replace with the number you need
  
  })

  1

  Comment actions Permalink
• 

  Jacque Frady October 23, 2017 21:28

  Where exactly does this code go?

   

  0

  Comment actions Permalink
• 

  Michael Becker October 24, 2017 11:11

  Hi Jacque,

  input this into widget JS script editor, this is available when you edit widget and go to hamburger menu of that widget.

  Regards,

  Michał

  0

  Comment actions Permalink
• 

  Linh Cao July 02, 2018 08:14

  I use this script and then I got error "The file could not be generated" when export widget into excel. Other widgets do not meet this issue.
  Is there any relation?

  0

  Comment actions Permalink

Please sign in to leave a comment.