Created attachment 122136 [details] ODS with conditional purple background for cells ending with 11 Conditional formatting selection is inverted for "Ends with" conditions. Hence all the non-conformant cells are formatted with the conditional style and all conformat cells are left unformatted. Fault does not exist for "Begins with" conditions.
Hi @Matthew, thanks for reporting. Reproducible. Win7x64 Version: 5.0.5.1 (x64) Build ID: 7609023f63524a6c8326f6c82e7e23f55a5b7bb5
I'll give it a try
Reproducible with LO 5.1.0.2, Win 8.1
Julien Nabet committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a0a4ea3c636fc18cca6a3b2f9391996fb909e81f tdf#97308: fix logic with conditional "ends with" It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Gerrit review for 5.1: https://gerrit.libreoffice.org/#/c/21730/ for 5.0: https://gerrit.libreoffice.org/#/c/21731/
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=64b23ff688fc4ba3fc0205094380f072fd98b5b5&h=libreoffice-5-1 tdf#97308: fix logic with conditional "ends with" It will be available in 5.1.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-5-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9cd87519d7a9d97b58fafff25280bd77fe04ab25&h=libreoffice-5-0 tdf#97308: fix logic with conditional "ends with" It will be available in 5.0.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4dc18dd3abf78b8451334e093dc84fb289a83336 add test for tdf#97308 It will be available in 5.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.