[Bug 159167] Conditional formatting of cells based on rules for checking values greater than or less than

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=159167

Alexander Nolting <a.nolting at almano.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #15 from Alexander Nolting <a.nolting at almano.de> ---
(In reply to Heiko Tietze from comment #14)
> (In reply to Alexander Nolting from comment #11)
> > But the current design and overall behavior of LO allows selecting a range
> > and add a rule for it but does not process this correctly.
> What exactly is wrong or difficult with the solution in comment 8?

Hello Heiko

there is nothing wrong. But in my opinion not the same way as the function
behaves in Excel, to which many of the commenters refering to - for any reason,
so let us assume this is the goal of LO to mimic as exact as possible the
example.

Second, as this is working and this cell reference is also a range, this raises
the question why is my example, for which I started this bug report, not
working?

As the documentation lacks detailed information what values are accepted - and
with this knowledge one can see what kind of entry is allowed and what is not,
its impossible for the reporter to decide what error pattern is present here?
Is it a incomplete implementation of a function approved by design board or is
it not implemented as designed or any other imaginable issue.

As every one seem to push me to accept any of the commented workarounds (which
is by the way an admission that there was wrongdoing here) it may helpful to
explain the bug reporter and to close this report or accept that there is a bug
and  give it a priority, which will allow the organization to work on it in due
course.

Best Alex

-- 
You are receiving this mail because:
You are on the CC list for the bug.