[Libreoffice-bugs] [Bug 37987] FORMATTING EDITING Calc Conditional Formatting - Incorrect cell references after line or column insertions

[bugzilla-daemon at freedesktop.org]

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

--- Comment #8 from Winfried Donkers <osc at dci-electronics.nl> 2012-01-04 22:49:37 PST ---
(In reply to comment #7)
> This is not related to bug 42261 or bug 44383.
> 
> The problem originates from how conditional formats are implemented, one
> conditional can be applied to multiple cells, when moved around they behave
> like named ranges and relative references are not updated but applied to the
> then current position instead.
> 
> There's no easy fix for this; splitting conditionals and creating duplicates to
> be updated could be a possibility, somewhat similar to how internal shared
> formulas are treated.

I understand the why now, but I fear that the average user will not understand
this. In his/her view the conditional formatting of cell(s) is damaged when
inserting row(s)/column(s).

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