Identifying cells that break data validation rules

[angela-li]

The current quality assurance section states that "data validation rules are not applied retroactively to data that is already present in the cell".

However, in Excel, it's possible to highlight sections of your data that don't meet the data validation rules by clicking the drop-down next to "Data Validation" in Excel and selecting "Circle Invalid Data".

Showing learners how to find and locate incorrectly-validated data would be a good addition to the curriculum.

[jacquelyneneal]

It looks like Google Sheets has a similar functionality with its validation rules (not sure if this is a recommended program or not). Testing it out, the cell will be flagged with a warning if data validation rules are applied after entry.

I have been testing out LibreOffice to see if it will flag already entered values if validation is added later, but I am not currently having success there. This could be good information to mention while showing learners how to validate their data after its been entered.

[chris-prener]

One of the challenges with this lesson in particular is that (a) the different spreadsheet apps have slightly different functionality and (b) they continue to evolve. We aren't necessarily consistent in directing folks to particular apps, but I'd like to get there. Thanks for the info @angela-li and @jacquelyneneal!

[kekoziar]

Also, the same section states that "Instead, if a particular cell would fail the validation check a triangle is placed in the top left corner of the cell as a warning." which is incorrect.

[josenino95]

This issue was closed as part of PR #197. The option to circle invalid data has been described for Excel and Calc