https://bugs.documentfoundation.org/show_bug.cgi?id=100793
Bug ID: 100793
Summary: FORMATTING - conditional formatting gets corrupted
upon copy/paste/insert
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: thms.mae...@gmail.com
Created attachment 126095
--> https://bugs.documentfoundation.org/attachment.cgi?id=126095&action=edit
Screen shots of conditional formatting edit dialogs
Upon copying/pasting within a range, some conditional formatting ranges get
corrupt, and can no longer be changed.
Bug - pages (attachment) & comments
1) Original "clean" file - see ranges C10:190, D10:D190 and E10:F190
2) Modified file (copy/paste whole lines only)
--> range C10:C190 is still clean, but D & E-F are now corrupt
3) Try to correct for D - open dialog
4) …enter correct range D10:D190 & click OK
5) …and change unsuccessful - range stays the same at D78:D190, D10:D73
Workaround:
6) Copy/paste line from original clean file: entries for C74, D74 & E74:F74
7) Changed C74 to C10:C190, then deleted original C75:C190,C10:C73 -> OK!
8) Now deleted bad ranges D78:D190,D10:D73 and E78F190,E10:F73
-> reveals other little bug: they come back if main dialog not closed now
9) Now edit D74
10) …to D10:D190 & click OK
11) Change successful
--> now other little bug: the previously-deleted ranges come back
(as the main dialog was not closed before editing D74)
12) Delete bad range D78:D190,D10:D73 (will come back, as main dialog not
closed)
13) Edit E74:F74
14) …to E10:F190 & click OK
15) Change successful, but bad range D78:D190,D10:D73 comes back, as before
16) So delete bad ranges & close main dialog; reopen: now everything OK
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs