Bug 83813 - FORMATTING: Format painter clears conditional formatting for some sheets
Summary: FORMATTING: Format painter clears conditional formatting for some sheets
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-13 09:12 UTC by B.J. Herbison
Modified: 2014-11-10 02:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Sheet demonstrating the described problem. (14.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-09-13 09:12 UTC, B.J. Herbison 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description B.J. Herbison 2014-09-13 09:12:27 UTC 
Created attachment 106209 [details]
Sheet demonstrating the described problem.

Problem description: 

Steps to reproduce:
1. Load the attached file Conditional.ods.
2. Delete the value of cell A1.
3. Undo the delete in step 2.
4. Select cell A2, click the format painter, click cell A2.
5. Delete the value of cell A1.

Current behavior:
2. Cell A2 turns red.
5. Cell A2 does not turn red.

Expected behavior:
2. Cell A2 turns red.
5. Cell A2 turns red.

I wasn't able to reproduce this problem with a new file (in one attempt), but I see it in existing files. The attached file was creating by copying a sheet from an existing file to a new file, deleting all but two cells, and changing the values.
Operating System: Ubuntu
Version: 4.3.1.2 release
Comment 1 m_a_riosv 2014-09-13 11:35:10 UTC 
Reproducible
Win7x64
Version: 4.3.1.2 Build ID: 958349dc3b25111dbca392fbc281a05559ef6848
Comment 2 ign_christian 2014-09-13 13:18:33 UTC 
(In reply to comment #0)
> I wasn't able to reproduce this problem with a new file (in one attempt),
> but I see it in existing files. The attached file was creating by copying a
> sheet from an existing file to a new file, deleting all but two cells, and
> changing the values.
Possibly it's because Bug 81611. I still saw CF issue in pasted sheet with LO 4.3.2.1
Comment 3 B.J. Herbison 2014-09-13 15:00:03 UTC 
No, the good news is whenever I copy the existing fields to a new sheet the conditional formatting (and bad behavior) is copied. No sign of bug 81611/bug 82503 for me.

What I was hoping to do, but failed, is start with a brand new blank .ods file and create a series of steps to reproduce this issue.
Comment 4 raal 2014-10-19 18:12:18 UTC 
Unable to reproduce with Version: 4.3.4.0.0+
Build ID: afd19a5ee99b1855bc2c2a48a29d2da16be883d1
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-3, Time: 2014-10-10_01:47:41

2. Cell A2 turns red.
5. Cell A2 turns red.

Seems to be fixed in dev version..
Comment 5 B.J. Herbison 2014-11-10 02:33:53 UTC 
Updated to Version: 4.3.3.2 and the problem no longer exists.