Bug 53428

Summary:	Conditional FORMATTING cell references always absolute
Product:	LibreOffice	Reporter:	asierdelpozo
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	LibreOffice, markus.mohrhard, michael.meeks
Priority:	medium	Keywords:	regression
Version:	3.6.0.0.beta2
Hardware:	Other
OS:	All
Whiteboard:	BSA (target:3.6.1)
Crash report or crash signature:		Regression By:
Attachments:	Sample Document

Description asierdelpozo 2012-08-13 04:06:29 UTC

Problem description: 
I have conditional formatting working in tables with references in 3.5.5 but not in 3.6.0.4. For example, if we have a format when the value of the cell A2 is > than the value of the cell A$23, and we copy - paste the format to the cell B2, then the comparing value is the cell B$23. This does not work in 3.6.0.4.
Another thing is that now it is impossible to select the cell by clicking it.

Steps to reproduce:
1. Apply Conditional format to a cell, with several conditions. They have to be defined in cell values.
2. Copy paste the format to other cells.

Current behavior: It copy - pastes the format but not the condition

Expected behavior: The format must depend on the condition that depends on cell value

Platform (if different from the browser): Windows 7 64 bit

Comment 1 Rainer Bielefeld Retired 2012-08-13 05:12:38 UTC

[Reproducible] with Server Installation of  "LibreOffice 3.6.1.0+  English UI/ German Locale [Build-ID:  b0aac2a] on German WIN7 Home Premium (64bit)  {tinderbox: Win-x86@9, pull time 2012-08-11 00:16:39}:

1. download / Open attached Sampel 0
2. Click A1 (what has cf reference to A$23)
3. <Control+c> for 'Copy'
4. Click B1 
5. Menu 'Edit -> Paste Speckal -> Only formatting -> <ok>
   Expected: Conditional Formatting in B1 Reference to B$23
   Actual: reference still to  A$23
6. Click A1 (what has cf reference to A$23)
7. <Control+c> for 'Copy'
8. Click C1
9.  <Control+v> for Paste
   Expected: Conditional Formatting in B2 Reference to C$23
   Actual: reference still to  A$23

Expected behavior I see with 3.5.6.2
Expected behavior I see with parallel installation of Master "LOdev  3.7.0.0.alpha0+   - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 7d8cd0a]" {tinderbox: 2008R2@20, pull time 2012-08-10 23:27:17}, so fixed for Master

Was already broken with Server Installation of  "LibreOffice 3.6.0.0.beta2  German UI/Locale [Build-ID: f010139] on German WIN7 Home Premium (64bit) and may be moer early.

@asierdelpozo:
Thank you for your attention!

Comment 2 Rainer Bielefeld Retired 2012-08-13 05:22:58 UTC

Created attachment 65490 [details]
Sample Document

Forgot to mention: worked fine in dailies at least until 2012-May-15

Comment 3 Michael Meeks 2012-08-13 09:18:47 UTC

Rainer - is this 'WORKSFORME' resolution correct ? your comment sounds like you confirmed an issue in 3.6.0 ? :-)

Comment 4 Rainer Bielefeld Retired 2012-08-13 10:07:22 UTC

@Michael:
Yes, WFM is intended, because the bug is no longer reproducible in 3.6 branch and 3.7

But my versions listing is complete nonsense, thank you for the hint:

Problem *IS* reproducible with Server Installation of  "LibreOffice 3.6.0.4  German UI/Locale [Build-ID:  932b512] on German WIN7 Home Premium (64bit) 

but

the problem *is no longer* reproducible 
- with Server Installation of  "LibreOffice 3.6.1.0+  English UI/ German Locale [Build-ID:  b0aac2a] on German WIN7 Home Premium (64bit) {tinderbox: Win-x86@9, pull time 2012-08-11 00:16:39}
- with 3.7 Master

Please excuse me for the negligence!