Created attachment 166532 [details]
Example file from Calc with merged cells and invalid content
Attached example file contains data validation (condiftion: whole numbers >0) for merged cells which were filled with invalid data.
When the Tools – Detective – Mark Invalid Data command is used the top left cell of the merged cells is circled instead of all the merged range.
Steps to reproduce:
1. Open attached file
Validation circles are around the top left cell of merged ranges.
Validation circles are drawn around all of the merged ranges.
Version: 188.8.131.52.alpha0+ (x64)
Build ID: c064766901722082df0d759c95434c1460fcdba5
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Created attachment 166533 [details]
Screenshot of the problem in Calc
Created attachment 166534 [details]
Example file from Excel with merged cells and invalid content
Created attachment 166535 [details]
For reference: How Excel behaves in a similar setup
Created attachment 166607 [details]
Like in the attached patch?
(In reply to Regina Henschel from comment #4)
> Created attachment 166607 [details]
> Like in the attached patch?
Thank you for your suggestion!
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":
tdf#137614 sc: fix data circle shape size on merged cells
It will be available in 7.1.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: 184.108.40.206.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
Thanks for fixing!