https://bugs.freedesktop.org/show_bug.cgi?id=60521
Priority: medium
Bug ID: 60521
Assignee: [email protected]
Summary: FORMATTING
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
