Calc 5.2.3.3, Windows 10 64b When selecting the option "All Cells" properly functioning appeal to make formula. Changing values in the formula's cells does not affect the conditional formatting. You need to reignite edit formatting. The same edition of the call will change the formatting See and test for example here https://wiki.documentfoundation.org/images/f/ff/FAQ.CALC_142_ColorScale.ods In my old Calc version (5.0.2) on Windows 10 32b everything was O.K. After installing a new version it is like above.
it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
In version 5.3.0.3, nothing has changed. In addition, when selecting a "Icon set" can not see any fields to set parameters for this formatting. I have to go back to the previous version.
Tested: edited E11 and changed the value to 15. It changed to blue immediately. Win 7 Pro 64-bit Version: 5.4.0.0.alpha0+ Build ID: 83e059af2203ec0cd15dea08cfa538555ba14bd7 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-02-06_23:34:43 Locale: fi-FI (fi_FI); Calc: group
If we talk about CALC_142_ColorScale.ods, see for change cell M40 for example from 10 to 30. The problem is in this presentation.
(In reply to Jerzy Moruś from comment #4) > If we talk about CALC_142_ColorScale.ods, see for change cell M40 for > example from 10 to 30. The problem is in this presentation. Ok, it is not updated immediately. I had to switch window focus and then it updated. I confirm it worked in 5.0.2 Win 7 Pro 64-bit Version: 5.4.0.0.alpha0+ Build ID: 83e059af2203ec0cd15dea08cfa538555ba14bd7 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-02-06_23:34:43 Locale: fi-FI (fi_FI); Calc: group
This phenomenon applies to all kinds of formatting in the type of "All cels". The update will occur even after a small resized of window.
Bibisected using repo /bibisect-win32-5.2. commit 1a4026187ba08936ffb78431408667c6acfcf893 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Mon Mar 28 01:26:09 2016 -0700 source 88a0c7d01b7dfd085a0569030f97cc7de0f0d106 # bad: [86cb9d229718f48f9538032b80037238ea79e8a5] source 78223678b7513ffe46804cb08f2dc5bc899b2bab # good: [1f670510f08cb800cbae2a1dd6ea70d3542e4721] source 49c2b9808df8a6b197dec666dfc0cda6321a4306 git bisect start '86cb9d229718f48f9538032b80037238ea79e8a5' 'oldest' # good: [3f9909c4c2ada7a3c705eba0e7ff39f96fb4dcae] source b08e200c3dfa964f257c8b7719ef9c801fb107d7 git bisect good 3f9909c4c2ada7a3c705eba0e7ff39f96fb4dcae # bad: [0679445193ab11c32226f60d9143f84a50f019e4] source caf64a8c814bf821eef302fc6c2570c05b7fb169 git bisect bad 0679445193ab11c32226f60d9143f84a50f019e4 # bad: [1cddb3fbfb07dcfe3b6416b4e9f7f03f70d43be3] source 6b2889b3c4b2da175c4f95bde4495a1a89deedc3 git bisect bad 1cddb3fbfb07dcfe3b6416b4e9f7f03f70d43be3 # good: [5a3c5287cf1db727d42bc5140008776c4c3ac45b] source 0c3ff8ca07265304f9ea0a7aca8c83703cff01a1 git bisect good 5a3c5287cf1db727d42bc5140008776c4c3ac45b # good: [07a1114d2784d83a43aeff9bc029f64b19f2b3c9] source 0eea1465a06119903fca5f5b6dfe5b05a80546ba git bisect good 07a1114d2784d83a43aeff9bc029f64b19f2b3c9 # good: [e8c294367f01071d1a96faf96ce45004a6a54fb0] source 168efab3c49b14f17bf455e74b8a9f153f5534a9 git bisect good e8c294367f01071d1a96faf96ce45004a6a54fb0 # good: [1d7ea3f6ccb390815ffa53e3320b46307ed7fac8] source e7fb8dc9a3c2f40823b2b0c12c7962dc408092cc git bisect good 1d7ea3f6ccb390815ffa53e3320b46307ed7fac8 # good: [4c5e5ef9f022bb6b0ca4e79f91bd4c1cef0535bb] source 4518faa31dec03ffabee30437e6960558a940957 git bisect good 4c5e5ef9f022bb6b0ca4e79f91bd4c1cef0535bb # good: [6cb6022034abb3a8a6e5ac4563e06a8dff444b1e] source 9ec8732e086613f4620850acf97fe74b8b1600d1 git bisect good 6cb6022034abb3a8a6e5ac4563e06a8dff444b1e # bad: [b16fdfbd225109d2311cb11182da017f46350cc9] source c2d130425cc876cceb96cc7e47636426a9e48fa8 git bisect bad b16fdfbd225109d2311cb11182da017f46350cc9 # bad: [a3a4ee8b59742b5ba8ba4cb8b95b4ef45c1665e0] source 988a49426f42c1445bc26677cf8041b7a233015c git bisect bad a3a4ee8b59742b5ba8ba4cb8b95b4ef45c1665e0 # bad: [1a4026187ba08936ffb78431408667c6acfcf893] source 88a0c7d01b7dfd085a0569030f97cc7de0f0d106 git bisect bad 1a4026187ba08936ffb78431408667c6acfcf893 # good: [4cd7999dd679ad4a6d93022fb1743a1a399e43c1] source b41aed83c416a7b00285fc2b198d286d8169f08d git bisect good 4cd7999dd679ad4a6d93022fb1743a1a399e43c1 # first bad commit: [1a4026187ba08936ffb78431408667c6acfcf893] source 88a0c7d01b7dfd085a0569030f97cc7de0f0d106
This issue started with the commit referenced below. Adding Cc: to Markus Mohrhard, please take a look. https://cgit.freedesktop.org/libreoffice/core/commit/?id=88a0c7d01b7dfd085a0569030f97cc7de0f0d106 author Markus Mohrhard <markus.mohrhard@googlemail.com> 2016-03-26 12:11:53 (GMT) committer Markus Mohrhard <markus.mohrhard@googlemail.com> 2016-03-26 15:59:20 (GMT) "switch to a listener based cond format update, tdf#95437"
Can you please check with a current master daily build. At least changing M40 works for me with an update to the conditional format.
(In reply to Markus Mohrhard from comment #9) > Can you please check with a current master daily build. At least changing > M40 works for me with an update to the conditional format. No, still requires some changing of focus, zooming etc. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 4cdd4b47ba62a75aadfd5cab166acfdbc31b9b71 CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on February 17th 2016
So it is a bit more complicated. The row that is changed is actually updated and just not the whole color scale range. This obviously will affect all the range based conditional formats as they share the same listener code.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=49922897d68835ae4e5c850b3c55107157fe7548 repaint whole range for range based cond formats, tdf#105696 It will be available in 6.0.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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6ed7a3085216caf29f9066154fccc6ee2f1b953d&h=libreoffice-5-4 repaint whole range for range based cond formats, tdf#105696 It will be available in 5.4.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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3aa9933caa929e454b68e6efc1f21d485c483932&h=libreoffice-5-4-0 repaint whole range for range based cond formats, tdf#105696 It will be available in 5.4.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.