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.
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.
|001||Open||LibreOffice 3.5.2||MS-Office 2010||Validation rule is gone / not checked|
|002||Open||LibreOffice 3.5.2||Calligra 2.4 (Win7)||Validation rule is not checked|
|003||Open||Apache Open Office 3.4.0 b9586||LibreOffice 3.4.5||Validation rule is gone / not checked|
|004||Open||Apache Open Office 3.4.0 b9586||Gnumeric 1.10.17||Validation rule works, warning|
|005||Open||LibreOffice 3.5.2||Calligra trunk Linux||Validation rule not checked|