jQWidgets Forums

jQuery UI Widgets Forums Grid validation spreadsheet jqx grid

This topic contains 2 replies, has 2 voices, and was last updated by  Hristo 9 years ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • validation spreadsheet jqx grid #85045

    atomic
    Participant

    Hi guys,

    I am using jqx Grid with

    editable: true,
     selectionmode: 'multiplecellsadvanced',

    I am using some columns validation as

    cellsformat: 'd2',
     columntype: 'numberinput'
     validation: function (cell, value) {
           if (value < 0) {
                 return { result: false, message: "You must enter positive value!" };
           }
     return true;											 }

    }`
    and everything works fine when you enter cell by cell, but if you paste values from excel (not all numbers) jqx grid will accept those values as regular and wont show any validation message.
    am i doing something wrong?
    thank you

    validation spreadsheet jqx grid #85046

    atomic
    Participant

    I would like to add that not all cells accept not number values and negative values, they are only set to 0.00, but some of them get negative values as well as strings. Unless I do something wrong this is bug.
    Cheers

    validation spreadsheet jqx grid #85057

    Hristo
    Participant

    Hello atomic,

    Unfortunately, that is not possible.
    Only in edit mode typed value will be validated.

    Best Regards,
    Hristo Hristov

    jQWidgets team
    http://www.jqwidgets.com

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.