[Libreoffice-bugs] [Bug 52410] New: Conditional Formatting of rows does not work if cell contains formula
bugzilla-daemon at freedesktop.org
bugzilla-daemon at freedesktop.org
Tue Jul 24 05:34:45 CEST 2012
https://bugs.freedesktop.org/show_bug.cgi?id=52410
Bug #: 52410
Summary: Conditional Formatting of rows does not work if cell
contains formula
Classification: Unclassified
Product: LibreOffice
Version: 3.5.5.3 release
Platform: All
OS/Version: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
AssignedTo: libreoffice-bugs at lists.freedesktop.org
ReportedBy: jean-paul.hahn at gmx.net
To reproduce:
1. Create a new spreadsheet.
2. Select a certain range and the select Format, Conditional Formatting ...
3. Enter as first condition: ISEVEN(ROW()) and select a yellow background
4. Enter as second condition:ISODD(ROW()) and select a green background
Up to now everything looks fine and you've got rows colored alternately in
yellow and green.
5. Now enter a formula in any on of the colored cells, e.g.
=IF(ISBLANK(C9);"";MIN(Kurs))
6. the corresponding cell looses it's color; the conditional formatting doesn't
work any more
7. Delete the formula. Now the colur reappears.
Please fix this bug because else I (and all others) have to color cells
containing formulas manually.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
More information about the Libreoffice-bugs
mailing list