Bug 53428 - Conditional FORMATTING cell references always absolute
Summary: Conditional FORMATTING cell references always absolute
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.0.beta2
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA (target:3.6.1)
Keywords: regression
Depends on:
Blocks:
 
Reported: 2012-08-13 04:06 UTC by asierdelpozo
Modified: 2012-08-13 10:07 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample Document (8.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-13 05:22 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
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!