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: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
