https://bugs.documentfoundation.org/show_bug.cgi?id=90025
Bug ID: 90025
Summary: Copying conditionally formatted cells
Product: LibreOffice
Version: 4.4.1.2 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'd like to propose an enhancement to handling conditionally formatted cell
ranges when cells are copied.
Example: Cell range B2:B10 is conditionally formatted. The list delivered by
"Format\Conditional Formatting\Manage..." has a single entry for B2:B10.
Current behavior:
a) Copying inside the same CF range: When cell B4 is copied to B8, the CF range
is split into three independent ranges (B2:B7, B8, and B9:B10) with the exact
same conditional formatting.
b) Copying from within the CF range to the outside: When cell B4 is copied to
D4, an new CF range is created for D4 with the exact same conditional
formatting.
Proposed behavior:
a) When cells from within the range are copied to a destination that is also
within the same existing CF range, the range should remain exactly as is. In
the above example, there would be a single CF range "B2:B10" even after the
copying.
b) When cells from within the range are copied to a destination outside the
range, the existing CF range should be extended to include the destination. In
the above example, there would be a single CF range "B2:B10;D4" after the
copying.
The principle could then be extended to copying multiple cells or cell ranges,
and maybe the corner case where the destination range partly overlaps with the
original CF range. In effect, splitting CF ranges into independent smaller
ranges with identical formatting should be avoided wherever possible.
--
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
