From the ESC meeting: * API change suggestion for data validation (Heiko) + https://lists.freedesktop.org/archives/libreoffice/2025-December/094111.html + https://gerrit.libreoffice.org/c/core/+/195563 + what's done here: new option to the validation list + if enabled, just reject the invalid input if requested + but it's an API change + extends a published enum + kind of confident with the code, but Stephan & Cloph is less happy
(full minutes at https://lists.freedesktop.org/archives/libreoffice/2025-December/094119.html)
I would push the patch to master first, if no one complains, and see if users are happy. In case of positive feedback I suggest to cherry-pick the patch to 26.2.
Cheers, Heiko On 16.12.25 5:50 PM, Heiko Tietze wrote:
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.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.https://gerrit.libreoffice.org/c/core/+/195563It 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).
-- Dr. Heiko Tietze, UX-Architect and UI-Designer Tel: +49 30 5557992-63 | Mail: [email protected] 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
OpenPGP_signature.asc
Description: OpenPGP digital signature
