Your XLSX validation rule exists. Does it actually reject bad input?
A spreadsheet can pass a formula-preservation check and still fail its user. I hit that distinction while adding input validation to a profit tracker. The original report cells accepted text where a month or year belonged. In LibreOffice, that produced downstream date-formula errors. My local candidate adds a date rule to the monthly report and a whole-number rule to the yearly report. It is not…
The validation rule for the yearly report in the profit tracker spreadsheet is designed to accept only whole numbers between 2000 and 2100 in cell B1. To verify if the rule effectively rejects bad input, a test was conducted using a disposable copy of the spreadsheet in the actual application being used. Upon entering invalid text, an error message appeared titled "Check report period," but it was difficult to determine if the previous value was correctly restored to the cell.
This indicates that the validation test did not fully pass, as the acceptance of invalid input and proper handling of erroneous entries remain unverified.
Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.
