Several bugs in one example (validations, formulas and updateList)

[vsa]

Hello,

Please find here a link to jsFiddle and description of several bugs in one example which is a very simplified one (in our case we have dozens of columns with formulas).

https://jsfiddle.net/0gyj8qns/10/

FYI: As in a screenshot, only values of columns B and C in rows 3 and 4 were changed manually

Critical bugs:

   In validation:
      Cell B1: has a formula, but shows validation error after entering and exiting edit mode even if there is NO ERROR (value is less than or equal 31)
      Cell B2 contains a formula with result that is not valid and was warned in a normal way
      Cell C2: no validation error is shown after initializing the grid (value should be less or equal 12) and will show error ONLY AFTER entering and exiting edit mode or executing a isValid() method on a row or a grid
      No validation errors are detected on a whole grid with isValidChange and isValid methods

   Why this is considered as bug: it is expected that there is a possibility to identify validation errors and (in our case) we have a special field that should be filled upon validation error in any cell in a row.

   Get Validation result in console:

Code: [Select]

"isValidChange", true
"isValid", {
  valid: true
}
   In getChanges:
      Cell B1 has a value that was changed by formula (from 1 to actual day index) after loading, but getChanges does not have any modified values from this row.
      All values in cells in column E were changed by formula, but do not appear in getChanges


   Why this is considered as bug: values calculated by formula are expected to be saved in DB.

   Get Changes result in console:

Code: [Select]

"getChanges", [{
  col2: 3,
  col3: 3,
  id: 3
}, {
  col2: 50,
  col3: 50,
  id: 4
}]
Non critical:
   "DATEVALUE" formula accepts impossible dates

Thank you in andvance.

Sincerely,

[vsa]

Hello Team,

Would you be so kind to treat this bugs request?

It is over one month with no response.
You have all details and JSFiddle available.

Thank you.

[paramvir]

Dear vsa

Sorry for the delay. isValid returns validation errors and not warning failures.

When warn: true is added to a validation, it becomes a warning and is no longer treated as a validation error.

isValid can be called upon initialization ( in complete event ) to find out all the validation errors.

Rest of the issues would be resolved in upcoming version.

Regards
Param