Public bug reported:
Binary package hint: openoffice.org
Conditional Formats have no effect in cells which are referenced as part
of the condition formula, if the reference is via a range. The problem
occurs only if the range is coded without an explicit sheet name (i.e.
implicitly referring to the current sheet).
Please see the attached small demo file.
A guess is that evaluating a ref to a range returns an error when the
referencing cell is within the range, rather than returning the value of
that cell. An error would be appropriate when evaluating a regular
formula in a cell, because such a self-reference implies infinite
recursion. However for Conditional Formats, the formula is not in the
'referencing' cell (or any cell), and so using the cell value should be
allowed. OTOH I have no idea why specifying a sheet name explicitly in
the range would avoid this.
Observed in both Openoffice.org 3.2 and LibreOffice 3.1.3
Steps to reproduce:
1. Create a cell style with a distinctive background (create a sample cell,
select it, Format->Styles & Formatting, and click NewFromSelection)
2. Select several (or all) cells in a row, including column B
3. Format->Conditional Formatting
4. Select "Formula Is' in the drop-down, and set the formula to $B$1:$B$1000 <
0 and specify the name of the new style
5. Enter a negative number in column B of the row.
Results: cells in columns other than B change to the distinctive color
ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org-calc 1:3.2.1-7ubuntu1.1
ProcVersionSignature: Ubuntu 2.6.35-25.44-generic 2.6.35.10
Uname: Linux 2.6.35-25-generic x86_64
Architecture: amd64
Date: Sat Mar 5 11:18:00 2011
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release Candidate amd64
(20100928)
ProcEnviron:
PATH=(custom, user)
LANG=en_US.utf8
SHELL=/bin/bash
SourcePackage: openoffice.org
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug maverick
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/729890
Title:
Certain range references do not work in Conditional Format formulas
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
