Issue 109243 - STYLE function in conditional formatting interferes with cell notes
Summary: STYLE function in conditional formatting interferes with cell notes
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 128100 (view as issue list)
Depends on:
Reported: 2010-02-13 21:31 UTC by Joe Smith
Modified: 2019-04-25 14:10 UTC (History)
3 users (show)

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

Sample document showing problem (14.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-02-13 21:32 UTC, Joe Smith
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Joe Smith 2010-02-13 21:31:29 UTC
The STYLE function can be used to apply a cell style through a conditional
formatting formula.

However, when STYLE is used in this way, it seems to prevent cell notes from
popping up as usual when the mouse cursor hovers over the note cell.

Although this use of STYLE and conditional formatting is somewhat unorthodox, it
is very useful, and it should not interfere with the notes feature.

See the attached document for a sample.

I see the same behavior with both 3.1.1 and 3.2rc5, on both Windows and Linux.
Comment 1 Joe Smith 2010-02-13 21:32:27 UTC
Created attachment 67814 [details]
Sample document showing problem
Comment 2 jbf.faure 2010-05-01 09:32:23 UTC
I reproduce this behaviour with OOo 3.2.0 and OOO320m16 under Linux (Ubuntu 8.04)
If AutoCalculate is desactivated notes work as expected but it not a workaround.

Regards. JBF
Comment 3 jbf.faure 2010-05-01 09:37:42 UTC
The fact it works when autocalculate is desactivated maybe linked to issue 21357.

regards. JBF
Comment 4 oooforum (fr) 2019-04-25 14:10:27 UTC
*** Issue 128100 has been marked as a duplicate of this issue. ***