Bug 69064

Summary: Change formula Conditional formatting
Product: LibreOffice Reporter: Fabio <fabio1.servizio>
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: barta
Priority: medium    
Version: 4.0.5.2 release   
Hardware: All   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Procedure to see the bug
Procedure to see the bug

Description Fabio 2013-09-07 09:10:45 UTC
Created attachment 85389 [details]
Procedure to see the bug

Cut and paste a cell.
The formula of the conditional formatting neighboring cell is changed.
Comment 1 Fabio 2013-09-07 09:21:32 UTC
Created attachment 85390 [details]
Procedure to see the bug
Comment 2 Dominique Boutry 2013-10-20 15:48:17 UTC
NotABug... Here is what happens :
- to better understand, fill cell F7 with the formula "=B7"
- when you cut a cell and paste it in another place, LibO processes it like a move ; Previous reference to the source place are updated with the destination place. So in our case, B7 references are replaced with D7 ; see how it occurs in F7
- The "B7" in the conditional formatting of C7 is also replaced by D7, and D7 contains "A" at the end of the scenario, hence the right color.
Comment 3 tommy27 2013-11-23 03:44:00 UTC
I mark it as RESOLVED NOTABUG according to previous comment