Bug 90475 - FORMATTING: conditional formatting of an area does not work on the column that contains the condition
Summary: FORMATTING: conditional formatting of an area does not work on the column tha...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.6.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-04-06 09:10 UTC by Aldo
Modified: 2015-04-06 15:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example of conditional formatting on a cell area (57.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-04-06 09:10 UTC, Aldo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Aldo 2015-04-06 09:10:41 UTC 
Created attachment 114643 [details]
Example of conditional formatting on a cell area

With fewer than 1 in a cell in the column ' J ' the entire row should change color. Its cell in the column J does not change.
Comment 1 m_a_riosv 2015-04-06 15:15:37 UTC 
Hi Aldo, thanks for reporting.
 
In the conditions there is a range for comparison, this is the mistake, put only $J2 for both conditions instead $J2:$J10 and it works fine, is the CF A2:AE10 that does the work for the whole rows.