Evaluate WIJMO Grid before buying license

Evaluate WIJMO Grid before buying license

Posted by: Gopala.Chintakindi on 4 January 2018, 1:13 pm EST

• 

  Gopala.Chintakindi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 January 2018, 1:13 pm EST

  Ours is a HTML5/ Angular JS 4 application. In our company few HTML5/ Angular JS 4 projects are already using Licensed WIJMO grid and now it is our time.
  
  Before we buy license we want to do research and see whether Wijmo Grid does what we want to do.

  Please see the attachment for our UI. We basically need few below features

  1. First row first cell we need a drop down
  2. First row starting from second cell we need to have checkboxes with blue background
  3. When check box is checked entire column must be checked
  4. We need to have total for each row and total for each column
  5. We need cells to be editable and an event to validate entered data
  6. We need support for arrow keys, edit and press enter key
  7. Export to excel support
  8. Each column styles are different from other column
  9. Add rows and columns at dynamically/ runtime

  Can you please guide us and give helpful tips and point in right direction for wijmo grid tutorials for Angular 2.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 January 2018, 4:23 am EST

  Hi Gopala,
  
  As per your requirements, the FlexSheet would be appropriate control for you since FlexGrid does not support formula same as Excel and row wise total.

  Here are the answers for your queries based on FlexSheet and FlexGrid control:

  1. DropDown may be added for any cell using itemFormatter or formatItem for both FlexSheet and FlexGrid, In FlexGrid, wjFlexGridCellTemplate can be used in Angular framework. Please refer to the following demo sample.

  http://demos.wijmo.com/5/Angular2/CellTemplateIntro/CellTemplateIntro/

  2. Need to use itemFormatter and formatItem for adding checkbox for both and Cell Template for FlexGrid.

  3. For this, we need to add checkbox and handle click event for the same. Please refer to the following fiddle sample, this functionality may be implement for FlexSheet also.

  http://jsfiddle.net/mkgupta911/f9vsr3y5/

  4. The total for each column may be evaluated using aggregation for ColumnFooters for both. But row total is not possible for FlexGrid. However, this may be accomplished using custom function to set value using setCellData on collectionChanged.

  Using FlexSheet, this may be implemented using FlexSheet formula support.

  5. The cell is editable as excel and can be validate using cellEditEnding event.

  6. Both FlexGrid & FlexSheet, support arrow keys, tab and Enter key navigation and Quick edit same as Excel.

  7. FlexGrid and FlexSheet support Excel support with following limitation:

     Do not export Merged cell
     
     Do not export any custom Editor or HTML control

  8. Each column can be styles differently by adding different CSS class for each column.

  9. Rows and Column may be added any time by pushing into Rows and Columns collection of Control.

  Please refer to the following demo samples for both controls:

  http://demos.wijmo.com/5/Angular2/FlexGridIntro/FlexGridIntro/

  http://demos.wijmo.com/5/angular2/FlexSheetIntro/FlexSheetIntro/

  http://demos.wijmo.com/5/Angular2/ExcelBook/ExcelBook/excellikeSheet.htm

  http://demos.wijmo.com/5/Angular2/ExcelImportExport/ExcelImportExport/

  Let us know for any further queries.

  ~Manish