Inconistent behavior of the Spreadsheet list validation when the from option contains empty space #7913
Labels
Bug
C: Spreadsheet
FP: Unplanned
Sync status with associated Feedback Item
jQuery
Regression
Broken functionality which was working previously
Bug report
When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.
Reproduction of the problem
Current behavior
On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:
Expected/desired behavior
The empty space added in the
from
configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.The issue is a regression starting with 2020.3.1118
Environment
The text was updated successfully, but these errors were encountered: