(In reply to comment #8) > I understand the why now, but I fear that the average user will not understand > this. In his/her view the conditional formatting of cell(s) is damaged when > inserting row(s)/column(s).
I must be the average user you mention, because I'm afraid that the current behaviour definitely appears to be buggy to me. To me, cell references used within conditional formatting should mimic the behaviour of cell references used in cell formulas. That is, if a formula (or conditional formatting) refers to another cell and that other cell is moved then the formula (or conditional formatting) should be updated to reflect that. As far as I know cell formulas *always* behave this way. Also, just so not to confuse a separate issue, the use of A1 vs. $A$1 vs. $Sheet1.$A$1 should make no difference to what I said above. So I don't really understand why when a precedent cell is moved that the address used in a conditional format of the dependent cell is not updated just like it is for cell formulas. The behaviour is also not consistent depending on the addressing mode used. Please try again the original test case ( https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods ) Insert a row above row 11, and you should see cells B12 - E12 (now B13 - E13) retain their green formatting. OK so far. Now starting with the original test case again, make the following modification: In cells B12 to E12, change the conditional formatting to _not_ use sheet names. That is remove the prefix $Tabell1. from the conditional formatting test in each. In fact so it looks just like the format documented in row 8. Insert a row above row 11, and C12 & E12 (now C13 & E13) lose their green formatting. So, the $Tabell1. prefix is critical to the behaviour. I think it should have no impact, just as it would not matter when used in a cell formula. I hope that all makes sense. I'm using: LibreOffice 3.5.4.2 Build ID: 165a79a-7059095-e13bb37-fef39a4-9503d18 Windows XP. Thanks for making LO a great product. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/235602 Title: [upstream] [hardy] Calc Conditional Formatting - Incorrect cell references after line or column insertions Status in LibreOffice Productivity Suite: Confirmed Status in The OpenOffice.org Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org-calc 1) lsb_release -rd Description: Ubuntu 11.04 Release: 11.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu5 Candidate: 1:3.3.2-1ubuntu5 Version table: *** 1:3.3.2-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu4 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 3) What is expected to happen with LibreOffice Calc via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/235602/+attachment/321005/+files/Conditional%20formatting%20example.ods && localc -nologo 'Conditional formatting example.ods' place the cursor in row 12 -> Insert -> Row and all the rows move down, and the highlighting does not change. 4) What happens instead is B13 and D13 lose their highlighting. Original Reporter Comments: Ubuntu 8.04 LTS OpenOffice.org Calc Version: 1:2.4.0-3ubuntu6 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/235602/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp