Bug 113370 - Copying a row temporarily disables Conditional Formatting.
Summary: Copying a row temporarily disables Conditional Formatting.
Status: RESOLVED DUPLICATE of bug 109280
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Mac OS X (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2017-10-23 00:10 UTC by mrelwood
Modified: 2020-05-09 22:11 UTC (History)
0 users

See Also:
Crash report or crash signature:

A spreadsheet to show the issue. (14.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-10-23 00:12 UTC, mrelwood

Note You need to log in before you can comment on or make changes to this bug.
Description mrelwood 2017-10-23 00:10:36 UTC
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 and (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

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 ***