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 Actual results: Validation circles are around the top left cell of merged ranges. Expected results: Validation circles are drawn around all of the merged ranges. LibreOffice details: Version: 7.1.0.0.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 Calc: CL
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] Suggestion Like in the attached patch?
(In reply to Regina Henschel from comment #4) > Created attachment 166607 [details] > Suggestion > > 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": https://git.libreoffice.org/core/commit/d7bcf59a51a058ba57e685cfc3e000fec623f716 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: 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!