Author Topic: Several bugs in one example (validations, formulas and updateList)  (Read 299 times)

vsa

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 12
    • View Profile
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

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 12
    • View Profile
Re: Several bugs in one example (validations, formulas and updateList)
« Reply #1 on: June 07, 2022, 03:50:06 pm »
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 5637
    • View Profile
Re: Several bugs in one example (validations, formulas and updateList)
« Reply #2 on: June 08, 2022, 06:34:53 am »
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