Description: The Color|DataBar is only applied to the Top-Row of **merged Cells** in a Conditional-Format-Range Steps to Reproduce: 1. Fill a Range with Numbers 2. Apply →Format→ConditionalFormat→→Colorscale ( or →→Databar ) 3. Merge some Cells with neighbour-Cells right **and** below Actual Results: The Color|Databar appears only on the Top-line of merged Cells Expected Results: …It should be fill the whole merged Cell Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.4.2 Build ID: 00(Build:2) CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Raspbian package version: 1:7.0.4-4+rpi1+deb11u6 Calc: threaded See also: https://ask.libreoffice.org/t/merged-cell-and-conditionnal-formating-background-fill-only-on-the-upmost-cell/94340
Created attachment 188789 [details] Calc-Document which shows the Issue
Not clear to me how it should be the right behavior. Because hidden cells can have their own value. So for me, it should work: - Extended the result of CF to all merged cells only if the first cell has a value and the rest are blank. - Otherwise, if they are in the CF range, every hidden cell should be treated as independent. In any case, now looks like a bug.