Public bug reported:
Binary package hint: openoffice.org
If a symbolic name is defined for a column, then that name can be used
in formulas and Conditional Format expressions instead of the column
number.
For example:
Click in col B header to select column B
Insert->Names->Define
Enter a name, say "NamedCol"
Now, a formula in D5 which was "B5+1" can instead be "NamedCol+1".
Similarly, NamedCol can be referenced in formulas entered at
Format->ConditionalFormatting.
THE BUG: If a conditional format accesses a column in the above manner,
it works only in columns OTHER THAN THAT COLUMN. In other words, if a
conditional format for a cell in column B references the symbol NamedCol
(using the above example), then the conditional format expression is
never true and the format is never applied.
This is a nuisance because you can't use the same formula for many
columns if the formula references one of those columns via a Name.
Attached is an ODS spreadsheet demonstrating the problem. I will also
attach a screen-shot of how it looks to me.
ProblemType: Bug
Architecture: amd64
Date: Wed Nov 4 18:10:43 2009
DistroRelease: Ubuntu 9.10
ExecutablePath: /usr/lib/openoffice/program/soffice.bin
Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified:
var/lib/openoffice/basis3.1/program/services.rdb]
ProcEnviron:
PATH=(custom, user)
LANG=en_US.UTF-8
SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-14.48-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-14-generic x86_64
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug
--
Named reference to current column does not work in Conditional Formats
https://bugs.launchpad.net/bugs/474992
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
