API change suggestion for data validation

[Heiko Tietze]

In bug 159595 I made a complaint about data validation not rejecting invalid data points (for example, a list with 1,2,3 still accepts the value 4 - with or without error message). Julian kindly submitted a patch that changed the behavior. But several users disagree with the change and expect a use case where some validation criteria is defined but exceptions are possible (for example, Ford, Toyota, VW... but also BYD). This is discussed in bug 160096.

https://gerrit.libreoffice.org/c/core/+/195563




--
Dr. Heiko Tietze, UX-Architect and UI-Designer
Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
The Document Foundation, Winterfeldtstraße 52, 10781 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint

In fact, Excel's behavior is the same as we did in the past. And there is no way to silently reject invalid data. I suggest an API change that adds this option to the validation. The patch has successfully compiled (thanks to Xisco) and could be cherry-picked for 26.2. It includes a minor string change because "Show error message when invalid values are entered" makes no sense for the action "Reject silently". "Handle invalid values" sounds better to me. The API change is an addition to the ValidationAlertStyle. It will not survive a round-trip with other file formats (likewise in case of MACRO).

OpenPGP_signature.asc
Description: OpenPGP digital signature