Created attachment 167195 [details]
Example file from Calc
Attached simple file contains a SUM formula in a cell summing two other cells content. It has a validity condition of Whole numbers > 6. Detective circles this since the formula result is 5.
When another value is entered in the summed cells, the formula updates the value, but the Detective circle is not removed, despite the new calculated value fulfilling the condition.
Steps to reproduce:
1. Open attached file
2. Notice the detective circle on C1
3. Enter 4 in A1
Value in C1 becomes 7 but detective circle is still present.
Note: Excel 2013 works the same way, but we can do better :).
Detective circle gone since the newly calculated value fulfills the validation condition.
Version: 126.96.36.199.alpha1+ (x64)
Build ID: 00e5c63c35307faacf76a5e2ca7953c4208244ed
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Created attachment 167196 [details]
Example file from Calc saved as XLSX
Created attachment 167197 [details]
Screenshot of the original documents side by side in Excel and Calc
Created attachment 167198 [details]
Screenshot of the modified documents side by side in Excel and Calc
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":
tdf#138134 sc: remove red circle of updated formula
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Version: 188.8.131.52.alpha0+ (x64) / LibreOffice Community
Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU