Different numeric validation between FlexGrid and FlexSheet

Different numeric validation between FlexGrid and FlexSheet

Posted by: david_gadsby on 18 November 2021, 11:43 pm EST

• 

  david_gadsby

  • Post Options:
  • Link
    Copy

  Posted 18 November 2021, 11:43 pm EST

  Hi,
  
  I’m trying to track down why our FlexSheet doesn’t throw a parsing error when entering an invalid number like ‘1.1.1.’ into a number column. If I use a FlexGrid it does throw a validation error, is there difference in behavior between these 2 controls?
  
  Both examples are bound to the same CollectionView with the same getError callback.

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2021, 3:58 pm EST

  Hello,

  Yes, there are certain differences between FlexSheet and FlexGrid. FlexSheet control is designed to be like Excel therefore it supports the features like Excel. It doesn’t coerce the cell values to maintain the dataType of the cell value according to the column dataType.However, the FlexGrid coerces the cell values to keep column dataType in check.

  If you wish to validate the cell values according to the dataType or on some other parameters you may handle the cellEditEnding event of FlexSheet and perform the validations. Please refer to the API link below for reference:

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#celleditending

  Regards