** 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
