[Libreoffice-bugs] [Bug 141580] New: Copy of "Conditional Formatting" pastes old reference cell, not relative new cell

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Apr 9 07:52:08 UTC 2021


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

            Bug ID: 141580
           Summary: Copy of "Conditional Formatting" pastes old reference
                    cell, not relative new cell
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gurkan at gmail.com

Description:
Let us say A1 has a Conditonal Formatting and the First (and only) condition
refers to the value in A2.

If you copy Column A to Column B, B1's Conditional Formatting still refers to
the value in A2, not B2.

Whether you code the first condition reference statically ($Sheet.$A$2), or not
(A2) does not change the result. B1's Conditional Formatting always refers to
A2.

Steps to Reproduce:
1. Already in Description
2.
3.

Actual Results:
Already in Description

Expected Results:
Already in Description.
B1's conditional formatting must refer to B2, if A1's Conditional Formatting is
referring to the Cell Value of A2.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no

-- 
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/20210409/4214d888/attachment-0001.htm>


More information about the Libreoffice-bugs mailing list