https://bugs.freedesktop.org/show_bug.cgi?id=86253
Bug ID: 86253
Summary: Copying & paste special / Paintbrush of conditional
formatting applies wrong range
Product: LibreOffice
Version: 4.3.4.1 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109414
--> https://bugs.freedesktop.org/attachment.cgi?id=109414&action=edit
test ods file with conditional formatting for A1:C6
Steps to reproduce:
1. Download and save the attached test ods file. This file contains conditional
formatting in cells A1:A6. You can observe the conditions by going to "Format -
Conditional Formatting - Manage".
2. Open the saved file, then either:
* Copy A1, then paste special only "formatting" to C1; or
* Select A1, click the paintbrush, then apply to C1.
--> Conditional formatting is correctly applied to C1. A new formatting
condition is created with the range "C1". This is expected.
3. But, if you do the following:
* Copy A1, then paste special only "formatting" to C1:C17; or
* Select A1, click the paintbrush, then apply to C1:C17.
--> Cell formatting for C1:C17 is changed. But, if you go to "Format -
Conditional Formatting - Manage", you will see that a new formatting condition
is created with the range "C1:C6", rather than "C1:C17". This is wrong
behavior.
4. Further, if you save the file modified by step 3, then reopen, you see that
cell formatting for C7:C17 are lost. (Of course this is because of the wrong
behavior as discussed above in step 3.)
Version: 4.4.0.0.alpha2+
Build ID: c1358e5dc875bb923f4b5472ba615ebd19f0d057
Fedora 20 X64.
Also reproducible with
4.3.4.1
Build ID: bc356b2f991740509f321d70e4512a6a54c5f243
xubuntu 14.04 64bit
I see that the main codes for conditional formatting is at:
http://cgit.freedesktop.org/libreoffice/core/tree/sc/source/core/data/conditio.cxx
and the recent changes to this file is:
http://cgit.freedesktop.org/libreoffice/core/log/sc/source/core/data/conditio.cxx
Not much changes to this source file, so it may be easier to find the bad
commit.
(This bug was first reported at the Chinese LibreOffice discussion forum and
was confirmed:
http://www.libreofficechina.org/thread-774-1-1.html
--
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
