Bug 52300

Summary: FORMATTING: "Conditional formatting Formula is" applies absolute references
Product: LibreOffice Reporter: pierre-yves samyn <pierre-yves.samyn>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: medium    
Version: 3.6.0.2 rc   
Hardware: Other   
OS: All   
Whiteboard: BSA
Crash report or crash signature: Regression By:

Description pierre-yves samyn 2012-07-20 09:57:52 UTC 
Hello

Steps to reproduce:

1. File> New> Spreadsheet
2. Enter 1, 2, 3 respectively A1, A2, A3
3. Enter a, b, c respectively B1, B2, B3
4. Select B1:B3
5. Format> conditionnal formatting> conditionnal formatting> Add :
- Condition : Formula is
- Formula : A1=2
- Style : select or create one
6. Ok

Expected result : B2 applies the conditional format
Actual result : not...

7. Select B2 then Format> conditionnal formatting> conditionnal formatting, click "1"

The formula used is : A1=2, this should be A2=2

Note: select B2 and define conditional formatting with "formula is" : A2=2 does not work either

Platform: windows 7 64bits & Version 3.6.0.2 (Build ID: 815c576)

Reproduced (fr-discuss) with beta3 and RC1

Regards
Pierre-Yves
Comment 1 Markus Mohrhard 2012-07-27 21:05:27 UTC 

*** This bug has been marked as a duplicate of bug 52565 ***