Disclaimer: You are free to reuse it “as-is”, on your own responsibility and without any guarantee whatsoever. No rights can be derived from, successfully or unsuccessfully, completing the steps outlined below.

This is a scenario that tests whether your application is able to validate the value of a spreadsheet cell against a range of allowed values. Typically, this is rendered as a cell with a drop-down list, while the range itself is on another (hidden) sheet.

Part 1:

• Create a new spreadsheet
• Make sure it has at least 2 sheets/tabs in it
• On the second sheet, enter the values “red”, “green” and “blue” in A1..A3
• On the first sheet, add a validation rule to cell A1, only allowing the values from the range Sheet2/A1..A3 + allow empty cell
• Enter/select “red” as value for A1
• Add the same validation rule to the empty cell A2, do not enter a value

Part 2:

• Open the spreadsheet in another application
• Check if the rule is still in place, by entering an incorrect value in cell A2 (e.g. “yellow”, this should produce a warning)

Please follow the file name convention outlined in the faq. Note that the PDF files can be included as a previewing aid, but uploading the ODF files is much more important.

A list of known issues. Implementations not listed here may or may not work as expected. Results may vary depending on user settings and computer environment. Use at your own risk.