Description: doesn't update type of icon of conditional formatting "Icon set" with percent if delete minimal or maximal values from range Version: 6.0.3.2 Build ID: 8f48d515416608e3a835360314dac7e47fd0b821 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk2; Locale: ru-RU (ru_RU.UTF-8); Calc: group Steps to Reproduce: 0. Just open file Example from attach and go to 5, or 1. Create a conditional formatting for range A1:A20. All cells - Icon set - 3 arrows 2. Enter value for yellow arrow - 50 percent, for green arrow - 80 percent 3. Fill range A1:A20 uses any values from 0 to 100 (for simpling) 4. Note: percent for any value in cell of range is calculated as (cell_value-minimal_value) / (maximal_value-minimal_value) 5. Delete all value 0 or all value 100. 6. Type of icon for all cells in range must be recalculate and change! Because percent is changed! But it didn't happen! 7. Then, change value in any cell from range -> Type of icon for all cells in range is recalculated and changed to correct! Actual Results: doesn't update type of icon of conditional formatting "Icon set" with percent if delete minimal or maximal values from range Expected Results: type of icon changes to correct if delete minimal or maximal values from range Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101 Firefox/60.0
Created attachment 142358 [details] Example
(In reply to kompilainenn from comment #0) > 5. Delete all value 0 or all value 100. > 6. Type of icon for all cells in range must be recalculate and change! > Because percent is changed! But it didn't happen! > 7. Then, change value in any cell from range -> Type of icon for all cells > in range is recalculated and changed to correct! After I delete 0s, the arrows go away and do not come back. Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: 0929a98acca8ec4d86caa97d3090a39f89f35f90 CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on June 20th 2018
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=17722541e906cf64dcdd7169194aad72ec14bb10 tdf#117809, listen to the actual conditional format range if necessary It will be available in 6.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.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4b7ce45c2384fdd65c17ab18036899cd76577254 add tests for tdf#117809 It will be available in 6.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.