Automatically add rows and columns in wijmo.grid.sheet

Automatically add rows and columns in wijmo.grid.sheet

Posted by: tos on 29 April 2018, 6:07 pm EST

• 

  tos

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 April 2018, 6:07 pm EST

  Using a FlexGrid, rows and columns are added automatically at the end of the data set, but this doesn’t seem the case with FlexSheet.

  Is this a feature you’re planning on implementing, or do we have to implement it ourselves?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 30 April 2018, 6:09 pm EST

  Hi,
  
  You may add the Rows and Columns in FlexSheet same as FlexGrid.
  
  The newRow can be added by setting allowAddNew to true. Please refer to the following sample for the same:
  
  https://stackblitz.com/edit/angular-qqzky4?file=app/app.component.html

  Please let us know if you have further query.

  ~Manish

• 

  tos

  • Post Options:
  • Link
    Copy

  Posted 30 April 2018, 11:30 pm EST

  Hi

  I’m not using the Angular wrapper, but rather making our own wrapper of the Javascript libraries, as we’re using AngularJS.

  Setting the FlexSheet/FlexGrid.allowAddNew property doesn’t seem to be doing anything, unfortunately.

• 

  tos

  • Post Options:
  • Link
    Copy

  Posted 1 May 2018, 1:22 am EST

  Hi,

  Managed to work around this problem by implementing the logic myself, as I also needed it when pasting data.

  However, the performance of FlexSheet seems a bit poor, spending a lot of time handling scroll events? Is this something you’ve experienced?

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 1 May 2018, 10:24 pm EST

  Hi,
  
  The appropriate solution may not be suggested until the requirement is not clear or acknowledged.

  We are glad to know that you have implemented yourself.

  Just for information, the allowAddNew setting true, allow adding new row to collectionView on editing this or pasting data to this row. The new rows gets added on pasting if required.

  The FlexSheet /FlexGrid have scrollPositionChanged event which can be handled to do some code while scrolling has been finished.

  http://demos.wijmo.com/5/Angular/WijmoHelp/WijmoHelp/topic/wijmo.grid.sheet.FlexSheet.Class.html#scrollPositionChanged

  You may also use standard scroll event for handling scroll event. Please refer to the following code snippet:

  theGrid.hostElement.addEventListener("scroll",function(e){
  	/* Code here */
  });
  

  We are sorry, we would not suggest why FlexSheet performance is slow.
  
  It would be great if you elaborate your requirement so that we can suggest you accordingly.

  Any demo sample depicting your issue would be helpful in investigation.

  If you would like to share it privately, please create a case at SupportOne portal:
  
  https://supportone.componentone.com/home

  ~Manish