Bug 156626

Summary: CF Colorscale | Databar - Issue with merged Cells
Product: LibreOffice Reporter: Werner Tietz <werner-tietz>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: buzea.bogdan, l28-2, miguelangelrv, werner-tietz
Priority: medium    
Version: 7.5.5.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 87351    
Attachments: Calc-Document which shows the Issue

Description Werner Tietz 2023-08-05 08:05:32 UTC 
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
Comment 1 Werner Tietz 2023-08-05 08:08:06 UTC 
Created attachment 188789 [details]
Calc-Document which shows the Issue
Comment 2 m_a_riosv 2023-08-05 09:50:32 UTC 
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.