Bug 106230 - FORMATTING: Conditional formatting lost while copy + paste (on 1st sheet only)
Summary: FORMATTING: Conditional formatting lost while copy + paste (on 1st sheet only)
Status: RESOLVED DUPLICATE of bug 106242
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2017-02-28 12:40 UTC by Stefan_Lange_KA@T-Online.de
Modified: 2017-03-02 11:47 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
zip-File with 4 spreadsheets to reproduce the error (438.30 KB, application/x-zip-compressed)
2017-02-28 12:45 UTC, Stefan_Lange_KA@T-Online.de
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan_Lange_KA@T-Online.de 2017-02-28 12:40:15 UTC
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
Comment 1 Stefan_Lange_KA@T-Online.de 2017-02-28 12:45:16 UTC
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
Comment 2 Xisco Faulí 2017-03-02 11:47:59 UTC
Regression introduced by 8a11d34c7e08218b5ff9da4870c460297f312332
Closing as RESOLVED DUPLICATED of bug 106242

*** This bug has been marked as a duplicate of bug 106242 ***