[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
** 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
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
Bowmore, this issue is unreproducible in 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' Inserted a row above row 12 and inserted a column to the left of column 14, the conditionally formatted cell references were not changed. Does this work for you? lsb_release -rd Description:Ubuntu 11.04 Release:11.04 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 ** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Changed in: libreoffice (Ubuntu) Status: New = Incomplete ** Changed in: openoffice.org (Ubuntu) Importance: Medium = Low -- 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 ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
** Tags added: hardy -- [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions https://bugs.launchpad.net/bugs/235602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
** Changed in: openoffice Status: Unknown = Confirmed -- [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions https://bugs.launchpad.net/bugs/235602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
Possibly a bit more detailed information for the bug-solver: I use a column, let's say J, with conditional formatting based on the values in column D. When I insert a new column left from D (or more than one column), the references are updated. When I insert a column between D and J, the references are NOT updated. This should help to isolate the problem. Good luck developers. -- [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions https://bugs.launchpad.net/bugs/235602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
pboosman, what type of conditional formatting reference did you use in your example? If you by updated mean updated correctly that behaviour only applies as far as I can see to relative addressing of columns, i.e columns not prefixed by $. For absolute addressed columns I get the opposite result. -- [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions https://bugs.launchpad.net/bugs/235602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 235602] Re: [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions
** Summary changed: - OO Calc Conditional Formatting - Incorrect cell references after line or column insertions + [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions -- [upstream] [hardy] OO Calc Conditional Formatting - Incorrect cell references after line or column insertions https://bugs.launchpad.net/bugs/235602 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs