Flexsheet: Display Average, count and sum in flexsheet footer

Flexsheet: Display Average, count and sum in flexsheet footer

Posted by: chandrasekar_keerthana on 30 October 2018, 6:17 pm EST

• 

  chandrasekar_keerthana

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 October 2018, 6:17 pm EST

  Hi,
  
  Two questions…

  1. Is there a way to customize the flexsheet right-click context menu to display the hide/unhide flexsheet columns option?

  2.Is it possible to display the sum, average and count in the flexsheet footer after selecting a range of cells? I see in your example that it is displayed below the flexsheet footer.
  
  https://demos.wijmo.com/5/angular/excelbook/excelbook/excellikeSheet.htm
  
  But is there an option to display it inside the flexsheet’s footer itself?

  Thanks,
  
  Keerthana

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 31 October 2018, 4:45 pm EST

  1). The easiest way to do that would be by using CSS,

  .wj-context-menu-item[wj-part='insert-columns']{
    display: none;
  }
  .wj-context-menu-item[wj-part='delete-columns']{
    display: none;
  }
  

  Alternatively, you may handle ‘contextmenu’ event and replace the default contextmenu with your own custom ‘contextmenu’.

  2). You may handle the selectionChanged event and update footer values as required.

  Please refer to the following sample which demonstrates the same:
  
  https://stackblitz.com/edit/js-uixk4q?file=index.js

  ~Sharad

• 

  chandrasekar_keerthana

  • Post Options:
  • Link
    Copy

  Posted 13 November 2018, 5:51 pm EST

  Thanks for the reply Sharad