[Libreoffice-bugs] [Bug 133027] LO Calc: Conditional Format formula issue, when you "cut-paste" the conditionally formatted cell range into another overlapping range.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133027

--- Comment #14 from b. <newbie-02 at gmx.de> ---
there are atomic fails, at least two: 

1.) one cell with a value, one cell referencing that value for conditional
format, 

moving the referenced! cell by either 'ctrl-x' - 'ctrl-v' or by 'mouse-push'
cleanly adapts the relative referencing in the conditional format formula, ok, 

moving the referencing! cell either by ctrl-x ctrl-v or by 'mouse-push' does
not! adapt the relative referencing in the conditional format formula, not ok, 

(the reference points to a new cell with identical relative position to the
moved cell as the old 'target', behaviour as it should be for copying! the
referencing cell), 

2.) (may result from above) moving a range of cells containing as well the
conditional formatted cell(s) as the reference(s) for formatting (wich
shouldn't be the cell itself, neither referenced by 'cell value' nor by a
formula pointing to itself), to an 'overlapping position' (mostly) adapts the
formatted range and the relative formula by double the value of the move, with
the funny side effect that on move left or down it is evaluated acc. the new
wrong references and thus fails, but on move right or up the evaluation is also
erroneous and the result looks good ... only looks but isn't as the formula is
wrong (see attached screenshot), and as the construction doesn't survive
save-load, 

tested with 7.1.0 alpha win7x64, 

history: ver. 3.5.1.2 didn't adapt relative referencing in any way, 4.1.6.2 did
but already has both above fails (a little different as it has different
handling for grouping of formattings), 

i admit ... programming such stuff is challenging, estimate working with parts
of formatted ranges, or parting / breaking referenced ranges ... 

boiled down, now it only needs an interested dev ...

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201031/3f65e1d9/attachment.htm>