Bug 60521

Summary:	Conditional formatting reference errors when copy/paste special cells
Product:	LibreOffice	Reporter:	maxhvargasdiez
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	jmadero.dev, LibreOffice
Priority:	medium
Version:	4.0.0.3 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description maxhvargasdiez 2013-02-08 22:34:32 UTC

CONDITIONAL FORMATTING REFERENCE ERRORS WHEN COPYING PASTE SPECIAL CELLS
lets say I have the following conditional formattingformula in cell D20:

AND(D20<0,A20<>"x")

if this condition is true then D20 turns red

now I copy this cell and paste it into D21 and D22 (only format paste special)

Surprise!

in D21 I get:

AND(D22<0,A21<>"x")

and more surprise, in D22 I get:

AND(D24<0,A22<>"x")

The right formulas should have been:
in D21:   AND(D21<0,A21<>"x")
in D22:   AND(D22<0,A22<>"x")

If you have only one condition in a formula like IF(A20<>"x") the paste has no bug, but you can't paste formulas with more than one condition!

I hope this helps

regards,

Maximo

Comment 1 Joel Madero 2013-02-11 05:23:35 UTC

Please attach a document so we can test this out. Marking as NEEDINFO, once the attachment is made please set bug to UNCONFIRMED and we'll take a look at it.

Comment 2 Rainer Bielefeld Retired 2013-02-20 05:34:33 UTC

I did not get working the CF, but I see the wrong references. Known problem, DUP of "Bug 60311 - EDITING: Copy cells with CONDITIONAL FORMATTING formula with wrong references after paste"

@maxhvargasdiez:
Please feel free to reopen this Bug if you find evidence that we have an independent issue here  (for example because the fix for the other bug does not work for you).

*** This bug has been marked as a duplicate of bug 60311 ***