[Libreoffice-bugs] [Bug 52410] Conditional Formatting of rows does not work if cell contains formula

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52410

Roman Eisele <bugs at eikota.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #7 from Roman Eisele <bugs at eikota.de> 2012-08-04 19:52:41 UTC ---
REPRODUCIBLE with the reporter's sample file (attachment 65112) and
* LibreOffice 3.5.5.3 (Build ID: 7122e39-92ed229-498d286-15e43b4-d70da21) and
* LibreOffice 3.6.0.4 (Build ID: 932b512),
both with German langpack installed and both on MacOS X 10.6.8 (Intel).

(In reply to comment #5)
> All cells which do not have a formula are affected (A, B, C). As soon as I
> enter a date in column A the formatting for that cell is lost. The same happens
> if I enter values into columns B and C. As soon as I have entered a value unto
> a cell in column C, the calculation for columns D to J is done and for these
> cells the formatting remains correct.

I can confirm this.

If I open the sample file, everything looks correct -- even data rows (4, 6,
etc.) have a white background, and odd (5, 7, etc.) data rows have a grey
background. But as soon as I try to add another row by entering a date into
column A or currency numbers in column B or C, the cell gets a white
background, regardless of the current row. This does not even change if I save,
close, and open again the file: the cells still have a white background.
However,
-- the background of the cells with formulas (column D to J)
   calculated automatically is correct, even in new rows;
-- if I try to change the contents of any cell from A4 to C13,
   which already contain the correct background color,
   the background color remains correct.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.