Issue 77740 - Conditional formatting is tempremental
Summary: Conditional formatting is tempremental
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.1
Hardware: Mac All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-24 04:24 UTC by cfleming2691
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Attachments
Sample document made from reporter instructions. (7.15 KB, application/vnd.sun.xml.calc)
2007-07-11 16:19 UTC, Joe Smith 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description cfleming2691 2007-05-24 04:24:37 UTC 
Set up a conditional formatting style for a cell with a red background.

Enter the values 3 in B5, 10 in B7, and 11 in D7.

Conditionally
format cell D7 to turn red if it's value is less than
SUM(OFFSET(D4;0;1;1;$B5))+$B7

Enter the values 1 in E4 and 1 in F4:
Cell D7 should turn red but it does not.

Move the active cell to the
right until cell D7 disappears from view and then move the active cell
back to D7. Cell D7 is now red.

Delete the value 1 from cell F4. The
red background from cell D7 should disappear but it does not.

Move
the active cell to the right until cell D7 disappears from view and then
move the active cell back to D7. The red background from cell D7 now
disappears.
Comment 1 Joe Smith 2007-07-11 16:18:33 UTC 
Confirmed in 2.2.1 on Fedora Linux 7, as described above.
Comment 2 Joe Smith 2007-07-11 16:19:54 UTC 
Created attachment 46695 [details]
Sample document made from reporter instructions.
Comment 3 pracslipkerm 2007-07-15 11:14:16 UTC 
Confirmed on OOo 2.2.1 Win XP
Formating is also updated if cell D7 is clicked on or highlighted, or if OOo
window is minimised and maximised.
Pracslipkerm :-)
Comment 4 frank 2007-07-16 12:54:34 UTC 
Hi Niklas,

maybe it's something with the OFFSET as the cell with the conditional format
doesn't get the information about a changed value. Maybe it's a double.

Frank
Comment 5 cfleming2691 2007-09-20 04:22:25 UTC 
Its been 4 months since I reported this bug: Is anybody working on correcting it?
Comment 6 cfleming2691 2008-04-03 01:06:43 UTC 
Is anybody looking at fixing this bug??
Comment 7 cfleming2691 2008-07-02 08:01:22 UTC 
When will this be fixed: Its nearly 12 months since I reported it.
Comment 8 frank 2008-07-02 08:48:23 UTC 
Hi cfleming,

messing around with the Issue does not make it faster to solve it. Re-assigning
it back from the developer to the general spreadsheet owner is counter
productive. I've corrected it. You may also try the newest development version.

Frank
Comment 9 Marcus 2017-05-20 11:13:30 UTC 
Reset assigne to the default "issues@openoffice.apache.org".