Bug 65449 - FORMATTING: Condtitional formatting breaks on moving cells with relative reference
Summary: FORMATTING: Condtitional formatting breaks on moving cells with relative refe...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA target:4.0.3
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-06-06 09:47 UTC by Thomas Pulzer
Modified: 2013-06-27 10:09 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Pulzer 2013-06-06 09:47:48 UTC
Problem description: 
If you have a cell as a relative reference for a conditional formatting, after inserting a line above the cell with the conditional formatting, it increments the column by 2 instead of 1

Steps to reproduce:
1. Enter value 1 in C6
2. Assign a conditional formatting to cell D6, saying: Formula equals $Tabelle1.C6=1
Assign an arbitrary template to the formatting
3. Insert a row above D6
4. Check conditional formatting on D6, it will now have the    condition Formula equals $Tabelle1.C8=1

Current behavior:
The column reference is incremented by one on inserting one row above the formatted cell

Expected behavior:
The column reference is incremented by two on inserting one row above the formatted cell

              
Operating System: All
Version: 4.0.1.2 release
Last worked in: 3.5.7.2 release
Comment 1 ign_christian 2013-06-06 14:31:16 UTC
Not reproducible on LO 4.0.4.1 (Win7 32bit)

Could you test using latest stable release (3.6.6 or 4.0.3)? Perhaps it's been fixed.
Comment 2 ign_christian 2013-06-06 14:33:11 UTC
> Current behavior:
> The column reference is incremented by one on inserting one row above the
> formatted cell
> 
> Expected behavior:
> The column reference is incremented by two on inserting one row above the
> formatted cell

Maybe you mean the opposite behavior?
Comment 3 Markus Mohrhard 2013-06-06 20:06:19 UTC
Should be fixed in 4.0.3 or 4.0.4.
Comment 4 Thomas Pulzer 2013-06-07 06:01:18 UTC
(In reply to comment #2)
> > Current behavior:
> > The column reference is incremented by one on inserting one row above the
> > formatted cell
> > 
> > Expected behavior:
> > The column reference is incremented by two on inserting one row above the
> > formatted cell
> 
> Maybe you mean the opposite behavior?

Indeed, it is the opposite around. But it's already fixed in the latest stable release. Thank you.
Comment 5 Thomas Pulzer 2013-06-07 06:03:12 UTC
Fixed in the latest stable release (4.0.3).
Comment 6 Björn Michaelsen 2013-06-27 10:09:25 UTC
setting target as per Comment 5.