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
Created attachment 131533 [details] zip-File with 4 spreadsheets to reproduce the error zip-File with 4 spreadsheets to reproduce resp. demonstrate the error: - altix_Nummern_klein.ods - altix_Nummern_klein_Rows_copied.ods - altix_Nummern_klein_V2.ods - altix_Nummern_klein_V2_Rows_copied.ods
Regression introduced by 8a11d34c7e08218b5ff9da4870c460297f312332 Closing as RESOLVED DUPLICATED of bug 106242 *** This bug has been marked as a duplicate of bug 106242 ***