[Libreoffice-bugs] [Bug 138134] New: EDITING Validation circle does not disappear when value is changed by formula calculation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138134

            Bug ID: 138134
           Summary: EDITING Validation circle does not disappear when
                    value is changed by formula calculation
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nagy.tibor2 at nisz.hu, nemeth at numbertext.org
            Blocks: 108988

Created attachment 167195
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167195&action=edit
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

Actual results:
Value in C1 becomes 7 but detective circle is still present. 
Note: Excel 2013 works the same way, but we can do better :).

Expected results:
Detective circle gone since the newly calculated value fulfills the validation
condition.

LibreOffice details:
Version: 7.1.0.0.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
Calc: CL


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108988
[Bug 108988] [META] Validity-related bugs and enhancements
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201111/5234a9be/attachment.htm>