Bug 145713

Summary:	CALC - conditional formatting changes only a part of a merged area
Product:	LibreOffice	Reporter:	Frank <fpwerkstatt>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	buzea.bogdan, miguelangelrv
Priority:	medium
Version:	7.2.2.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	87351
Attachments:	Screenshot of the incorrect formatting Evaluation of gas- water- and electricity consumption by coloring

Description Frank 2021-11-16 09:26:00 UTC

Description:
A merged area (A16:D19) is to be changed in color by conditional formatting. The conditions are trivial: threshold values 8 green, 10 yellow, 15 red. The condition is correctly implemented, but the color change is executed only for the first line (here A16:A19) instead of for the entire range A16:D19.

Steps to Reproduce:
1.Merge  some cells
2.type in a number
3.set up conditions for format with different colours


Actual Results:
colours will be changed for the first Line of cells only 

Expected Results:
people usually expect that all the merged cells will be changed by cond. formatting


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

Comment 1 Frank 2021-11-16 09:32:52 UTC

Created attachment 176279 [details]
Screenshot of the incorrect formatting

Comment 2 m_a_riosv 2021-11-16 21:30:00 UTC

Please attach a sample file to test.

Comment 3 Frank 2021-11-17 08:01:57 UTC

Created attachment 176306 [details]
Evaluation of gas- water- and electricity consumption by coloring

The conditional formatting is located in the table 'Dashboard' over the cells A16:D19. In order to be able to test the formatting, a corresponding value for the current date is expected in each of the tables 'WATER_Data' 'GAS_Data' or 'CURRENT_Data'.

Comment 4 m_a_riosv 2021-11-17 17:38:40 UTC

Seems CF it's not working fine.
For row 16 A16:D16 applies the CF even B16:D16 are empty, but not for the other rows of the merged cells.
Adding a formula like =a16 in A17:D19, applies the CF in B16:D16 and A17:A19, which not sound very consistent.

You can work around, while the bug exist by filling A17:A19~B16:D19 with a formula =A16, and merging keeping the values in hidden cells.

Comment 5 Tibor Nagy 2023-07-25 09:47:52 UTC


*** This bug has been marked as a duplicate of bug 155322 ***