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

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 133027
           Summary: LO Calc: Conditional Format formula issue, when you
                    "cut-paste" the conditionally formatted cell range.
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kovacs.tibor64 at gmail.com

Description:
When you "cut-paste" the conditionally formatted cell range, the reference of
the CF formula go wrong. Using relative references, the formula must populate
"paralell" with the distance of the "cut place" and the "paste place". But it
not work properly.

Steps to Reproduce:
See the attachment.
1. The red cell E8 was formatted by CF formula with relative reference in the
condition: D8=1. The name of the applied Cell Style is „Error”.
2. Then the yellow and the red cell have been copied down to D17.
3. Check the setting of the CF in the Manage Conditional Format feature: The CF
formula and range have been integrated into one condition – as it is expected.
4. Select, Cut and then Paste the colorized block (D8:E17) down by some rows.
(if you move the range less than 10 rows down you will prompt see the strange
behavior) 
5. Check again the formula of the CF
6. You will see: the reference of the CF formula changed by double value
relative to the distance of the „paste location-original place”


Actual Results:
the CF formula changed by double value relative to the distance of the „paste
location-original place”

Expected Results:
the CF formula must be changed same value relative to the distance of the
„paste location-original place”


Reproducible: Always


User Profile Reset: No



Additional Info:
The attached file was created in the LO 6.4.3 winPenPack portable version, but
the issue is present in my permanently installed LO 6.2.8 and the LO 6.1.6 too.

-- 
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/20200514/25402662/attachment.htm>