Bug 52300 - FORMATTING: "Conditional formatting Formula is" applies absolute references
Summary: FORMATTING: "Conditional formatting Formula is" applies absolute references
Status: RESOLVED DUPLICATE of bug 52565
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.2 rc
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-20 09:57 UTC by pierre-yves samyn
Modified: 2012-07-27 21:05 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
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 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 ***