ParamQuery grid support forum
General Category => Bug Report => Topic started by: vsa on May 05, 2022, 08:22:34 pm
-
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/ (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:
"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:
"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,
-
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.
-
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