[Libreoffice-bugs] [Bug 138483] New: EDITING Validation circles not updated when circled cells get merged

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 25 12:28:36 UTC 2020


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

            Bug ID: 138483
           Summary: EDITING Validation circles not updated when circled
                    cells get merged
           Product: LibreOffice
           Version: 7.2.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          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,
                    szucs.attila3 at nisz.hu
            Blocks: 108988

Created attachment 167558
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167558&action=edit
Example file from Calc with validation errors

If there are validation circles on Calc cells and those cells are merged, the
validation circles stay behind instead of the newly merged cells validity being
evaluated.
Attached file has some cells with validity of Whole number > 5. 

Steps to reproduce:
    1. Open attached file
    2. Merge cells A1 and B1
    3. Merge cells A3 and B3
    4. Merge cells A6:C6
    5. Merge cells A10 and B10
    6. Unmerge cells A12:B12

Actual results:
Validation circle is not expanded in A1:B1.
Two validation circles remain in A3:B3 and A6:C6.
The validation circle does not disappear from B10, since after merging the
value of 6 in A10 satisfies the validity criteria.
Validation circle is not shrunk to A12 from the formerly merged A12:B12 cell.

Expected results:
Expanded validation circle around A1:B1.
One validation circle around A3:B3 and A6:C6 
No circle around A10:B10 since the criteria is now met.
Validation circle around A12 only and nothing aroung B12.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64)
Build ID: cb084f475db33a2cfc62bc9c8de37b8c3c87b3c7
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/20201125/e09f9c76/attachment.htm>


More information about the Libreoffice-bugs mailing list