https://bugs.freedesktop.org/show_bug.cgi?id=57486

          Priority: medium
            Bug ID: 57486
          Assignee: [email protected]
           Summary: FORMATTING When moving cells inside conditional
                    formatting range, CF rules breaks apart
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: UNCONFIRMED
           Version: 3.6.0.0.alpha1
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 70523
  --> https://bugs.freedesktop.org/attachment.cgi?id=70523&action=edit
Test document - one CF range splits apart after moving data

Hi

In attached document, there is conditional formatting applied to cells A1:B17.
Steps to reproduce:
1. Select cells A9:B17
2. Cut them (Ctrl+X)
3. Place cursor in cell A8
4. Paste (Ctrl+V)
5. Go to Format → Conditional formatting → Manage...

You will see that there are two conditional formatting ranges: A1:B7 and
A8:B16. Since conditional formatting rules are the same in both cases, this
could (and should) be just A1:B16.

If user now decide to modify CF rule, he must modify it in two places instead
of just one.

Of course this is simplified case of this bug. On larger datasets a moment of
moving data back and forth can create dozens ranges of the same CF rules.

This problem exists since introduction of modified CF dialogs in 3.6.0 and I
can still reproduce it in 3.6.4-rc1.

-- 
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

Reply via email to