Apache OpenOffice (AOO) Bugzilla – Issue 109243
STYLE function in conditional formatting interferes with cell notes
Last modified: 2019-04-25 14:10:27 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.
Created attachment 67814 [details] Sample document showing problem
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
The fact it works when autocalculate is desactivated maybe linked to issue 21357. regards. JBF
*** Issue 128100 has been marked as a duplicate of this issue. ***