Description: Changing a validity drop down cell to a valid blank selection by using the space bar, apparently is not generating a change sheet event since the latest update. Actual Results: Put a range of cells in the data validity for a cell. have a blank option as valid. without using the drop down, use the space bar to blank out the data in a cell. Expected Results: Selecting the blank option by pressing the space bar does not trigger a changed sheet event. Selecting the blank option from the drop down does generate the change sheet event Reproducible: Always User Profile Reset: No Additional Info: Triggered a change sheet event. I'm changing other cells and sometimes attributes of other cells based on the contents of the data validity in cells. I have multiple columns with data validity rules and it slows down data entry by not being able to blank a cell without having to use the drop down to select. the previous release allowed the space bar blank.
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Because the space is like any other letter that you can use to select a value in the list, they get on the position but doesn't trigger the selection. IMO not a bug.