Issue 109243

Summary: STYLE function in conditional formatting interferes with cell notes
Product: Calc Reporter: Joe Smith <jes>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: acgooglmail, issues, jbf.faure
Version: OOo 3.2   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sample document showing problem none

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. ***