Issue 28589

to continue...
4. Apply conditional formatting to C2 with formala is C2>Testvalue ... style 
will be applied
5. Change value of cell B2 to 6 .... style of C2 is unchanged *ERROR*
6. Switch to another window and back (in windows) style is applied
OR 6. Scroll Cell C2 off visible page and back style is applied

hi, thanks for reporting this!

>> 5. Change value of cell B2 to 6 .... style of C2 is unchanged *ERROR*

hmm, before changing the value in B2 the value in C2 was printed bold, after
chaning B2 to 6 it is not printed bold any longer. However the cell is still
larger than before (I am using "Heading" as the result of the conditional format
statement.) Is this behaviour the "ERROR" you are talking about or do you mean
something else?

I am using the 1.1.2RC build.

Thanks for the attention to this, Max.
The comment *ERROR* was just to indicate where I thought the action was not 
what I expected, while including all the steps necessary to demonstrate the 
defect. My version is 1.1.1RC3 which I believe is unchanged at 1.1.1 (according 
to the MD5SUMS)

My guess is that the modify listener is not set up for the range name.
I suggest that any fix takes into account the fact that the range_name itself 
may be pointed at another cell and the condition should be re-evaluated then. 
That seems harder to resolve as the modify listeners are attached to the cell 
range and not the range name. That is, ScCellObj has  addModifyListener but 
ScNamedRangeObj does not.
To continue with the  problem/fix demonstration ...
step 7. use insert name define to change cell range for testvalue to C1 (which 
contains nothing) and the cell format *should* change back to default formatting

Hi,

I'm sorry to tell you but I could not reproduce your problem. I've checked both
with OOo1.1.1 and OOo1.1.2rc on Windows and Linux.

As you should know, without re-produceable Issues we can't fix something. So I
have no choice as to close this Issue as worksforme. Feel free to re-open if you
could reproduce this problem at least on two different machines.

Thanks for your understanding.

Farnk

closed wfm

fst,
Will you please re-open this issue. I have personally identified 2 further 
separate configurations with the issue (clean builds at my local computer store)
OOo V 1.1.0 Windows XP Pro SP1
OOo V 1.1.0 Windows XP 64bit build 3790 SRV03
A fellow user on OOo Forum confirms the existance (for them) at windows XP SP1 
see http://www.oooforum.org/forum/viewtopic.php?p=32987#32987
I still consistently get the effect at OOo V1.1.1 rc3 and Windows 2000 Pro

Hi,

Frank is out of office for some days. I'm reopening it without any further look.

Peter

reassign it to Frank just to force a mail in his intray

A fellow user on OOo Forum confirms the existance (for them) at OOo V1.1.0 and 
Linux debian build. A fair sprinkling so far but certainly not pointing at a 
particular release of OOo, operating sys, or combination.

Created attachment 15286 [details]
Minimal example of issue with comments

Hi Niklas,

if possible a fix for OOo2.0 would be fine.

It's a repaint problem, CTRL+SHIFT+R will show the correct styles.

Frank

accepting

Seems fixed for original first six steps, but not for step 7 as described by 
dfrench at
http://qa.openoffice.org/issues/show_bug.cgi?id=28589#desc5

I can confirm that original issue (step 5) is fixed (thanks team!) but that
moving the definition of the named range does not trigger the necessary  repaint.
Now at version 3.0.0(Beta) Windows 2000 professional

Perhaps "fixed" was optimistic. There seems to be some eratic or timing issue
around this as well. 
I conducted a test using a 2x2 NamedRange  ... formulas that compared an offset
in this range with a value worked ok (immediately switching styles as expected)
BUT if the value was replaced by a cell reference, a repaint of screen was
needed (forced) to reveal the style change. 
Exercising this test a bit resulted in the problem going away!!! But recreated
simply by copying the conditional formatting cells elsewhere.
I notice that we are coming up for the 4th anniversary of this issue, is there a
party arranged?

Created attachment 52840 [details]
Updated testcase for conditional formatting -named ranges

Created attachment 72190

Reset assigne to the default "issues@openoffice.apache.org".