Different numeric validation between FlexGrid and FlexSheet

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

  • 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.
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels