https://bugs.documentfoundation.org/show_bug.cgi?id=106230
Bug ID: 106230
Summary: FORMATTING: Conditional formatting lost while copy +
paste (on 1st sheet only)
Product: LibreOffice
Version: 5.3.1.1 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
There is a problem with conditional formatting at copy + paste of more than one
cell on the first or unique sheet of a spreadsheet document.
When a complete row should be copied to an other row and the first cell of the
row to copy is without conditional formatting, after (standard) paste in the
target row all conditional formatting is lost. This is visible via Conditional
formatting -> Manage: The target row doesn't appear as area!
See attached files "altix_Nummern_klein_Rows_copied.ods" and
"altix_Nummern_klein_V2_Rows_copied.ods": rows 21 in sheet "Altix I bis III"
resp. "Altix IV und V"!
The problem doesn't occur on the second and following sheets.
See attached files "altix_Nummern_klein_Rows_copied.ods" and
"altix_Nummern_klein_V2_Rows_copied.ods": e.g. row 9 sheet "Altix n und nb"!
It also not occurs when only single cells are copied with (standard) paste and
with "Paste special" ("Inhalte einfügen"), when all except formats is pasted.
One can use this as workaround.
Steps to Reproduce:
1. open one of the files "altix_Nummern_klein.ods" or
"altix_Nummern_klein_V2.ods" from the attached zip-File
2. go to the first sheet ("Altix I bis III" resp. "Altix IV und V")
3. insert a row before row 21
4. copy row 20 and paste it to row 21
Actual Results:
Color of cell B21 is black, cell B21 is missing in the area of Conditional
formatting (Conditional formatting -> Manage)
Expected Results:
- Row 21 should look like row 20, that means color of cell B21 should be red
because of conditional formatting
- cell B21 should appear in the area of Conditional formatting (Conditional
formatting -> Manage)
Reproducible: Always
User Profile Reset: No
Additional Info:
Behavior reproducible with LO 5.3.0 (release), LO 5.3.1 (rc1) and with
Version: 5.4.0.0.alpha0+
Build-ID: 08750abc64a7ad82cac96adeb7a0bcdce7ac704d
CPU-Threads: 2; BS-Version: Windows 6.2; UI-Render: Standard;
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2017-02-28_00:02:28
Gebietsschema: de-DE (de_DE); Calc: group,
but not with LO 5.2.5 (release) and with LO 5.2.6.1 (rc1)!
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:51.0) Gecko/20100101
Firefox/51.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
