Issue 116456 - ConditionalFormat refer defect when draging cells
Summary: ConditionalFormat refer defect when draging cells
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m18
Hardware: HP (PA-RISC) Windows 7
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-01-14 00:34 UTC by verhallen
Modified: 2013-05-16 11:42 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

spreadsheet with conditionalformat refer bug when draging (6.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-14 00:41 UTC, verhallen
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description verhallen 2011-01-14 00:34:25 UTC
open new spreadsheet
put in cell A1 a value, [100]
press CTRL F3
make a name for cell A1, [ape]
select an other cell (B1)
go to conditional format dialogue box true menu ....format? (in Dutch it is menu
first list-box select formula
second box (condition box) write [ape = 100]
ad new format that makes the background red, and give this format a name [red]
choose this name in the list box

When you change the value of cell A1 from 100 to something else and back again
cell B1 will turn on and of with the colour red. This is good and big fun.

When you move cell A1 with CTRL x and CTRL V everything looks al right but will
not work until you make a little change in the conditional format dialogue box.
for instance get rid of a space [ape= 100] . now it will work again. If you use
a other way to move cell A1 you get the same bad result.

This is my first input in OOo I hope it is clear 
regards Verhallen
Comment 1 verhallen 2011-01-14 00:41:45 UTC
Created attachment 75558 [details]
spreadsheet with conditionalformat refer bug when draging
Comment 2 Oliver Brinzing 2011-01-14 08:06:54 UTC
Comment 3 Edwin Sharp 2013-05-16 11:42:09 UTC
As given in description.
Rev. 1479897 Win 7