Bug 113370

Summary: Copying a row temporarily disables Conditional Formatting.
Product: LibreOffice Reporter: mrelwood
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 4.0.0.3 release   
Hardware: All   
OS: macOS (All)   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=109280
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 87351    
Attachments: A spreadsheet to show the issue.

Description mrelwood 2017-10-23 00:10:36 UTC 
Description:
Copying a row looks like it doesn't copy the conditional formattings, but if:
- select menu item File > Reload, or
- the spreadsheet is saved and reopened, or
- if visiting any conditional formatting rule for editing,
the conditional formattings are then shown correctly.

For visiting any cconditional formatting rule, it is enough to:
- Menu: Format > Conditional Formatting > Manage, double-click a condition, "OK", "OK".

Copying two or more rows, or a column doesn't have this issue.

Steps to Reproduce:
1. Create a conditional formatting.
2. Enter data that shows conditional formatting.
3. Copy (Cmd C + Cmd V, or Alt Drag) the single row where you entered data.

Actual Results:  
The copied row appears as if no conditional formattings were in place.

Expected Results:
The conditional formattings should show up right away, without reopening the spreadsheet or editing conditional formattings.


Reproducible: Always

User Profile Reset: Yes. Happens on a new install.

Additional Info:
This issue has been there for a long time, so I don't remember the earliest version I saw this bug in. It is still relevant in 5.3.6.1 and 6.0.0.0.alpha0+ (17.Sept.2017).


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.102 Safari/537.36 Vivaldi/1.94.971.8
Comment 1 mrelwood 2017-10-23 00:12:44 UTC 
Created attachment 137220 [details]
A spreadsheet to show the issue.

This spreadsheet has conditional formatting in place, and a guide how to reproduce the issue.
Comment 2 Alex Thurgood 2017-10-23 11:59:46 UTC 
Confirming with

Version: 6.0.0.0.alpha0+
Build ID: 0ad8447d3199e1c1d1f7d6ddabc9b4cded99c2d6
CPU threads: 4; OS: Mac OS X 10.13; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2017-10-19_07:06:36
Locale: fr-FR (fr_FR.UTF-8); Calc: group
Comment 3 Alex Thurgood 2017-10-23 12:04:46 UTC 
Looks like a DUP of bug 109280
Comment 4 QA Administrators 2018-10-24 02:57:49 UTC Comment hidden (obsolete)
Comment 5 eisa01 2020-05-09 22:11:47 UTC 
Yes, this works and was a dupe

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