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
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.
> 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?
Should be fixed in 4.0.3 or 4.0.4.
(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.
Fixed in the latest stable release (4.0.3).
setting target as per Comment 5.