Created attachment 167558 [details] 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
Created attachment 167559 [details] Screenshot of the example file in Calc before merging cells with validation errors
Created attachment 167560 [details] Screenshot of the example file in Calc after merging cells with validation errors
Tibor Nagy committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3741b90abe478fb04db88207b496a5238df35bb8 tdf#138483 sc: update red circles after merging cells 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/210ec3ef966b2f9206e9e52781f4cb9d2ed46300 Revert "tdf#138483 sc: update red circles after merging cells" 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tibor Nagy committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/df36ac613e43934e49edd3f087d78c7c54ac92ee tdf#138483 sc: update red circles after merging cells It will be available in 7.1.0.0.beta2. 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b18c7096af799e49bc27771cd1500c4eff6bb780 Revert "Revert "tdf#138483 sc: update red circles after merging cells"" 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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.2.0.0.alpha0+ (x64) Build ID: 368c56144aab5794c39d5bc2082d9b3d6d7cebdb CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded Thanks for fixing!