No, it still does not work correctly neither for OO nor LO. Cell references shall act the same way independent of whether they are specified explicilty in the cell itself or by using conditional formatting.
A correct result is that all four cells on row 12 remain green when moved to row 13 after you insert an empty row inbetween row 11 and 12. The references explicitly given in a cell works and you can check the discrepancy further by replacing the absolute values (1) in cells B12-E12 by a reference to its cells above, i.e - contents of cell B12 changed from value 1 to the reference =B11 - contents of cell C12 changed from value 1 to the reference =C$11 - contents of cell D12 changed from value 1 to the reference =$D11 - contents of cell E12 changed from value 1 to the reference =$E$11 thus the same references as stated for conditions formatting. Now if you insert an empty row inbetween row 11 and 12 you will see that the cells now on row 13 all still equals 1 BUT only two of those cells remain green. If correct all those four cells also shall remain green. Running LibreOffice 3.3.2 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/235602 Title: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
