** Description changed: Binary package hint: openoffice.org-calc - The OpenOffice.org 2.4.0 Calc Conditional Formatting does not work - properly in certain cases of absolute and relative addressing. This - occurres when adding rows or columns that affect the address of a cell - or cells that are part of a conditional formatting located below - inserted line(s) or to the right of inserted column(s). + 1) lsb_release -rd + Description: Ubuntu 11.04 + Release: 11.04 - One example is when the value of a cell (below referred to as B2) - affects the conditional format of another cell below row 2 (cell used - here was B4). + 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 - Adding a row above row 2 gives the result: + 3) What is expected to happen with LibreOffice Calc via the Terminal: - * $B$2 becomes $B$3 - correct - * $B2 becomes $B3 - correct - * B$2 remains B$2 - incorrect, should become B$3 - * B2 becomes B3 - correct + 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' - Adding a row between row 2 and 4 gives the result: + place the cursor in row 12 -> Insert -> Row and all the rows move down, + and the highlighting does not change. - * $B$2 remains $B$2 - correct - * $B2 becomes $B3 - incorrect, should remain as $B2 - * B$2 remains B$2 - correct - * B2 becomes B3 - incorrect, should remain as B2 + 4) What happens instead is B13 and D13 lose their highlighting. - Similar deficiencies exist when adding columns left to and between - involved cells. - - Thus, the relations should survive such changes. - - - Ubuntu release: - 8.04 LTS - - Product: - OpenOffice.org 2.4.0 Calc - - Package: - openoffice.org - Version: 1:2.4.0-3ubuntu6 + Original Reporter Comments: Ubuntu 8.04 LTS OpenOffice.org Calc Version: + 1:2.4.0-3ubuntu6
** Tags added: lo33 ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Medium ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Triaged ** Summary changed: - [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions + [upstream] [hardy] Calc Conditional Formatting - Incorrect cell references after line or column insertions -- 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] Calc Conditional Formatting - Incorrect cell references after line or column insertions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs